Source Column |
Source Form |
Target Type |
Target |
Target Column |
Calculation Formula |
PEBEMPL_1042_RECIPIENT_CD |
PEAEMPL |
COMPOSITE VIEW |
AP_EMPLOYEE |
FOREIGN_INCOME_RECIPIENT_TYPE |
NA |
PEBEMPL_ACTIVITY_DATE |
PEAEMPL |
COMPOSITE VIEW |
AP_EMPLOYEE |
ACTIVITY_DATE |
|
PEBEMPL_ADJ_SERVICE_DATE |
PEAEMPL |
COMPOSITE VIEW |
AP_EMPLOYEE |
ADJUSTED_SERVICE_DATE |
NA |
PEBEMPL_BCAT_CODE |
PEAEMPL |
COMPOSITE VIEW |
AP_EMPLOYEE |
BENEFIT_CATEGORY |
NA |
PEBEMPL_CALIF_PENSION_IND |
TBD |
COMPOSITE VIEW |
AP_EMPLOYEE |
PUBLIC_RETIREMENT_MEMBERSHIP |
|
PEBEMPL_CAMP_CODE |
PEAEMPL |
COMPOSITE VIEW |
AP_EMPLOYEE |
CAMPUS |
NA |
PEBEMPL_COAS_CODE_DIST |
TBD |
COMPOSITE VIEW |
AP_EMPLOYEE |
CHECK_DISTRIBUTION_CHART |
|
PEBEMPL_COAS_CODE_HOME |
PEAEMPL |
COMPOSITE VIEW |
AP_EMPLOYEE |
HOME_ORGANIZATION_CHART |
NA |
PEBEMPL_COLL_CODE |
PEAEMPL |
COMPOSITE VIEW |
AP_EMPLOYEE |
COLLEGE |
NA |
PEBEMPL_CURRENT_HIRE_DATE |
PEAEMPL |
COMPOSITE VIEW |
AP_EMPLOYEE |
CURRENT_HIRE_DATE |
NA |
PEBEMPL_DAYS_IN_CANADA |
PEAEMPL |
COMPOSITE VIEW |
AP_EMPLOYEE |
NONRESIDENT_DAYS_IN_COUNTRY |
NA |
PEBEMPL_DICD_CODE |
PEAEMPL |
COMPOSITE VIEW |
AP_EMPLOYEE |
DIVISION |
NA |
PEBEMPL_ECLS_CODE |
PEAEMPL |
COMPOSITE VIEW |
AP_EMPLOYEE |
EMPLOYEE_CLASS |
NA |
PEBEMPL_EGRP_CODE |
PEAEMPL |
COMPOSITE VIEW |
AP_EMPLOYEE |
EMPLOYEE_GROUP |
NA |
PEBEMPL_EMPL_STATUS |
PEAEMPL |
COMPOSITE VIEW |
AP_EMPLOYEE |
EMPLOYEE_STATUS |
NA |
PEBEMPL_EW2_CONSENT_DATE |
TBD |
COMPOSITE VIEW |
AP_EMPLOYEE |
ELECTRONIC_CONSENT_DATE |
|
PEBEMPL_EW2_CONSENT_IND |
TBD |
COMPOSITE VIEW |
AP_EMPLOYEE |
ELECTRONIC_CONSENT_IND |
|
PEBEMPL_EW2_CONSENT_USER_ID |
PEAEMPL |
COMPOSITE VIEW |
AP_EMPLOYEE |
ELECTRONIC_CONSENT_USER_ID |
|
PEBEMPL_FIRST_HIRE_DATE |
PEAEMPL |
COMPOSITE VIEW |
AP_EMPLOYEE |
ORIGINAL_HIRE_DATE |
NA |
PEBEMPL_FIRST_WORK_DATE |
TBD |
COMPOSITE VIEW |
AP_EMPLOYEE |
FIRST_WORK_DATE |
|
PEBEMPL_FLSA_IND |
TBD |
COMPOSITE VIEW |
AP_EMPLOYEE |
FAIR_LABOR_STANDARDS_TYPE |
|
PEBEMPL_I9_DATE |
PEAEMPL |
COMPOSITE VIEW |
AP_EMPLOYEE |
IMMIGRATION_DATE |
NA |
PEBEMPL_I9_EXPIRE_DATE |
PEAEMPL |
COMPOSITE VIEW |
AP_EMPLOYEE |
IMMIGRATION_EXPIRATION_DATE |
NA |
PEBEMPL_I9_FORM_IND |
PEAEMPL |
COMPOSITE VIEW |
AP_EMPLOYEE |
IMMIGRATION_STATUS |
NA |
PEBEMPL_INTERNAL_FT_PT_IND |
PEAEMPL |
COMPOSITE VIEW |
AP_EMPLOYEE |
FULL_OR_PART_TIME_IND |
NA |
PEBEMPL_IPEDS_MED_DENTAL_IND |
PEAEMPL |
|
|
|
|
PEBEMPL_IPEDS_PRIMARY_FUNCTION |
PEAEMPL |
|
|
|
|
PEBEMPL_IPEDS_SOFT_MONEY_IND |
TBD |
COMPOSITE VIEW |
AP_EMPLOYEE |
FEDERAL_SOFT_MONEY_IND |
|
PEBEMPL_JBLN_CODE |
TBD |
COMPOSITE VIEW |
AP_EMPLOYEE |
HIRING_LOCATION |
|
PEBEMPL_LAST_WORK_DATE |
TBD |
COMPOSITE VIEW |
AP_EMPLOYEE |
LAST_WORK_DATE |
|
PEBEMPL_LCAT_CODE |
PEAEMPL |
COMPOSITE VIEW |
AP_EMPLOYEE |
LEAVE_CATEGORY |
NA |
PEBEMPL_LOA_BEG_DATE |
PEAEMPL |
COMPOSITE VIEW |
AP_EMPLOYEE |
LEAVE_OF_ABSENCE_BEGIN_DATE |
NA |
PEBEMPL_LOA_END_DATE |
PEAEMPL |
COMPOSITE VIEW |
AP_EMPLOYEE |
LEAVE_OF_ABSENCE_END_DATE |
NA |
PEBEMPL_LREA_CODE |
PEAEMPL |
COMPOSITE VIEW |
AP_EMPLOYEE |
LEAVE_OF_ABSENCE_REASON |
NA |
PEBEMPL_NRSI_CODE |
TBD |
COMPOSITE VIEW |
AP_EMPLOYEE |
NONRESIDENT_SERVICE_INDUSTRY |
|
PEBEMPL_ORGN_CODE_DIST |
TBD |
COMPOSITE VIEW |
AP_EMPLOYEE |
CHECK_DIST_ORGANIZATION |
|
PEBEMPL_ORGN_CODE_HOME |
PEAEMPL |
COMPOSITE VIEW |
AP_EMPLOYEE |
HOME_ORGANIZATION |
NA |
PEBEMPL_PIDM |
PEAEMPL |
COMPOSITE VIEW |
AP_EMPLOYEE |
PERSON_UID |
NA |
PEBEMPL_SENIORITY_DATE |
PEAEMPL |
COMPOSITE VIEW |
AP_EMPLOYEE |
SENIORITY_DATE |
NA |
PEBEMPL_STGR_CODE |
PEAEMPL |
COMPOSITE VIEW |
AP_EMPLOYEE |
EMPLOYEE_GROUPING |
NA |
PEBEMPL_TERM_DATE |
PEAEMPL |
COMPOSITE VIEW |
AP_EMPLOYEE |
TERMINATION_DATE |
NA |
PEBEMPL_TREA_CODE |
PEAEMPL |
COMPOSITE VIEW |
AP_EMPLOYEE |
TERMINATION_REASON |
NA |
PEBEMPL_USER_ID |
PEAEMPL |
COMPOSITE VIEW |
AP_EMPLOYEE |
USER_ID |
|
PEBEMPL_WKPR_CODE |
TBD |
COMPOSITE VIEW |
AP_EMPLOYEE |
WORK_PERIOD |
|