Open topic with navigation

COUNTRYADDRESSLABEL (4.0SP20)

Contains custom labels for use in address forms when dealing with a specific country.

Primary Key
Primary Key Field Type

ID

uniqueidentifier
Foreign Key Fields
Foreign Key Field Type Null Notes Description

COUNTRYID

uniqueidentifier

false

Stores the country that this set of custom labels is to be used with.

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.
Fields
Field Field Type Null Notes Description

ADDRESSLABEL

nvarchar(25)

false

'Address'

Stores the value to be used on labels when prompting for an address block.

CITYLABEL

nvarchar(25)

false

'City'

Stores the value to be used on labels when prompting for a city.

REGIONLABEL

nvarchar(25)

false

'Province'

Stores the value to be used on labels when prompting for a region.

POSTCODELABEL

nvarchar(25)

false

'Postcode'

Stores the value to be used on labels when prompting for a postcode.

DPCLABEL

nvarchar(25)

false

''

Stores the value to be used on labels when prompting for a DPC.

CARTLABEL

nvarchar(25)

false

''

Stores the value to be used on labels when prompting for a cart.

LOTLABEL

nvarchar(25)

false

''

Stores the value to be used on labels when prompting for a lot.

COUNTYLABEL

nvarchar(25)

false

''

Stores the value to be used on labels when prompting for a county.

CONGRESSIONALDISTRICTLABEL

nvarchar(25)

false

''

Stores the value to be used on labels when prompting for a congressional district.

STATEHOUSEDISTRICTLABEL

nvarchar(25)

false

''

Stores the value to be used on labels when prompting for a state house district.

STATESENATEDISTRICTLABEL

nvarchar(25)

false

''

Stores the value to be used on labels when prompting for a state senate district.

LOCALPRECINCTLABEL

nvarchar(25)

false

''

Stores the value to be used on labels when prompting for a local precinct.

DATEADDED

datetime

false

getdate()

Indicates the date this record was added.

DATECHANGED

datetime

false

getdate()

Indicates the date this record was last changed.

TS

timestamp

false

Timestamp.

TSLONG

bigint (Computed)

true

Numeric representation of the timestamp.
Indexes
Index Name Field(s) Unique Primary Clustered

IX_COUNTRYADDRESSLABEL_DATEADDED

DATEADDED

False

False

True

IX_COUNTRYADDRESSLABEL_DATECHANGED

DATECHANGED

False

False

False

PK_COUNTRYADDRESSLABEL

ID

True

True

False

UC_COUNTRYADDRESSLABEL_COUNTRYID

COUNTRYID

True

False

False
Triggers
Trigger Name Description

TR_COUNTRYADDRESSLABEL_T2BDELETE

TR_COUNTRYADDRESSLABEL_AUDIT_UPDATE

TR_COUNTRYADDRESSLABEL_AUDIT_DELETE