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

Banner Operational Data Store
Composite View Target: AN_LABOR_COST_DISTRIBUTION

Description Source composite view contains the accounting details for the labor distribution associated with an employee in a position or assignment.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
ACCOUNT_INDEX Account Index is used as a short cut method to the data entry of an accounting distribution. It may contain any or all of the account distribution columns. VARCHAR2(6)

NBRJLBD

NBRJLBD_ACCI_CODE

NO

NO
ACCOUNT_INDEX_DESC   VARCHAR2(35)       NO
ASSIGNMENT_ACCOUNT Account code. Must exist in corresponding finance system. VARCHAR2(6)

NBRJLBD

NBRJLBD_ACCT_CODE

NO

NO
ASSIGNMENT_ACCOUNT_DESC   VARCHAR2(35)       NO
ASSIGNMENT_ACTIVITY Activity code. VARCHAR2(6)

NBRJLBD

NBRJLBD_ACTV_CODE

NO

NO
ASSIGNMENT_ACTIVITY_DESC   VARCHAR2(35)       NO
ASSIGNMENT_FUND Fund code. Requires corresponding finance system to be installed. VARCHAR2(6)

NBRJLBD

NBRJLBD_FUND_CODE

NO

NO
ASSIGNMENT_FUND_DESC   VARCHAR2(35)       NO
ASSIGNMENT_LOCATION Location code. Requires corresponding finance system to be installed. VARCHAR2(6)

NBRJLBD

NBRJLBD_LOCN_CODE

NO

NO
ASSIGNMENT_LOCATION_DESC   VARCHAR2(35)       NO
ASSIGNMENT_ORGANIZATION Organization code. Requires corresponding finance system to be installed. VARCHAR2(6)

NBRJLBD

NBRJLBD_ORGN_CODE

NO

NO
ASSIGNMENT_ORGANIZATION_DESC   VARCHAR2(35)       NO
ASSIGNMENT_PROGRAM Program code. Requires corresponding finance system to be installed. VARCHAR2(6)

NBRJLBD

NBRJLBD_PROG_CODE

NO

NO
ASSIGNMENT_PROGRAM_DESC   VARCHAR2(35)       NO
ASSIGNMENT_PROJECT_DESC   VARCHAR2(30)       NO
CHANGE_INDICATOR Specifies if the record is active or to be deleted. VARCHAR2(1)

NBRJLBD

NBRJLBD_CHANGE_IND

NO

NO
CHART_OF_ACCOUNTS Identifies the chart from other charts in a multi-chart environment. VARCHAR2(1)

NBRJLBD

NBRJLBD_COAS_CODE

NO

NO
CHART_OF_ACCOUNTS_DESC   VARCHAR2(35)       NO
COST_TYPE Cost type within the corresponding finance cost accounting module. VARCHAR2(2)

NBRJLBD

NBRJLBD_CTYP_CODE

NO

NO
COST_TYPE_LONG_DESC   VARCHAR2(30)       NO
COST_TYPE_SHORT_DESC   VARCHAR2(30)       NO
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

NO

NO
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

NO

NO
EFFECTIVE_DATE Date that the job labor distribution record becomes effective in the payroll system. DATE

NBRJLBD

NBRJLBD_EFFECTIVE_DATE

NO

NO
EFFECTIVE_END_DATE End effective date. DATE

FUNCTION

NOKODSF.F_GET_END_NBRJLBD_DATE

NO

NO
EFFECTIVE_START_DATE Start effective date. DATE

NBRJLBD

NBRJLBD_EFFECTIVE_DATE

NO

NO
ENCUMBRANCE_NUMBER Unique encumbrance code of a document. VARCHAR2(8)

NBRJLBD

NBRJLBD_ENCD_NUM

NO

NO
ENCUMBRANCE_SEQUENCE Encumbrance sequence number. NUMBER

NBRJLBD

NBRJLBD_ENCD_SEQ_NUM

NO

NO
ENCUMB_LAST_CALCULATION_DATE   DATE       NO
ENCUMB_LAST_RECAST_DATE   DATE       NO
ENCUMB_OVERRIDE_END_DATE   DATE       NO
EXTERNAL_ACCOUNT System account distribution code to which this position should be charged. VARCHAR2(60)

NBRJLBD

NBRJLBD_ACCT_CODE_EXTERNAL

NO

NO
FRINGE_ACCOUNT Fringe Account. VARCHAR2(6)

NBRJLBD

NBRJLBD_ACCT_CODE_FRINGE

NO

NO
FRINGE_ACCOUNT_DESC   VARCHAR2(35)       NO
FRINGE_ACTIVITY Fringe Activity code. VARCHAR2(6)

NBRJLBD

NBRJLBD_ACTV_CODE_FRINGE

NO

NO
FRINGE_ACTIVITY_DESC   VARCHAR2(35)       NO
FRINGE_ENCUMBRANCE Amount of fringe benefits encumbered to this labor distribution for the active fiscal year. NUMBER

NBRJLBD

NBRJLBD_FRINGE_ENCUMBRANCE

NO

NO
FRINGE_ENCUMBRANCE_RESID_AMT Fringe encumbrance residual amount assigned to this externally funded labor distribution. NUMBER

NBRJLBD

NBRJLBD_FRINGE_RESIDUAL

NO

NO
FRINGE_ENCUMBRANCE_TO_POST Amount of encumbrance that is posted to the finance system. NUMBER

NBRJLBD

NBRJLBD_FRINGE_ENC_TO_POST

NO

NO
FRINGE_ENCUMB_RESID_TO_POST Amount of fringe encumbrance residual to post to this externally funded labor distribution. NUMBER

NBRJLBD

NBRJLBD_FRINGE_RES_TO_POST

NO

NO
FRINGE_FUND Fringe fund code. Requires corresponding finance system to be installed. VARCHAR2(6)

NBRJLBD

NBRJLBD_FUND_CODE_FRINGE

NO

NO
FRINGE_FUND_DESC   VARCHAR2(35)       NO
FRINGE_LOCATION Fringe location code. Requires corresponding finance system to be installed. VARCHAR2(6)

NBRJLBD

NBRJLBD_LOCN_CODE_FRINGE

NO

NO
FRINGE_LOCATION_DESC   VARCHAR2(35)       NO
FRINGE_ORGANIZATION Fringe organization code. Requires corresponding finance system to be installed. VARCHAR2(6)

NBRJLBD

NBRJLBD_ORGN_CODE_FRINGE

NO

NO
FRINGE_ORGANIZATION_DESC   VARCHAR2(35)       NO
FRINGE_PROGRAM Fringe program code. Requires corresponding finance system to be installed. VARCHAR2(6)

NBRJLBD

NBRJLBD_PROG_CODE_FRINGE

NO

NO
FRINGE_PROGRAM_DESC   VARCHAR2(35)       NO
FUTURE_FRINGE_ENCUMB   NUMBER       NO
FUTURE_FRINGE_ENCUMB_TO_POST   NUMBER       NO
FUTURE_FRINGE_RESIDUAL   NUMBER       NO
FUTURE_FRINGE_RESIDUAL_TO_POST   NUMBER       NO
FUTURE_SALARY_ENCUMB   NUMBER       NO
FUTURE_SALARY_ENCUMB_TO_POST   NUMBER       NO
JOB_SUFFIX Suffix allows users to define an Employee_Position with more precision. For example, a user could denote daytime faculty with one suffix and evening school with another. VARCHAR2(2)

NBRJLBD

NBRJLBD_SUFF

NO

NO
LABOR_COST_DIST_ACTIVITY_DATE   DATE       NO
LABOR_COST_DIST_DATA_ORIGIN   VARCHAR2(30)       NO
LABOR_COST_DIST_USER_ID   VARCHAR2(30)       NO
MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

NO

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

NA

NA

NO

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

NBRJLBD

NBRJLBD_PERCENT

NO

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

NBRJLBD

NBRJLBD_PIDM

NO

NO
POSITION Position number for this Employee_Position. VARCHAR2(6)

NBRJLBD

NBRJLBD_POSN

NO

NO
PROJECT Work order code used within cost accounting module. VARCHAR2(8)

NBRJLBD

NBRJLBD_PROJ_CODE

NO

NO
SALARY_ENCUMBRANCE Amount encumbered to this labor distribution for the active fiscal year. NUMBER

NBRJLBD

NBRJLBD_SALARY_ENCUMBRANCE

NO

NO
SALARY_ENCUMBRANCE_TO_POST Amount of encumbrance that is posted to the finance system. NUMBER

NBRJLBD

NBRJLBD_SALARY_ENC_TO_POST

NO

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

NA

NA

NO

NO


Ver: