RETURN TO EDW META DATA REPORTS LIST
(ODS Target Report)

SGHE Enterprise Data Warehouse EDW Source: AWARD_BY_PERSON

Source Column Local Source Target Type Target Target Column Local Target
ADMINISTRATIVE_GROUP NO

DIMENSION TABLE

WDT_MULTI_SOURCE

ADMINISTRATIVE_GROUP

NO

AID_PERIOD NO

DIMENSION TABLE

WDT_TIME

AID_PERIOD

NO

AID_PERIOD_DESC NO

DIMENSION TABLE

WDT_TIME

WDT_TIME

AID_PERIOD_SD

AID_PERIOD_LD

NO

NO

AID_YEAR NO        
AID_YEAR_DESC NO        
AWARD_ACCEPT_AMOUNT NO        
AWARD_ACCEPT_IND NO

DIMENSION TABLE

WDT_FINANCIAL_AID_STATUS

WDT_FINANCIAL_AID_STATUS

AWARD_ACCEPTED_IND

AWARD_ACCEPTED_IND

NO

NO

AWARD_AUTHORIZED_AMOUNT NO        
AWARD_CANCEL_AMOUNT NO        
AWARD_CANCEL_IND NO

DIMENSION TABLE

WDT_FINANCIAL_AID_STATUS

WDT_FINANCIAL_AID_STATUS

AWARD_CANCELED_IND

AWARD_CANCELED_IND

NO

NO

AWARD_DECLINE_AMOUNT NO        
AWARD_DECLINE_IND NO

DIMENSION TABLE

WDT_FINANCIAL_AID_STATUS

WDT_FINANCIAL_AID_STATUS

AWARD_DECLINED_IND

AWARD_DECLINED_IND

NO

NO

AWARD_OFFER_IND NO

DIMENSION TABLE

WDT_FINANCIAL_AID_STATUS

WDT_FINANCIAL_AID_STATUS

AWARD_OFFERED_IND

AWARD_OFFERED_IND

NO

NO

AWARD_PAID_AMOUNT NO        
FUNCTION NO

DIMENSION TABLE

WDT_FINANCIAL_AID_STATUS

WDT_FINANCIAL_AID_STATUS

AWARD_PAID_IND

AWARD_PAID_IND

NO

NO

MULTI_SOURCE NO

DIMENSION TABLE

WDT_MULTI_SOURCE

MULTI_SOURCE

NO

MULTI_SOURCE_DESC NO

DIMENSION TABLE

WDT_MULTI_SOURCE

WDT_MULTI_SOURCE

MULTI_SOURCE_SD

MULTI_SOURCE_LD

NO

NO

ORIGINAL_OFFER_AMOUNT NO        
PROCESS_GROUP NO

DIMENSION TABLE

WDT_MULTI_SOURCE

PROCESS_GROUP

NO

YEAR NO

DIMENSION TABLE

WDT_TIME

AID_YEAR

NO

YEAR_DESC NO

DIMENSION TABLE

WDT_TIME

WDT_TIME

AID_YEAR_SD

AID_YEAR_LD

NO

NO



Ver: 3.1