Description: Defines acceptable county entries used by the system and application
| Column Name |
Ordinal Position |
|
| Column Name |
Ordinal Position |
Referenced Table |
|
| LKSTATEID |
2 |
LKSTATE
|
|
|
Name |
Type |
|
| 1 |
LKCOUNTYID |
INT |
|
|
Description: The unique Id for the LkCounty table
|
|
Name |
Type |
|
| 2 |
LKSTATEID |
INT |
|
|
Description: LkStateId is a foreign key to the LkState table
|
|
Name |
Type |
|
| 3 |
CODE |
NVARCHAR |
|
|
Description: Internal code for the county
|
|
Name |
Type |
|
| 4 |
COUNTY |
NVARCHAR |
|
|
Description: Textual name of the county
|
|
Name |
Type |
|
| 5 |
STARTDATE |
DATE |
|
|
Description: Start / Effective Date
|
|
Name |
Type |
|
| 6 |
ENDDATE |
DATE |
|
|
Description: End / Discontinue Date
|
|
Name |
Type |
|
| 7 |
FIPSCODE |
NVARCHAR |
|
|
Description: FIPS code for the county including two digit state code preceding the three digit county code
|