Description: List of US states and territories. USPS Value Set.
| Column Name |
Ordinal Position |
|
| Column Name |
Ordinal Position |
Referenced Table |
|
| LKCOUNTRYID |
4 |
LKCOUNTRY
|
|
|
Name |
Type |
|
| 1 |
LKSTATEID |
INT |
|
|
Description: The unique Id for the LkState table
|
|
Name |
Type |
|
| 2 |
STATEABBR |
NCHAR |
|
|
Description: State abbreviation
|
|
Name |
Type |
|
| 3 |
STATE |
NVARCHAR |
|
|
Description: State description
|
|
Name |
Type |
|
| 4 |
LKCOUNTRYID |
INT |
|
|
Description: LkCountryId is a foreign key to the LkCountry table
|
|
Name |
Type |
|
| 5 |
FIPSCODE |
NCHAR |
|
|
Description: Two digit FIPS code for the state
|