Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Student Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: STUDENT_COURSE

Description Contains detail data for student courses recorded in the system. Courses taken by the studen maybe registered (in progress course), graded (institutional history), and transfered (transfer credit granted) courses. This reporting view shows all courses associated with the student in a single reporting view. Indicators permit the report user to identify groupings of courses for selected reporting needs.
Key & Frequency One row per person per academic period per course reference number.
Recommended Search Columns PERSON_UID, ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER, IN_PROGRESS_COURSE_IND
PERSON_UID, TRANSFER_COURSE_IND
PERSON_UID, ACADEMIC_PERIOD, INSTITUTION_COURSE_IND
ACADEMIC_PERIOD
PERSON_UID, ACADEMIC_PERIOD, COURSE_LEVEL
PERSON_UID, COURSE_IDENTIFICATION
PERSON_UID, ACADEMIC_PERIOD, COURSE_IDENTIFICATION
COURSE_IDENTIFICATION, ACADEMIC_PERIOD
GRADE_VALUE, ACADEMIC_PERIOD

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Academic period or time frame associated with this course record. VARCHAR2(63)

SFRSTCR

SHRTCKN

SHRTRCE

SFRSTCR_TERM_CODE

SHRTCKN_TERM_CODE

SHRTRCE_TERM_CODE_EFF

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(255)

STVTERM

STVTERM_DESC

ACADEMIC_YEAR Academic year associated with the academic period on this record. VARCHAR2(63)

FUNCTION

GOKODSF.F_GET_DESC

ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(255)

STVACYR

STVACYR_DESC

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

NA

NA

CAMPUS Campus the student attended this schedule offering or section. VARCHAR2(63)

SHRTCKN

SSBSECT

SHRTCKN_CAMP_CODE

SSBSECT_CAMP_CODE

CAMPUS_DESC Institution campus name. VARCHAR2(255)

STVCAMP

STVCAMP_DESC

COLLEGE College, faculty or school to which the course instructional responsibility is associated. VARCHAR2(63)

SCBCRSE

SHRTCKN

SSBOVRR

SCBCRSE_COLL_CODE

SHRTCKN_COLL_CODE

SSBOVRR_COLL_CODE

COLLEGE_DESC College, faculty or school name. VARCHAR2(255)

STVCOLL

STVCOLL_DESC

COUNT_IN_GPA_IND Indicates whether this course should be used in the calculation of the GPA. VARCHAR2(1)

SHRGRDE

SHRTRCE

SHRGRDE_GPA_IND

SHRTRCE_COUNT_IN_GPA_IND

COURSE_ATTRIBUTES_COUNT Number of course attributes associated with this course for this student. NUMBER

FUNCTION

MSKFUNC.F_COUNT_COURSE_ATTRIBUTES

MSKFUNC.F_COUNT_STUDENT_COURSE_ATTR

COURSE_BILLING_CREDITS Billing units associated with this section or schedule offering. NUMBER

SFRSTCR

SFRSTCR_BILL_HR

COURSE_BILLING_HOLD Identifies the number of billing units that are being held for potential reinstatement. NUMBER

SFRSTCR

SFRSTCR_BILL_HR_HOLD

COURSE_CREDITS Credits associated with this course. NUMBER

SFRSTCR

SHRTCKG

SHRTRCE

SFRSTCR_CREDIT_HR

SHRTCKG_CREDIT_HOURS

SHRTRCE_CREDIT_HOURS

COURSE_CREDITS_HOLD Identifies the number of credits that are being held for potential reinstatement. NUMBER

SFRSTCR

SFRSTCR_BILL_HR_HOLD

COURSE_IDENTIFICATION Combined subject code and course number that identifies the instructional content of this course. VARCHAR2(63)

CALCULATION

SFRSTCR_SUBJ_CODE||SFRSTCR_CRSE_NUMB

SHRTCKN_SUBJ_CODE||SHRTCKN_CRSE_NUMB

SHRTRCE_SUBJ_CODE||SHRTRCE_CRSE_NUMB

COURSE_LEVEL Level of academic study satisfied by this course. For example, undergraduate, graduate, credit, etc. VARCHAR2(63)

SFRSTCR

SHRTATC

SHRTCKL

SHRTRCE

SFRSTCR_LEVL_CODE

SHRTATC_TLVL_CODE

SHRTCKL_LEVL_CODE

SHRTRCE_LEVL_CODE

COURSE_LEVEL_DESC Course level description. VARCHAR2(255)

STVLEVL

STVLEVL_DESC

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

SHRTCKN

SHRTRCE

SSBSECT

SHRTCKN_CRSE_NUMB

SHRTRCE_CRSE_NUMB

SSBSECT_CRSE_NUMB

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

CALCULATION

SFRSTCR

SHRTCKN

SHRTRCE_TRIT_SEQ_NO||TO_CHAR(SHRTRCE_TRAM_SEQ_NO,'FM09')||TO_CHAR(NVL(SHRTRCE_TRCR_SEQ_NO,0),'FM009')||TO_CHAR(SHRTRCE_SEQ_NO,'FM009')

SFRSTCR_CRN

SHRTCKN_CRN

COURSE_SECTION_NUMBER Sequence number used to associated the information about the unique course for the student. VARCHAR2(63)

SHRTCKN

SHRTRCE

SSBSECT

SHRTCKN_SEQ_NUMB

SHRTRCE_SEQ_NO

SSBSECT_SEQ_NUMB

COURSE_TITLE_LONG Long title for the course. VARCHAR2(255)

FUNCTION

SHRTCKN

SSRSYLN

SOKODSF.F_GET_CRSE_LONG_TITLE

SHRTCKN_LONG_COURSE_TITLE

SSRSYLN_LONG_COURSE_TITLE

COURSE_TITLE_SHORT Short title for the course. VARCHAR2(63)

SHRTCKN

SHRTRCE

SSBSECT

SHRTCKN_CRSE_TITLE

SHRTRCE_CRSE_TITLE

SSBSECT_CRSE_TITLE

COURSE_VERSION Course version number. VARCHAR2(255)

NA

NA

CREDITS_ATTEMPTED Credits attempted as defined by the grading rules of the institution. In-progress or transfer courses may be defined not to add to the credits attempted. NUMBER

CALCULATION

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

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

DEPARTMENT Department responsible for the instructional delivery of this offering. VARCHAR2(63)

SCBCRSE

SHRTCKN

SSBOVRR

SCBCRSE_DEPT_CODE

SHRTCKN_DEPT_CODE

SSBOVRR_DEPT_CODE

DEPARTMENT_DESC Department name. VARCHAR2(255)

STVDEPT

STVDEPT_DESC

DIVISION Division responsible for the instructional delivery of this course or section. VARCHAR2(255)

SCBCRSE

SHRTCKN

SSBOVRR

SCBCRSE_DIVS_CODE

SHRTCKN_DIVS_CODE

SSBOVRR_DIVS_CODE

DIVISION_DESC Name of the division. VARCHAR2(255)

STVDIVS

STVDIVS_DESC

EFF_ACADEMIC_PERIOD_OF_GRADE Earliest academic period for which grade is used. VARCHAR2(63)

SHRGRDE

SHRGRDE_TERM_CODE_EFFECTIVE

END_DATE Date the student completes the coursework in the section. This is either recorded for the individual student in the course or taken from the overall section end date. DATE

FUNCTION

SFRAREG

SSBSECT

SOKODSF.F_GET_COURSE_DATES

SFRAREG_COMPLETION_DATE

SSBSECT_PTRM_END_DATE

EXTENSIONS Number of extensions granted for the student to complete the required work for this section. NUMBER

FUNCTION

SFRAREG

SOKODSF.F_GET_COURSE_EXTENSIONS

SFRAREG_EXTENSION_NUMBER

FINALIZED_COMPLETION_DATE Date a student completed their study for this subject or course. This might be the final completion date for an open learning course or it might be the end date from the sub academic period end date associated with a section. DATE

FUNCTION

SOKODSF.F_GET_COURSE_DATES

FINAL_GRADE Final grade earned by the student for this course. VARCHAR2(63)

SFRSTCR

SHRTCKG

SHRTRCE

SFRSTCR_GRDE_CODE

SHRTCKG_GRDE_CODE_FINAL

SHRTRCE_GRDE_CODE

FINAL_GRADE_DATE Date associated with this grade. DATE

SFRSTCR

SHRTCKG

SFRSTCR_GRDE_DATE

SHRTCKG_FINAL_GRDE_CHG_DATE

FINAL_GRADE_ROLL_IND Indicates whether the final grade has been rolled to the history tables where applicable. VARCHAR2(1)

CALCULATION

DECODE(SFRSTCR_GRDE_DATE,NULL,'N','Y')

GRADABLE_IND Indicates whether the course can be graded. VARCHAR2(1)

SSBSECT

SSBSECT_GRADABLE_IND

GRADE_CHANGE_COUNT Number of grade changes recorded for this student for this course. NUMBER

FUNCTION

MSKFUNC.F_COUNT_GRADE_CHANGE

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. VARCHAR2(255)

STVGCHG

STVGCHG_DESC

GRADE_TYPE Grade mode associated with this CRN. VARCHAR2(63)

SFRSTCR

SHRTCKG

SFRSTCR_GMOD_CODE

SHRTCKG_GMOD_CODE

GRADE_TYPE_DESC Grading mode (e.g., pass/fail, audit, normal grading mode) associated with the grading mode code. VARCHAR2(255)

STVGMOD

STVGMOD_DESC

GRADE_VALUE Numeric value assigned to a grade symbol to be used to measure course performance statistics. This willl only be present if a final grade has been recorded for either in progress or grades rolled to history for the student course. NUMBER

SHRGRDE

SHRGRDE_NUMERIC_VALUE

HOURS_ATTENDED Number of hours the student attended this class. NUMBER

SFRSTCR

SFRSTCR_ATTEND_HR

ID Person's identification number used to access the records associated with the person. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

INCOMPLETE_EXT_DATE Specifies the latest date the student has to complete any missing course work before they are assigned an incomplete grade for the course. DATE

SHRTCKG

SHRTCKG_INCOMPLETE_EXT_DATE

INSTITUTION_COURSE_IND Indicates whether the subject or course was taken at this institution. VARCHAR2(1)

CALCULATION

CONSTANT

DECODE(SFRSTCR_PIDM,NULL,'Y','N')

'N'

'Y'

INSTRUCTION_METHOD Instructional method used for the section. VARCHAR2(63)

STVSCHD

STVSCHD_INSM_CODE

INSTRUCTION_METHOD_DESC Instructional method description associated with the course. VARCHAR2(255)

GTVINSM

GTVINSM_DESC

IN_PROGRESS_COURSE_IND Indicates whether the course is in progress and not yet graded. VARCHAR2(1)

CALCULATION

CONSTANT

DECODE(SFRSTCR_PIDM,NULL,'N','Y')

'N'

LAST_ATTEND_DATE Identifies the date on which the instruction ended. DATE

SFRSTCR

SFRSTCR_LAST_ATTEND

MID_TERM_GRADE Mid-term grade code associated with this CRN. VARCHAR2(63)

SFRSTCR

SFRSTCR_GRDE_CODE_MID

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

NA

NA

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

NA

NA

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

SFRSTCR

SFRSTCR_PIDM

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

REGISTRATION_ERROR_FLAG Indicates an error is associated with this section registration. VARCHAR2(1)

SFRSTCR

SFRSTCR_ERROR_FLAG

REGISTRATION_SEQUENCE_NUMBER Sequence number system assigned to the student registration in the section. NUMBER

SFRSTCR

SHRTCKN

SFRSTCR_REG_SEQ

SHRTCKN_REG_SEQ

REGISTRATION_STATUS Course registration status associated with this section. VARCHAR2(63)

SFRSTCR

SFRSTCR_RSTS_CODE

REGISTRATION_STATUS_DATE Date associated with the course registration status of this section. DATE

SFRSTCR

SFRSTCR_RSTS_DATE

REGISTRATION_STATUS_DESC Course registration status description. VARCHAR2(255)

STVRSTS

STVRSTS_DESC

REGISTRATION_USER_ID Person user identification number who processed the registration request for this section. VARCHAR2(63)

SFRSTCR

SFRSTCR_USER

REPEAT_COURSE_IND Identifies this course appears in more than one academic period for the student. Valid values in this data include 'E' exclude in any calculations, 'I' include in all calculations, or 'A' average in all calculations. VARCHAR2(1)

SHRTCKN

SHRTCKN_REPEAT_COURSE_IND

SCHEDULE_TYPE Instructional method or delivery type associated with the course. VARCHAR2(63)

SHRTCKN

SSBSECT

SHRTCKN_SCHD_CODE

SSBSECT_SCHD_CODE

SCHEDULE_TYPE_DESC Schedule type description. VARCHAR2(255)

STVSCHD

STVSCHD_DESC

SECTION_ADD_DATE Date the student registered in this section. DATE

SFRSTCR

SFRSTCR_ADD_DATE

SPECIAL_APPROVAL_IND Indicates whether special approval was received to register in this section. VARCHAR2(1)

SFRSTCR

SFRSTCR_APPR_RECEIVED_IND

START_DATE Date the instruction for this course began for this student. This is either recorded for the individual student in the course or taken from the overall section begin date. DATE

FUNCTION

SFRAREG

SOKODSF.F_GET_COURSE_DATES

SFRAREG_START_DATE

SUBJECT Main instructional subject area for this course. VARCHAR2(63)

SHRTCKN

SHRTRCE

SSBSECT

SHRTCKN_SUBJ_CODE

SHRTRCE_SUBJ_CODE

SSBSECT_SUBJ_CODE

SUBJECT_DESC Subject code description. VARCHAR2(255)

STVSUBJ

STVSUBJ_DESC

SUB_ACADEMIC_PERIOD A session, portion or part of the academic period. VARCHAR2(63)

SFRSTCR

SHRTCKN

SFRSTCR_PTRM_CODE

SHRTCKN_PTRM_CODE

SUB_ACADEMIC_PERIOD_DESC Sub academic period description. VARCHAR2(255)

STVPTRM

STVPTRM_DESC

TRADITIONAL_IND Indicates whether this grade symbol is considered a traditional type of grade. VARCHAR2(1)

SHRGRDE

SHRGRDE_TRADITIONAL_IND

TRANSFER_COURSE_IND Indicates whether this course was taken at and transferred from another post secondary institution. VARCHAR2(1)

CALCULATION

DECODE(SHRTRCE_PIDM,NULL,'N','Y')

TRANSFER_COURSE_INSTITUTION Identifies the post secondary institution where the transfer course was taken. VARCHAR2(255)

SHRTRIT

SHRTRIT_SBGI_CODE

TRANSFER_COURSE_INST_DESC Name of the post secondary transfer institution. VARCHAR2(255)

STVSBGI

STVSBGI_DESC



Ver: 8.0