Composite View Source: PHRHOUR

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Reporting View Source: PHRHOUR Human Resources

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column
PHRHOUR_ACTIVITY_DATE	PHAHOUR	COMPOSITE VIEW	AP_PAYROLL_TIMESHEET	ACTIVITY_DATE
PHRHOUR_AMT	PHAHOUR	COMPOSITE VIEW	AP_PAYROLL_TIMESHEET	GROSS_EARNINGS
PHRHOUR_BEGIN_DATE	NA	COMPOSITE VIEW	AP_PAYROLL_TIMESHEET	TIME_ENTRY_PERIOD_BEGIN_DATE
PHRHOUR_EARN_CODE	PHAHOUR	COMPOSITE VIEW	AP_PAYROLL_TIMESHEET	EARNINGS
PHRHOUR_EFFECTIVE_DATE	PHAHOUR	COMPOSITE VIEW	AP_PAYROLL_TIMESHEET	EFFECTIVE_DATE
PHRHOUR_END_DATE	NA	COMPOSITE VIEW	AP_PAYROLL_TIMESHEET	TIME_ENTRY_PERIOD_END_DATE
PHRHOUR_GEN_IND	PHAHOUR	COMPOSITE VIEW	AP_PAYROLL_TIMESHEET	SYSTEM_GENERATED_IND
PHRHOUR_HRS	PHAHOUR	COMPOSITE VIEW	AP_PAYROLL_TIMESHEET	HOURS_WORKED
PHRHOUR_PAYNO	PHAHOUR	COMPOSITE VIEW	AP_PAYROLL_TIMESHEET	PAYROLL_NUMBER
PHRHOUR_PICT_CODE	PHAHOUR	COMPOSITE VIEW	AP_PAYROLL_TIMESHEET	PAYROLL_IDENTIFIER
PHRHOUR_PIDM	PHAHOUR	COMPOSITE VIEW	AP_PAYROLL_TIMESHEET	PERSON_UID
PHRHOUR_POSN	PHAHOUR	COMPOSITE VIEW	AP_PAYROLL_TIMESHEET	POSITION
PHRHOUR_SEQ_NO	PHAHOUR	COMPOSITE VIEW	AP_PAYROLL_TIMESHEET	EVENT_SEQUENCE_NUMBER
PHRHOUR_SHIFT	PHAHOUR
PHRHOUR_SUFF	PHAHOUR	COMPOSITE VIEW	AP_PAYROLL_TIMESHEET	JOB_SUFFIX
PHRHOUR_YEAR	PHAHOUR	COMPOSITE VIEW	AP_PAYROLL_TIMESHEET	CALENDAR_YEAR

Ver: