CertificationAppt

Name: Certification Appointments

Type: Ancillary, Application

Modules: Cert

Description: Information related to passenger certification appointments. Where, When, with whom, etc.


Field	Documentation
ApptAId	Numeric identifier of the certification appointment.
ApptCId	Numeric identifier of the certification facility (AdministrativeUnitId from the CertificationFacilities table).
ApptDate	Date of the appointment.
ApptTime	Time of the appointment.
LastName	Last name of the client who has the appointment.
FirstName	First name of the client who has the appointment.
MiddleName	Middle name of the client who has the appointment.
HStreetNum	Street number of the pick-up address for the client going to the appointment.
HStreetNo	String street number of the pick-up address for the client going to the appointment.
HOnStreet	Street name of the pick-up address for the client going to the appointment.
HUnit	Unit number of the pick-up address for the client going to the appointment.
HCity	City of the pick-up address for the client going to the appointment.
HState	State of the pick-up address for the client going to the appointment.
HZipCode	Zip code or postal code of the pick-up address for the client going to the appointment.
RComments	Comments about the request.
Phone	Phone number at which the client can be contacted.
ApptRider	Deprecated.
ApptAttn	Deprecated.
ClientId	Numeric identifier of the client who has the appointment (from the Clients table).
AddrType	Address type of the pick-up address for the client going to the appointment (from the AddressTypes table).
HLon	Longitude coordinate of the client's home address.
HLat	Latitude coordinate of the client's home address.
CertApptTypeID	Numeric identifier of the appointment type (from the CertificationApptType table).