RETURN TO DIMENSION TABLE 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)

GRANT_LEDGER

OPERATING_LEDGER

RECEIVABLE_ACCOUNTING

ORGANIZATION_CODE

B_ORGANIZATION

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

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)

GRANT_LEDGER

OPERATING_LEDGER

RECEIVABLE_ACCOUNTING

ORGANIZATION_DESC

B_ORGANIZATION_DESC

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

RECEIVABLE REVENUE

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

GRANT_LEDGER

OPERATING_LEDGER

RECEIVABLE_ACCOUNTING

ORGANIZATION_DESC

B_ORGANIZATION_DESC

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

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)

GRANT_LEDGER

OPERATING_LEDGER

ORGANIZATION_HIERARCHY

ORGANIZATION_LEVEL_1

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

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)

GRANT_LEDGER

OPERATING_LEDGER

ORGANIZATION_HIERARCHY

ORGANIZATION_DESC_1

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

RECEIVABLE REVENUE

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

GRANT_LEDGER

OPERATING_LEDGER

ORGANIZATION_HIERARCHY

ORGANIZATION_DESC_1

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

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)

GRANT_LEDGER

OPERATING_LEDGER

ORGANIZATION_HIERARCHY

ORGANIZATION_LEVEL_2

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

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)

GRANT_LEDGER

OPERATING_LEDGER

ORGANIZATION_HIERARCHY

ORGANIZATION_DESC_2

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

RECEIVABLE REVENUE

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

GRANT_LEDGER

OPERATING_LEDGER

ORGANIZATION_HIERARCHY

ORGANIZATION_DESC_2

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

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)

GRANT_LEDGER

OPERATING_LEDGER

ORGANIZATION_HIERARCHY

ORGANIZATION_LEVEL_3

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

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)

GRANT_LEDGER

OPERATING_LEDGER

ORGANIZATION_HIERARCHY

ORGANIZATION_DESC_3

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

RECEIVABLE REVENUE

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

GRANT_LEDGER

OPERATING_LEDGER

ORGANIZATION_HIERARCHY

ORGANIZATION_DESC_3

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

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)

GRANT_LEDGER

OPERATING_LEDGER

ORGANIZATION_HIERARCHY

ORGANIZATION_LEVEL_4

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

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)

GRANT_LEDGER

OPERATING_LEDGER

ORGANIZATION_HIERARCHY

ORGANIZATION_DESC_4

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

RECEIVABLE REVENUE

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

GRANT_LEDGER

OPERATING_LEDGER

ORGANIZATION_HIERARCHY

ORGANIZATION_DESC_4

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

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)

GRANT_LEDGER

OPERATING_LEDGER

ORGANIZATION_HIERARCHY

ORGANIZATION_LEVEL_5

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

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)

GRANT_LEDGER

OPERATING_LEDGER

ORGANIZATION_HIERARCHY

ORGANIZATION_DESC_5

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

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)

GRANT_LEDGER

OPERATING_LEDGER

ORGANIZATION_HIERARCHY

ORGANIZATION_DESC_5

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

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)

GRANT_LEDGER

OPERATING_LEDGER

ORGANIZATION_HIERARCHY

ORGANIZATION_LEVEL_6

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

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)

GRANT_LEDGER

OPERATING_LEDGER

ORGANIZATION_HIERARCHY

ORGANIZATION_DESC_6

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

RECEIVABLE REVENUE

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

GRANT_LEDGER

OPERATING_LEDGER

ORGANIZATION_HIERARCHY

ORGANIZATION_DESC_6

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

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)

GRANT_LEDGER

OPERATING_LEDGER

ORGANIZATION_HIERARCHY

ORGANIZATION_LEVEL_7

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

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)

GRANT_LEDGER

OPERATING_LEDGER

ORGANIZATION_HIERARCHY

ORGANIZATION_DESC_7

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

RECEIVABLE REVENUE

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

GRANT_LEDGER

OPERATING_LEDGER

ORGANIZATION_HIERARCHY

ORGANIZATION_DESC_7

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

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)

GRANT_LEDGER

OPERATING_LEDGER

ORGANIZATION_HIERARCHY

ORGANIZATION_LEVEL_8

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

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)

GRANT_LEDGER

OPERATING_LEDGER

ORGANIZATION_HIERARCHY

ORGANIZATION_DESC_8

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

RECEIVABLE REVENUE

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

GRANT_LEDGER

OPERATING_LEDGER

ORGANIZATION_HIERARCHY

ORGANIZATION_DESC_8

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

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: 3.1