Banner EDW Source: ACCOUNT_HIERARCHY

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

**SGHE Enterprise Data Warehouse**
Source Column	Local Source	Target Type	Target	Target Column	Star Name	Local Target
ACCOUNT_DESC	NO	DIMENSION TABLE	WDT_ACCOUNT	ACCOUNT_SD	RECEIVABLE REVENUE	NO
ACCOUNT_DESC_1	NO	DIMENSION TABLE	WDT_ACCOUNT WDT_ACCOUNT	ACCOUNT_LEVEL_1_LD ACCOUNT_LEVEL_1_SD	RECEIVABLE REVENUE RECEIVABLE REVENUE	NO NO
ACCOUNT_DESC_2	NO	DIMENSION TABLE	WDT_ACCOUNT WDT_ACCOUNT	ACCOUNT_LEVEL_2_SD ACCOUNT_LEVEL_2_LD	RECEIVABLE REVENUE RECEIVABLE REVENUE	NO NO
ACCOUNT_DESC_3	NO	DIMENSION TABLE	WDT_ACCOUNT WDT_ACCOUNT	ACCOUNT_LEVEL_3_LD ACCOUNT_LEVEL_3_SD	RECEIVABLE REVENUE RECEIVABLE REVENUE	NO NO
ACCOUNT_DESC_4	NO	DIMENSION TABLE	WDT_ACCOUNT WDT_ACCOUNT	ACCOUNT_LEVEL_4_SD ACCOUNT_LEVEL_4_LD	RECEIVABLE REVENUE RECEIVABLE REVENUE	NO NO
ACCOUNT_LEVEL_1	NO	DIMENSION TABLE	WDT_ACCOUNT	ACCOUNT_LEVEL_1	RECEIVABLE REVENUE	NO
ACCOUNT_LEVEL_2	NO	DIMENSION TABLE	WDT_ACCOUNT	ACCOUNT_LEVEL_2	RECEIVABLE REVENUE	NO
ACCOUNT_LEVEL_3	NO	DIMENSION TABLE	WDT_ACCOUNT	ACCOUNT_LEVEL_3	RECEIVABLE REVENUE	NO
ACCOUNT_LEVEL_4	NO	DIMENSION TABLE	WDT_ACCOUNT	ACCOUNT_LEVEL_4	RECEIVABLE REVENUE	NO
ACCOUNT_POOL	NO	DIMENSION TABLE	WDT_ACCOUNT	ACCOUNT_POOL	RECEIVABLE REVENUE	NO
ACCOUNT_POOL_DESC	NO	DIMENSION TABLE	WDT_ACCOUNT WDT_ACCOUNT	ACCOUNT_POOL_LD ACCOUNT_POOL_SD	RECEIVABLE REVENUE RECEIVABLE REVENUE	NO NO
ACCOUNT_TYPE	NO	DIMENSION TABLE	WDT_ACCOUNT	ACCOUNT_TYPE	GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE	NO
ACCOUNT_TYPE_DESC	NO	DIMENSION TABLE	WDT_ACCOUNT WDT_ACCOUNT	ACCOUNT_TYPE_LD ACCOUNT_TYPE_SD	GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE	NO NO
ACCOUNT_TYPE_DESC_1	NO	DIMENSION TABLE	WDT_ACCOUNT WDT_ACCOUNT	ACCOUNT_TYPE_LEVEL_1_LD ACCOUNT_TYPE_LEVEL_1_SD	RECEIVABLE REVENUE RECEIVABLE REVENUE	NO NO
ACCOUNT_TYPE_DESC_2	NO	DIMENSION TABLE	WDT_ACCOUNT WDT_ACCOUNT	ACCOUNT_TYPE_LEVEL_2_LD ACCOUNT_TYPE_LEVEL_2_SD	RECEIVABLE REVENUE RECEIVABLE REVENUE	NO NO
ACCOUNT_TYPE_LEVEL_1	NO	DIMENSION TABLE	WDT_ACCOUNT	ACCOUNT_TYPE_LEVEL_1	RECEIVABLE REVENUE	NO
ACCOUNT_TYPE_LEVEL_2	NO	DIMENSION TABLE	WDT_ACCOUNT	ACCOUNT_TYPE_LEVEL_2	RECEIVABLE REVENUE	NO
INTERNAL_ACCOUNT_TYPE	NO	DIMENSION TABLE	WDT_ACCOUNT	INTERNAL_ACCOUNT_TYPE	RECEIVABLE REVENUE	NO
INTERNAL_ACCOUNT_TYPE_DESC	NO	DIMENSION TABLE	WDT_ACCOUNT WDT_ACCOUNT	INTERNAL_ACCOUNT_TYPE_LD INTERNAL_ACCOUNT_TYPE_SD	RECEIVABLE REVENUE RECEIVABLE REVENUE	NO NO

Ver: 9.0