RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: PEBEMPL Human Resources Composite View Reports
SGHE Operational Data Store Composite View Source: PEBEMPL

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_ADJ_SERVICE_DATE PEAEMPL COMPOSITE VIEW

AP_EMPLOYEE

ADJUSTED_SERVICE_DATE

NA
PEBEMPL_BCAT_CODE PEAEMPL COMPOSITE VIEW

AP_EMPLOYEE

BENEFIT_CATEGORY

NA
PEBEMPL_CAMP_CODE PEAEMPL       NA
PEBEMPL_COAS_CODE_HOME PEAEMPL COMPOSITE VIEW

AP_EMPLOYEE

HOME_ORGANIZATION_CHART

NA
PEBEMPL_COLL_CODE PEAEMPL       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       NA
PEBEMPL_ECLS_CODE PEAEMPL COMPOSITE VIEW

AP_EMPLOYEE

EMPLOYEE_CLASS

NA
PEBEMPL_EGRP_CODE PEAEMPL       NA
PEBEMPL_EMPL_STATUS PEAEMPL COMPOSITE VIEW

AP_EMPLOYEE

EMPLOYEE_STATUS

NA
PEBEMPL_FIRST_HIRE_DATE PEAEMPL COMPOSITE VIEW

AP_EMPLOYEE

ORIGINAL_HIRE_DATE

NA
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_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_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


Ver: 3.1