SGHE Enterprise Data Warehouse
Banner EDW Source: FINAID_APPLICANT_STATUS - NULL
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| ADMINISTRATIVE_GROUP |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE |
ADMINISTRATIVE_GROUP |
FINANCIAL AID APPLICATION |
NO |
| AID_YEAR |
NO |
DIMENSION TABLE
DIMENSION TABLE |
WDT_FINANCIAL_AID_YEAR WDT_FINANCIAL_AID_YEAR |
FINANCIAL_AID_YEAR FINANCIAL_AID_YEAR |
BANNER COMMUNICATION, FINANCIAL AID APPLICATION, STUDENT, STUDENT PROGRESS BANNER COMMUNICATION, FINANCIAL AID APPLICATION, STUDENT, STUDENT PROGRESS |
NO NO |
| AID_YEAR_DESC |
NO |
DIMENSION TABLE
DIMENSION TABLE |
WDT_FINANCIAL_AID_YEAR WDT_FINANCIAL_AID_YEAR WDT_FINANCIAL_AID_YEAR WDT_FINANCIAL_AID_YEAR |
FINANCIAL_AID_YEAR_SD FINANCIAL_AID_YEAR_LD FINANCIAL_AID_YEAR_SD FINANCIAL_AID_YEAR_LD |
BANNER COMMUNICATION, FINANCIAL AID APPLICATION, STUDENT, STUDENT PROGRESS BANNER COMMUNICATION, FINANCIAL AID APPLICATION, STUDENT, STUDENT PROGRESS BANNER COMMUNICATION, FINANCIAL AID APPLICATION, STUDENT, STUDENT PROGRESS BANNER COMMUNICATION, FINANCIAL AID APPLICATION, STUDENT, STUDENT PROGRESS |
NO NO NO NO |
| BUDGET_GROUP |
NO |
DIMENSION TABLE |
WDT_FINANCIAL_AID_BUDGET_GRP |
FINANCIAL_AID_BUDGET_GRP |
FINANCIAL AID APPLICATION |
NO |
| BUDGET_GROUP_DESC |
NO |
DIMENSION TABLE |
WDT_FINANCIAL_AID_BUDGET_GRP WDT_FINANCIAL_AID_BUDGET_GRP |
FINANCIAL_AID_BUDGET_GRP_LD FINANCIAL_AID_BUDGET_GRP_SD |
FINANCIAL AID APPLICATION FINANCIAL AID APPLICATION |
NO NO |
| MULTI_SOURCE |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE |
MULTI_SOURCE |
FINANCIAL AID APPLICATION |
NO |
| MULTI_SOURCE_DESC |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE WDT_MULTI_SOURCE |
MULTI_SOURCE_LD MULTI_SOURCE_SD |
FINANCIAL AID APPLICATION FINANCIAL AID APPLICATION |
NO NO |
| PACKAGE_COMPLETE_DATE |
NO |
DIMENSION TABLE
FACT TABLE |
WDT_CALENDAR_DATE WFT_FINAID_APPLICATION |
CALENDAR_DATE PACKAGING_COMPLETE_DATE |
FINANCIAL AID APPLICATION FINANCIAL AID APPLICATION |
NO NO |
| PACKAGING_GROUP |
NO |
DIMENSION TABLE |
WDT_FINANCIAL_AID_PACKAGE_GRP |
FINANCIAL_AID_PACKAGE_GRP |
FINANCIAL AID APPLICATION |
NO |
| PACKAGING_GROUP_DESC |
NO |
DIMENSION TABLE |
WDT_FINANCIAL_AID_PACKAGE_GRP WDT_FINANCIAL_AID_PACKAGE_GRP |
FINANCIAL_AID_PACKAGE_GRP_SD FINANCIAL_AID_PACKAGE_GRP_LD |
FINANCIAL AID APPLICATION FINANCIAL AID APPLICATION |
NO NO |
| PROCESS_GROUP |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE |
PROCESS_GROUP |
FINANCIAL AID APPLICATION |
NO |