SGHE Banner Operational Data Store
Composite View Source: PHRJOBS
| Banner Source Name |
Banner Source Column |
Banner Business Name |
Source Form |
Banner Business Definition |
Banner Business Acronym |
ODS Target |
ODS Target Column |
| |
PHRJOBS_ACTIVITY_DATE |
|
PHIJOBS |
|
|
AP_PAYROLL_EMPLOYEE_POSITION |
PAYROLL_POSITION_ACTIVITY_DATE |
| |
PHRJOBS_APPT_PCT |
|
NA |
|
|
|
|
| |
PHRJOBS_BASE_SAL_HRS |
|
NA |
|
|
|
|
| |
PHRJOBS_COAS_CODE_TS |
|
PHIJOBS |
|
|
|
|
| |
PHRJOBS_CONTRACT_TYPE |
|
NA |
|
|
|
|
| |
PHRJOBS_DEFER_AMT |
|
NA |
|
|
|
|
| |
PHRJOBS_ECLS_CODE |
|
PHIJOBS |
|
|
|
|
| |
PHRJOBS_EFFECTIVE_DATE |
|
PHIJOBS |
|
|
|
|
| |
PHRJOBS_EFFECTIVE_UNTIL_DATE |
|
NA |
|
|
|
|
| |
PHRJOBS_EMPR_CODE |
|
NA |
|
|
|
|
| |
PHRJOBS_FIRST_NAME_SEQ |
|
PHIJOBS |
|
|
|
|
| |
PHRJOBS_FTE |
|
NA |
|
|
|
|
| |
PHRJOBS_FULL_ASSGN_SALARY |
|
NA |
|
|
|
|
| |
PHRJOBS_HRS_DAY |
|
NA |
|
|
|
|
| |
PHRJOBS_ID_SEQ |
|
PHIJOBS |
|
|
|
|
| |
PHRJOBS_LAST_NAME_SEQ |
|
PHIJOBS |
|
|
|
|
| |
PHRJOBS_LCAT_CODE |
|
NA |
|
|
|
|
| |
PHRJOBS_LGCD_CODE |
|
NA |
|
|
|
|
| |
PHRJOBS_ORGN_CODE_TS |
|
PHIJOBS |
|
|
|
|
| |
PHRJOBS_PAY_CNT |
|
NA |
|
|
|
|
| |
PHRJOBS_PCAT_CODE |
|
NA |
|
|
|
|
| |
PHRJOBS_PERS_CONT_CODE |
|
NA |
|
|
|
|
| |
PHRJOBS_PERS_PAY_CODE |
|
NA |
|
|
|
|
| |
PHRJOBS_PER_PAY_SALARY |
|
NA |
|
|
|
|
| |
PHRJOBS_POSN |
|
PHIJOBS |
|
|
|
|
| |
PHRJOBS_PREV_FISCAL_YEAR_IND |
|
NA |
|
|
|
|
| |
PHRJOBS_SALARY_RATE |
|
NA |
|
|
|
|
| |
PHRJOBS_SHIFT |
|
NA |
|
|
|
|
| |
PHRJOBS_STATUS |
|
PHIJOBS |
|
|
|
|
| |
PHRJOBS_STRS_ASSN_CODE |
|
NA |
|
|
|
|
| |
PHRJOBS_STRS_CONT_CODE |
|
NA |
|
|
|
|
| |
PHRJOBS_STRS_PAY_CODE |
|
NA |
|
|
|
|
| |
PHRJOBS_SUFF |
|
PHIJOBS |
|
|
|
|
| |
PHRJOBS_TIME_ENTRY_IND |
|
NA |
|
|
|
|
| |
PHRJOBS_TS_ROSTER_IND |
|
PHIJOBS |
|
|
|
|