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
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
ASSIGNMENT_ACCOUNT	Account code. Must exist in corresponding finance system.	VARCHAR2(63)	NBRJLBD	NBRJLBD_ACCT_CODE
ASSIGNMENT_ACTIVITY	Activity code.	VARCHAR2(63)	NBRJLBD	NBRJLBD_ACTV_CODE
ASSIGNMENT_FUND	Fund code. Requires corresponding finance system to be installed.	VARCHAR2(63)	NBRJLBD	NBRJLBD_FUND_CODE
ASSIGNMENT_LOCATION	Location code. Requires corresponding finance system to be installed.	VARCHAR2(63)	NBRJLBD	NBRJLBD_LOCN_CODE
ASSIGNMENT_ORGANIZATION	Organization code. Requires corresponding finance system to be installed.	VARCHAR2(63)	NBRJLBD	NBRJLBD_ORGN_CODE
ASSIGNMENT_PROGRAM	Program code. Requires corresponding finance system to be installed.	VARCHAR2(63)	NBRJLBD	NBRJLBD_PROG_CODE
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
COST_TYPE	Cost type within the corresponding finance cost accounting module.	VARCHAR2(2)	NBRJLBD	NBRJLBD_CTYP_CODE
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
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(63)	NBRJLBD	NBRJLBD_ACCT_CODE_FRINGE
FRINGE_ACTIVITY	Fringe Activity code.	VARCHAR2(63)	NBRJLBD	NBRJLBD_ACTV_CODE_FRINGE
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(63)	NBRJLBD	NBRJLBD_FUND_CODE_FRINGE
FRINGE_LOCATION	Fringe location code. Requires corresponding finance system to be installed.	VARCHAR2(63)	NBRJLBD	NBRJLBD_LOCN_CODE_FRINGE
FRINGE_ORGANIZATION	Fringe organization code. Requires corresponding finance system to be installed.	VARCHAR2(63)	NBRJLBD	NBRJLBD_ORGN_CODE_FRINGE
FRINGE_PROGRAM	Fringe program code. Requires corresponding finance system to be installed.	VARCHAR2(63)	NBRJLBD	NBRJLBD_PROG_CODE_FRINGE
ID	Person's or organization's current identification number.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
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(63)	NBRJLBD	NBRJLBD_SUFF
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
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(63)	NBRJLBD	NBRJLBD_POSN
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
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 posted to the finance system.	NUMBER	NBRJLBD	NBRJLBD_SALARY_ENC_TO_POST

Ver: 8.1