Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACTIVITY_DATE	Date record was inserted or updated.	DATE	PHRELBD	PHRELBD_ACTIVITY_DATE
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
CALENDAR_YEAR	Pay period calendar year.	VARCHAR2(63)	PHRELBD	PHRELBD_YEAR
CHART_OF_ACCOUNTS	Chart of accounts code as defined on the BANNER Finance system.	VARCHAR2(63)	PHRELBD	PHRELBD_COAS_CODE
CHART_OF_ACCOUNTS_DESC	Chart of accounts code description or title.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
COST_TYPE	Type of labor cost.	VARCHAR2(63)	PHRELBD	PHRELBD_CTYP_CODE
COST_TYPE_LONG_DESC	Cost type long description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
COST_TYPE_SHORT_DESC	Cost type short description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
EARNINGS	Earnings Code.	VARCHAR2(63)	PHRELBD	PHRELBD_EARN_CODE
EARNINGS_DESC	Earnings code long description.	VARCHAR2(255)	PTREARN	PTREARN_LONG_DESC
ENCUMBRANCE_NUMBER	Unique encumbrance code of a document.	VARCHAR2(63)	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(63)	PHRELBD	PHRELBD_ACCT_CODE_EXTERNAL
HOURS	Number of earnings hours associated with the labor distribution.	NUMBER	PHRELBD	PHRELBD_HRS
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 a job with more precision. For example, a user could denote daytime faculty with one suffix and evening school with another.	VARCHAR2(63)	PHRELBD	PHRELBD_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	Combination of the person's first, middle initial, and last name into one value.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PAYROLL_IDENTIFIER	Pay identification number to which this Employee_Position belongs.	VARCHAR2(63)	PHRELBD	PHRELBD_PICT_CODE
PAYROLL_IDENTIFIER_DESC	Payroll code description or title.	VARCHAR2(255)	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(63)	PHRELBD	PHRELBD_POSN
POSITION_ACCOUNT	Code to which the position account is to be charged.	VARCHAR2(63)	PHRELBD	PHRELBD_ACCT_CODE
POSITION_ACCOUNT_DESC	Position account description.	VARCHAR2(255)	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(63)	PHRELBD	PHRELBD_ACCI_CODE
POSITION_ACCOUNT_INDEX_DESC	Position account index description.	VARCHAR2(255)	FTVACCI	FTVACCI_TITLE
POSITION_ACTIVITY	Code that defines the activity to which the position should be charged.	VARCHAR2(63)	PHRELBD	PHRELBD_ACTV_CODE
POSITION_ACTIVITY_DESC	Position activity descripton.	VARCHAR2(255)	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(63)	PHRELBD	PHRELBD_FUND_CODE
POSITION_FUND_DESC	Position fund description.	VARCHAR2(255)	FTVFUND	FTVFUND_TITLE
POSITION_LOCATION	Code that identifies the program to which this position should be charged.	VARCHAR2(63)	PHRELBD	PHRELBD_LOCN_CODE
POSITION_LOCATION_DESC	Position location description.	VARCHAR2(255)	FTVLOCN	FTVLOCN_TITLE
POSITION_ORGANIZATION	Code that identifies the organization to which this position should be charged.	VARCHAR2(63)	PHRELBD	PHRELBD_ORGN_CODE
POSITION_ORGANIZATION_DESC	Position organization description.	VARCHAR2(255)	FTVORGN	FTVORGN_TITLE
POSITION_PROGRAM	Code that identifies the program to which this position should be charged.	VARCHAR2(63)	PHRELBD	PHRELBD_PROG_CODE
POSITION_PROGRAM_DESC	Position program description.	VARCHAR2(255)	FTVPROG	FTVPROG_TITLE
POSITION_PROJECT	Work order code used within cost accounting module.	VARCHAR2(63)	PHRELBD	PHRELBD_PROJ_CODE
POSITION_PROJECT_DESC	Position project description.	VARCHAR2(255)	FTVPROJ	FTVPROJ_DESC
POSITION_TITLE	Description of the Employee_Position. Defaults from the position title if left blank.	VARCHAR2(255)	NBBPOSN	NBBPOSN_TITLE
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
REDISTRIBUTION_AMOUNT	Amount of redistributed dollars.	NUMBER	PHRELBD	PHRELBD_REDISTRIBUTION_AMT
SHIFT_NUMBER	Shift Associated with Earnings Code.	VARCHAR2(63)	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(255)	FUNCTION	GOKODSF.F_GET_DESC
TIMESHEET_CHART_OF_ACCOUNTS	Timesheet Chart of Accounts Code.	VARCHAR2(63)	PHRELBD	PHRELBD_COAS_CODE_TS
TIMESHEET_METHOD	Determines the method by which the timesheet is entered in they system.	VARCHAR2(63)	PHRELBD	PHRELBD_TS_ROSTER_IND
TIMESHEET_METHOD_DESC	Timesheet method description.	VARCHAR2(255)	CALCULATION	DECODE(PHRELBD_TS_ROSTER_IND)
TIMESHEET_ORGANIZATION	Organization to which the time sheet for this position is sent.	VARCHAR2(63)	PHRELBD	PHRELBD_ORGN_CODE_TS
TIMESHEET_ORGANIZATION_DESC	Organization to which this Employee_Position's time sheet is sent.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC

Ver: 9.1