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