RETURN TO DIMENSION TABLE REPORTS LIST
Academic Program Course Star  Course Registration 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
FINAL_GRADE Final grade assigned to the student for the course. VARCHAR2(63)

STUDENT_COURSE

FINAL_GRADE

NO

NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION
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
GRADE_TYPE_LD Long description for the types of grades. VARCHAR2(255)

STUDENT_COURSE

GRADE_TYPE_DESC

NO

NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION
GRADE_TYPE_SD Short description for the types of grades. VARCHAR2(255)

STUDENT_COURSE

GRADE_TYPE_DESC

NO

NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION
REGISTRATION_KEY Key for the registration dimension. NUMBER

ETL GENERATED

NA

NO

NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION
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
REGISTRATION_STATUS_LD Long description for the registration status. VARCHAR2(255)

STUDENT_COURSE

REGISTRATION_STATUS_DESC

NO

NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION
REGISTRATION_STATUS_SD Short description for the registration status. VARCHAR2(255)

STUDENT_COURSE

REGISTRATION_STATUS_DESC

NO

NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION
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
SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

ETL GENERATED

NA

NO

NO ACADEMIC PROGRAM COURSE, COURSE REGISTRATION


Ver: 8.1