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_SD ACADEMIC_PERIOD_LD |
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_LD ADMISSIONS_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 |
| 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_SD AWARD_CATEGORY_SD AWARD_CATEGORY_LD AWARD_CATEGORY_LD |
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_PROGRAM WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY WDT_ACADEMIC_PROGRAM |
CAMPUS_LD CAMPUS_SD CAMPUS_LD CAMPUS_SD |
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 |
| COLLEGE |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_PROGRAM WDT_ACADEMIC_STUDY |
COLLEGE COLLEGE |
ACADEMIC PROGRAM COURSE COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS |
NO NO |
| COLLEGE_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY WDT_ACADEMIC_PROGRAM WDT_ACADEMIC_PROGRAM |
COLLEGE_LD COLLEGE_SD COLLEGE_LD COLLEGE_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 |
| 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_MAJOR WDT_ACADEMIC_STUDY WDT_MAJOR WDT_CONCENTRATION |
DEPARTMENT_SD DEPARTMENT_SD DEPARTMENT_LD DEPARTMENT_LD DEPARTMENT_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 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_CONCENTRATION WDT_CONCENTRATION WDT_MAJOR WDT_MAJOR |
CONCENTRATION_MAJOR_SD CONCENTRATION_MAJOR_LD MAJOR_LD 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_LD PROGRAM_CLASSIFICATION_SD |
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_ACADEMIC_STUDY WDT_CONCENTRATION WDT_MAJOR |
MAJOR CONCENTRATION_MAJOR MAJOR |
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO NO |
| MAJOR_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY WDT_MAJOR WDT_CONCENTRATION WDT_ACADEMIC_STUDY WDT_CONCENTRATION WDT_MAJOR |
MAJOR_SD MAJOR_SD CONCENTRATION_MAJOR_LD MAJOR_LD CONCENTRATION_MAJOR_SD MAJOR_LD |
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS 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_LD MULTI_SOURCE_SD |
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_ACADEMIC_STUDY WDT_CONCENTRATION WDT_MAJOR |
PROGRAM_CLASSIFICATION PROGRAM_CLASSIFICATION_LD PROGRAM_CLASSIFICATION |
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO NO |
| PROGRAM_CLASSIFICATION_DESC |
NO |
DIMENSION TABLE |
WDT_MAJOR WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY WDT_MAJOR WDT_CONCENTRATION |
PROGRAM_CLASSIFICATION_SD PROGRAM_CLASSIFICATION_LD PROGRAM_CLASSIFICATION_SD PROGRAM_CLASSIFICATION_LD PROGRAM_CLASSIFICATION_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 ACADEMIC PROGRAM COURSE |
NO NO NO NO NO |
| PROGRAM_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY WDT_ACADEMIC_PROGRAM WDT_ACADEMIC_PROGRAM |
PROGRAM_SD PROGRAM_LD PROGRAM_LD PROGRAM_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 |
| 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_LD CONCENTRATION_SD |
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_LD SECOND_DEPARTMENT_SD 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_MAJOR WDT_ACADEMIC_STUDY WDT_CONCENTRATION |
MAJOR SECOND_MAJOR CONCENTRATION_MAJOR |
ACADEMIC PROGRAM COURSE COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS 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_LD CONCENTRATION_SD |
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_CONCENTRATION WDT_MAJOR WDT_CONCENTRATION WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY WDT_MAJOR |
CONCENTRATION_MAJOR_LD MAJOR_SD CONCENTRATION_MAJOR_SD SECOND_MAJOR_LD SECOND_MAJOR_SD MAJOR_LD |
ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE 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 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_ACADEMIC_STUDY WDT_ACADEMIC_STUDY WDT_MAJOR WDT_MAJOR |
SECOND_PROG_CLASSIFICATION_SD SECOND_PROG_CLASSIFICATION_LD PROGRAM_CLASSIFICATION_SD PROGRAM_CLASSIFICATION_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 |
| 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_ACADEMIC_PROGRAM WDT_STUDENT |
STUDENT_CLASSIFICATION STUDENT_CLASSIFICATION |
ACADEMIC PROGRAM COURSE ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS |
NO NO |
| STUDENT_CLASSIFICATION_DESC |
NO |
DIMENSION TABLE |
WDT_STUDENT WDT_STUDENT WDT_ACADEMIC_PROGRAM WDT_ACADEMIC_PROGRAM |
STUDENT_CLASSIFICATION_LD STUDENT_CLASSIFICATION_SD STUDENT_CLASSIFICATION_SD STUDENT_CLASSIFICATION_LD |
ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO NO NO |
| STUDENT_FTE |
NO |
FACT TABLE |
WFT_STUDENT |
STUDENT_FTE |
STUDENT |
NO |
| STUDENT_LEVEL |
NO |
DIMENSION TABLE
FACT TABLE |
WDT_ACADEMIC_STUDY WDT_ACADEMIC_PROGRAM WDT_STUDENT_LEVEL WFT_STUDENT |
STUDENT_LEVEL STUDENT_LEVEL STUDENT_LEVEL STUDENT_LEVEL |
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE RETENTION MULTI YEAR STUDENT |
NO NO NO NO |
| STUDENT_LEVEL_DESC |
NO |
DIMENSION TABLE |
WDT_STUDENT_LEVEL WDT_ACADEMIC_PROGRAM WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY WDT_ACADEMIC_PROGRAM WDT_STUDENT_LEVEL |
STUDENT_LEVEL_SD STUDENT_LEVEL_SD STUDENT_LEVEL_SD STUDENT_LEVEL_LD STUDENT_LEVEL_LD STUDENT_LEVEL_LD |
RETENTION MULTI YEAR 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 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_ACADEMIC_PROGRAM WDT_STUDENT WDT_ACADEMIC_PROGRAM |
STUDENT_POPULATION_SD STUDENT_POPULATION_SD STUDENT_POPULATION_LD STUDENT_POPULATION_LD |
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS 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_LD RATE_SD |
STUDENT, STUDENT PROGRESS STUDENT, STUDENT PROGRESS |
NO NO |
| SUB_ACADEMIC_PERIOD |
NO |
DIMENSION TABLE
DIMENSION TABLE |
WDT_TIME WDT_TIME |
SUB_ACADEMIC_PERIOD SUB_ACADEMIC_PERIOD |
ADVANCEMENT GIFT, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER, RECRUITING AND ADMISSION ADVANCEMENT GIFT, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER, RECRUITING AND ADMISSION |
NO NO |
| SUB_ACADEMIC_PERIOD_DESC |
NO |
DIMENSION TABLE
DIMENSION TABLE |
WDT_TIME WDT_TIME WDT_TIME WDT_TIME |
SUB_ACADEMIC_PERIOD_LD SUB_ACADEMIC_PERIOD_SD SUB_ACADEMIC_PERIOD_LD SUB_ACADEMIC_PERIOD_SD |
ADVANCEMENT GIFT, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECRUITING AND ADMISSION ADVANCEMENT GIFT, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECRUITING AND ADMISSION ADVANCEMENT GIFT, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECRUITING AND ADMISSION ADVANCEMENT GIFT, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECRUITING AND ADMISSION |
NO NO 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_SD CONCENTRATION_LD |
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_MAJOR WDT_CONCENTRATION |
MAJOR CONCENTRATION_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_LD CONCENTRATION_SD |
ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO |
| THIRD_MAJOR_DESC |
NO |
DIMENSION TABLE |
WDT_CONCENTRATION WDT_MAJOR WDT_CONCENTRATION WDT_MAJOR |
CONCENTRATION_MAJOR_LD MAJOR_LD CONCENTRATION_MAJOR_SD MAJOR_SD |
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_SD PROGRAM_CLASSIFICATION_LD |
ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE |
NO NO |