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

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 has a course registration 'count in enrolled' set to Yes) 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 PERSON_UID
ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER
SUBJECT, COURSE_NUMBER
PERSON_UID, ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER
SUBJECT, COURSE_NUMBER, ACADEMIC_PERIOD
COURSE_IDENTIFICATION, ACADEMIC_PERIOD, PERSON_UID
ACADEMIC_PERIOD, PERSON_UID, COURSE_LEVEL, COURSE_REFERENCE_NUMBER
COURSE_COLLEGE, COURSE_DEPARTMENT, COURSE_IDENTIFICATION, ACADEMIC_PERIOD, PERSON_UID

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)

SFRSTCR

SFRSTCR_TERM_CODE

ACADEMIC_PERIOD_DESC Academic Period Description Academic period description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

STVTERM

STVTERM_ACYR_CODE

ACADEMIC_YEAR_DESC Academic Year Description Academic year description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SSBSECT

SSBSECT_ACCT_CODE

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

STVACCT

STVACCT_DESC

ACTUAL_ENROLLMENT 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 Administrative Group Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

BEGIN_TIME 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 Billing Units Specifies the billing units associated with this course. NUMBER

SFRSTCR

SFRSTCR_BILL_HR

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

SSRMEET

SSRMEET_BLDG_CODE

CENSUS_ENROLLMENT1 Census Enrollment 1 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 Census Enrollment 2 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 Census Enrollment Date 1 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 Census Enrollment Date 2 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 Course Billing Hold Identifies the number of billing units that are being held for potential reinstatement. NUMBER

SFRSTCR

SFRSTCR_BILL_HR_HOLD

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

SFRSTCR

SFRSTCR_CAMP_CODE

COURSE_CAMPUS_DESC Course Campus Description Institution campus description. VARCHAR2(255)

STVCAMP

STVCAMP_DESC

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

SCBCRSE

SSBOVRR

SCBCRSE_COLL_CODE

SSBOVRR_COLL_CODE

COURSE_COLLEGE_DESC Course College Description College description. VARCHAR2(255)

STVCOLL

STVCOLL_DESC

COURSE_CREDITS Course Credits Credits associated with this course. NUMBER

SFRSTCR

SFRSTCR_CREDIT_HR

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

SFRSTCR

SFRSTCR_CREDIT_HR_HOLD

COURSE_DEPARTMENT Course Department Department providing this instruction. VARCHAR2(63)

SCBCRSE

SSBOVRR

SCBCRSE_DEPT_CODE

SSBOVRR_DEPT_CODE

COURSE_DEPARTMENT_DESC Course Department Description Department providing this instruction. VARCHAR2(255)

STVDEPT

STVDEPT_DESC

COURSE_DIVISION Course Division Division providing this instruction. VARCHAR2(63)

SCBCRSE

SSBOVRR

SCBCRSE_DIVS_CODE

SSBOVRR_DIVS_CODE

COURSE_DIVISION_DESC Course Division Description Division description. VARCHAR2(255)

STVDIVS

STVDIVS_DESC

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

CALCULATION

CALCULATION

SHRTCKN_SUBJ_CODE||SHRTCKN_CRSE_NUMB

SSBSECT_SUBJ_CODE||SSBSECT_CRSE_NUMB

COURSE_LEVEL 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 Course level description. VARCHAR2(255)

FUNCTION

NA

GOKODSF.F_GET_DESC

NA

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

SCBCRSE

SCBCRSE_CRSE_NUMB

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

SFRSTCR

SFRSTCR_CRN

COURSE_REPORTING_CODE_1 Course Reporting Code 1 Course institutional reporting element 1 code. VARCHAR2(63)

SCBSUPP

SCBSUPP_CUDA_CODE

COURSE_REPORTING_CODE_2 Course Reporting Code 2 Course institutional reporting element 2 code. VARCHAR2(63)

SCBSUPP

SCBSUPP_CUDB_CODE

COURSE_REPORTING_CODE_3 Course Reporting Code 3 Course institutional reporting element 3 code. VARCHAR2(63)

SCBSUPP

SCBSUPP_CUDC_CODE

COURSE_REPORTING_CODE_4 Course Reporting Code 4 Course institutional reporting element 4 code. VARCHAR2(63)

SCBSUPP

SCBSUPP_CUDD_CODE

COURSE_REPORTING_CODE_5 Course Reporting Code 5 Course institutional reporting element 5 code. VARCHAR2(63)

SCBSUPP

SCBSUPP_CUDE_CODE

COURSE_REPORTING_CODE_6 Course Reporting Code 6 Course institutional reporting element 6 code. VARCHAR2(63)

SCBSUPP

SCBSUPP_CUDF_CODE

COURSE_TITLE_SHORT Course Title Short Short title for the course. VARCHAR2(63)

CALCULATION

NVL(SSBSECT_CRSE_TITLE,SCBCRSE_TITLE)

END_DATE 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 End Time Time the offering meeting ends. VARCHAR2(4)

SSRMEET

SSRMEET_END_TIME

EXEMPT_TUITION_SECTION 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 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 Faculty member staff type description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SHRTCKG

SHRTCKG_GRDE_CODE_FINAL

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

SPRIDEN

SPRIDEN_FIRST_NAME

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

SSRMEET

SSRMEET_FRI_DAY

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

SPRIDEN

SPRIDEN_ID

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

SSBSECT

SSBSECT_INSM_CODE

INSTRUCTION_METHOD_DESC Instruction Method Description Instructional method description. VARCHAR2(255)

GTVINSM

GTVINSM_DESC

INSTRUCTOR_COUNT Instructor Count Count of instructors assigned to the course. NUMBER

FUNCTION

MSKFUNC.F_COUNT_INSTRUCTOR

INSTRUCTOR_FIRST_NAME Instructor First Name Primary instructor first name. VARCHAR2(60)

SPRIDEN

SPRIDEN_FIRST_NAME

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

SPRIDEN

SPRIDEN_ID

INSTRUCTOR_LAST_NAME Instructor Last Name Primary instructor last name. VARCHAR2(60)

CALCULATION

NVL(SPRIDEN_LAST_NAME,'STAFF')

INSTRUCTOR_MIDDLE_NAME Instructor Middle Name Primary instructor middle name. VARCHAR2(63)

SPRIDEN

SPRIDEN_MI

INTEGRATION_PARTNER Integration Partner Institution defined integration code that identifies an external partner used for instruction of this schedule offering. VARCHAR2(63)

SSBSECT

SSBSECT_INTG_CDE

INTEGRATION_PARTNER_DESC Integration Partner Description Instruction integration partner description. VARCHAR2(255)

GORINTG

GORINTG_DESC

INTEGRATION_PARTNER_SYSTEM Integration Partner System Institution defined integration system code that identifies an external partner systen used for instruction of this schedule offering. VARCHAR2(63)

GORINTG

GORINTG_INTP_CODE

INTEGRATION_PARTNER_SYS_DESC Integration Partner System Description Instruction integration partner system description. VARCHAR2(255)

GORINTG

GTVINTP_DESC

LAB_CONTACT_HOURS Lab Contact Hours Maximum lab contact hours for schedule offering. NUMBER

CALCULATION

NVL(SSBSECT_LAB_HR,SCBCRSE_LAB_HR_HIGH)

LAST_NAME Last Name Last name. VARCHAR2(63)

SPRIDEN

SPRIDEN_LAST_NAME

LECTURE_CONTACT_HOURS Lecture Contact Hours Maximum lecture contact hours for schedule offering. NUMBER

CALCULATION

NVL(SSBSECT_LEC_HR,SCBCRSE_LEC_HR_HIGH)

MAXIMUM_ENROLLMENT Maximum Enrollment Sets the maximum enrollment for this offering. NUMBER

SSBSECT

SSBSECT_MAX_ENRL

MEETING_TIME_COUNT 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 Middle name. VARCHAR2(63)

SPRIDEN

SPRIDEN_MI

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

SSRMEET

SSRMEET_MON_DAY

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

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

NA

NA

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

SCBSUPP

SCBSUPP_OCCS_CODE

OCCUPATIONAL_COURSE_DESC Occupational Course Description Vocational or occupational indicator description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SSBSECT

SSBSECT_SEQ_NUMB

OTHER_CONTACT_HOURS Other Contact Hours Maximum other contact hours for schedule offering. NUMBER

CALCULATION

NVL(SSBSECT_OTH_HR,SCBCRSE_OTH_HR_HIGH)

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

SIRASGN

SIRASGN_PERCENT_SESS

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

SFRSTCR

SFRSTCR_PIDM

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

SIRASGN

SIRASGN_PRIMARY_IND

PROCESS_GROUP 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 Classification of Instructional Program (CIP) codes assigned to an area of study and used for governmental reporting. VARCHAR2(63)

NA

NA

PROGRAM_CLASSIFICATION_DESC Program Classification Description Program classification description. VARCHAR2(255)

STVCIPC

STVCIPC_DESC

REGISTER_CENSUS_DATE1_IND REGISTER_CENSUS_DATE1_IND Indicates a registration course status that identifies the person counts in the course section headcount was recorded prior to the census date. VARCHAR2(1)

SSBSECT

SSBSECT_CENSUS_ENRL

REGISTER_CENSUS_DATE2_IND REGISTER_CENSUS_DATE2_IND Indicates a registration course status that identifies the person counts in the course section headcount was recorded prior to the census date 2. VARCHAR2(1)

SSBSECT

SSBSECT_CENSUS_2_DATE

REGISTRATION_ERROR_FLAG Registration Error Indicator 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 Registration Sequence Number Sequence in which this registrant enrolled in this course. NUMBER

SFRSTCR

SFRSTCR_REG_SEQ

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

SFRSTCR

SFRSTCR_RSTS_CODE

REGISTRATION_STATUS_DATE Registration Status Date Latest change registration date for this course. DATE

SFRSTCR

SFRSTCR_RSTS_DATE

REGISTRATION_STATUS_DESC Registration Status Description Course registration status description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SFRSTCR

SFRSTCR_USER

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

SFRSTCR

SFRSTCR_REPT_OVER

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

SSRMEET

SSRMEET_ROOM_CODE

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

SSRMEET

SSRMEET_SAT_DAY

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

SSBSECT

SSBSECT_SCHD_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

SEATS_AVAILABLE 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 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 Special Approval Indicator Indicates special approval was required for this registration. VARCHAR2(1)

SFRSTCR

SFRSTCR_APPR_RECEIVED_IND

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

SFRAREG

SFRAREG_START_DATE

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

NA

NA

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

NA

NA

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

SCBCRSE

SCBCRSE_SUBJ_CODE

SUBJECT_DESC Subject Description Subject code description. VARCHAR2(255)

STVSUBJ

STVSUBJ_DESC

SUB_ACADEMIC_PERIOD 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 Sub academic period description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SSRMEET

SSRMEET_SUN_DAY

TAXONOMY_OF_PROGRAM 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 Taxonomy Of Program Description Government reporting code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SSRMEET

SSRMEET_THU_DAY

TOTAL_CONTACT_HOURS Total Contact Hours Maximum contact hours for schedule offering. NUMBER

CALCULATION

NVL(SSBSECT_CONT_HR,SCBCRSE_CONT_HR_HIGH)

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

SSRMEET

SSRMEET_TUE_DAY

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

SSRMEET

SSRMEET_SUN_DAY

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

SIRASGN

SIRASGN_WORKLOAD_ADJUST



Ver: 9.2