Reporting View Source: PHRHOUR

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**
Source Column	Source Form	Target Type	Target	Target Column
PHRHOUR_ACTIVITY_DATE	PHAHOUR	REPORTING VIEW	PAYROLL_POSITION_TIMESHEET PAYROLL_TIMESHEET	TIMESHEET_ACTIVITY_DATE ACTIVITY_DATE
PHRHOUR_AMT	PHAHOUR	REPORTING VIEW	PAYROLL_POSITION_TIMESHEET PAYROLL_TIMESHEET	GROSS_EARNINGS GROSS_EARNINGS
PHRHOUR_BEGIN_DATE	NA	REPORTING VIEW	PAYROLL_POSITION_TIMESHEET PAYROLL_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_TIMESHEET PAYROLL_POSITION_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_POSITION_TIMESHEET PAYROLL_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_POSITION_TIMESHEET PAYROLL_TIMESHEET	PAYROLL_IDENTIFIER PAYROLL_IDENTIFIER
PHRHOUR_PIDM	PHAHOUR	REPORTING VIEW	PAYROLL_TIMESHEET PAYROLL_POSITION_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_POSITION_TIMESHEET PAYROLL_TIMESHEET	JOB_SUFFIX JOB_SUFFIX
PHRHOUR_YEAR	PHAHOUR	REPORTING VIEW	PAYROLL_POSITION_TIMESHEET PAYROLL_TIMESHEET	CALENDAR_YEAR CALENDAR_YEAR

Ver: 9.0