Banner EDW Source: ORGANIZATION_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
ORGANIZATION_DESC_1	NO	DIMENSION TABLE	WDT_ORGANIZATION WDT_ORGANIZATION	ORGANIZATION_LEVEL_1_LD ORGANIZATION_LEVEL_1_SD	RECEIVABLE REVENUE RECEIVABLE REVENUE	NO NO
ORGANIZATION_DESC_2	NO	DIMENSION TABLE	WDT_ORGANIZATION WDT_ORGANIZATION	ORGANIZATION_LEVEL_2_LD ORGANIZATION_LEVEL_2_SD	RECEIVABLE REVENUE RECEIVABLE REVENUE	NO NO
ORGANIZATION_DESC_3	NO	DIMENSION TABLE	WDT_ORGANIZATION WDT_ORGANIZATION	ORGANIZATION_LEVEL_3_LD ORGANIZATION_LEVEL_3_SD	RECEIVABLE REVENUE RECEIVABLE REVENUE	NO NO
ORGANIZATION_DESC_4	NO	DIMENSION TABLE	WDT_ORGANIZATION WDT_ORGANIZATION	ORGANIZATION_LEVEL_4_LD ORGANIZATION_LEVEL_4_SD	RECEIVABLE REVENUE RECEIVABLE REVENUE	NO NO
ORGANIZATION_DESC_5	NO	DIMENSION TABLE	WDT_ORGANIZATION WDT_ORGANIZATION	ORGANIZATION_LEVEL_5_LD ORGANIZATION_LEVEL_5_SD	RECEIVABLE REVENUE RECEIVABLE REVENUE	NO NO
ORGANIZATION_DESC_6	NO	DIMENSION TABLE	WDT_ORGANIZATION WDT_ORGANIZATION	ORGANIZATION_LEVEL_6_SD ORGANIZATION_LEVEL_6_LD	RECEIVABLE REVENUE RECEIVABLE REVENUE	NO NO
ORGANIZATION_DESC_7	NO	DIMENSION TABLE	WDT_ORGANIZATION WDT_ORGANIZATION	ORGANIZATION_LEVEL_7_LD ORGANIZATION_LEVEL_7_SD	RECEIVABLE REVENUE RECEIVABLE REVENUE	NO NO
ORGANIZATION_DESC_8	NO	DIMENSION TABLE	WDT_ORGANIZATION WDT_ORGANIZATION	ORGANIZATION_LEVEL_8_LD ORGANIZATION_LEVEL_8_SD	RECEIVABLE REVENUE RECEIVABLE REVENUE	NO NO
ORGANIZATION_LEVEL_1	NO	DIMENSION TABLE	WDT_ORGANIZATION	ORGANIZATION_LEVEL_1	RECEIVABLE REVENUE	NO
ORGANIZATION_LEVEL_2	NO	DIMENSION TABLE	WDT_ORGANIZATION	ORGANIZATION_LEVEL_2	RECEIVABLE REVENUE	NO
ORGANIZATION_LEVEL_3	NO	DIMENSION TABLE	WDT_ORGANIZATION	ORGANIZATION_LEVEL_3	RECEIVABLE REVENUE	NO
ORGANIZATION_LEVEL_4	NO	DIMENSION TABLE	WDT_ORGANIZATION	ORGANIZATION_LEVEL_4	RECEIVABLE REVENUE	NO
ORGANIZATION_LEVEL_5	NO	DIMENSION TABLE	WDT_ORGANIZATION	ORGANIZATION_LEVEL_5	RECEIVABLE REVENUE	NO
ORGANIZATION_LEVEL_6	NO	DIMENSION TABLE	WDT_ORGANIZATION	ORGANIZATION_LEVEL_6	RECEIVABLE REVENUE	NO
ORGANIZATION_LEVEL_7	NO	DIMENSION TABLE	WDT_ORGANIZATION	ORGANIZATION_LEVEL_7	RECEIVABLE REVENUE	NO
ORGANIZATION_LEVEL_8	NO	DIMENSION TABLE	WDT_ORGANIZATION	ORGANIZATION_LEVEL_8	RECEIVABLE REVENUE	NO
ORGANIZATION_POOL	NO	DIMENSION TABLE	WDT_ORGANIZATION	ORGANIZATION_POOL	GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE	NO
ORGANIZATION_POOL_DESC	NO	DIMENSION TABLE	WDT_ORGANIZATION WDT_ORGANIZATION	ORGANIZATION_POOL_SD ORGANIZATION_POOL_LD	GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE	NO NO

Ver: 9.0