Banner EDW Source: ETL GENERATED

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
NA	NO	AGGREGATE FACT TABLE DIMENSION TABLE FACT TABLE REPORTING VIEW AGGREGATE FACT TABLE DIMENSION TABLE FACT TABLE REPORTING VIEW AGGREGATE FACT TABLE DIMENSION TABLE AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS WAT_STUDENT_PROGRESS WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY WDT_BANNER_COMMUNICATION WDT_FINANCIAL_AID_YEAR WDT_ACADEMIC_OUTCOME WDT_ACTIVITY WDT_POST_SECONDARY_SCHOOL WDT_FINANCIAL_AID_YEAR WDT_POST_SECONDARY_SCHOOL WDT_CONTACT WDT_GEOGRAPHIC_REGION WDT_PERSON WDT_ACADEMIC_OUTCOME WDT_INSTITUTION WDT_CONTACT WDT_BANNER_COMMUNICATION WDT_CONSTITUENT WDT_COURSE WDT_ACADEMIC_TIME WDT_GEOGRAPHIC_REGION WDT_CONSTITUENT WDT_COURSE WDT_POST_SECONDARY_SCHOOL WDT_BANNER_COMMUNICATION WDT_ACADEMIC_STUDY WDT_SECONDARY_SCHOOL WDT_ACTIVITY WDT_GEOGRAPHIC_REGION WDT_INSTITUTION WDT_FINANCIAL_AID_YEAR WDT_INSTITUTION WDT_POST_SECONDARY_SCHOOL WDT_CONTACT WDT_PERSON WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_STUDENT_COURSE WFT_STUDENT WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_STUDENT_COURSE WFT_STUDENT_COURSE WFT_BANNER_COMMUNICATION WFT_ENROLLMENT WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_STUDENT_COURSE WFT_STUDENT_COURSE WFT_STUDENT_COURSE WFT_SECONDARY_SCHOOL_SUBJECT WFT_FINANCIAL_AID_PRE_STUDENT WFT_ACADEMIC_OUTCOME WFT_RECRUITING_AND_ADMISSION WFT_ACADEMIC_OUTCOME WFT_STUDENT_ACTIVITY WFT_ACADEMIC_OUTCOME WFT_COURSE_REGISTRATION WFT_ACADEMIC_OUTCOME WFT_STUDENT_COURSE AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK WAT_STUDENT_PROGRESS WAT_STUDENT_PROGRESS WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY WDT_BANNER_COMMUNICATION WDT_FINANCIAL_AID_YEAR WDT_ACADEMIC_OUTCOME WDT_ACTIVITY WDT_POST_SECONDARY_SCHOOL WDT_FINANCIAL_AID_YEAR WDT_POST_SECONDARY_SCHOOL WDT_CONTACT WDT_GEOGRAPHIC_REGION WDT_PERSON WDT_ACADEMIC_OUTCOME WDT_INSTITUTION WDT_CONTACT WDT_BANNER_COMMUNICATION WDT_CONSTITUENT WDT_COURSE WDT_ACADEMIC_TIME WDT_GEOGRAPHIC_REGION WDT_CONSTITUENT WDT_COURSE WDT_POST_SECONDARY_SCHOOL WDT_BANNER_COMMUNICATION WDT_ACADEMIC_STUDY WDT_SECONDARY_SCHOOL WDT_ACTIVITY WDT_GEOGRAPHIC_REGION WDT_INSTITUTION WDT_FINANCIAL_AID_YEAR WDT_INSTITUTION WDT_POST_SECONDARY_SCHOOL WDT_CONTACT WDT_PERSON WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_STUDENT_COURSE WFT_STUDENT WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_STUDENT_COURSE WFT_STUDENT_COURSE WFT_BANNER_COMMUNICATION WFT_ENROLLMENT WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_STUDENT_COURSE WFT_STUDENT_COURSE WFT_STUDENT_COURSE WFT_SECONDARY_SCHOOL_SUBJECT WFT_FINANCIAL_AID_PRE_STUDENT WFT_ACADEMIC_OUTCOME WFT_RECRUITING_AND_ADMISSION WFT_ACADEMIC_OUTCOME WFT_STUDENT_ACTIVITY WFT_ACADEMIC_OUTCOME WFT_COURSE_REGISTRATION WFT_ACADEMIC_OUTCOME WFT_STUDENT_COURSE AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK WAT_STUDENT_PROGRESS WAT_STUDENT_PROGRESS WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY WDT_BANNER_COMMUNICATION WDT_FINANCIAL_AID_YEAR WDT_ACADEMIC_OUTCOME WDT_ACTIVITY WDT_POST_SECONDARY_SCHOOL WDT_FINANCIAL_AID_YEAR WDT_POST_SECONDARY_SCHOOL WDT_CONTACT WDT_GEOGRAPHIC_REGION WDT_PERSON WDT_ACADEMIC_OUTCOME WDT_INSTITUTION WDT_CONTACT WDT_BANNER_COMMUNICATION WDT_CONSTITUENT WDT_COURSE WDT_ACADEMIC_TIME WDT_GEOGRAPHIC_REGION WDT_CONSTITUENT WDT_COURSE WDT_POST_SECONDARY_SCHOOL WDT_BANNER_COMMUNICATION (More Targets -- list too long to display currently.) WAT_STUDENT_PROGRESS (More Targets -- list too long to display currently.)	SYSTEM_LOAD_PROCESS SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_PROCESS SYSTEM_LOAD_TMSTMP FINANCIAL_AID_YEAR_KEY ACADEMIC_OUTCOME_KEY SYSTEM_LOAD_TMSTMP POST_SECONDARY_GPA_RANGE_LD SYSTEM_LOAD_PROCESS TRANSFER_CREDIT_RANGE_LD CONTACT_KEY SYSTEM_LOAD_PROCESS SYSTEM_LOAD_PROCESS SYSTEM_LOAD_TMSTMP INSTITUTION_KEY SYSTEM_LOAD_TMSTMP BANNER_COMMUNICATION_KEY ENTITY_TYPE_LD CONTINUING_EDUCATION_IND_SD SYSTEM_LOAD_TMSTMP GEOGRAPHIC_REGION_KEY ENTITY_TYPE_SD CONTINUING_EDUCATION_IND_LD TRANSFER_CREDIT_RANGE_SD SYSTEM_LOAD_PROCESS ACADEMIC_STUDY_KEY SECONDARY_GPA_RANGE_SD SYSTEM_LOAD_PROCESS SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_PROCESS SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_TMSTMP POST_SECONDARY_GPA_RANGE_SD SYSTEM_LOAD_PROCESS SYSTEM_LOAD_TMSTMP PERSON_UID INSTITUTIONAL_HONOR_GROUP_KEY DEMOGRAPHIC_KEY COURSE_PASSED_HEADCOUNT SYSTEM_LOAD_TMSTMP GRADUATION_ACADEMIC_TIME_KEY ACADEMIC_STUDY_KEY ACAD_OUTCOME_HONOR_GROUP_KEY ACADEMIC_OUTCOME_COUNT_KEY ACADEMIC_OUTCOME_GROUP_KEY COURSE_WITHDRAWN_HEADCOUNT COURSE_FAILED_HEADCOUNT FINANCIAL_AID_YEAR_KEY AGE SYSTEM_LOAD_TMSTMP ACADEMIC_OUTCOME_RECORD_KEY DEPARTMENTAL_HONOR_GROUP_KEY COURSE_ATTEMPTED_HEADCOUNT COURSE_DROPPED_HEADCOUNT SOURCE_TYPE SEC_SCHOOL_SUBJECT_GROUP_KEY AGE MULTI_SOURCE_KEY SEQUENCE_NUMBER ACADEMIC_TIME_KEY ACTIVITY_LAST_ACADTIME_KEY SYSTEM_LOAD_PROCESS AGE ACADEMIC_OUTCOME_KEY DEVELOPMENTAL_COURSE_IND CREDITS_APPLIED_RANGE_DESC COURSES_NEEDED_RANGE_ORDER CREDITS_PCT_CMPLTE_RANGE_ORDER COURSES_APPLIED_RANGE_DESC REQUIRE_PCT_COMPLETE_RANGE CREDITS_NEEDED_RANGE COURSES_APPLIED_RANGE COURSES_NEEDED_RANGE_DESC CREDITS_NEEDED_RANGE_DESC CREDITS_PCT_CMPLETE_RANGE_DESC COURSES_NEEDED_RANGE CREDITS_APPLIED_RANGE_ORDER REQUIRE_PCT_CMPLETE_RANGE_DESC REQUIRE_PCT_CMPLTE_RANGE_ORDER COURSES_APPLIED_RANGE_ORDER CREDITS_APPLIED_RANGE GPA_RANGE_ORDER GPA_RANGE CREDITS_PCT_COMPLETE_RANGE CREDITS_NEEDED_RANGE_ORDER GPA_RANGE_DESC SYSTEM_LOAD_PROCESS SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_PROCESS SYSTEM_LOAD_TMSTMP FINANCIAL_AID_YEAR_KEY ACADEMIC_OUTCOME_KEY SYSTEM_LOAD_TMSTMP POST_SECONDARY_GPA_RANGE_LD SYSTEM_LOAD_PROCESS TRANSFER_CREDIT_RANGE_LD CONTACT_KEY SYSTEM_LOAD_PROCESS SYSTEM_LOAD_PROCESS SYSTEM_LOAD_TMSTMP INSTITUTION_KEY SYSTEM_LOAD_TMSTMP BANNER_COMMUNICATION_KEY ENTITY_TYPE_LD CONTINUING_EDUCATION_IND_SD SYSTEM_LOAD_TMSTMP GEOGRAPHIC_REGION_KEY ENTITY_TYPE_SD CONTINUING_EDUCATION_IND_LD TRANSFER_CREDIT_RANGE_SD SYSTEM_LOAD_PROCESS ACADEMIC_STUDY_KEY SECONDARY_GPA_RANGE_SD SYSTEM_LOAD_PROCESS SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_PROCESS SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_TMSTMP POST_SECONDARY_GPA_RANGE_SD SYSTEM_LOAD_PROCESS SYSTEM_LOAD_TMSTMP PERSON_UID INSTITUTIONAL_HONOR_GROUP_KEY DEMOGRAPHIC_KEY COURSE_PASSED_HEADCOUNT SYSTEM_LOAD_TMSTMP GRADUATION_ACADEMIC_TIME_KEY ACADEMIC_STUDY_KEY ACAD_OUTCOME_HONOR_GROUP_KEY ACADEMIC_OUTCOME_COUNT_KEY ACADEMIC_OUTCOME_GROUP_KEY COURSE_WITHDRAWN_HEADCOUNT COURSE_FAILED_HEADCOUNT FINANCIAL_AID_YEAR_KEY AGE SYSTEM_LOAD_TMSTMP ACADEMIC_OUTCOME_RECORD_KEY DEPARTMENTAL_HONOR_GROUP_KEY COURSE_ATTEMPTED_HEADCOUNT COURSE_DROPPED_HEADCOUNT SOURCE_TYPE SEC_SCHOOL_SUBJECT_GROUP_KEY AGE MULTI_SOURCE_KEY SEQUENCE_NUMBER ACADEMIC_TIME_KEY ACTIVITY_LAST_ACADTIME_KEY SYSTEM_LOAD_PROCESS AGE ACADEMIC_OUTCOME_KEY DEVELOPMENTAL_COURSE_IND CREDITS_APPLIED_RANGE_DESC COURSES_NEEDED_RANGE_ORDER CREDITS_PCT_CMPLTE_RANGE_ORDER COURSES_APPLIED_RANGE_DESC REQUIRE_PCT_COMPLETE_RANGE CREDITS_NEEDED_RANGE COURSES_APPLIED_RANGE COURSES_NEEDED_RANGE_DESC CREDITS_NEEDED_RANGE_DESC CREDITS_PCT_CMPLETE_RANGE_DESC COURSES_NEEDED_RANGE CREDITS_APPLIED_RANGE_ORDER REQUIRE_PCT_CMPLETE_RANGE_DESC REQUIRE_PCT_CMPLTE_RANGE_ORDER COURSES_APPLIED_RANGE_ORDER CREDITS_APPLIED_RANGE GPA_RANGE_ORDER GPA_RANGE CREDITS_PCT_COMPLETE_RANGE CREDITS_NEEDED_RANGE_ORDER GPA_RANGE_DESC SYSTEM_LOAD_PROCESS SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_PROCESS SYSTEM_LOAD_TMSTMP FINANCIAL_AID_YEAR_KEY ACADEMIC_OUTCOME_KEY SYSTEM_LOAD_TMSTMP POST_SECONDARY_GPA_RANGE_LD SYSTEM_LOAD_PROCESS TRANSFER_CREDIT_RANGE_LD CONTACT_KEY SYSTEM_LOAD_PROCESS SYSTEM_LOAD_PROCESS SYSTEM_LOAD_TMSTMP INSTITUTION_KEY SYSTEM_LOAD_TMSTMP BANNER_COMMUNICATION_KEY ENTITY_TYPE_LD CONTINUING_EDUCATION_IND_SD SYSTEM_LOAD_TMSTMP GEOGRAPHIC_REGION_KEY ENTITY_TYPE_SD CONTINUING_EDUCATION_IND_LD TRANSFER_CREDIT_RANGE_SD SYSTEM_LOAD_PROCESS (More Target Columns -- list too long to display currently.) SYSTEM_LOAD_PROCESS (More Target Columns -- list too long to display currently.)	STUDENT PROGRESS STUDENT PROGRESS ACADEMIC OUTCOME, STUDENT, STUDENT PROGRESS ACADEMIC OUTCOME STUDENT PROGRESS BANNER COMMUNICATION ACADEMIC OUTCOME ATHLETIC ADMISSIONS APPLICATION BANNER COMMUNICATION ADMISSIONS APPLICATION STUDENT PROGRESS POST SECONDARY SCHOOL STUDENT PROGRESS ACADEMIC OUTCOME STUDENT PROGRESS STUDENT PROGRESS STUDENT PROGRESS ADVANCEMENT GIFT ACADEMIC PROGRAM COURSE STUDENT, STUDENT PROGRESS POST SECONDARY SCHOOL ADVANCEMENT GIFT ACADEMIC PROGRAM COURSE ADMISSIONS APPLICATION STUDENT PROGRESS ACADEMIC OUTCOME EMPLOYMENT APPLICATION ATHLETIC POST SECONDARY SCHOOL STUDENT PROGRESS BANNER COMMUNICATION STUDENT PROGRESS ADMISSIONS APPLICATION STUDENT PROGRESS STUDENT PROGRESS ACADEMIC OUTCOME ACADEMIC OUTCOME ACADEMIC OUTCOME STUDENT COURSE STUDENT ACADEMIC OUTCOME ACADEMIC OUTCOME ACADEMIC OUTCOME ACADEMIC OUTCOME ACADEMIC OUTCOME STUDENT COURSE STUDENT COURSE BANNER COMMUNICATION ENROLLMENT ACADEMIC OUTCOME ACADEMIC OUTCOME ACADEMIC OUTCOME STUDENT COURSE STUDENT COURSE STUDENT COURSE SECONDARY SCHOOL SUBJECT FINANCIAL AID PRE STUDENT ACADEMIC OUTCOME RECRUITING AND ADMISSION ACADEMIC OUTCOME STUDENT ACTIVITY ACADEMIC OUTCOME COURSE REGISTRATION ACADEMIC OUTCOME STUDENT COURSE NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA STUDENT PROGRESS STUDENT PROGRESS ACADEMIC OUTCOME, STUDENT, STUDENT PROGRESS ACADEMIC OUTCOME STUDENT PROGRESS BANNER COMMUNICATION ACADEMIC OUTCOME ATHLETIC ADMISSIONS APPLICATION BANNER COMMUNICATION ADMISSIONS APPLICATION STUDENT PROGRESS POST SECONDARY SCHOOL STUDENT PROGRESS ACADEMIC OUTCOME STUDENT PROGRESS STUDENT PROGRESS STUDENT PROGRESS ADVANCEMENT GIFT ACADEMIC PROGRAM COURSE STUDENT, STUDENT PROGRESS POST SECONDARY SCHOOL ADVANCEMENT GIFT ACADEMIC PROGRAM COURSE ADMISSIONS APPLICATION STUDENT PROGRESS ACADEMIC OUTCOME EMPLOYMENT APPLICATION ATHLETIC POST SECONDARY SCHOOL STUDENT PROGRESS BANNER COMMUNICATION STUDENT PROGRESS ADMISSIONS APPLICATION STUDENT PROGRESS STUDENT PROGRESS ACADEMIC OUTCOME ACADEMIC OUTCOME ACADEMIC OUTCOME STUDENT COURSE STUDENT ACADEMIC OUTCOME ACADEMIC OUTCOME ACADEMIC OUTCOME ACADEMIC OUTCOME ACADEMIC OUTCOME STUDENT COURSE STUDENT COURSE BANNER COMMUNICATION ENROLLMENT ACADEMIC OUTCOME ACADEMIC OUTCOME ACADEMIC OUTCOME STUDENT COURSE STUDENT COURSE STUDENT COURSE SECONDARY SCHOOL SUBJECT FINANCIAL AID PRE STUDENT ACADEMIC OUTCOME RECRUITING AND ADMISSION ACADEMIC OUTCOME STUDENT ACTIVITY ACADEMIC OUTCOME COURSE REGISTRATION ACADEMIC OUTCOME STUDENT COURSE NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA STUDENT PROGRESS STUDENT PROGRESS ACADEMIC OUTCOME, STUDENT, STUDENT PROGRESS ACADEMIC OUTCOME STUDENT PROGRESS BANNER COMMUNICATION ACADEMIC OUTCOME ATHLETIC ADMISSIONS APPLICATION BANNER COMMUNICATION ADMISSIONS APPLICATION STUDENT PROGRESS POST SECONDARY SCHOOL STUDENT PROGRESS ACADEMIC OUTCOME STUDENT PROGRESS STUDENT PROGRESS STUDENT PROGRESS ADVANCEMENT GIFT ACADEMIC PROGRAM COURSE STUDENT, STUDENT PROGRESS POST SECONDARY SCHOOL ADVANCEMENT GIFT ACADEMIC PROGRAM COURSE ADMISSIONS APPLICATION STUDENT PROGRESS STUDENT PROGRESS	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 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 NO NO NO NO NO

Ver: 8.4.2