RETURN TO DIMENSION TABLE REPORTS LIST
Course Registration Star Enrollment Star Financial Aid Student Star Graduation Completion Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_STUDENT

Description Student Dimension table provides information for the person as the student for the time frame. This information includes student population (New first time, continuing, re-admit, etc.), year of study or student class, residency (in district or out) and campus affiliation. 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
CAMPUS Identifies the campus to that the student is assigned as the home campus. VARCHAR2(63)

ACADEMIC_OUTCOME

ACADEMIC_STUDY

CAMPUS

NO

NO

GRADUATION COMPLETION

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT

CAMPUS_LD Long description for the campus. VARCHAR2(255)

ACADEMIC_OUTCOME

ACADEMIC_STUDY

CAMPUS_DESC

NO

NO

GRADUATION COMPLETION

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT

CAMPUS_SD Short description for the campus. VARCHAR2(255)

ACADEMIC_OUTCOME

ACADEMIC_STUDY

CAMPUS_DESC

NO

NO

GRADUATION COMPLETION

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT

HOUSING_IND Identifies whether the student has been placed in institutional housing. VARCHAR2(63)

STUDENT

HOUSING_IND

NO

NO

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION

RESIDENCY Residency code for the student identifying the type of charges the student will incur. VARCHAR2(63)

STUDENT

RESIDENCY

NO

NO

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION

RESIDENCY_IND Identifies whether the student is considered in or out of the district for enrollment charges. Typically this indicates in or out of state or province but may also be in or out of county or in or out of the European Union, etc. VARCHAR2(63)

STUDENT

RESIDENCY_IND

NO

NO

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION

RESIDENCY_LD Long description for the residency code. VARCHAR2(255)

STUDENT

RESIDENCY_DESC

NO

NO

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION

RESIDENCY_SD Short description for the residency code. VARCHAR2(255)

STUDENT

RESIDENCY_DESC

NO

NO

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION

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

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION

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

ACADEMIC_STUDY

STUDENT_CLASSIFICATION_DESC

NO

NO

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION

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

ACADEMIC_STUDY

STUDENT_CLASSIFICATION_DESC

NO

NO

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION

STUDENT_KEY Key for the student dimension. NUMBER

ETL GENERATED

NA

NO

NO

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION

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

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION

STUDENT_POPULATION_LD Long description for student population code. VARCHAR2(255)

ACADEMIC_STUDY

STUDENT_POPULATION_DESC

NO

NO

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION

STUDENT_POPULATION_SD Short description for student population code. VARCHAR2(255)

ACADEMIC_STUDY

STUDENT_POPULATION_DESC

NO

NO

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION

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

ETL GENERATED

NA

NO

NO

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION

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

ETL GENERATED

NA

NO

NO

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION



Ver: 3.1