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

SGHE Enterprise Data Warehouse EDW Source: RECEIVABLE_ACCOUNT_DETAIL

Source Column Local Source Target Type Target Target Column Local Target
ACADEMIC_PERIOD NO

DIMENSION TABLE

WDT_TIME

ACADEMIC_PERIOD

NO

ACADEMIC_PERIOD_DESC NO

DIMENSION TABLE

WDT_TIME

WDT_TIME

ACADEMIC_PERIOD_SD

ACADEMIC_PERIOD_LD

NO

NO

ACADEMIC_YEAR NO

DIMENSION TABLE

WDT_TIME

ACADEMIC_YEAR

NO

ACADEMIC_YEAR_DESC NO

DIMENSION TABLE

WDT_TIME

WDT_TIME

ACADEMIC_YEAR_SD

ACADEMIC_YEAR_LD

NO

NO

ADMINISTRATIVE_GROUP NO

DIMENSION TABLE

WDT_MULTI_SOURCE

ADMINISTRATIVE_GROUP

NO

AMOUNT NO        
BALANCE NO        
BILL_DATE_AGING NO

DIMENSION TABLE

WDT_ACCOUNTS_RECEIVABLE

BILL_DATE_AGING

NO

BILL_DATE_AGING_DESC NO

DIMENSION TABLE

WDT_ACCOUNTS_RECEIVABLE

WDT_ACCOUNTS_RECEIVABLE

BILL_DATE_AGING_LD

BILL_DATE_AGING_SD

NO

NO

CATEGORY NO

DIMENSION TABLE

WDT_ACCOUNTS_RECEIVABLE

CATEGORY

NO

CATEGORY_DESC NO

DIMENSION TABLE

WDT_ACCOUNTS_RECEIVABLE

WDT_ACCOUNTS_RECEIVABLE

CATEGORY_LD

CATEGORY_SD

NO

NO

DETAIL_CODE NO

DIMENSION TABLE

WDT_ACCOUNTS_RECEIVABLE

DETAIL_CODE

NO

DETAIL_CODE_DESC NO

DIMENSION TABLE

WDT_ACCOUNTS_RECEIVABLE

WDT_ACCOUNTS_RECEIVABLE

DETAIL_CODE_LD

DETAIL_CODE_SD

NO

NO

EFFECTIVE_DATE_AGING NO

DIMENSION TABLE

WDT_ACCOUNTS_RECEIVABLE

EFFECTIVE_DATE_AGING

NO

EFFECTIVE_DATE_AGING_DESC NO

DIMENSION TABLE

WDT_ACCOUNTS_RECEIVABLE

WDT_ACCOUNTS_RECEIVABLE

EFFECTIVE_DATE_AGING_SD

EFFECTIVE_DATE_AGING_LD

NO

NO

FUNCTION 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_LD

MULTI_SOURCE_SD

NO

NO

PROCESS_GROUP NO

DIMENSION TABLE

WDT_MULTI_SOURCE

PROCESS_GROUP

NO

SUB_ACADEMIC_PERIOD NO

DIMENSION TABLE

WDT_TIME

SUB_ACADEMIC_PERIOD

NO

SUB_ACADEMIC_PERIOD_DESC NO

DIMENSION TABLE

WDT_TIME

WDT_TIME

SUB_ACADEMIC_PERIOD_LD

SUB_ACADEMIC_PERIOD_SD

NO

NO

TRANSACTION_DATE NO

DIMENSION TABLE

WDT_TIME

WDT_TIME

CALENDAR_MONTH

CALENDAR_YEAR

NO

NO



Ver: 3.1