Reporting View Source: PHRJOBS

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

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
PHRJOBS_ACTIVITY_DATE	PHIJOBS	REPORTING VIEW	PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET	PAYROLL_POSITION_ACTIVITY_DATE PAYROLL_POSITION_ACTIVITY_DATE
PHRJOBS_APPT_PCT	NA	REPORTING VIEW	PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET	APPOINTMENT_PCT APPOINTMENT_PCT	NA
PHRJOBS_BASE_SAL_HRS	NA	REPORTING VIEW	PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET	BASE_SALARY_HOURS BASE_SALARY_HOURS	NA
PHRJOBS_COAS_CODE_TS	PHIJOBS	REPORTING VIEW	PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET	TIMESHEET_CHART_OF_ACCOUNTS TIMESHEET_CHART_OF_ACCOUNTS	NA
PHRJOBS_CONTRACT_TYPE	NA	REPORTING VIEW	PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET	POSITION_CONTRACT_TYPE POSITION_CONTRACT_TYPE	NA
PHRJOBS_DEFER_AMT	NA	REPORTING VIEW	PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION	DEFERRED_PAY_AMOUNT DEFERRED_PAY_AMOUNT	NA
PHRJOBS_ECLS_CODE	PHIJOBS	REPORTING VIEW	PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET	POSITION_EMPLOYEE_CLASS POSITION_EMPLOYEE_CLASS	NA
PHRJOBS_EFFECTIVE_DATE	PHIJOBS	REPORTING VIEW	PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION	POSITION_BEGIN_DATE POSITION_BEGIN_DATE	NA
PHRJOBS_EFFECTIVE_UNTIL_DATE	NA	REPORTING VIEW	PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION	POSITION_END_DATE POSITION_END_DATE	NA
PHRJOBS_EMPR_CODE	NA	REPORTING VIEW	PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET	EMPLOYER EMPLOYER	NA
PHRJOBS_FIRST_NAME_SEQ	PHIJOBS	REPORTING VIEW	PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET	FIRST_NAME_HISTORY FIRST_NAME_HISTORY	NA
PHRJOBS_FTE	NA	REPORTING VIEW	PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET	FULL_TIME_EQUIVALENCY FULL_TIME_EQUIVALENCY	NA
PHRJOBS_FULL_ASSGN_SALARY	NA	REPORTING VIEW	PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET	FULL_ASSIGNMENT_SALARY FULL_ASSIGNMENT_SALARY	NA
PHRJOBS_HRS_DAY	NA	REPORTING VIEW	PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION	HOURS_PER_DAY HOURS_PER_DAY	NA
PHRJOBS_ID_SEQ	PHIJOBS	REPORTING VIEW	PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION	ID_HISTORY ID_HISTORY	NA
PHRJOBS_LAST_NAME_SEQ	PHIJOBS	REPORTING VIEW	PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION	LAST_NAME_HISTORY LAST_NAME_HISTORY	NA
PHRJOBS_LCAT_CODE	NA	REPORTING VIEW	PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET	LEAVE_CATEGORY LEAVE_CATEGORY	NA
PHRJOBS_LGCD_CODE	NA	REPORTING VIEW	PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET	LONGEVITY_ELIGIBILITY LONGEVITY_ELIGIBILITY	NA
PHRJOBS_ORGN_CODE_TS	PHIJOBS	REPORTING VIEW	PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION	TIMESHEET_ORGANIZATION TIMESHEET_ORGANIZATION	NA
PHRJOBS_PAY_CNT	NA	REPORTING VIEW	PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION	PAYROLL_IDENTIFIER_COUNT PAYROLL_IDENTIFIER_COUNT	NA
PHRJOBS_PCAT_CODE	NA	REPORTING VIEW	PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION	PREMIUM_PAY_CATEGORY PREMIUM_PAY_CATEGORY	NA
PHRJOBS_PERS_CONT_CODE	NA	REPORTING VIEW	PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET	PUBLIC_RETIREMENT_CONTRIBUTION PUBLIC_RETIREMENT_CONTRIBUTION	NA
PHRJOBS_PERS_PAY_CODE	NA	REPORTING VIEW	PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION	PUBLIC_RETIREMENT_PAY_RATE PUBLIC_RETIREMENT_PAY_RATE	NA
PHRJOBS_PER_PAY_SALARY	NA	REPORTING VIEW	PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET	PER_PAY_SALARY PER_PAY_SALARY	NA
PHRJOBS_POSN	PHIJOBS	REPORTING VIEW	PAYROLL_EMPLOYEE_POSITION	POSITION	NA
PHRJOBS_PREV_FISCAL_YEAR_IND	NA	REPORTING VIEW	PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION	PREVIOUS_FISCAL_YEAR_IND PREVIOUS_FISCAL_YEAR_IND	NA
PHRJOBS_SALARY_RATE	NA	REPORTING VIEW	PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION	HOURLY_RATE HOURLY_RATE	NA
PHRJOBS_SHIFT	NA	REPORTING VIEW	PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION	SHIFT_NUMBER SHIFT_NUMBER	NA
PHRJOBS_STATUS	PHIJOBS	REPORTING VIEW	PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION	POSITION_STATUS POSITION_STATUS	NA
PHRJOBS_STRS_ASSN_CODE	NA	REPORTING VIEW	PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET	STATE_RETIREMENT_ASSIGNMENT STATE_RETIREMENT_ASSIGNMENT	NA
PHRJOBS_STRS_CONT_CODE	NA	REPORTING VIEW	PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION	STATE_RETIREMENT_CONTRIBUTION STATE_RETIREMENT_CONTRIBUTION	NA
PHRJOBS_STRS_PAY_CODE	NA	REPORTING VIEW	PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION	STATE_RETIREMENT_PAY_RATE STATE_RETIREMENT_PAY_RATE	NA
PHRJOBS_SUFF	PHIJOBS	REPORTING VIEW	PAYROLL_EMPLOYEE_POSITION	JOB_SUFFIX	NA
PHRJOBS_TIME_ENTRY_IND	NA	REPORTING VIEW	PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION	TIME_ENTRY_TYPE TIME_ENTRY_TYPE	NA
PHRJOBS_TS_ROSTER_IND	PHIJOBS	REPORTING VIEW	PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION	TIMESHEET_METHOD TIMESHEET_METHOD	NA

Ver: 9.0