Nomenclator

tblNomenclator, name combinations at rank of genus or lower

NomenclatorID, integer, 4 bytes, identifier for the name combination GenusNameID, integer, 4 bytes, = tblGenusNames.GenusNameID SubgenusNameID, integer, 4 bytes, = tblGenusNames.GenusNameID SpeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID SubspeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID InfrasubKind, integer, 2 bytes, kind of infrasubspecies name 0 = [none] 1 = form 2 = variety InfrasubspeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID TSN, integer, 4 bytes, taxon serial number from ITIS. This column has not been implemented. SuitableForGenus, bit. A value of 1 indicates this row in tblNomenclator may be used to determine if the citation for a genus-group taxon should be used to generate a taxon name LSID. Reasons for a value of 0 include missing names, names that are not scientific names, and names for species-group taxa. SuitableForSpecies, bit. A value of 1 indicates this row in tblNomenclator may be used to determine if the citation for a species-group taxon should be used to generate a taxon name LSID. Reasons for a value of 0 include missing names and names that are not scientific names. LastUpdate, smalldatetime, date and time of last update ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change CreatedOn, smalldatetime, date and time row was created CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row