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_DESC	NO	DIMENSION TABLE REPORTING VIEW DIMENSION TABLE REPORTING VIEW	WDT_DESIGNATION WDT_DESIGNATION DEGREE DEGREE DESIGNATION GIFT PLEDGE PLEDGE_MATCHING ACADEMIC_OUTCOME ACADEMIC_OUTCOME ACADEMIC_OUTCOME ACADEMIC_OUTCOME ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION COURSE_CATALOG GOVERNMENT_ADMISSIONS GOVERNMENT_COURSE GOVERNMENT_STUDENT GOVERNMENT_STUDENT GOVERNMENT_STUDENT GOVERNMENT_STUDENT RECRUITMENT_INFORMATION RECRUITMENT_INFORMATION RECRUITMENT_INFORMATION RECRUITMENT_INFORMATION SCHEDULE_OFFERING STUDENT_COURSE STUDENT_COURSE_REG_AUDIT COMBINED_ACADEMIC_OUTCOME COMBINED_ACADEMIC_OUTCOME EVENT WDT_DESIGNATION WDT_DESIGNATION DEGREE DEGREE DESIGNATION GIFT PLEDGE PLEDGE_MATCHING ACADEMIC_OUTCOME ACADEMIC_OUTCOME ACADEMIC_OUTCOME ACADEMIC_OUTCOME ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION COURSE_CATALOG GOVERNMENT_ADMISSIONS GOVERNMENT_COURSE GOVERNMENT_STUDENT GOVERNMENT_STUDENT GOVERNMENT_STUDENT GOVERNMENT_STUDENT RECRUITMENT_INFORMATION RECRUITMENT_INFORMATION RECRUITMENT_INFORMATION RECRUITMENT_INFORMATION SCHEDULE_OFFERING STUDENT_COURSE STUDENT_COURSE_REG_AUDIT COMBINED_ACADEMIC_OUTCOME COMBINED_ACADEMIC_OUTCOME EVENT	DESIGNATION_DEPARTMENT_LD DESIGNATION_DEPARTMENT_SD DEPARTMENT1_DESC DEPARTMENT2_DESC DESG_DEPARTMENT_DESC DESG_DEPARTMENT_DESC DESG_DEPARTMENT_DESC DESG_DEPARTMENT_DESC DEPARTMENT_DESC FOURTH_DEPARTMENT_DESC SECOND_DEPARTMENT_DESC THIRD_DEPARTMENT_DESC DEPARTMENT_DESC DUAL_DEGREE_DEPARTMENT_DESC FOURTH_DEPARTMENT_DESC SECOND_DEPARTMENT_DESC THIRD_DEPARTMENT_DESC DEPARTMENT_DESC DUAL_DEGREE_DEPARTMENT_DESC FOURTH_DEPARTMENT_DESC SECOND_DEPARTMENT_DESC THIRD_DEPARTMENT_DESC DEPARTMENT_DESC FOURTH_DEPARTMENT_DESC SECOND_DEPARTMENT_DESC THIRD_DEPARTMENT_DESC DEPARTMENT_DESC DEPARTMENT_DESC COURSE_DEPARTMENT_DESC DEPARTMENT_DESC FOURTH_DEPARTMENT_DESC SECOND_DEPARTMENT_DESC THIRD_DEPARTMENT_DESC DEPARTMENT_DESC FOURTH_DEPARTMENT_DESC SECOND_DEPARTMENT_DESC THIRD_DEPARTMENT_DESC DEPARTMENT_DESC DEPARTMENT_DESC DEPARTMENT_DESC DEPARTMENT_DESC SECOND_DEPARTMENT_DESC DEPARTMENT_DESC DESIGNATION_DEPARTMENT_LD DESIGNATION_DEPARTMENT_SD DEPARTMENT1_DESC DEPARTMENT2_DESC DESG_DEPARTMENT_DESC DESG_DEPARTMENT_DESC DESG_DEPARTMENT_DESC DESG_DEPARTMENT_DESC DEPARTMENT_DESC FOURTH_DEPARTMENT_DESC SECOND_DEPARTMENT_DESC THIRD_DEPARTMENT_DESC DEPARTMENT_DESC DUAL_DEGREE_DEPARTMENT_DESC FOURTH_DEPARTMENT_DESC SECOND_DEPARTMENT_DESC THIRD_DEPARTMENT_DESC DEPARTMENT_DESC DUAL_DEGREE_DEPARTMENT_DESC FOURTH_DEPARTMENT_DESC SECOND_DEPARTMENT_DESC THIRD_DEPARTMENT_DESC DEPARTMENT_DESC FOURTH_DEPARTMENT_DESC SECOND_DEPARTMENT_DESC THIRD_DEPARTMENT_DESC DEPARTMENT_DESC DEPARTMENT_DESC COURSE_DEPARTMENT_DESC DEPARTMENT_DESC FOURTH_DEPARTMENT_DESC SECOND_DEPARTMENT_DESC THIRD_DEPARTMENT_DESC DEPARTMENT_DESC FOURTH_DEPARTMENT_DESC SECOND_DEPARTMENT_DESC THIRD_DEPARTMENT_DESC DEPARTMENT_DESC DEPARTMENT_DESC DEPARTMENT_DESC DEPARTMENT_DESC SECOND_DEPARTMENT_DESC DEPARTMENT_DESC	ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE 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 ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE 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

Ver: 8.2