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_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 Student's program, curriculum or course of study. This may be Data Not Available when program codes have not been defined by the institution. The alternate curriculum identification is by a combination of college, degree and major codes. VARCHAR2(63)
RECEIVABLE_ACCOUNTING

B_PROGRAM

NO
NO 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 student's program. VARCHAR2(255)
RECEIVABLE_ACCOUNTING

B_PROGRAM_DESC

NO
NO 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)
PROGRAM_HIERARCHY

PROGRAM_LEVEL_1

NO
NO 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)
PROGRAM_HIERARCHY

PROGRAM_DESC_1

NO
NO RECEIVABLE REVENUE

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

PROGRAM_DESC_1

NO
NO 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)
PROGRAM_HIERARCHY

PROGRAM_LEVEL_2

NO
NO 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)
PROGRAM_HIERARCHY

PROGRAM_DESC_2

NO
NO RECEIVABLE REVENUE

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

PROGRAM_DESC_2

NO
NO 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)
PROGRAM_HIERARCHY

PROGRAM_LEVEL_3

NO
NO 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)
PROGRAM_HIERARCHY

PROGRAM_DESC_3

NO
NO RECEIVABLE REVENUE

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

PROGRAM_DESC_3

NO
NO 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)
PROGRAM_HIERARCHY

PROGRAM_LEVEL_4

NO
NO 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)
PROGRAM_HIERARCHY

PROGRAM_DESC_4

NO
NO RECEIVABLE REVENUE

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

PROGRAM_DESC_4

NO
NO 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)
PROGRAM_HIERARCHY

PROGRAM_LEVEL_5

NO
NO 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)
PROGRAM_HIERARCHY

PROGRAM_DESC_5

NO
NO RECEIVABLE REVENUE

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

PROGRAM_DESC_5

NO
NO RECEIVABLE REVENUE

PROGRAM_SD Short description of the student's program. VARCHAR2(255)
OPERATING_LEDGER

PROGRAM_DESC

NO
NO 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
PROGRAM	Student's program, curriculum or course of study. This may be Data Not Available when program codes have not been defined by the institution. The alternate curriculum identification is by a combination of college, degree and major codes.	VARCHAR2(63)	RECEIVABLE_ACCOUNTING	B_PROGRAM	NO	NO	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 student's program.	VARCHAR2(255)	RECEIVABLE_ACCOUNTING	B_PROGRAM_DESC	NO	NO	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)	PROGRAM_HIERARCHY	PROGRAM_LEVEL_1	NO	NO	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)	PROGRAM_HIERARCHY	PROGRAM_DESC_1	NO	NO	RECEIVABLE REVENUE
PROGRAM_LEVEL_1_SD	Short hierarchy description or title appropriate for this Level.	VARCHAR2(255)	PROGRAM_HIERARCHY	PROGRAM_DESC_1	NO	NO	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)	PROGRAM_HIERARCHY	PROGRAM_LEVEL_2	NO	NO	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)	PROGRAM_HIERARCHY	PROGRAM_DESC_2	NO	NO	RECEIVABLE REVENUE
PROGRAM_LEVEL_2_SD	Short hierarchy description or title appropriate for this Level.	VARCHAR2(255)	PROGRAM_HIERARCHY	PROGRAM_DESC_2	NO	NO	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)	PROGRAM_HIERARCHY	PROGRAM_LEVEL_3	NO	NO	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)	PROGRAM_HIERARCHY	PROGRAM_DESC_3	NO	NO	RECEIVABLE REVENUE
PROGRAM_LEVEL_3_SD	Short hierarchy description or title appropriate for this Level.	VARCHAR2(255)	PROGRAM_HIERARCHY	PROGRAM_DESC_3	NO	NO	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)	PROGRAM_HIERARCHY	PROGRAM_LEVEL_4	NO	NO	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)	PROGRAM_HIERARCHY	PROGRAM_DESC_4	NO	NO	RECEIVABLE REVENUE
PROGRAM_LEVEL_4_SD	Short hierarchy description or title appropriate for this Level.	VARCHAR2(255)	PROGRAM_HIERARCHY	PROGRAM_DESC_4	NO	NO	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)	PROGRAM_HIERARCHY	PROGRAM_LEVEL_5	NO	NO	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)	PROGRAM_HIERARCHY	PROGRAM_DESC_5	NO	NO	RECEIVABLE REVENUE
PROGRAM_LEVEL_5_SD	Short hierarchy description or title appropriate for this Level.	VARCHAR2(255)	PROGRAM_HIERARCHY	PROGRAM_DESC_5	NO	NO	RECEIVABLE REVENUE
PROGRAM_SD	Short description of the student's program.	VARCHAR2(255)	OPERATING_LEDGER	PROGRAM_DESC	NO	NO	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