Target Column	Business Definition	Database Data Type	Source Name	Source Column
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
ACCOUNT_INDEX_DESC		VARCHAR2(35)
ASSIGNMENT_ACCOUNT	Account code. Must exist in corresponding finance system.	VARCHAR2(6)	NBRJLBD	NBRJLBD_ACCT_CODE
ASSIGNMENT_ACCOUNT_DESC		VARCHAR2(35)
ASSIGNMENT_ACTIVITY	Activity code.	VARCHAR2(6)	NBRJLBD	NBRJLBD_ACTV_CODE
ASSIGNMENT_ACTIVITY_DESC		VARCHAR2(35)
ASSIGNMENT_FUND	Fund code. Requires corresponding finance system to be installed.	VARCHAR2(6)	NBRJLBD	NBRJLBD_FUND_CODE
ASSIGNMENT_FUND_DESC		VARCHAR2(35)
ASSIGNMENT_LOCATION	Location code. Requires corresponding finance system to be installed.	VARCHAR2(6)	NBRJLBD	NBRJLBD_LOCN_CODE
ASSIGNMENT_LOCATION_DESC		VARCHAR2(35)
ASSIGNMENT_ORGANIZATION	Organization code. Requires corresponding finance system to be installed.	VARCHAR2(6)	NBRJLBD	NBRJLBD_ORGN_CODE
ASSIGNMENT_ORGANIZATION_DESC		VARCHAR2(35)
ASSIGNMENT_PROGRAM	Program code. Requires corresponding finance system to be installed.	VARCHAR2(6)	NBRJLBD	NBRJLBD_PROG_CODE
ASSIGNMENT_PROGRAM_DESC		VARCHAR2(35)
ASSIGNMENT_PROJECT_DESC		VARCHAR2(30)
CHANGE_INDICATOR	Specifies if the record is active or to be deleted.	VARCHAR2(1)	NBRJLBD	NBRJLBD_CHANGE_IND
CHART_OF_ACCOUNTS	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(1)	NBRJLBD	NBRJLBD_COAS_CODE
CHART_OF_ACCOUNTS_DESC		VARCHAR2(35)
COST_TYPE	Cost type within the corresponding finance cost accounting module.	VARCHAR2(2)	NBRJLBD	NBRJLBD_CTYP_CODE
COST_TYPE_LONG_DESC		VARCHAR2(30)
COST_TYPE_SHORT_DESC		VARCHAR2(30)
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA
EFFECTIVE_DATE	Date that the job labor distribution record becomes effective in the payroll system.	DATE	NBRJLBD	NBRJLBD_EFFECTIVE_DATE
EFFECTIVE_END_DATE	End effective date.	DATE	FUNCTION	NOKODSF.F_GET_END_NBRJLBD_DATE
EFFECTIVE_START_DATE	Start effective date.	DATE	NBRJLBD	NBRJLBD_EFFECTIVE_DATE
ENCUMBRANCE_NUMBER	Unique encumbrance code of a document.	VARCHAR2(8)	NBRJLBD	NBRJLBD_ENCD_NUM
ENCUMBRANCE_SEQUENCE	Encumbrance sequence number.	NUMBER	NBRJLBD	NBRJLBD_ENCD_SEQ_NUM
ENCUMB_LAST_CALCULATION_DATE		DATE
ENCUMB_LAST_RECAST_DATE		DATE
ENCUMB_OVERRIDE_END_DATE		DATE
EXTERNAL_ACCOUNT	System account distribution code to which this position should be charged.	VARCHAR2(60)	NBRJLBD	NBRJLBD_ACCT_CODE_EXTERNAL
FRINGE_ACCOUNT	Fringe Account.	VARCHAR2(6)	NBRJLBD	NBRJLBD_ACCT_CODE_FRINGE
FRINGE_ACCOUNT_DESC		VARCHAR2(35)
FRINGE_ACTIVITY	Fringe Activity code.	VARCHAR2(6)	NBRJLBD	NBRJLBD_ACTV_CODE_FRINGE
FRINGE_ACTIVITY_DESC		VARCHAR2(35)
FRINGE_ENCUMBRANCE	Amount of fringe benefits encumbered to this labor distribution for the active fiscal year.	NUMBER	NBRJLBD	NBRJLBD_FRINGE_ENCUMBRANCE
FRINGE_ENCUMBRANCE_RESID_AMT	Fringe encumbrance residual amount assigned to this externally funded labor distribution.	NUMBER	NBRJLBD	NBRJLBD_FRINGE_RESIDUAL
FRINGE_ENCUMBRANCE_TO_POST	Amount of encumbrance that is posted to the finance system.	NUMBER	NBRJLBD	NBRJLBD_FRINGE_ENC_TO_POST
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
FRINGE_FUND	Fringe fund code. Requires corresponding finance system to be installed.	VARCHAR2(6)	NBRJLBD	NBRJLBD_FUND_CODE_FRINGE
FRINGE_FUND_DESC		VARCHAR2(35)
FRINGE_LOCATION	Fringe location code. Requires corresponding finance system to be installed.	VARCHAR2(6)	NBRJLBD	NBRJLBD_LOCN_CODE_FRINGE
FRINGE_LOCATION_DESC		VARCHAR2(35)
FRINGE_ORGANIZATION	Fringe organization code. Requires corresponding finance system to be installed.	VARCHAR2(6)	NBRJLBD	NBRJLBD_ORGN_CODE_FRINGE
FRINGE_ORGANIZATION_DESC		VARCHAR2(35)
FRINGE_PROGRAM	Fringe program code. Requires corresponding finance system to be installed.	VARCHAR2(6)	NBRJLBD	NBRJLBD_PROG_CODE_FRINGE
FRINGE_PROGRAM_DESC		VARCHAR2(35)
FUTURE_FRINGE_ENCUMB		NUMBER
FUTURE_FRINGE_ENCUMB_TO_POST		NUMBER
FUTURE_FRINGE_RESIDUAL		NUMBER
FUTURE_FRINGE_RESIDUAL_TO_POST		NUMBER
FUTURE_SALARY_ENCUMB		NUMBER
FUTURE_SALARY_ENCUMB_TO_POST		NUMBER
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
LABOR_COST_DIST_ACTIVITY_DATE		DATE
LABOR_COST_DIST_DATA_ORIGIN		VARCHAR2(30)
LABOR_COST_DIST_USER_ID		VARCHAR2(30)
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
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
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	NBRJLBD	NBRJLBD_PIDM
POSITION	Position number for this Employee_Position.	VARCHAR2(6)	NBRJLBD	NBRJLBD_POSN
PROJECT	Work order code used within cost accounting module.	VARCHAR2(8)	NBRJLBD	NBRJLBD_PROJ_CODE
SALARY_ENCUMBRANCE	Amount encumbered to this labor distribution for the active fiscal year.	NUMBER	NBRJLBD	NBRJLBD_SALARY_ENCUMBRANCE
SALARY_ENCUMBRANCE_TO_POST	Amount of encumbrance that is posted to the finance system.	NUMBER	NBRJLBD	NBRJLBD_SALARY_ENC_TO_POST
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA

Ver: