RETURN TO BANNER EDW META DATA REPORTS LIST
Grade Change Star  

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_GRADE_CHANGE

Description Grade Change fact table provides measures that may be used to compare and display history of grades and specific information related to that grade and the reasons for the change.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
ACADEMIC_TIME_KEY Key for the academic time dimension. NUMBER

ETL_GENERATED

NA

NO

NO GRADE CHANGE
COURSE_IDENTIFICATION Course subject and course number combined. VARCHAR2(63)

ETL_GENERATED

NA

NO

NO GRADE CHANGE
COURSE_REFERENCE_NUMBER_KEY Key for the course reference number dimension. NUMBER

ETL_GENERATED

NA

NO

NO GRADE CHANGE
CREDITS_ATTEMPTED Credits attempted as defined by the grading rules of the institution. NUMBER

STUDENT_COURSE_GRADE_CHANGE

CREDITS_ATTEMPTED

NO

NO GRADE CHANGE
CREDITS_EARNED Credits earned as defined by the grading rules of the institution. This number must be calculated by the system after the final grade is recorded for the student. NUMBER

STUDENT_COURSE_GRADE_CHANGE

CREDITS_EARNED

NO

NO GRADE CHANGE
CREDITS_FOR_GPA Credits used in the calculation of the average or GPA based on the rules of the institution. NUMBER

STUDENT_COURSE_GRADE_CHANGE

CREDITS_FOR_GPA

NO

NO GRADE CHANGE
CREDITS_PASSED Credits passed as defined by the grading rules of the institution. This number must be calculated by the system after the final grade is recorded for the student. NUMBER

STUDENT_COURSE_GRADE_CHANGE

CREDITS_PASSED

NO

NO GRADE CHANGE
DEMOGRAPHIC_KEY Key for the demographic dimension. NUMBER

ETL_GENERATED

NA

NO

NO GRADE CHANGE
FINAL_GRADE_IND Identifies this grade as the last or latest change to the final grade for the student course. NUMBER

ETL_GENERATED

NA

NO

NO GRADE CHANGE
GRADE Final grade assigned to the student for the work completed in this course section in this academic period. VARCHAR2(63)

STUDENT_COURSE_GRADE_CHANGE

FINAL_GRADE

NO

NO GRADE CHANGE
GRADE_CHANGE_DATE Date this grade change was recorded in the system. DATE

STUDENT_COURSE_GRADE_CHANGE

GRADE_CHANGE_DATE

NO

NO GRADE CHANGE
GRADE_CHANGE_GROUP_KEY Key for the grade change group dimension. NUMBER

ETL_GENERATED

NA

NO

NO GRADE CHANGE
GRADE_CHANGE_KEY Key for the grade change dimension. NUMBER

ETL_GENERATED

NA

NO

NO GRADE CHANGE
GRADE_SEQUENCE_NUMBER Sequence number used to associated the information about the unique course for the student. NUMBER

STUDENT_COURSE_GRADE_CHANGE

FINAL_GRADE_SEQUENCE_NUMBER

NO

NO GRADE CHANGE
INCOMPLETE_EXT_DATE Extension date associated with an incomplete grade to determine when the student must have completed any missing work for the course. DATE

STUDENT_COURSE_GRADE_CHANGE

INCOMPLETE_EXT_DATE

NO

NO GRADE CHANGE
MULTI_SOURCE_KEY Key for the multi source dimension. NUMBER

ETL_GENERATED

NA

NO

NO GRADE CHANGE
PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER

STUDENT_COURSE_GRADE_CHANGE

PERSON_UID

NO

NO GRADE CHANGE
QUALITY_POINTS Quality points associated with the grade. NUMBER

STUDENT_COURSE_GRADE_CHANGE

QUALITY_POINTS

NO

NO GRADE CHANGE
SUB_ACADEMIC_PERIOD_KEY Key for the sub academic dimension. NUMBER

ETL_GENERATED

NA

NO

NO GRADE CHANGE
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
SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

ETL_GENERATED

NA

NO

NO GRADE CHANGE


Ver: 9.0