Banner EDW Source: STVACYR

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
STVACYR_DESC	NO	DIMENSION TABLE REPORTING VIEW DIMENSION TABLE REPORTING VIEW	WDT_ADVANCEMENT_DEG_YEAR WDT_ADVANCEMENT_DEG_YEAR ACADEMIC_STUDY GPA_BY_TERM RECRUITMENT_INFORMATION PROJECTED_SEATS_NEEDED AUDIT_STUDENT_BLOCK STUDENT_TRANSFERRED_COURSE FACULTY_FEEDBACK FACULTY_FEEDBACK_DETAIL MEAL_ASSIGNMENT ROOM_ASSIGNMENT COMMUNICATION ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED AUDIT_STUDENT_COURSE DEGREE RECEIVABLE_ACCOUNT_DETAIL AUDIT_STUDENT_BLOCK REGISTRATION_PLAN_COURSE GPA OFFERING_GRADE_TYPE AUDIT_COURSE_NEEDED BLOCK_REGISTRATION_COURSE DEGREE ACADEMIC_STUDY PHONE_ASSIGNMENT RECRUITMENT_LEARNED STUDENT_ACTIVITY STUDENT_COURSE_GRADE_CHANGE ACADEMIC_OUTCOME FIELD_OF_STUDY MEETING_TIME SCHEDULE_OFFERING ENROLLMENT_WITHDRAWAL AUDIT_STUDENT_COURSE ACADEMIC_OUTCOME CONTRACT EXEMPTION AUDIT_STUDENT_NON_COURSE CONTRACT_PAYMENT_DETAIL AUDIT_STUDENT_NON_COURSE ACADEMIC_STUDY ADMISSIONS_COHORT ENROLLMENT RECEIVABLE_SUMMARY ACADEMIC_STUDY_EXTENDED AUDIT_STUDENT_BLOCK REGISTRATION_PLAN WDT_ADVANCEMENT_DEG_YEAR WDT_ADVANCEMENT_DEG_YEAR ACADEMIC_STUDY GPA_BY_TERM RECRUITMENT_INFORMATION PROJECTED_SEATS_NEEDED AUDIT_STUDENT_BLOCK STUDENT_TRANSFERRED_COURSE FACULTY_FEEDBACK FACULTY_FEEDBACK_DETAIL MEAL_ASSIGNMENT ROOM_ASSIGNMENT COMMUNICATION ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED AUDIT_STUDENT_COURSE DEGREE RECEIVABLE_ACCOUNT_DETAIL AUDIT_STUDENT_BLOCK REGISTRATION_PLAN_COURSE GPA OFFERING_GRADE_TYPE AUDIT_COURSE_NEEDED BLOCK_REGISTRATION_COURSE DEGREE ACADEMIC_STUDY PHONE_ASSIGNMENT RECRUITMENT_LEARNED STUDENT_ACTIVITY STUDENT_COURSE_GRADE_CHANGE ACADEMIC_OUTCOME FIELD_OF_STUDY MEETING_TIME SCHEDULE_OFFERING ENROLLMENT_WITHDRAWAL AUDIT_STUDENT_COURSE ACADEMIC_OUTCOME CONTRACT EXEMPTION AUDIT_STUDENT_NON_COURSE CONTRACT_PAYMENT_DETAIL AUDIT_STUDENT_NON_COURSE ACADEMIC_STUDY ADMISSIONS_COHORT ENROLLMENT RECEIVABLE_SUMMARY ACADEMIC_STUDY_EXTENDED AUDIT_STUDENT_BLOCK REGISTRATION_PLAN	ADVANCEMENT_DEG_YEAR_LD ADVANCEMENT_DEG_YEAR_SD YEAR_ADMITTED_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC AUDIT_ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC GRAD_YEAR_INTENDED_DESC YEAR_ADMITTED_DESC ACADEMIC_YEAR_DESC BULLETIN_YEAR_DESC ACADEMIC_YEAR_DESC CATALOG_YEAR_START_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC AUDIT_ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC GRAD_YEAR_INTENDED_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_GRADUATION_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC AUDIT_ACADEMIC_YEAR_DESC BULLETIN_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC AUDIT_ACADEMIC_YEAR_DESC YEAR_MATRICULATED_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC YEAR_MATRICULATED_DESC CATALOG_YEAR_END_DESC ACADEMIC_YEAR_DESC ADVANCEMENT_DEG_YEAR_LD ADVANCEMENT_DEG_YEAR_SD YEAR_ADMITTED_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC AUDIT_ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC GRAD_YEAR_INTENDED_DESC YEAR_ADMITTED_DESC ACADEMIC_YEAR_DESC BULLETIN_YEAR_DESC ACADEMIC_YEAR_DESC CATALOG_YEAR_START_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC AUDIT_ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC GRAD_YEAR_INTENDED_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_GRADUATION_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC AUDIT_ACADEMIC_YEAR_DESC BULLETIN_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC AUDIT_ACADEMIC_YEAR_DESC YEAR_MATRICULATED_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC YEAR_MATRICULATED_DESC CATALOG_YEAR_END_DESC ACADEMIC_YEAR_DESC	ADVANCEMENT DEGREE ADVANCEMENT DEGREE 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 NA NA NA NA NA ADVANCEMENT DEGREE ADVANCEMENT DEGREE 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 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 NO NO NO NO NO NO

Ver: 8.4.2