CertificationClients

Name: Certification Clients

Type: Application

Modules: Cert

Description: Information associating Certification Clients with their Cert application user and the government agency representative.


Field	Documentation
ClientId	Numeric identifier of the client to be certified (from the Clients table).
ReturnedMail	Flag that indicates letters sent to the client were returned.
LoginName	CERT username that last edited the record.
AppealCW	Initials of the case worker assigned to the appeal for the client.
CertifyCW	Initials of the case worker assigned to the certification for the client.
RenewCW	Initials of the case worker assigned to the certification renewal for the client.
LetterId	Numeric identifier of the certification letter (from the CertificationLetters table).
LetterLabel	Numeric identifier of the certification label (from the CertificationLetters table).
WorkerId	Numeric identifier of the certification worker assigned to the client (from the CertificationWorker table).
ClientMemo	User-entered comments about the client.
ReqOrigAlt	Date the original client request was entered into the system.
CreBy	CERT username that created the original entry.
DateEntered	Date the client was entered into CERT.
Guardian	Name of the person acting as a guardian for the client when traveling.
RepName	Name of the client representative (e.g., CNIB).
RepAddress1	Address of the representative for the client (e.g., for CNIB - 50 Burnhamthorpe Rd W #300).
RepAddress2	Second line of the client representative's address (e.g., Suite 5 or 2nd floor).
RepCity	City of the client representative address.
RepState	State of the client representative address.
RepZip	Zip code or postal code of the client representative address.
RepPhone	Phone number of the client representative.
RepFax	Fax number of the client representative.
RepEmail	E-mail address of the client representative.
GuardianPhone	Phone number of the person acting as a guardian for the client.
IdPrint	Flag that indicates the ID card is to be printed.
IdEligDays	Number of days that the ID card is valid for use.
IdNumber	ID card number of the client.
BttId	Numeric identifier of the bus travel training entry (from the CertificationBtravel table).
Mname	Name to use when mailing documents to the client.
Attention	Name to use if letters sent to the client require someone else's attention.
ClientEmail	E-mail address of the client.
ExpirationLetter	Name of the expiration letter to use for the client.