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

Source Column Source Form Target Type Target Target Column Calculation Formula
PEBEMPL_1042_RECIPIENT_CD PEAEMPL

REPORTING VIEW

EMPLOYEE

FOREIGN_INCOME_RECIPIENT_TYPE

NA
PEBEMPL_ADJ_SERVICE_DATE PEAEMPL

REPORTING VIEW

EMPLOYEE

ADJUSTED_SERVICE_DATE

NA
PEBEMPL_BCAT_CODE PEAEMPL

REPORTING VIEW

EMPLOYEE

BENEFIT_CATEGORY

NA
PEBEMPL_CAMP_CODE PEAEMPL

REPORTING VIEW

EMPLOYEE

EMPLOYEE_POSITION

CAMPUS

CAMPUS

NA
PEBEMPL_COAS_CODE_HOME PEAEMPL

REPORTING VIEW

PAYROLL_DISTRIBUTION

EMPLOYEE

HOME_ORGANIZATION_CHART

HOME_ORGANIZATION_CHART

NA
PEBEMPL_COLL_CODE PEAEMPL

REPORTING VIEW

EMPLOYEE

EMPLOYEE_POSITION

COLLEGE

COLLEGE

NA
PEBEMPL_CURRENT_HIRE_DATE PEAEMPL

REPORTING VIEW

EMPLOYEE

CURRENT_HIRE_DATE

NA
PEBEMPL_DAYS_IN_CANADA PEAEMPL

REPORTING VIEW

EMPLOYEE

NONRESIDENT_DAYS_IN_COUNTRY

NA
PEBEMPL_DICD_CODE PEAEMPL

REPORTING VIEW

EMPLOYEE

DIVISION

NA
PEBEMPL_ECLS_CODE PEAEMPL

REPORTING VIEW

EMPLOYEE

EMPLOYEE_CLASS

NA
PEBEMPL_EGRP_CODE PEAEMPL

REPORTING VIEW

EMPLOYEE

EMPLOYEE_GROUP

NA
PEBEMPL_EMPL_STATUS PEAEMPL

REPORTING VIEW

EMPLOYEE

EMPLOYEE_STATUS

NA
PEBEMPL_FIRST_HIRE_DATE PEAEMPL

REPORTING VIEW

EMPLOYEE

ORIGINAL_HIRE_DATE

NA
PEBEMPL_I9_DATE PEAEMPL

REPORTING VIEW

EMPLOYEE

IMMIGRATION_DATE

NA
PEBEMPL_I9_EXPIRE_DATE PEAEMPL

REPORTING VIEW

EMPLOYEE

IMMIGRATION_EXPIRATION_DATE

NA
PEBEMPL_I9_FORM_IND PEAEMPL

REPORTING VIEW

EMPLOYEE

IMMIGRATION_STATUS

NA
PEBEMPL_INTERNAL_FT_PT_IND PEAEMPL

REPORTING VIEW

EMPLOYEE

FULL_OR_PART_TIME_IND

NA
PEBEMPL_LCAT_CODE PEAEMPL

REPORTING VIEW

EMPLOYEE

LEAVE_CATEGORY

NA
PEBEMPL_LOA_BEG_DATE PEAEMPL

REPORTING VIEW

EMPLOYEE

LEAVE_OF_ABSENCE_BEGIN_DATE

NA
PEBEMPL_LOA_END_DATE PEAEMPL

REPORTING VIEW

EMPLOYEE

LEAVE_OF_ABSENCE_END_DATE

NA
PEBEMPL_LREA_CODE PEAEMPL

REPORTING VIEW

EMPLOYEE

LEAVE_OF_ABSENCE_REASON

NA
PEBEMPL_ORGN_CODE_HOME PEAEMPL

REPORTING VIEW

PAYROLL_DISTRIBUTION

EMPLOYEE

HOME_ORGANIZATION

HOME_ORGANIZATION

NA
PEBEMPL_PIDM PEAEMPL

REPORTING VIEW

EMPLOYEE

PERSON_UID

NA
PEBEMPL_SENIORITY_DATE PEAEMPL

REPORTING VIEW

EMPLOYEE

SENIORITY_DATE

NA
PEBEMPL_STGR_CODE PEAEMPL

REPORTING VIEW

EMPLOYEE

EMPLOYEE_GROUPING

NA
PEBEMPL_TERM_DATE PEAEMPL

REPORTING VIEW

EMPLOYEE

TERMINATION_DATE

NA
PEBEMPL_TREA_CODE PEAEMPL

REPORTING VIEW

EMPLOYEE

TERMINATION_REASON

NA


Ver: 3.1