RETURN TO DIMENSION TABLE REPORTS LIST
Academic Program Course Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_MINOR

Description Minor Dimension table provides information for the minor. This information includes the program classification and department. 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
DEPARTMENT Department responsible for this minor in the student's academic program or study. VARCHAR2 (63)

NA

NA

NO

NO

ACADEMIC PROGRAM COURSE

DEPARTMENT_LD Long description name for this department. VARCHAR2 (255)

NA

NA

NO

NO

ACADEMIC PROGRAM COURSE

DEPARTMENT_SD Short description name for this department. VARCHAR2 (255)

NA

NA

NO

NO

ACADEMIC PROGRAM COURSE

MINOR Minor subject area emphasis of the person's academic program or study. VARCHAR2 (63)

ACADEMIC_STUDY

FIRST_MINOR

FOURTH_MINOR

SECOND_MINOR

THIRD_MINOR

NO

NO

ACADEMIC PROGRAM COURSE

MINOR_KEY Key for the minor dimension. NUMBER

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE

MINOR_LD Long description name of the student's minor subject area. VARCHAR2 (255)

ACADEMIC_STUDY

FIRST_MINOR_DESC

FOURTH_MINOR_DESC

SECOND_MINOR_DESC

THIRD_MINOR_DESC

NO

NO

ACADEMIC PROGRAM COURSE

MINOR_SD Short description name of the student's minor subject area. VARCHAR2 (255)

ACADEMIC_STUDY

FIRST_MINOR_DESC

FOURTH_MINOR_DESC

SECOND_MINOR_DESC

THIRD_MINOR_DESC

NO

NO

ACADEMIC PROGRAM COURSE

PROGRAM_CLASSIFICATION Program classification associated with the minor subject area of study for this academic program. This may be the Classification of Institutional Programs (CIP) codes used for reporting to the federal government. VARCHAR2 (63)

NA

NA

NO

NO

ACADEMIC PROGRAM COURSE

PROGRAM_CLASSIFICATION_LD Long description for the program classification. VARCHAR2 (255)

NA

NA

NO

NO

ACADEMIC PROGRAM COURSE

PROGRAM_CLASSIFICATION_SD Short description for the program classification. VARCHAR2 (255)

NA

NA

NO

NO

ACADEMIC PROGRAM COURSE

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

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE

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

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE



Ver: 3.1