RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: PHRJOBS Human Resources Reporting View Meta Data Reports
SGHE Operational Data Store Reporting View Source: PHRJOBS

Source Column Source Form Target Type Target Target Column Calculation Formula
PHRJOBS_APPT_PCT NA

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

APPOINTMENT_PCT

NA
PHRJOBS_BASE_SAL_HRS NA

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

BASE_SALARY_HOURS

NA
PHRJOBS_COAS_CODE_TS PHIJOBS

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

TIMESHEET_CHART_OF_ACCOUNTS

NA
PHRJOBS_CONTRACT_TYPE NA

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

POSITION_CONTRACT_TYPE

NA
PHRJOBS_DEFER_AMT NA

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

DEFERRED_PAY_AMOUNT

NA
PHRJOBS_ECLS_CODE PHIJOBS

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

POSITION_EMPLOYEE_CLASS

NA
PHRJOBS_EFFECTIVE_DATE PHIJOBS

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

POSITION_BEGIN_DATE

NA
PHRJOBS_EFFECTIVE_UNTIL_DATE NA

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

POSITION_END_DATE

NA
PHRJOBS_EMPR_CODE NA

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

EMPLOYER

NA
PHRJOBS_FIRST_NAME_SEQ PHIJOBS

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

FIRST_NAME_HISTORY

NA
PHRJOBS_FTE NA

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

FULL_TIME_EQUIVALENCY

NA
PHRJOBS_FULL_ASSGN_SALARY NA

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

FULL_ASSIGNMENT_SALARY

NA
PHRJOBS_HRS_DAY NA

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

HOURS_PER_DAY

NA
PHRJOBS_ID_SEQ PHIJOBS

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

ID_HISTORY

NA
PHRJOBS_LAST_NAME_SEQ PHIJOBS

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

LAST_NAME_HISTORY

NA
PHRJOBS_LCAT_CODE NA

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

LEAVE_CATEGORY

NA
PHRJOBS_LGCD_CODE NA

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

LONGEVITY_ELIGIBILITY

NA
PHRJOBS_ORGN_CODE_TS PHIJOBS

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

TIMESHEET_ORGANIZATION

NA
PHRJOBS_PAY_CNT NA

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

PAYROLL_IDENTIFIER_COUNT

NA
PHRJOBS_PCAT_CODE NA

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

PREMIUM_PAY_CATEGORY

NA
PHRJOBS_PERS_CONT_CODE NA

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

PUBLIC_RETIREMENT_CONTRIBUTION

NA
PHRJOBS_PERS_PAY_CODE NA

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

PUBLIC_RETIREMENT_PAY_RATE

NA
PHRJOBS_PER_PAY_SALARY NA

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

PER_PAY_SALARY

NA
PHRJOBS_POSN PHIJOBS

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

POSITION

NA
PHRJOBS_PREV_FISCAL_YEAR_IND NA

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

PREVIOUS_FISCAL_YEAR_IND

NA
PHRJOBS_SALARY_RATE NA

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

HOURLY_RATE

NA
PHRJOBS_SHIFT NA

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

SHIFT_NUMBER

NA
PHRJOBS_STATUS PHIJOBS

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

POSITION_STATUS

NA
PHRJOBS_STRS_ASSN_CODE NA

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

STATE_RETIREMENT_ASSIGNMENT

NA
PHRJOBS_STRS_CONT_CODE NA

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

STATE_RETIREMENT_CONTRIBUTION

NA
PHRJOBS_STRS_PAY_CODE NA

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

STATE_RETIREMENT_PAY_RATE

NA
PHRJOBS_SUFF PHIJOBS

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

JOB_SUFFIX

NA
PHRJOBS_TIME_ENTRY_IND NA

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

TIME_ENTRY_TYPE

NA
PHRJOBS_TS_ROSTER_IND PHIJOBS

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

TIMESHEET_METHOD

NA


Ver: 3.1