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 |