Dimension Table Target: WDT_ENROLLMENT

	RETURN TO BANNER EDW META DATA REPORTS LIST
	Academic Program Course Star Course Registration Star Enrollment Star Financial Aid Student Star Student Star Student Progress 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 if the student is officially enrolled in an academic outcome in this enrollment time frame. VARCHAR2(63)
ETL GENERATED

NA

NO
NO STUDENT, STUDENT PROGRESS

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, STUDENT, STUDENT PROGRESS

CURRENT_TIME_STATUS_LD Long description for the current time status that is institution defined will be for example Full-time or Part-time. VARCHAR2(255)
ENROLLMENT

CURRENT_TIME_STATUS_DESC

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

CURRENT_TIME_STATUS_SD Short description for the current time status that is institution defined will be for example Full-time or Part-time. VARCHAR2(255)
ENROLLMENT

CURRENT_TIME_STATUS_DESC

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

ENROLLED_IND Indicates whether the student has enrolled for the academic period identified by the student having a registration enrollment status that effects headcount. VARCHAR2(63)
ENROLLMENT

ENROLLED_IND

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

ENROLLMENT_STATUS Indicates the current enrollment status. VARCHAR2(63)
ENROLLMENT

ENROLLMENT_STATUS

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

ENROLLMENT_STATUS_KEY Key for enrollment status dimension. NUMBER
ETL_GENERATED

NA

NO
NO STUDENT PROGRESS

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, STUDENT, STUDENT PROGRESS

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, STUDENT, STUDENT PROGRESS

INSTITUTION_ATTENDING Institution the student is attending if the withdrawal was to attend a different institution. VARCHAR2(63)
ENROLLMENT

TRANSFER_TO_INSTITUTION

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

INSTITUTION_ATTENDING_LD Long name for the institution attending. VARCHAR2(255)
ENROLLMENT

TRANSFER_TO_INSTITUTION_DESC

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

INSTITUTION_ATTENDING_SD Short name for the institution attending. VARCHAR2(255)
ENROLLMENT

TRANSFER_TO_INSTITUTION_DESC

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

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, STUDENT, STUDENT PROGRESS

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

NA

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

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

NA

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

LEAVE_REASON Reason the student was placed on leave defined by institution values. VARCHAR2(63)
ACADEMIC_STUDY

LEAVE_REASON

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

LEAVE_REASON_LD Long description for the leave reason. VARCHAR2(255)
ACADEMIC_STUDY

LEAVE_REASON_DESC

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

LEAVE_REASON_SD Short description for the leave reason. VARCHAR2(255)
ACADEMIC_STUDY

LEAVE_REASON_DESC

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

REGISTERED_IND Indicates that the student is considered registered because the have at least one course section with a registration course status assigned for this academic period where the status has a yes in the include in section enrollment indicator is yes. VARCHAR2(63)
ENROLLMENT

REGISTERED_IND

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

REGISTRATION_REASON Reason given at registration either for the initial registration or for change of registration defined by institution values. VARCHAR2(63)
ENROLLMENT

REGISTRATION_REASON

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

REGISTRATION_REASON_LD Short description for the registration reason. VARCHAR2(255)
ENROLLMENT

REGISTRATION_REASON_DESC

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

REGISTRATION_REASON_SD Short description for the registration reason. VARCHAR2(255)
ENROLLMENT

REGISTRATION_REASON_DESC

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

STUDENT_STATUS Student Status in the academic period that identifies whether the student can register for courses based on the permit registration indicator associated. VARCHAR2(63)
STUDENT

STUDENT_STATUS

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

STUDENT_STATUS_LD Long description for the student status. VARCHAR2(255)
STUDENT

STUDENT_STATUS_DESC

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

STUDENT_STATUS_SD Short description for the student status. VARCHAR2(255)
STUDENT

STUDENT_STATUS_DESC

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

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

NA
NA

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

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

NA
NA

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

WITHDRAWAL_REASON If the student withdraws for the institution this identifies the major reason for the student withdrawal defined by institution values. VARCHAR2(63)
ENROLLMENT

WITHDRAWAL_REASON

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

WITHDRAWAL_REASON_LD Long description for the withdrawal reason. VARCHAR2(255)
ENROLLMENT

WITHDRAWAL_REASON_DESC

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

WITHDRAWAL_REASON_SD Short description for the withdrawal reason. VARCHAR2(255)
ENROLLMENT

WITHDRAWAL_REASON_DESC

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

Ver: 9.0

Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACADEMIC_OUTCOME_ENROLLED_IND	Indicates if the student is officially enrolled in an academic outcome in this enrollment time frame.	VARCHAR2(63)	ETL GENERATED	NA	NO	NO	STUDENT, STUDENT PROGRESS
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, STUDENT, STUDENT PROGRESS
CURRENT_TIME_STATUS_LD	Long description for the current time status that is institution defined will be for example Full-time or Part-time.	VARCHAR2(255)	ENROLLMENT	CURRENT_TIME_STATUS_DESC	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS
CURRENT_TIME_STATUS_SD	Short description for the current time status that is institution defined will be for example Full-time or Part-time.	VARCHAR2(255)	ENROLLMENT	CURRENT_TIME_STATUS_DESC	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS
ENROLLED_IND	Indicates whether the student has enrolled for the academic period identified by the student having a registration enrollment status that effects headcount.	VARCHAR2(63)	ENROLLMENT	ENROLLED_IND	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS
ENROLLMENT_STATUS	Indicates the current enrollment status.	VARCHAR2(63)	ENROLLMENT	ENROLLMENT_STATUS	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS
ENROLLMENT_STATUS_KEY	Key for enrollment status dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	STUDENT PROGRESS
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, STUDENT, STUDENT PROGRESS
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, STUDENT, STUDENT PROGRESS
INSTITUTION_ATTENDING	Institution the student is attending if the withdrawal was to attend a different institution.	VARCHAR2(63)	ENROLLMENT	TRANSFER_TO_INSTITUTION	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS
INSTITUTION_ATTENDING_LD	Long name for the institution attending.	VARCHAR2(255)	ENROLLMENT	TRANSFER_TO_INSTITUTION_DESC	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS
INSTITUTION_ATTENDING_SD	Short name for the institution attending.	VARCHAR2(255)	ENROLLMENT	TRANSFER_TO_INSTITUTION_DESC	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS
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, STUDENT, STUDENT PROGRESS
INTENDED_TIME_STATUS_LD	Intended time status long description that is either Full-time or Part-time.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS
INTENDED_TIME_STATUS_SD	Intended time status short description that is either Full-time or Part-time.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS
LEAVE_REASON	Reason the student was placed on leave defined by institution values.	VARCHAR2(63)	ACADEMIC_STUDY	LEAVE_REASON	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS
LEAVE_REASON_LD	Long description for the leave reason.	VARCHAR2(255)	ACADEMIC_STUDY	LEAVE_REASON_DESC	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS
LEAVE_REASON_SD	Short description for the leave reason.	VARCHAR2(255)	ACADEMIC_STUDY	LEAVE_REASON_DESC	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS
REGISTERED_IND	Indicates that the student is considered registered because the have at least one course section with a registration course status assigned for this academic period where the status has a yes in the include in section enrollment indicator is yes.	VARCHAR2(63)	ENROLLMENT	REGISTERED_IND	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS
REGISTRATION_REASON	Reason given at registration either for the initial registration or for change of registration defined by institution values.	VARCHAR2(63)	ENROLLMENT	REGISTRATION_REASON	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS
REGISTRATION_REASON_LD	Short description for the registration reason.	VARCHAR2(255)	ENROLLMENT	REGISTRATION_REASON_DESC	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS
REGISTRATION_REASON_SD	Short description for the registration reason.	VARCHAR2(255)	ENROLLMENT	REGISTRATION_REASON_DESC	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS
STUDENT_STATUS	Student Status in the academic period that identifies whether the student can register for courses based on the permit registration indicator associated.	VARCHAR2(63)	STUDENT	STUDENT_STATUS	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS
STUDENT_STATUS_LD	Long description for the student status.	VARCHAR2(255)	STUDENT	STUDENT_STATUS_DESC	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS
STUDENT_STATUS_SD	Short description for the student status.	VARCHAR2(255)	STUDENT	STUDENT_STATUS_DESC	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL GENERATED ETL_GENERATED	NA NA	NO NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS STUDENT PROGRESS
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED ETL_GENERATED	NA NA	NO NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS STUDENT PROGRESS
WITHDRAWAL_REASON	If the student withdraws for the institution this identifies the major reason for the student withdrawal defined by institution values.	VARCHAR2(63)	ENROLLMENT	WITHDRAWAL_REASON	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS
WITHDRAWAL_REASON_LD	Long description for the withdrawal reason.	VARCHAR2(255)	ENROLLMENT	WITHDRAWAL_REASON_DESC	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS
WITHDRAWAL_REASON_SD	Short description for the withdrawal reason.	VARCHAR2(255)	ENROLLMENT	WITHDRAWAL_REASON_DESC	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS