Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: PHRHOUR Human Resources Reporting View Meta Data Reports
SGHE Banner Operational Data Store Reporting View Source: PHRHOUR - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
PHRHOUR_ACTIVITY_DATE PHAHOUR

REPORTING VIEW

PAYROLL_TIMESHEET

PAYROLL_POSITION_TIMESHEET

ACTIVITY_DATE

TIMESHEET_ACTIVITY_DATE

 
PHRHOUR_AMT PHAHOUR

REPORTING VIEW

PAYROLL_POSITION_TIMESHEET

PAYROLL_TIMESHEET

GROSS_EARNINGS

GROSS_EARNINGS

 
PHRHOUR_BEGIN_DATE NA

REPORTING VIEW

PAYROLL_TIMESHEET

PAYROLL_POSITION_TIMESHEET

TIME_ENTRY_PERIOD_BEGIN_DATE

TIME_ENTRY_PERIOD_BEGIN_DATE

 
PHRHOUR_EARN_CODE PHAHOUR

REPORTING VIEW

PAYROLL_POSITION_TIMESHEET

PAYROLL_TIMESHEET

EARNINGS

EARNINGS

 
PHRHOUR_EFFECTIVE_DATE PHAHOUR

REPORTING VIEW

PAYROLL_POSITION_TIMESHEET

PAYROLL_TIMESHEET

EFFECTIVE_DATE

EFFECTIVE_DATE

 
PHRHOUR_END_DATE NA

REPORTING VIEW

PAYROLL_POSITION_TIMESHEET

PAYROLL_TIMESHEET

TIME_ENTRY_PERIOD_END_DATE

TIME_ENTRY_PERIOD_END_DATE

 
PHRHOUR_GEN_IND PHAHOUR

REPORTING VIEW

PAYROLL_TIMESHEET

PAYROLL_POSITION_TIMESHEET

SYSTEM_GENERATED_IND

SYSTEM_GENERATED_IND

 
PHRHOUR_HRS PHAHOUR

REPORTING VIEW

PAYROLL_POSITION_TIMESHEET

PAYROLL_TIMESHEET

HOURS_WORKED

HOURS_WORKED

 
PHRHOUR_PAYNO PHAHOUR

REPORTING VIEW

PAYROLL_POSITION_TIMESHEET

PAYROLL_TIMESHEET

PAYROLL_NUMBER

PAYROLL_NUMBER

 
PHRHOUR_PICT_CODE PHAHOUR

REPORTING VIEW

PAYROLL_TIMESHEET

PAYROLL_POSITION_TIMESHEET

PAYROLL_IDENTIFIER

PAYROLL_IDENTIFIER

 
PHRHOUR_PIDM PHAHOUR

REPORTING VIEW

PAYROLL_POSITION_TIMESHEET

PAYROLL_TIMESHEET

PERSON_UID

PERSON_UID

 
PHRHOUR_POSN PHAHOUR

REPORTING VIEW

PAYROLL_POSITION_TIMESHEET

PAYROLL_TIMESHEET

POSITION

POSITION

 
PHRHOUR_SEQ_NO PHAHOUR

REPORTING VIEW

PAYROLL_POSITION_TIMESHEET

PAYROLL_TIMESHEET

EVENT_SEQUENCE_NUMBER

EVENT_SEQUENCE_NUMBER

 
PHRHOUR_SHIFT PHAHOUR

REPORTING VIEW

PAYROLL_TIMESHEET

SHIFT_NUMBER

 
PHRHOUR_SUFF PHAHOUR

REPORTING VIEW

PAYROLL_TIMESHEET

PAYROLL_POSITION_TIMESHEET

JOB_SUFFIX

JOB_SUFFIX

 
PHRHOUR_YEAR PHAHOUR

REPORTING VIEW

PAYROLL_TIMESHEET

PAYROLL_POSITION_TIMESHEET

CALENDAR_YEAR

CALENDAR_YEAR

 


Ver: 8.0