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

SGHE Banner Operational Data Store
Reporting View Target: GOVERNMENT_COURSE

Description Contains common data on course registration used for government reporting. Details are included for the courses (subjects) that are registered or in progress (where the course is count in enrolled and not be deducted from the counts) for the academic period reported. It may be joined with other reporting views required for external or internal reporting requirements.
Key & Frequency One row per person per academic period per course reference number.
Recommended Search Columns ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER
PERSON_UID
PERSON_UID, ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER
PERSON_UID, ACADEMIC_PERIOD, COURSE_LEVEL
PERSON_UID, COURSE_IDENTIFICATION
PERSON_UID, ACADEMIC_PERIOD, COURSE_IDENTIFICATION
PERSON_UID, COURSE_COLLEGE, COURSE_DEPARTMENT
COURSE_IDENTIFICATION, ACADEMIC_PERIOD
COURSE_COLLEGE, COURSE_DEPARTMENT, COURSE_IDENTIFICATION, ACADEMIC_PERIOD
COURSE_DEPARTMENT, ACADEMIC_PERIOD
SUBJECT, COURSE_NUMBER

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Academic period or time frame this institution course was taken by the student. VARCHAR2(63)

SFRSTCR

SFRSTCR_TERM_CODE

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

STVTERM

STVTERM_ACYR_CODE

ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ACCOUNTING_METHOD Accounting method used for tracking attendance either weekly or daily. VARCHAR2(63)

SSBSECT

SSBSECT_ACCT_CODE

ACCOUNTING_METHOD_DESC Accounting method description for this course. VARCHAR2(255)

STVACCT

STVACCT_DESC

ACTUAL_ENROLLMENT Total number of students enrolled in this schedule offering. The students counting in the actual enrollment have a course status defined to count as enrolled. NUMBER

SSBSECT

SSBSECT_ENRL

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

NA

NA

BEGIN_TIME Begin time of the section or schedule offering. It is in the format HHMM using military time. VARCHAR2(4)

SSRMEET

SSRMEET_BEGIN_TIME

BILLING_UNITS Specifies the billing units associated with this course. NUMBER

SFRSTCR

SFRSTCR_BILL_HR

BUILDING Building code for the room assignment. VARCHAR2(63)

SSRMEET

SSRMEET_BLDG_CODE

CENSUS_ENROLLMENT1 Total of students registered and counted in enrollment for the section or schedule offering through the defined census date. NUMBER

SSBSECT

SSBSECT_CENSUS_ENRL

CENSUS_ENROLLMENT2 Total of students registered and counted in enrollment for the section or schedule offering through the second defined census date. NUMBER

SSBSECT

SSBSECT_CENSUS_2_ENRL

CENSUS_ENROLLMENT_DATE1 First date used for official enrollment reporting in a time frame. All student registration through this date is counted in the census one enrollment count. DATE

SSBSECT

SSBSECT_CENSUS_ENRL_DATE

CENSUS_ENROLLMENT_DATE2 Second date used for official enrollment reporting in a time frame. All student registration through this date is counted in the census two enrollment count. DATE

SSBSECT

SSBSECT_CENSUS_2_DATE

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

SFRSTCR

SFRSTCR_BILL_HR_HOLD

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

SFRSTCR

SFRSTCR_CAMP_CODE

COURSE_CAMPUS_DESC Institution campus description. VARCHAR2(255)

STVCAMP

STVCAMP_DESC

COURSE_COLLEGE College, faculty or school provide this section instruction. VARCHAR2(63)

SCBCRSE

SSBOVRR

SCBCRSE_COLL_CODE

SSBOVRR_COLL_CODE

COURSE_COLLEGE_DESC College description. VARCHAR2(255)

STVCOLL

STVCOLL_DESC

COURSE_CREDITS Credits associated with this course. NUMBER

SFRSTCR

SFRSTCR_CREDIT_HR

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

SFRSTCR

SFRSTCR_CREDIT_HR_HOLD

COURSE_DEPARTMENT Department providing this instruction. VARCHAR2(63)

SCBCRSE

SSBOVRR

SCBCRSE_DEPT_CODE

SSBOVRR_DEPT_CODE

COURSE_DEPARTMENT_DESC Department providing this instruction. VARCHAR2(255)

STVDEPT

STVDEPT_DESC

COURSE_DIVISION Division providing this instruction. VARCHAR2(63)

SCBCRSE

SSBOVRR

SCBCRSE_DIVS_CODE

SSBOVRR_DIVS_CODE

COURSE_DIVISION_DESC Division description. VARCHAR2(255)

STVDIVS

STVDIVS_DESC

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

CALCULATION

SCBCRSE_SUBJ_CODE||SCBCRSE_CRSE_NUMB

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

NA

SFRSTCR

NA

SFRSTCR_LEVL_CODE

COURSE_LEVEL_DESC Course level description. VARCHAR2(255)

FUNCTION

NA

GOKODSF.F_GET_DESC

NA

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

SCBCRSE

SCBCRSE_CRSE_NUMB

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

SFRSTCR

SFRSTCR_CRN

COURSE_REPORTING_CODE_1 Course institutional reporting element 1 code. VARCHAR2(255)

SCBSUPP

SCBSUPP_CUDA_CODE

COURSE_REPORTING_CODE_2 Course institutional reporting element 2 code. VARCHAR2(255)

SCBSUPP

SCBSUPP_CUDB_CODE

COURSE_REPORTING_CODE_3 Course institutional reporting element 3 code. VARCHAR2(255)

SCBSUPP

SCBSUPP_CUDC_CODE

COURSE_REPORTING_CODE_4 Course institutional reporting element 4 code. VARCHAR2(255)

SCBSUPP

SCBSUPP_CUDD_CODE

COURSE_REPORTING_CODE_5 Course institutional reporting element 5 code. VARCHAR2(255)

SCBSUPP

SCBSUPP_CUDE_CODE

COURSE_REPORTING_CODE_6 Course institutional reporting element 6 code. VARCHAR2(255)

SCBSUPP

SCBSUPP_CUDF_CODE

COURSE_TITLE_SHORT Short title for the course. VARCHAR2(63)

CALCULATION

NVL(SSBSECT_CRSE_TITLE,SCBCRSE_TITLE)

END_DATE Date on which the instruction ended. It is either stored specifically for the open learning student or taken from the end date on the offering. DATE

SFRAREG

SFRAREG_COMPLETION_DATE

END_TIME Time the offering meeting ends. VARCHAR2(4)

SSRMEET

SSRMEET_END_TIME

EXEMPT_TUITION_SECTION Specifies this section is exempt from the assessment of tuition and fee rules and only incurs any section fee charges. VARCHAR2(63)

SSBSECT

SSBSECT_TUIW_IND

FACULTY_MEMBER_STAFF_TYPE Staff type assigned to the faculty or academic staff member. Included type may be full time, part time, continuing education, etc. VARCHAR2(63)

SIBINST

SIBINST_FSTP_CODE

FACULTY_MEMBER_STAFF_TYPE_DESC Faculty member staff type description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SHRTCKG

SHRTCKG_GRDE_CODE_FINAL

FIRST_NAME Person's first or given name. VARCHAR2(63)

SPRIDEN

SPRIDEN_FIRST_NAME

FRIDAY_IND Indicates whether the section meets on Friday. VARCHAR2(1)

SSRMEET

SSRMEET_FRI_DAY

ID ID number given to the student to track their records at the institution. VARCHAR2(63)

SPRIDEN

SPRIDEN_ID

INSTRUCTION_METHOD Method of instruction. Traditional classroom, internet, correspondence, etc. VARCHAR2(63)

SSBSECT

SSBSECT_INSM_CODE

INSTRUCTION_METHOD_DESC Instructional method description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

INSTRUCTOR_COUNT Count of instructors assigned to the course. NUMBER

FUNCTION

MSKFUNC.F_COUNT_INSTRUCTOR

INSTRUCTOR_FIRST_NAME Primary instructor first name. VARCHAR2(60)

SPRIDEN

SPRIDEN_FIRST_NAME

INSTRUCTOR_ID Instructor ID for the academic staff assigned as the primary instructor. VARCHAR2(63)

SPRIDEN

SPRIDEN_ID

INSTRUCTOR_LAST_NAME Primary instructor last name. VARCHAR2(60)

CALCULATION

NVL(SPRIDEN_LAST_NAME,'STAFF')

INSTRUCTOR_MIDDLE_NAME Primary instructor middle name. VARCHAR2(63)

SPRIDEN

SPRIDEN_MI

LAB_CONTACT_HOURS Maximum lab contact hours for schedule offering. NUMBER

CALCULATION

NVL(SSBSECT_LAB_HR,SCBCRSE_LAB_HR_HIGH)

LAST_NAME Last name. VARCHAR2(63)

SPRIDEN

SPRIDEN_LAST_NAME

LECTURE_CONTACT_HOURS Maximum lecture contact hours for schedule offering. NUMBER

CALCULATION

NVL(SSBSECT_LEC_HR,SCBCRSE_LEC_HR_HIGH)

MAXIMUM_ENROLLMENT Sets the maximum enrollment for this offering. NUMBER

SSBSECT

SSBSECT_MAX_ENRL

MEETING_TIME_COUNT Count of meeting times assigned to the course but not reflected in this row. NUMBER

FUNCTION

MSKFUNC.F_COUNT_MEETING_TIME

MIDDLE_NAME Middle name. VARCHAR2(63)

SPRIDEN

SPRIDEN_MI

MONDAY_IND Indicates whether the section meets on Monday. VARCHAR2(1)

SSRMEET

SSRMEET_MON_DAY

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

NON_TRADITIONAL_COURSE Non-traditional course as indicated by the institution. VARCHAR2(1)

NA

NA

OCCUPATIONAL_COURSE Indicates whether this course is an occupational or vocational course for reporting purposes. VARCHAR2(63)

SCBSUPP

SCBSUPP_OCCS_CODE

OCCUPATIONAL_COURSE_DESC Vocational or occupational indicator description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

OFFERING_NUMBER Identifies a particular offering within the course identification. VARCHAR2(63)

SSBSECT

SSBSECT_SEQ_NUMB

OTHER_CONTACT_HOURS Maximum other contact hours for schedule offering. NUMBER

CALCULATION

NVL(SSBSECT_OTH_HR,SCBCRSE_OTH_HR_HIGH)

PERCENT_RESPONSIBILITY Schedule offering session percent of responsibility for the faculty member's instructional assignment. NUMBER

SIRASGN

SIRASGN_PERCENT_SESS

PERSON_UID Internally generated by the system to uniquely identify the person or entity. NUMBER

SFRSTCR

SFRSTCR_PIDM

PRIMARY_IND Indicates Y if the instructor is the primary or N if not. VARCHAR2(1)

SIRASGN

SIRASGN_PRIMARY_IND

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

NA

NA

PROGRAM_CLASSIFICATION Program Classification associated with the major subject area of study for this course. Classification of Institutional Programs (CIP) codes used for reporting outcomes to the federal government. VARCHAR2(63)

NA

NA

PROGRAM_CLASSIFICATION_DESC Program classification description. VARCHAR2(255)

STVCIPC

STVCIPC_DESC

REGISTRATION_ERROR_FLAG Identifies an error associated with the registration of this course section or offering. Values include F=Fatal, D=Do not count in enrollment, L=Waitlisted, O=Override. VARCHAR2(1)

SFRSTCR

SFRSTCR_ERROR_FLAG

REGISTRATION_SEQUENCE_NUMBER Sequence in which this registrant enrolled in this course. NUMBER

SFRSTCR

SFRSTCR_REG_SEQ

REGISTRATION_STATUS Identifies the course registration status associated for this course. VARCHAR2(63)

SFRSTCR

SFRSTCR_RSTS_CODE

REGISTRATION_STATUS_DATE Latest change registration date for this course. DATE

SFRSTCR

SFRSTCR_RSTS_DATE

REGISTRATION_STATUS_DESC Course registration status description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

REGISTRATION_USER_ID User who entered the course registration. VARCHAR2(63)

SFRSTCR

SFRSTCR_USER

REPEAT_COURSE_IND Identifies this course is being taken again by this student. VARCHAR2(1)

SFRSTCR

SFRSTCR_REPT_OVER

ROOM Room where the offering meeting is scheduled. VARCHAR2(10)

SSRMEET

SSRMEET_ROOM_CODE

SATURDAY_IND Indicates whether the section meets on Saturday. VARCHAR2(1)

SSRMEET

SSRMEET_SAT_DAY

SCHEDULE Instructional delivery for this course. This could be lecture, lab, internet, etc. VARCHAR2(63)

SSBSECT

SSBSECT_SCHD_CODE

SCHEDULE_TYPE_DESC Description for the method in which the course content is delivered. For example, lecture, lab, internet, etc. VARCHAR2(63)

FUNCTION

GOKODSF.F_GET_DESC

SEATS_AVAILABLE System maintained running total of remaining available seats in the section by subtracting the Actual enrollment field from the Maximum enrollment field defined for this section. NUMBER

SSBSECT

SSBSECT_ENRL

SECTION_ADD_DATE Original registration date for this course regardless of the last change in registration status date. DATE

SFRSTCR

SFRSTCR_ADD_DATE

SPECIAL_APPROVAL_IND Indicates special approval was required for this registration. VARCHAR2(1)

SFRSTCR

SFRSTCR_APPR_RECEIVED_IND

START_DATE Date the instruction for this course began for this student. DATE

SFRAREG

SFRAREG_START_DATE

STUDENT_MEETING_TIME Student's normal attendance time. May be either day, evening, weekend, etc. VARCHAR2(63)

NA

NA

STUDENT_MEETING_TIME_DESC Student's normal attendance time. May be either day, evening, weekend, etc. VARCHAR2(255)

NA

NA

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

SCBCRSE

SCBCRSE_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

SFRSTCR_PTRM_CODE

SUB_ACADEMIC_PERIOD_DESC Sub academic period description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SUNDAY_IND Indicates whether the section meets on Sunday. VARCHAR2(1)

SSRMEET

SSRMEET_SUN_DAY

TAXONOMY_OF_PROGRAM Government reporting code typically used for reporting of vocational technical courses or subjects. VARCHAR2(63)

SCBSUPP

SSBOVRR

SCBSUPP_TOPS_CODE

SSBOVRR_TOPS_CODE

TAXONOMY_OF_PROGRAM_DESC Government reporting code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

THURSDAY_IND Indicates whether the section meets on Thursday. VARCHAR2(1)

SSRMEET

SSRMEET_THU_DAY

TOTAL_CONTACT_HOURS Maximum contact hours for schedule offering. NUMBER

CALCULATION

NVL(SSBSECT_CONT_HR,SCBCRSE_CONT_HR_HIGH)

TUESDAY_IND Indicates whether the section meets on Tuesday. VARCHAR2(1)

SSRMEET

SSRMEET_TUE_DAY

WEDNESDAY_IND Indicates whether the section meets on Wednesday. VARCHAR2(1)

SSRMEET

SSRMEET_SUN_DAY

WORKLOAD_ADJUST Adjusted workload recorded for the instructional assignments of this faculty member. NUMBER

SIRASGN

SIRASGN_WORKLOAD_ADJUST



Ver: 8.0