| Field Name
| Description | 1º Key
| 2º Index
| Foreign Key | Paradox Field Type
|
| LocPrefix
| Locality prefix. For compatibility with existing records
| * | | | Alpha, 2 characters
|
| LocalityNo
| | * | |
| Long Integer |
| Geog |
Location of site | | * | Geography
| Short Integer |
| MapName |
Map on which locality is marked | | * | Map
| Alpha, 40 characters |
| GeolTime
| Age of locality | | * | GeolTime
| Short Integer |
| RockUnitNo
| Rock unit fossils were found in | | * | RockUnit
| Short Integer |
| LandownerNo
| Property owner | | | Landowner
| Long Integer |
| LocalityName
| | | | | Alpha, 80 characters
|
| Latitude
| Stored in decimal degrees | | | | Number
|
| Longitude
| stored in decimal degrees | | | | Number
|
| Variance
| Amount of uncertainty in latitude/longitude measurements | | | | Alpha, 20 characters
|
| Township
| | | | | Alpha, 3 characters
|
| Range |
| | | | Alpha, 3 characters
|
| Sections |
| | | | Alpha, 3 characters
|
| Meridian
| Meridian referenced by Township Range Section values | | | | Alpha, 25 characters
|
| Description
| Description to enable relocation of locality | | | | Memo, 100 characters displayed
|
| CollectDate
| Date of first collection at locality | | | | Alpha, 25 characters
|
| EntryDate
| date record entered in database | | | | Date
|
| EnteredBy
| Data Entry personnel | | | Person
| Long Integer |