SGHE Enterprise Data Warehouse
Banner EDW Source: STUDENT - NULL
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| ACADEMIC_PERIOD |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_TIME WDT_RETENTION_TIME |
ACADEMIC_PERIOD ACADEMIC_PERIOD |
STUDENT, STUDENT PROGRESS STUDENT, STUDENT PROGRESS |
NO NO |
| ACADEMIC_PERIOD_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_TIME WDT_RETENTION_TIME WDT_RETENTION_TIME WDT_ACADEMIC_TIME |
ACADEMIC_PERIOD_LD ACADEMIC_PERIOD_SD ACADEMIC_PERIOD_LD ACADEMIC_PERIOD_SD |
STUDENT, STUDENT PROGRESS STUDENT, STUDENT PROGRESS STUDENT, STUDENT PROGRESS STUDENT, STUDENT PROGRESS |
NO NO NO NO |
| ACADEMIC_YEAR |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_TIME |
ACADEMIC_YEAR |
STUDENT, STUDENT PROGRESS |
NO |
| ACADEMIC_YEAR_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME |
ACADEMIC_YEAR_SD ACADEMIC_YEAR_LD |
STUDENT, STUDENT PROGRESS STUDENT, STUDENT PROGRESS |
NO NO |
| ACAD_STUDY_REGISTERED_IN_COUNT |
NO |
FACT TABLE |
WFT_STUDENT |
ACAD_STUDY_REGISTERED_IN_COUNT |
STUDENT |
NO |
| ADMINISTRATIVE_GROUP |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE |
ADMINISTRATIVE_GROUP |
ADMISSIONS FINAID RECORD, STUDENT, STUDENT PROGRESS |
NO |
| APPLICANT_IND |
NO |
DIMENSION TABLE |
WDT_PRE_STUDENT_STATUS |
APPLIED_IND |
STUDENT, STUDENT PROGRESS |
NO |
| COMBINED_ACAD_STANDING_DESC |
NO |
DIMENSION TABLE |
WDT_STUDENT_PERFORMANCE WDT_STUDENT_PERFORMANCE |
COMBINED_ACADEMIC_STANDING_LD COMBINED_ACADEMIC_STANDING_SD |
STUDENT, STUDENT PROGRESS STUDENT, STUDENT PROGRESS |
NO NO |
| DEANS_LIST_DESC |
NO |
DIMENSION TABLE |
WDT_STUDENT_PERFORMANCE WDT_STUDENT_PERFORMANCE |
DEANS_LIST_LD DEANS_LIST_SD |
STUDENT, STUDENT PROGRESS STUDENT, STUDENT PROGRESS |
NO NO |
| DEANS_LIST_VALUE |
NO |
DIMENSION TABLE |
WDT_STUDENT_PERFORMANCE |
DEANS_LIST |
STUDENT, STUDENT PROGRESS |
NO |
| EDUCATIONAL_GOAL |
NO |
DIMENSION TABLE |
WDT_STUDENT |
EDUCATION_GOAL |
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS |
NO |
| EDUCATIONAL_GOAL_DESC |
NO |
DIMENSION TABLE |
WDT_STUDENT WDT_STUDENT |
EDUCATION_GOAL_LD EDUCATION_GOAL_SD |
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS |
NO NO |
| EDUCATION_LEVEL |
NO |
DIMENSION TABLE |
WDT_STUDENT |
EDUCATION_LEVEL |
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS |
NO |
| EDUCATION_LEVEL_DESC |
NO |
DIMENSION TABLE |
WDT_STUDENT WDT_STUDENT |
EDUCATION_LEVEL_SD EDUCATION_LEVEL_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 |
| GRADUATE_CREDIT_ELIG_IND |
NO |
DIMENSION TABLE |
WDT_STUDENT_STATUS |
GRADUATE_CREDIT_ELIG_IND |
STUDENT, STUDENT PROGRESS |
NO |
| HOUSING_IND |
NO |
DIMENSION TABLE |
WDT_STUDENT |
HOUSING_IND |
ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION |
NO |
| MULTI_SOURCE |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE |
MULTI_SOURCE |
ADMISSIONS FINAID RECORD, STUDENT, STUDENT PROGRESS |
NO |
| MULTI_SOURCE_DESC |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE WDT_MULTI_SOURCE |
MULTI_SOURCE_SD MULTI_SOURCE_LD |
ADMISSIONS FINAID RECORD, STUDENT, STUDENT PROGRESS ADMISSIONS FINAID RECORD, STUDENT, STUDENT PROGRESS |
NO NO |
| OUTCOME_NUMBER |
NO |
FACT TABLE |
WFT_STUDENT |
ACADEMIC_OUTCOME_ROLL_KEY |
STUDENT |
NO |
| PERSON_UID |
NO |
FACT TABLE |
WFT_STUDENT |
PERSON_UID |
STUDENT |
NO |
| PROCESS_GROUP |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE |
PROCESS_GROUP |
ADMISSIONS FINAID RECORD, STUDENT, STUDENT PROGRESS |
NO |
| PROGRESS_EVALUATION |
NO |
DIMENSION TABLE |
WDT_STUDENT_PERFORMANCE |
PROGRESS_EVALUATION |
STUDENT, STUDENT PROGRESS |
NO |
| PROGRESS_EVALUATION_DESC |
NO |
DIMENSION TABLE |
WDT_STUDENT_PERFORMANCE WDT_STUDENT_PERFORMANCE |
PROGRESS_EVALUATION_SD PROGRESS_EVALUATION_LD |
STUDENT, STUDENT PROGRESS STUDENT, STUDENT PROGRESS |
NO NO |
| RESIDENCY |
NO |
DIMENSION TABLE |
WDT_STUDENT |
RESIDENCY |
ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS |
NO |
| RESIDENCY_DESC |
NO |
DIMENSION TABLE |
WDT_STUDENT WDT_STUDENT |
RESIDENCY_SD RESIDENCY_LD |
ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS |
NO NO |
| RESIDENCY_IND |
NO |
DIMENSION TABLE |
WDT_STUDENT |
RESIDENCY_IND |
ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS |
NO |
| STUDENT_LEVEL |
NO |
FACT TABLE |
WFT_RETENTION_MULTI_YEAR |
STUDENT_LEVEL |
RETENTION MULTI YEAR |
NO |
| STUDENT_STATUS |
NO |
DIMENSION TABLE |
WDT_ENROLLMENT_STATUS |
STUDENT_STATUS |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS |
NO |
| STUDENT_STATUS_DESC |
NO |
DIMENSION TABLE |
WDT_ENROLLMENT_STATUS WDT_ENROLLMENT_STATUS |
STUDENT_STATUS_LD STUDENT_STATUS_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 |
| TOTAL_BILLING |
NO |
FACT TABLE |
WFT_ENROLLMENT |
TOTAL_BILLING |
ENROLLMENT |
NO |
| TOTAL_CEU_BILLING |
NO |
FACT TABLE |
WFT_ENROLLMENT |
TOTAL_CEU_BILLING |
ENROLLMENT |
NO |
| TOTAL_CEU_CREDITS |
NO |
FACT TABLE |
WFT_ENROLLMENT |
TOTAL_CEU |
ENROLLMENT |
NO |
| TOTAL_CREDITS |
NO |
FACT TABLE |
WFT_ENROLLMENT |
TOTAL_CREDITS_GENERATED |
ENROLLMENT |
NO |
| VETERAN_TYPE |
NO |
DIMENSION TABLE
DIMENSION TABLE |
WDT_DEMOGRAPHIC WDT_DEMOGRAPHIC |
VETERAN_TYPE VETERAN_TYPE |
ACADEMIC OUTCOME, ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADE CHANGE, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RACE, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RETENTION MULTI YEAR, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT PROGRESS, TEST ACADEMIC OUTCOME, ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADE CHANGE, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RACE, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RETENTION MULTI YEAR, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT PROGRESS, TEST |
NO NO |
| VETERAN_TYPE_DESC |
NO |
DIMENSION TABLE
DIMENSION TABLE |
WDT_DEMOGRAPHIC WDT_DEMOGRAPHIC WDT_DEMOGRAPHIC WDT_DEMOGRAPHIC |
VETERAN_TYPE_LD VETERAN_TYPE_SD VETERAN_TYPE_LD VETERAN_TYPE_SD |
ACADEMIC OUTCOME, ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADE CHANGE, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RACE, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RETENTION MULTI YEAR, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT PROGRESS, TEST
ACADEMIC OUTCOME, ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADE CHANGE, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RACE, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RETENTION MULTI YEAR, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT PROGRESS, TEST
ACADEMIC OUTCOME, ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADE CHANGE, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RACE, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RETENTION MULTI YEAR, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT PROGRESS, TEST
ACADEMIC OUTCOME, ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADE CHANGE, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RACE, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RETENTION MULTI YEAR, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT PROGRESS, TEST
|
NO NO NO NO |