Dimension Table Target: WDT

	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
PROGRAM
B_PROGRAM

NO
NO
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
PROGRAM_DESC
B_PROGRAM_DESC

NO
NO
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
PROGRAM_LEVEL_1
PROGRAM_LEVEL_1

NO
NO
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
PROGRAM_DESC_1
PROGRAM_DESC_1

NO
NO
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
PROGRAM_DESC_1
PROGRAM_DESC_1

NO
NO
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
PROGRAM_LEVEL_2
PROGRAM_LEVEL_2

NO
NO
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
PROGRAM_DESC_2
PROGRAM_DESC_2

NO
NO
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
PROGRAM_DESC_2
PROGRAM_DESC_2

NO
NO
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
PROGRAM_LEVEL_3
PROGRAM_LEVEL_3

NO
NO
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
PROGRAM_DESC_3
PROGRAM_DESC_3

NO
NO
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
PROGRAM_DESC_3
PROGRAM_DESC_3

NO
NO
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
PROGRAM_LEVEL_4
PROGRAM_LEVEL_4

NO
NO
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
PROGRAM_DESC_4
PROGRAM_DESC_4

NO
NO
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
PROGRAM_DESC_4
PROGRAM_DESC_4

NO
NO
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
PROGRAM_LEVEL_5
PROGRAM_LEVEL_5

NO
NO
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
PROGRAM_DESC_5
PROGRAM_DESC_5

NO
NO
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
PROGRAM_DESC_5
PROGRAM_DESC_5

NO
NO
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
PROGRAM_DESC
B_PROGRAM_DESC

NO
NO
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: 8.1

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 PROGRAM B_PROGRAM	NO NO 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 PROGRAM_DESC B_PROGRAM_DESC	NO NO 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 PROGRAM_LEVEL_1 PROGRAM_LEVEL_1	NO NO 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 PROGRAM_DESC_1 PROGRAM_DESC_1	NO NO 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 PROGRAM_DESC_1 PROGRAM_DESC_1	NO NO 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 PROGRAM_LEVEL_2 PROGRAM_LEVEL_2	NO NO 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 PROGRAM_DESC_2 PROGRAM_DESC_2	NO NO 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 PROGRAM_DESC_2 PROGRAM_DESC_2	NO NO 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 PROGRAM_LEVEL_3 PROGRAM_LEVEL_3	NO NO 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 PROGRAM_DESC_3 PROGRAM_DESC_3	NO NO 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 PROGRAM_DESC_3 PROGRAM_DESC_3	NO NO 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 PROGRAM_LEVEL_4 PROGRAM_LEVEL_4	NO NO 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 PROGRAM_DESC_4 PROGRAM_DESC_4	NO NO 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 PROGRAM_DESC_4 PROGRAM_DESC_4	NO NO 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 PROGRAM_LEVEL_5 PROGRAM_LEVEL_5	NO NO 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 PROGRAM_DESC_5 PROGRAM_DESC_5	NO NO 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 PROGRAM_DESC_5 PROGRAM_DESC_5	NO NO 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 PROGRAM_DESC B_PROGRAM_DESC	NO NO 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