Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACCOUNT_INDEX	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	Account INDEX Description	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 Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
ASSIGNMENT_ACCOUNT	Assignment Account	Account code. Must exist in corresponding finance system.	VARCHAR2(63)		NBRJLBD	NBRJLBD_ACCT_CODE
ASSIGNMENT_ACCOUNT_DESC	Assignment Account Description	Assignment account description.	VARCHAR2(255)		FTVACCT	FTVACCT_TITLE
ASSIGNMENT_ACTIVITY	Assignment Activity	Activity code.	VARCHAR2(63)		NBRJLBD	NBRJLBD_ACTV_CODE
ASSIGNMENT_ACTIVITY_DESC	Assignment Activity Description	Assignment activity description.	VARCHAR2(255)		FTVACTV	FTVACTV_TITLE
ASSIGNMENT_FUND	Assignment Fund	Fund code. Requires corresponding finance system to be installed.	VARCHAR2(63)		NBRJLBD	NBRJLBD_FUND_CODE
ASSIGNMENT_FUND_DESC	Assignment Fund Description	Assignment fund description.	VARCHAR2(255)		FTVFUND	FTVFUND_TITLE
ASSIGNMENT_LOCATION	Assignment Location	Location code. Requires corresponding finance system to be installed.	VARCHAR2(63)		NBRJLBD	NBRJLBD_LOCN_CODE
ASSIGNMENT_LOCATION_DESC	Assignment Location Description	Assignment location description.	VARCHAR2(255)		FTVLOCN	FTVLOCN_TITLE
ASSIGNMENT_ORGANIZATION	Assignment Organization	Organization code. Requires corresponding finance system to be installed.	VARCHAR2(63)		NBRJLBD	NBRJLBD_ORGN_CODE
ASSIGNMENT_ORGANIZATION_DESC	Assignment Organization Description	Assignment organization description.	VARCHAR2(255)		FTVORGN	FTVORGN_TITLE
ASSIGNMENT_PROGRAM	Assignment Program	Program code. Requires corresponding finance system to be installed.	VARCHAR2(63)		NBRJLBD	NBRJLBD_PROG_CODE
ASSIGNMENT_PROGRAM_DESC	Assignment Program Description	Assignment program description.	VARCHAR2(255)		FTVPROG	FTVPROG_TITLE
ASSIGNMENT_PROJECT_DESC	Assignment Project Description	Assignment project description.	VARCHAR2(255)		FTVPROJ	FTVPROJ_DESC
CHANGE_INDICATOR	Change Indicator	Specifies if the record is active or to be deleted.	VARCHAR2(1)		NBRJLBD	NBRJLBD_CHANGE_IND
CHART_OF_ACCOUNTS	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 Description	Chart of accounts code description or title.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
COST_TYPE	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	Cost type long description.	VARCHAR2(255)		FTVCTYP	FTVCTYP_SHORT_DESC
COST_TYPE_SHORT_DESC	Cost Type Short Description	Cost type short description.	VARCHAR2(255)		FTVCTYP	FTVCTYP_SHORT_DESC
EFFECTIVE_DATE	Effective Date	Date that the job labor distribution record becomes effective in the payroll system.	DATE		NBRJLBD	NBRJLBD_EFFECTIVE_DATE
EFFECTIVE_END_DATE	Effective End Date	End effective date.	DATE		FUNCTION	NOKODSF.F_GET_END_NBRJLBD_DATE
EFFECTIVE_START_DATE	Effective Start Date	Start effective date.	DATE		NBRJLBD	NBRJLBD_EFFECTIVE_DATE
ENCUMBRANCE_NUMBER	Encumbrance Number	Unique encumbrance code of a document.	VARCHAR2(8)		NBRJLBD	NBRJLBD_ENCD_NUM
ENCUMBRANCE_SEQUENCE	Encumbrance Sequence	Encumbrance sequence number.	NUMBER		NBRJLBD	NBRJLBD_ENCD_SEQ_NUM
ENCUMB_LAST_CALCULATION_DATE	Encumb Last Calculation Date	Date the last encumbrance calculation was run.	DATE		NBRJLBD	NBRJLBD_ENC_LAST_CALC_DATE
ENCUMB_LAST_RECAST_DATE	Encumb Last Recast Date	Last recasting to encumber salaries and fringes	DATE		NBRJLBD	NBRJLBD_ENC_LAST_RECAST_DATE
ENCUMB_OVERRIDE_END_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	External Account	System account distribution code to which this position should be charged.	VARCHAR2(60)		NBRJLBD	NBRJLBD_ACCT_CODE_EXTERNAL
FRINGE_ACCOUNT	Fringe Account	Fringe Account.	VARCHAR2(63)		NBRJLBD	NBRJLBD_ACCT_CODE_FRINGE
FRINGE_ACCOUNT_DESC	Fringe Account Description	Fringe account description.	VARCHAR2(255)		FTVACCT	FTVACCT_TITLE
FRINGE_ACTIVITY	Fringe Activity	Fringe Activity code.	VARCHAR2(63)		NBRJLBD	NBRJLBD_ACTV_CODE_FRINGE
FRINGE_ACTIVITY_DESC	Fringe Activity Description	Fringe activity description.	VARCHAR2(255)		FTVACTV	FTVACTV_TITLE
FRINGE_ENCUMBRANCE	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 Resid Amount	Fringe encumbrance residual amount assigned to this externally funded labor distribution.	NUMBER		NBRJLBD	NBRJLBD_FRINGE_RESIDUAL
FRINGE_ENCUMBRANCE_TO_POST	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	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	Fringe fund code. Requires corresponding finance system to be installed.	VARCHAR2(63)		NBRJLBD	NBRJLBD_FUND_CODE_FRINGE
FRINGE_FUND_DESC	Fringe Fund Description	Fringe fund description.	VARCHAR2(255)		FTVFUND	FTVFUND_TITLE
FRINGE_LOCATION	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	Fringe location description.	VARCHAR2(255)		FTVLOCN	FTVLOCN_TITLE
FRINGE_ORGANIZATION	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	Fringe organization description.	VARCHAR2(255)		FTVORGN	FTVORGN_TITLE
FRINGE_PROGRAM	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	Fringe program description.	VARCHAR2(255)		FTVPROG	FTVPROG_TITLE
FUTURE_FRINGE_ENCUMB	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	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	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	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	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	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	ID	Person's or organization's current identification number.	VARCHAR2(63)		FUNCTION	MGKFUNC.F_GET_PERSON_INFO
JOB_SUFFIX	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	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	Labor Cost Dist Data Origin	Source system that created or updated the data.	VARCHAR2(63)		NBRJLBD	NBRJLBD_DATA_ORIGIN
LABOR_COST_DIST_USER_ID	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	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)		NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)		NA	NA
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)		FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PERCENT	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	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER		NBRJLBD	NBRJLBD_PIDM
POSITION	Position	Position number for this employee position.	VARCHAR2(63)		NBRJLBD	NBRJLBD_POSN
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
PROJECT	Project	Work order code used within cost accounting module.	VARCHAR2(8)		NBRJLBD	NBRJLBD_PROJ_CODE
SALARY_ENCUMBRANCE	Salary Encumbrance	Amount encumbered to this labor distribution for the active fiscal year.	NUMBER		NBRJLBD	NBRJLBD_SALARY_ENCUMBRANCE
SALARY_ENCUMBRANCE_TO_POST	Salary Encumbrance To Post	Amount of encumbrance posted to the finance system.	NUMBER		NBRJLBD	NBRJLBD_SALARY_ENC_TO_POST

Ver: 9.0