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
DIMENSION TABLE |
WDT_TIME WDT_TIME |
ACADEMIC_PERIOD 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 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_PERIOD_DESC |
NO |
DIMENSION TABLE
DIMENSION TABLE |
WDT_TIME WDT_TIME WDT_TIME WDT_TIME |
ACADEMIC_PERIOD_SD ACADEMIC_PERIOD_LD 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 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 NO NO |
| ACADEMIC_YEAR_DESC |
NO |
DIMENSION TABLE
DIMENSION TABLE |
WDT_TIME WDT_TIME WDT_TIME WDT_TIME |
ACADEMIC_YEAR_LD ACADEMIC_YEAR_SD ACADEMIC_YEAR_LD ACADEMIC_YEAR_SD |
EMPLOYEE EMPLOYEE EMPLOYEE EMPLOYEE |
NO NO NO NO |
| AID_PERIOD |
NO |
DIMENSION TABLE
DIMENSION TABLE |
WDT_TIME WDT_TIME |
AID_PERIOD 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 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 |
| AID_PERIOD_DESC |
NO |
DIMENSION TABLE
DIMENSION TABLE |
WDT_TIME WDT_TIME WDT_TIME WDT_TIME |
AID_PERIOD_LD AID_PERIOD_SD AID_PERIOD_LD AID_PERIOD_SD |
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 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 NO NO |
| CALENDAR_MONTH |
NO |
DIMENSION TABLE
DIMENSION TABLE |
WDT_TIME WDT_TIME |
CALENDAR_MONTH CALENDAR_MONTH |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER |
NO NO |
| CALENDAR_YEAR |
NO |
DIMENSION TABLE
DIMENSION TABLE |
WDT_TIME WDT_TIME |
CALENDAR_YEAR CALENDAR_YEAR |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER |
NO 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, FEEDBACK, FINANCIAL AID AWARD BY ACADEMIC PERIOD, GRADE CHANGE, 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, FEEDBACK, FINANCIAL AID AWARD BY ACADEMIC PERIOD, GRADE CHANGE, 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
DIMENSION TABLE |
WDT_TIME WDT_TIME WDT_TIME WDT_TIME |
FISCAL_YEAR FISCAL_PERIOD FISCAL_YEAR FISCAL_PERIOD |
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 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 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 |
NO NO 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, FEEDBACK, FINANCIAL AID AWARD BY ACADEMIC PERIOD, GRADE CHANGE, 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, FEEDBACK, FINANCIAL AID AWARD BY ACADEMIC PERIOD, GRADE CHANGE, 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_TIME WDT_ACADEMIC_TIME WDT_TIME WDT_TIME WDT_TIME WDT_ACADEMIC_TIME WDT_TIME |
ACADEMIC_YEAR AID_YEAR ACADEMIC_YEAR SUB_ACADEMIC_PERIOD ACADEMIC_YEAR AID_YEAR ACADEMIC_YEAR SUB_ACADEMIC_PERIOD ACADEMIC_YEAR AID_YEAR ACADEMIC_YEAR SUB_ACADEMIC_PERIOD |
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 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, FINANCIAL AID AWARD BY ACADEMIC PERIOD GRADUATION COMPLETION 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 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, FINANCIAL AID AWARD BY ACADEMIC PERIOD GRADUATION COMPLETION 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 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, FINANCIAL AID AWARD BY ACADEMIC PERIOD GRADUATION COMPLETION |
NO NO NO 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_SD ACADEMIC_YEAR_LD AID_YEAR_SD AID_YEAR_LD ACADEMIC_YEAR_SD ACADEMIC_YEAR_LD AID_YEAR_SD AID_YEAR_LD ACADEMIC_YEAR_SD ACADEMIC_YEAR_LD |
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, FINANCIAL AID AWARD BY ACADEMIC PERIOD ACADEMIC OUTCOME, FINANCIAL AID AWARD BY ACADEMIC PERIOD 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, FINANCIAL AID AWARD BY ACADEMIC PERIOD ACADEMIC OUTCOME, FINANCIAL AID AWARD BY ACADEMIC PERIOD 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, FINANCIAL AID AWARD BY ACADEMIC PERIOD ACADEMIC OUTCOME, FINANCIAL AID AWARD BY ACADEMIC PERIOD |
NO NO NO NO NO NO NO NO NO NO NO NO |
| YEAR_DESC |
NO |
DIMENSION TABLE
DIMENSION TABLE |
WDT_TIME WDT_TIME WDT_TIME WDT_TIME |
ACADEMIC_YEAR_LD ACADEMIC_YEAR_SD 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
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 NO NO |