Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Human Resources Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: PAYROLL_EMPLOYEE_POSITION

Description Contains payroll history and related job history information specific to each payroll.
Key & Frequency One row per payroll identifier per calendar year per payroll number per event sequence number per position per job suffix per shift number per person.
Recommended Search Columns CALENDAR_YEAR, PAYROLL_IDENTIFIER, PAYROLL_NUMBER, PERSON_UID, EVENT_SEQUENCE_NUMBER
PERSON_UID, POSITION, JOB_SUFFIX, CALENDAR_YEAR

Target Column Business Definition Database Data Type Source Name Source Column
ADJUST_BY_DATE Date of the pay event that adjusts this pay event. DATE

PHRHIST

PHRHIST_ADJ_BY_DATE

ADJUST_BY_SEQUENCE_NUMBER Sequence number of the pay event that adjusts this pay event. VARCHAR2(63)

PHRHIST

PHRHIST_ADJ_BY_SEQ_NO

ADJUST_DATE Date of the pay event that this event adjusts. DATE

PHRHIST

PHRHIST_ADJS_DATE

ADJUST_SEQUENCE_NUMBER Sequence number of the pay event that this one adjusts. NUMBER

PHRHIST

PHRHIST_ADJS_SEQ_NO

ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

APPOINTMENT_PCT Percentage of position's salary used to calculate employee's salary. NUMBER

PHRJOBS

PHRJOBS_APPT_PCT

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 Regular hours worked during the Pay Period. NUMBER

PHRJOBS

PHRJOBS_BASE_SAL_HRS

CALENDAR_YEAR Pay period calendar year. VARCHAR2(63)

PHRHIST

PHRHIST_YEAR

DEDUCTIONS_AMOUNT Total amount of the deductions from the gross amount. NUMBER

FUNCTION

POKODSF.F_CALC_DEDN_AMT

DEFERRED_PAY_AMOUNT Amount deferred each pay period. NUMBER

PHRJOBS

PHRJOBS_DEFER_AMT

DISPOSITION Status of this pay event through the pay cycle. VARCHAR2(63)

PHRHIST

PHRHIST_DISP

DISPOSITION_DESC Status of the pay event description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

DOCUMENT_DATE Date that will appear on the pay document. DATE

PHRHIST

PHRHIST_EVENT_DATE

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. VARCHAR2(255)

CALCULATION

DECODE(PHRHIST_PRINT_IND)

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 code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

EVENT_SEQUENCE_NUMBER Pay Event Identifying Sequence Number. NUMBER

PHRHIST

PHRHIST_SEQ_NO

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 The salary to be paid each pay period. NUMBER

PHRJOBS

PHRJOBS_FULL_ASSGN_SALARY

FULL_TIME_EQUIVALENCY Full time equivalency assigned to this Employee_Position. NUMBER

PHRJOBS

PHRJOBS_FTE

GROSS_AMOUNT Total gross amount of the event. NUMBER

PHRHIST

PHRHIST_GROSS

HOURLY_RATE Rate of Pay for the Employee Position. NUMBER

PHRJOBS

PHRJOBS_SALARY_RATE

HOURS_PER_DAY The number of hours a person filling this Employee Position normally works in a day. NUMBER

PHRJOBS

PHRJOBS_HRS_DAY

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 Identification number assigned to the person at the time of the specific pay event. VARCHAR2(63)

PHRJOBS

PHRJOBS_ID_SEQ

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

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 to which the employee belongs. VARCHAR2(63)

PHRJOBS

PHRJOBS_LCAT_CODE

LEAVE_CATEGORY_DESC Leave category description or title. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

LONGEVITY_ELIGIBILITY Indicates eligibility for additional longevity pay. VARCHAR2(63)

PHRJOBS

PHRJOBS_LGCD_CODE

LONGEVITY_ELIGIBILITY_DESC Longevity code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

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 Total net amount of the event. NUMBER

PHRHIST

PHRHIST_NET

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 Pay event calculation description. VARCHAR2(255)

CALCULATION

DECODE(PHRHIST_CALC_IND)

PAYROLL_EVENT_TYPE Indicates the type of pay event (Manual, Void, Redistribution, etc.). VARCHAR2(63)

PHRHIST

PHRHIST_TYPE_IND

PAYROLL_EVENT_TYPE_DESC Pay event type description. VARCHAR2(255)

CALCULATION

DECODE(PHRHIST_TYPE_IND)

PAYROLL_IDENTIFIER Pay identification number to which this Employee_Position belongs. VARCHAR2(63)

PHRHIST

PHRHIST_PICT_CODE

PAYROLL_IDENTIFIER_COUNT Number of times the employee has been paid for this payroll identifier. NUMBER

PHRJOBS

PHRJOBS_PAY_CNT

PAYROLL_IDENTIFIER_DESC Payroll code description or title. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

PAYROLL_NUMBER Used to uniquely identify a pay period within a fiscal year. NUMBER

PHRHIST

PHRHIST_PAYNO

PAYROLL_POSITION_ACTIVITY_DATE Date record was inserted or updated. DATE

PHRJOBS

PHRJOBS_ACTIVITY_DATE

PERSON_UID System generated unique internal identification number assigned to this person. NUMBER

PHRHIST

PHRHIST_PIDM

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

POSITION Employee Position number. VARCHAR2(63)

PHRJOBS

PHRJOBS_POSN

POSITION_BEGIN_DATE Date an Employee_Position became effective in the payroll system. DATE

PHRJOBS

PHRJOBS_EFFECTIVE_DATE

POSITION_CONTRACT_TYPE Indicates whether this is the Primary, Secondary, or Overload position. VARCHAR2(63)

PHRJOBS

PHRJOBS_CONTRACT_TYPE

POSITION_CONTRACT_TYPE_DESC Description of the contract type VARCHAR2(255)

CALCULATION

DECODE(PHRJOB_CONTRACT_TYPE, 'P', 'PRIMARY', 'S', 'SECONDARY', 'O', 'OVERLOAD')

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 Employee position class description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

POSITION_END_DATE The date until which this history Employee Position record is effective. DATE

PHRJOBS

PHRJOBS_EFFECTIVE_UNTIL_DATE

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. VARCHAR2(255)

CALCULATION

DECODE(NBRJOBS_STATUS)

POSITION_TITLE Description of the Employee_Position. Defaults from the position title if left blank. VARCHAR2(255)

NBRJOBS

NBRJOBS_DESC

POSTING_OVERRIDE_DATE Date the accounting transaction was overriden by the finance process. DATE

PHRHIST

PHRHIST_POSTING_OVERRIDE_DATE

PREMIUM_PAY_CATEGORY Controls premium pay generation. VARCHAR2(63)

PHRJOBS

PHRJOBS_PCAT_CODE

PREMIUM_PAY_CATEGORY_DESC Description of the premium pay category. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

PREVIOUS_FISCAL_YEAR_IND Indicator if the retro earnings paid are for the previous fiscal year. VARCHAR2(63)

PHRJOBS

PHRJOBS_PREV_FISCAL_YEAR_IND

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 employee retirement contribution code. VARCHAR2(63)

PHRJOBS

PHRJOBS_PERS_CONT_CODE

PUBLIC_RETIREMENT_CONT_DESC Public employee retirement contribution code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

PUBLIC_RETIREMENT_PAY_RATE Public employee retirement pay rate/frequency code. VARCHAR2(63)

PHRJOBS

PHRJOBS_PERS_PAY_CODE

PUBLIC_RETIRE_PAY_RATE_DESC Public employee retirement pay rate/frequency description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SHIFT_NUMBER Identifies a time period during which the employee works. VARCHAR2(63)

PHRJOBS

PHRJOBS_SHIFT

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 The additional percent (above their regular rate) an employee will earn when working this shift number. NUMBER

PTRSHFT

PTRSHFT_PERCENT

STATE_RETIREMENT_ASSIGNMENT State employee retirement assignment code. VARCHAR2(63)

PHRJOBS

PHRJOBS_STRS_ASSN_CODE

STATE_RETIREMENT_ASSIGN_DESC State employee retirement assignment code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

STATE_RETIREMENT_CONTRIBUTION State employee retirement contribution code. VARCHAR2(63)

PHRJOBS

PHRJOBS_STRS_CONT_CODE

STATE_RETIREMENT_CONT_DESC State employee retirement contribution code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

STATE_RETIREMENT_PAY_RATE State employee retirement pay rate/frequency code. VARCHAR2(63)

PHRJOBS

PHRJOBS_STRS_PAY_CODE

STATE_RETIREMENT_PAY_RATE_DESC State employee retirement pay rate/frequency description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SUPPLEMENTAL_PAY_DATE The date that the update payroll was run for supplemental pay or adjustments.. DATE

PHRHIST

PHRHIST_UPDT_DATE

TIMESHEET_CHART_DESC Chart of accounts code description or title. VARCHAR2(255)

FTVCOAS

FTVCOAS_TITLE

TIMESHEET_CHART_OF_ACCOUNTS Timesheet chart of accounts. VARCHAR2(63)

PHRJOBS

PHRJOBS_COAS_CODE_TS

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. VARCHAR2(255)

CALCULATION

DECODE(PHRJOBS_TS_ROSTER_IND)

TIMESHEET_ORGANIZATION Organization to which the time sheet for this position is sent. VARCHAR2(63)

PHRJOBS

PHRJOBS_ORGN_CODE_TS

TIMESHEET_ORGANIZATION_DESC Organization to which this Employee_Position's time sheet is sent. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

TIME_ENTRY_TYPE Type of or frequency of time entry. VARCHAR2(63)

PHRJOBS

PHRJOBS_TIME_ENTRY_IND

TIME_ENTRY_TYPE_DESC Description of the time entry type. VARCHAR2(255)

CALCULATION

DECODE(PHRJOBS_TIME_ENTRY_IND)

UNEMPLOY_INSURANCE_EXCEPTION Associated with insurable earnings by pay period. VARCHAR2(63)

PHRHIST

PHRHIST_UI_EXCEPTION_IND

UNEMPLOY_INSURANCE_WEEKS Unemployment Insurance insurable for this pay period. NUMBER

PHRHIST

PHRHIST_UI_WEEKS



Ver: 8.0