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

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

PHRHOUR

PHRHOUR_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
EARNINGS Earnings Code. VARCHAR2(63)

PHRHOUR

PHRHOUR_EARN_CODE

NO

NO
EARNINGS_DESC Earnings code long description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

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

PHRHOUR

PHRHOUR_EFFECTIVE_DATE

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

PHRHOUR

PHRHOUR_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
GROSS_EARNINGS Gross earnings for this employee for this earnings code during the time entry period. NUMBER

PHRHOUR

PHRHOUR_AMT

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
HOURS_WORKED Number of hours worked during the time entry period. NUMBER

PHRHOUR

PHRHOUR_HRS

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)

PHRHOUR

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

PHRHIST

PHRHIST_TYPE_DESC

NO

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

PHRHOUR

PHRHOUR_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

PHRHOUR

PHRHOUR_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

PHRHOUR

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

PHRHOUR

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

NBBPOSN

NBBPOSN_TITLE

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
SYSTEM_GENERATED_IND Indicates if the pay event was calculated manually or by the system. VARCHAR2(1)

PHRHOUR

PHRHOUR_GEN_IND

NO

NO
TIMESHEET_ACTIVITY_DATE Date record was inserted or updated. DATE

PHRHOUR

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

NO

NO
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

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


Ver: 9.2