Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ADJUST_BY_DATE	Adjustment By Date	Date of the pay event that adjusts this pay event.	DATE		PHRHIST	PHRHIST_ADJ_BY_DATE
ADJUST_BY_SEQUENCE_NUMBER	Adjustment By Sequence Number	Sequence number of the pay event that adjusts this pay event.	VARCHAR2(63)		PHRHIST	PHRHIST_ADJ_BY_SEQ_NO
ADJUST_DATE	Adjustment Date	Date of the pay event that this event adjusts.	DATE		PHRHIST	PHRHIST_ADJS_DATE
ADJUST_SEQUENCE_NUMBER	Adjustment Sequence Number	Sequence number of the pay event that this one adjusts.	NUMBER		PHRHIST	PHRHIST_ADJS_SEQ_NO
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
APPOINTMENT_PCT	Appointment Percent	Percentage of position's salary used to calculate employee's salary.	NUMBER		PHRJOBS	PHRJOBS_APPT_PCT
ASSOCIATED_SEQUENCE_NUMBER	Associated Sequence Number	The sequence of the event that corresponds to this event for two step adjustments.	NUMBER		PHRHIST	PHRHIST_ASSOC_SEQ_NO
BASE_SALARY_HOURS	Base Salary Hours	Regular hours worked during the Pay Period.	NUMBER		PHRJOBS	PHRJOBS_BASE_SAL_HRS
CALENDAR_YEAR	Calendar Year	Pay period calendar year.	VARCHAR2(63)		PHRHOUR	PHRHOUR_YEAR
DEDUCTIONS_AMOUNT	Deductions Amount	Total amount of the deductions from the gross amount.	NUMBER		FUNCTION	POKODSF.F_CALC_DEDN_AMT
DEFERRED_PAY_AMOUNT	Deferred Pay Amount	Amount deferred each pay period.	NUMBER		PHRJOBS	PHRJOBS_DEFER_AMT
DISPOSITION	Disposition	Status of this pay event through the pay cycle.	VARCHAR2(63)		PHRHIST	PHRHIST_DISP
DISPOSITION_DESC	Disposition Description	Status of the pay event description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
DOCUMENT_DATE	Document Date	Date that will appear on the pay document.	DATE		PHRHIST	PHRHIST_EVENT_DATE
DOCUMENT_PRINT_METHOD	Document Print Method	Indicates if the event was manually printed outside of the sytem	VARCHAR2(63)		PHRHIST	PHRHIST_PRINT_IND
DOCUMENT_PRINT_METHOD_DESC	Document Print Method Description	Document print method description.	VARCHAR2(255)		CALCULATION	DECODE(PHRHIST_PRINT_IND)
EARNINGS	Earnings	Earnings Code.	VARCHAR2(63)		PHRHOUR	PHRHOUR_EARN_CODE
EARNINGS_DESC	Earnings Description	Earnings code long description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
EFFECTIVE_DATE	Effective Date	Date on which the history earnings record becomes effective.	DATE		PHRHOUR	PHRHOUR_EFFECTIVE_DATE
EMPLOYEE_CLASS_TYPE	Employee Class Type	Identifies a type of employee class that is potentially eligible for a shift premium.	VARCHAR2(63)		PTRECLS	PTRECLS_SHCD_CODE
EMPLOYEE_CLASS_TYPE_DESC	Employee Class Type Description	Employee class type code description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
EMPLOYER	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.	VARCHAR2(63)		PHRJOBS	PHRJOBS_EMPR_CODE
EMPLOYER_DESC	Employer Description	Employer description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
EVENT_SEQUENCE_NUMBER	Event Sequence Number	Pay Event Identifying Sequence Number.	NUMBER		PHRHOUR	PHRHOUR_SEQ_NO
FIRST_NAME_HISTORY	First Name History	First name of the person at the time of the pay event.	VARCHAR2(63)		PHRJOBS	PHRJOBS_FIRST_NAME_SEQ
FULL_ASSIGNMENT_SALARY	Full Assignment Salary	The salary to be paid each pay period.	NUMBER		PHRJOBS	PHRJOBS_FULL_ASSGN_SALARY
FULL_TIME_EQUIVALENCY	Full Time Equivalency	Full time equivalency assigned to this Employee_Position.	NUMBER		PHRJOBS	PHRJOBS_FTE
GROSS_AMOUNT	Gross Amount	Total gross amount of the event.	NUMBER		PHRHIST	PHRHIST_GROSS
GROSS_EARNINGS	Gross Earnings	Gross earnings for this employee for this earnings code during the time entry period.	NUMBER		PHRHOUR	PHRHOUR_AMT
HOURLY_RATE	Hourly Rate	Rate of Pay for the Employee Position.	NUMBER		PHRJOBS	PHRJOBS_SALARY_RATE
HOURS_PER_DAY	Hours Period Day	The number of hours a person filling this Employee Position normally works in a day.	NUMBER		PHRJOBS	PHRJOBS_HRS_DAY
HOURS_WORKED	Hours Worked	Number of hours worked during the time entry period.	NUMBER		PHRHOUR	PHRHOUR_HRS
ID	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
ID_HISTORY	ID History	Identification number assigned to the person at the time of the specific pay event.	VARCHAR2(63)		PHRJOBS	PHRJOBS_ID_SEQ
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(63)		PHRHOUR	PHRHOUR_SUFF
LAST_NAME_HISTORY	Last Name History	Last name of the person at the time of the specific pay event.	VARCHAR2(63)		PHRJOBS	PHRJOBS_LAST_NAME_SEQ
LEAVE_CATEGORY	Leave Category	Leave category to which the employee belongs.	VARCHAR2(63)		PHRJOBS	PHRJOBS_LCAT_CODE
LEAVE_CATEGORY_DESC	Leave Category Description	Leave category description or title.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
LONGEVITY_ELIGIBILITY	Longevity Eligibility	Indicates eligibility for additional longevity pay.	VARCHAR2(63)		PHRJOBS	PHRJOBS_LGCD_CODE
LONGEVITY_ELIGIBILITY_DESC	Longevity Eligibility Description	Longevity code description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)		NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)		NA	NA
NAME	Name	Combination of the person's first, middle initial, and last name into one value.	VARCHAR2(255)		FUNCTION	MGKFUNC.F_GET_PERSON_INFO
NET_AMOUNT	Net Amount	Total net amount of the event.	NUMBER		PHRHIST	PHRHIST_NET
PAYROLL_CALCULATION_TYPE	Payroll Calculation Type	Indicates if the pay event was calculated manually or by the system.	VARCHAR2(63)		PHRHIST	PHRHIST_CALC_IND
PAYROLL_CALCULATION_TYPE_DESC	Payroll Calculation Type Description	Pay event calculation description.	VARCHAR2(255)		CALCULATION	DECODE(PHRHIST_CALC_IND)
PAYROLL_EVENT_TYPE	Payroll Event Type	Indicates the type of pay event (Manual, Void, Redistribution, etc.).	VARCHAR2(63)		PHRHIST	PHRHIST_TYPE_IND
PAYROLL_EVENT_TYPE_DESC	Payroll Event Type Description	Pay event type description.	VARCHAR2(255)		PHRHIST	PHRHIST_TYPE_DESC
PAYROLL_IDENTIFIER	Payroll Identifier	Pay identification number to which this Employee_Position belongs.	VARCHAR2(63)		PHRHOUR	PHRHOUR_PICT_CODE
PAYROLL_IDENTIFIER_COUNT	Payroll Identifier Count	Number of times the employee has been paid for this payroll identifier.	NUMBER		PHRJOBS	PHRJOBS_PAY_CNT
PAYROLL_IDENTIFIER_DESC	Payroll Identifier Description	Payroll code description or title.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
PAYROLL_NUMBER	Payroll Number	Used to uniquely identify a pay period within a fiscal year.	NUMBER		PHRHOUR	PHRHOUR_PAYNO
PAYROLL_POSITION_ACTIVITY_DATE	Payroll Position Activity Date	Date record was inserted or updated	DATE		PHRJOBS	PHRJOBS_ACTIVITY_DATE
PERSON_UID	Person UID	System generated unique internal identification number assigned to this person.	NUMBER		PHRHOUR	PHRHOUR_PIDM
PER_PAY_SALARY	Period Pay Salary	Salary paid each pay period. Used for deferred pay calculations. Amount Deferred = Employee Position Salary - Per Pay Salary.	NUMBER		PHRJOBS	PHRJOBS_PER_PAY_SALARY
POSITION	Position	Employee Position number.	VARCHAR2(63)		PHRHOUR	PHRHOUR_POSN
POSITION_BEGIN_DATE	Position Begin Date	Date an Employee_Position became effective in the payroll system.	DATE		PHRJOBS	PHRJOBS_EFFECTIVE_DATE
POSITION_CONTRACT_TYPE	Position Contract Type	Indicates whether this is the Primary, Secondary, or Overload position.	VARCHAR2(63)		PHRJOBS	PHRJOBS_CONTRACT_TYPE
POSITION_CONTRACT_TYPE_DESC	Position Contract Type Description	Description of the contract type	VARCHAR2(255)		CALCULATION	DECODE(PHRJOB_CONTRACT_TYPE, 'P', 'PRIMARY', 'S', 'SECONDARY', 'O', 'OVERLOAD')
POSITION_EMPLOYEE_CLASS	Position Employee Class	Employee class code. Organizes position information consistent with employee groupings. At the employee level, it's used to help determine controls for benefits, leave, payroll and self-service rules.	VARCHAR2(63)		PHRJOBS	PHRJOBS_ECLS_CODE
POSITION_EMPLOYEE_CLASS_DESC	Position Employee Class Description	Employee position class description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
POSITION_END_DATE	Position End Date	The date until which this history Employee Position record is effective.	DATE		PHRJOBS	PHRJOBS_EFFECTIVE_UNTIL_DATE
POSITION_STATUS	Position Status	Status of the Employee_Position (Active, Terminated, Leave with Benefits, etc.) at the time of the pay event.	VARCHAR2(63)		PHRJOBS	PHRJOBS_STATUS
POSITION_STATUS_DESC	Position Status Description	Position status description.	VARCHAR2(255)		CALCULATION	DECODE(NBRJOBS_STATUS)
POSITION_TITLE	Position Title	Description of the Employee_Position. Defaults from the position title if left blank.	VARCHAR2(255)		NBBPOSN	NBBPOSN_TITLE
POSTING_OVERRIDE_DATE	Posting Override Date	Date the accounting transaction was overriden by the finance process.	DATE		PHRHIST	PHRHIST_POSTING_OVERRIDE_DATE
PREMIUM_PAY_CATEGORY	Premium Pay Category	Controls premium pay generation.	VARCHAR2(63)		PHRJOBS	PHRJOBS_PCAT_CODE
PREMIUM_PAY_CATEGORY_DESC	Premium Pay Category Description	Description of the premium pay category.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
PREVIOUS_FISCAL_YEAR_IND	Previous Fiscal Year Indicator	Indicator if the retro earnings paid are for the previous fiscal year.	VARCHAR2(63)		PHRJOBS	PHRJOBS_PREV_FISCAL_YEAR_IND
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
PUBLIC_RETIREMENT_CONTRIBUTION	Public Retirement Contribution	Public employee retirement contribution code.	VARCHAR2(63)		PHRJOBS	PHRJOBS_PERS_CONT_CODE
PUBLIC_RETIREMENT_CONT_DESC	Public Retirement Contribution Description	Public employee retirement contribution code description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
PUBLIC_RETIREMENT_PAY_RATE	Public Retirement Pay Rate	Public employee retirement pay rate/frequency code.	VARCHAR2(63)		PHRJOBS	PHRJOBS_PERS_PAY_CODE
PUBLIC_RETIRE_PAY_RATE_DESC	Public Retirement Pay Rate Description	Public employee retirement pay rate/frequency description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
SHIFT_NUMBER	Shift Number	Identifies a time period during which the employee works.	VARCHAR2(63)		PHRJOBS	PHRJOBS_SHIFT
SHIFT_PREMIUM_AMOUNT	Shift Premium Amount	The additional amount (above their regular rate) an employee will earn when working this shift number.	NUMBER		PTRSHFT	PTRSHFT_AMOUNT
SHIFT_PREMIUM_PERCENT	Shift Premium Percent	The additional percent (above their regular rate) an employee will earn when working this shift number.	NUMBER		PTRSHFT	PTRSHFT_PERCENT
STATE_RETIREMENT_ASSIGNMENT	State Retirement Assignment	State employee retirement assignment code.	VARCHAR2(63)		PHRJOBS	PHRJOBS_STRS_ASSN_CODE
STATE_RETIREMENT_ASSIGN_DESC	State Retirement Assignment Description	State employee retirement assignment code description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
STATE_RETIREMENT_CONTRIBUTION	State Retirement Contribution	State employee retirement contribution code.	VARCHAR2(63)		PHRJOBS	PHRJOBS_STRS_CONT_CODE
STATE_RETIREMENT_CONT_DESC	State Retirement Contribution Description	State employee retirement contribution code description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
STATE_RETIREMENT_PAY_RATE	State Retirement Pay Rate	State employee retirement pay rate/frequency code.	VARCHAR2(63)		PHRJOBS	PHRJOBS_STRS_PAY_CODE
STATE_RETIREMENT_PAY_RATE_DESC	State Retirement Pay Rate Description	State employee retirement pay rate/frequency description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
SUPPLEMENTAL_PAY_DATE	Supplemental Pay Date	The date that the update payroll was run for supplemental pay or adjustments..	DATE		PHRHIST	PHRHIST_UPDT_DATE
SYSTEM_GENERATED_IND	System Generated Indicator	Indicates if the pay event was calculated manually or by the system.	VARCHAR2(1)		PHRHOUR	PHRHOUR_GEN_IND
TIMESHEET_ACTIVITY_DATE	Timesheet Activity Date	Date record was inserted or updated	DATE		PHRHOUR	PHRHOUR_ACTIVITY_DATE
TIMESHEET_CHART_DESC	Timesheet Chart Description	Chart of accounts code description or title.	VARCHAR2(255)		FTVCOAS	FTVCOAS_TITLE
TIMESHEET_CHART_OF_ACCOUNTS	Timesheet Chart Of Accounts	Timesheet chart of accounts.	VARCHAR2(63)		PHRJOBS	PHRJOBS_COAS_CODE_TS
TIMESHEET_METHOD	Timesheet Method	Determines the method by which the timesheet is entered in they system.	VARCHAR2(63)		PHRJOBS	PHRJOBS_TS_ROSTER_IND
TIMESHEET_METHOD_DESC	Timesheet Method Description	Timesheet method description.	VARCHAR2(255)		CALCULATION	DECODE(PHRJOBS_TS_ROSTER_IND)
TIMESHEET_ORGANIZATION	Timesheet Organization	Organization to which the time sheet for this position is sent.	VARCHAR2(63)		PHRJOBS	PHRJOBS_ORGN_CODE_TS
TIMESHEET_ORGANIZATION_DESC	Timesheet Organization Description	Organization to which this Employee_Position's time sheet is sent.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
TIME_ENTRY_PERIOD_BEGIN_DATE	Time Entry Period Begin Date	Begin date of the timesheet entry period. This period is determined by the value in the Time Entry Type.	DATE		PHRHOUR	PHRHOUR_BEGIN_DATE
TIME_ENTRY_PERIOD_END_DATE	Time Entry Period End Date	End date of the timesheet entry period. This period is determined by the value in the Time Entry Type.	DATE		PHRHOUR	PHRHOUR_END_DATE
TIME_ENTRY_TYPE	Time Entry Type	Type of or frequency of time entry.	VARCHAR2(63)		PHRJOBS	PHRJOBS_TIME_ENTRY_IND
TIME_ENTRY_TYPE_DESC	Time Entry Type Description	Description of the time entry type.	VARCHAR2(255)		CALCULATION	DECODE(PHRJOBS_TIME_ENTRY_IND)
UNEMPLOY_INSURANCE_EXCEPTION	Unemployment Insurance Exception	Associated with insurable earnings by pay period.	VARCHAR2(63)		PHRHIST	PHRHIST_UI_EXCEPTION_IND
UNEMPLOY_INSURANCE_WEEKS	Unemployment Insurance Weeks	Unemployment Insurance insurable for this pay period.	NUMBER		PHRHIST	PHRHIST_UI_WEEKS

Ver: 9.0