SGHE Enterprise Data Warehouse
Banner EDW Source: YEAR_TYPE_DEFINITION
| 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_LD ACADEMIC_PERIOD_SD |
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 |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_TIME WDT_TIME |
ACADEMIC_YEAR ACADEMIC_YEAR |
FINANCIAL AID AWARD BY ACADEMIC PERIOD FINANCIAL AID STUDENT |
NO NO |
| ACADEMIC_YEAR_DESC |
NO |
DIMENSION TABLE |
WDT_TIME WDT_TIME WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME |
ACADEMIC_YEAR_LD ACADEMIC_YEAR_SD ACADEMIC_YEAR_LD ACADEMIC_YEAR_SD |
EMPLOYEE EMPLOYEE FINANCIAL AID AWARD BY ACADEMIC PERIOD FINANCIAL AID AWARD BY ACADEMIC PERIOD |
NO NO 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_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 |
NO NO |
| AID_YEAR |
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 |
WDT_ACADEMIC_TIME |
ACADEMIC_PERIOD_END_DATE |
ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, FINANCIAL AID AWARD BY ACADEMIC PERIOD, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT |
NO |
| FISCAL_QUARTER |
NO |
|
|
|
|
|
| FISCAL_YEAR |
NO |
|
|
|
|
|
| FUNCTION |
NO |
DIMENSION TABLE |
WDT_TIME WDT_TIME WDT_TIME |
FISCAL_QUARTER FISCAL_PERIOD FISCAL_YEAR |
ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE DEGREE, 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 |
NO NO NO |
| START_DATE |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_TIME |
ACADEMIC_PERIOD_BEGIN_DATE |
ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, FINANCIAL AID AWARD BY ACADEMIC PERIOD, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT |
NO |
| SUB_ACADEMIC_PERIOD |
NO |
DIMENSION TABLE |
WDT_TIME |
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 |
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, 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, GRANT AND PROJECT, OPERATING LEDGER, RECRUITING AND ADMISSION |
NO NO |
| YEAR |
NO |
DIMENSION TABLE |
WDT_TIME WDT_TIME |
ACADEMIC_YEAR AID_YEAR |
ADVANCEMENT GIFT, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, FINANCIAL AID PRE STUDENT, GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER 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 |
| YEAR_DESC |
NO |
DIMENSION TABLE |
WDT_TIME WDT_TIME WDT_TIME WDT_TIME |
ACADEMIC_YEAR_LD ACADEMIC_YEAR_SD AID_YEAR_LD AID_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
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 |