Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Human Resources Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AN_PERSONNEL_ACTION_LABOR_DIST

Description Source composite view contains labor distribution changes associated with personnel actions (PAF) transaction number for the employee over their time. Includes personnel actions with current status for applied and pending transactions.
Key & Frequency One row per person per PAF transaction number per approval type per position per suffix

Target Column Business Definition Database Data Type Source Name Source Column
ACCOUNT Account code that this APPROVAL TRANSACTION was charged. VARCHAR2(6)

NORTBLD

NORTLBD_ACCT_CODE

ACCOUNT_DESC Position account description. VARCHAR2(35)

FTVACCT

FTVACCT_TITLE

ACCOUNT_INDEX Account index code that was used to default the account distribution this APPROVAL TRANSACTION was charged. VARCHAR2(6)

NORTBLD

NORTLBD_ACCI_CODE

ACCOUNT_INDEX_DESC An index code that is used to default the account distribution to which this position should be charged. VARCHAR2(35)

FTVACCI

FTVACCI_TITLE

ACTIVITY Activity code where this APPROVAL TRANSACTION is charged. VARCHAR2(6)

NORTBLD

NORTLBD_ACTV_CODE

ACTIVITY_DESC Position activity description. VARCHAR2(35)

FTVACTV

FTVACTV_TITLE

CHART_OF_ACCOUNTS Chart of accounts code where this APPROVAL TRANSACTION is charged. VARCHAR2(1)

NORTBLD

NORTLBD_COAS_CODE

CHART_OF_ACCOUNTS_DESC Chart of accounts code description or title. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

COST_TYPE Cost type where this APPROVAL TRANSACTION is charged when cost accounting is used. VARCHAR2(2)

NORTBLD

NORTLBD_CTYP_CODE

COST_TYPE_LONG_DESC   VARCHAR2(30)    
COST_TYPE_SHORT_DESC   VARCHAR2(30)    
CURRENT_DATE   DATE    
DOMAIN_VALUE Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA

ENCUMBRANCE_CALCULATE_END_DATE End date used to calculate future fiscal year encumbrances for a labor distribution. DATE

NORTBLD

NORTLBD_ENC_OVERRIDE_END_DATE

EXTERNAL_ACCOUNT Free form account number to be used to interface to an external finance system. VARCHAR2(60)

NORTBLD

NORTLBD_ACCT_CODE_EXTERNAL

FUND Fund code where this APPROVAL TRANSACTION is charged. VARCHAR2(6)

NORTBLD

NORTLBD_FUND_CODE

FUND_DESC Position fund description. VARCHAR2(35)

FTVFUND

FTVFUND_TITLE

JOB_SUFFIX Suffix allows users to define a job with more precision. For example, a user could denote daytime faculty with one suffix and evening school with another. VARCHAR2(2)

NORTBLD

NORTBLD_SUFF

LOCATION Location code where this APPROVAL TRANSACTION is charged. VARCHAR2(6)

NORTBLD

NORTLBD_LOCN_CODE

LOCATION_DESC Position location description. VARCHAR2(35)

FTVLOCN

FTVLOCN_TITLE

MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

ORGANIZATION Organization code where this APPROVAL TRANSACTION is charged. VARCHAR2(6)

NORTBLD

NORTLBD_ORGN_CODE

ORGANIZATION_CODE   VARCHAR2(6)    
ORGANIZATION_DESC Position organization description. VARCHAR2(35)

FTVORGN

FTVORGN_TITLE

PAF_APPLY_STATUS Status of the personnel action sequence number. Values may be A = Applied, P = Pending or C = Canceled. VARCHAR2(1)

NORTBLD

NORTLBD_APPLY_STATUS_IND

PAF_APPROVAL_TYPE Approval type defaulted for the sequence number per approval category rules. Rule include one record for each basic type of action defined for the approval category, such as establishing a new job assignment or terminating an existing job assignment. VARCHAR2(6)

NORTBLD

NORTBLD_APTY_CODE

PAF_APPROVAL_TYPE_DESC Approval type description. VARCHAR2(30)

NTVAPTY

NTVAPTY_DESC

PAF_EFFECTIVE_DATE Date the personnel action record became effective. DATE

NORTBLD

NORTLBD_EFFECTIVE_DATE

PAF_LABOR_DIST_ACTIVITY_DATE Date of last activity on this record. DATE

NORTBLD

NORTLBD_ACTIVITY_DATE

PAF_TRANSACTION_NUMBER System-generated number that is created when you enter information pertaining to an Electronic Personnel Action. NUMBER

NORTBLD

NORTLBD_TRANSACTION_NO

PAF_TRANSACTION_TYPE Identifies if the transaction number includes transactions that are General, Earnings and or Labor Distributions. CHAR(4)

CALCULATION

TBLD

PERCENT Percent of pay to be applied to this labor distribution. Defines the percentage of the contract value attributed to this accounting distribution. NUMBER

NORTBLD

NORTLBD_PERCENT

PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER

NOBTRAN

NOBTRAN_PIDM

POSITION Position number attached to the personnel action. VARCHAR2(6)

NORTBLD

NORTLBD_POSN

PROGRAM Program code where this APPROVAL TRANSACTION is charged. VARCHAR2(6)

NORTBLD

NORTLBD_PROG_CODE

PROGRAM_DESC Position program description. VARCHAR2(35)

FTVPROG

FTVPROG_TITLE

PROJECT Project code where this APPROVAL TRANSACTION is charged when cost accounting is used. VARCHAR2(8)

NORTBLD

NORTLBD_PROJ_CODE

PROJECT_DESC Position project description. VARCHAR2(30)

FTVPROJ

FTVPROJ_DESC

ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA



Ver: