Flora of Texas Consortium Draft Data Model - Main Table
Field Range Field #Field Name DescriptionType Length

Accession (unique identifier = fields 1+2)
1 Acronym of collectionEach Institution will use the acronym assigned in Index Herbariorum which can be entered by default in most cases. Where institutions hold more than one collection, they will have the option of selecting by a toggle key. Alphabetic 5
2 Number on sheetThis may be an existing number on the sheet or ,in the case of collections without accession numbers on the sheet, a new number. Bar-coded numbers are optional. Alphanumeric 12
3 Ancillary collection information Indicate the existence of an ancillary collection by checking the appropriate checkbox from the choices: carpological, slide, spirit, multiple sheets, oversize collections. There is no limit on the number that can be checked. 5 Check boxes: carpological; slide, spirit; multiple sheets; oversize collections. 2

Names referenced to BONAP authority table
4Name on sheetSelect from the authority file. This will drop in a reference number that will link the specimen information to the full citation of the name and insert the reference to the BONAP accepted name in the next field. Alphanumeric8
5BONAP accepted nameThe reference number will be entered automatically from the authority table.Alphanumeric8
6Common name from authority fileSelect from authority file.Alphanumeric50
7Alternative common name on sheetFlag that additional information can be viewed via the image, if available.Boolean Yes/no1

Collection information
8Primary Collector's name (could be a pair)Name of primary collector to be selected from authority file of collectors. This may be a pair such as Lundell and Lundell. Alphabetic50 (from lookup table to be developed)
9Other collectorsIf other names are available check YES (which will signify et al.. if not, check NO.Boolean Y= et al. N= no others
10Collector's Number Alphanumeric so that all notations can be entered. Number to be entered without commas.Alphanumeric15
11Beginning date of collectiondd/mmm/yyyy Enter the year in full to prevent misinterpretation.Date (dd/mmm/yyyy)25
12Ending datedd/mmm/yyyy Enter if a second date is provided Date (dd/mmm/yyyy)25
13Other dateText field for references such as "spring 1888"Alphabetic30

Locality records Fields for higher categories will be available but not used, or entered automatically, for this project
14Country (entered automatically for this project)For this project, this will be entered automaticallyAlphabetic15
15StateFor this project, Texas will be entered automaticallyAlphabetic5
16County (Type ahead: linked table)Type in letters until the county name is 'recognized' and dropped in from the linked table.Alphabetic20
17Referenced Place: Major TownEnter name of major town mentioned in locality text.Alphabetic25
18Distance from Referenced Placedistance as recorded with unit m/kmalphanumeric 5
19Direction from Referenced PlaceRead from sheet and enter ,N,S, NNW etc.Alphabetic3
20Referenced AreaText field for reference to area such as Big Bend National ParkAlphabetic20
21LAT.Enter if given on sheet, in standard formatAlphanumeric15
22LONGEnter if given on sheet, in standard formatAlphanumeric15
23Confidence LimitsFour degrees of confidence in the accuracy of the grid will be
1= grid reference was present on sheet
2= grid reference was determined using map
3= grid reference was read from gazetteer.
4= no precise locality, fill in county.
Numeric1 (four options)

24Type If the sheet is a type, check one of the listed options (range from holo to epi)Check box5
25Ecological InformationCheck appropriate box. Yes/No If this information can be associated with an image on file, then the information can be interpreted at a later stage.Check box1
26VoucherCheck boxes for : anatomy, chemotaxonomy, cytology, ethnobotanical, molecular pollen or other.Alphabeticpulldown menu of 7 options
27PhenologyCheck boxes will be provided for Flowering, Fruiting Neither. At least one must be checked.Check boxesthree options one of which must be checked
28Determined byTwo choices in check boxes: determined by collector, or annotated by other.Check boxes (2 options)1 (collector or on an annotation label))
29Date determined (annotations only)Enter the date of the annotationdd/mmm/yyyy10
30Data entry byName of data entry person We can devise a checklist so the names can be selected and dropped in, in standard format and will not need to be keyed in every time.Alphabetic25
31Data entry dateDate format could be dropped inDate25
32ImageSelect from the menu:
0 for no image on file
1 for full specimen image
2 for image of label only.
Checkboxes (three options)1
33ImageInsert image if availableImage fileBLOB - (ca. 64kb)

34data entry edited byName of data entry person who edits database. Names could be in short lookup file of data entry personnel.Alphabetic25
35Data entry edited dateDate format, maybe dropped in automaticallyDate25
36data entry edited atAcronym of institution that revised the informationAlphabetic5

Created: 14 November1995 as HTML conversion from 'FTCFFLD1.DOC' from BRIT. Last updated: 21 November 1995.