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 Reporting View Source: PHRJOBS - NULL

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