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**
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_ACTIVITY_DATE	PEAEMPL	REPORTING VIEW	EMPLOYEE	ACTIVITY_DATE
PEBEMPL_ADJ_SERVICE_DATE	PEAEMPL	REPORTING VIEW	EMPLOYEE	ADJUSTED_SERVICE_DATE	NA
PEBEMPL_BCAT_CODE	PEAEMPL	REPORTING VIEW	EMPLOYEE	BENEFIT_CATEGORY	NA
PEBEMPL_CALIF_PENSION_IND	TBD	REPORTING VIEW	EMPLOYEE	PUBLIC_RETIREMENT_MEMBERSHIP
PEBEMPL_CAMP_CODE	PEAEMPL	REPORTING VIEW	EMPLOYEE EMPLOYEE_POSITION	CAMPUS CAMPUS	NA
PEBEMPL_COAS_CODE_DIST	TBD	REPORTING VIEW	EMPLOYEE	CHECK_DISTRIBUTION_CHART
PEBEMPL_COAS_CODE_HOME	PEAEMPL	REPORTING VIEW	PAYROLL_DISTRIBUTION EMPLOYEE	HOME_ORGANIZATION_CHART HOME_ORGANIZATION_CHART	NA
PEBEMPL_COLL_CODE	PEAEMPL	REPORTING VIEW	EMPLOYEE_POSITION EMPLOYEE	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_EW2_CONSENT_DATE	TBD	REPORTING VIEW	EMPLOYEE	ELECTRONIC_CONSENT_DATE
PEBEMPL_EW2_CONSENT_IND	TBD	REPORTING VIEW	EMPLOYEE	ELECTRONIC_CONSENT_IND
PEBEMPL_EW2_CONSENT_USER_ID	PEAEMPL	REPORTING VIEW	EMPLOYEE	ELECTRONIC_CONSENT_USER_ID
PEBEMPL_FIRST_HIRE_DATE	PEAEMPL	REPORTING VIEW	EMPLOYEE	ORIGINAL_HIRE_DATE	NA
PEBEMPL_FIRST_WORK_DATE	TBD	REPORTING VIEW	EMPLOYEE	FIRST_WORK_DATE
PEBEMPL_FLSA_IND	TBD	REPORTING VIEW	EMPLOYEE	FAIR_LABOR_STANDARDS_TYPE
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_IPEDS_MED_DENTAL_IND	PEAEMPL	REPORTING VIEW	EMPLOYEE_POSITION EMPLOYEE	FEDERAL_MEDICAL_DENTAL_IND FEDERAL_MEDICAL_DENTAL_IND
PEBEMPL_IPEDS_PRIMARY_FUNCTION	PEAEMPL	REPORTING VIEW	EMPLOYEE_POSITION EMPLOYEE	PRIMARY_FUNCTION PRIMARY_FUNCTION
PEBEMPL_IPEDS_SOFT_MONEY_IND	TBD	REPORTING VIEW	EMPLOYEE_POSITION EMPLOYEE	FEDERAL_SOFT_MONEY_IND FEDERAL_SOFT_MONEY_IND
PEBEMPL_JBLN_CODE	TBD	REPORTING VIEW	EMPLOYEE	HIRING_LOCATION
PEBEMPL_LAST_WORK_DATE	TBD	REPORTING VIEW	EMPLOYEE	LAST_WORK_DATE
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_NRSI_CODE	TBD	REPORTING VIEW	EMPLOYEE	NONRESIDENT_SERVICE_INDUSTRY
PEBEMPL_ORGN_CODE_DIST	TBD	REPORTING VIEW	EMPLOYEE	CHECK_DIST_ORGANIZATION
PEBEMPL_ORGN_CODE_HOME	PEAEMPL	REPORTING VIEW	EMPLOYEE PAYROLL_DISTRIBUTION	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
PEBEMPL_USER_ID	PEAEMPL	REPORTING VIEW	EMPLOYEE	USER_ID
PEBEMPL_WKPR_CODE	TBD	REPORTING VIEW	EMPLOYEE	WORK_PERIOD

Ver: 8.5