College associated with the course

Course.courseCollege could match the CourseSection.college, 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.

Department associated with the course

Course.courseDepartment could match the CourseSection.department, 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

Course.courseDivision could match the CourseSection.division, 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.

Academic level of the course

Course.courseLevel could match CourseSection.courseSectionLevel, but allows for varying values as needed.
For example, an Independent Study course could have differing levels for course sections where level is based on student.
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 is part of a bachelor's/associate degree program or a vocational/technical program below the baccalaureate.

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

'Doctorate' - Course 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 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 is part of additional learning that is not aligned with a degree outcome.

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

Number to disinguish type of course

Typically a 3- to 5-digit string.

Current status of the course

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

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

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

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

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

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

Date source record inserted or modified

Subject associated with the course

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

Academic term code in which the course is initially effective

Title or description of the course

College associated with the course

Renamed to courseCollege. Remap the college field to the courseCollege field or to the college field in the Course Section entity.

Department associated with course

Renamed to courseDepartment. Remap the department field to the courseDepartment field or to the department field in the Course Section entity.

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

Removed. The isESL field is relocated to the Course Section entity to allow for setting property on a unique course section.

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

Removed. The isRemedial field is relocated to the Course Section entity to allow for setting property on a unique course section.