ODS Column	ODS Business Definition	ODS Calculation Formula	ODS Data Type	Banner Source Name	Banner Source Column	Banner Form Name
ACTIVITY_DATE	Date record was inserted or updated			PHRELBD	PHRELBD_ACTIVITY_DATE
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA
CALENDAR_YEAR	Pay period calendar year.			PHRELBD	PHRELBD_YEAR
CHART_OF_ACCOUNTS	Chart of accounts code as defined on the BANNER Finance system.			PHRELBD	PHRELBD_COAS_CODE
CHART_OF_ACCOUNTS_DESC	Chart of accounts code description or title.			FUNCTION	GOKODSF.F_GET_DESC
COST_TYPE	Type of labor cost.			PHRELBD	PHRELBD_CTYP_CODE
COST_TYPE_LONG_DESC	Cost type long description.			FUNCTION	GOKODSF.F_GET_DESC
COST_TYPE_SHORT_DESC	Cost type short description.			FUNCTION	GOKODSF.F_GET_DESC
EARNINGS	Earnings Code.			PHRELBD	PHRELBD_EARN_CODE
EARNINGS_DESC	Earnings code long description.			PTREARN	PTREARN_LONG_DESC
ENCUMBRANCE_NUMBER	Unique encumbrance code of a document.			PHRELBD	PHRELBD_ENCD_NUM
ENCUMBRANCE_SEQUENCE	Encumbrance sequence number.			PHRELBD	PHRELBD_ENCD_SEQ_NUM
EVENT_SEQUENCE_NUMBER	Sequence of the pay event.			PHRELBD	PHRELBD_SEQ_NO
EXTERNAL_ACCOUNT	Free form Account Number to be used to interface to finance systems when Banner Finance is not present.			PHRELBD	PHRELBD_ACCT_CODE_EXTERNAL
HOURS	Number of earnings hours associated with the labor distribution.			PHRELBD	PHRELBD_HRS
ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.			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.			PHRELBD	PHRELBD_SUFF
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.			NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.			NA	NA
NAME	Combination of the person's first, middle initial, and last name into one value.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PAYROLL_IDENTIFIER	Pay identification number to which this Employee_Position belongs.			PHRELBD	PHRELBD_PICT_CODE
PAYROLL_IDENTIFIER_DESC	Payroll code description or title.			PTRPICT	PTRPICT_DESC
PAYROLL_NUMBER	Used to uniquely identify a pay period within a fiscal year.			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.			PHRELBD	PHRELBD_PERCENT
PERSON_UID	System generated unique internal identification number assigned to this person.			PHRELBD	PHRELBD_PIDM
POSITION	Employee Position number.			PHRELBD	PHRELBD_POSN
POSITION_ACCOUNT	Code to which the position account is to be charged.			PHRELBD	PHRELBD_ACCT_CODE
POSITION_ACCOUNT_DESC	Position account description.			FTVACCT	FTVACCT_TITLE
POSITION_ACCOUNT_INDEX	An index code that is used to default the account distribution to which this position should be charged.			PHRELBD	PHRELBD_ACCI_CODE
POSITION_ACCOUNT_INDEX_DESC	Position account index description.			FTVACCI	FTVACCI_TITLE
POSITION_ACTIVITY	Code that defines the activity to which the position should be charged.			PHRELBD	PHRELBD_ACTV_CODE
POSITION_ACTIVITY_DESC	Position activity descripton.			FTVACTV	FTVACTV_TITLE
POSITION_BEGIN_DATE	Date an Employee_Position became effective in the payroll system.			PHRELBD	PHRELBD_EFFECTIVE_DATE
POSITION_FUND	Code that identifies the fund to which this position should be charged.			PHRELBD	PHRELBD_FUND_CODE
POSITION_FUND_DESC	Position fund description.			FTVFUND	FTVFUND_TITLE
POSITION_LOCATION	Code that identifies the program to which this position should be charged.			PHRELBD	PHRELBD_LOCN_CODE
POSITION_LOCATION_DESC	Position location description.			FTVLOCN	FTVLOCN_TITLE
POSITION_ORGANIZATION	Code that identifies the organization to which this position should be charged.			PHRELBD	PHRELBD_ORGN_CODE
POSITION_ORGANIZATION_DESC	Position organization description.			FTVORGN	FTVORGN_TITLE
POSITION_PROGRAM	Code that identifies the program to which this position should be charged.			PHRELBD	PHRELBD_PROG_CODE
POSITION_PROGRAM_DESC	Position program description.			FTVPROG	FTVPROG_TITLE
POSITION_PROJECT	Work order code used within cost accounting module.			PHRELBD	PHRELBD_PROJ_CODE
POSITION_PROJECT_DESC	Position project description.			FTVPROJ	FTVPROJ_DESC
POSITION_TITLE	Description of the Employee_Position. Defaults from the position title if left blank.			NBBPOSN	NBBPOSN_TITLE
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA
REDISTRIBUTION_AMOUNT	Amount of redistributed dollars.			PHRELBD	PHRELBD_REDISTRIBUTION_AMT
SHIFT_NUMBER	Shift Associated with Earnings Code.			PHRELBD	PHRELBD_SHIFT
SYSTEM_GENERATED_IND	Indicates if the pay event was calculated manually or by the system.			PHRELBD	PHRELBD_GEN_IND
TIMESHEET_CHART_DESC	Chart of accounts code description or title.			FUNCTION	GOKODSF.F_GET_DESC
TIMESHEET_CHART_OF_ACCOUNTS	Timesheet Chart of Accounts Code			PHRELBD	PHRELBD_COAS_CODE_TS
TIMESHEET_METHOD	Determines the method by which the timesheet is entered in they system.			PHRELBD	PHRELBD_TS_ROSTER_IND
TIMESHEET_METHOD_DESC	Timesheet method description.			CALCULATION	DECODE(PHRELBD_TS_ROSTER_IND)
TIMESHEET_ORGANIZATION	Organization to which the time sheet for this position is sent.			PHRELBD	PHRELBD_ORGN_CODE_TS
TIMESHEET_ORGANIZATION_DESC	Organization to which this Employee_Position's time sheet is sent.			FUNCTION	GOKODSF.F_GET_DESC

Ver: 8.3