Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: PHRJOBS Human Resources
SGHE Banner Operational Data Store Composite View Source: PHRJOBS - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
PHRJOBS_ACTIVITY_DATE PHIJOBS COMPOSITE VIEW

AP_PAYROLL_EMPLOYEE_POSITION

PAYROLL_POSITION_ACTIVITY_DATE

 
PHRJOBS_APPT_PCT NA       NA
PHRJOBS_BASE_SAL_HRS NA       NA
PHRJOBS_COAS_CODE_TS PHIJOBS       NA
PHRJOBS_CONTRACT_TYPE NA       NA
PHRJOBS_DEFER_AMT NA       NA
PHRJOBS_ECLS_CODE PHIJOBS       NA
PHRJOBS_EFFECTIVE_DATE PHIJOBS       NA
PHRJOBS_EFFECTIVE_UNTIL_DATE NA       NA
PHRJOBS_EMPR_CODE NA       NA
PHRJOBS_FIRST_NAME_SEQ PHIJOBS       NA
PHRJOBS_FTE NA       NA
PHRJOBS_FULL_ASSGN_SALARY NA       NA
PHRJOBS_HRS_DAY NA       NA
PHRJOBS_ID_SEQ PHIJOBS       NA
PHRJOBS_LAST_NAME_SEQ PHIJOBS       NA
PHRJOBS_LCAT_CODE NA       NA
PHRJOBS_LGCD_CODE NA       NA
PHRJOBS_ORGN_CODE_TS PHIJOBS       NA
PHRJOBS_PAY_CNT NA       NA
PHRJOBS_PCAT_CODE NA       NA
PHRJOBS_PERS_CONT_CODE NA       NA
PHRJOBS_PERS_PAY_CODE NA       NA
PHRJOBS_PER_PAY_SALARY NA       NA
PHRJOBS_POSN PHIJOBS       NA
PHRJOBS_PREV_FISCAL_YEAR_IND NA       NA
PHRJOBS_SALARY_RATE NA       NA
PHRJOBS_SHIFT NA       NA
PHRJOBS_STATUS PHIJOBS       NA
PHRJOBS_STRS_ASSN_CODE NA       NA
PHRJOBS_STRS_CONT_CODE NA       NA
PHRJOBS_STRS_PAY_CODE NA       NA
PHRJOBS_SUFF PHIJOBS       NA
PHRJOBS_TIME_ENTRY_IND NA       NA
PHRJOBS_TS_ROSTER_IND PHIJOBS       NA


Ver: