CertificationRequest

Name: Certification Request

Type: Ancillary, Application

Modules: Cert

Description: Contains all the passenger certification appointment information.

Field Documentation
Cert_Rid Numeric identifier of a certification request.
LastName Last name of the client making the certification request.
FirstName First name of the client making the certification request.
MiddleName Middle name of the client making the certification request.
DateOfBirth Birth date of the client making the certification request.
HStreetNo Street number of the home address of the client (alphanumeric).
HStreetNum Street number of the home address of the client (numeric).
HOnStreet Street name of the home address of the client.
HUnit Unit number of the home address of the client.
HCity City that the home address of the client is in.
HState State that the home address of the client is in.
HZipCode Zip code or postal code of the home address of the client.
MStreetNo Alphanumeric street number of the mailing address for the client.
MStreetNum Numeric street number of the mailing address for the client.
MOnStreet Street name of the mailing address of the client is on.
MUnit Unit number of the mailing address of the client.
MCity City that the mailing address of the client is in.
MState State that the mailing address of the client is in.
MZipcode Zip code or postal code for the mailing address of the client.
Mname Name to use when sending letters to the mailing address of the client.
Phone Phone number at which to contact the client.
FAX Fax number for the client.
DateEntered Date when the certification request was entered into the system.
DateMailed Date when the letter(s) were last sent to the client.
MType Deprecated.
RComments Comments about the certification request.
Title Title for the client (e.g., Mr. Mrs).
ReturnedMail Flag that indicates the letter sent to the client was returned.
Attention Name to use if letters sent to the client require someone else's attention.
MailPhone Phone number at the mailing address of the client.
Quantity Number of copies to send.
AddedtoClient Date when the certification request was added to the clients file.
ClientCode Client code of the client (from the Clients table).
Gender Gender of the client.
CreBy Username that created the certification request record.
CreDate Date the record was created.
CreTime Time the record was created. Value is in seconds from midnight.
ModBy User who last modified the record.
ModDate Date the record was last modified.
ModTime Time the record was last modified. Value is in seconds from midnight.
AdmUnitId Numeric identifier of the administration unit (from the AdmUnit table).
HSiteName Name of the home address of the client (e.g., Happy Trails Retirement Home).
MSiteName Name of the mailing address of the client (e.g., Trapeze Inc.).
HAddrName Name of the home address of the client.
MAddrName Name of the mailing address of the client.
ClientEmail E-mail address of the client.
HGeoStatus Numeric value of the status of the geocoding for the longitude and latitude of the home address of the client.
HLon Longitude coordinate of the home address of the client.
HLat Latitude coordinate of the home address of the client.
MGeoStatus Numeric value of the status of the geocoding for the longitude and latitude of the mailing address of the client.
MLon Longitude coordinate of the mailing address of the client.
MLat Latitude coordinate of the mailing address of the client.
SSN Social security number of the client.
AdministrativeUnitId Numeric identifier of the administration unit (from the AdmUnit table).
HMapPage Page number of a map book that the home address of the client is on (e.g., Page 4 of Perlys Maps).
MMapPage Page number of a map book that the clients mailing address is on (e.g., Page 5 of Perlys Maps).
HAtStreet Cross-street or intersection closest to the home address of the client.
MAtStreet Cross-street or intersection closest to the mailing address of the client.