Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Human Resources Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: PAYROLL_POSITION_TIMESHEET

Description Contains payroll history, related job history and timesheet information specific to each payroll.
Key & Frequency One row per calendar year per payroll identifier per payroll number per system generated indicator per person per event sequence number per position per job suffix per position begin date per earnings per shift number per time entry period begin date.
Recommended Search Columns CALENDAR_YEAR, PAYROLL_IDENTIFIER, PAYROLL_NUMBER, PERSON_UID, EVENT_SEQUENCE_NUMBER
PERSON_UID, POSITION, JOB_SUFFIX, CALENDAR_YEAR
CALENDAR_YEAR, PAYROLL_IDENTIFIER, PAYROLL_NUMBER, PERSON_UID, POSITION, JOB_SUFFIX, EFFECTIVE_DATE, EARNINGS, EVENT_SEQUENCE_NUMBER

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 Administrative-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)

PHRHOUR

PHRHOUR_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)

EARNINGS Earnings Code. VARCHAR2(63)

PHRHOUR

PHRHOUR_EARN_CODE

EARNINGS_DESC Earnings code long description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

EFFECTIVE_DATE Date on which the history earnings record becomes effective. DATE

PHRHOUR

PHRHOUR_EFFECTIVE_DATE

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

PHRHOUR

PHRHOUR_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

GROSS_EARNINGS Gross earnings for this employee for this earnings code during the time entry period. NUMBER

PHRHOUR

PHRHOUR_AMT

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

HOURS_WORKED Number of hours worked during the time entry period. NUMBER

PHRHOUR

PHRHOUR_HRS

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)

PHRHOUR

PHRHOUR_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)

PHRHIST

PHRHIST_TYPE_DESC

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

PHRHOUR

PHRHOUR_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

PHRHOUR

PHRHOUR_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

PHRHOUR

PHRHOUR_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)

PHRHOUR

PHRHOUR_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)

NBBPOSN

NBBPOSN_TITLE

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

SYSTEM_GENERATED_IND Indicates if the pay event was calculated manually or by the system. VARCHAR2(1)

PHRHOUR

PHRHOUR_GEN_IND

TIMESHEET_ACTIVITY_DATE Date record was inserted or updated. DATE

PHRHOUR

PHRHOUR_ACTIVITY_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_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 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 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.5