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**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
PHREARN_ACCRUE_SENIORITY_IND	NA	REPORTING VIEW	PAYROLL_EARNING	SENIORITY_ACCRUED_IND	NA
PHREARN_ACTIVITY_DATE	NA	REPORTING VIEW	PAYROLL_EARNING	PAYROLL_EARNING_ACTIVITY_DATE
PHREARN_AMT	PHAHOUR	REPORTING VIEW	PAYROLL_EARNING	EARNINGS_AMOUNT	NA
PHREARN_COAS_CODE_TS	NA	REPORTING VIEW	PAYROLL_EARNING	TIMESHEET_CHART_OF_ACCOUNTS	NA
PHREARN_DEEMED_HRS	NA	REPORTING VIEW	PAYROLL_EARNING	EMPLOYMENT_INSURANCE_HOURS	NA
PHREARN_EARN_CODE	PHAHOUR	REPORTING VIEW	PAYROLL_EARNING	EARNINGS	NA
PHREARN_EFFECTIVE_DATE	PHICHEK	REPORTING VIEW	PAYROLL_EARNING	POSITION_BEGIN_DATE	NA
PHREARN_GEN_IND	NA	REPORTING VIEW	PAYROLL_EARNING	GENERATED_IND
PHREARN_HRS	PHAHOUR	REPORTING VIEW	PAYROLL_EARNING	HOURS	NA
PHREARN_ORGN_CODE_TS	NA	REPORTING VIEW	PAYROLL_EARNING	TIMESHEET_ORGANIZATION	NA
PHREARN_PAYNO	PHICHEK	REPORTING VIEW	PAYROLL_EARNING	PAYROLL_NUMBER	NA
PHREARN_PICT_CODE	PHICHEK	REPORTING VIEW	PAYROLL_EARNING	PAYROLL_IDENTIFIER	NA
PHREARN_PIDM	NA	REPORTING VIEW	PAYROLL_EARNING	PERSON_UID	NA
PHREARN_POSN	PHICHEK	REPORTING VIEW	PAYROLL_EARNING	POSITION	NA
PHREARN_RATE	PHAHOUR	REPORTING VIEW	PAYROLL_EARNING	HOURLY_RATE	NA
PHREARN_REDISTRIBUTION_IND	NA	REPORTING VIEW	PAYROLL_EARNING	REDISTRIBUTION_IND	NA
PHREARN_SEQ_NO	PHICHEK	REPORTING VIEW	PAYROLL_EARNING	EVENT_SEQUENCE_NUMBER	NA
PHREARN_SHIFT	PHAHOUR	REPORTING VIEW	PAYROLL_EARNING	SHIFT_NUMBER	NA
PHREARN_SPECIAL_RATE	PHAHOUR	REPORTING VIEW	PAYROLL_EARNING	HOURLY_SPECIAL_RATE	NA
PHREARN_SUFF	NA	REPORTING VIEW	PAYROLL_EARNING	JOB_SUFFIX	NA
PHREARN_TS_ENTRY_SEQ	NA	REPORTING VIEW	PAYROLL_EARNING	TIME_ENTRY_SEQUENCE_NUMBER
PHREARN_TS_ROSTER_IND	NA	REPORTING VIEW	PAYROLL_EARNING	TIMESHEET_METHOD	NA
PHREARN_UPDATE_HRS	NA	REPORTING VIEW	PAYROLL_EARNING	UPDATED_HOURS
PHREARN_USER_ID	NA	REPORTING VIEW	PAYROLL_EARNING PAYROLL_EARNING	PAYROLL_EARNING_USER_ID PRINT_SEQUENCE_NUMBER
PHREARN_YEAR	PHICHEK	REPORTING VIEW	PAYROLL_EARNING	CALENDAR_YEAR	NA

Ver: 8.5