RETURN TO DIMENSION TABLE REPORTS LIST
Academic Program Course Star Course Registration Star Enrollment Star Financial Aid Student Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_ENROLLMENT_STATUS

Description Enrollment Status Dimension table provides information for the person that includes the time frame status of enrollment. This information includes whether they intended to study full or part time, whether or not they are currently enrolled and their current time status based on the institution defined rules. 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_OUTCOME_ENROLLED_IND Indicates whether or not the student has a 'Y' on their ENROLLMENT ODS reporting view. The academic outcome enrolled indicator was determined by the logic in the ERP system and based on the whether or not the student is matriculated in any academic study within this academic period or sub-academic period. VARCHAR2(63)

ENROLLMENT

ACADEMIC_OUTCOME_ENROLLED_IND

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT

CURRENT_TIME_STATUS Indicates the current student time status based on the credits enrolled for the time period by the student. VARCHAR2(63)

ENROLLMENT

CURRENT_TIME_STATUS

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT

CURRENT_TIME_STATUS_LD This field maintains the governmental time status long description of the enrollment dimension. VARCHAR2(255)

ENROLLMENT

CURRENT_TIME_STATUS_DESC

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT

CURRENT_TIME_STATUS_SD This field maintains the governmental time status short description of the enrollment dimension. VARCHAR2(255)

ENROLLMENT

CURRENT_TIME_STATUS_DESC

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT

ENROLLED_IND Indicates whether or not the student has a 'Y' on their ENROLLMENT ODS reporting view. The enrolled indicator was determined by the logic in the ERP system and based on the specific course status within the academic period or sub-academic period. VARCHAR2(63)

ENROLLMENT

ENROLLED_IND

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT

ENROLLMENT_STATUS Indicates the current enrollment status. VARCHAR2(63)

ENROLLMENT

ENROLLMENT_STATUS

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT

ENROLLMENT_STATUS_KEY Key for the enrollment dimension. NUMBER

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT

ENROLLMENT_STATUS_LD Long description for the enrollment status. VARCHAR2(255)

ENROLLMENT

ENROLLMENT_STATUS_DESC

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT

ENROLLMENT_STATUS_SD Short description for the enrollment status. VARCHAR2(255)

ENROLLMENT

ENROLLMENT_STATUS_DESC

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT

INTENDED_TIME_STATUS Indicates the intended time status of full-time or part-time. VARCHAR2(63)

ACADEMIC_STUDY

INTENDED_TIME_STATUS

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT

INTENDED_TIME_STATUS_LD Intended time status long description that is either Full-time or Part-time. VARCHAR2(255)

ACADEMIC_STUDY

INTENDED_TIME_STATUS

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT

INTENDED_TIME_STATUS_SD Intended time status short description that is either Full-time or Part-time. VARCHAR2(255)

ACADEMIC_STUDY

INTENDED_TIME_STATUS

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT

REGISTERED_IND Indicates whether or not the student has a 'Y' on their ENROLLMENT ODS reporting view. The registered indicator was determined by the logic in the ERP system and based on the overall status within the academic period or sub-academic period. VARCHAR2(63)

ENROLLMENT

REGISTERED_IND

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT

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, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT

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

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT



Ver: 3.1