Definition of table course

Definition of a Course we may offer

Table Dump Name: course

abstract: (CHAR) Abstract length description of this course
course-id: (INTG) (no description available)
course-shortname: (CHAR) Simple, short name/code for this course
course-title: (CHAR) Title of this course
duration: (DECM) Duration of this course in hours
max-seats: (INTG) Maximum # of seats possible in this class
min-seats: (INTG) Minimum seats to be filled or course is cancelled
needed-tools: (CHAR) Tools or objects (books, software, computer) needed to teach
optimal-seats: (INTG) Optimal class size
outcall-cost: (DECM) Cost of this course given on site
per-seat-fee: (DECM) Fee/Tuition for course given at our offices
pre-requisites: (CHAR) Courses that should be taken, if any, before this one
summary: (CHAR) Enter a short, 1 line summary of this course

abstract Data type: CHARACTER
Format: x(48)
Help: Abstract length description of this course

course-id Data type: INTEGER
Format: zzzzzzzzzzz9
Attributes: Index Component

course-shortname Data type: CHARACTER
Format: x(16)
Help: Simple, short name/code for this course
Attributes: Index Component

course-title Data type: CHARACTER
Format: x(40)
Help: Title of this course
Attributes: Index Component

duration Data type: DECIMAL (Decimals: 2)
Format: zz9.9 (Initial Value: 0)
Help: Duration of this course in hours

max-seats Data type: INTEGER
Format: zz9 (Initial Value: 6)
Help: Maximum # of seats possible in this class

min-seats Data type: INTEGER
Format: zz9 (Initial Value: 2)
Help: Minimum seats to be filled or course is cancelled

needed-tools Data type: CHARACTER
Format: x(32)
Help: Tools or objects (books, software, computer) needed to teach

optimal-seats Data type: INTEGER
Format: zz9 (Initial Value: 4)
Help: Optimal class size

outcall-cost Data type: DECIMAL (Decimals: 2)
Format: z,zz9.99 (Initial Value: 0)
Help: Cost of this course given on site

per-seat-fee Data type: DECIMAL (Decimals: 2)
Format: zz,zz9.99 (Initial Value: 0)
Help: Fee/Tuition for course given at our offices

pre-requisites Data type: CHARACTER
Format: x(32)
Help: Courses that should be taken, if any, before this one

summary Data type: CHARACTER
Format: x(40)
Help: Enter a short, 1 line summary of this course
Attributes: Index Component