Definition of table course-pupil

No table description available

Table Dump Name: course-p

Alphabetical Field Summary

• comments: (CHAR) Pupils Comments
• course-id: (INTG) Course this offering is associated with
• district-po-num: (CHAR) PO # to bill district for this training
• in-attendance: (LOGC) Yes if the pupil actually attended class
• invoice-num: (CHAR) Invoice Number (if any) we billed this on
• offering-id: (INTG) Offering ID
• pupil-email: (CHAR) Pupils Email Address
• pupil-name: (CHAR) Name of this pupil
• pupil-phone: (CHAR) Pupils Phone #
• pupil-seq: (INTG) Pupil Seq# (used for ordering requests)
• pupil-status: (CHAR) Pupil Status (APPROVED, WAITING, DECLINED)
• registered-date: (DATE) Date Pupil registered for course
• registered-time: (CHAR) Time Pupil Registered At
• site-id: (INTG) Site This pupil is associated with

Alphabetical Index Summary

• course-by-site: (PRIMARY) site-id, pupil-name, course-id, offering-id
• course-student: course-id, offering-id, pupil-name

Tables course-pupil references

• course - Definition of a Course we may offer
• course-offering - A specific date/time a course is offered
• site - Installed Sites

Detailed Alphabetical Field Listing

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

district-po-num Data type: CHARACTER
Format: x(16)
Help: PO # to bill district for this training

in-attendance Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes if the pupil actually attended class

invoice-num Data type: CHARACTER
Format: x(16)
Help: Invoice Number (if any) we billed this on

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

pupil-email Data type: CHARACTER
Format: x(40)
Help: Pupils Email Address

pupil-name Data type: CHARACTER
Format: x(40)
Help: Name of this pupil
Attributes: Index Component

pupil-phone Data type: CHARACTER
Format: (xxx) xxx-xxxx ~xxxxx
Help: Pupils Phone #

pupil-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Pupil Seq# (used for ordering requests)

pupil-status Data type: CHARACTER
Format: x(12) (Initial Value: WAITING)
Help: Pupil Status (APPROVED, WAITING, DECLINED)

registered-date Data type: DATE
Format: 99/99/9999
Help: Date Pupil registered for course

registered-time Data type: CHARACTER
Format: x(8)
Help: Time Pupil Registered At

site-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Site This pupil is associated with
Attributes: Index Component

Created on 04/03/2003 by DBHTML V1.1c