SGHE Enterprise Data Warehouse
Banner EDW Source: ADMISSIONS_APPLICATION
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| ACADEMIC_PERIOD |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_TIME WDT_TIME |
ACADEMIC_PERIOD ACADEMIC_PERIOD |
ADMISSIONS APPLICATION RECRUITING AND ADMISSION |
NO NO |
| ACADEMIC_PERIOD_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME WDT_TIME WDT_TIME |
ACADEMIC_PERIOD_LD ACADEMIC_PERIOD_SD ACADEMIC_PERIOD_LD ACADEMIC_PERIOD_SD |
ADMISSIONS APPLICATION ADMISSIONS APPLICATION 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 RECRUITING AND ADMISSION |
NO NO |
| ACADEMIC_YEAR_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME WDT_TIME WDT_TIME |
ACADEMIC_YEAR_LD ACADEMIC_YEAR_SD ACADEMIC_YEAR_LD ACADEMIC_YEAR_SD |
ADMISSIONS APPLICATION ADMISSIONS APPLICATION RECRUITING AND ADMISSION 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_NUMBER_KEY |
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_LD APPLICATION_STATUS_SD |
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 |
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_LD AWARD_CATEGORY_SD |
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_LD CAMPUS_SD |
ADMISSIONS APPLICATION ADMISSIONS APPLICATION |
NO NO |
| CITY |
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_LD COLLEGE_SD |
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_LD COUNTY_SD |
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_LD DEGREE_SD |
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 WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY |
DEPARTMENT_LD DEPARTMENT_SD SECOND_DEPARTMENT_LD SECOND_DEPARTMENT_SD |
ADMISSIONS APPLICATION, RECRUITING AND ADMISSION ADMISSIONS APPLICATION, RECRUITING AND ADMISSION ADMISSIONS APPLICATION ADMISSIONS APPLICATION |
NO NO 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 |
| FINAID_APPLICANT_IND |
NO |
|
|
|
|
|
| FUNCTION |
NO |
DIMENSION TABLE |
WDT_PRE_STUDENT_STATUS WDT_FINANCIAL_AID_STATUS WDT_PRE_STUDENT_STATUS |
APPLIED_IND FINANCIAL_AID_APPLICANT_IND INQUIRED_IND |
FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION ADMISSIONS APPLICATION, RECRUITING AND ADMISSION ADMISSIONS APPLICATION, RECRUITING AND ADMISSION |
NO NO NO |
| INQUIRER_IND |
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 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 WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY |
MAJOR_LD MAJOR_SD SECOND_MAJOR_LD SECOND_MAJOR_SD |
ADMISSIONS APPLICATION, RECRUITING AND ADMISSION ADMISSIONS APPLICATION, RECRUITING AND ADMISSION ADMISSIONS APPLICATION ADMISSIONS APPLICATION |
NO NO 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_ADMIT_DESC |
NO |
|
|
|
|
|
| NATION_DESC_ADMIT |
NO |
DIMENSION TABLE |
WDT_POSTAL WDT_POSTAL |
NATION_LD NATION_SD |
ADMISSIONS APPLICATION ADMISSIONS APPLICATION |
NO NO |
| PERSON_UID |
NO |
DIMENSION TABLE
FACT TABLE |
WDT_PERSON WFT_ADMISSIONS_APPLICATION WFT_PROSPECTIVE_STUDENT WFT_RECRUITING_AND_ADMISSION |
PERSON_UID PERSON_UID PERSON_UID PERSON_UID |
ADMISSIONS APPLICATION, PROSPECTIVE STUDENT ADMISSIONS APPLICATION PROSPECTIVE STUDENT RECRUITING AND ADMISSION |
NO NO NO NO |
| POSTAL_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 WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY |
PROGRAM_CLASSIFICATION_LD PROGRAM_CLASSIFICATION_SD SECOND_PROG_CLASSIFICATION_LD SECOND_PROG_CLASSIFICATION_SD |
ADMISSIONS APPLICATION, RECRUITING AND ADMISSION ADMISSIONS APPLICATION, RECRUITING AND ADMISSION ADMISSIONS APPLICATION ADMISSIONS APPLICATION |
NO NO 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_MAJOR |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY |
SECOND_MAJOR |
ADMISSIONS APPLICATION |
NO |
| SECOND_PROGRAM_CLASSIFICATION |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY |
SECOND_PROG_CLASSIFICATION |
ADMISSIONS APPLICATION |
NO |
| SEQUENCE_NUMBER |
NO |
FACT TABLE |
WFT_RECRUITING_AND_ADMISSION |
SEQUENCE_NUMBER |
RECRUITING AND ADMISSION |
NO |
| SITE |
NO |
DIMENSION TABLE |
WDT_STUDENT |
SITE |
ADMISSIONS APPLICATION |
NO |
| SITE_DESC |
NO |
DIMENSION TABLE |
WDT_STUDENT WDT_STUDENT |
SITE_LD SITE_SD |
ADMISSIONS APPLICATION ADMISSIONS APPLICATION |
NO NO |
| STATE_ADMIT |
NO |
DIMENSION TABLE |
WDT_POSTAL |
STATE_PROVINCE |
ADMISSIONS APPLICATION |
NO |
| STATE_DESC_ADMIT |
NO |
|
|
|
|
|
| STATE_PROVINCE_ADMIT |
NO |
|
|
|
|
|
| STATE_PROVINCE_ADMIT_DESC |
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 |