Banner EDW Source: STVDEPT

RETURN TO BANNER EDW META DATA REPORTS LIST

**SGHE Enterprise Data Warehouse**
Source Column	Local Source	Target Type	Target	Target Column	Star Name	Local Target
STVDEPT_CODE	NO	DIMENSION TABLE	WDT_ADVANCEMENT_DEG_DEPT	ADVANCEMENT_DEG_DEPT	ADVANCEMENT DEG DEPT	NO
STVDEPT_DESC	NO	DIMENSION TABLE REPORTING VIEW DIMENSION TABLE REPORTING VIEW	WDT_ADVANCEMENT_DEG_DEPT WDT_ADVANCEMENT_DEG_DEPT WDT_DESIGNATION WDT_DESIGNATION DEGREE DESIGNATION ACADEMIC_OUTCOME ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED ADMISSIONS_APPLICATION COURSE_CATALOG COURSE_OFFERING_FEES COMBINED_ACADEMIC_OUTCOME ACADEMIC_OUTCOME ACADEMIC_STUDY ACADEMIC_STUDY ADMISSIONS_APPLICATION GOVERNMENT_COURSE GOVERNMENT_STUDENT GOVERNMENT_STUDENT RECRUITMENT_INFORMATION GOVERNMENT_STUDENT RECRUITMENT_INFORMATION EVENT DEGREE PLEDGE_MATCHING ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED GOVERNMENT_STUDENT GIFT ACADEMIC_STUDY_EXTENDED RECRUITMENT_INFORMATION ACADEMIC_STUDY ACADEMIC_STUDY GOVERNMENT_ADMISSIONS RECRUITMENT_INFORMATION REGISTRATION_PLAN_COURSE STUDENT_COURSE_REG_AUDIT ACADEMIC_OUTCOME ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION STUDENT_COURSE COMBINED_ACADEMIC_OUTCOME PLEDGE ACADEMIC_STUDY_EXTENDED SCHEDULE_OFFERING WDT_ADVANCEMENT_DEG_DEPT WDT_ADVANCEMENT_DEG_DEPT WDT_DESIGNATION WDT_DESIGNATION DEGREE DESIGNATION ACADEMIC_OUTCOME ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED ADMISSIONS_APPLICATION COURSE_CATALOG COURSE_OFFERING_FEES COMBINED_ACADEMIC_OUTCOME ACADEMIC_OUTCOME ACADEMIC_STUDY ACADEMIC_STUDY ADMISSIONS_APPLICATION GOVERNMENT_COURSE GOVERNMENT_STUDENT GOVERNMENT_STUDENT RECRUITMENT_INFORMATION GOVERNMENT_STUDENT RECRUITMENT_INFORMATION EVENT DEGREE PLEDGE_MATCHING ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED GOVERNMENT_STUDENT GIFT ACADEMIC_STUDY_EXTENDED RECRUITMENT_INFORMATION ACADEMIC_STUDY ACADEMIC_STUDY GOVERNMENT_ADMISSIONS RECRUITMENT_INFORMATION REGISTRATION_PLAN_COURSE STUDENT_COURSE_REG_AUDIT ACADEMIC_OUTCOME ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION STUDENT_COURSE COMBINED_ACADEMIC_OUTCOME PLEDGE ACADEMIC_STUDY_EXTENDED SCHEDULE_OFFERING	ADVANCEMENT_DEG_DEPT_SD ADVANCEMENT_DEG_DEPT_LD DESIGNATION_DEPARTMENT_SD DESIGNATION_DEPARTMENT_LD DEPARTMENT2_DESC DESG_DEPARTMENT_DESC DEPARTMENT_DESC SECOND_DEPARTMENT_DESC THIRD_DEPARTMENT_DESC DEPARTMENT_DESC DEPARTMENT_DESC DEPARTMENT_DESC SECOND_DEPARTMENT_DESC THIRD_DEPARTMENT_DESC FOURTH_DEPARTMENT_DESC THIRD_DEPARTMENT_DESC FOURTH_DEPARTMENT_DESC COURSE_DEPARTMENT_DESC FOURTH_DEPARTMENT_DESC SECOND_DEPARTMENT_DESC DEPARTMENT_DESC DEPARTMENT_DESC THIRD_DEPARTMENT_DESC DEPARTMENT_DESC DEPARTMENT1_DESC DESG_DEPARTMENT_DESC DUAL_DEGREE_DEPARTMENT_DESC SECOND_DEPARTMENT_DESC THIRD_DEPARTMENT_DESC DESG_DEPARTMENT_DESC DEPARTMENT_DESC SECOND_DEPARTMENT_DESC DEPARTMENT_DESC DUAL_DEGREE_DEPARTMENT_DESC DEPARTMENT_DESC FOURTH_DEPARTMENT_DESC COURSE_DEPARTMENT_DESC DEPARTMENT_DESC FOURTH_DEPARTMENT_DESC SECOND_DEPARTMENT_DESC THIRD_DEPARTMENT_DESC DEPARTMENT_DESC DEPARTMENT_DESC DESG_DEPARTMENT_DESC FOURTH_DEPARTMENT_DESC DEPARTMENT_DESC ADVANCEMENT_DEG_DEPT_SD ADVANCEMENT_DEG_DEPT_LD DESIGNATION_DEPARTMENT_SD DESIGNATION_DEPARTMENT_LD DEPARTMENT2_DESC DESG_DEPARTMENT_DESC DEPARTMENT_DESC SECOND_DEPARTMENT_DESC THIRD_DEPARTMENT_DESC DEPARTMENT_DESC DEPARTMENT_DESC DEPARTMENT_DESC SECOND_DEPARTMENT_DESC THIRD_DEPARTMENT_DESC FOURTH_DEPARTMENT_DESC THIRD_DEPARTMENT_DESC FOURTH_DEPARTMENT_DESC COURSE_DEPARTMENT_DESC FOURTH_DEPARTMENT_DESC SECOND_DEPARTMENT_DESC DEPARTMENT_DESC DEPARTMENT_DESC THIRD_DEPARTMENT_DESC DEPARTMENT_DESC DEPARTMENT1_DESC DESG_DEPARTMENT_DESC DUAL_DEGREE_DEPARTMENT_DESC SECOND_DEPARTMENT_DESC THIRD_DEPARTMENT_DESC DESG_DEPARTMENT_DESC DEPARTMENT_DESC SECOND_DEPARTMENT_DESC DEPARTMENT_DESC DUAL_DEGREE_DEPARTMENT_DESC DEPARTMENT_DESC FOURTH_DEPARTMENT_DESC COURSE_DEPARTMENT_DESC DEPARTMENT_DESC FOURTH_DEPARTMENT_DESC SECOND_DEPARTMENT_DESC THIRD_DEPARTMENT_DESC DEPARTMENT_DESC DEPARTMENT_DESC DESG_DEPARTMENT_DESC FOURTH_DEPARTMENT_DESC DEPARTMENT_DESC	ADVANCEMENT DEG DEPT ADVANCEMENT DEG DEPT ADVANCEMENT GIFT ADVANCEMENT GIFT NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA ADVANCEMENT DEG DEPT ADVANCEMENT DEG DEPT ADVANCEMENT GIFT ADVANCEMENT GIFT NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA	NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO

Ver: 9.0