CountryRegistration

Name: Country Registration

Type: Ancillary

Modules: Clients, CERT

Description: Used mostly in Europe as a place to store clients for PASS that are either manually loaded into the table or entered through an external application.


Field	Documentation
ClientCode	Alphanumeric identifier of the client.
LastName	Last name of the client.
FirstName	First name of the client.
MiddName	Middle name of the client.
Gender	Gender of the client (F = female, M = male).
DateOfBirth	Birth date of the client.
Title	Title of the client (e.g., Mr., Mrs).
SSN	Social security number or other country-specific number identitfying the client.
Comments	Comments about the record.
ZipCode	Zip code or postal code of the client address.
OnStreet	Street name of the client address.
StreetNo	Street number of the client addresst.
State	State of the client address.
City	City of the client address.
Century	Flag that indicates which century is related to the dates (e.g., 1900 or 2000).
Unit	Unit number of the client address.
AdmUnitId	Numeric identifier of the administrative unit that the client has been placed under (from the AdmUnit table).
Lat	Latitude coordinate of the client address.
Lon	Longitude coordinate of the client address.
GeoStatus	Numeric value of the geocoding status for the longitude and latitude of the client address.