Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: PEBEMPL Human Resources
SGHE Banner Operational Data Store Composite View Source: PEBEMPL - NULL

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

 


Ver: 8.0