Reporting View Source: PEBEMPL

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Composite View Source: PEBEMPL Human Resources Reporting View Meta Data Reports

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

Ver: 8.3