SGHE Enterprise Data Warehouse
Banner EDW Source: ACADEMIC_STUDY - NULL
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| ACADEMIC_PERIOD |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_TIME |
ACADEMIC_PERIOD |
RETENTION MULTI YEAR |
NO |
| ACADEMIC_PERIOD_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME |
ACADEMIC_PERIOD_LD ACADEMIC_PERIOD_SD |
RETENTION MULTI YEAR RETENTION MULTI YEAR |
NO NO |
| ACADEMIC_STANDING |
NO |
DIMENSION TABLE |
WDT_STUDENT_PERFORMANCE |
ACADEMIC_STANDING |
STUDENT, STUDENT PROGRESS |
NO |
| ACADEMIC_STANDING_DESC |
NO |
DIMENSION TABLE |
WDT_STUDENT_PERFORMANCE WDT_STUDENT_PERFORMANCE |
ACADEMIC_STANDING_LD ACADEMIC_STANDING_SD |
STUDENT, STUDENT PROGRESS STUDENT, STUDENT PROGRESS |
NO NO |
| ACADEMIC_YEAR |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_TIME |
ACADEMIC_YEAR |
RETENTION MULTI YEAR |
NO |
| ACADEMIC_YEAR_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME |
ACADEMIC_YEAR_LD ACADEMIC_YEAR_SD |
RETENTION MULTI YEAR RETENTION MULTI YEAR |
NO NO |
| ADMINISTRATIVE_GROUP |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE |
ADMINISTRATIVE_GROUP |
RETENTION MULTI YEAR |
NO |
| ADMISSIONS_POPULATION |
NO |
DIMENSION TABLE |
WDT_STUDENT WDT_ACADEMIC_PROGRAM |
ADMISSIONS_POPULATION ADMISSIONS_POPULATION |
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE |
NO NO |
| ADMISSIONS_POPULATION_DESC |
NO |
DIMENSION TABLE |
WDT_STUDENT WDT_STUDENT WDT_ACADEMIC_PROGRAM WDT_ACADEMIC_PROGRAM |
ADMISSIONS_POPULATION_LD ADMISSIONS_POPULATION_SD ADMISSIONS_POPULATION_SD ADMISSIONS_POPULATION_LD |
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO NO NO |
| AGE_ADMITTED |
NO |
FACT TABLE |
WFT_STUDENT |
ADMIT_AGE |
STUDENT |
NO |
| AWARD_CATEGORY |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY WDT_ACADEMIC_PROGRAM |
AWARD_CATEGORY AWARD_CATEGORY |
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE |
NO NO |
| AWARD_CATEGORY_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_PROGRAM WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY WDT_ACADEMIC_PROGRAM |
AWARD_CATEGORY_LD AWARD_CATEGORY_LD AWARD_CATEGORY_SD AWARD_CATEGORY_SD |
ACADEMIC PROGRAM COURSE COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE |
NO NO NO NO |
| CAMPUS |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY WDT_ACADEMIC_PROGRAM |
CAMPUS CAMPUS |
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE |
NO NO |
| CAMPUS_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY WDT_ACADEMIC_PROGRAM WDT_ACADEMIC_PROGRAM |
CAMPUS_LD CAMPUS_SD CAMPUS_SD CAMPUS_LD |
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO NO NO |
| COLLEGE |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY WDT_ACADEMIC_PROGRAM |
COLLEGE COLLEGE |
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE |
NO NO |
| COLLEGE_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY WDT_ACADEMIC_PROGRAM WDT_ACADEMIC_STUDY WDT_ACADEMIC_PROGRAM |
COLLEGE_LD COLLEGE_LD COLLEGE_SD COLLEGE_SD |
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE |
NO NO NO NO |
| COOPERATIVE_EDUCATION_IND |
NO |
DIMENSION TABLE |
WDT_STUDENT_STATUS |
COOP_ED_PARTICIPANT_IND |
STUDENT, STUDENT PROGRESS |
NO |
| CURRICULUM_PRIORITY_NUMBER |
NO |
FACT TABLE |
WFV_ACADEMIC_PROGRAM_COURSE |
CURRICULUM_PRIORITY_NUMBER |
ACADEMIC PROGRAM COURSE |
NO |
| DEGREE |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY WDT_ACADEMIC_PROGRAM |
DEGREE DEGREE |
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE |
NO NO |
| DEGREE_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY WDT_ACADEMIC_PROGRAM WDT_ACADEMIC_PROGRAM |
DEGREE_SD DEGREE_LD DEGREE_LD DEGREE_SD |
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO NO NO |
| DEPARTMENT |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY WDT_MAJOR |
DEPARTMENT DEPARTMENT |
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE |
NO NO |
| DEPARTMENT_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY WDT_CONCENTRATION WDT_MAJOR WDT_MAJOR |
DEPARTMENT_SD DEPARTMENT_LD DEPARTMENT_LD DEPARTMENT_SD DEPARTMENT_LD |
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO NO NO NO |
| EXPECTED_GRADUATION_DATE |
NO |
FACT TABLE |
WFT_STUDENT |
EXPECTED_GRAD_DATE |
STUDENT |
NO |
| FIRST_CONCENTRATION |
NO |
DIMENSION TABLE |
WDT_CONCENTRATION |
CONCENTRATION |
ACADEMIC PROGRAM COURSE |
NO |
| FIRST_CONCENTRATION_DESC |
NO |
DIMENSION TABLE |
WDT_CONCENTRATION WDT_CONCENTRATION |
CONCENTRATION_LD CONCENTRATION_SD |
ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO |
| FIRST_MINOR |
NO |
DIMENSION TABLE |
WDT_MINOR |
MINOR |
ACADEMIC PROGRAM COURSE |
NO |
| FIRST_MINOR_DESC |
NO |
DIMENSION TABLE |
WDT_MINOR WDT_MINOR |
MINOR_SD MINOR_LD |
ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO |
| FOURTH_DEPARTMENT |
NO |
DIMENSION TABLE |
WDT_MAJOR |
DEPARTMENT |
ACADEMIC PROGRAM COURSE |
NO |
| FOURTH_DEPARTMENT_DESC |
NO |
DIMENSION TABLE |
WDT_MAJOR WDT_MAJOR |
DEPARTMENT_SD DEPARTMENT_LD |
ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO |
| FOURTH_MAJOR |
NO |
DIMENSION TABLE |
WDT_CONCENTRATION WDT_MAJOR |
CONCENTRATION_MAJOR MAJOR |
ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO |
| FOURTH_MAJOR_CONC_1 |
NO |
DIMENSION TABLE |
WDT_CONCENTRATION |
CONCENTRATION |
ACADEMIC PROGRAM COURSE |
NO |
| FOURTH_MAJOR_CONC_1_DESC |
NO |
DIMENSION TABLE |
WDT_CONCENTRATION WDT_CONCENTRATION |
CONCENTRATION_LD CONCENTRATION_SD |
ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO |
| FOURTH_MAJOR_CONC_2 |
NO |
DIMENSION TABLE |
WDT_CONCENTRATION |
CONCENTRATION |
ACADEMIC PROGRAM COURSE |
NO |
| FOURTH_MAJOR_CONC_2_DESC |
NO |
DIMENSION TABLE |
WDT_CONCENTRATION WDT_CONCENTRATION |
CONCENTRATION_LD CONCENTRATION_SD |
ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO |
| FOURTH_MAJOR_CONC_3 |
NO |
DIMENSION TABLE |
WDT_CONCENTRATION |
CONCENTRATION |
ACADEMIC PROGRAM COURSE |
NO |
| FOURTH_MAJOR_CONC_3_DESC |
NO |
DIMENSION TABLE |
WDT_CONCENTRATION WDT_CONCENTRATION |
CONCENTRATION_LD CONCENTRATION_SD |
ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO |
| FOURTH_MAJOR_DESC |
NO |
DIMENSION TABLE |
WDT_MAJOR WDT_CONCENTRATION WDT_MAJOR WDT_CONCENTRATION |
MAJOR_SD CONCENTRATION_MAJOR_LD MAJOR_LD CONCENTRATION_MAJOR_SD |
ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO NO NO |
| FOURTH_MINOR |
NO |
DIMENSION TABLE |
WDT_MINOR |
MINOR |
ACADEMIC PROGRAM COURSE |
NO |
| FOURTH_MINOR_DESC |
NO |
DIMENSION TABLE |
WDT_MINOR WDT_MINOR |
MINOR_LD MINOR_SD |
ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO |
| FOURTH_PROGRAM_CLASSIFICATION |
NO |
DIMENSION TABLE |
WDT_MAJOR |
PROGRAM_CLASSIFICATION |
ACADEMIC PROGRAM COURSE |
NO |
| FOURTH_PROGRAM_CLASSIF_DESC |
NO |
DIMENSION TABLE |
WDT_MAJOR WDT_MAJOR |
PROGRAM_CLASSIFICATION_SD PROGRAM_CLASSIFICATION_LD |
ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO |
| FTE_DIVISOR |
NO |
FACT TABLE |
WFT_STUDENT |
FTE_DIVISOR |
STUDENT |
NO |
| INTENDED_TIME_STATUS |
NO |
DIMENSION TABLE |
WDT_ENROLLMENT_STATUS WDT_STUDENT WDT_GRADUATION WDT_GRADUATION WDT_GRADUATION |
INTENDED_TIME_STATUS INTENDED_TIME_STATUS INTENDED_TIME_STATUS INTENDED_TIME_STATUS_SD INTENDED_TIME_STATUS_LD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS GRADUATION COMPLETION GRADUATION COMPLETION GRADUATION COMPLETION |
NO NO NO NO NO |
| LEAVE_DATE_FROM |
NO |
FACT TABLE |
WFT_STUDENT |
LEAVE_FROM_DATE |
STUDENT |
NO |
| LEAVE_DATE_TO |
NO |
FACT TABLE |
WFT_STUDENT |
LEAVE_TO_DATE |
STUDENT |
NO |
| LEAVE_REASON |
NO |
DIMENSION TABLE |
WDT_ENROLLMENT_STATUS |
LEAVE_REASON |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS |
NO |
| LEAVE_REASON_DESC |
NO |
DIMENSION TABLE |
WDT_ENROLLMENT_STATUS WDT_ENROLLMENT_STATUS |
LEAVE_REASON_LD LEAVE_REASON_SD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS |
NO NO |
| MAJOR |
NO |
DIMENSION TABLE |
WDT_MAJOR WDT_ACADEMIC_STUDY WDT_CONCENTRATION |
MAJOR MAJOR CONCENTRATION_MAJOR |
ACADEMIC PROGRAM COURSE COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE |
NO NO NO |
| MAJOR_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY WDT_CONCENTRATION WDT_MAJOR WDT_MAJOR WDT_CONCENTRATION |
MAJOR_LD MAJOR_SD CONCENTRATION_MAJOR_SD MAJOR_LD MAJOR_SD CONCENTRATION_MAJOR_LD |
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO NO NO NO NO |
| MATRICULATED_IND |
NO |
DIMENSION TABLE |
WDT_STUDENT_STATUS |
MATRICULATED_IND |
STUDENT, STUDENT PROGRESS |
NO |
| MULTI_SOURCE |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE |
MULTI_SOURCE |
RETENTION MULTI YEAR |
NO |
| MULTI_SOURCE_DESC |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE WDT_MULTI_SOURCE |
MULTI_SOURCE_SD MULTI_SOURCE_LD |
RETENTION MULTI YEAR RETENTION MULTI YEAR |
NO NO |
| PERMIT_REGISTRATION |
NO |
DIMENSION TABLE |
WDT_STUDENT_STATUS |
PERMIT_REGISTRATION_IND |
STUDENT, STUDENT PROGRESS |
NO |
| PROCESS_GROUP |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE |
PROCESS_GROUP |
RETENTION MULTI YEAR |
NO |
| PROGRAM |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY WDT_ACADEMIC_PROGRAM |
PROGRAM PROGRAM |
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE |
NO NO |
| PROGRAM_CLASSIFICATION |
NO |
DIMENSION TABLE |
WDT_MAJOR WDT_ACADEMIC_STUDY WDT_CONCENTRATION |
PROGRAM_CLASSIFICATION PROGRAM_CLASSIFICATION PROGRAM_CLASSIFICATION_LD |
ACADEMIC PROGRAM COURSE COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE |
NO NO NO |
| PROGRAM_CLASSIFICATION_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY WDT_CONCENTRATION WDT_MAJOR WDT_MAJOR |
PROGRAM_CLASSIFICATION_LD PROGRAM_CLASSIFICATION_SD PROGRAM_CLASSIFICATION_SD PROGRAM_CLASSIFICATION_LD PROGRAM_CLASSIFICATION_SD |
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO NO NO NO |
| PROGRAM_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY WDT_ACADEMIC_PROGRAM WDT_ACADEMIC_STUDY WDT_ACADEMIC_PROGRAM |
PROGRAM_SD PROGRAM_SD PROGRAM_LD PROGRAM_LD |
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE |
NO NO NO NO |
| REGISTERED_IND |
NO |
DIMENSION TABLE |
WDT_STUDENT_STATUS |
REGISTERED_IND |
STUDENT, STUDENT PROGRESS |
NO |
| SECOND_CONCENTRATION |
NO |
DIMENSION TABLE |
WDT_CONCENTRATION |
CONCENTRATION |
ACADEMIC PROGRAM COURSE |
NO |
| SECOND_CONCENTRATION_DESC |
NO |
DIMENSION TABLE |
WDT_CONCENTRATION WDT_CONCENTRATION |
CONCENTRATION_SD CONCENTRATION_LD |
ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO |
| SECOND_DEPARTMENT |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY WDT_MAJOR |
SECOND_DEPARTMENT DEPARTMENT |
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE |
NO NO |
| SECOND_DEPARTMENT_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY WDT_MAJOR WDT_MAJOR |
SECOND_DEPARTMENT_SD SECOND_DEPARTMENT_LD DEPARTMENT_SD DEPARTMENT_LD |
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO NO NO |
| SECOND_MAJOR |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY WDT_CONCENTRATION WDT_MAJOR |
SECOND_MAJOR CONCENTRATION_MAJOR MAJOR |
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO NO |
| SECOND_MAJOR_CONC_1 |
NO |
DIMENSION TABLE |
WDT_CONCENTRATION |
CONCENTRATION |
ACADEMIC PROGRAM COURSE |
NO |
| SECOND_MAJOR_CONC_1_DESC |
NO |
DIMENSION TABLE |
WDT_CONCENTRATION WDT_CONCENTRATION |
CONCENTRATION_SD CONCENTRATION_LD |
ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO |
| SECOND_MAJOR_CONC_2 |
NO |
DIMENSION TABLE |
WDT_CONCENTRATION |
CONCENTRATION |
ACADEMIC PROGRAM COURSE |
NO |
| SECOND_MAJOR_CONC_2_DESC |
NO |
DIMENSION TABLE |
WDT_CONCENTRATION WDT_CONCENTRATION |
CONCENTRATION_SD CONCENTRATION_LD |
ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO |
| SECOND_MAJOR_CONC_3 |
NO |
DIMENSION TABLE |
WDT_CONCENTRATION |
CONCENTRATION |
ACADEMIC PROGRAM COURSE |
NO |
| SECOND_MAJOR_CONC_3_DESC |
NO |
DIMENSION TABLE |
WDT_CONCENTRATION WDT_CONCENTRATION |
CONCENTRATION_LD CONCENTRATION_SD |
ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO |
| SECOND_MAJOR_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY WDT_MAJOR WDT_CONCENTRATION WDT_MAJOR WDT_CONCENTRATION |
SECOND_MAJOR_SD SECOND_MAJOR_LD MAJOR_LD CONCENTRATION_MAJOR_LD MAJOR_SD CONCENTRATION_MAJOR_SD |
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO NO NO NO NO |
| SECOND_MINOR |
NO |
DIMENSION TABLE |
WDT_MINOR |
MINOR |
ACADEMIC PROGRAM COURSE |
NO |
| SECOND_MINOR_DESC |
NO |
DIMENSION TABLE |
WDT_MINOR WDT_MINOR |
MINOR_LD MINOR_SD |
ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO |
| SECOND_PROGRAM_CLASSIFICATION |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY WDT_MAJOR |
SECOND_PROG_CLASSIFICATION PROGRAM_CLASSIFICATION |
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE |
NO NO |
| SECOND_PROGRAM_CLASSIF_DESC |
NO |
DIMENSION TABLE |
WDT_MAJOR WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY WDT_MAJOR |
PROGRAM_CLASSIFICATION_SD SECOND_PROG_CLASSIFICATION_SD SECOND_PROG_CLASSIFICATION_LD PROGRAM_CLASSIFICATION_LD |
ACADEMIC PROGRAM COURSE COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE |
NO NO NO NO |
| SITE |
NO |
DIMENSION TABLE |
WDT_STUDENT |
SITE |
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS |
NO |
| SITE_DESC |
NO |
DIMENSION TABLE |
WDT_STUDENT WDT_STUDENT |
SITE_SD SITE_LD |
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS |
NO NO |
| START_DATE |
NO |
FACT TABLE |
WFT_STUDENT |
START_DATE |
STUDENT |
NO |
| START_DATE_ADMITTED |
NO |
FACT TABLE |
WFT_STUDENT |
START_DATE_ADMITTED |
STUDENT |
NO |
| START_DATE_MATRICULATED |
NO |
FACT TABLE |
WFT_STUDENT |
START_DATE_MATRICULATED |
STUDENT |
NO |
| STUDENT_CLASSIFICATION |
NO |
DIMENSION TABLE |
WDT_STUDENT WDT_ACADEMIC_PROGRAM |
STUDENT_CLASSIFICATION STUDENT_CLASSIFICATION |
ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE |
NO NO |
| STUDENT_CLASSIFICATION_DESC |
NO |
DIMENSION TABLE |
WDT_STUDENT WDT_ACADEMIC_PROGRAM WDT_ACADEMIC_PROGRAM WDT_STUDENT |
STUDENT_CLASSIFICATION_SD STUDENT_CLASSIFICATION_SD STUDENT_CLASSIFICATION_LD STUDENT_CLASSIFICATION_LD |
ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS |
NO NO NO NO |
| STUDENT_FTE |
NO |
FACT TABLE |
WFT_STUDENT |
STUDENT_FTE |
STUDENT |
NO |
| STUDENT_LEVEL |
NO |
DIMENSION TABLE
FACT TABLE |
WDT_ACADEMIC_PROGRAM WDT_ACADEMIC_STUDY WDT_STUDENT_LEVEL WFT_STUDENT |
STUDENT_LEVEL STUDENT_LEVEL STUDENT_LEVEL STUDENT_LEVEL |
ACADEMIC PROGRAM COURSE COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS RETENTION MULTI YEAR STUDENT |
NO NO NO NO |
| STUDENT_LEVEL_DESC |
NO |
DIMENSION TABLE |
WDT_STUDENT_LEVEL WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY WDT_ACADEMIC_PROGRAM WDT_ACADEMIC_PROGRAM WDT_STUDENT_LEVEL |
STUDENT_LEVEL_LD STUDENT_LEVEL_SD STUDENT_LEVEL_LD STUDENT_LEVEL_LD STUDENT_LEVEL_SD STUDENT_LEVEL_SD |
RETENTION MULTI YEAR COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE RETENTION MULTI YEAR |
NO NO NO NO NO NO |
| STUDENT_POPULATION |
NO |
DIMENSION TABLE |
WDT_STUDENT WDT_ACADEMIC_PROGRAM |
STUDENT_POPULATION STUDENT_POPULATION |
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE |
NO NO |
| STUDENT_POPULATION_DESC |
NO |
DIMENSION TABLE |
WDT_STUDENT WDT_STUDENT WDT_ACADEMIC_PROGRAM WDT_ACADEMIC_PROGRAM |
STUDENT_POPULATION_SD STUDENT_POPULATION_LD STUDENT_POPULATION_LD STUDENT_POPULATION_SD |
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO NO NO |
| STUDENT_RATE |
NO |
DIMENSION TABLE |
WDT_STUDENT |
RATE |
STUDENT, STUDENT PROGRESS |
NO |
| STUDENT_RATE_DESC |
NO |
DIMENSION TABLE |
WDT_STUDENT WDT_STUDENT |
RATE_SD RATE_LD |
STUDENT, STUDENT PROGRESS STUDENT, STUDENT PROGRESS |
NO NO |
| SUB_ACADEMIC_PERIOD |
NO |
DIMENSION TABLE |
WDT_TIME |
SUB_ACADEMIC_PERIOD |
ADVANCEMENT GIFT, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYMENT APPLICATION |
NO |
| SUB_ACADEMIC_PERIOD_DESC |
NO |
DIMENSION TABLE |
WDT_TIME WDT_TIME |
SUB_ACADEMIC_PERIOD_LD SUB_ACADEMIC_PERIOD_SD |
ADVANCEMENT GIFT, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, OPERATING LEDGER ADVANCEMENT GIFT, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, OPERATING LEDGER |
NO NO |
| THIRD_CONCENTRATION |
NO |
DIMENSION TABLE |
WDT_CONCENTRATION |
CONCENTRATION |
ACADEMIC PROGRAM COURSE |
NO |
| THIRD_CONCENTRATION_DESC |
NO |
DIMENSION TABLE |
WDT_CONCENTRATION WDT_CONCENTRATION |
CONCENTRATION_LD CONCENTRATION_SD |
ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO |
| THIRD_DEPARTMENT |
NO |
DIMENSION TABLE |
WDT_MAJOR |
DEPARTMENT |
ACADEMIC PROGRAM COURSE |
NO |
| THIRD_DEPARTMENT_DESC |
NO |
DIMENSION TABLE |
WDT_MAJOR WDT_MAJOR |
DEPARTMENT_LD DEPARTMENT_SD |
ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO |
| THIRD_MAJOR |
NO |
DIMENSION TABLE |
WDT_CONCENTRATION WDT_MAJOR |
CONCENTRATION_MAJOR MAJOR |
ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO |
| THIRD_MAJOR_CONC_1 |
NO |
DIMENSION TABLE |
WDT_CONCENTRATION |
CONCENTRATION |
ACADEMIC PROGRAM COURSE |
NO |
| THIRD_MAJOR_CONC_1_DESC |
NO |
DIMENSION TABLE |
WDT_CONCENTRATION WDT_CONCENTRATION |
CONCENTRATION_LD CONCENTRATION_SD |
ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO |
| THIRD_MAJOR_CONC_2 |
NO |
DIMENSION TABLE |
WDT_CONCENTRATION |
CONCENTRATION |
ACADEMIC PROGRAM COURSE |
NO |
| THIRD_MAJOR_CONC_2_DESC |
NO |
DIMENSION TABLE |
WDT_CONCENTRATION WDT_CONCENTRATION |
CONCENTRATION_LD CONCENTRATION_SD |
ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO |
| THIRD_MAJOR_CONC_3 |
NO |
DIMENSION TABLE |
WDT_CONCENTRATION |
CONCENTRATION |
ACADEMIC PROGRAM COURSE |
NO |
| THIRD_MAJOR_CONC_3_DESC |
NO |
DIMENSION TABLE |
WDT_CONCENTRATION WDT_CONCENTRATION |
CONCENTRATION_SD CONCENTRATION_LD |
ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO |
| THIRD_MAJOR_DESC |
NO |
DIMENSION TABLE |
WDT_CONCENTRATION WDT_MAJOR WDT_CONCENTRATION WDT_MAJOR |
CONCENTRATION_MAJOR_SD MAJOR_SD CONCENTRATION_MAJOR_LD MAJOR_LD |
ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO NO NO |
| THIRD_MINOR |
NO |
DIMENSION TABLE |
WDT_MINOR |
MINOR |
ACADEMIC PROGRAM COURSE |
NO |
| THIRD_MINOR_DESC |
NO |
DIMENSION TABLE |
WDT_MINOR WDT_MINOR |
MINOR_SD MINOR_LD |
ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO |
| THIRD_PROGRAM_CLASSIFICATION |
NO |
DIMENSION TABLE |
WDT_MAJOR |
PROGRAM_CLASSIFICATION |
ACADEMIC PROGRAM COURSE |
NO |
| THIRD_PROGRAM_CLASSIF_DESC |
NO |
DIMENSION TABLE |
WDT_MAJOR WDT_MAJOR |
PROGRAM_CLASSIFICATION_LD PROGRAM_CLASSIFICATION_SD |
ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO |