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 AGGREGATE FACT TABLE DIMENSION TABLE FACT TABLE AGGREGATE FACT TABLE DIMENSION TABLE FACT TABLE	WAT_STUDENT_PROGRESS WAT_STUDENT_PROGRESS WAT_STUDENT_PROGRESS WDT_BANNER_COMMUNICATION WDT_CONSTITUENT WDT_ACADEMIC_TIME WDT_FINANCIAL_AID_YEAR WDT_ACTIVITY WDT_INSTITUTION WDT_CONTACT WDT_PERSON WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY WDT_FINANCIAL_AID_YEAR WDT_POST_SECONDARY_SCHOOL WDT_PERSON WDT_ACADEMIC_OUTCOME WDT_INSTITUTION WDT_POST_SECONDARY_SCHOOL WDT_ACADEMIC_STUDY WDT_BANNER_COMMUNICATION WDT_BANNER_COMMUNICATION WDT_ACTIVITY WDT_CONTACT WDT_SECONDARY_SCHOOL WDT_FINANCIAL_AID_YEAR WDT_CONTACT WDT_GEOGRAPHIC_REGION WDT_ACADEMIC_OUTCOME WDT_GEOGRAPHIC_REGION WDT_COURSE WDT_POST_SECONDARY_SCHOOL WDT_COURSE WDT_INSTITUTION WDT_GEOGRAPHIC_REGION WDT_CONSTITUENT WDT_POST_SECONDARY_SCHOOL WFT_ACADEMIC_OUTCOME WFT_STUDENT_ACTIVITY WFT_STUDENT_COURSE WFT_RECRUITING_AND_ADMISSION WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_COURSE_REGISTRATION WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_STUDENT_COURSE WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_STUDENT_COURSE WFT_ACADEMIC_OUTCOME WFT_FINANCIAL_AID_PRE_STUDENT WFT_SECONDARY_SCHOOL_SUBJECT WFT_ENROLLMENT WFT_STUDENT_COURSE WFT_BANNER_COMMUNICATION WFT_STUDENT_COURSE WFT_STUDENT_COURSE WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_STUDENT_COURSE WFT_STUDENT WAT_STUDENT_PROGRESS WAT_STUDENT_PROGRESS WAT_STUDENT_PROGRESS WDT_BANNER_COMMUNICATION WDT_CONSTITUENT WDT_ACADEMIC_TIME WDT_FINANCIAL_AID_YEAR WDT_ACTIVITY WDT_INSTITUTION WDT_CONTACT WDT_PERSON WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY WDT_FINANCIAL_AID_YEAR WDT_POST_SECONDARY_SCHOOL WDT_PERSON WDT_ACADEMIC_OUTCOME WDT_INSTITUTION WDT_POST_SECONDARY_SCHOOL WDT_ACADEMIC_STUDY WDT_BANNER_COMMUNICATION WDT_BANNER_COMMUNICATION WDT_ACTIVITY WDT_CONTACT WDT_SECONDARY_SCHOOL WDT_FINANCIAL_AID_YEAR WDT_CONTACT WDT_GEOGRAPHIC_REGION WDT_ACADEMIC_OUTCOME WDT_GEOGRAPHIC_REGION WDT_COURSE WDT_POST_SECONDARY_SCHOOL WDT_COURSE WDT_INSTITUTION WDT_GEOGRAPHIC_REGION WDT_CONSTITUENT WDT_POST_SECONDARY_SCHOOL WFT_ACADEMIC_OUTCOME WFT_STUDENT_ACTIVITY WFT_STUDENT_COURSE WFT_RECRUITING_AND_ADMISSION WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_COURSE_REGISTRATION WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_STUDENT_COURSE WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_STUDENT_COURSE WFT_ACADEMIC_OUTCOME WFT_FINANCIAL_AID_PRE_STUDENT WFT_SECONDARY_SCHOOL_SUBJECT WFT_ENROLLMENT WFT_STUDENT_COURSE WFT_BANNER_COMMUNICATION WFT_STUDENT_COURSE WFT_STUDENT_COURSE WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_STUDENT_COURSE WFT_STUDENT WAT_STUDENT_PROGRESS WAT_STUDENT_PROGRESS WAT_STUDENT_PROGRESS WDT_BANNER_COMMUNICATION WDT_CONSTITUENT WDT_ACADEMIC_TIME WDT_FINANCIAL_AID_YEAR WDT_ACTIVITY WDT_INSTITUTION WDT_CONTACT WDT_PERSON WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY WDT_FINANCIAL_AID_YEAR WDT_POST_SECONDARY_SCHOOL WDT_PERSON WDT_ACADEMIC_OUTCOME WDT_INSTITUTION WDT_POST_SECONDARY_SCHOOL WDT_ACADEMIC_STUDY WDT_BANNER_COMMUNICATION WDT_BANNER_COMMUNICATION WDT_ACTIVITY WDT_CONTACT WDT_SECONDARY_SCHOOL WDT_FINANCIAL_AID_YEAR WDT_CONTACT WDT_GEOGRAPHIC_REGION WDT_ACADEMIC_OUTCOME WDT_GEOGRAPHIC_REGION WDT_COURSE WDT_POST_SECONDARY_SCHOOL WDT_COURSE WDT_INSTITUTION WDT_GEOGRAPHIC_REGION WDT_CONSTITUENT WDT_POST_SECONDARY_SCHOOL WFT_ACADEMIC_OUTCOME WFT_STUDENT_ACTIVITY WFT_STUDENT_COURSE WFT_RECRUITING_AND_ADMISSION WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_COURSE_REGISTRATION WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_STUDENT_COURSE WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_STUDENT_COURSE WFT_ACADEMIC_OUTCOME WFT_FINANCIAL_AID_PRE_STUDENT WFT_SECONDARY_SCHOOL_SUBJECT WFT_ENROLLMENT WFT_STUDENT_COURSE WFT_BANNER_COMMUNICATION WFT_STUDENT_COURSE WFT_STUDENT_COURSE WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_ACADEMIC_OUTCOME WFT_STUDENT_COURSE WFT_STUDENT	SYSTEM_LOAD_PROCESS LAST_FEEDBACK_ACAD_TIME_KEY SYSTEM_LOAD_TMSTMP BANNER_COMMUNICATION_KEY ENTITY_TYPE_LD SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_PROCESS SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_PROCESS CONTACT_KEY SYSTEM_LOAD_TMSTMP ACADEMIC_STUDY_KEY SYSTEM_LOAD_TMSTMP FINANCIAL_AID_YEAR_KEY POST_SECONDARY_GPA_RANGE_SD SYSTEM_LOAD_PROCESS SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_TMSTMP POST_SECONDARY_GPA_RANGE_LD SYSTEM_LOAD_PROCESS SYSTEM_LOAD_PROCESS SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_PROCESS SYSTEM_LOAD_TMSTMP SECONDARY_GPA_RANGE_SD SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_PROCESS SYSTEM_LOAD_PROCESS ACADEMIC_OUTCOME_KEY GEOGRAPHIC_REGION_KEY CONTINUING_EDUCATION_IND_SD TRANSFER_CREDIT_RANGE_SD CONTINUING_EDUCATION_IND_LD INSTITUTION_KEY SYSTEM_LOAD_TMSTMP ENTITY_TYPE_SD TRANSFER_CREDIT_RANGE_LD ACADEMIC_OUTCOME_RECORD_KEY ACTIVITY_LAST_ACADTIME_KEY COURSE_ATTEMPTED_HEADCOUNT SEQUENCE_NUMBER SYSTEM_LOAD_TMSTMP ACADEMIC_STUDY_KEY AGE ACADEMIC_OUTCOME_COUNT_KEY ACADEMIC_OUTCOME_GROUP_KEY DEPARTMENTAL_HONOR_GROUP_KEY COURSE_WITHDRAWN_HEADCOUNT PERSON_UID ACADEMIC_TIME_KEY GRADUATION_ACADEMIC_TIME_KEY COURSE_DROPPED_HEADCOUNT ACADEMIC_OUTCOME_KEY AGE SEC_SCHOOL_SUBJECT_GROUP_KEY AGE COURSE_FAILED_HEADCOUNT FINANCIAL_AID_YEAR_KEY SOURCE_TYPE DEVELOPMENTAL_COURSE_IND SYSTEM_LOAD_PROCESS ACAD_OUTCOME_HONOR_GROUP_KEY DEMOGRAPHIC_KEY INSTITUTIONAL_HONOR_GROUP_KEY MULTI_SOURCE_KEY COURSE_PASSED_HEADCOUNT SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_PROCESS LAST_FEEDBACK_ACAD_TIME_KEY SYSTEM_LOAD_TMSTMP BANNER_COMMUNICATION_KEY ENTITY_TYPE_LD SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_PROCESS SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_PROCESS CONTACT_KEY SYSTEM_LOAD_TMSTMP ACADEMIC_STUDY_KEY SYSTEM_LOAD_TMSTMP FINANCIAL_AID_YEAR_KEY POST_SECONDARY_GPA_RANGE_SD SYSTEM_LOAD_PROCESS SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_TMSTMP POST_SECONDARY_GPA_RANGE_LD SYSTEM_LOAD_PROCESS SYSTEM_LOAD_PROCESS SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_PROCESS SYSTEM_LOAD_TMSTMP SECONDARY_GPA_RANGE_SD SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_PROCESS SYSTEM_LOAD_PROCESS ACADEMIC_OUTCOME_KEY GEOGRAPHIC_REGION_KEY CONTINUING_EDUCATION_IND_SD TRANSFER_CREDIT_RANGE_SD CONTINUING_EDUCATION_IND_LD INSTITUTION_KEY SYSTEM_LOAD_TMSTMP ENTITY_TYPE_SD TRANSFER_CREDIT_RANGE_LD ACADEMIC_OUTCOME_RECORD_KEY ACTIVITY_LAST_ACADTIME_KEY COURSE_ATTEMPTED_HEADCOUNT SEQUENCE_NUMBER SYSTEM_LOAD_TMSTMP ACADEMIC_STUDY_KEY AGE ACADEMIC_OUTCOME_COUNT_KEY ACADEMIC_OUTCOME_GROUP_KEY DEPARTMENTAL_HONOR_GROUP_KEY COURSE_WITHDRAWN_HEADCOUNT PERSON_UID ACADEMIC_TIME_KEY GRADUATION_ACADEMIC_TIME_KEY COURSE_DROPPED_HEADCOUNT ACADEMIC_OUTCOME_KEY AGE SEC_SCHOOL_SUBJECT_GROUP_KEY AGE COURSE_FAILED_HEADCOUNT FINANCIAL_AID_YEAR_KEY SOURCE_TYPE DEVELOPMENTAL_COURSE_IND SYSTEM_LOAD_PROCESS ACAD_OUTCOME_HONOR_GROUP_KEY DEMOGRAPHIC_KEY INSTITUTIONAL_HONOR_GROUP_KEY MULTI_SOURCE_KEY COURSE_PASSED_HEADCOUNT SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_PROCESS LAST_FEEDBACK_ACAD_TIME_KEY SYSTEM_LOAD_TMSTMP BANNER_COMMUNICATION_KEY ENTITY_TYPE_LD SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_PROCESS SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_PROCESS CONTACT_KEY SYSTEM_LOAD_TMSTMP ACADEMIC_STUDY_KEY SYSTEM_LOAD_TMSTMP FINANCIAL_AID_YEAR_KEY POST_SECONDARY_GPA_RANGE_SD SYSTEM_LOAD_PROCESS SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_TMSTMP POST_SECONDARY_GPA_RANGE_LD SYSTEM_LOAD_PROCESS SYSTEM_LOAD_PROCESS SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_PROCESS SYSTEM_LOAD_TMSTMP SECONDARY_GPA_RANGE_SD SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_PROCESS SYSTEM_LOAD_PROCESS ACADEMIC_OUTCOME_KEY GEOGRAPHIC_REGION_KEY CONTINUING_EDUCATION_IND_SD TRANSFER_CREDIT_RANGE_SD CONTINUING_EDUCATION_IND_LD INSTITUTION_KEY SYSTEM_LOAD_TMSTMP ENTITY_TYPE_SD TRANSFER_CREDIT_RANGE_LD ACADEMIC_OUTCOME_RECORD_KEY ACTIVITY_LAST_ACADTIME_KEY COURSE_ATTEMPTED_HEADCOUNT SEQUENCE_NUMBER SYSTEM_LOAD_TMSTMP ACADEMIC_STUDY_KEY AGE ACADEMIC_OUTCOME_COUNT_KEY ACADEMIC_OUTCOME_GROUP_KEY DEPARTMENTAL_HONOR_GROUP_KEY COURSE_WITHDRAWN_HEADCOUNT PERSON_UID ACADEMIC_TIME_KEY GRADUATION_ACADEMIC_TIME_KEY COURSE_DROPPED_HEADCOUNT ACADEMIC_OUTCOME_KEY AGE SEC_SCHOOL_SUBJECT_GROUP_KEY AGE COURSE_FAILED_HEADCOUNT FINANCIAL_AID_YEAR_KEY SOURCE_TYPE DEVELOPMENTAL_COURSE_IND SYSTEM_LOAD_PROCESS ACAD_OUTCOME_HONOR_GROUP_KEY DEMOGRAPHIC_KEY INSTITUTIONAL_HONOR_GROUP_KEY MULTI_SOURCE_KEY COURSE_PASSED_HEADCOUNT SYSTEM_LOAD_TMSTMP	STUDENT PROGRESS STUDENT PROGRESS STUDENT PROGRESS STUDENT PROGRESS ADVANCEMENT GIFT STUDENT, STUDENT PROGRESS BANNER COMMUNICATION ATHLETIC STUDENT PROGRESS STUDENT PROGRESS STUDENT PROGRESS ACADEMIC OUTCOME ACADEMIC OUTCOME, STUDENT, STUDENT PROGRESS BANNER COMMUNICATION ADMISSIONS APPLICATION STUDENT PROGRESS ACADEMIC OUTCOME STUDENT PROGRESS ADMISSIONS APPLICATION ACADEMIC OUTCOME STUDENT PROGRESS STUDENT PROGRESS ATHLETIC STUDENT PROGRESS EMPLOYMENT APPLICATION BANNER COMMUNICATION STUDENT PROGRESS POST SECONDARY SCHOOL ACADEMIC OUTCOME POST SECONDARY SCHOOL ACADEMIC PROGRAM COURSE ADMISSIONS APPLICATION ACADEMIC PROGRAM COURSE STUDENT PROGRESS POST SECONDARY SCHOOL ADVANCEMENT GIFT ADMISSIONS APPLICATION ACADEMIC OUTCOME STUDENT ACTIVITY STUDENT COURSE RECRUITING AND ADMISSION ACADEMIC OUTCOME ACADEMIC OUTCOME COURSE REGISTRATION ACADEMIC OUTCOME ACADEMIC OUTCOME ACADEMIC OUTCOME STUDENT COURSE ACADEMIC OUTCOME ACADEMIC OUTCOME ACADEMIC OUTCOME STUDENT COURSE ACADEMIC OUTCOME FINANCIAL AID PRE STUDENT SECONDARY SCHOOL SUBJECT ENROLLMENT STUDENT COURSE BANNER COMMUNICATION STUDENT COURSE STUDENT COURSE ACADEMIC OUTCOME ACADEMIC OUTCOME ACADEMIC OUTCOME ACADEMIC OUTCOME ACADEMIC OUTCOME STUDENT COURSE STUDENT STUDENT PROGRESS STUDENT PROGRESS STUDENT PROGRESS STUDENT PROGRESS ADVANCEMENT GIFT STUDENT, STUDENT PROGRESS BANNER COMMUNICATION ATHLETIC STUDENT PROGRESS STUDENT PROGRESS STUDENT PROGRESS ACADEMIC OUTCOME ACADEMIC OUTCOME, STUDENT, STUDENT PROGRESS BANNER COMMUNICATION ADMISSIONS APPLICATION STUDENT PROGRESS ACADEMIC OUTCOME STUDENT PROGRESS ADMISSIONS APPLICATION ACADEMIC OUTCOME STUDENT PROGRESS STUDENT PROGRESS ATHLETIC STUDENT PROGRESS EMPLOYMENT APPLICATION BANNER COMMUNICATION STUDENT PROGRESS POST SECONDARY SCHOOL ACADEMIC OUTCOME POST SECONDARY SCHOOL ACADEMIC PROGRAM COURSE ADMISSIONS APPLICATION ACADEMIC PROGRAM COURSE STUDENT PROGRESS POST SECONDARY SCHOOL ADVANCEMENT GIFT ADMISSIONS APPLICATION ACADEMIC OUTCOME STUDENT ACTIVITY STUDENT COURSE RECRUITING AND ADMISSION ACADEMIC OUTCOME ACADEMIC OUTCOME COURSE REGISTRATION ACADEMIC OUTCOME ACADEMIC OUTCOME ACADEMIC OUTCOME STUDENT COURSE ACADEMIC OUTCOME ACADEMIC OUTCOME ACADEMIC OUTCOME STUDENT COURSE ACADEMIC OUTCOME FINANCIAL AID PRE STUDENT SECONDARY SCHOOL SUBJECT ENROLLMENT STUDENT COURSE BANNER COMMUNICATION STUDENT COURSE STUDENT COURSE ACADEMIC OUTCOME ACADEMIC OUTCOME ACADEMIC OUTCOME ACADEMIC OUTCOME ACADEMIC OUTCOME STUDENT COURSE STUDENT STUDENT PROGRESS STUDENT PROGRESS STUDENT PROGRESS STUDENT PROGRESS ADVANCEMENT GIFT STUDENT, STUDENT PROGRESS BANNER COMMUNICATION ATHLETIC STUDENT PROGRESS STUDENT PROGRESS STUDENT PROGRESS ACADEMIC OUTCOME ACADEMIC OUTCOME, STUDENT, STUDENT PROGRESS BANNER COMMUNICATION ADMISSIONS APPLICATION STUDENT PROGRESS ACADEMIC OUTCOME STUDENT PROGRESS ADMISSIONS APPLICATION ACADEMIC OUTCOME STUDENT PROGRESS STUDENT PROGRESS ATHLETIC STUDENT PROGRESS EMPLOYMENT APPLICATION BANNER COMMUNICATION STUDENT PROGRESS POST SECONDARY SCHOOL ACADEMIC OUTCOME POST SECONDARY SCHOOL ACADEMIC PROGRAM COURSE ADMISSIONS APPLICATION ACADEMIC PROGRAM COURSE STUDENT PROGRESS POST SECONDARY SCHOOL ADVANCEMENT GIFT ADMISSIONS APPLICATION ACADEMIC OUTCOME STUDENT ACTIVITY STUDENT COURSE RECRUITING AND ADMISSION ACADEMIC OUTCOME ACADEMIC OUTCOME COURSE REGISTRATION ACADEMIC OUTCOME ACADEMIC OUTCOME ACADEMIC OUTCOME STUDENT COURSE ACADEMIC OUTCOME ACADEMIC OUTCOME ACADEMIC OUTCOME STUDENT COURSE ACADEMIC OUTCOME FINANCIAL AID PRE STUDENT SECONDARY SCHOOL SUBJECT ENROLLMENT STUDENT COURSE BANNER COMMUNICATION STUDENT COURSE STUDENT COURSE ACADEMIC OUTCOME ACADEMIC OUTCOME ACADEMIC OUTCOME ACADEMIC OUTCOME ACADEMIC OUTCOME STUDENT COURSE STUDENT	NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO 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.3