FO_State
This table requires a single record for each state. Its purpose is to match a state full name to its accepted abbreviation.
| Field | Type | Notes |
|---|---|---|
|
State_ID |
int |
ID field, a counter. Unique |
|
StateCode |
varchar(50) |
Standard two character state postal abbreviation. |
|
StateName |
varchar(80) |
Full state name. |