RETURN TO BANNER EDW META DATA REPORTS LIST
Grade Change Star  Student Course Star  

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_GRADE_CHANGE

Description Grade Change Dimension table provides a history of any grade changes for the student course. Data includes the grade change reason and comment on why change was made.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
GRADE_CHANGE_KEY Key for the grade change dimension. NUMBER

ETL_GENERATED

NA

NO

NO GRADE CHANGE, STUDENT COURSE
GRADE_CHANGE_REASON Institution defined grade change reason associated with this grade for this course. VARCHAR2(63)

STUDENT_COURSE_GRADE_CHANGE

GRADE_CHANGE_REASON

NO

NO GRADE CHANGE, STUDENT COURSE
GRADE_CHANGE_REASON_LD Long grade change reason description. VARCHAR2(255)

STUDENT_COURSE_GRADE_CHANGE

GRADE_CHANGE_REASON_DESC

NO

NO GRADE CHANGE, STUDENT COURSE
GRADE_CHANGE_REASON_SD Short grade change reason description. VARCHAR2(255)

STUDENT_COURSE_GRADE_CHANGE

GRADE_CHANGE_REASON_DESC

NO

NO GRADE CHANGE, STUDENT COURSE
GRADE_COMMENT Code valued for the grade comment added for this course when a grade was assigned. VARCHAR2(63)

STUDENT_COURSE_GRADE_CHANGE

GRADE_COMMENT

NO

NO GRADE CHANGE, STUDENT COURSE
GRADE_COMMENT_LD Long grade coded comment description. VARCHAR2(255)

STUDENT_COURSE_GRADE_CHANGE

GRADE_COMMENT_DESC

NO

NO GRADE CHANGE, STUDENT COURSE
GRADE_COMMENT_SD Short grade coded comment description. VARCHAR2(255)

STUDENT_COURSE_GRADE_CHANGE

GRADE_COMMENT_DESC

NO

NO GRADE CHANGE, STUDENT COURSE
SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)

ETL_GENERATED

NA

NO

NO GRADE CHANGE, STUDENT COURSE
SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

ETL_GENERATED

NA

NO

NO GRADE CHANGE, STUDENT COURSE


Ver: 9.0