ODS Column	ODS Business Definition	ODS Calculation Formula	ODS Data Type	Banner Source Name	Banner Source Column	Banner Form Name
ADJUST_BY_DATE	Date of the pay event that adjusts this pay event.
ADJUST_BY_SEQUENCE_NUMBER	Sequence number of the pay event that adjusts this pay event.
ADJUST_DATE	Date of the pay event that this event adjusts.
ADJUST_SEQUENCE_NUMBER	Sequence number of the pay event that this one adjusts.
APPOINTMENT_PCT	Percentage of positions salary used to calculate employees salary.
ASSOCIATED_SEQUENCE_NUMBER	The sequence of the event that corresponds to this event for two step adjustments.
BASE_SALARY_HOURS	Regular hours worked during the Pay Period.
CALENDAR_YEAR	Pay Period Year for Expenditure Interface transactions. This will be null for all transactions other than Expenditure type transactions.
CURRENT_DATE	System current date (sysdate) or date the data was extracted.			NA	SYSDATE
DEDUCTIONS_AMOUNT	Total amount of the deductions from the gross amount.
DEFERRED_PAY_AMOUNT	Amount deferred each pay period.
DISPOSITION	Status of this pay event through the pay cycle.
DISPOSITION_DESC	Status of the pay event description.
DOCUMENT_DATE	Date that will appear on the pay document.
DOCUMENT_PRINT_METHOD	Indicates if the event was manually printed outside of the sytem
DOCUMENT_PRINT_METHOD_DESC	Check print method description.
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.
EMPLOYEE_CLASS_TYPE	Identifies a type of employee class that is potentially eligible for a shift premium.
EMPLOYEE_CLASS_TYPE_DESC	Employee Class type code description.
EMPLOYER	User-defined code used as part of the Employee_Position definition. It is often used, for example, as a means to identify different campuses within an institution, or different major functional areas.
EMPLOYER_DESC	Employer description.
EVENT_SEQUENCE_NUMBER	Pay Event Identifying Sequence Number.
FIRST_NAME_HISTORY	First name of the person at the time of the specific pay event.
FULL_ASSIGNMENT_SALARY	The salary to be paid each pay period.
FULL_TIME_EQUIVALENCY	Full time equivalency assigned to this Employee_Position.
GROSS_AMOUNT	Total gross amount of the event.
HOURLY_RATE	Rate of Pay for the Employee Position.
HOURS_PER_DAY	The number of hours a person filling this Employee Position normally works in a day.
ID_HISTORY	Identification number assigned to the person at the time of the specific pay event.
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.
LAST_NAME_HISTORY	Last name of the person at the time of the specific pay event.
LEAVE_CATEGORY	Leave category to which the employee belongs.
LEAVE_CATEGORY_DESC	Leave category description or title.
LONGEVITY_ELIGIBILITY	Indicates eligibility for additional longevity pay.
LONGEVITY_ELIGIBILITY_DESC	Longevity code description.
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.
NET_AMOUNT	Total net amount of the event.
PAYROLL_CALCULATION_TYPE	Indicates if the pay event was calculated manually or by the system.
PAYROLL_CALCULATION_TYPE_DESC	Pay event calculation description.
PAYROLL_EVENT_TYPE	Indicates the type of pay event (Manual, Void, Redistribution, etc.).
PAYROLL_EVENT_TYPE_DESC	Pay event type description.
PAYROLL_IDENTIFIER	Pay identification number to which this Employee_Position belongs.
PAYROLL_IDENTIFIER_COUNT	Number of times the employee has been paid for this payroll identifier.
PAYROLL_IDENTIFIER_DESC	Payroll code description or title.
PAYROLL_NUMBER	Used to uniquely identify a pay period within a fiscal year.
PAYROLL_POSITION_ACTIVITY_DATE	Date record was inserted or updated.			PHRJOBS	PHRJOBS_ACTIVITY_DATE
PERSON_UID	System generated unique internal identification number assigned to this person.
PER_PAY_SALARY	Salary paid each pay period. Used for deferred pay calculations. Amount Deferred = Employee Position Salary - Per Pay Salary.
POSITION	Employee Position number.
POSITION_BEGIN_DATE	Date an Employee_Position became effective in the payroll system.
POSITION_CONTRACT_TYPE	Indicates whether this is the Primary, Secondary, or Overload position.
POSITION_CONTRACT_TYPE_DESC	Description of the contract type
POSITION_EMPLOYEE_CLASS	Employee class code. Organizes position information consistent with employee groupings. At the employee level, its used to help determine controls for benefits, leave, payroll and self-service rules.
POSITION_EMPLOYEE_CLASS_DESC	Employee position class description.
POSITION_END_DATE	The date until which this history Employee Position record is effective.
POSITION_STATUS	Status of the Employee_Position (Active, Terminated, Leave with Benefits, etc.) at the time of the pay event.
POSITION_STATUS_DESC	Position status description.
POSITION_TITLE	Description of the Employee_Position. Defaults from the position title if left blank.
POSTING_OVERRIDE_DATE	Date the accounting transaction was overriden by the finance process.
PREMIUM_PAY_CATEGORY	Controls premium pay generation.
PREMIUM_PAY_CATEGORY_DESC	Description of the premium pay category.
PREVIOUS_FISCAL_YEAR_IND	Indicator if the retro earnings paid are for the previous fiscal year.
PUBLIC_RETIREMENT_CONTRIBUTION	Public employee retirement contribution code.
PUBLIC_RETIREMENT_CONT_DESC	Public employee retirement contribution code description.
PUBLIC_RETIREMENT_PAY_RATE	Public employee retirement pay rate/frequency code.
PUBLIC_RETIRE_PAY_RATE_DESC	Public employee retirement pay rate/frequency description.
SHIFT_NUMBER	Identifies a time period during which the employee works.
SHIFT_PREMIUM_AMOUNT	The additional amount (above their regular rate) an employee will earn when working this shift number.
SHIFT_PREMIUM_PERCENT	The additional percent (above their regular rate) an employee will earn when working this shift number.
STATE_RETIREMENT_ASSIGNMENT	State employee retirement assignment code.
STATE_RETIREMENT_ASSIGN_DESC	State employee retirement assignment code description.
STATE_RETIREMENT_CONTRIBUTION	State employee retirement contribution code.
STATE_RETIREMENT_CONT_DESC	State employee retirement contribution code description.
STATE_RETIREMENT_PAY_RATE	State employee retirement pay rate/frequency code.
STATE_RETIREMENT_PAY_RATE_DESC	State employee retirement pay rate/frequency description.
SUPPLEMENTAL_PAY_DATE	The date that the update payroll was run for supplemental pay or adjustments..
TIMESHEET_CHART_DESC	Chart of accounts code description or title.
TIMESHEET_CHART_OF_ACCOUNTS	Timesheet chart of accounts.
TIMESHEET_METHOD	Determines the method by which the timesheet is entered in they system.
TIMESHEET_METHOD_DESC	Description of the timesheet method.
TIMESHEET_ORGANIZATION	Organization to which the time sheet for this position is sent.
TIMESHEET_ORGANIZATION_DESC	Organization to which this Employee_Positions time sheet is sent.
TIME_ENTRY_TYPE	Type of or frequency of time entry.
TIME_ENTRY_TYPE_DESC	Description of the time entry type.
UNEMPLOY_INSURANCE_EXCEPTION	Associated with insurable earnings by pay period.
UNEMPLOY_INSURANCE_WEEKS	Unemployment Insurance insurable for this pay period.
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.

Ver: 8.3