Definition of table course-offering

A specific date/time a course is offered

Table Dump Name: course-o

billed: (LOGC) Yes after the class has been billed
course-date: (DATE) Date this course meets
course-id: (INTG) Course this offering is associated with
course-time: (CHAR) Course offered time (i.e. 9AM-Noon)
offering-id: (INTG) Offering ID
offering-seats: (INTG) Number of seats in this offering
offering-status: (CHAR) Offering Status (OPEN, CLOSED, FULL, CANCELLED, COMPLETE)
staff-id: (INTG) Staff Member teaching this class
used-seats: (INTG) Number of used/registered seats

course-by-date: course-id, course-date, course-time, offering-id
course-offering: (UNIQUE, PRIMARY) course-id, offering-id
couse-by-instructor: staff-id, course-date, course-time, course-id, offering-id
offering-by-date: course-date, course-time, offering-id

billed Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Yes after the class has been billed

course-date Data type: DATE
Format: 99/99/9999
Help: Date this course meets
Attributes: Index Component

course-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Course this offering is associated with
Attributes: Index Component

course-time Data type: CHARACTER
Format: x(16)
Help: Course offered time (i.e. 9AM-Noon)
Attributes: Index Component

offering-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Offering ID
Attributes: Index Component

offering-seats Data type: INTEGER
Format: zz9 (Initial Value: 0)
Help: Number of seats in this offering

offering-status Data type: CHARACTER
Format: x(8) (Initial Value: OPEN)
Help: Offering Status (OPEN, CLOSED, FULL, CANCELLED, COMPLETE)

staff-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Staff Member teaching this class
Attributes: Index Component

used-seats Data type: INTEGER
Format: zz9 (Initial Value: 0)
Help: Number of used/registered seats