Reporting View Source: PHREARN

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Composite View Source: PHREARN Human Resources Reporting View Meta Data Reports

**SGHE Banner Operational Data Store**
Banner Source Column	Source Form	ODS Target	ODS Target Column
PHREARN_ACCRUE_SENIORITY_IND	NA	PAYROLL_EARNING	SENIORITY_ACCRUED_IND
PHREARN_AMT	PHAHOUR	PAYROLL_EARNING	EARNINGS_AMOUNT
PHREARN_COAS_CODE_TS	NA	PAYROLL_EARNING	TIMESHEET_CHART_OF_ACCOUNTS
PHREARN_DEEMED_HRS	NA	PAYROLL_EARNING	EMPLOYMENT_INSURANCE_HOURS
PHREARN_EARN_CODE	PHAHOUR	PAYROLL_EARNING	EARNINGS
PHREARN_EFFECTIVE_DATE	PHICHEK	PAYROLL_EARNING	POSITION_BEGIN_DATE
PHREARN_HRS	PHAHOUR	PAYROLL_EARNING	HOURS
PHREARN_ORGN_CODE_TS	NA	PAYROLL_EARNING	TIMESHEET_ORGANIZATION
PHREARN_PAYNO	PHICHEK	PAYROLL_EARNING	PAYROLL_NUMBER
PHREARN_PICT_CODE	PHICHEK	PAYROLL_EARNING	PAYROLL_IDENTIFIER
PHREARN_PIDM	NA	PAYROLL_EARNING	PERSON_UID
PHREARN_POSN	PHICHEK	PAYROLL_EARNING	POSITION
PHREARN_RATE	PHAHOUR	PAYROLL_EARNING	HOURLY_RATE
PHREARN_REDISTRIBUTION_IND	NA	PAYROLL_EARNING	REDISTRIBUTION_IND
PHREARN_SEQ_NO	PHICHEK	PAYROLL_EARNING	EVENT_SEQUENCE_NUMBER
PHREARN_SHIFT	PHAHOUR	PAYROLL_EARNING	SHIFT_NUMBER
PHREARN_SPECIAL_RATE	PHAHOUR	PAYROLL_EARNING	HOURLY_SPECIAL_RATE
PHREARN_SUFF	NA	PAYROLL_EARNING	JOB_SUFFIX
PHREARN_TS_ROSTER_IND	NA	PAYROLL_EARNING	TIMESHEET_METHOD
PHREARN_YEAR	PHICHEK	PAYROLL_EARNING	CALENDAR_YEAR

Ver: 8.3