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