SGHE Enterprise Data Warehouse
Banner EDW Source: AWARD_BY_PERSON - NULL
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| ACADEMIC_PERIOD |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_TIME |
ACADEMIC_PERIOD |
FINANCIAL AID AWARD BY ACADEMIC PERIOD |
NO |
| ACADEMIC_PERIOD_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME |
ACADEMIC_PERIOD_SD ACADEMIC_PERIOD_LD |
FINANCIAL AID AWARD BY ACADEMIC PERIOD FINANCIAL AID AWARD BY ACADEMIC PERIOD |
NO NO |
| ADMINISTRATIVE_GROUP |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE |
ADMINISTRATIVE_GROUP |
FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT |
NO |
| AID_PERIOD |
NO |
DIMENSION TABLE |
WDT_TIME |
AID_PERIOD |
FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT |
NO |
| AID_PERIOD_DESC |
NO |
DIMENSION TABLE |
WDT_TIME WDT_TIME |
AID_PERIOD_LD AID_PERIOD_SD |
FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT |
NO NO |
| AID_YEAR |
NO |
DIMENSION TABLE |
WDT_FINANCIAL_AID_YEAR |
FINANCIAL_AID_YEAR |
ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, FINANCIAL AID AWARD BY ACADEMIC PERIOD |
NO |
| AID_YEAR_DESC |
NO |
DIMENSION TABLE |
WDT_FINANCIAL_AID_YEAR WDT_FINANCIAL_AID_YEAR |
FINANCIAL_AID_YEAR_LD FINANCIAL_AID_YEAR_SD |
ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, FINANCIAL AID AWARD BY ACADEMIC PERIOD ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, FINANCIAL AID AWARD BY ACADEMIC PERIOD |
NO NO |
| AWARD_ACCEPT_AMOUNT |
NO |
FACT TABLE |
WFT_FINANCIAL_AID_STUDENT WFT_FINAID_AWARD_ACAD_PERIOD WFT_FINANCIAL_AID_PRE_STUDENT |
AWARD_ACCEPTED_AMOUNT AWARD_ACCEPTED_AMOUNT AWARD_ACCEPTED_AMOUNT |
FINANCIAL AID STUDENT FINANCIAL AID AWARD BY ACADEMIC PERIOD FINANCIAL AID PRE STUDENT |
NO NO NO |
| AWARD_ACCEPT_DATE |
NO |
FACT TABLE |
WFT_FINAID_AWARD_ACAD_PERIOD |
AWARD_ACCEPTED_DATE |
FINANCIAL AID AWARD BY ACADEMIC PERIOD |
NO |
| AWARD_ACCEPT_IND |
NO |
DIMENSION TABLE |
WDT_FINANCIAL_AID_STATUS |
AWARD_ACCEPTED_IND |
ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION |
NO |
| AWARD_AUTHORIZE_AMOUNT |
NO |
FACT TABLE |
WFT_FINAID_AWARD_ACAD_PERIOD WFT_FINANCIAL_AID_STUDENT WFT_FINANCIAL_AID_PRE_STUDENT |
AWARD_AUTHORIZED_AMOUNT AWARD_AUTHORIZED_AMOUNT AWARD_AUTHORIZED_AMOUNT |
FINANCIAL AID AWARD BY ACADEMIC PERIOD FINANCIAL AID STUDENT FINANCIAL AID PRE STUDENT |
NO NO NO |
| AWARD_AUTHORIZE_DATE |
NO |
FACT TABLE |
WFT_FINAID_AWARD_ACAD_PERIOD |
AWARD_AUTHORIZED_DATE |
FINANCIAL AID AWARD BY ACADEMIC PERIOD |
NO |
| AWARD_CANCEL_AMOUNT |
NO |
FACT TABLE |
WFT_FINAID_AWARD_ACAD_PERIOD WFT_FINANCIAL_AID_STUDENT WFT_FINANCIAL_AID_PRE_STUDENT |
AWARD_CANCELED_AMOUNT AWARD_CANCELED_AMOUNT AWARD_CANCELED_AMOUNT |
FINANCIAL AID AWARD BY ACADEMIC PERIOD FINANCIAL AID STUDENT FINANCIAL AID PRE STUDENT |
NO NO NO |
| AWARD_CANCEL_DATE |
NO |
FACT TABLE |
WFT_FINAID_AWARD_ACAD_PERIOD |
AWARD_CANCELED_DATE |
FINANCIAL AID AWARD BY ACADEMIC PERIOD |
NO |
| AWARD_CANCEL_IND |
NO |
DIMENSION TABLE |
WDT_FINANCIAL_AID_STATUS |
AWARD_CANCELED_IND |
ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION |
NO |
| AWARD_DECLINE_AMOUNT |
NO |
FACT TABLE |
WFT_FINANCIAL_AID_STUDENT WFT_FINANCIAL_AID_PRE_STUDENT WFT_FINAID_AWARD_ACAD_PERIOD |
AWARD_DECLINED_AMOUNT AWARD_DECLINED_AMOUNT AWARD_DECLINED_AMOUNT |
FINANCIAL AID STUDENT FINANCIAL AID PRE STUDENT FINANCIAL AID AWARD BY ACADEMIC PERIOD |
NO NO NO |
| AWARD_DECLINE_DATE |
NO |
FACT TABLE |
WFT_FINAID_AWARD_ACAD_PERIOD |
AWARD_DECLINED_DATE |
FINANCIAL AID AWARD BY ACADEMIC PERIOD |
NO |
| AWARD_DECLINE_IND |
NO |
DIMENSION TABLE |
WDT_FINANCIAL_AID_STATUS |
AWARD_DECLINED_IND |
ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION |
NO |
| AWARD_MEMO_AMOUNT |
NO |
FACT TABLE |
WFT_FINAID_AWARD_ACAD_PERIOD |
AWARD_MEMO_AMOUNT |
FINANCIAL AID AWARD BY ACADEMIC PERIOD |
NO |
| AWARD_MEMO_EXPIRATION_DATE |
NO |
FACT TABLE |
WFT_FINAID_AWARD_ACAD_PERIOD |
AWARD_MEMO_EXPIRATION_DATE |
FINANCIAL AID AWARD BY ACADEMIC PERIOD |
NO |
| AWARD_OFFER_AMOUNT |
NO |
FACT TABLE |
WFT_FINANCIAL_AID_STUDENT WFT_FINAID_AWARD_ACAD_PERIOD WFT_FINANCIAL_AID_PRE_STUDENT |
AWARD_OFFERED_AMOUNT AWARD_OFFERED_AMOUNT AWARD_OFFERED_AMOUNT |
FINANCIAL AID STUDENT FINANCIAL AID AWARD BY ACADEMIC PERIOD FINANCIAL AID PRE STUDENT |
NO NO NO |
| AWARD_OFFER_DATE |
NO |
FACT TABLE |
WFT_FINAID_AWARD_ACAD_PERIOD |
AWARD_OFFERED_DATE |
FINANCIAL AID AWARD BY ACADEMIC PERIOD |
NO |
| AWARD_OFFER_IND |
NO |
DIMENSION TABLE |
WDT_FINANCIAL_AID_STATUS |
AWARD_OFFERED_IND |
ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION |
NO |
| AWARD_ORIGINAL_OFFER_AMOUNT |
NO |
FACT TABLE |
WFT_FINAID_AWARD_ACAD_PERIOD |
AWARD_ORIGINAL_OFFERED_AMOUNT |
FINANCIAL AID AWARD BY ACADEMIC PERIOD |
NO |
| AWARD_ORIGINAL_OFFER_DATE |
NO |
FACT TABLE |
WFT_FINAID_AWARD_ACAD_PERIOD |
AWARD_ORIGINAL_OFFERED_DATE |
FINANCIAL AID AWARD BY ACADEMIC PERIOD |
NO |
| AWARD_PAID_AMOUNT |
NO |
FACT TABLE |
WFT_ENROLLMENT WFT_FINAID_AWARD_ACAD_PERIOD WFT_FINANCIAL_AID_PRE_STUDENT WFT_FINANCIAL_AID_STUDENT |
FINANCIAL_AID_AMOUNT AWARD_PAID_AMOUNT AWARD_PAID_AMOUNT AWARD_PAID_AMOUNT |
ENROLLMENT FINANCIAL AID AWARD BY ACADEMIC PERIOD FINANCIAL AID PRE STUDENT FINANCIAL AID STUDENT |
NO NO NO NO |
| AWARD_PAID_DATE |
NO |
FACT TABLE |
WFT_FINAID_AWARD_ACAD_PERIOD |
AWARD_PAID_DATE |
FINANCIAL AID AWARD BY ACADEMIC PERIOD |
NO |
| FUNCTION |
NO |
DIMENSION TABLE |
WDT_FINANCIAL_AID_STATUS |
AWARD_PAID_IND |
ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION |
NO |
| FUND |
NO |
DIMENSION TABLE |
WDT_FINANCIAL_AID_FUND |
FUND |
FINANCIAL AID AWARD BY ACADEMIC PERIOD |
NO |
| FUND_SOURCE |
NO |
DIMENSION TABLE |
WDT_FINANCIAL_AID_FUND |
FUND_SOURCE |
FINANCIAL AID AWARD BY ACADEMIC PERIOD |
NO |
| FUND_SOURCE_DESC |
NO |
DIMENSION TABLE |
WDT_FINANCIAL_AID_FUND WDT_FINANCIAL_AID_FUND |
FUND_SOURCE_SD FUND_SOURCE_LD |
FINANCIAL AID AWARD BY ACADEMIC PERIOD FINANCIAL AID AWARD BY ACADEMIC PERIOD |
NO NO |
| FUND_TITLE |
NO |
DIMENSION TABLE |
WDT_FINANCIAL_AID_FUND WDT_FINANCIAL_AID_FUND |
FUND_LD FUND_SD |
FINANCIAL AID AWARD BY ACADEMIC PERIOD FINANCIAL AID AWARD BY ACADEMIC PERIOD |
NO NO |
| FUND_TYPE |
NO |
DIMENSION TABLE |
WDT_FINANCIAL_AID_FUND |
FUND_TYPE |
FINANCIAL AID AWARD BY ACADEMIC PERIOD |
NO |
| FUND_TYPE_DESC |
NO |
DIMENSION TABLE |
WDT_FINANCIAL_AID_FUND WDT_FINANCIAL_AID_FUND |
FUND_TYPE_LD FUND_TYPE_SD |
FINANCIAL AID AWARD BY ACADEMIC PERIOD FINANCIAL AID AWARD BY ACADEMIC PERIOD |
NO NO |
| MULTI_SOURCE |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE |
MULTI_SOURCE |
FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT |
NO |
| MULTI_SOURCE_DESC |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE WDT_MULTI_SOURCE |
MULTI_SOURCE_LD MULTI_SOURCE_SD |
FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT |
NO NO |
| PERSON_UID |
NO |
FACT TABLE |
WFT_FINAID_AWARD_ACAD_PERIOD |
PERSON_UID |
FINANCIAL AID AWARD BY ACADEMIC PERIOD |
NO |
| PROCESS_GROUP |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE |
PROCESS_GROUP |
FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT |
NO |