Composite View Source: PHRATND

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

**SGHE Banner Operational Data Store**
Banner Source Column	Source Form	ODS Target	ODS Target Column
PHRATND_ACTIVITY_DATE	PHAHOUR	AP_PAYROLL_ATTENDANCE	ACTIVITY_DATE
PHRATND_ATND_DATE	PHAHOUR	AP_PAYROLL_ATTENDANCE	ABSENCE_DATE
PHRATND_COAS_CODE_TS	PHAHOUR	AP_PAYROLL_ATTENDANCE	TIMESHEET_CHART_OF_ACCOUNTS
PHRATND_EARN_CODE	PHAHOUR	AP_PAYROLL_ATTENDANCE	EARNINGS
PHRATND_EFFECTIVE_DATE	PHAHOUR	AP_PAYROLL_ATTENDANCE	POSITION_BEGIN_DATE
PHRATND_HOURS	PHAHOUR	AP_PAYROLL_ATTENDANCE	HOURS_ABSENT
PHRATND_LEAV_REASON	PHAHOUR	AP_PAYROLL_ATTENDANCE	LEAVE_REASON
PHRATND_ORGN_CODE_TS	PHAHOUR	AP_PAYROLL_ATTENDANCE	TIMESHEET_ORGANIZATION
PHRATND_PAYNO	PHAHOUR	AP_PAYROLL_ATTENDANCE	PAYROLL_NUMBER
PHRATND_PICT_CODE	PHAHOUR	AP_PAYROLL_ATTENDANCE	PAYROLL_IDENTIFIER
PHRATND_PIDM	PHAHOUR	AP_PAYROLL_ATTENDANCE	PERSON_UID
PHRATND_POSN	PHAHOUR	AP_PAYROLL_ATTENDANCE	POSITION
PHRATND_SUFF	PHAHOUR	AP_PAYROLL_ATTENDANCE	JOB_SUFFIX
PHRATND_TS_ROSTER_IND	PHAHOUR	AP_PAYROLL_ATTENDANCE	TIMESHEET_METHOD
PHRATND_YEAR	PHAHOUR	AP_PAYROLL_ATTENDANCE	CALENDAR_YEAR

Ver: 8.3