NewNameStatus
From Species File Help
tblNewNameStatus, types of new status for names
- NewNameStatusID, integer, 4 bytes, values between 11 and 16 used for tblTaxonHistory but not tblCites
- 0 = unspecified
- 1 = unchanged
- 2 = new taxon name (including new misspelling or misapplication)
- 3 = made a synonym
- 4 = made valid or temporary
- 5 = new combination initiated by this citation
- 6 = new nomen nudum
- 7 = nomen dubium
- 8 = missed previous change
- 9 = synonym of different taxon
- 10 = gender change
- 11 = name deleted with no related name
- 12 = name deleted, was duplicate protonym
- 13 = genus or species lowered to nominotypical sub
- 14 = nominotypical sub raised to genus or species
- 15 = name replaced by nominotypical sub
- 16 = newly created nominotypical sub
- 17 = new corrected taxon name (justified emendation, corrected lapsus or nomen nudum made available)
- 18 = different combination, may have been initiated by an unlisted previous citation
- 19 = made valid in different combination
- 20 = data before taxon named
- 21 = previous synonymy ended
- UsedForCite, bit, = 0 for NewNameStatusID of 11 to 16 and 21 (used only for tblTaxonHistory), 1 for all other rows (also used for tblCites)
- Name, text, 50 characters maximum
- Explanation, text, 100 characters maximum
- DisplayPosition, integer, 1 byte, used for display sequence in drop down boxes in pages for citations