SGHE Enterprise Data Warehouse
Banner EDW Source: FINAID_FUND - NULL
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| FINANCIAL_AID_TYPE |
NO |
DIMENSION TABLE |
WDT_FINANCIAL_AID_FUND |
FINANCIAL_AID_TYPE |
FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT |
NO |
| FINANCIAL_AID_TYPE_DESC |
NO |
DIMENSION TABLE |
WDT_FINANCIAL_AID_FUND WDT_FINANCIAL_AID_FUND |
FINANCIAL_AID_TYPE_LD FINANCIAL_AID_TYPE_SD |
FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT |
NO NO |
| FUND |
NO |
DIMENSION TABLE |
WDT_FINANCIAL_AID_FUND |
FUND |
FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT |
NO |
| FUND_SOURCE |
NO |
DIMENSION TABLE |
WDT_FINANCIAL_AID_FUND |
FUND_SOURCE |
FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT |
NO |
| FUND_SOURCE_DESC |
NO |
DIMENSION TABLE |
WDT_FINANCIAL_AID_FUND WDT_FINANCIAL_AID_FUND |
FUND_SOURCE_LD FUND_SOURCE_SD |
FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT |
NO NO |
| FUND_SOURCE_TYPE |
NO |
DIMENSION TABLE |
WDT_FINANCIAL_AID_FUND |
FINANCIAL_AID_SOURCE_TYPE |
FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT |
NO |
| FUND_SOURCE_TYPE_DESC |
NO |
DIMENSION TABLE |
WDT_FINANCIAL_AID_FUND WDT_FINANCIAL_AID_FUND |
FINANCIAL_AID_SOURCE_TYPE_LD FINANCIAL_AID_SOURCE_TYPE_SD |
FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT |
NO NO |
| FUND_TITLE |
NO |
DIMENSION TABLE |
WDT_FINANCIAL_AID_FUND WDT_FINANCIAL_AID_FUND |
FUND_LD FUND_SD |
FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT |
NO NO |
| FUND_TYPE |
NO |
DIMENSION TABLE |
WDT_FINANCIAL_AID_FUND |
FUND_TYPE |
FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT |
NO |
| FUND_TYPE_DESC |
NO |
DIMENSION TABLE |
WDT_FINANCIAL_AID_FUND WDT_FINANCIAL_AID_FUND |
FUND_TYPE_SD FUND_TYPE_LD |
FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT |
NO NO |
| GIFT_OR_SELF_HELP_AID |
NO |
DIMENSION TABLE |
WDT_FINANCIAL_AID_FUND |
GIFT_OR_SELF_HELP_AID |
FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT |
NO |
| GIFT_OR_SELF_HELP_AID_DESC |
NO |
DIMENSION TABLE |
WDT_FINANCIAL_AID_FUND WDT_FINANCIAL_AID_FUND |
GIFT_OR_SELF_HELP_AID_LD GIFT_OR_SELF_HELP_AID_SD |
FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT |
NO NO |
| NEED_ANALYSIS_IND |
NO |
DIMENSION TABLE |
WDT_FINANCIAL_AID_FUND |
NEED_ANALYSIS_IND |
FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT |
NO |
| NEED_BASED_IND |
NO |
DIMENSION TABLE |
WDT_FINANCIAL_AID_FUND |
REDUCE_NEED_IND |
FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT |
NO |
| OVERRIDE_NEED_TO_COA_IND |
NO |
DIMENSION TABLE |
WDT_FINANCIAL_AID_FUND |
OVERRIDE_NEED_TO_COA_IND |
FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT |
NO |
| OVERRIDE_UNMET_NEED_IND |
NO |
DIMENSION TABLE |
WDT_FINANCIAL_AID_FUND |
OVERRIDE_UNMET_NEED_IND |
FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT |
NO |
| REPLACE_TFC_IND |
NO |
DIMENSION TABLE |
WDT_FINANCIAL_AID_FUND |
REPLACE_EFC_IND |
FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT |
NO |