Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Student Reporting View Reports

Banner Operational Data Store
Reporting View Target: STUDENT_COURSE_GRADE_CHANGE

Description Contains all details and history of the grade changes for the subject or course completed by the student. Data includes the grade change reason and date so that analytical and statistical reporting on grades can be done.
Key & Frequency One row per person per academic period per course reference number per final grade sequence number.
Recommended Search Columns PERSON_UID, ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER, FINAL_GRADE_SEQUENCE_NUMBER
GRADE_CHANGE_REASON
FINAL_GRADE
GRADE_COMMENT

Target Column Business Name Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Academic Period Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year. VARCHAR2(63)

SHRTCKG

SHRTCKG_TERM_CODE

ACADEMIC_PERIOD_DESC Academic Period Description Description of the academic period. VARCHAR2(255)

STVTERM

STVTERM_DESC

ACADEMIC_YEAR Academic Year Academic year associated with the academic period. VARCHAR2(63)

STVTERM

STVTERM_ACYR_CODE

ACADEMIC_YEAR_DESC Academic Year Description Description for this academic year. VARCHAR2(255)

STVACYR

STVACYR_DESC

ADMINISTRATIVE_GROUP Administrative Group Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

COURSE_IDENTIFICATION Course ID Course subject and course number combined. VARCHAR2(63)

CALCULATION

SHRTCKN_SUBJ_CODE||SHRTCKN_CRSE_NUMB

COURSE_NUMBER Course Number Course number associated with the subject for the course. VARCHAR2(63)

SHRTCKN

SHRTCKN_CRSE_NUMB

COURSE_REFERENCE_NUMBER Course Reference Number Computer assigned internal unique number for the schedule offering. VARCHAR2(63)

SHRTCKN

SHRTCKN_CRN

COURSE_SEQUENCE_NUMBER Course Sequence Number Sequence number used to associated the information about the unique course for the student. NUMBER

SHRTCKG

SHRTCKG_TCKN_SEQ_NO

CREDITS_ATTEMPTED Credits Attempted Credits attempted as defined by the grading rules of the institution. NUMBER

CALCULATION

SHRTCKG_CREDIT_HOURS*DECODE(SHRGRDE_ATTEMPTED_IND,'Y',1,0)

CREDITS_EARNED 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

CALCULATION

SHRTCKG_CREDIT_HOURS*DECODE(SHRGRDE_COMPLETED_IND,'Y',1,0)*DECODE(SHRTCKN_REPEAT_COURSE_IND,'A',0,'E',0,1)

CREDITS_FOR_GPA Credits For GPA - Grade Point Average or Average Credits used in the calculation of the average or GPA based on the rules of the institution. NUMBER

CALCULATION

SHRTCKG_CREDIT_HOURS*DECODE(SHRGRDE_GPA_IND,'Y',1,0)*DECODE(SHRTCKN_REPEAT_COURSE_IND,'E',0,1)

CREDITS_PASSED 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

CALCULATION

SHRTCKG_CREDIT_HOURS*DECODE(SHRGRDE_PASSED_IND,'Y',1,0)*DECODE(SHRTCKN_REPEAT_COURSE_IND,'A',0,'E',0,1)

FINAL_GRADE Final Grade Assigned student final grade. VARCHAR2(63)

SHRTCKG

SHRTCKG_GRDE_CODE_FINAL

FINAL_GRADE_CHANGE_USER Final Grade Change user Institutional Course Grade Change User. VARCHAR2(255)

SHRTCKG

SHRTCKG_FINAL_GRDE_CHG_USER

FINAL_GRADE_SEQUENCE_NUMBER Final Grade Sequence Number System assigned sequence number assigned as the grade for a course is changed. The highest number is the last grade change recorded and will display on the STUDENT_COURSE reporting view. NUMBER

SHRTCKG

SHRTCKG_SEQ_NO

GRADE_CHANGE_DATE Grade Change Date Date associated with this grade. DATE

SHRTCKG

SHRTCKG_FINAL_GRDE_CHG_DATE

GRADE_CHANGE_REASON Grade Change Reason Institution defined grade change reason associated with this grade for this course. VARCHAR2(63)

SHRTCKG

SHRTCKG_GCHG_CODE

GRADE_CHANGE_REASON_DESC Grade Change Reason Description Grade change reason description. VARCHAR2(255)

STVGCHG

STVGCHG_DESC

GRADE_COMMENT Grade Comment Value for the grade comment or result code added for this course. VARCHAR2(63)

SHRTCKG

SHRTCKG_GCMT_CODE

GRADE_COMMENT_DESC Grade Comment Description Grade comment descriptive text. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

GRADE_TYPE Grade Type Grade mode associated with this section or offering of the course. VARCHAR2(63)

SHRTCKG

SHRTCKG_GMOD_CODE

GRADE_TYPE_DESC Grade Type Description Grade type description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ID ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

SHRTCKG

SHRTCKG_INCOMPLETE_EXT_DATE

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NAME Name Combination of the person's last, first, and middle initial into one value. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PERSON_UID Person UID System generated unique internal identification number assigned to this person. NUMBER

SHRTCKG

SHRTCKG_PIDM

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

QUALITY_POINTS Quality Points Quality points associated with the grade. NUMBER

CALCULATION

SHRTCKG_CREDIT_HOURS*SHRGRDE_QUALITY_POINTS*DECODE(SHRGRDE_GPA_IND,'Y',1,0)*DECODE(SHRTCKN_REPEAT_COURSE_IND,'E',0,1)

SUBJECT Subject Identifies the main instructional subject area for this course. VARCHAR2(63)

SHRTCKN

SHRTCKN_SUBJ_CODE

SUBJECT_DESC Subject Description Description for the subject code. VARCHAR2(255)

STVSUBJ

STVSUBJ_DESC

SUB_ACADEMIC_PERIOD Sub Academic Period Identifies a session, portion or part of the academic period. VARCHAR2(63)

SHRTCKN

SHRTCKN_PTRM_CODE

SUB_ACADEMIC_PERIOD_DESC Sub Academic Period Description Description of the sub academic period. VARCHAR2(255)

STVPTRM

STVPTRM_DESC



Ver: 9.2