TaxonHistory

tblTaxonHistory contains history of concepts and nomenclature for protonyms added in version 4.0.


 * TaxonHistoryID, integer, 4 bytes, primary key, identifier for taxon name and concept.
 * TaxonNameID, integer, 4 bytes, = tblTaxon.TaxonNameID, identifier for the monomial name (protonym) associated with the history.
 * SeqNum, integer, 2 bytes, sequence number within this TaxonNameID, 1-based values without gaps.
 * NomenclatorID, integer, 4 bytes, = tblNomenclator.NomenclatorID, identifier for binomial name associated with the history.
 * CiteRefID, integer, 4 bytes, = tblRefs.RefID, identifier for the reference that defined the nomenclatural or concept change. May = 0 if change comes from other source explained in note or if the reference has not been identified.
 * NewNameStatus, integer, 1 byte, status of name when changed
 * 0 = unspecified
 * 1 = unchanged
 * 2 = new taxon name
 * 3 = made a synonym
 * 4 = made valid or temporary
 * 5 = new combination
 * 6 = name deleted with no related name
 * 7 = name deleted because of duplicate protonym, related name can be found in tblRelatedHistory
 * 8 = genus or species lowered to nominotypical sub
 * 9 = nominotypical sub raised to genus or species
 * 10 = name replaced by nominotypical sub
 * 11 = new nominotypical sub
 * ConceptChange, integer, 1 byte, values in effect on completion of the change, permitted values:
 * 0 = unspecified
 * 1 = unchanged
 * 2 = new
 * 3 = restored
 * 4 = expanded
 * 5 = shrunk
 * 6 = modified
 * 7 = terminated
 * 8 = transferred
 * OtherHistoryID, integer, 4 bytes, = tblTaxonHistory.TaxonHistoryID, identifier for the other history ID involved in a relationship change specified in RelatedHistoryID
 * RelatedHistoryID, integer, 2 bytes, = tblRelatedHistory.RelatedHistoryID, identifier for the type of relationship to OtherHistoryID
 * UserConfirmed, bit, 1 = user has confirmed data in this row or generated from user supplied data in tblCites
 * UnreliableAssumption, bit, 1 = program used an unreliable assumption to create row
 * ArbitraryRow, bit, 1 = arbitrary row generated by program to resolve conflict, user resolution needed
 * Note, text, 300 bytes maximum. When Status is set = 2, values for NomenclatorID and CiteRefID are set = 0, but those items are expanded to text in this column. When Status is set = 3, the domain name of the split out species file is placed in this column.
 * LastUpdate, smalldatetime, date and time row last changed
 * ModifiedBy, integer, 2 bytes, UserID of the signon that made the change
 * Status, integer, 1 byte, status of the row
 * 0 = active
 * 1 = dormant, used for deleted nominotypiical subs, which might be re-instated at a later time
 * 2 = artifact, used for rows erroneously added. The row cannot be deleted once TaxonHistoryID has been exposed in an LSID or other GUID for a taxon concept.
 * 3 = moved to other species file identified in Note
 * 4 = moved out of scope