TaxonNameLSIDs

tblTxnNmLSIDs contains infomation about LSIDs for scientific taxon names.

TxnNmLSID, integer, 4 bytes, primary key, = ID portion of LSIDs FileID, integer, 4 bytes, = tblFiles.FileID TaxonNameID, integer, 4 bytes, when row added = tblTaxa.TaxonNameID, but table relationship cannot be created because the row must remain here even if the row in tblTaxa is deleted NomenclatorID, integer, 4 bytes, = tblNomenclator.NomenclatorID. TaxonNameID and NomenclatorID for a unique index TrueTxnNmLSID, integer, 4 bytes, = TxnNmLSID, available for forwarding in case an LSID must be deleted Status, integer, 1 byte 0 = active 1 = dormant, used for deleted nominotypical subs 2 = artifact from rows erroneously added 3 = moved to other species file identified in Note 4 = moved out of scope 5 = dormant, AccessCode changed to > 0 Note, text, 100 bytes maximum, used to record that the value of TxnNmLSID in this row is reserved for future merge into this species file of an existing private species file named in this field. Other uses are likely in the future. LastUpdate, smalldatetime, date and time row last updated 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