Dimension Table Target: WDT

	RETURN TO BANNER EDW META DATA REPORTS LIST
	Grant And Project Star Operating Ledger Star Receivable Revenue Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_ORGANIZATION

Description Organization Dimension table provides information for the hierarchy of the organization. This information includes the organization pool information as well as the eight levels that may have been assigned to the organization. It uses the cleansing rules in the EDW for the short and long descriptions.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name

ORGANIZATION_CODE Organization that is responsible for the asset. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme.. VARCHAR2(63)
RECEIVABLE_ACCOUNTING

B_ORGANIZATION

NO
NO RECEIVABLE REVENUE

ORGANIZATION_CODE_LD Long description of the responsible organization. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme. VARCHAR2(255)
RECEIVABLE_ACCOUNTING

B_ORGANIZATION_DESC

NO
NO RECEIVABLE REVENUE

ORGANIZATION_CODE_SD Short description of the responsible organization. VARCHAR2(255)
RECEIVABLE_ACCOUNTING

B_ORGANIZATION_DESC

NO
NO RECEIVABLE REVENUE

ORGANIZATION_KEY Key for the organization dimension. NUMBER
ETL GENERATED

NA

NO
NO GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE

ORGANIZATION_LEVEL_1 Primary organization within the organization hierarchy. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme. VARCHAR2(63)
ORGANIZATION_HIERARCHY

ORGANIZATION_LEVEL_1

NO
NO RECEIVABLE REVENUE

ORGANIZATION_LEVEL_1_LD Long description of the responsible organization. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme. VARCHAR2(255)
ORGANIZATION_HIERARCHY

ORGANIZATION_DESC_1

NO
NO RECEIVABLE REVENUE

ORGANIZATION_LEVEL_1_SD Short description of the responsible organization. VARCHAR2(255)
ORGANIZATION_HIERARCHY

ORGANIZATION_DESC_1

NO
NO RECEIVABLE REVENUE

ORGANIZATION_LEVEL_2 Level 2 organization within this organization hierarchy. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme. VARCHAR2(63)
ORGANIZATION_HIERARCHY

ORGANIZATION_LEVEL_2

NO
NO RECEIVABLE REVENUE

ORGANIZATION_LEVEL_2_LD Long description of the responsible organization. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme. VARCHAR2(255)
ORGANIZATION_HIERARCHY

ORGANIZATION_DESC_2

NO
NO RECEIVABLE REVENUE

ORGANIZATION_LEVEL_2_SD Short description of the responsible organization. VARCHAR2(255)
ORGANIZATION_HIERARCHY

ORGANIZATION_DESC_2

NO
NO RECEIVABLE REVENUE

ORGANIZATION_LEVEL_3 Level 3 organization within this organization hierarchy. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme. VARCHAR2(63)
ORGANIZATION_HIERARCHY

ORGANIZATION_LEVEL_3

NO
NO RECEIVABLE REVENUE

ORGANIZATION_LEVEL_3_LD Long description of the responsible organization. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme. VARCHAR2(255)
ORGANIZATION_HIERARCHY

ORGANIZATION_DESC_3

NO
NO RECEIVABLE REVENUE

ORGANIZATION_LEVEL_3_SD Short description of the responsible organization. VARCHAR2(255)
ORGANIZATION_HIERARCHY

ORGANIZATION_DESC_3

NO
NO RECEIVABLE REVENUE

ORGANIZATION_LEVEL_4 Level 4 organization within this organization hierarchy. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme. VARCHAR2(63)
ORGANIZATION_HIERARCHY

ORGANIZATION_LEVEL_4

NO
NO RECEIVABLE REVENUE

ORGANIZATION_LEVEL_4_LD Long description of the responsible organization. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme. VARCHAR2(255)
ORGANIZATION_HIERARCHY

ORGANIZATION_DESC_4

NO
NO RECEIVABLE REVENUE

ORGANIZATION_LEVEL_4_SD Short description of the responsible organization. VARCHAR2(255)
ORGANIZATION_HIERARCHY

ORGANIZATION_DESC_4

NO
NO RECEIVABLE REVENUE

ORGANIZATION_LEVEL_5 Level 5 organization within this organization hierarchy. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme. VARCHAR2(63)
ORGANIZATION_HIERARCHY

ORGANIZATION_LEVEL_5

NO
NO RECEIVABLE REVENUE

ORGANIZATION_LEVEL_5_LD Long description of the responsible organization. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme. VARCHAR2(255)
ORGANIZATION_HIERARCHY

ORGANIZATION_DESC_5

NO
NO RECEIVABLE REVENUE

ORGANIZATION_LEVEL_5_SD Short description of the responsible organization. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme. VARCHAR2(255)
ORGANIZATION_HIERARCHY

ORGANIZATION_DESC_5

NO
NO RECEIVABLE REVENUE

ORGANIZATION_LEVEL_6 Level 6 organization within this organization hierarchy. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme. VARCHAR2(63)
ORGANIZATION_HIERARCHY

ORGANIZATION_LEVEL_6

NO
NO RECEIVABLE REVENUE

ORGANIZATION_LEVEL_6_LD Long description of the responsible organization. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme. VARCHAR2(255)
ORGANIZATION_HIERARCHY

ORGANIZATION_DESC_6

NO
NO RECEIVABLE REVENUE

ORGANIZATION_LEVEL_6_SD Short description of the responsible organization. VARCHAR2(255)
ORGANIZATION_HIERARCHY

ORGANIZATION_DESC_6

NO
NO RECEIVABLE REVENUE

ORGANIZATION_LEVEL_7 Level 7 organization within this organization hierarchy. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme. VARCHAR2(63)
ORGANIZATION_HIERARCHY

ORGANIZATION_LEVEL_7

NO
NO RECEIVABLE REVENUE

ORGANIZATION_LEVEL_7_LD Long description of the responsible organization. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme. VARCHAR2(255)
ORGANIZATION_HIERARCHY

ORGANIZATION_DESC_7

NO
NO RECEIVABLE REVENUE

ORGANIZATION_LEVEL_7_SD Short description of the responsible organization. VARCHAR2(255)
ORGANIZATION_HIERARCHY

ORGANIZATION_DESC_7

NO
NO RECEIVABLE REVENUE

ORGANIZATION_LEVEL_8 Level 8 organization within this organization hierarchy. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme. VARCHAR2(63)
ORGANIZATION_HIERARCHY

ORGANIZATION_LEVEL_8

NO
NO RECEIVABLE REVENUE

ORGANIZATION_LEVEL_8_LD Long description of the responsible organization. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme. VARCHAR2(255)
ORGANIZATION_HIERARCHY

ORGANIZATION_DESC_8

NO
NO RECEIVABLE REVENUE

ORGANIZATION_LEVEL_8_SD Short description of the responsible organization. VARCHAR2(255)
ORGANIZATION_HIERARCHY

ORGANIZATION_DESC_8

NO
NO RECEIVABLE REVENUE

ORGANIZATION_POOL Organization responsible for controlling the budget. VARCHAR2(63)
ORGANIZATION_HIERARCHY

ORGANIZATION_POOL

NO
NO GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE

ORGANIZATION_POOL_LD Long description assigned to the fund pool. VARCHAR2(255)
ORGANIZATION_HIERARCHY

ORGANIZATION_POOL_DESC

NO
NO GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE

ORGANIZATION_POOL_SD Short description assigned to the fund pool. VARCHAR2(255)
ORGANIZATION_HIERARCHY

ORGANIZATION_POOL_DESC

NO
NO GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE

SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)
ETL GENERATED

NA

NO
NO GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE

SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE
ETL GENERATED

NA

NO
NO GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE

Ver: 9.0

Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ORGANIZATION_CODE	Organization that is responsible for the asset. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme..	VARCHAR2(63)	RECEIVABLE_ACCOUNTING	B_ORGANIZATION	NO	NO	RECEIVABLE REVENUE
ORGANIZATION_CODE_LD	Long description of the responsible organization. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme.	VARCHAR2(255)	RECEIVABLE_ACCOUNTING	B_ORGANIZATION_DESC	NO	NO	RECEIVABLE REVENUE
ORGANIZATION_CODE_SD	Short description of the responsible organization.	VARCHAR2(255)	RECEIVABLE_ACCOUNTING	B_ORGANIZATION_DESC	NO	NO	RECEIVABLE REVENUE
ORGANIZATION_KEY	Key for the organization dimension.	NUMBER	ETL GENERATED	NA	NO	NO	GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE
ORGANIZATION_LEVEL_1	Primary organization within the organization hierarchy. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme.	VARCHAR2(63)	ORGANIZATION_HIERARCHY	ORGANIZATION_LEVEL_1	NO	NO	RECEIVABLE REVENUE
ORGANIZATION_LEVEL_1_LD	Long description of the responsible organization. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme.	VARCHAR2(255)	ORGANIZATION_HIERARCHY	ORGANIZATION_DESC_1	NO	NO	RECEIVABLE REVENUE
ORGANIZATION_LEVEL_1_SD	Short description of the responsible organization.	VARCHAR2(255)	ORGANIZATION_HIERARCHY	ORGANIZATION_DESC_1	NO	NO	RECEIVABLE REVENUE
ORGANIZATION_LEVEL_2	Level 2 organization within this organization hierarchy. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme.	VARCHAR2(63)	ORGANIZATION_HIERARCHY	ORGANIZATION_LEVEL_2	NO	NO	RECEIVABLE REVENUE
ORGANIZATION_LEVEL_2_LD	Long description of the responsible organization. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme.	VARCHAR2(255)	ORGANIZATION_HIERARCHY	ORGANIZATION_DESC_2	NO	NO	RECEIVABLE REVENUE
ORGANIZATION_LEVEL_2_SD	Short description of the responsible organization.	VARCHAR2(255)	ORGANIZATION_HIERARCHY	ORGANIZATION_DESC_2	NO	NO	RECEIVABLE REVENUE
ORGANIZATION_LEVEL_3	Level 3 organization within this organization hierarchy. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme.	VARCHAR2(63)	ORGANIZATION_HIERARCHY	ORGANIZATION_LEVEL_3	NO	NO	RECEIVABLE REVENUE
ORGANIZATION_LEVEL_3_LD	Long description of the responsible organization. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme.	VARCHAR2(255)	ORGANIZATION_HIERARCHY	ORGANIZATION_DESC_3	NO	NO	RECEIVABLE REVENUE
ORGANIZATION_LEVEL_3_SD	Short description of the responsible organization.	VARCHAR2(255)	ORGANIZATION_HIERARCHY	ORGANIZATION_DESC_3	NO	NO	RECEIVABLE REVENUE
ORGANIZATION_LEVEL_4	Level 4 organization within this organization hierarchy. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme.	VARCHAR2(63)	ORGANIZATION_HIERARCHY	ORGANIZATION_LEVEL_4	NO	NO	RECEIVABLE REVENUE
ORGANIZATION_LEVEL_4_LD	Long description of the responsible organization. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme.	VARCHAR2(255)	ORGANIZATION_HIERARCHY	ORGANIZATION_DESC_4	NO	NO	RECEIVABLE REVENUE
ORGANIZATION_LEVEL_4_SD	Short description of the responsible organization.	VARCHAR2(255)	ORGANIZATION_HIERARCHY	ORGANIZATION_DESC_4	NO	NO	RECEIVABLE REVENUE
ORGANIZATION_LEVEL_5	Level 5 organization within this organization hierarchy. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme.	VARCHAR2(63)	ORGANIZATION_HIERARCHY	ORGANIZATION_LEVEL_5	NO	NO	RECEIVABLE REVENUE
ORGANIZATION_LEVEL_5_LD	Long description of the responsible organization. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme.	VARCHAR2(255)	ORGANIZATION_HIERARCHY	ORGANIZATION_DESC_5	NO	NO	RECEIVABLE REVENUE
ORGANIZATION_LEVEL_5_SD	Short description of the responsible organization. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme.	VARCHAR2(255)	ORGANIZATION_HIERARCHY	ORGANIZATION_DESC_5	NO	NO	RECEIVABLE REVENUE
ORGANIZATION_LEVEL_6	Level 6 organization within this organization hierarchy. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme.	VARCHAR2(63)	ORGANIZATION_HIERARCHY	ORGANIZATION_LEVEL_6	NO	NO	RECEIVABLE REVENUE
ORGANIZATION_LEVEL_6_LD	Long description of the responsible organization. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme.	VARCHAR2(255)	ORGANIZATION_HIERARCHY	ORGANIZATION_DESC_6	NO	NO	RECEIVABLE REVENUE
ORGANIZATION_LEVEL_6_SD	Short description of the responsible organization.	VARCHAR2(255)	ORGANIZATION_HIERARCHY	ORGANIZATION_DESC_6	NO	NO	RECEIVABLE REVENUE
ORGANIZATION_LEVEL_7	Level 7 organization within this organization hierarchy. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme.	VARCHAR2(63)	ORGANIZATION_HIERARCHY	ORGANIZATION_LEVEL_7	NO	NO	RECEIVABLE REVENUE
ORGANIZATION_LEVEL_7_LD	Long description of the responsible organization. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme.	VARCHAR2(255)	ORGANIZATION_HIERARCHY	ORGANIZATION_DESC_7	NO	NO	RECEIVABLE REVENUE
ORGANIZATION_LEVEL_7_SD	Short description of the responsible organization.	VARCHAR2(255)	ORGANIZATION_HIERARCHY	ORGANIZATION_DESC_7	NO	NO	RECEIVABLE REVENUE
ORGANIZATION_LEVEL_8	Level 8 organization within this organization hierarchy. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme.	VARCHAR2(63)	ORGANIZATION_HIERARCHY	ORGANIZATION_LEVEL_8	NO	NO	RECEIVABLE REVENUE
ORGANIZATION_LEVEL_8_LD	Long description of the responsible organization. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme.	VARCHAR2(255)	ORGANIZATION_HIERARCHY	ORGANIZATION_DESC_8	NO	NO	RECEIVABLE REVENUE
ORGANIZATION_LEVEL_8_SD	Short description of the responsible organization.	VARCHAR2(255)	ORGANIZATION_HIERARCHY	ORGANIZATION_DESC_8	NO	NO	RECEIVABLE REVENUE
ORGANIZATION_POOL	Organization responsible for controlling the budget.	VARCHAR2(63)	ORGANIZATION_HIERARCHY	ORGANIZATION_POOL	NO	NO	GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE
ORGANIZATION_POOL_LD	Long description assigned to the fund pool.	VARCHAR2(255)	ORGANIZATION_HIERARCHY	ORGANIZATION_POOL_DESC	NO	NO	GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE
ORGANIZATION_POOL_SD	Short description assigned to the fund pool.	VARCHAR2(255)	ORGANIZATION_HIERARCHY	ORGANIZATION_POOL_DESC	NO	NO	GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL GENERATED	NA	NO	NO	GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED	NA	NO	NO	GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE