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

Ver: