Composite View Source: PEBEMPL

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Reporting View Source: PEBEMPL Human Resources

**SGHE Banner Operational Data Store**
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.1