SGHE Enterprise Data Warehouse
Banner EDW Source: YEAR_TYPE_DEFINITION - NULL
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| ACADEMIC_PERIOD |
NO |
DIMENSION TABLE |
WDT_TIME |
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 |
NO |
| ACADEMIC_PERIOD_DESC |
NO |
DIMENSION TABLE |
WDT_TIME WDT_TIME |
ACADEMIC_PERIOD_SD ACADEMIC_PERIOD_LD |
ADVANCEMENT GIFT, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER ADVANCEMENT GIFT, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER |
NO NO |
| ACADEMIC_YEAR_DESC |
NO |
DIMENSION TABLE |
WDT_TIME WDT_TIME |
ACADEMIC_YEAR_LD ACADEMIC_YEAR_SD |
EMPLOYEE EMPLOYEE |
NO NO |
| AID_PERIOD |
NO |
DIMENSION TABLE |
WDT_TIME |
AID_PERIOD |
ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION |
NO |
| AID_PERIOD_DESC |
NO |
DIMENSION TABLE |
WDT_TIME WDT_TIME |
AID_PERIOD_SD AID_PERIOD_LD |
ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION |
NO NO |
| CALENDAR_MONTH |
NO |
DIMENSION TABLE |
WDT_TIME |
CALENDAR_MONTH |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER |
NO |
| CALENDAR_YEAR |
NO |
DIMENSION TABLE |
WDT_TIME |
CALENDAR_YEAR |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER |
NO |
| END_DATE |
NO |
DIMENSION TABLE
DIMENSION TABLE |
WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME |
ACADEMIC_PERIOD_END_DATE ACADEMIC_PERIOD_END_DATE |
ACADEMIC OUTCOME, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, COURSE INSTRUCTOR, COURSE SECTION, ENROLLMENT, FEEDBACK, FINANCIAL AID AWARD BY ACADEMIC PERIOD, GRADE CHANGE, GRADUATION COMPLETION, MEETING TIME, RACE, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RETENTION MULTI YEAR, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT COURSE ATTRIBUTE, STUDENT PROGRESS ACADEMIC OUTCOME, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, COURSE INSTRUCTOR, COURSE SECTION, ENROLLMENT, FEEDBACK, FINANCIAL AID AWARD BY ACADEMIC PERIOD, GRADE CHANGE, GRADUATION COMPLETION, MEETING TIME, RACE, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RETENTION MULTI YEAR, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT COURSE ATTRIBUTE, STUDENT PROGRESS |
NO NO |
| FUNCTION |
NO |
DIMENSION TABLE |
WDT_TIME WDT_TIME |
FISCAL_PERIOD FISCAL_YEAR |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, EMPLOYEE, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION |
NO NO |
| START_DATE |
NO |
DIMENSION TABLE
DIMENSION TABLE |
WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME |
ACADEMIC_PERIOD_BEGIN_DATE ACADEMIC_PERIOD_BEGIN_DATE |
ACADEMIC OUTCOME, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, COURSE INSTRUCTOR, COURSE SECTION, ENROLLMENT, FEEDBACK, FINANCIAL AID AWARD BY ACADEMIC PERIOD, GRADE CHANGE, GRADUATION COMPLETION, MEETING TIME, RACE, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RETENTION MULTI YEAR, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT COURSE ATTRIBUTE, STUDENT PROGRESS ACADEMIC OUTCOME, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, COURSE INSTRUCTOR, COURSE SECTION, ENROLLMENT, FEEDBACK, FINANCIAL AID AWARD BY ACADEMIC PERIOD, GRADE CHANGE, GRADUATION COMPLETION, MEETING TIME, RACE, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RETENTION MULTI YEAR, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT COURSE ATTRIBUTE, STUDENT PROGRESS |
NO NO |
| YEAR_CODE |
NO |
DIMENSION TABLE
DIMENSION TABLE
DIMENSION TABLE |
WDT_TIME WDT_TIME WDT_ACADEMIC_TIME WDT_TIME WDT_TIME WDT_ACADEMIC_TIME WDT_TIME WDT_TIME WDT_ACADEMIC_TIME |
AID_YEAR ACADEMIC_YEAR ACADEMIC_YEAR AID_YEAR ACADEMIC_YEAR ACADEMIC_YEAR AID_YEAR ACADEMIC_YEAR ACADEMIC_YEAR |
ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, 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 ACADEMIC OUTCOME, ENROLLMENT, FINANCIAL AID AWARD BY ACADEMIC PERIOD, GRADUATION COMPLETION ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, 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 ACADEMIC OUTCOME, ENROLLMENT, FINANCIAL AID AWARD BY ACADEMIC PERIOD, GRADUATION COMPLETION ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, 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 ACADEMIC OUTCOME, ENROLLMENT, FINANCIAL AID AWARD BY ACADEMIC PERIOD, GRADUATION COMPLETION |
NO NO NO NO NO NO NO NO NO |
| YEAR_CODE_DESC |
NO |
DIMENSION TABLE
DIMENSION TABLE
DIMENSION TABLE |
WDT_TIME WDT_TIME WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME WDT_TIME WDT_TIME WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME WDT_TIME WDT_TIME WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME |
AID_YEAR_SD AID_YEAR_LD ACADEMIC_YEAR_LD ACADEMIC_YEAR_SD AID_YEAR_SD AID_YEAR_LD ACADEMIC_YEAR_LD ACADEMIC_YEAR_SD AID_YEAR_SD AID_YEAR_LD ACADEMIC_YEAR_LD ACADEMIC_YEAR_SD |
ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION ACADEMIC OUTCOME, ENROLLMENT, FINANCIAL AID AWARD BY ACADEMIC PERIOD, GRADUATION COMPLETION ACADEMIC OUTCOME, ENROLLMENT, FINANCIAL AID AWARD BY ACADEMIC PERIOD, GRADUATION COMPLETION ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION ACADEMIC OUTCOME, ENROLLMENT, FINANCIAL AID AWARD BY ACADEMIC PERIOD, GRADUATION COMPLETION ACADEMIC OUTCOME, ENROLLMENT, FINANCIAL AID AWARD BY ACADEMIC PERIOD, GRADUATION COMPLETION ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION ACADEMIC OUTCOME, ENROLLMENT, FINANCIAL AID AWARD BY ACADEMIC PERIOD, GRADUATION COMPLETION ACADEMIC OUTCOME, ENROLLMENT, FINANCIAL AID AWARD BY ACADEMIC PERIOD, GRADUATION COMPLETION |
NO NO NO NO NO NO NO NO NO NO NO NO |
| YEAR_DESC |
NO |
DIMENSION TABLE |
WDT_TIME WDT_TIME |
ACADEMIC_YEAR_LD ACADEMIC_YEAR_SD |
ADVANCEMENT GIFT, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER ADVANCEMENT GIFT, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER |
NO NO |