RETURN TO DIMENSION TABLE REPORTS LIST
Academic Program Course Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_CONCENTRATION

Description Concentration Dimension table provides information for the concentration. This information includes the program classification, department and major the concentration is attached to (where appropriate). 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
CONCENTRATION Major concentration or study emphasis attached to this major within the student's academic program or study. VARCHAR2 (63)

ACADEMIC_STUDY

FIRST_CONCENTRATION

FOURTH_MAJOR_CONC_1

FOURTH_MAJOR_CONC_2

FOURTH_MAJOR_CONC_3

SECOND_CONCENTRATION

SECOND_MAJOR_CONC_1

SECOND_MAJOR_CONC_2

SECOND_MAJOR_CONC_3

THIRD_CONCENTRATION

THIRD_MAJOR_CONC_1

THIRD_MAJOR_CONC_2

THIRD_MAJOR_CONC_3

NO

NO

ACADEMIC PROGRAM COURSE

CONCENTRATION_KEY Key for the concentration dimension. NUMBER

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE

CONCENTRATION_LD Long description for the major concentration or study emphasis. VARCHAR2 (255)

ACADEMIC_STUDY

FIRST_CONCENTRATION_DESC

FOURTH_MAJOR_CONC_1_DESC

FOURTH_MAJOR_CONC_2_DESC

FOURTH_MAJOR_CONC_3_DESC

SECOND_CONCENTRATION_DESC

SECOND_MAJOR_CONC_1_DESC

SECOND_MAJOR_CONC_2_DESC

SECOND_MAJOR_CONC_3_DESC

THIRD_CONCENTRATION_DESC

THIRD_MAJOR_CONC_1_DESC

THIRD_MAJOR_CONC_2_DESC

THIRD_MAJOR_CONC_3_DESC

NO

NO

ACADEMIC PROGRAM COURSE

CONCENTRATION_MAJOR Major subject area to which this concentration is attached. VARCHAR2 (63)

ACADEMIC_STUDY

FOURTH_MAJOR

MAJOR

SECOND_MAJOR

THIRD_MAJOR

NO

NO

ACADEMIC PROGRAM COURSE

CONCENTRATION_MAJOR_LD Long name for the student's major concentration subject area. VARCHAR2 (255)

ACADEMIC_STUDY

FOURTH_MAJOR_DESC

MAJOR_DESC

SECOND_MAJOR_DESC

THIRD_MAJOR_DESC

NO

NO

ACADEMIC PROGRAM COURSE

CONCENTRATION_MAJOR_SD Short name for the student's major concentration subject area. VARCHAR2 (255)

ACADEMIC_STUDY

FOURTH_MAJOR_DESC

MAJOR_DESC

SECOND_MAJOR_DESC

THIRD_MAJOR_DESC

NO

NO

ACADEMIC PROGRAM COURSE

CONCENTRATION_SD Short description for the major concentration or study emphasis. VARCHAR2 (255)

ACADEMIC_STUDY

FIRST_CONCENTRATION_DESC

FOURTH_MAJOR_CONC_1_DESC

FOURTH_MAJOR_CONC_2_DESC

FOURTH_MAJOR_CONC_3_DESC

SECOND_CONCENTRATION_DESC

SECOND_MAJOR_CONC_1_DESC

SECOND_MAJOR_CONC_2_DESC

SECOND_MAJOR_CONC_3_DESC

THIRD_CONCENTRATION_DESC

THIRD_MAJOR_CONC_1_DESC

THIRD_MAJOR_CONC_2_DESC

THIRD_MAJOR_CONC_3_DESC

NO

NO

ACADEMIC PROGRAM COURSE

DEPARTMENT Department responsible for this concentration in this major for the student's academic program or study. VARCHAR2 (63)

NA

NA

NO

NO

ACADEMIC PROGRAM COURSE

DEPARTMENT_LD Long description for this department. VARCHAR2 (255)

NA

NA

NO

NO

ACADEMIC PROGRAM COURSE

DEPARTMENT_SD Short description for this department. VARCHAR2 (255)

NA

NA

NO

NO

ACADEMIC PROGRAM COURSE

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