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

Ver: