Data Element Definition Description Codes Data Type MSU Source
COURSE_CAMPUS Location of course Indicates where the course is taught.

Main campus indicates the MUS campus offering the course.

Student Location indicates where the student takes the course - either one of the MUS campuses or off campus taking distance-delivered courses.

Delivery Mode indicates how instruction is delivered to the student.

3 characters VARCHAR2(3) Programmed
TERM Current term Year and term during which the course is offered. 6 characters:
4-digit year, plus
00-19=Winter
20-39=Spring
40-69=Summer
70-99=Fall
VARCHAR2(6) ssbsect_term_code
EVENT Data extract type Indicates whether data extract is current (previous day), 15th day, or end of term. 15 characters:
Term+Current
Term+15th
Term+EOT
VARCHAR2(15) Programmed
CRN Course registration number Banner-generated number for a course section. 5 characters VARCHAR2(5) ssbsect_crn
COURSE_LEVL Level of the course The level of credit at which the course is offered.  Course level is based on course number, where lower division courses are numbered 000-299, upper division courses 300-499, and graduate courses 500 and above. LD=Lower Division
UD=Upper Division
GR=Graduate
VARCHAR2(2) Calculated from ssbsect_crse_numb where
LD=000-299
UD=300-499
GR=500-699
COLLEGE Code for course college Code for college offering the course. 2 characters; see stvcoll for each campus VARCHAR2(2) scbcrse_coll_code
DEPT Code for course department Code for department offering the course. 4 characters; see stvdept for each campus VARCHAR2(4) scbcrse_dept_code
SUBJ_CODE Subject code Subject area code for the course--e.g., BIOL indicates a biology course on some campuses. 4 characters; see stvsubj for each campus VARCHAR2(4) ssbsect_subj_code
COURSE_NUMBER Course number Course number--e.g., 101. Varies by campus; up to five digits and/or characters VARCHAR2(5) ssbsect_crse_numb
SECTION_NUMBER Section number Sequence number of the section of the course. Varies by campus; up to three digits and/or characters VARCHAR2(3) ssbsect_seq_numb
SCHD_CODE Code for scheduled instruction mode Code for scheduled mode of instruction for section. 1 character; see stvschd VARCHAR2(1) ssbsect_schd_code
SCHD_DESC Scheduled mode of instruction Description of scheduled mode of instruction. 30 characters VARCHAR2(30) stvschd_desc
COURSE_TITLE Course title Title of the course. 30 characters VARCHAR2(30) ssbsect_crse_title;
if null, scbcrse_title
CIP CIP code CIP (Classification of Instructional Programs) code associated with the subject area code.  CIP codes are developed by the National Center for Education Statistics and standardized for MSU by OCHE. 6 characters; see stvcipc VARCHAR2(6) scbcrse_cipc_code
ENROLLED Course enrollment Number of students enrolled in the course, 4-digit number NUMBER(4) ssbsect_enrl
COURSE_CREDITS Course credits The credits offered for the course and its subsections. 4-digit number (2 decimals) NUMBER(4,2) ssbsect_credit_hrs
CREDIT_HOURS Student credit hours Student credit hours for the course, calculated as course credits times enrollment. 8 characters VARCHAR2(8) ssbsect_tot_credit_hrs
CONTACT_HOURS Section contact hours Number of instructor contact hours associated with course section. 6-digit number (2 decimals) NUMBER(6,2) ssbsect_cont_hrs
CROSS_LISTED Cross-listed course Code indicating whether course is cross-listed with another currently-offered course. 2 characters VARCHAR2(2) ssbxlst_xlst_group
INSTR1_ID Primary instructor's SSN Primary instructor's Social Security Number 9 characters VARCHAR2(9) spbpers_ssn
INSTR1_RESP Primary instructor's percent

Primary instructor's percent of instructionalresponsibility for the course

3 characters VARCHAR2(3) sirasgn_percent_response
INSTR1_LAST_NAME Primary instructor's last name Primary instructor's last name 60 characters VARCHAR2(60) spriden_last_name
INSTR1_FIRST_NAME Primary instructor's first name Primary instructor's first name 15 characters VARCHAR2(15) spriden_first_name
INSTR1_MIDDLE_NAME Primary instructor's middle name Primary instructor's middle name 15 characters VARCHAR2(15) spriden_mi
INSTR2_ID Second instructor's SSN Second instructor's Social Security Number 9 characters VARCHAR2(9) spbpers_ssn
INSTR2_RESP Second instructor's percent Second instructor's percent of instructional responsibility for the course 3 characters VARCHAR2(3) sirasgn_percent_response
INSTR2_LAST_NAME Second instructor's last name Second instructor's last name 60 characters VARCHAR2(60) spriden_last_name
INSTR2_FIRST_NAME Second instructor's first name Second instructor's first name 15 characters VARCHAR2(15) spriden_first_name
INSTR2_MIDDLE_NAME Second instructor's middle name Second instructor's middle name 15 characters VARCHAR2(15) spriden_mi
INSTR3_ID Third instructor's SSN Third instructor's Social Security Number 9 characters VARCHAR2(9) spbpers_ssn
INSTR3_RESP Third instructor's percent Third instructor's percent of instructional responsibility for the course 3 characters VARCHAR2(3) sirasgn_percent_response
INSTR3_LAST_NAME Third instructor's last name Third instructor's last name 60 characters VARCHAR2(60) spriden_last_name
INSTR3_FIRST_NAME Third instructor's first name Third instructor's first name 15 characters VARCHAR2(15) spriden_first_name
INSTR3_MIDDLE_NAME Third instructor's middle name Third instructor's middle name 15 characters VARCHAR2(15) spriden_mi
INSTR4_ID Fourth instructor's SSN Fourth instructor's Social Security Number 9 characters VARCHAR2(9) spbpers_ssn
INSTR4_RESP Fourth instructor's percent Fourth instructor's percent of instructional responsibility for the course 3 characters VARCHAR2(3) sirasgn_percent_response
INSTR4_LAST_NAME Fourth instructor's last name Fourth instructor's last name 60 characters VARCHAR2(60) spriden_last_name
INSTR4_FIRST_NAME Fourth instructor's first name Fourth instructor's first name 15 characters VARCHAR2(15) spriden_first_name
INSTR4_MIDDLE_NAME Fourth instructor's middle name Fourth instructor's middle name 15 characters VARCHAR2(15) spriden_mi