Dimension Table Target: WDT_ENROLLMENT

	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: 8.1

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