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

Ver: 8.3