OtherEcoTaxa

tblOtherEcoTaxa, taxa in ecological relationships but outside the primary scope


 * OtherEcoTaxonID, integer, 4 bytes, primary key, identifier for a taxon outside the primary scope
 * FileID, integer, 4 bytes, = tblFiles.FileID
 * OtherEcoTaxonStr, text, 150 character maximum, a string with OtherEcoTaxonIDs showing the ancestors and separated by "-". "g" is added at the end of OtherEcoTaxonID for a genus.  "s" is added at the end of OtherEcoTaxonID for a subgenus.
 * ScientificName, text, 100 characters maximum
 * CommonName, text, 100 characters maximum (may include multiple common names separated by commas)
 * RankID, integer, 4 bytes
 * 30 = above genus
 * 20 = genus
 * 18 = subgenus
 * 15 = below subgenus and above species
 * 10 = species
 * 5 = below species
 * AboveID, integer, 4 bytes, = OtherEcoTaxonID. A value of 0 indicates that no parent taxon is included in the table.  There is no limit to the number of "top taxa" that have no parent taxa.
 * 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