Database Table: STATECODE

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

Column Name Column Type Column Description
PRODUCTVENDOR VARCHAR (64)
NOT NULL
String that identifies the third-party product or vendor using this State or Province code for the State or Province identified by this StateProvAbbr code.
STATEPROVABBR CHARACTER (20)
NOT NULL
The internal State or Province Code for the specified state or province assigned by the third-party product or vendor.
STATEPROVCODE CHARACTER (5)
NULL
The State or Province Code used by the third-party product or vendor for this State or Province.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035108000 PRODUCTVENDOR, STATEPROVABBR Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
Not Applicable

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable