Composite View Source: PEBEMPL

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

**SGHE Banner Operational Data Store**
Banner Source Column	Source Form	ODS Target	ODS Target Column
PEBEMPL_1042_RECIPIENT_CD	PEAEMPL	AP_EMPLOYEE	FOREIGN_INCOME_RECIPIENT_TYPE
PEBEMPL_ACTIVITY_DATE	PEAEMPL	AP_EMPLOYEE	ACTIVITY_DATE
PEBEMPL_ADJ_SERVICE_DATE	PEAEMPL	AP_EMPLOYEE	ADJUSTED_SERVICE_DATE
PEBEMPL_BCAT_CODE	PEAEMPL	AP_EMPLOYEE	BENEFIT_CATEGORY
PEBEMPL_CALIF_PENSION_IND	TBD	AP_EMPLOYEE	PUBLIC_RETIREMENT_MEMBERSHIP
PEBEMPL_CAMP_CODE	PEAEMPL	AP_EMPLOYEE	CAMPUS
PEBEMPL_COAS_CODE_DIST	TBD	AP_EMPLOYEE	CHECK_DISTRIBUTION_CHART
PEBEMPL_COAS_CODE_HOME	PEAEMPL	AP_EMPLOYEE	HOME_ORGANIZATION_CHART
PEBEMPL_COLL_CODE	PEAEMPL	AP_EMPLOYEE	COLLEGE
PEBEMPL_CURRENT_HIRE_DATE	PEAEMPL	AP_EMPLOYEE	CURRENT_HIRE_DATE
PEBEMPL_DAYS_IN_CANADA	PEAEMPL	AP_EMPLOYEE	NONRESIDENT_DAYS_IN_COUNTRY
PEBEMPL_DICD_CODE	PEAEMPL	AP_EMPLOYEE	DIVISION
PEBEMPL_ECLS_CODE	PEAEMPL	AP_EMPLOYEE	EMPLOYEE_CLASS
PEBEMPL_EGRP_CODE	PEAEMPL	AP_EMPLOYEE	EMPLOYEE_GROUP
PEBEMPL_EMPL_STATUS	PEAEMPL	AP_EMPLOYEE	EMPLOYEE_STATUS
PEBEMPL_EW2_CONSENT_DATE	TBD	AP_EMPLOYEE	ELECTRONIC_CONSENT_DATE
PEBEMPL_EW2_CONSENT_IND	TBD	AP_EMPLOYEE	ELECTRONIC_CONSENT_IND
PEBEMPL_EW2_CONSENT_USER_ID	PEAEMPL	AP_EMPLOYEE	ELECTRONIC_CONSENT_USER_ID
PEBEMPL_FIRST_HIRE_DATE	PEAEMPL	AP_EMPLOYEE	ORIGINAL_HIRE_DATE
PEBEMPL_FIRST_WORK_DATE	TBD	AP_EMPLOYEE	FIRST_WORK_DATE
PEBEMPL_FLSA_IND	TBD	AP_EMPLOYEE	FAIR_LABOR_STANDARDS_TYPE
PEBEMPL_I9_DATE	PEAEMPL	AP_EMPLOYEE	IMMIGRATION_DATE
PEBEMPL_I9_EXPIRE_DATE	PEAEMPL	AP_EMPLOYEE	IMMIGRATION_EXPIRATION_DATE
PEBEMPL_I9_FORM_IND	PEAEMPL	AP_EMPLOYEE	IMMIGRATION_STATUS
PEBEMPL_INTERNAL_FT_PT_IND	PEAEMPL	AP_EMPLOYEE	FULL_OR_PART_TIME_IND
PEBEMPL_IPEDS_SOFT_MONEY_IND	TBD	AP_EMPLOYEE	FEDERAL_SOFT_MONEY_IND
PEBEMPL_JBLN_CODE	TBD	AP_EMPLOYEE	HIRING_LOCATION
PEBEMPL_LAST_WORK_DATE	TBD	AP_EMPLOYEE	LAST_WORK_DATE
PEBEMPL_LCAT_CODE	PEAEMPL	AP_EMPLOYEE	LEAVE_CATEGORY
PEBEMPL_LOA_BEG_DATE	PEAEMPL	AP_EMPLOYEE	LEAVE_OF_ABSENCE_BEGIN_DATE
PEBEMPL_LOA_END_DATE	PEAEMPL	AP_EMPLOYEE	LEAVE_OF_ABSENCE_END_DATE
PEBEMPL_LREA_CODE	PEAEMPL	AP_EMPLOYEE	LEAVE_OF_ABSENCE_REASON
PEBEMPL_NRSI_CODE	TBD	AP_EMPLOYEE	NONRESIDENT_SERVICE_INDUSTRY
PEBEMPL_ORGN_CODE_DIST	TBD	AP_EMPLOYEE	CHECK_DIST_ORGANIZATION
PEBEMPL_ORGN_CODE_HOME	PEAEMPL	AP_EMPLOYEE	HOME_ORGANIZATION
PEBEMPL_PIDM	PEAEMPL	AP_EMPLOYEE	PERSON_UID
PEBEMPL_SENIORITY_DATE	PEAEMPL	AP_EMPLOYEE	SENIORITY_DATE
PEBEMPL_STGR_CODE	PEAEMPL	AP_EMPLOYEE	EMPLOYEE_GROUPING
PEBEMPL_TERM_DATE	PEAEMPL	AP_EMPLOYEE	TERMINATION_DATE
PEBEMPL_TREA_CODE	PEAEMPL	AP_EMPLOYEE	TERMINATION_REASON
PEBEMPL_USER_ID	PEAEMPL	AP_EMPLOYEE	USER_ID
PEBEMPL_WKPR_CODE	TBD	AP_EMPLOYEE	WORK_PERIOD

Ver: 8.3