General Concepts

Course	A course is identified by a Course ID. The title, subject(s) and number(s) assigned to it may vary over time, but the general body of knowledge that is covered stays the same.
Course listing	An offering of a course in a term with a specific subject and number.
Section	Students enroll in a section. Each section has a CRN and one or more meetings.
CRN	A one-up number assigned to each section created in Banner. Students use the CRN to enroll, instructors use the CRN to get a class list. All student enrollments will be recorded by CRN.
Meeting	Each section has one or more meetings. Each meeting has a session id and a schedule type. Meetings can be TBA (to be arranged) or will have a start and end time, days of the week, a building and a room number. A section may have multiple meetings if the rooms or times vary through the week, or if different instructors teach different days.
Schedule type	Distinct modes of instruction. Examples: LEC (Lecture), IND (Independent Study). Schedule types are assigned to sections and to meetings. When the schedule type on the section is different from the schedule type on the meeting, we will use the schedule type on the meeting.
Session	Instructors are assigned to sessions. A session may have multiple instructors. If a section has multiple meetings, the session number may be the same on all meetings (if all the instructors teach all the sessions) or the session number may be different for each meeting. In the EDW, sessions for crosslisted sections are represented by one record

Crosslisted Courses

Note: in UI Direct, all crosslistings had to be at the same course level (100-400). In Banner, one common use of crosslisting is to manage a course that is appropriate for upper-level undergraduates as well as graduate students, so the course levels do not have to be consistent among all members of a crosslisted set.

For reporting, all sections of crosslisted courses will be consolidated and treated as one section. Controlling departments will be asked to designate one of the subject/number combinations as the "offering course" and the section will be listed and reported there.

How to identify them in Banner SCACRSE: Approval=C for controlling dept or N for non-controlling.
Department will be set to the controlling dept.

SCADETL/Equivalent courses: Each crosslist will be included as an "equivalent course" with end date of 999999.
Other equivalent courses will have a campus-specific end term of 199999.

SCADETL/Supplemental information: the course id will be the same on all crosslistings,
and the controlling dept will be listed in the credit category field:

SSASECT: There will be a crosslist identifier, usually starting with "C" which will be the same for each crosslisted section. However, if the section also "meets with" another course, the crosslist identifier may start with another letter. (The crosslist identifier allows the crosslistings to be scheduled in the same room. TBA courses may lack this crosslist ID).

To find all crosslistings for a section In Banner: From SSASECT, under Options, choose SSAXLST to search for crosslistings with the same crosslist ID.

In EDW: The table EDW_T_CROSS_LIST_CRS has an entry for each crosslisting. If the CROSS_LIST_CRS_CTRL_CD=C, the listing is the controlling department. If you are working with a section or session table, use term and course id as the key to this table to obtain the controlling course information. Remember that section enrollments and section limits must be added for all crosslisted course sections to get a true picture of the enrollments in a section.

Crosslisted sections

SSASECT: Crosslist identifier will be populated:

For these sections, we will adjust the contact hours for any instructor listed for more than one section.

Extramural sections and Guided Individual Study

• Extramural part of term
  Some whole courses will be offered in a part of term labeled XM.
• On-campus enrollments (community learning)
  Other students will be enrolled in special sessions of regular on-campus courses in the regular part of term. These can be identified by an Instructional Method value of XM-OL (for Extramural -- Open Learning)
• Open learning
  These sections will be identified by a special term (1xxxx7) which has start and end dates lasting a full year. Guided individual study will be identified as sections which are independent study. All other sections are to be counted as regular extramural classes.

Online course sections/sessions

In the EDW: T_SESS_SCHED_TYPE_CD ='ONL' or T_SECT_BASE_SCHED_TYPE_CD ='ONL'

Packaged sections

The section schedule type will be PKG, and you will need to look at the meeting schedule type to determine the "real" schedule type.

Linked sections

Linked sections are marked by a "link identifier" on SSACRSE and SECT_LINK_ID on the section base information in the EDW.

Credit can be assigned to different sections of a linked course. SSASECT will have the section specific credit, and it will also be added to the meeting block.   Any schedule type that carries credit should have "gradeable" marked on SSASECT.

Independent studies

Independent studies can be identified in Banner with the schedule type of IND or N1-N5.

Enrollment in multiple unlinked sections in one course