RETURN TO DIMENSION TABLE REPORTS LIST
Grant And Project Star Operating Ledger Star Receivable Revenue Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_PROGRAM

Description Program Dimension table provides information for the hierarchy of the program. This information includes the five levels that may have been assigned to the program. 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
PROGRAM Program 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

PROGRAM

B_PROGRAM

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

RECEIVABLE REVENUE

PROGRAM_KEY Key for the program dimension. NUMBER

ETL GENERATED

NA

NO

NO

GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE

PROGRAM_LD Long description of the responsible program. 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

PROGRAM_DESC

B_PROGRAM_DESC

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

RECEIVABLE REVENUE

PROGRAM_LEVEL_1 Primary program within the program 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

PROGRAM_HIERARCHY

PROGRAM_LEVEL_1

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

RECEIVABLE REVENUE

PROGRAM_LEVEL_1_LD Long hierarchy description or title appropriate for this Level. 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

PROGRAM_HIERARCHY

PROGRAM_DESC_1

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

RECEIVABLE REVENUE

PROGRAM_LEVEL_1_SD Short hierarchy description or title appropriate for this Level. VARCHAR2(255)

GRANT_LEDGER

OPERATING_LEDGER

PROGRAM_HIERARCHY

PROGRAM_DESC_1

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

RECEIVABLE REVENUE

PROGRAM_LEVEL_2 Level 2 program within this program 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

PROGRAM_HIERARCHY

PROGRAM_LEVEL_2

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

RECEIVABLE REVENUE

PROGRAM_LEVEL_2_LD Long hierarchy description or title appropriate for this Level. 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

PROGRAM_HIERARCHY

PROGRAM_DESC_2

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

RECEIVABLE REVENUE

PROGRAM_LEVEL_2_SD Short hierarchy description or title appropriate for this Level. VARCHAR2(255)

GRANT_LEDGER

OPERATING_LEDGER

PROGRAM_HIERARCHY

PROGRAM_DESC_2

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

RECEIVABLE REVENUE

PROGRAM_LEVEL_3 Level 3 program within this program 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

PROGRAM_HIERARCHY

PROGRAM_LEVEL_3

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

RECEIVABLE REVENUE

PROGRAM_LEVEL_3_LD Long hierarchy description or title appropriate for this Level. 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

PROGRAM_HIERARCHY

PROGRAM_DESC_3

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

RECEIVABLE REVENUE

PROGRAM_LEVEL_3_SD Short hierarchy description or title appropriate for this Level. VARCHAR2(255)

GRANT_LEDGER

OPERATING_LEDGER

PROGRAM_HIERARCHY

PROGRAM_DESC_3

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

RECEIVABLE REVENUE

PROGRAM_LEVEL_4 Level 4 program within this program 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

PROGRAM_HIERARCHY

PROGRAM_LEVEL_4

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

RECEIVABLE REVENUE

PROGRAM_LEVEL_4_LD Long hierarchy description or title appropriate for this Level. 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

PROGRAM_HIERARCHY

PROGRAM_DESC_4

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

RECEIVABLE REVENUE

PROGRAM_LEVEL_4_SD Short hierarchy description or title appropriate for this Level. VARCHAR2(255)

GRANT_LEDGER

OPERATING_LEDGER

PROGRAM_HIERARCHY

PROGRAM_DESC_4

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

RECEIVABLE REVENUE

PROGRAM_LEVEL_5 Level 5 program within this program 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

PROGRAM_HIERARCHY

PROGRAM_LEVEL_5

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

RECEIVABLE REVENUE

PROGRAM_LEVEL_5_LD Long hierarchy description or title appropriate for this Level. 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

PROGRAM_HIERARCHY

PROGRAM_DESC_5

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

RECEIVABLE REVENUE

PROGRAM_LEVEL_5_SD Short hierarchy description or title appropriate for this Level. VARCHAR2(255)

GRANT_LEDGER

OPERATING_LEDGER

PROGRAM_HIERARCHY

PROGRAM_DESC_5

NO

NO

GRANT AND PROJECT

OPERATING LEDGER

RECEIVABLE REVENUE

PROGRAM_SD Short description of the responsible program. VARCHAR2(255)

GRANT_LEDGER

OPERATING_LEDGER

PROGRAM_HIERARCHY

PROGRAM_DESC

B_PROGRAM_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