Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
ADJUST_BY_DATE
|
Date of the pay event that adjusts this pay event.
|
DATE
|
PHRHIST
|
PHRHIST_ADJ_BY_DATE
|
NO
|
NO
|
ADJUST_BY_SEQUENCE_NUMBER
|
Sequence number of the pay event that adjusts this pay event.
|
VARCHAR2(63)
|
PHRHIST
|
PHRHIST_ADJ_BY_SEQ_NO
|
NO
|
NO
|
ADJUST_DATE
|
Date of the pay event that this event adjusts.
|
DATE
|
PHRHIST
|
PHRHIST_ADJS_DATE
|
NO
|
NO
|
ADJUST_SEQUENCE_NUMBER
|
Sequence number of the pay event that this one adjusts.
|
NUMBER
|
PHRHIST
|
PHRHIST_ADJS_SEQ_NO
|
NO
|
NO
|
ADMINISTRATIVE_GROUP
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
APPOINTMENT_PCT
|
Percentage of position's salary used to calculate employee's salary.
|
NUMBER
|
PHRJOBS
|
PHRJOBS_APPT_PCT
|
NO
|
NO
|
ASSOCIATED_SEQUENCE_NUMBER
|
The sequence of the event that corresponds to this event for two step adjustments.
|
NUMBER
|
PHRHIST
|
PHRHIST_ASSOC_SEQ_NO
|
NO
|
NO
|
BASE_SALARY_HOURS
|
Regular hours worked during the Pay Period.
|
NUMBER
|
PHRJOBS
|
PHRJOBS_BASE_SAL_HRS
|
NO
|
NO
|
CALENDAR_YEAR
|
Pay period calendar year.
|
VARCHAR2(63)
|
PHRHIST
|
PHRHIST_YEAR
|
NO
|
NO
|
DEDUCTIONS_AMOUNT
|
Total amount of the deductions from the gross amount.
|
NUMBER
|
FUNCTION
|
POKODSF.F_CALC_DEDN_AMT
|
NO
|
NO
|
DEFERRED_PAY_AMOUNT
|
Amount deferred each pay period.
|
NUMBER
|
PHRJOBS
|
PHRJOBS_DEFER_AMT
|
NO
|
NO
|
DISPOSITION
|
Status of this pay event through the pay cycle.
|
VARCHAR2(63)
|
PHRHIST
|
PHRHIST_DISP
|
NO
|
NO
|
DISPOSITION_DESC
|
Status of the pay event description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
DOCUMENT_DATE
|
Date that will appear on the pay document.
|
DATE
|
PHRHIST
|
PHRHIST_EVENT_DATE
|
NO
|
NO
|
DOCUMENT_PRINT_METHOD
|
Indicates if the event was manually printed outside of the sytem.
|
VARCHAR2(63)
|
PHRHIST
|
PHRHIST_PRINT_IND
|
NO
|
NO
|
DOCUMENT_PRINT_METHOD_DESC
|
Document print method description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(PHRHIST_PRINT_IND)
|
NO
|
NO
|
EMPLOYEE_CLASS_TYPE
|
Identifies a type of employee class that is potentially eligible for a shift premium.
|
VARCHAR2(63)
|
PTRECLS
|
PTRECLS_SHCD_CODE
|
NO
|
NO
|
EMPLOYEE_CLASS_TYPE_DESC
|
Employee class type code description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
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
|
NO
|
NO
|
EMPLOYER_DESC
|
Employer description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
EVENT_SEQUENCE_NUMBER
|
Pay Event Identifying Sequence Number.
|
NUMBER
|
PHRHIST
|
PHRHIST_SEQ_NO
|
NO
|
NO
|
FIRST_NAME_HISTORY
|
First name of the person at the time of the pay event.
|
VARCHAR2(63)
|
PHRJOBS
|
PHRJOBS_FIRST_NAME_SEQ
|
NO
|
NO
|
FULL_ASSIGNMENT_SALARY
|
The salary to be paid each pay period.
|
NUMBER
|
PHRJOBS
|
PHRJOBS_FULL_ASSGN_SALARY
|
NO
|
NO
|
FULL_TIME_EQUIVALENCY
|
Full time equivalency assigned to this Employee_Position.
|
NUMBER
|
PHRJOBS
|
PHRJOBS_FTE
|
NO
|
NO
|
GROSS_AMOUNT
|
Total gross amount of the event.
|
NUMBER
|
PHRHIST
|
PHRHIST_GROSS
|
NO
|
NO
|
HOURLY_RATE
|
Rate of Pay for the Employee Position.
|
NUMBER
|
PHRJOBS
|
PHRJOBS_SALARY_RATE
|
NO
|
NO
|
HOURS_PER_DAY
|
The number of hours a person filling this Employee Position normally works in a day.
|
NUMBER
|
PHRJOBS
|
PHRJOBS_HRS_DAY
|
NO
|
NO
|
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
|
NO
|
NO
|
ID_HISTORY
|
Identification number assigned to the person at the time of the specific pay event.
|
VARCHAR2(63)
|
PHRJOBS
|
PHRJOBS_ID_SEQ
|
NO
|
NO
|
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)
|
PHRJOBS
|
PHRJOBS_SUFF
|
NO
|
NO
|
LAST_NAME_HISTORY
|
Last name of the person at the time of the specific pay event.
|
VARCHAR2(63)
|
PHRJOBS
|
PHRJOBS_LAST_NAME_SEQ
|
NO
|
NO
|
LEAVE_CATEGORY
|
Leave category to which the employee belongs.
|
VARCHAR2(63)
|
PHRJOBS
|
PHRJOBS_LCAT_CODE
|
NO
|
NO
|
LEAVE_CATEGORY_DESC
|
Leave category description or title.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
LONGEVITY_ELIGIBILITY
|
Indicates eligibility for additional longevity pay.
|
VARCHAR2(63)
|
PHRJOBS
|
PHRJOBS_LGCD_CODE
|
NO
|
NO
|
LONGEVITY_ELIGIBILITY_DESC
|
Longevity code description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
MULTI_SOURCE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
MULTI_SOURCE_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
NAME
|
Combination of the person's first, middle initial, and last name into one value.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
NET_AMOUNT
|
Total net amount of the event.
|
NUMBER
|
PHRHIST
|
PHRHIST_NET
|
NO
|
NO
|
PAYROLL_CALCULATION_TYPE
|
Indicates if the pay event was calculated manually or by the system.
|
VARCHAR2(63)
|
PHRHIST
|
PHRHIST_CALC_IND
|
NO
|
NO
|
PAYROLL_CALCULATION_TYPE_DESC
|
Pay event calculation description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(PHRHIST_CALC_IND)
|
NO
|
NO
|
PAYROLL_EVENT_TYPE
|
Indicates the type of pay event (Manual, Void, Redistribution, etc.).
|
VARCHAR2(63)
|
PHRHIST
|
PHRHIST_TYPE_IND
|
NO
|
NO
|
PAYROLL_EVENT_TYPE_DESC
|
Pay event type description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(PHRHIST_TYPE_IND)
|
NO
|
NO
|
PAYROLL_IDENTIFIER
|
Pay identification number to which this Employee_Position belongs.
|
VARCHAR2(63)
|
PHRHIST
|
PHRHIST_PICT_CODE
|
NO
|
NO
|
PAYROLL_IDENTIFIER_COUNT
|
Number of times the employee has been paid for this payroll identifier.
|
NUMBER
|
PHRJOBS
|
PHRJOBS_PAY_CNT
|
NO
|
NO
|
PAYROLL_IDENTIFIER_DESC
|
Payroll code description or title.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
PAYROLL_NUMBER
|
Used to uniquely identify a pay period within a fiscal year.
|
NUMBER
|
PHRHIST
|
PHRHIST_PAYNO
|
NO
|
NO
|
PAYROLL_POSITION_ACTIVITY_DATE
|
Date record was inserted or updated.
|
DATE
|
PHRJOBS
|
PHRJOBS_ACTIVITY_DATE
|
NO
|
NO
|
PERSON_UID
|
System generated unique internal identification number assigned to this person.
|
NUMBER
|
PHRHIST
|
PHRHIST_PIDM
|
NO
|
NO
|
PER_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
|
NO
|
NO
|
POSITION
|
Employee Position number.
|
VARCHAR2(63)
|
PHRJOBS
|
PHRJOBS_POSN
|
NO
|
NO
|
POSITION_BEGIN_DATE
|
Date an Employee_Position became effective in the payroll system.
|
DATE
|
PHRJOBS
|
PHRJOBS_EFFECTIVE_DATE
|
NO
|
NO
|
POSITION_CONTRACT_TYPE
|
Indicates whether this is the Primary, Secondary, or Overload position.
|
VARCHAR2(63)
|
PHRJOBS
|
PHRJOBS_CONTRACT_TYPE
|
NO
|
NO
|
POSITION_CONTRACT_TYPE_DESC
|
Description of the contract type.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(PHRJOB_CONTRACT_TYPE, 'P', 'PRIMARY', 'S', 'SECONDARY', 'O', 'OVERLOAD')
|
NO
|
NO
|
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
|
NO
|
NO
|
POSITION_EMPLOYEE_CLASS_DESC
|
Employee position class description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
POSITION_END_DATE
|
The date until which this history Employee Position record is effective.
|
DATE
|
PHRJOBS
|
PHRJOBS_EFFECTIVE_UNTIL_DATE
|
NO
|
NO
|
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
|
NO
|
NO
|
POSITION_STATUS_DESC
|
Position status description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(NBRJOBS_STATUS)
|
NO
|
NO
|
POSITION_TITLE
|
Description of the Employee_Position. Defaults from the position title if left blank.
|
VARCHAR2(255)
|
NBRJOBS
|
NBRJOBS_DESC
|
NO
|
NO
|
POSTING_OVERRIDE_DATE
|
Date the accounting transaction was overriden by the finance process.
|
DATE
|
PHRHIST
|
PHRHIST_POSTING_OVERRIDE_DATE
|
NO
|
NO
|
PREMIUM_PAY_CATEGORY
|
Controls premium pay generation.
|
VARCHAR2(63)
|
PHRJOBS
|
PHRJOBS_PCAT_CODE
|
NO
|
NO
|
PREMIUM_PAY_CATEGORY_DESC
|
Description of the premium pay category.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
PREVIOUS_FISCAL_YEAR_IND
|
Indicator if the retro earnings paid are for the previous fiscal year.
|
VARCHAR2(63)
|
PHRJOBS
|
PHRJOBS_PREV_FISCAL_YEAR_IND
|
NO
|
NO
|
PROCESS_GROUP
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
PUBLIC_RETIREMENT_CONTRIBUTION
|
Public employee retirement contribution code.
|
VARCHAR2(63)
|
PHRJOBS
|
PHRJOBS_PERS_CONT_CODE
|
NO
|
NO
|
PUBLIC_RETIREMENT_CONT_DESC
|
Public employee retirement contribution code description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
PUBLIC_RETIREMENT_PAY_RATE
|
Public employee retirement pay rate/frequency code.
|
VARCHAR2(63)
|
PHRJOBS
|
PHRJOBS_PERS_PAY_CODE
|
NO
|
NO
|
PUBLIC_RETIRE_PAY_RATE_DESC
|
Public employee retirement pay rate/frequency description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
SHIFT_NUMBER
|
Identifies a time period during which the employee works.
|
VARCHAR2(63)
|
PHRJOBS
|
PHRJOBS_SHIFT
|
NO
|
NO
|
SHIFT_PREMIUM_AMOUNT
|
The additional amount (above their regular rate) an employee will earn when working this shift number.
|
NUMBER
|
PTRSHFT
|
PTRSHFT_AMOUNT
|
NO
|
NO
|
SHIFT_PREMIUM_PERCENT
|
The additional percent (above their regular rate) an employee will earn when working this shift number.
|
NUMBER
|
PTRSHFT
|
PTRSHFT_PERCENT
|
NO
|
NO
|
STATE_RETIREMENT_ASSIGNMENT
|
State employee retirement assignment code.
|
VARCHAR2(63)
|
PHRJOBS
|
PHRJOBS_STRS_ASSN_CODE
|
NO
|
NO
|
STATE_RETIREMENT_ASSIGN_DESC
|
State employee retirement assignment code description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
STATE_RETIREMENT_CONTRIBUTION
|
State employee retirement contribution code.
|
VARCHAR2(63)
|
PHRJOBS
|
PHRJOBS_STRS_CONT_CODE
|
NO
|
NO
|
STATE_RETIREMENT_CONT_DESC
|
State employee retirement contribution code description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
STATE_RETIREMENT_PAY_RATE
|
State employee retirement pay rate/frequency code.
|
VARCHAR2(63)
|
PHRJOBS
|
PHRJOBS_STRS_PAY_CODE
|
NO
|
NO
|
STATE_RETIREMENT_PAY_RATE_DESC
|
State employee retirement pay rate/frequency description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
SUPPLEMENTAL_PAY_DATE
|
The date that the update payroll was run for supplemental pay or adjustments..
|
DATE
|
PHRHIST
|
PHRHIST_UPDT_DATE
|
NO
|
NO
|
TIMESHEET_CHART_DESC
|
Chart of accounts code description or title.
|
VARCHAR2(255)
|
FTVCOAS
|
FTVCOAS_TITLE
|
NO
|
NO
|
TIMESHEET_CHART_OF_ACCOUNTS
|
Timesheet chart of accounts.
|
VARCHAR2(63)
|
PHRJOBS
|
PHRJOBS_COAS_CODE_TS
|
NO
|
NO
|
TIMESHEET_METHOD
|
Determines the method by which the timesheet is entered in they system.
|
VARCHAR2(63)
|
PHRJOBS
|
PHRJOBS_TS_ROSTER_IND
|
NO
|
NO
|
TIMESHEET_METHOD_DESC
|
Timesheet method description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(PHRJOBS_TS_ROSTER_IND)
|
NO
|
NO
|
TIMESHEET_ORGANIZATION
|
Organization to which the time sheet for this position is sent.
|
VARCHAR2(63)
|
PHRJOBS
|
PHRJOBS_ORGN_CODE_TS
|
NO
|
NO
|
TIMESHEET_ORGANIZATION_DESC
|
Organization to which this Employee_Position's time sheet is sent.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
TIME_ENTRY_TYPE
|
Type of or frequency of time entry.
|
VARCHAR2(63)
|
PHRJOBS
|
PHRJOBS_TIME_ENTRY_IND
|
NO
|
NO
|
TIME_ENTRY_TYPE_DESC
|
Description of the time entry type.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(PHRJOBS_TIME_ENTRY_IND)
|
NO
|
NO
|
UNEMPLOY_INSURANCE_EXCEPTION
|
Associated with insurable earnings by pay period.
|
VARCHAR2(63)
|
PHRHIST
|
PHRHIST_UI_EXCEPTION_IND
|
NO
|
NO
|
UNEMPLOY_INSURANCE_WEEKS
|
Unemployment Insurance insurable for this pay period.
|
NUMBER
|
PHRHIST
|
PHRHIST_UI_WEEKS
|
NO
|
NO
|