STATECODE

This table maps the internal StateProv Abbreviation Code to the State or Province Code. They are dictated by the third-party product or vendor identified in the PRODUCTVENDOR column.

Column Descriptions:

NameTypeDescription
PRODUCTVENDORVARCHAR (64) NOT NULLString that identifies the third-party product or vendor using this State or Province code for the State or Province identified by this StateProvAbbr code.
STATEPROVABBRCHAR (20) NOT NULLThe internal State or Province Code for the specified state or province assigned by the third-party product or vendor.
STATEPROVCODECHAR (5)The State or Province Code used by the third-party product or vendor for this State or Province.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>PRODUCTVENDOR+STATEPROVABBRPrimary Key