Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACTIVITY_DATE	Date record was inserted or updated.	DATE	PHRELBD	PHRELBD_ACTIVITY_DATE	NO	NO
CALENDAR_YEAR	Pay period calendar year.	VARCHAR2(4)	PHRELBD	PHRELBD_YEAR	NO	NO
CHART_OF_ACCOUNTS	Chart of accounts code as defined on the BANNER Finance system.	VARCHAR2(1)	PHRELBD	PHRELBD_COAS_CODE	NO	NO
CHART_OF_ACCOUNTS_DESC	Chart of accounts code description or title.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
COST_TYPE	Type of labor cost.	VARCHAR2(2)	PHRELBD	PHRELBD_CTYP_CODE	NO	NO
COST_TYPE_LONG_DESC	Cost type long description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
COST_TYPE_SHORT_DESC	Cost type short description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DOMAIN_VALUE	Domain column for future use, not currently populated.	VARCHAR2(6)	NA	NA	NO	NO
EARNINGS	Earnings Code.	VARCHAR2(3)	PHRELBD	PHRELBD_EARN_CODE	NO	NO
EARNINGS_DESC	Earnings code long description.	VARCHAR2(30)	PTREARN	PTREARN_LONG_DESC	NO	NO
ENCUMBRANCE_NUMBER	Unique encumbrance code of a document.	VARCHAR2(8)	PHRELBD	PHRELBD_ENCD_NUM	NO	NO
ENCUMBRANCE_SEQUENCE	Encumbrance sequence number.	NUMBER	PHRELBD	PHRELBD_ENCD_SEQ_NUM	NO	NO
EVENT_SEQUENCE_NUMBER	Sequence of the pay event.	NUMBER	PHRELBD	PHRELBD_SEQ_NO	NO	NO
EXTERNAL_ACCOUNT	Free form Account Number to be used to interface to finance systems when Banner Finance is not present.	VARCHAR2(60)	PHRELBD	PHRELBD_ACCT_CODE_EXTERNAL	NO	NO
HOURS	Number of earnings hours associated with the labor distribution.	NUMBER	PHRELBD	PHRELBD_HRS	NO	NO
JOB_SUFFIX	Suffix allows users to define a job with more precision. For example, a user could denote daytime faculty with one suffix and evening school with another.	VARCHAR2(2)	PHRELBD	PHRELBD_SUFF	NO	NO
MIF_DESC	The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(6)	NA	NA	NO	NO
PAYROLL_IDENTIFIER	Pay identification number to which this Employee_Position belongs.	VARCHAR2(2)	PHRELBD	PHRELBD_PICT_CODE	NO	NO
PAYROLL_IDENTIFIER_DESC	Payroll code description or title.	VARCHAR2(30)	PTRPICT	PTRPICT_DESC	NO	NO
PAYROLL_NUMBER	Used to uniquely identify a pay period within a fiscal year.	NUMBER	PHRELBD	PHRELBD_PAYNO	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	PHRELBD	PHRELBD_PERCENT	NO	NO
PERSON_UID	System generated unique internal identification number assigned to this person.	NUMBER	PHRELBD	PHRELBD_PIDM	NO	NO
POSITION	Employee Position number.	VARCHAR2(6)	PHRELBD	PHRELBD_POSN	NO	NO
POSITION_ACCOUNT	Code to which the position account is to be charged.	VARCHAR2(6)	PHRELBD	PHRELBD_ACCT_CODE	NO	NO
POSITION_ACCOUNT_DESC	Position account description.	VARCHAR2(35)	FTVACCT	FTVACCT_TITLE	NO	NO
POSITION_ACCOUNT_INDEX	An index code that is used to default the account distribution to which this position should be charged.	VARCHAR2(6)	PHRELBD	PHRELBD_ACCI_CODE	NO	NO
POSITION_ACCOUNT_INDEX_DESC	Position account index description.	VARCHAR2(35)	FTVACCI	FTVACCI_TITLE	NO	NO
POSITION_ACTIVITY	Code that defines the activity to which the position should be charged.	VARCHAR2(6)	PHRELBD	PHRELBD_ACTV_CODE	NO	NO
POSITION_ACTIVITY_DESC	Position activity descripton.	VARCHAR2(35)	FTVACTV	FTVACTV_TITLE	NO	NO
POSITION_BEGIN_DATE	Date an Employee_Position became effective in the payroll system.	DATE	PHRELBD	PHRELBD_EFFECTIVE_DATE	NO	NO
POSITION_FUND	Code that identifies the fund to which this position should be charged.	VARCHAR2(6)	PHRELBD	PHRELBD_FUND_CODE	NO	NO
POSITION_FUND_DESC	Position fund description.	VARCHAR2(35)	FTVFUND	FTVFUND_TITLE	NO	NO
POSITION_LOCATION	Code that identifies the program to which this position should be charged.	VARCHAR2(6)	PHRELBD	PHRELBD_LOCN_CODE	NO	NO
POSITION_LOCATION_DESC	Position location description.	VARCHAR2(35)	FTVLOCN	FTVLOCN_TITLE	NO	NO
POSITION_ORGANIZATION	Code that identifies the organization to which this position should be charged.	VARCHAR2(6)	PHRELBD	PHRELBD_ORGN_CODE	NO	NO
POSITION_ORGANIZATION_DESC	Position organization description.	VARCHAR2(35)	FTVORGN	FTVORGN_TITLE	NO	NO
POSITION_PROGRAM	Code that identifies the program to which this position should be charged.	VARCHAR2(6)	PHRELBD	PHRELBD_PROG_CODE	NO	NO
POSITION_PROGRAM_DESC	Position program description.	VARCHAR2(35)	FTVPROG	FTVPROG_TITLE	NO	NO
POSITION_PROJECT	Work order code used within cost accounting module.	VARCHAR2(8)	PHRELBD	PHRELBD_PROJ_CODE	NO	NO
POSITION_PROJECT_DESC	Position project description.	VARCHAR2(30)	FTVPROJ	FTVPROJ_DESC	NO	NO
POSITION_TITLE	Description of the Employee_Position. Defaults from the position title if left blank.	VARCHAR2(30)	NBBPOSN	NBBPOSN_TITLE	NO	NO
REDISTRIBUTION_AMOUNT	Amount of redistributed dollars.	NUMBER	PHRELBD	PHRELBD_REDISTRIBUTION_AMT	NO	NO
SHIFT_NUMBER	Shift Associated with Earnings Code.	VARCHAR2(1)	PHRELBD	PHRELBD_SHIFT	NO	NO
SYSTEM_GENERATED_IND	Indicates if the pay event was calculated manually or by the system.	VARCHAR2(1)	PHRELBD	PHRELBD_GEN_IND	NO	NO
TIMESHEET_CHART_DESC	Chart of accounts code description or title.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
TIMESHEET_CHART_OF_ACCOUNTS	Timesheet Chart of Accounts Code.	VARCHAR2(1)	PHRELBD	PHRELBD_COAS_CODE_TS	NO	NO
TIMESHEET_METHOD	Determines the method by which the timesheet is entered in they system.	VARCHAR2(1)	PHRELBD	PHRELBD_TS_ROSTER_IND	NO	NO
TIMESHEET_METHOD_DESC	Timesheet method description.	VARCHAR2(12)	CALCULATION	DECODE(PHRELBD_TS_ROSTER_IND)	NO	NO
TIMESHEET_ORGANIZATION	Organization to which the time sheet for this position is sent.	VARCHAR2(6)	PHRELBD	PHRELBD_ORGN_CODE_TS	NO	NO
TIMESHEET_ORGANIZATION_DESC	Organization to which this Employee_Position's time sheet is sent.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA	NO	NO

Ver: