RETURN TO DIMENSION TABLE REPORTS LIST
Academic Program Course Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_MAJOR

Description Major Dimension table information for the major. 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 major in the student's academic program or study. VARCHAR2 (63)

ACADEMIC_STUDY

DEPARTMENT

FOURTH_DEPARTMENT

SECOND_DEPARTMENT

THIRD_DEPARTMENT

NO

NO

ACADEMIC PROGRAM COURSE

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

ACADEMIC_STUDY

DEPARTMENT_DESC

FOURTH_DEPARTMENT_DESC

SECOND_DEPARTMENT_DESC

THIRD_DEPARTMENT_DESC

NO

NO

ACADEMIC PROGRAM COURSE

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

ACADEMIC_STUDY

DEPARTMENT_DESC

FOURTH_DEPARTMENT_DESC

SECOND_DEPARTMENT_DESC

THIRD_DEPARTMENT_DESC

NO

NO

ACADEMIC PROGRAM COURSE

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

ACADEMIC_STUDY

FOURTH_MAJOR

MAJOR

SECOND_MAJOR

THIRD_MAJOR

NO

NO

ACADEMIC PROGRAM COURSE

MAJOR_KEY Key for the major dimension. NUMBER

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE

MAJOR_LD Long description name of the student's major subject area. VARCHAR2 (255)

ACADEMIC_STUDY

FOURTH_MAJOR_DESC

MAJOR_DESC

SECOND_MAJOR_DESC

THIRD_MAJOR_DESC

NO

NO

ACADEMIC PROGRAM COURSE

MAJOR_SD Short description name of the student's major subject area. VARCHAR2 (255)

ACADEMIC_STUDY

FOURTH_MAJOR_DESC

MAJOR_DESC

SECOND_MAJOR_DESC

THIRD_MAJOR_DESC

NO

NO

ACADEMIC PROGRAM COURSE

PROGRAM_CLASSIFICATION Program classification associated with the major 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)

ACADEMIC_STUDY

FOURTH_PROGRAM_CLASSIFICATION

PROGRAM_CLASSIFICATION

SECOND_PROGRAM_CLASSIFICATION

THIRD_PROGRAM_CLASSIFICATION

NO

NO

ACADEMIC PROGRAM COURSE

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

ACADEMIC_STUDY

FOURTH_PROGRAM_CLASSIF_DESC

PROGRAM_CLASSIFICATION_DESC

SECOND_PROGRAM_CLASSIF_DESC

THIRD_PROGRAM_CLASSIF_DESC

NO

NO

ACADEMIC PROGRAM COURSE

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

ACADEMIC_STUDY

FOURTH_PROGRAM_CLASSIF_DESC

PROGRAM_CLASSIFICATION_DESC

SECOND_PROGRAM_CLASSIF_DESC

THIRD_PROGRAM_CLASSIF_DESC

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