Reporting View Source: PHRJOBS

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

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

Ver: 9.2