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	An index code that is used to default the account distribution to which this position should be charged.	VARCHAR2(255)	FTVACCI	FTVACCI_TITLE
ADMINISTRATIVE_GROUP	Administrative-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_ACCOUNT_DESC	Assignment account description.	VARCHAR2(255)	FTVACCT	FTVACCT_TITLE
ASSIGNMENT_ACTIVITY	Activity code.	VARCHAR2(63)	NBRJLBD	NBRJLBD_ACTV_CODE
ASSIGNMENT_ACTIVITY_DESC	Assignment activity description.	VARCHAR2(255)	FTVACTV	FTVACTV_TITLE
ASSIGNMENT_FUND	Fund code. Requires corresponding finance system to be installed.	VARCHAR2(63)	NBRJLBD	NBRJLBD_FUND_CODE
ASSIGNMENT_FUND_DESC	Assignment fund description.	VARCHAR2(255)	FTVFUND	FTVFUND_TITLE
ASSIGNMENT_LOCATION	Location code. Requires corresponding finance system to be installed.	VARCHAR2(63)	NBRJLBD	NBRJLBD_LOCN_CODE
ASSIGNMENT_LOCATION_DESC	Assignment location description.	VARCHAR2(255)	FTVLOCN	FTVLOCN_TITLE
ASSIGNMENT_ORGANIZATION	Organization code. Requires corresponding finance system to be installed.	VARCHAR2(63)	NBRJLBD	NBRJLBD_ORGN_CODE
ASSIGNMENT_ORGANIZATION_DESC	Assignment organization description.	VARCHAR2(255)	FTVORGN	FTVORGN_TITLE
ASSIGNMENT_PROGRAM	Program code. Requires corresponding finance system to be installed.	VARCHAR2(63)	NBRJLBD	NBRJLBD_PROG_CODE
ASSIGNMENT_PROGRAM_DESC	Assignment program description.	VARCHAR2(255)	FTVPROG	FTVPROG_TITLE
ASSIGNMENT_PROJECT_DESC	Assignment project description.	VARCHAR2(255)	FTVPROJ	FTVPROJ_DESC
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	Chart of accounts code description or title.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
COST_TYPE	Cost type within the corresponding finance cost accounting module.	VARCHAR2(2)	NBRJLBD	NBRJLBD_CTYP_CODE
COST_TYPE_LONG_DESC	Cost type long description.	VARCHAR2(255)	FTVCTYP	FTVCTYP_SHORT_DESC
COST_TYPE_SHORT_DESC	Cost type short description.	VARCHAR2(255)	FTVCTYP	FTVCTYP_SHORT_DESC
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 the last encumbrance calculation was run.	DATE	NBRJLBD	NBRJLBD_ENC_LAST_CALC_DATE
ENCUMB_LAST_RECAST_DATE	Last recasting to encumber salaries and fringes	DATE	NBRJLBD	NBRJLBD_ENC_LAST_RECAST_DATE
ENCUMB_OVERRIDE_END_DATE	End date used to calculate future fiscal year encumbrances for a labor distribution.	DATE	NBRJLBD	NBRJLBD_ENC_OVERRIDE_END_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(63)	NBRJLBD	NBRJLBD_ACCT_CODE_FRINGE
FRINGE_ACCOUNT_DESC	Fringe account description.	VARCHAR2(255)	FTVACCT	FTVACCT_TITLE
FRINGE_ACTIVITY	Fringe Activity code.	VARCHAR2(63)	NBRJLBD	NBRJLBD_ACTV_CODE_FRINGE
FRINGE_ACTIVITY_DESC	Fringe activity description.	VARCHAR2(255)	FTVACTV	FTVACTV_TITLE
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_FUND_DESC	Fringe fund description.	VARCHAR2(255)	FTVFUND	FTVFUND_TITLE
FRINGE_LOCATION	Fringe location code. Requires corresponding finance system to be installed.	VARCHAR2(63)	NBRJLBD	NBRJLBD_LOCN_CODE_FRINGE
FRINGE_LOCATION_DESC	Fringe location description.	VARCHAR2(255)	FTVLOCN	FTVLOCN_TITLE
FRINGE_ORGANIZATION	Fringe organization code. Requires corresponding finance system to be installed.	VARCHAR2(63)	NBRJLBD	NBRJLBD_ORGN_CODE_FRINGE
FRINGE_ORGANIZATION_DESC	Fringe organization description.	VARCHAR2(255)	FTVORGN	FTVORGN_TITLE
FRINGE_PROGRAM	Fringe program code. Requires corresponding finance system to be installed.	VARCHAR2(63)	NBRJLBD	NBRJLBD_PROG_CODE_FRINGE
FRINGE_PROGRAM_DESC	Fringe program description.	VARCHAR2(255)	FTVPROG	FTVPROG_TITLE
FUTURE_FRINGE_ENCUMB	Amount of fringe benefits encumbered to a labor distribution for future fiscal years.	NUMBER	NBRJLBD	NBRJLBD_FUTURE_FRINGE_ENC
FUTURE_FRINGE_ENCUMB_TO_POST	Amount of future fringe benefit encumbrance that will be posted to finance system for specified labor distribution.	NUMBER	NBRJLBD	NBRJLBD_FUTURE_FRG_ENC_TO_POST
FUTURE_FRINGE_RESIDUAL	Amount of fringe encumbrance residual assigned to a labor distribution for future fiscal years.	NUMBER	NBRJLBD	NBRJLBD_FUTURE_FRINGE_RESIDUAL
FUTURE_FRINGE_RESIDUAL_TO_POST	Amount of future fringe encumbrance residual that will be posted to finance system for specified externally funded labor distribution.	NUMBER	NBRJLBD	NBRJLBD_FUTURE_FRG_RES_TO_POST
FUTURE_SALARY_ENCUMB	Amount of salary encumbered to a labor distribution for future fiscal years.	NUMBER	NBRJLBD	NBRJLBD_FUTURE_SALARY_ENC
FUTURE_SALARY_ENCUMB_TO_POST	Amount of salary encumbrance that will be posted to the finance system.	NUMBER	NBRJLBD	NBRJLBD_FUTURE_SAL_ENC_TO_POST
ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	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
LABOR_COST_DIST_ACTIVITY_DATE	Date information for this record in the table was entered or last updated.	DATE	NBRJLBD	NBRJLBD_ACTIVITY_DATE
LABOR_COST_DIST_DATA_ORIGIN	Source system that created or updated the data.	VARCHAR2(63)	NBRJLBD	NBRJLBD_DATA_ORIGIN
LABOR_COST_DIST_USER_ID	Unique identification code of the user who entered or last touched the record.	VARCHAR2(63)	NBRJLBD	NBRJLBD_USER_ID
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: 9.1