Dimension Table Target: WDT

	RETURN TO BANNER EDW META DATA REPORTS LIST
	Academic Program Course Star Course Registration Star Student Course Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_REGISTRATION

Description Registration Dimension table provides information for the person that includes the time frame registration status for a schedule offering. This information includes final grade if assigned, type of grading (regular, Pass/Fail, Audit, etc.) and section registration status. 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

COURSE_ATTEMPTED_IND Indicates the course section counts as a course attempted and the course credits are added the credits attempted based on the final grade assigned to the person. NUMBER
STUDENT_COURSE

COURSE_ATTEMPTED_IND

NO
NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE

COURSE_ATTEMPTED_IND_LD Long description for the course attempted indicator. VARCHAR2(255)
EDW CLEANSING PROCESS

NA

NO
NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE

COURSE_ATTEMPTED_IND_SD Short description for the course attempted indicator. VARCHAR2(255)
EDW CLEANSING PROCESS

NA

NO
NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE

COURSE_DROPPED_IND Indicates the course section counts as a dropped course based on the final grade assigned to the person. NUMBER
FUNCTION

CASE WHEN STUDENT_COURSE_REC.COURSE_REGISTER_IND ='Y' THEN

NO
NO

COURSE_DROPPED_IND_LD Long description for the dropped course indicator. VARCHAR2(255)
EDW CLEANSING PROCESS

NA

NO
NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE

COURSE_DROPPED_IND_SD Short description for the dropped course indicator. VARCHAR2(255)
EDW CLEANSING PROCESS

NA

NO
NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE

COURSE_FAILED_IND Indicates the course section counts as a failed course and the course credits are added to the failed credits based on the final grade assigned to the person. NUMBER
STUDENT_COURSE

COURSE_FAILED_IND

NO
NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE

COURSE_FAILED_IND_LD Long description for the failed course indicator. VARCHAR2(255)
EDW CLEANSING PROCESS

NA

NO
NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE

COURSE_FAILED_IND_SD Short description for the failed course indicator. VARCHAR2(255)
EDW CLEANSING PROCESS

NA

NO
NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE

COURSE_PASSED_IND Indicates the course section counts as a passed course and the course credits are added to the passed credits based on the final grade assigned to the person. NUMBER
STUDENT_COURSE

COURSE_PASSED_IND

NO
NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE

COURSE_PASSED_IND_LD Long description for the passed course indicator. VARCHAR2(255)
EDW CLEANSING PROCESS

NA

NO
NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE

COURSE_PASSED_IND_SD Short description for the passed course indicator. VARCHAR2(255)
EDW CLEANSING PROCESS

NA

NO
NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE

COURSE_REGISTER_IND Indicates whether the student counts as registered in the course section. NUMBER
STUDENT_COURSE

COURSE_REGISTER_IND

NO
NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE

COURSE_REGISTER_IND_LD Long description for the course registration indicator. VARCHAR2(255)
EDW CLEANSING PROCESS

NA

NO
NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE

COURSE_REGISTER_IND_SD Short description for the course registration indicator. VARCHAR2(255)
EDW CLEANSING PROCESS

NA

NO
NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE

COURSE_WITHDRAWN_IND Indicates the course section counts as a withdrawn course based on the final grade assigned to the person. NUMBER
STUDENT_COURSE

WITHDRAWN_IND

NO
NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE

COURSE_WITHDRAWN_IND_LD Long description for the withdrawn course indicator. VARCHAR2(255)
EDW CLEANSING PROCESS

NA

NO
NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE

COURSE_WITHDRAWN_IND_SD Short description for the withdrawn course indicator. VARCHAR2(255)
EDW CLEANSING PROCESS

NA

NO
NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE

FINAL_GRADE Final grade assigned to the student for the course. VARCHAR2(63)
STUDENT_COURSE

FINAL_GRADE

NO
NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE

GRADE_TYPE Defines the grading scheme used for the grade codes available in this combination. VARCHAR2(63)
STUDENT_COURSE

GRADE_TYPE

NO
NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE

GRADE_TYPE_LD Long description for the types of grades. VARCHAR2(255)
STUDENT_COURSE

GRADE_TYPE_DESC

NO
NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE

GRADE_TYPE_SD Short description for the types of grades. VARCHAR2(255)
STUDENT_COURSE

GRADE_TYPE_DESC

NO
NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE

REGISTER_CENSUS_DATE1_IND Indicates a registration course status that identifies the person counts in the course section headcount was recorded prior to the census date. NUMBER
STUDENT_COURSE

REGISTER_CENSUS_DATE1_IND

NO
NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE

REGISTER_CENSUS_DATE1_IND_LD Long description for the course register by census date indicator. VARCHAR2(255)
EDW CLEANSING PROCESS

NA

NO
NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE

REGISTER_CENSUS_DATE1_IND_SD Short description for the course register by census date indicator. VARCHAR2(255)
EDW CLEANSING PROCESS

NA

NO
NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE

REGISTER_CENSUS_DATE2_IND Indicates a registration course status that Identifies the person counts in the course section headcount was recorded prior to the census date 2. NUMBER
STUDENT_COURSE

REGISTER_CENSUS_DATE2_IND

NO
NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE

REGISTER_CENSUS_DATE2_IND_LD Long description for the course register by census date 2 indicator. VARCHAR2(255)
EDW CLEANSING PROCESS

NA

NO
NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE

REGISTER_CENSUS_DATE2_IND_SD Short description for the course register by census date 2 indicator. VARCHAR2(255)
EDW CLEANSING PROCESS

NA

NO
NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE

REGISTRATION_KEY Key for the registration dimension. NUMBER
ETL_GENERATED

NA

NO
NO STUDENT COURSE

REGISTRATION_OVERRIDE_IND Indicates a registration restriction was overridden for the person to register in this course section. NUMBER
STUDENT_COURSE

REGISTRATION_OVERRIDE_IND

NO
NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE

REGISTRATION_OVERRIDE_IND_LD Long description for the registration override indicator. VARCHAR2(255)
EDW CLEANSING PROCESS

NA

NO
NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE

REGISTRATION_OVERRIDE_IND_SD Short description for the registration override indicator. VARCHAR2(255)
EDW CLEANSING PROCESS

NA

NO
NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE

REGISTRATION_STATUS Registration status of the student in the course. For example, registered, withdrawn, auditing, etc. VARCHAR2(63)
STUDENT_COURSE

REGISTRATION_STATUS

NO
NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE

REGISTRATION_STATUS_LD Long description for the registration status. VARCHAR2(255)
STUDENT_COURSE

REGISTRATION_STATUS_DESC

NO
NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE

REGISTRATION_STATUS_SD Short description for the registration status. VARCHAR2(255)
STUDENT_COURSE

REGISTRATION_STATUS_DESC

NO
NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE

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

SYSTEM_LOAD_PROCESS

NO
NO STUDENT COURSE

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

SYSTEM_LOAD_TMSTMP

NO
NO STUDENT COURSE

Ver: 9.0

Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
COURSE_ATTEMPTED_IND	Indicates the course section counts as a course attempted and the course credits are added the credits attempted based on the final grade assigned to the person.	NUMBER	STUDENT_COURSE	COURSE_ATTEMPTED_IND	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE
COURSE_ATTEMPTED_IND_LD	Long description for the course attempted indicator.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE
COURSE_ATTEMPTED_IND_SD	Short description for the course attempted indicator.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE
COURSE_DROPPED_IND	Indicates the course section counts as a dropped course based on the final grade assigned to the person.	NUMBER	FUNCTION	CASE WHEN STUDENT_COURSE_REC.COURSE_REGISTER_IND ='Y' THEN	NO	NO
COURSE_DROPPED_IND_LD	Long description for the dropped course indicator.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE
COURSE_DROPPED_IND_SD	Short description for the dropped course indicator.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE
COURSE_FAILED_IND	Indicates the course section counts as a failed course and the course credits are added to the failed credits based on the final grade assigned to the person.	NUMBER	STUDENT_COURSE	COURSE_FAILED_IND	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE
COURSE_FAILED_IND_LD	Long description for the failed course indicator.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE
COURSE_FAILED_IND_SD	Short description for the failed course indicator.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE
COURSE_PASSED_IND	Indicates the course section counts as a passed course and the course credits are added to the passed credits based on the final grade assigned to the person.	NUMBER	STUDENT_COURSE	COURSE_PASSED_IND	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE
COURSE_PASSED_IND_LD	Long description for the passed course indicator.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE
COURSE_PASSED_IND_SD	Short description for the passed course indicator.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE
COURSE_REGISTER_IND	Indicates whether the student counts as registered in the course section.	NUMBER	STUDENT_COURSE	COURSE_REGISTER_IND	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE
COURSE_REGISTER_IND_LD	Long description for the course registration indicator.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE
COURSE_REGISTER_IND_SD	Short description for the course registration indicator.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE
COURSE_WITHDRAWN_IND	Indicates the course section counts as a withdrawn course based on the final grade assigned to the person.	NUMBER	STUDENT_COURSE	WITHDRAWN_IND	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE
COURSE_WITHDRAWN_IND_LD	Long description for the withdrawn course indicator.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE
COURSE_WITHDRAWN_IND_SD	Short description for the withdrawn course indicator.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE
FINAL_GRADE	Final grade assigned to the student for the course.	VARCHAR2(63)	STUDENT_COURSE	FINAL_GRADE	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE
GRADE_TYPE	Defines the grading scheme used for the grade codes available in this combination.	VARCHAR2(63)	STUDENT_COURSE	GRADE_TYPE	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE
GRADE_TYPE_LD	Long description for the types of grades.	VARCHAR2(255)	STUDENT_COURSE	GRADE_TYPE_DESC	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE
GRADE_TYPE_SD	Short description for the types of grades.	VARCHAR2(255)	STUDENT_COURSE	GRADE_TYPE_DESC	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE
REGISTER_CENSUS_DATE1_IND	Indicates a registration course status that identifies the person counts in the course section headcount was recorded prior to the census date.	NUMBER	STUDENT_COURSE	REGISTER_CENSUS_DATE1_IND	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE
REGISTER_CENSUS_DATE1_IND_LD	Long description for the course register by census date indicator.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE
REGISTER_CENSUS_DATE1_IND_SD	Short description for the course register by census date indicator.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE
REGISTER_CENSUS_DATE2_IND	Indicates a registration course status that Identifies the person counts in the course section headcount was recorded prior to the census date 2.	NUMBER	STUDENT_COURSE	REGISTER_CENSUS_DATE2_IND	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE
REGISTER_CENSUS_DATE2_IND_LD	Long description for the course register by census date 2 indicator.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE
REGISTER_CENSUS_DATE2_IND_SD	Short description for the course register by census date 2 indicator.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE
REGISTRATION_KEY	Key for the registration dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	STUDENT COURSE
REGISTRATION_OVERRIDE_IND	Indicates a registration restriction was overridden for the person to register in this course section.	NUMBER	STUDENT_COURSE	REGISTRATION_OVERRIDE_IND	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE
REGISTRATION_OVERRIDE_IND_LD	Long description for the registration override indicator.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE
REGISTRATION_OVERRIDE_IND_SD	Short description for the registration override indicator.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE
REGISTRATION_STATUS	Registration status of the student in the course. For example, registered, withdrawn, auditing, etc.	VARCHAR2(63)	STUDENT_COURSE	REGISTRATION_STATUS	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE
REGISTRATION_STATUS_LD	Long description for the registration status.	VARCHAR2(255)	STUDENT_COURSE	REGISTRATION_STATUS_DESC	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE
REGISTRATION_STATUS_SD	Short description for the registration status.	VARCHAR2(255)	STUDENT_COURSE	REGISTRATION_STATUS_DESC	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	STUDENT_COURSE	SYSTEM_LOAD_PROCESS	NO	NO	STUDENT COURSE
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	STUDENT_COURSE	SYSTEM_LOAD_TMSTMP	NO	NO	STUDENT COURSE