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