Billable hours for course section

College associated with the course section

CourseSection.college could match the Course.courseCollege, but allows for varying values as needed.
If college is associated solely on subject and course number, use the same value in both Course.courseCollege and CourseSection.college.
If college is associated partly on course section, the Course.courseCollege value can be null.
If college is not associated with a course or course section, both values can be null.

Number to disinguish type of course

Typically a 3- to 5-digit string.

Academic level of the course section

CourseSection.courseSectionLevel could match Course.courseLevel, but allows for varying values as needed. For example, an Independent Study course could have differing levels for course sections, based on student level.
If level is assigned based solely on subject and course number, use the same value in both Course.courseLevel and CourseSection.courseSectionLevel.
If level is assigned based partly on course section, the Course.courseLevel value can be null.
Either CourseSection.courseSectionLevel or Course.courseLevel should have an applicable level value.

'Undergraduate' - Course section is part of a bachelor's/associate degree program or a vocational/technical program below the baccalaureate.

'Masters' - Course section is part of a post-bachelor's level program requiring between 1 and 2 full time equivalent academic years of work.

'Doctorate' - Course section is part of a post-master's level program requiring the preparation of an original dissertation/project which demonstrates substantial artistic or scholarly achievement.

'Professional Practice Doctorate' - Course section is part of a post-master's level program to demonstrate the knowledge and skills required to be recognized for professional practice.

'Continuing Education' - Course section is part of additional learning that is not aligned with a degree outcome.

'Other' - Course section can't be described by one of the above.

Unique identifier for every course section per termCode/partOfTermCode

Value is client-defined, but is typically the Course Reference Number (CRN), the Course Section Identifier or a combination of data fields that result in a unique value.
The value for courseSectionNumber will be referenced as a one-to-one relationship in Registration, CourseSectionSchedule and InstructionalAssignment.

Current status of the course section

'Active' - Course section is currently active and being scheduled for enrollment.

'Inactive' - Course section is inactive and will no longer by scheduled for future enrollment.

'Pending' - Course section is active but has not yet been scheduled.

'Cancelled' - Course section is currently cancelled and not being scheduled for enrollment.

'Renumbered' - Course section is inactive because it was replaced by a similar course under a different identifier.

Credit or clock hours based on the number of hours per week the course section meets

Client-defined value for use as needed, such as an additional identifier

Department associated with course section

CourseSection.department could match the Course.courseDepartment, but allows for varying values as needed.
If department is associated solely on subject and course number, use the same value in both Course.courseDepartment and CourseSection.department.
If department is associated partly on course section, the Course.courseDepartment value can be null.
If department is not associated with a course or course section, both values can be null.

Division associated with the course section

CourseSection.division could match the Course.courseDivision, but allows for varying values as needed.
If division is associated solely on subject and course number, use the same value in both Course.courseDivision and CourseSection.division.
If division is associated partly on course section, the Course.courseDivision value can be null.
If division is not associated with a course or course section, both values can be null.

Credit or clock hour value or remedial/ESL/co-op equivalent hour value to be used for enrollment reporting

If course hours are reported in clock hours instead of credit hours, value = 1, else 0

Default value if null: 0/false.

If course section is considered an ESL course, value = 1, else 0

Default value if null: 0/false.

If record is applicable for IPEDS reporting, value = 1, else 0

If course section is considered a remedial course, value = 1, else 0

Default value if null: 0/false.

Part of academic term

If field is not applicable or value unknown, use default value of 1 for full term.

Date source record inserted or modified

Additional identifier to distinguish a particular instance of a course

Subject associated with the course

Typically a 2- to 4-char string in all caps.

Academic term code

Campus associated with course section

Removed. The campus field is relocated to the Course Section Schedule entity with other scheduling properties.

Unique identifier for an instance of a course based on academic term and course number

Renamed to courseSectionNumber. Remap the crn field to the courseSectionNumber field.

Maximum number of seats available for course section

Removed. The maxSeats field is relocated to the Course Section Schedule entity with other scheduling properties.

Current status of the course section

Renamed to courseSectionStatus. Remap the sectionStatus field to the courseSectionStatus field.