RETURN TO DIMENSION TABLE REPORTS LIST
Academic Program Course Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_ACADEMIC_PROGRAM

Description Academic Program Dimension table provides information for the program of study for the individual. This is the data in the academic study record that identifies the sought award or degree, etc.. 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
ACADEMIC_PROGRAM_KEY Key for the academic program dimension. NUMBER

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE

ADMISSIONS_POPULATION Identifies the type of admission the applicant is seeking or granted (e.g. early admit, regular admit, mature admit, special admit, etc.). VARCHAR2 (63)

ACADEMIC_STUDY

ADMISSIONS_POPULATION

NO

NO

ACADEMIC PROGRAM COURSE

ADMISSIONS_POPULATION_LD Long description for the admission population. VARCHAR2 (255)

ACADEMIC_STUDY

ADMISSIONS_POPULATION_DESC

NO

NO

ACADEMIC PROGRAM COURSE

ADMISSIONS_POPULATION_SD Short description for the admission population. VARCHAR2 (255)

ACADEMIC_STUDY

ADMISSIONS_POPULATION_DESC

NO

NO

ACADEMIC PROGRAM COURSE

AWARD_CATEGORY Government reporting category that groups awards and degrees together to count students. For example, Less than 2 yr, 2 yr, Bachelor, etc.. VARCHAR2 (63)

ACADEMIC_STUDY

AWARD_CATEGORY

NO

NO

ACADEMIC PROGRAM COURSE

AWARD_CATEGORY_LD Long description for the award category. VARCHAR2 (255)

ACADEMIC_STUDY

AWARD_CATEGORY_DESC

NO

NO

ACADEMIC PROGRAM COURSE

AWARD_CATEGORY_SD Short description for the award category. VARCHAR2 (255)

ACADEMIC_STUDY

AWARD_CATEGORY_DESC

NO

NO

ACADEMIC PROGRAM COURSE

CAMPUS Identifies the campus that the student is assigned as their home campus. VARCHAR2 (63)

ACADEMIC_STUDY

CAMPUS

NO

NO

ACADEMIC PROGRAM COURSE

CAMPUS_LD Long description for the student's campus. VARCHAR2 (255)

ACADEMIC_STUDY

CAMPUS_DESC

NO

NO

ACADEMIC PROGRAM COURSE

CAMPUS_SD Short description for the student's campus. VARCHAR2 (255)

ACADEMIC_STUDY

CAMPUS_DESC

NO

NO

ACADEMIC PROGRAM COURSE

COLLEGE First level of the institution organization structure that is responsible for the academic instruction responsibility for this academic program or study. VARCHAR2 (63)

ACADEMIC_STUDY

COLLEGE

NO

NO

ACADEMIC PROGRAM COURSE

COLLEGE_LD Long description for the student's college. VARCHAR2 (255)

ACADEMIC_STUDY

COLLEGE_DESC

NO

NO

ACADEMIC PROGRAM COURSE

COLLEGE_SD Short description for the student's college. VARCHAR2 (255)

ACADEMIC_STUDY

COLLEGE_DESC

NO

NO

ACADEMIC PROGRAM COURSE

DEGREE Outcome upon completion of all the requirements for a particular academic program. For example, Bachelor of Science, Associate of Arts, Vocational Certificate. VARCHAR2 (63)

ACADEMIC_STUDY

DEGREE

NO

NO

ACADEMIC PROGRAM COURSE

DEGREE_LD Long description for the student's degree. VARCHAR2 (255)

ACADEMIC_STUDY

DEGREE_DESC

NO

NO

ACADEMIC PROGRAM COURSE

DEGREE_SD Short description for the student's degree. VARCHAR2 (255)

ACADEMIC_STUDY

DEGREE_DESC

NO

NO

ACADEMIC PROGRAM COURSE

PROGRAM Program or course of study for the student. This may be blank when programs are not being used to manage a set of completion requirements. VARCHAR2 (63)

ACADEMIC_STUDY

PROGRAM

NO

NO

ACADEMIC PROGRAM COURSE

PROGRAM_LD Long description for the student's program. VARCHAR2 (255)

ACADEMIC_STUDY

PROGRAM_DESC

NO

NO

ACADEMIC PROGRAM COURSE

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

ACADEMIC_STUDY

PROGRAM_DESC

NO

NO

ACADEMIC PROGRAM COURSE

STUDENT_CLASSIFICATION Identifies the student's current class at the institution. The typical values are first year, second year, or freshman, sophomore, etc.. VARCHAR2 (63)

ACADEMIC_STUDY

STUDENT_CLASSIFICATION

NO

NO

ACADEMIC PROGRAM COURSE

STUDENT_CLASSIFICATION_LD Long description for the student classification. VARCHAR2 (255)

ACADEMIC_STUDY

STUDENT_CLASSIFICATION_DESC

NO

NO

ACADEMIC PROGRAM COURSE

STUDENT_CLASSIFICATION_SD Short description for the student classification. VARCHAR2 (255)

ACADEMIC_STUDY

STUDENT_CLASSIFICATION_DESC

NO

NO

ACADEMIC PROGRAM COURSE

STUDENT_LEVEL Level of study for the student's academic program. For example, Undergraduate, Graduate, Credit, Continuing Education, etc.. VARCHAR2 (63)

ACADEMIC_STUDY

STUDENT_LEVEL

NO

NO

ACADEMIC PROGRAM COURSE

STUDENT_LEVEL_LD Long description for the student level. VARCHAR2 (255)

ACADEMIC_STUDY

STUDENT_LEVEL_DESC

NO

NO

ACADEMIC PROGRAM COURSE

STUDENT_LEVEL_SD Short description for the student level. VARCHAR2 (255)

ACADEMIC_STUDY

STUDENT_LEVEL_DESC

NO

NO

ACADEMIC PROGRAM COURSE

STUDENT_POPULATION Identifies the category this student that will be used for governmental reporting. The typical values are new first time, transfer, continuing, etc. VARCHAR2 (63)

ACADEMIC_STUDY

STUDENT_POPULATION

NO

NO

ACADEMIC PROGRAM COURSE

STUDENT_POPULATION_LD Long description for student population. VARCHAR2 (255)

ACADEMIC_STUDY

STUDENT_POPULATION_DESC

NO

NO

ACADEMIC PROGRAM COURSE

STUDENT_POPULATION_SD Short description for student population. VARCHAR2 (255)

ACADEMIC_STUDY

STUDENT_POPULATION_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