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

Banner Operational Data Store
Reporting View Target: PAYROLL_TIMESHEET

Description Contains timesheet information pertaining to specific pay periods.
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, POSITION, JOB_SUFFIX, EFFECTIVE_DATE, EARNINGS, EVENT_SEQUENCE_NUMBER

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
ACTIVITY_DATE Date record was inserted or updated. DATE

PHRHOUR

PHRHOUR_ACTIVITY_DATE

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
CALENDAR_YEAR Pay period calendar year. VARCHAR2(63)

PHRHOUR

PHRHOUR_YEAR

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
EVENT_SEQUENCE_NUMBER Pay Event Identifying Sequence Number. NUMBER

PHRHOUR

PHRHOUR_SEQ_NO

NO

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

PHRHOUR

PHRHOUR_AMT

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
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
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
PAYROLL_IDENTIFIER Pay identification number to which this Employee_Position belongs. VARCHAR2(63)

PHRHOUR

PHRHOUR_PICT_CODE

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
PERSON_UID System generated unique internal identification number assigned to this person. NUMBER

PHRHOUR

PHRHOUR_PIDM

NO

NO
POSITION Employee Position number. VARCHAR2(63)

PHRHOUR

PHRHOUR_POSN

NO

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

NBBPOSN

NBBPOSN_TITLE

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
SHIFT_NUMBER Shift Associated with Earnings Code. VARCHAR2(63)

PHRHOUR

PHRHOUR_SHIFT

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


Ver: 9.2