CertificationApptHour
Name: Certification Appointment Hour
Type: Application
Modules: Cert
Description: Lists all valid Cert User appointments times for passenger Certification. Cross-reference to appointment type.
| Field | Documentation |
|---|---|
| ApptTId | Numeric identifier of the appointment time. |
| ApptCId | Numeric identifier of the Certification facility (AdministrativeUnitId from the CertificationFacilities table). |
| ApptDate | Date of the appointment. |
| ApptDow | Three-character name of the week day (e.g., Sun, Mon). |
| ApptTime | Time of the appointment. |
| ApptBooked | Number of appointments booked within the time range. |
| ApptLimit | Maximum duration of each appointment within the time range. |
| ApptEndTime | End time of the appointment. |
| CertApptTypeID | Numeric identifier of the certification appointment type (from the CertificationApptType table). |
| IsClosed | Flag that indicates whether the booking has been closed. |