SGHE Enterprise Data Warehouse
Banner EDW Source: ADMISSIONS_APPLICATION - NULL
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| ACADEMIC_PERIOD |
NO |
DIMENSION TABLE |
WDT_TIME WDT_ACADEMIC_TIME |
ACADEMIC_PERIOD ACADEMIC_PERIOD |
RECRUITING AND ADMISSION ADMISSIONS APPLICATION, RACE |
NO NO |
| ACADEMIC_PERIOD_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME WDT_TIME WDT_TIME |
ACADEMIC_PERIOD_SD ACADEMIC_PERIOD_LD ACADEMIC_PERIOD_SD ACADEMIC_PERIOD_LD |
ADMISSIONS APPLICATION, RACE ADMISSIONS APPLICATION, RACE RECRUITING AND ADMISSION RECRUITING AND ADMISSION |
NO NO NO NO |
| ACADEMIC_YEAR |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_TIME WDT_TIME |
ACADEMIC_YEAR ACADEMIC_YEAR |
ADMISSIONS APPLICATION, RACE RECRUITING AND ADMISSION |
NO NO |
| ACADEMIC_YEAR_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_TIME WDT_TIME WDT_ACADEMIC_TIME WDT_TIME |
ACADEMIC_YEAR_SD ACADEMIC_YEAR_LD ACADEMIC_YEAR_LD ACADEMIC_YEAR_SD |
ADMISSIONS APPLICATION, RACE RECRUITING AND ADMISSION ADMISSIONS APPLICATION, RACE RECRUITING AND ADMISSION |
NO NO NO NO |
| ADMINISTRATIVE_GROUP |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE |
ADMINISTRATIVE_GROUP |
ADMISSIONS APPLICATION, RECRUITING AND ADMISSION |
NO |
| ADMISSIONS_POPULATION |
NO |
DIMENSION TABLE |
WDT_STUDENT |
ADMISSIONS_POPULATION |
ADMISSIONS APPLICATION |
NO |
| ADMISSIONS_POPULATION_DESC |
NO |
DIMENSION TABLE |
WDT_STUDENT WDT_STUDENT |
ADMISSIONS_POPULATION_LD ADMISSIONS_POPULATION_SD |
ADMISSIONS APPLICATION ADMISSIONS APPLICATION |
NO NO |
| APPLICATION_DATE |
NO |
DIMENSION TABLE
FACT TABLE |
WDT_TIME WDT_TIME WFT_ADMISSIONS_APPLICATION |
CALENDAR_MONTH CALENDAR_YEAR APPLICATION_DATE |
RECRUITING AND ADMISSION RECRUITING AND ADMISSION ADMISSIONS APPLICATION |
NO NO NO |
| APPLICATION_FEE_RECEIVED_DATE |
NO |
FACT TABLE |
WFT_ADMISSIONS_APPLICATION |
APPLICATION_FEE_RECEIVED_DATE |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_FEE_REQUIRED_IND |
NO |
FACT TABLE |
WFT_ADMISSIONS_APPLICATION |
APPLICATION_FEE_REQUIRED_IND |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_IND1 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_IND |
APPL_SUPL_IND_01 |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_IND10 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_IND |
APPL_SUPL_IND_10 |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_IND2 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_IND |
APPL_SUPL_IND_02 |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_IND3 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_IND |
APPL_SUPL_IND_03 |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_IND4 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_IND |
APPL_SUPL_IND_04 |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_IND5 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_IND |
APPL_SUPL_IND_05 |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_IND6 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_IND |
APPL_SUPL_IND_06 |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_IND7 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_IND |
APPL_SUPL_IND_07 |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_IND8 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_IND |
APPL_SUPL_IND_08 |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_IND9 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_IND |
APPL_SUPL_IND_09 |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_IND_TYPE1 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_IND |
APPL_SUPL_IND_01_TYPE |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_IND_TYPE10 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_IND |
APPL_SUPL_IND_10_TYPE |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_IND_TYPE2 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_IND |
APPL_SUPL_IND_02_TYPE |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_IND_TYPE3 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_IND |
APPL_SUPL_IND_03_TYPE |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_IND_TYPE4 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_IND |
APPL_SUPL_IND_04_TYPE |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_IND_TYPE5 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_IND |
APPL_SUPL_IND_05_TYPE |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_IND_TYPE6 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_IND |
APPL_SUPL_IND_06_TYPE |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_IND_TYPE7 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_IND |
APPL_SUPL_IND_07_TYPE |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_IND_TYPE8 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_IND |
APPL_SUPL_IND_08_TYPE |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_IND_TYPE9 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_IND |
APPL_SUPL_IND_09_TYPE |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO1 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_01 |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO10 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_10 |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO11 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_11 |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO12 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_12 |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO13 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_13 |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO14 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_14 |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO15 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_15 |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO16 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_16 |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO17 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_17 |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO18 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_18 |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO19 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_19 |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO2 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_04 APPL_SUPL_DATA_02 |
ADMISSIONS APPLICATION ADMISSIONS APPLICATION |
NO NO |
| APPLICATION_INFO20 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_20 |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO3 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_03 |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO5 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_05 |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO6 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_06 |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO7 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_07 |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO8 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_08 |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO9 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_09 |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO_TYPE1 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_01_TYPE |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO_TYPE10 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_10_TYPE |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO_TYPE11 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_11_TYPE |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO_TYPE12 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_12_TYPE |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO_TYPE13 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_13_TYPE |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO_TYPE14 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_14_TYPE |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO_TYPE15 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_15_TYPE |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO_TYPE16 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_16_TYPE |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO_TYPE17 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_17_TYPE |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO_TYPE18 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_18_TYPE |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO_TYPE19 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_19_TYPE |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO_TYPE2 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_02_TYPE |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO_TYPE20 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_20_TYPE |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO_TYPE3 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_03_TYPE |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO_TYPE4 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_04_TYPE |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO_TYPE5 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_05_TYPE |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO_TYPE6 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_06_TYPE |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO_TYPE7 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_07_TYPE |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO_TYPE8 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_08_TYPE |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_INFO_TYPE9 |
NO |
DIMENSION TABLE |
WDT_APPLICATION_SUPL_DATA |
APPL_SUPL_DATA_09_TYPE |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_STATUS |
NO |
DIMENSION TABLE |
WDT_STUDENT_APPLICATION |
APPLICATION_STATUS |
ADMISSIONS APPLICATION, RECRUITING AND ADMISSION |
NO |
| APPLICATION_STATUS_DATE |
NO |
FACT TABLE |
WFT_ADMISSIONS_APPLICATION |
APPLICATION_STATUS_DATE |
ADMISSIONS APPLICATION |
NO |
| APPLICATION_STATUS_DESC |
NO |
DIMENSION TABLE |
WDT_STUDENT_APPLICATION WDT_STUDENT_APPLICATION |
APPLICATION_STATUS_SD APPLICATION_STATUS_LD |
ADMISSIONS APPLICATION, RECRUITING AND ADMISSION ADMISSIONS APPLICATION, RECRUITING AND ADMISSION |
NO NO |
| APPL_ACCEPT_ANY_TIME_IND |
NO |
DIMENSION TABLE |
WDT_PRE_STUDENT_STATUS |
ACCEPTED_IND |
ADMISSIONS APPLICATION, FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS |
NO |
| AWARD_CATEGORY |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY |
AWARD_CATEGORY |
ADMISSIONS APPLICATION, RECRUITING AND ADMISSION |
NO |
| AWARD_CATEGORY_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY |
AWARD_CATEGORY_SD AWARD_CATEGORY_LD |
ADMISSIONS APPLICATION, RECRUITING AND ADMISSION ADMISSIONS APPLICATION, RECRUITING AND ADMISSION |
NO NO |
| CAMPUS |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY |
CAMPUS |
ADMISSIONS APPLICATION |
NO |
| CAMPUS_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY |
CAMPUS_SD CAMPUS_LD |
ADMISSIONS APPLICATION ADMISSIONS APPLICATION |
NO NO |
| COLLEGE |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY |
COLLEGE |
ADMISSIONS APPLICATION, RECRUITING AND ADMISSION |
NO |
| COLLEGE_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY |
COLLEGE_SD COLLEGE_LD |
ADMISSIONS APPLICATION, RECRUITING AND ADMISSION ADMISSIONS APPLICATION, RECRUITING AND ADMISSION |
NO NO |
| COMPLETE_IND |
NO |
FACT TABLE |
WFT_ADMISSIONS_APPLICATION |
APPLICATION_COMPLETE_IND |
ADMISSIONS APPLICATION |
NO |
| COUNTY_ADMIT |
NO |
DIMENSION TABLE |
WDT_POSTAL |
COUNTY |
ADMISSIONS APPLICATION |
NO |
| COUNTY_DESC_ADMIT |
NO |
DIMENSION TABLE |
WDT_POSTAL WDT_POSTAL |
COUNTY_SD COUNTY_LD |
ADMISSIONS APPLICATION ADMISSIONS APPLICATION |
NO NO |
| DEGREE |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY |
DEGREE |
ADMISSIONS APPLICATION, RECRUITING AND ADMISSION |
NO |
| DEGREE_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY |
DEGREE_SD DEGREE_LD |
ADMISSIONS APPLICATION, RECRUITING AND ADMISSION ADMISSIONS APPLICATION, RECRUITING AND ADMISSION |
NO NO |
| DEPARTMENT |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY |
DEPARTMENT |
ADMISSIONS APPLICATION, RECRUITING AND ADMISSION |
NO |
| DEPARTMENT_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY |
DEPARTMENT_LD DEPARTMENT_SD |
ADMISSIONS APPLICATION, RECRUITING AND ADMISSION ADMISSIONS APPLICATION, RECRUITING AND ADMISSION |
NO NO |
| EDUCATION_GOAL |
NO |
DIMENSION TABLE |
WDT_STUDENT |
EDUCATION_GOAL |
ADMISSIONS APPLICATION |
NO |
| EDUCATION_GOAL_DESC |
NO |
DIMENSION TABLE |
WDT_STUDENT WDT_STUDENT |
EDUCATION_GOAL_LD EDUCATION_GOAL_SD |
ADMISSIONS APPLICATION ADMISSIONS APPLICATION |
NO NO |
| EDUCATION_LEVEL |
NO |
DIMENSION TABLE |
WDT_STUDENT |
EDUCATION_LEVEL |
ADMISSIONS APPLICATION |
NO |
| EDUCATION_LEVEL_DESC |
NO |
DIMENSION TABLE |
WDT_STUDENT WDT_STUDENT |
EDUCATION_LEVEL_LD EDUCATION_LEVEL_SD |
ADMISSIONS APPLICATION ADMISSIONS APPLICATION |
NO NO |
| ENROLLED_IND |
NO |
DIMENSION TABLE |
WDT_PRE_STUDENT_STATUS |
ENROLLED_IND |
FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION |
NO |
| FUNCTION |
NO |
DIMENSION TABLE |
WDT_PRE_STUDENT_STATUS WDT_FINANCIAL_AID_STATUS WDT_PRE_STUDENT_STATUS |
INQUIRED_IND FINANCIAL_AID_APPLICANT_IND APPLIED_IND |
RECRUITING AND ADMISSION ADMISSIONS APPLICATION, RECRUITING AND ADMISSION FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION |
NO NO NO |
| INSTITUTION_ATTENDING |
NO |
DIMENSION TABLE |
WDT_STUDENT_APPLICATION |
INSTITUTION_ATTENDING |
ADMISSIONS APPLICATION, RECRUITING AND ADMISSION |
NO |
| INSTITUTION_ATTENDING_DESC |
NO |
DIMENSION TABLE |
WDT_STUDENT_APPLICATION WDT_STUDENT_APPLICATION |
INSTITUTION_ATTENDING_LD INSTITUTION_ATTENDING_SD |
ADMISSIONS APPLICATION, RECRUITING AND ADMISSION ADMISSIONS APPLICATION, RECRUITING AND ADMISSION |
NO NO |
| INST_ADMIT_ANY_TIME_IND |
NO |
DIMENSION TABLE |
WDT_PRE_STUDENT_STATUS WDT_PRE_STUDENT_STATUS |
ADMITTED_IND ENROLLED_IND |
ADMISSIONS APPLICATION, FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS ADMISSIONS APPLICATION |
NO NO |
| INTENDED_TIME_STATUS |
NO |
DIMENSION TABLE |
WDT_STUDENT |
INTENDED_TIME_STATUS |
ADMISSIONS APPLICATION |
NO |
| MAJOR |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY |
MAJOR |
ADMISSIONS APPLICATION, RECRUITING AND ADMISSION |
NO |
| MAJOR_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY |
MAJOR_SD MAJOR_LD |
ADMISSIONS APPLICATION, RECRUITING AND ADMISSION ADMISSIONS APPLICATION, RECRUITING AND ADMISSION |
NO NO |
| MULTI_SOURCE |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE |
MULTI_SOURCE |
ADMISSIONS APPLICATION, RECRUITING AND ADMISSION |
NO |
| MULTI_SOURCE_DESC |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE WDT_MULTI_SOURCE |
MULTI_SOURCE_LD MULTI_SOURCE_SD |
ADMISSIONS APPLICATION, RECRUITING AND ADMISSION ADMISSIONS APPLICATION, RECRUITING AND ADMISSION |
NO NO |
| NATION_ADMIT |
NO |
DIMENSION TABLE |
WDT_POSTAL |
NATION |
ADMISSIONS APPLICATION, INSTITUTION, PROSPECTIVE STUDENT |
NO |
| NATION_DESC_ADMIT |
NO |
DIMENSION TABLE |
WDT_POSTAL WDT_POSTAL |
NATION_SD NATION_LD |
ADMISSIONS APPLICATION ADMISSIONS APPLICATION |
NO NO |
| PERSON_UID |
NO |
DIMENSION TABLE
FACT TABLE |
WDT_PERSON WFT_PROSPECTIVE_STUDENT WFT_ADMISSIONS_APPLICATION WFT_RECRUITING_AND_ADMISSION |
PERSON_UID PERSON_UID PERSON_UID PERSON_UID |
ADMISSIONS APPLICATION, PROSPECTIVE STUDENT PROSPECTIVE STUDENT ADMISSIONS APPLICATION RECRUITING AND ADMISSION |
NO NO NO NO |
| POST_CODE_ADMIT |
NO |
DIMENSION TABLE |
WDT_POSTAL |
POSTAL_CODE |
ADMISSIONS APPLICATION |
NO |
| PRIMARY_SOURCE |
NO |
DIMENSION TABLE |
WDT_STUDENT_APPLICATION |
PRIMARY_SOURCE |
ADMISSIONS APPLICATION |
NO |
| PRIMARY_SOURCE_DESC |
NO |
DIMENSION TABLE |
WDT_STUDENT_APPLICATION WDT_STUDENT_APPLICATION |
PRIMARY_SOURCE_LD PRIMARY_SOURCE_SD |
ADMISSIONS APPLICATION, RECRUITING AND ADMISSION ADMISSIONS APPLICATION |
NO NO |
| PROCESS_GROUP |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE |
PROCESS_GROUP |
ADMISSIONS APPLICATION, RECRUITING AND ADMISSION |
NO |
| PROGRAM |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY |
PROGRAM |
ADMISSIONS APPLICATION, RECRUITING AND ADMISSION |
NO |
| PROGRAM_CLASSIFICATION |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY |
PROGRAM_CLASSIFICATION |
ADMISSIONS APPLICATION, RECRUITING AND ADMISSION |
NO |
| PROGRAM_CLASSIFICATION_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY |
PROGRAM_CLASSIFICATION_LD PROGRAM_CLASSIFICATION_SD |
ADMISSIONS APPLICATION, RECRUITING AND ADMISSION ADMISSIONS APPLICATION, RECRUITING AND ADMISSION |
NO NO |
| PROGRAM_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY |
PROGRAM_LD PROGRAM_SD |
ADMISSIONS APPLICATION, RECRUITING AND ADMISSION ADMISSIONS APPLICATION, RECRUITING AND ADMISSION |
NO NO |
| RATE |
NO |
DIMENSION TABLE |
WDT_STUDENT |
RATE |
ADMISSIONS APPLICATION |
NO |
| RATE_DESC |
NO |
DIMENSION TABLE |
WDT_STUDENT WDT_STUDENT |
RATE_LD RATE_SD |
ADMISSIONS APPLICATION ADMISSIONS APPLICATION |
NO NO |
| RECRUITER |
NO |
DIMENSION TABLE |
WDT_STUDENT_APPLICATION |
RECRUITER |
ADMISSIONS APPLICATION, RECRUITING AND ADMISSION |
NO |
| RECRUITER_DESC |
NO |
DIMENSION TABLE |
WDT_STUDENT_APPLICATION WDT_STUDENT_APPLICATION |
RECRUITER_LD RECRUITER_SD |
ADMISSIONS APPLICATION, RECRUITING AND ADMISSION ADMISSIONS APPLICATION, RECRUITING AND ADMISSION |
NO NO |
| RECRUIT_TYPE |
NO |
DIMENSION TABLE |
WDT_STUDENT_APPLICATION |
RECRUIT_TYPE |
ADMISSIONS APPLICATION, RECRUITING AND ADMISSION |
NO |
| RECRUIT_TYPE_DESC |
NO |
DIMENSION TABLE |
WDT_STUDENT_APPLICATION WDT_STUDENT_APPLICATION |
RECRUIT_TYPE_LD RECRUIT_TYPE_SD |
ADMISSIONS APPLICATION, RECRUITING AND ADMISSION ADMISSIONS APPLICATION, RECRUITING AND ADMISSION |
NO NO |
| RESIDENCY |
NO |
DIMENSION TABLE |
WDT_STUDENT |
RESIDENCY |
ADMISSIONS APPLICATION |
NO |
| RESIDENCY_DESC |
NO |
DIMENSION TABLE |
WDT_STUDENT WDT_STUDENT |
RESIDENCY_LD RESIDENCY_SD |
ADMISSIONS APPLICATION ADMISSIONS APPLICATION |
NO NO |
| RESIDENCY_IND |
NO |
DIMENSION TABLE |
WDT_STUDENT |
RESIDENCY_IND |
ADMISSIONS APPLICATION |
NO |
| SECOND_DEPARTMENT |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY |
SECOND_DEPARTMENT |
ADMISSIONS APPLICATION |
NO |
| SECOND_DEPARTMENT_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY |
SECOND_DEPARTMENT_LD SECOND_DEPARTMENT_SD |
ADMISSIONS APPLICATION ADMISSIONS APPLICATION |
NO NO |
| SECOND_MAJOR |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY |
SECOND_MAJOR |
ADMISSIONS APPLICATION |
NO |
| SECOND_MAJOR_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY |
SECOND_MAJOR_SD SECOND_MAJOR_LD |
ADMISSIONS APPLICATION ADMISSIONS APPLICATION |
NO NO |
| SECOND_PROGRAM_CLASSIFICATION |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY |
SECOND_PROG_CLASSIFICATION |
ADMISSIONS APPLICATION |
NO |
| SECOND_PROGRAM_CLASSIF_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY |
SECOND_PROG_CLASSIFICATION_LD SECOND_PROG_CLASSIFICATION_SD |
ADMISSIONS APPLICATION ADMISSIONS APPLICATION |
NO NO |
| SITE |
NO |
DIMENSION TABLE |
WDT_STUDENT |
SITE |
ADMISSIONS APPLICATION |
NO |
| SITE_DESC |
NO |
DIMENSION TABLE |
WDT_STUDENT WDT_STUDENT |
SITE_SD SITE_LD |
ADMISSIONS APPLICATION ADMISSIONS APPLICATION |
NO NO |
| STATE_ADMIT |
NO |
DIMENSION TABLE |
WDT_POSTAL |
STATE_PROVINCE |
ADMISSIONS APPLICATION |
NO |
| STUDENT_LEVEL |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY |
STUDENT_LEVEL |
ADMISSIONS APPLICATION, RECRUITING AND ADMISSION |
NO |
| STUDENT_LEVEL_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY |
STUDENT_LEVEL_LD STUDENT_LEVEL_SD |
ADMISSIONS APPLICATION, RECRUITING AND ADMISSION ADMISSIONS APPLICATION, RECRUITING AND ADMISSION |
NO NO |
| STUDENT_POPULATION |
NO |
DIMENSION TABLE |
WDT_STUDENT |
STUDENT_POPULATION |
ADMISSIONS APPLICATION |
NO |
| STUDENT_POPULATION_DESC |
NO |
DIMENSION TABLE |
WDT_STUDENT WDT_STUDENT |
STUDENT_POPULATION_LD STUDENT_POPULATION_SD |
ADMISSIONS APPLICATION ADMISSIONS APPLICATION |
NO NO |
| WITHDRAWAL_REASON |
NO |
DIMENSION TABLE |
WDT_STUDENT_APPLICATION |
WITHDRAWAL_REASON |
ADMISSIONS APPLICATION, RECRUITING AND ADMISSION |
NO |
| WITHDRAWAL_REASON_DESC |
NO |
DIMENSION TABLE |
WDT_STUDENT_APPLICATION WDT_STUDENT_APPLICATION |
WITHDRAWAL_REASON_LD WITHDRAWAL_REASON_SD |
ADMISSIONS APPLICATION, RECRUITING AND ADMISSION ADMISSIONS APPLICATION, RECRUITING AND ADMISSION |
NO NO |