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 WAT_STUDENT_PROGRESS WDT_ACADEMIC_STUDY WDT_INSTITUTION WDT_GEOGRAPHIC_REGION WDT_CONTACT WDT_CONTACT WDT_ACTIVITY WDT_ACTIVITY WDT_PERSON WDT_SECONDARY_SCHOOL WDT_ACADEMIC_STUDY WDT_BANNER_COMMUNICATION WDT_BANNER_COMMUNICATION WDT_TIME WDT_COURSE WDT_ACADEMIC_STUDY WDT_ACADEMIC_TIME WDT_POSTAL WDT_INSTITUTION WDT_CONTACT WDT_FINANCIAL_AID_YEAR WDT_CONSTITUENT WDT_CONSTITUENT WDT_POSTAL WDT_INSTITUTION WDT_FINANCIAL_AID_YEAR WDT_PERSON WDT_POSTAL WDT_BANNER_COMMUNICATION WDT_GEOGRAPHIC_REGION WDT_GEOGRAPHIC_REGION WDT_TIME WDT_ACADEMIC_OUTCOME WDT_ACADEMIC_OUTCOME WDT_COURSE WDT_FINANCIAL_AID_YEAR WDT_MULTI_SOURCE WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_GRADUATION_COMPLETION WFT_STUDENT_COURSE WFT_FINANCIAL_AID_PRE_STUDENT WFT_RECRUITING_AND_ADMISSION WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_STUDENT_COURSE WFT_STUDENT_COURSE WFT_ACADEMIC_OUTCOME WFT_ENROLLMENT WFT_ACADEMIC_OUTCOME WFT_STUDENT_ACTIVITY WFT_BANNER_COMMUNICATION WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_STUDENT_COURSE WFT_STUDENT_COURSE WFT_ACADEMIC_OUTCOME WFT_COURSE_REGISTRATION WFT_ACADEMIC_OUTCOME WFT_STUDENT_COURSE WFT_STUDENT 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 WAT_STUDENT_PROGRESS WDT_ACADEMIC_STUDY WDT_INSTITUTION WDT_GEOGRAPHIC_REGION WDT_CONTACT WDT_CONTACT WDT_ACTIVITY WDT_ACTIVITY WDT_PERSON WDT_SECONDARY_SCHOOL WDT_ACADEMIC_STUDY WDT_BANNER_COMMUNICATION WDT_BANNER_COMMUNICATION WDT_TIME WDT_COURSE WDT_ACADEMIC_STUDY WDT_ACADEMIC_TIME WDT_POSTAL WDT_INSTITUTION WDT_CONTACT WDT_FINANCIAL_AID_YEAR WDT_CONSTITUENT WDT_CONSTITUENT WDT_POSTAL WDT_INSTITUTION WDT_FINANCIAL_AID_YEAR WDT_PERSON WDT_POSTAL WDT_BANNER_COMMUNICATION WDT_GEOGRAPHIC_REGION WDT_GEOGRAPHIC_REGION WDT_TIME WDT_ACADEMIC_OUTCOME WDT_ACADEMIC_OUTCOME WDT_COURSE WDT_FINANCIAL_AID_YEAR WDT_MULTI_SOURCE WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_GRADUATION_COMPLETION WFT_STUDENT_COURSE WFT_FINANCIAL_AID_PRE_STUDENT WFT_RECRUITING_AND_ADMISSION WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_STUDENT_COURSE WFT_STUDENT_COURSE WFT_ACADEMIC_OUTCOME WFT_ENROLLMENT WFT_ACADEMIC_OUTCOME WFT_STUDENT_ACTIVITY WFT_BANNER_COMMUNICATION WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_STUDENT_COURSE WFT_STUDENT_COURSE WFT_ACADEMIC_OUTCOME WFT_COURSE_REGISTRATION WFT_ACADEMIC_OUTCOME WFT_STUDENT_COURSE WFT_STUDENT 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 WAT_STUDENT_PROGRESS WDT_ACADEMIC_STUDY WDT_INSTITUTION WDT_GEOGRAPHIC_REGION WDT_CONTACT WDT_CONTACT WDT_ACTIVITY WDT_ACTIVITY WDT_PERSON WDT_SECONDARY_SCHOOL WDT_ACADEMIC_STUDY WDT_BANNER_COMMUNICATION WDT_BANNER_COMMUNICATION WDT_TIME WDT_COURSE WDT_ACADEMIC_STUDY WDT_ACADEMIC_TIME WDT_POSTAL WDT_INSTITUTION WDT_CONTACT WDT_FINANCIAL_AID_YEAR (More Targets -- list too long to display currently.) WAT_STUDENT_PROGRESS (More Targets -- list too long to display currently.)	LAST_FEEDBACK_ACAD_TIME_KEY SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_PROCESS SYSTEM_LOAD_PROCESS SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_TMSTMP CONTACT_KEY SYSTEM_LOAD_PROCESS SYSTEM_LOAD_PROCESS SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_TMSTMP SECONDARY_GPA_RANGE_SD ACADEMIC_STUDY_KEY BANNER_COMMUNICATION_KEY SYSTEM_LOAD_PROCESS SUB_ACADEMIC_PERIOD CONTINUING_EDUCATION_IND_SD SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_PROCESS INSTITUTION_KEY SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_PROCESS ENTITY_TYPE_LD ENTITY_TYPE_SD POSTAL_KEY SYSTEM_LOAD_PROCESS FINANCIAL_AID_YEAR_KEY SYSTEM_LOAD_PROCESS SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_TMSTMP GEOGRAPHIC_REGION_KEY SYSTEM_LOAD_PROCESS FISCAL_QUARTER ACADEMIC_OUTCOME_KEY SYSTEM_LOAD_TMSTMP CONTINUING_EDUCATION_IND_LD SYSTEM_LOAD_TMSTMP MULTI_SOURCE_KEY ACADEMIC_OUTCOME_COUNT_KEY ACADEMIC_STUDY_KEY ACADEMIC_TIME_KEY ACAD_OUTCOME_HONOR_GROUP_KEY MULTI_SOURCE_KEY ACADEMIC_PERIOD_FRSTATTEND_KEY DEVELOPMENTAL_COURSE_IND AGE SEQUENCE_NUMBER GRADUATION_ACADEMIC_TIME_KEY ACADEMIC_OUTCOME_GROUP_KEY INSTITUTIONAL_HONOR_GROUP_KEY SYSTEM_LOAD_PROCESS COURSE_DROPPED_HEADCOUNT COURSE_WITHDRAWN_HEADCOUNT PERSON_UID AGE SYSTEM_LOAD_TMSTMP ACTIVITY_LAST_ACADTIME_KEY FINANCIAL_AID_YEAR_KEY ACADEMIC_OUTCOME_KEY DEPARTMENTAL_HONOR_GROUP_KEY COURSE_ATTEMPTED_HEADCOUNT COURSE_FAILED_HEADCOUNT ACADEMIC_OUTCOME_RECORD_KEY AGE DEMOGRAPHIC_KEY COURSE_PASSED_HEADCOUNT SYSTEM_LOAD_TMSTMP SOURCE_TYPE COURSES_APPLIED_RANGE CREDITS_APPLIED_RANGE_ORDER CREDITS_NEEDED_RANGE GPA_RANGE_DESC REQUIRE_PCT_CMPLTE_RANGE_ORDER CREDITS_APPLIED_RANGE_DESC CREDITS_PCT_CMPLTE_RANGE_ORDER REQUIRE_PCT_COMPLETE_RANGE COURSES_NEEDED_RANGE COURSES_NEEDED_RANGE_DESC COURSES_APPLIED_RANGE_DESC CREDITS_NEEDED_RANGE_DESC CREDITS_PCT_CMPLETE_RANGE_DESC COURSES_APPLIED_RANGE_ORDER COURSES_NEEDED_RANGE_ORDER CREDITS_NEEDED_RANGE_ORDER CREDITS_PCT_COMPLETE_RANGE GPA_RANGE_ORDER CREDITS_APPLIED_RANGE GPA_RANGE REQUIRE_PCT_CMPLETE_RANGE_DESC LAST_FEEDBACK_ACAD_TIME_KEY SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_PROCESS SYSTEM_LOAD_PROCESS SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_TMSTMP CONTACT_KEY SYSTEM_LOAD_PROCESS SYSTEM_LOAD_PROCESS SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_TMSTMP SECONDARY_GPA_RANGE_SD ACADEMIC_STUDY_KEY BANNER_COMMUNICATION_KEY SYSTEM_LOAD_PROCESS SUB_ACADEMIC_PERIOD CONTINUING_EDUCATION_IND_SD SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_PROCESS INSTITUTION_KEY SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_PROCESS ENTITY_TYPE_LD ENTITY_TYPE_SD POSTAL_KEY SYSTEM_LOAD_PROCESS FINANCIAL_AID_YEAR_KEY SYSTEM_LOAD_PROCESS SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_TMSTMP GEOGRAPHIC_REGION_KEY SYSTEM_LOAD_PROCESS FISCAL_QUARTER ACADEMIC_OUTCOME_KEY SYSTEM_LOAD_TMSTMP CONTINUING_EDUCATION_IND_LD SYSTEM_LOAD_TMSTMP MULTI_SOURCE_KEY ACADEMIC_OUTCOME_COUNT_KEY ACADEMIC_STUDY_KEY ACADEMIC_TIME_KEY ACAD_OUTCOME_HONOR_GROUP_KEY MULTI_SOURCE_KEY ACADEMIC_PERIOD_FRSTATTEND_KEY DEVELOPMENTAL_COURSE_IND AGE SEQUENCE_NUMBER GRADUATION_ACADEMIC_TIME_KEY ACADEMIC_OUTCOME_GROUP_KEY INSTITUTIONAL_HONOR_GROUP_KEY SYSTEM_LOAD_PROCESS COURSE_DROPPED_HEADCOUNT COURSE_WITHDRAWN_HEADCOUNT PERSON_UID AGE SYSTEM_LOAD_TMSTMP ACTIVITY_LAST_ACADTIME_KEY FINANCIAL_AID_YEAR_KEY ACADEMIC_OUTCOME_KEY DEPARTMENTAL_HONOR_GROUP_KEY COURSE_ATTEMPTED_HEADCOUNT COURSE_FAILED_HEADCOUNT ACADEMIC_OUTCOME_RECORD_KEY AGE DEMOGRAPHIC_KEY COURSE_PASSED_HEADCOUNT SYSTEM_LOAD_TMSTMP SOURCE_TYPE COURSES_APPLIED_RANGE CREDITS_APPLIED_RANGE_ORDER CREDITS_NEEDED_RANGE GPA_RANGE_DESC REQUIRE_PCT_CMPLTE_RANGE_ORDER CREDITS_APPLIED_RANGE_DESC CREDITS_PCT_CMPLTE_RANGE_ORDER REQUIRE_PCT_COMPLETE_RANGE COURSES_NEEDED_RANGE COURSES_NEEDED_RANGE_DESC COURSES_APPLIED_RANGE_DESC CREDITS_NEEDED_RANGE_DESC CREDITS_PCT_CMPLETE_RANGE_DESC COURSES_APPLIED_RANGE_ORDER COURSES_NEEDED_RANGE_ORDER CREDITS_NEEDED_RANGE_ORDER CREDITS_PCT_COMPLETE_RANGE GPA_RANGE_ORDER CREDITS_APPLIED_RANGE GPA_RANGE REQUIRE_PCT_CMPLETE_RANGE_DESC LAST_FEEDBACK_ACAD_TIME_KEY SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_PROCESS SYSTEM_LOAD_PROCESS SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_TMSTMP CONTACT_KEY SYSTEM_LOAD_PROCESS SYSTEM_LOAD_PROCESS SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_TMSTMP SECONDARY_GPA_RANGE_SD ACADEMIC_STUDY_KEY BANNER_COMMUNICATION_KEY SYSTEM_LOAD_PROCESS SUB_ACADEMIC_PERIOD CONTINUING_EDUCATION_IND_SD SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_PROCESS INSTITUTION_KEY SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_PROCESS (More Target Columns -- list too long to display currently.) LAST_FEEDBACK_ACAD_TIME_KEY (More Target Columns -- list too long to display currently.)	STUDENT PROGRESS STUDENT PROGRESS STUDENT PROGRESS ACADEMIC OUTCOME ENROLLMENT, STUDENT PROGRESS POST SECONDARY SCHOOL STUDENT PROGRESS STUDENT PROGRESS ATHLETIC ATHLETIC STUDENT PROGRESS EMPLOYMENT APPLICATION ACADEMIC OUTCOME STUDENT PROGRESS STUDENT PROGRESS FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER ACADEMIC PROGRAM COURSE ACADEMIC OUTCOME, STUDENT, STUDENT PROGRESS STUDENT, STUDENT PROGRESS ENROLLMENT ENROLLMENT, GRADUATION COMPLETION, STUDENT PROGRESS STUDENT PROGRESS BANNER COMMUNICATION ADVANCEMENT GIFT ADVANCEMENT GIFT ENROLLMENT ENROLLMENT, STUDENT PROGRESS BANNER COMMUNICATION STUDENT PROGRESS ENROLLMENT STUDENT PROGRESS POST SECONDARY SCHOOL POST SECONDARY SCHOOL EMPLOYEE, EMPLOYEE POSITION ACADEMIC OUTCOME ACADEMIC OUTCOME ACADEMIC PROGRAM COURSE BANNER COMMUNICATION COURSE INSTRUCTOR ACADEMIC OUTCOME ACADEMIC OUTCOME ACADEMIC OUTCOME ACADEMIC OUTCOME ACADEMIC OUTCOME GRADUATION COMPLETION STUDENT COURSE FINANCIAL AID PRE STUDENT RECRUITING AND ADMISSION ACADEMIC OUTCOME ACADEMIC OUTCOME ACADEMIC OUTCOME ACADEMIC OUTCOME STUDENT COURSE STUDENT COURSE ACADEMIC OUTCOME ENROLLMENT ACADEMIC OUTCOME STUDENT ACTIVITY BANNER COMMUNICATION ACADEMIC OUTCOME ACADEMIC OUTCOME STUDENT COURSE STUDENT COURSE ACADEMIC OUTCOME COURSE REGISTRATION ACADEMIC OUTCOME STUDENT COURSE STUDENT 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 STUDENT PROGRESS ACADEMIC OUTCOME ENROLLMENT, STUDENT PROGRESS POST SECONDARY SCHOOL STUDENT PROGRESS STUDENT PROGRESS ATHLETIC ATHLETIC STUDENT PROGRESS EMPLOYMENT APPLICATION ACADEMIC OUTCOME STUDENT PROGRESS STUDENT PROGRESS FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER ACADEMIC PROGRAM COURSE ACADEMIC OUTCOME, STUDENT, STUDENT PROGRESS STUDENT, STUDENT PROGRESS ENROLLMENT ENROLLMENT, GRADUATION COMPLETION, STUDENT PROGRESS STUDENT PROGRESS BANNER COMMUNICATION ADVANCEMENT GIFT ADVANCEMENT GIFT ENROLLMENT ENROLLMENT, STUDENT PROGRESS BANNER COMMUNICATION STUDENT PROGRESS ENROLLMENT STUDENT PROGRESS POST SECONDARY SCHOOL POST SECONDARY SCHOOL EMPLOYEE, EMPLOYEE POSITION ACADEMIC OUTCOME ACADEMIC OUTCOME ACADEMIC PROGRAM COURSE BANNER COMMUNICATION COURSE INSTRUCTOR ACADEMIC OUTCOME ACADEMIC OUTCOME ACADEMIC OUTCOME ACADEMIC OUTCOME ACADEMIC OUTCOME GRADUATION COMPLETION STUDENT COURSE FINANCIAL AID PRE STUDENT RECRUITING AND ADMISSION ACADEMIC OUTCOME ACADEMIC OUTCOME ACADEMIC OUTCOME ACADEMIC OUTCOME STUDENT COURSE STUDENT COURSE ACADEMIC OUTCOME ENROLLMENT ACADEMIC OUTCOME STUDENT ACTIVITY BANNER COMMUNICATION ACADEMIC OUTCOME ACADEMIC OUTCOME STUDENT COURSE STUDENT COURSE ACADEMIC OUTCOME COURSE REGISTRATION ACADEMIC OUTCOME STUDENT COURSE STUDENT 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 STUDENT PROGRESS ACADEMIC OUTCOME ENROLLMENT, STUDENT PROGRESS POST SECONDARY SCHOOL STUDENT PROGRESS STUDENT PROGRESS ATHLETIC ATHLETIC STUDENT PROGRESS EMPLOYMENT APPLICATION ACADEMIC OUTCOME STUDENT PROGRESS STUDENT PROGRESS FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER ACADEMIC PROGRAM COURSE ACADEMIC OUTCOME, STUDENT, STUDENT PROGRESS STUDENT, STUDENT PROGRESS ENROLLMENT ENROLLMENT, GRADUATION COMPLETION, STUDENT PROGRESS STUDENT PROGRESS BANNER COMMUNICATION 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 NO NO NO

Ver: 9.0