Country

The country object in the Deputy install stores information about which countries are supported in the Deputy system. When adding an address for example you will need to know the two-digit country code. This can be obtained from the Country object.

Data ElementData TypeWhat is itMandatory
IdIntegerUnique id of the recordNo
CodeChar(2)The unique code for the country, example AUYes
CodeA3Char(3)The unique 3 digit code for the countryYes
Regionchar(2)The Deputy region the country is inYes
ActiveBoolean True/FalseWhether the country record is active or notYes
SortOrderIntegerThe sort order of the country listNo
CountryVarCharThe full name of the countryYes
ZipValidatePregVarCharThe regex used to validate Zip/PostcodesNo
PhoneDisplayPregVarCharThe regex used to validate phone numbersNo
CreatorIntegerThe id record of the user who created the recordNo
CreatedDateTimeWhen the record was createdNo
ModifiedDateTimeWhen the record was last modifiedNo