Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Student Composite View Reports

Banner Operational Data Store
Composite View Target: AS_STUDENT_COURSE_GRADE_CHG

Description Source composite view contains information about the grade or grades assigned to the student for this course.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
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(6)

SHRTCKG

SHRTCKG_TERM_CODE

NO

NO
ACADEMIC_PERIOD_DESC Description of the academic period. VARCHAR2(30)

STVTERM

STVTERM_DESC

NO

NO
ACADEMIC_YEAR Academic year associated with the academic period. VARCHAR2(4)

STVTERM

STVTERM_ACYR_CODE

NO

NO
ACADEMIC_YEAR_DESC Description for this academic year. VARCHAR2(30)

STVACYR

STVACYR_DESC

NO

NO
COURSE_IDENTIFICATION Course subject and course number combined. VARCHAR2(9)       NO
COURSE_NUMBER Course number associated with the subject for the course. VARCHAR2(5)

SHRTCKN

SHRTCKN_CRSE_NUMB

NO

NO
COURSE_REFERENCE_NUMBER Computer assigned internal unique number for the schedule offering. VARCHAR2(5)

SHRTCKN

SHRTCKN_CRN

NO

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

SHRTCKG

SHRTCKG_TCKN_SEQ_NO

NO

NO
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)

NO

NO
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)

NO

NO
CREDITS_FOR_GPA 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)

NO

NO
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)

NO

NO
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

NO

NO
DOMAIN_VALUE The institution value of the organization-oriented identifier for the record used to determine access authorization to this record. VARCHAR2(6)

NA

NA

NO

NO
FINAL_GRADE Assigned student final grade. VARCHAR2(6)

SHRTCKG

SHRTCKG_GRDE_CODE_FINAL

NO

NO
FINAL_GRADE_CHANGE_USER Institutional Course Grade Change User. User-id of user who posted the grade. VARCHAR2(255)

SHRTCKG

SHRTCKG_FINAL_GRDE_CHG_USER

NO

NO
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

NO

NO
GRADE_CHANGE_DATE Date associated with this grade. DATE

SHRTCKG

SHRTCKG_FINAL_GRDE_CHG_DATE

NO

NO
GRADE_CHANGE_REASON Institution defined grade change reason associated with this grade for this course. VARCHAR2(2)

SHRTCKG

SHRTCKG_GCHG_CODE

NO

NO
GRADE_CHANGE_REASON_DESC Grade change reason description. VARCHAR2(30)

STVGCHG

STVGCHG_DESC

NO

NO
GRADE_COMMENT Value for the grade comment or result code added for this course. VARCHAR2(7)

SHRTCKG

SHRTCKG_GCMT_CODE

NO

NO
GRADE_COMMENT_DESC Grade comment descriptive text. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

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

SHRTCKG

SHRTCKG_GMOD_CODE

NO

NO
GRADE_TYPE_DESC Grade type description. VARCHAR2(30)

STVGMOD

STVGMOD_DESC

NO

NO
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

SHRTCKG

SHRTCKG_INCOMPLETE_EXT_DATE

NO

NO
MIF_DESC The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(30)

NA

NA

NO

NO
MIF_VALUE The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(6)

NA

NA

NO

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

SHRTCKG

SHRTCKG_PIDM

NO

NO
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)

NO

NO
SUBJECT Identifies the main instructional subject area for this course. VARCHAR2(4)

SHRTCKN

SHRTCKN_SUBJ_CODE

NO

NO
SUBJECT_DESC Description for the subject code. VARCHAR2(30)

STVSUBJ

STVSUBJ_DESC

NO

NO
SUB_ACADEMIC_PERIOD Identifies a session, portion or part of the academic period. VARCHAR2(3)

SHRTCKN

SHRTCKN_PTRM_CODE

NO

NO
SUB_ACADEMIC_PERIOD_DESC Description of the sub academic period. VARCHAR2(30)

STVPTRM

STVPTRM_DESC

NO

NO
ZONE_VALUE The institution value of the process-oriented identifier for the record used to determine access authorization to this record. VARCHAR2(6)

NA

NA

NO

NO


Ver: