Campus associated with the course registration if it differs from the course section campus value

If student is registered for a different campus value than CourseSectionSchedule.campus, field should include the alternate campus. If null, CourseSectionSchedule.campus value will be used.

Academic level associated with the course registration if it differs from the course section level

If student is registered for a different level value than what is reflected by the CourseSection.courseSectionLevel value, this field should include the alternate level. If null, CourseSection.courseSectionLevel value will be used.

'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

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 CourseSection, CourseSectionSchedule and InstructionalAssignment.

Enrollment hours value (credit/clock/billable/equivalent) if it differs from the course section enrollment hours value

If student is registered for a different enrollment hours value for the course section than CourseSection.enrollmentHours, field should include the alternate value. If null, CourseSection.enrollmentHours value will be used.

If student is auditing the associated course registration, value = 1, else 0

If student with associated registration status is considered enrolled in the course instance, value = 1, else 0

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

Part of academic term

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

Unique identifier of student

Date source record inserted or modified

Registration status

'Registered' - Student registration process completed for the associated 'courseSectionNumber' and 'termCode'/'partOfTermCode'(optional).

'Web Registered' - Designation to distinguish online registration methods.

'Withdrawal' - Student removal of a course for their course load after the institution's drop/withdrawal date.

'Drop' - Student removal of a course for their course load prior to the institution's drop/withdrawal date.

'Web Drop' - Designation to distinguish online course drop methods.

Date the registration status was inserted or modified, if different than recordActivityDate

If not applicable, use dummy date of: to_date('9999-09-09', 'YYYY-MM-DD').

Academic term code

Campus associated with the course instance

Renamed to courseSectionCampusOverride. If the campus value differs from the course section campus value, remap the campus field to the courseSectionCampusOverride field.

Instance of a course based on academic term, part of term and course number

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

Method of grading for the course instance

Removed. Relocate the course audit property to the new boolean field isAudited.

Level of course instance

Renamed to courseSectionLevelOverride. If the level value differs from the course section level value, remap the crnLevel field to the courseSectionLevelOverride field.