http://help.speciesfile.org/api.php?action=feedcontributions&user=Dceades&feedformat=atomSpecies File Help - User contributions [en]2024-03-29T00:58:45ZUser contributionsMediaWiki 1.19.0http://help.speciesfile.org/index.php/TaxonHistoryTaxonHistory2014-05-11T21:18:11Z<p>Dceades: </p>
<hr />
<div>'''tblTaxonHistory''', history of concepts and nomenclature for protonyms. This is used only for taxa at genus rank or lower.<br />
<br />
*TaxonHistoryID, integer, 4 bytes, primary key, identifier for taxon name and concept.<br />
* [[Taxa|TaxonNameID]], integer, 4 bytes, = tblTaxon.TaxonNameID, identifier for the monomial name (protonym) associated with the history.<br />
* FileID, integer, 4 bytes, = tblFiles.FileID, the species file the row is associated with. This column is being added in late 2013. Old rows with Status = 2 (artifact) remain with FileID = 0.<br />
* SeqNum, integer, 2 bytes, sequence number within this TaxonNameID, 1-based values without gaps.<br />
* [[Nomenclator|NomenclatorID]], integer, 4 bytes, = tblNomenclator.NomenclatorID, identifier for binomial name associated with the history.<br />
* [[Refs|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.<br />
* NewNameStatusID, integer, 4 bytes, status of name when changed<br />
** 0 = unspecified<br />
** 1 = unchanged<br />
** 2 = new taxon name<br />
** 3 = made a synonym<br />
** 4 = made valid or temporary<br />
** 5 = new combination<br />
** 6 = name deleted with no related name<br />
** 7 = name deleted because of duplicate protonym, related name can be found in tblRelatedHistory<br />
** 8 = genus or species lowered to nominotypical sub<br />
** 9 = nominotypical sub raised to genus or species<br />
** 10 = name replaced by nominotypical sub<br />
** 11 = new nominotypical sub<br />
* ConceptChangeID, integer, 4 bytes, values in effect on completion of the change, permitted values:<br />
** 0 = unspecified<br />
** 1 = unchanged<br />
** 2 = new<br />
** 3 = restored<br />
** 4 = expanded<br />
** 5 = shrunk<br />
** 6 = modified<br />
** 7 = terminated<br />
** 8 = transferred<br />
* OtherHistoryID, integer, 4 bytes, = tblTaxonHistory.TaxonHistoryID, identifier for the other history ID involved in a relationship change specified in RelatedHistoryID<br />
* RelatedHistoryID, integer, 4 bytes, = tblRelatedHistory.RelatedHistoryID, identifier for the type of relationship to OtherHistoryID<br />
* UserConfirmed, bit, 1 = user has confirmed data in this row or generated from user supplied data in tblCites<br />
* UnreliableAssumption, bit, 1 = program used an unreliable assumption to create row<br />
* ArbitraryRow, bit, 1 = arbitrary row generated by program to resolve conflict, user resolution needed<br />
* Note, text, 300 characters 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.<br />
* Status, integer, 1 byte, status of the row<br />
** 0 = active<br />
** 1 = dormant, used for deleted nominotypical subs, which might be re-instated at a later time<br />
** 2 = artifact, used for rows erroneously added. The row cannot be deleted once TaxonHistoryID has been exposed in a GUID for a taxon concept. But does that ever happen?<br />
** 3 = moved to other species file identified in Note<br />
** 4 = moved out of scope<br />
* LastUpdate, smalldatetime, date and time row last updated<br />
* ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
* CreatedOn, smalldatetime, date and time row was created<br />
* CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
[[Category:TaxaTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/NomenclatorNomenclator2014-03-03T16:37:08Z<p>Dceades: </p>
<hr />
<div>'''tblNomenclator''', name combinations at rank of genus or lower<br />
<br />
*NomenclatorID, integer, 4 bytes, identifier for the name combination<br />
* To be added: FileID, integer, 4 bytes, = tblFiles.FileID<br />
* [[GenusNames|GenusNameID]], integer, 4 bytes, = tblGenusNames.GenusNameID<br />
* [[GenusNames|SubgenusNameID]], integer, 4 bytes, = tblGenusNames.GenusNameID<br />
* [[GenusNames|InfragenusNameID]], integer, 4 bytes, = tblGenusNames.GenusNameID<br />
* [[SpeciesNames|SpeciesSeriesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID<br />
* [[SpeciesNames|SpeciesGroupNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID<br />
* [[SpeciesNames|SpeciesSubgroupNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID<br />
* [[SpeciesNames|SpeciesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID<br />
* [[SpeciesNames|SubspeciesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID<br />
* InfrasubspeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID<br />
* InfrasubKind, integer, 2 bytes, kind of infrasubspecies name<br />
** 0 = [none]<br />
** 1 = form<br />
** 2 = variety<br />
* SuitableForRanks, integer, 1 byte. Suitability indicates if nomenclator row based on a citation may be used to generate a taxon name LSID.<br />
** 0 = not suitable for use: no genus name, no species name when below species name present, any non-scientific name present<br />
** 1 = suitable for genus, subgenus or infragenus<br />
** 2 = suitable for species series, species group or species subgroup<br />
** 3 = suitable for species or lower<br />
* LastUpdate, smalldatetime, date and time of last update<br />
* ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
* CreatedOn, smalldatetime, date and time row was created<br />
* CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
[[Category:CiteRelatedTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/NewNameStatusNewNameStatus2014-02-13T22:22:48Z<p>Dceades: </p>
<hr />
<div>'''tblNewNameStatus''', types of new status for names<br />
<br />
*NewNameStatusID, integer, 4 bytes, values between 11 and 16 used for tblTaxonHistory but not tblCites<br />
**0 = unspecified<br />
**1 = unchanged<br />
**2 = new taxon name (including new misspelling or misapplication)<br />
**3 = made a synonym<br />
**4 = made valid or temporary<br />
**5 = new combination initiated by this citation<br />
**6 = new nomen nudum<br />
**7 = nomen dubium<br />
**8 = missed previous change<br />
**9 = synonym of different taxon<br />
**10 = gender change<br />
**11 = name deleted with no related name<br />
**12 = name deleted, was duplicate protonym<br />
**13 = genus or species lowered to nominotypical sub<br />
**14 = nominotypical sub raised to genus or species<br />
**15 = name replaced by nominotypical sub<br />
**16 = newly created nominotypical sub<br />
**17 = new corrected taxon name (justified emendation, corrected lapsus or nomen nudum made available)<br />
**18 = different combination, may have been initiated by an unlisted previous citation<br />
**19 = made valid in different combination<br />
**20 = data before taxon named<br />
**21 = previous synonymy ended<br />
**22 = misapplied name for misidentified specimen<br />
*UsedForCite, bit, = 0 for NewNameStatusID of 11 to 16 and 21 (used only for tblTaxonHistory), 1 for all other rows (also used for tblCites)<br />
*Name, text, 50 characters maximum<br />
*Explanation, text, 100 characters maximum<br />
*DisplayPosition, integer, 1 byte, used for display sequence in drop down boxes in pages for citations<br />
<br />
[[Category:CiteRelatedTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/TaxonHistoryTaxonHistory2014-02-13T21:59:33Z<p>Dceades: </p>
<hr />
<div>'''tblTaxonHistory''', history of concepts and nomenclature for protonyms.<br />
<br />
*TaxonHistoryID, integer, 4 bytes, primary key, identifier for taxon name and concept.<br />
* [[Taxa|TaxonNameID]], integer, 4 bytes, = tblTaxon.TaxonNameID, identifier for the monomial name (protonym) associated with the history.<br />
* FileID, integer, 4 bytes, = tblFiles.FileID, the species file the row is associated with. This column is being added in late 2013. Old rows with Status = 2 (artifact) remain with FileID = 0.<br />
* SeqNum, integer, 2 bytes, sequence number within this TaxonNameID, 1-based values without gaps.<br />
* [[Nomenclator|NomenclatorID]], integer, 4 bytes, = tblNomenclator.NomenclatorID, identifier for binomial name associated with the history.<br />
* [[Refs|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.<br />
* NewNameStatusID, integer, 4 bytes, status of name when changed<br />
** 0 = unspecified<br />
** 1 = unchanged<br />
** 2 = new taxon name<br />
** 3 = made a synonym<br />
** 4 = made valid or temporary<br />
** 5 = new combination<br />
** 6 = name deleted with no related name<br />
** 7 = name deleted because of duplicate protonym, related name can be found in tblRelatedHistory<br />
** 8 = genus or species lowered to nominotypical sub<br />
** 9 = nominotypical sub raised to genus or species<br />
** 10 = name replaced by nominotypical sub<br />
** 11 = new nominotypical sub<br />
* ConceptChangeID, integer, 4 bytes, values in effect on completion of the change, permitted values:<br />
** 0 = unspecified<br />
** 1 = unchanged<br />
** 2 = new<br />
** 3 = restored<br />
** 4 = expanded<br />
** 5 = shrunk<br />
** 6 = modified<br />
** 7 = terminated<br />
** 8 = transferred<br />
* OtherHistoryID, integer, 4 bytes, = tblTaxonHistory.TaxonHistoryID, identifier for the other history ID involved in a relationship change specified in RelatedHistoryID<br />
* RelatedHistoryID, integer, 4 bytes, = tblRelatedHistory.RelatedHistoryID, identifier for the type of relationship to OtherHistoryID<br />
* UserConfirmed, bit, 1 = user has confirmed data in this row or generated from user supplied data in tblCites<br />
* UnreliableAssumption, bit, 1 = program used an unreliable assumption to create row<br />
* ArbitraryRow, bit, 1 = arbitrary row generated by program to resolve conflict, user resolution needed<br />
* Note, text, 300 characters 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.<br />
* Status, integer, 1 byte, status of the row<br />
** 0 = active<br />
** 1 = dormant, used for deleted nominotypical subs, which might be re-instated at a later time<br />
** 2 = artifact, used for rows erroneously added. The row cannot be deleted once TaxonHistoryID has been exposed in a GUID for a taxon concept. But does that ever happen?<br />
** 3 = moved to other species file identified in Note<br />
** 4 = moved out of scope<br />
* LastUpdate, smalldatetime, date and time row last updated<br />
* ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
* CreatedOn, smalldatetime, date and time row was created<br />
* CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
[[Category:TaxaTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/Taxa_(table)Taxa (table)2014-01-21T23:17:10Z<p>Dceades: </p>
<hr />
<div>'''tblTaxa''' contains taxon names at all ranks, including synonyms and other non valid names.<br />
<br />
*TaxonNameID, integer, 4 bytes, unique identifier for the taxon name. This number can be used to enter the database at this name.<br />
*FileID, integer, 4 bytes, = tblFiles.FileID<br />
*TaxonNameStr, text, 300 characters maximum. A series of TaxonNameID in text form and separated by "-". <br />
**If a taxon is at genus rank and is not a synonym, the text of TaxonNameID is followed by "g". This makes forming binomial names more efficient.<br />
**If a taxon is at subgenus rank and is not a synonym, the text of TaxonNameID is followed by "s".<br />
**For all taxa immediately subordinate to the apex taxon, TaxonNameStr begins with the TaxonNameID of the apex taxon followed by "-" (or "g-" if the apex taxon is at genus rank) and the TaxonNameID of the subordinate.<br />
**The chain of TaxonNameIDs grows moving down the hierarchy by adding "-" and the TaxonNameID (and "g" or "s" when appropriate).<br />
**For all taxa outside the primary scope, TaxonNameStr begins with "0-".<br />
***For genera (and rarely other ranks) outside the primary scope, TaxonNameStr begins with "0-0-". This is needed for tblTaxa.OriginalGenusID, for genera in nomenclator information for citations, and for taxa providing images or sounds.<br />
***For context taxa outside the primary scope, TaxonNameStr begins with "0-1-". Such taxa provide some context around the apex taxon.<br />
***For taxa previously within the primary scope but now outside, TaxonNameStr begins with "0-2-". This enables finding such taxa in searches so that users can be told about the change in status.<br />
***For reserved values of TaxonNameID, TaxonNameStr begins with "0-3-". These values are held in reserve for when private species files are merged.<br />
***For family-group taxa outside the primary scope (needed for tblTypeSpecies.FirstFamGrpNameID), TaxonNameStr begins with "0-4-".<br />
*RankID, integer, 4 bytes, = tblRanks.RankID, number for rank in hierarchy<br />
*Name, text, 30 characters maximum, name of taxon<br />
*Parens, boolean, enclose author name in parens?<br />
*AboveID, integer, 4 bytes, = tblTaxa.TaxonNameID of the next higher taxon in the hierarchy. If this taxon is a synonym or other not valid name, then this is the TaxonNameID for the valid taxon.<br />
*LikeNameID, integer 4 bytes, = 0 unless this is a special case. Special cases are<br />
**Valid or temporary taxa<br />
***Genus, then = tblTaxa.TaxonNameID of subgenus by same name<br />
***Subgenus, then = tblTaxa.TaxonNameID of genus by same name<br />
***Species, then = tblTaxa.TaxonNameID of subspecies by same name<br />
***Subspecies, then = tblTaxa.TaxonNameID of species by same name<br />
*Extinct, integer, 1 byte, 0 = extant, 1 = extinct; if NameStatus = 7 (synonym), then the value of Extinct is ignored. Could be changed to allow additional values such as threatened, endangered and presumed extirpated.<br />
*HasPreHolocene, bit, 0 = no fossils, 1 = one or more fossils are known to exist; if NameStatus = 7 (synonym), then the value of HasPreHolocene is ignored.<br />
*HasModern, bit, 0 = no Recent specimens, 1 = one or more Recent specimens are known to exist; if NameStatus = 7(synonym), then the value of HasModern is ignored.<br />
*RefID, integer, 4 bytes, = tblRefs.RefID for the original description of the taxon. CAUTION: For family-group taxa, this is the first use of the name in its current form. The author and date for priority are based on the first use of any name based on the same type genus. To locate this information, trace via tblTypeGenera.GenusNameID to tblTypeSpecies.FirstFamGrpNameID to tblTaxa.RefID of that first name. For taxa above superfamily rank, RefID is always 0. Taxa at a rank above species and below subgenus also have RefID = 0.<br />
*NecAuthor, text, 200 characters maximum, author who used name correctly sometimes with additional information<br />
*DataFlags, integer, 2 bytes, with bitwise flags for type of data present<br />
**1 = image<br />
**2 = sound<br />
**4 = link to other website<br />
**8 = specimen data<br />
**0x10 (16) = scrutiny<br />
**0x20 (32) = key group<br />
**0x40 (64) = supplementary information<br />
**0x80 (128) = common name<br />
**0x100 (256) = related taxon<br />
**0x200 (512) = automatic link to other website<br />
**0x400 (1024) = ecological relationship<br />
**0x800 (2048) = valid taxon name string (used exclusively in spTestAboveIDvsTaxonNameStr)<br />
**0x1000 (4096) = has specimen(s) with latitude/longitude data useable for maps, applies to taxa at rank tribe or lower<br />
*AccessCode, integer, 4 bytes, = tblAccessCodes.AccessCode<br />
*NameStatus, integer, 1 byte<br />
**0 = valid<br />
**2 = temporary name for use until a valid name is provided (subordinate names limited to temporary names and synonyms)<br />
**4 = nomen nudum, must be at lower rank than parent (subordinate names limited to nomina nuda)<br />
**5 = nomen dubium, must be at lower rank than parent (subordinate names limited to nomina nuda and dubia)<br />
**7 = synonym (subordinate taxa not allowed)<br />
*StatusFlags, integer, 4 bytes, interpreted bitwise. We have run out of bits. To solve this, some flags will be moved to a new column UnavailFlags.<br />
**1 = informal name, compatible only with tblTaxa.NameStatus = 2 or 7. Will be moved to UnavailFlags.<br />
**2 = subsequent misspelling, compatible only with tblTaxa.NameStatus = 7. Will be moved to UnavailFlags.<br />
**4 = unjustified emendation, compatible only with tblTaxa.NameStatus = 7. New value will be 1.<br />
**8 = nomen nudum, compatible only with tblTaxa.NameStatus = 2 or 4 when rank is less than parent rank or = 7 when rank is same as parent. Will be moved to UnavailFlags.<br />
**0x10 (16) = nomen dubium, compatible only with tblTaxa.NameStatus = 5 when rank is less than parent rank or = 7 when rank is same as parent. New value will be 2.<br />
**0x20 (32) = incertae sedis, compatible only with tblTaxa.NameStatus = 0 or 2. New value will be 4.<br />
**0x40 (64) = required emendation, compatible only with tblTaxa.NameStatus = 0, 2 or 7. New value will be 8.<br />
**0x80 (128) = nomen protectum, compatible only with tblTaxa.NameStatus = 0 or 7. New value will be 0x10.<br />
**0x100 (256) = suppressed, compatible only with tblTaxa.NameStatus = 7. Will be moved to UnavailFlags.<br />
**0x200 (512) = misapplied, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7. Will be moved to UnavailFlags.<br />
**0x400 (1024) = preoccupied (genus-group names), compatible only with tblTaxa.NameStatus = 2 or 7. Will be moved to UnavailFlags.<br />
**0x800 (2048) = primary homonym (species-group names), compatible only with tblTaxa.NameStatus = 2 or 7. Will be moved to UnavailFlags.<br />
**0x1000 (4096) = secondary homonym (species-group names), compatible only with tblTaxa.NameStatus = 2 or 7. New value will be 0x20.<br />
**0x2000 (8192) = nomen oblitum, compatible only with tblTaxa.NameStatus = 7. New value will be 0x40.<br />
**0x4000 (16384) = unnecessary replacement name, compatible only with tblTaxa.NameStatus = 7. New value will be 0x80.<br />
**0x8000 (32768) = incorrect original spelling, compatible only with tblTaxa.Namestatus = 2, 4, 5 or 7. Will be moved to UnavailFlags.<br />
**0x10000 (65536) = other, explained by tblTaxa.Comment, compatible only with tblTaxa.NameStatus = 0, 2 or 7. New value will be 0x100.<br />
**0x20000 (131072) = unavailable, other reason, compatible only with tblTaxa.NameStatus = 2 or 7.<br />
**0x40000 (262144) = junior synonym, compatible only with tblTaxa.NameStatus = 7.<br />
**0x80000 (524288) = nomen novum, compatible only with tblTaxa.Namestatus = 0, 2, or 7.<br />
**0x100000 (1048576) = original name, used only for family-group names, compatible only with tblTaxa.NameStatus = 7.<br />
**0x200000 (2097152) = subsequent name, used only for family-group names, compatible with any tblTaxa.NameStatus value.<br />
**0x400000 (4194304) = junior homonym for species-group name not specified as primary or secondary, compatible only with tblTaxa.NameStatus = 2 or 7.<br />
**0x800000 (8388608) = lapsus calami, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7.<br />
**0x1000000 (16777216) = corrected lapsus calami, compatible only with tblTaxa.NameStatus = 0, 2 or 7. **0x2000000 (33554432) = nomen nudum made available, compatible only with tblTaxa.NameStatus = 0, 2 or 7.<br />
**Notes about StatusFlags.<br />
***Type data for taxa is available based on rank and name status:<br />
****No type data for ranks above superfamily.<br />
****No type data for ranks of subgenus through superfamily with name status of misapplied (0x200).<br />
****No type data for ranks above species and below subgenus.<br />
****No type data for ranks of species level and below for emendation (unjustified and required), misspelling, nomen nudum, unnecessary replacement, nomen novum, and misapplied (0x8424E) OR NameStatus = 4 (nomen nudum).<br />
***Age qualification is required for the following NameStatus values:<br />
****Junior synonym must not be older than the valid name.<br />
****Unjustified emendation, misspelling, and unnecessary replacement must not be older than the correct name.<br />
****Incorrectly formed name must not be younger than the justified emendation name.<br />
****Nomen novum must not be younger than the homonym replaced.<br />
****Nomen oblitum must not be younger than the valid name.<br />
***Taxa may have more than one status flag set. However, there are restrictions for certain status values. Unless stated below, more than one status flag may be set:<br />
****Emendation is not compatible with misspelling, unnecessary replacement, nomen nudum, incorrect original spelling, and misapplied.<br />
****Misspelling is not compatible with with emendation, unnecessary replacement, nomen nudum, incorrect original spelling, junior synonym, and misapplied.<br />
****Unnecessary replacement is not compatible with emendation, misspelling, junior synonym, and misapplied.<br />
****Nomen nudum is not compatible with emendation, misspelling, junior synonym, and misapplied.<br />
****Incorrect original spelling is not compatible with misspelling, unnecessary replacement, nomen nudum, and misapplied.<br />
****Junior synonym is not compatible with misspelling, unnecessary replacement, nomen nudum, and misapplied.<br />
****Misapplied is not compatible with emendation, misspelling, unnecessary replacement, nomen nudum, incorrect original spelling, junior synonym, and misapplied.<br />
****Note that, theoretically, the following status values may be used in combination with any other status value, but in some cases this may be illogical: Junior homonym, suppressed by ruling, unavailable (other reason), incertae sedis, nomen dubium, nomen oblitum, nomen novum, nomen protectum, unnamed.<br />
*OriginalGenusID, integer, 4 bytes, = tblTaxa.TaxonNameID, used only for species-group taxa other than a species that has subspecies, TaxonNameID for the genus in which the species was originally described, = 0 if unknown, -1 identifies cases where the previously recorded original genus did not exist when the species was described. If a genus and subgenus have the same name, use the TaxonNameID of the subgenus.<br />
*Distribution, text, 400 characters maximum.<br />
*Ecology, text, 400 characters maximum.<br />
*Comment, text, 400 characters maximum, explanation relating to the status of the name.<br />
*ExpertID, integer, 4 bytes, = tblExperts.ExpertID for the person recorded as expert for this taxon<br />
*ExpertReason, integer, 1 byte, reason expert assigned, 0 = no expert assigned, 1 = by default, 2 = by hierarchy only, 3 = by hierarchy and geography, 11 = cascaded by default, 12 = cascaded by hierarchy only, 13 = cascaded by hierarchy and geography<br />
**When a new taxon is created or a taxon becomes valid, the ExpertID is copied from the new AboveID. If the ExpertID and ExpertReason of the AboveID is 0, the new/now valid taxon values are also 0. If the ExpertReason of the AboveID is less than 10 (but greater than 0), add 10 to the ExpertReason of the AboveID to derive the ExpertReason value for the new/now valid taxon. Use the same ExpertReason value for the new/now valid taxon if the ExpertReason of the AboveID is greater than 9.<br />
*CurrentConceptRefID, integer, 4 bytes, = tblRefs.RefID, identifies the reference that initiated the currently accepted concept. If there is no currently accepted concept for the name, then this is the reference that terminated the concept.<br />
*LifeZone, integer, 1 byte, bit values:<br />
**1 = Marine<br />
**2 = Brackish<br />
**4 = Freshwater<br />
**8 = Terrestrial<br />
*LastUpdate, smalldatetime, date and time row last updated<br />
*ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
*CreatedOn, smalldatetime, date and time row was created<br />
*CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
[[Category:TaxaTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/Taxa_(table)Taxa (table)2014-01-21T23:14:02Z<p>Dceades: </p>
<hr />
<div>'''tblTaxa''' contains taxon names at all ranks, including synonyms and other non valid names.<br />
<br />
*TaxonNameID, integer, 4 bytes, unique identifier for the taxon name. This number can be used to enter the database at this name.<br />
*FileID, integer, 4 bytes, = tblFiles.FileID<br />
*TaxonNameStr, text, 300 characters maximum. A series of TaxonNameID in text form and separated by "-". <br />
**If a taxon is at genus rank and is not a synonym, the text of TaxonNameID is followed by "g". This makes forming binomial names more efficient.<br />
**If a taxon is at subgenus rank and is not a synonym, the text of TaxonNameID is followed by "s".<br />
**For all taxa immediately subordinate to the apex taxon, TaxonNameStr begins with the TaxonNameID of the apex taxon followed by "-" (or "g-" if the apex taxon is at genus rank) and the TaxonNameID of the subordinate.<br />
**The chain of TaxonNameIDs grows moving down the hierarchy by adding "-" and the TaxonNameID (and "g" or "s" when appropriate).<br />
**For all taxa outside the primary scope, TaxonNameStr begins with "0-".<br />
***For genera (and rarely other ranks) outside the primary scope, TaxonNameStr begins with "0-0-". This is needed for tblTaxa.OriginalGenusID, for genera in nomenclator information for citations, and for taxa providing images or sounds.<br />
***For context taxa outside the primary scope, TaxonNameStr begins with "0-1-". Such taxa provide some context around the apex taxon.<br />
***For taxa previously within the primary scope but now outside, TaxonNameStr begins with "0-2-". This enables finding such taxa in searches so that users can be told about the change in status.<br />
***For reserved values of TaxonNameID, TaxonNameStr begins with "0-3-". These values are held in reserve for when private species files are merged.<br />
***For family-group taxa outside the primary scope (needed for tblTypeSpecies.FirstFamGrpNameID), TaxonNameStr begins with "0-4-".<br />
*RankID, integer, 4 bytes, = tblRanks.RankID, number for rank in hierarchy<br />
*Name, text, 30 characters maximum, name of taxon<br />
*Parens, boolean, enclose author name in parens?<br />
*AboveID, integer, 4 bytes, = tblTaxa.TaxonNameID of the next higher taxon in the hierarchy. If this taxon is a synonym or other not valid name, then this is the TaxonNameID for the valid taxon. AboveID cannot be the TaxonNameID for a genus having subgenera or a species having subspecies: In those cases, use the TaxonNameID of the nominotypical subgenus or subspecies.<br />
*LikeNameID, integer 4 bytes, = 0 unless this is a special case. Special cases are<br />
**Valid or temporary taxa<br />
***Genus, then = tblTaxa.TaxonNameID of subgenus by same name<br />
***Subgenus, then = tblTaxa.TaxonNameID of genus by same name<br />
***Species, then = tblTaxa.TaxonNameID of subspecies by same name<br />
***Subspecies, then = tblTaxa.TaxonNameID of species by same name<br />
*Extinct, integer, 1 byte, 0 = extant, 1 = extinct; if NameStatus = 7 (synonym), then the value of Extinct is ignored. Could be changed to allow additional values such as threatened, endangered and presumed extirpated.<br />
*HasPreHolocene, bit, 0 = no fossils, 1 = one or more fossils are known to exist; if NameStatus = 7 (synonym), then the value of HasPreHolocene is ignored.<br />
*HasModern, bit, 0 = no Recent specimens, 1 = one or more Recent specimens are known to exist; if NameStatus = 7(synonym), then the value of HasModern is ignored.<br />
*RefID, integer, 4 bytes, = tblRefs.RefID for the original description of the taxon. CAUTION: For family-group taxa, this is the first use of the name in its current form. The author and date for priority are based on the first use of any name based on the same type genus. To locate this information, trace via tblTypeGenera.GenusNameID to tblTypeSpecies.FirstFamGrpNameID to tblTaxa.RefID of that first name. For taxa above superfamily rank, RefID is always 0. Taxa at a rank above species and below subgenus also have RefID = 0.<br />
*NecAuthor, text, 200 characters maximum, author who used name correctly sometimes with additional information<br />
*DataFlags, integer, 2 bytes, with bitwise flags for type of data present<br />
**1 = image<br />
**2 = sound<br />
**4 = link to other website<br />
**8 = specimen data<br />
**0x10 (16) = scrutiny<br />
**0x20 (32) = key group<br />
**0x40 (64) = supplementary information<br />
**0x80 (128) = common name<br />
**0x100 (256) = related taxon<br />
**0x200 (512) = automatic link to other website<br />
**0x400 (1024) = ecological relationship<br />
**0x800 (2048) = valid taxon name string (used exclusively in spTestAboveIDvsTaxonNameStr)<br />
**0x1000 (4096) = has specimen(s) with latitude/longitude data useable for maps, applies to taxa at rank tribe or lower<br />
*AccessCode, integer, 4 bytes, = tblAccessCodes.AccessCode<br />
*NameStatus, integer, 1 byte<br />
**0 = valid<br />
**2 = temporary name for use until a valid name is provided (subordinate names limited to temporary names and synonyms)<br />
**4 = nomen nudum, must be at lower rank than parent (subordinate names limited to nomina nuda)<br />
**5 = nomen dubium, must be at lower rank than parent (subordinate names limited to nomina nuda and dubia)<br />
**7 = synonym (subordinate taxa not allowed)<br />
*StatusFlags, integer, 4 bytes, interpreted bitwise. We have run out of bits. To solve this, some flags will be moved to a new column UnavailFlags.<br />
**1 = informal name, compatible only with tblTaxa.NameStatus = 2 or 7. Will be moved to UnavailFlags.<br />
**2 = subsequent misspelling, compatible only with tblTaxa.NameStatus = 7. Will be moved to UnavailFlags.<br />
**4 = unjustified emendation, compatible only with tblTaxa.NameStatus = 7. New value will be 1.<br />
**8 = nomen nudum, compatible only with tblTaxa.NameStatus = 2 or 4 when rank is less than parent rank or = 7 when rank is same as parent. Will be moved to UnavailFlags.<br />
**0x10 (16) = nomen dubium, compatible only with tblTaxa.NameStatus = 5 when rank is less than parent rank or = 7 when rank is same as parent. New value will be 2.<br />
**0x20 (32) = incertae sedis, compatible only with tblTaxa.NameStatus = 0 or 2. New value will be 4.<br />
**0x40 (64) = required emendation, compatible only with tblTaxa.NameStatus = 0, 2 or 7. New value will be 8.<br />
**0x80 (128) = nomen protectum, compatible only with tblTaxa.NameStatus = 0 or 7. New value will be 0x10.<br />
**0x100 (256) = suppressed, compatible only with tblTaxa.NameStatus = 7. Will be moved to UnavailFlags.<br />
**0x200 (512) = misapplied, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7. Will be moved to UnavailFlags.<br />
**0x400 (1024) = preoccupied (genus-group names), compatible only with tblTaxa.NameStatus = 2 or 7. Will be moved to UnavailFlags.<br />
**0x800 (2048) = primary homonym (species-group names), compatible only with tblTaxa.NameStatus = 2 or 7. Will be moved to UnavailFlags.<br />
**0x1000 (4096) = secondary homonym (species-group names), compatible only with tblTaxa.NameStatus = 2 or 7. New value will be 0x20.<br />
**0x2000 (8192) = nomen oblitum, compatible only with tblTaxa.NameStatus = 7. New value will be 0x40.<br />
**0x4000 (16384) = unnecessary replacement name, compatible only with tblTaxa.NameStatus = 7. New value will be 0x80.<br />
**0x8000 (32768) = incorrect original spelling, compatible only with tblTaxa.Namestatus = 2, 4, 5 or 7. Will be moved to UnavailFlags.<br />
**0x10000 (65536) = other, explained by tblTaxa.Comment, compatible only with tblTaxa.NameStatus = 0, 2 or 7. New value will be 0x100.<br />
**0x20000 (131072) = unavailable, other reason, compatible only with tblTaxa.NameStatus = 2 or 7.<br />
**0x40000 (262144) = junior synonym, compatible only with tblTaxa.NameStatus = 7.<br />
**0x80000 (524288) = nomen novum, compatible only with tblTaxa.Namestatus = 0, 2, or 7.<br />
**0x100000 (1048576) = original name, used only for family-group names, compatible only with tblTaxa.NameStatus = 7.<br />
**0x200000 (2097152) = subsequent name, used only for family-group names, compatible with any tblTaxa.NameStatus value.<br />
**0x400000 (4194304) = junior homonym for species-group name not specified as primary or secondary, compatible only with tblTaxa.NameStatus = 2 or 7.<br />
**0x800000 (8388608) = lapsus calami, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7.<br />
**0x1000000 (16777216) = corrected lapsus calami, compatible only with tblTaxa.NameStatus = 0, 2 or 7. **0x2000000 (33554432) = nomen nudum made available, compatible only with tblTaxa.NameStatus = 0, 2 or 7.<br />
**Notes about StatusFlags.<br />
***Type data for taxa is available based on rank and name status:<br />
****No type data for ranks above superfamily.<br />
****No type data for ranks of subgenus through superfamily with name status of misapplied (0x200).<br />
****No type data for ranks above species and below subgenus.<br />
****No type data for ranks of species level and below for emendation (unjustified and required), misspelling, nomen nudum, unnecessary replacement, nomen novum, and misapplied (0x8424E) OR NameStatus = 4 (nomen nudum).<br />
***Age qualification is required for the following NameStatus values:<br />
****Junior synonym must not be older than the valid name.<br />
****Unjustified emendation, misspelling, and unnecessary replacement must not be older than the correct name.<br />
****Incorrectly formed name must not be younger than the justified emendation name.<br />
****Nomen novum must not be younger than the homonym replaced.<br />
****Nomen oblitum must not be younger than the valid name.<br />
***Taxa may have more than one status flag set. However, there are restrictions for certain status values. Unless stated below, more than one status flag may be set:<br />
****Emendation is not compatible with misspelling, unnecessary replacement, nomen nudum, incorrect original spelling, and misapplied.<br />
****Misspelling is not compatible with with emendation, unnecessary replacement, nomen nudum, incorrect original spelling, junior synonym, and misapplied.<br />
****Unnecessary replacement is not compatible with emendation, misspelling, junior synonym, and misapplied.<br />
****Nomen nudum is not compatible with emendation, misspelling, junior synonym, and misapplied.<br />
****Incorrect original spelling is not compatible with misspelling, unnecessary replacement, nomen nudum, and misapplied.<br />
****Junior synonym is not compatible with misspelling, unnecessary replacement, nomen nudum, and misapplied.<br />
****Misapplied is not compatible with emendation, misspelling, unnecessary replacement, nomen nudum, incorrect original spelling, junior synonym, and misapplied.<br />
****Note that, theoretically, the following status values may be used in combination with any other status value, but in some cases this may be illogical: Junior homonym, suppressed by ruling, unavailable (other reason), incertae sedis, nomen dubium, nomen oblitum, nomen novum, nomen protectum, unnamed.<br />
*OriginalGenusID, integer, 4 bytes, = tblTaxa.TaxonNameID, used only for species-group taxa other than a species that has subspecies, TaxonNameID for the genus in which the species was originally described, = 0 if unknown, -1 identifies cases where the previously recorded original genus did not exist when the species was described. If a genus and subgenus have the same name, use the TaxonNameID of the subgenus.<br />
*Distribution, text, 400 characters maximum.<br />
*Ecology, text, 400 characters maximum.<br />
*Comment, text, 400 characters maximum, explanation relating to the status of the name.<br />
*ExpertID, integer, 4 bytes, = tblExperts.ExpertID for the person recorded as expert for this taxon<br />
*ExpertReason, integer, 1 byte, reason expert assigned, 0 = no expert assigned, 1 = by default, 2 = by hierarchy only, 3 = by hierarchy and geography, 11 = cascaded by default, 12 = cascaded by hierarchy only, 13 = cascaded by hierarchy and geography<br />
**When a new taxon is created or a taxon becomes valid, the ExpertID is copied from the new AboveID. If the ExpertID and ExpertReason of the AboveID is 0, the new/now valid taxon values are also 0. If the ExpertReason of the AboveID is less than 10 (but greater than 0), add 10 to the ExpertReason of the AboveID to derive the ExpertReason value for the new/now valid taxon. Use the same ExpertReason value for the new/now valid taxon if the ExpertReason of the AboveID is greater than 9.<br />
*CurrentConceptRefID, integer, 4 bytes, = tblRefs.RefID, identifies the reference that initiated the currently accepted concept. If there is no currently accepted concept for the name, then this is the reference that terminated the concept.<br />
*LifeZone, integer, 1 byte, bit values:<br />
**1 = Marine<br />
**2 = Brackish<br />
**4 = Freshwater<br />
**8 = Terrestrial<br />
*LastUpdate, smalldatetime, date and time row last updated<br />
*ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
*CreatedOn, smalldatetime, date and time row was created<br />
*CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
[[Category:TaxaTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/Taxa_(table)Taxa (table)2014-01-21T23:11:31Z<p>Dceades: </p>
<hr />
<div>'''tblTaxa''' contains taxon names at all ranks, including synonyms and other non valid names.<br />
<br />
*TaxonNameID, integer, 4 bytes, unique identifier for the taxon name. This number can be used to enter the database at this name.<br />
*FileID, integer, 4 bytes, = tblFiles.FileID<br />
*TaxonNameStr, text, 300 characters maximum. A series of TaxonNameID in text form and separated by "-". <br />
**If a taxon is at genus rank and is not a synonym, the text of TaxonNameID is followed by "g". This makes forming binomial names more efficient.<br />
**If a taxon is at subgenus rank and is not a synonym, the text of TaxonNameID is followed by "s".<br />
**For all taxa immediately subordinate to the apex taxon, TaxonNameStr begins with the TaxonNameID of the apex taxon followed by "-" (or "g-" if the apex taxon is at genus rank) and the TaxonNameID of the subordinate.<br />
**The chain of TaxonNameIDs grows moving down the hierarchy by adding "-" and the TaxonNameID (and "g" or "s" when appropriate).<br />
**For all taxa outside the primary scope, TaxonNameStr begins with "0-".<br />
***For genera (and rarely other ranks) outside the primary scope, TaxonNameStr begins with "0-0-". This is needed for tblTaxa.OriginalGenusID, for genera in nomenclator information for citations, and for taxa providing images or sounds.<br />
***For context taxa outside the primary scope, TaxonNameStr begins with "0-1-". Such taxa provide some context around the apex taxon.<br />
***For taxa previously within the primary scope but now outside, TaxonNameStr begins with "0-2-". This enables finding such taxa in searches so that users can be told about the change in status.<br />
***For reserved values of TaxonNameID, TaxonNameStr begins with "0-3-". These values are held in reserve for when private species files are merged.<br />
***For family-group taxa outside the primary scope (needed for tblTypeSpecies.FirstFamGrpNameID), TaxonNameStr begins with "0-4-".<br />
*RankID, integer, 4 bytes, = tblRanks.RankID, number for rank in hierarchy<br />
*Name, text, 30 characters maximum, name of taxon<br />
*Parens, boolean, enclose author name in parens?<br />
*AboveID, integer, 4 bytes, = tblTaxa.TaxonNameID of the next higher taxon in the hierarchy. If this taxon is a synonym or other not valid name, then this is the TaxonNameID for the valid taxon. AboveID cannot be the TaxonNameID for a genus having subgenera or a species having subspecies: In those cases, use the TaxonNameID of the nominotypical subgenus or subspecies.<br />
*LikeNameID, integer 4 bytes, = 0 unless this is a special case. Special cases are<br />
**Valid or temporary taxa<br />
***Genus, then = tblTaxa.TaxonNameID of subgenus by same name<br />
***Subgenus, then = tblTaxa.TaxonNameID of genus by same name<br />
***Species, then = tblTaxa.TaxonNameID of subspecies by same name<br />
***Subspecies, then = tblTaxa.TaxonNameID of species by same name<br />
*Extinct, integer, 1 byte, 0 = extant, 1 = extinct; if NameStatus = 7 (synonym), then the value of Extinct is ignored. Could be changed to allow additional values such as threatened, endangered and presumed extirpated.<br />
*HasPreHolocene, bit, 0 = no fossils, 1 = one or more fossils are known to exist; if NameStatus = 7 (synonym), then the value of HasPreHolocene is ignored.<br />
*HasModern, bit, 0 = no Recent specimens, 1 = one or more Recent specimens are known to exist; if NameStatus = 7(synonym), then the value of HasModern is ignored.<br />
*RefID, integer, 4 bytes, = tblRefs.RefID for the original description of the taxon. CAUTION: For family-group taxa, this is the first use of the name in its current form. The author and date for priority are based on the first use of any name based on the same type genus. To locate this information, trace via tblTypeGenera.GenusNameID to tblTypeSpecies.FirstFamGrpNameID to tblTaxa.RefID of that first name. For taxa above superfamily rank, RefID is always 0. Taxa at a rank above species and below subgenus also have RefID = 0.<br />
*NecAuthor, text, 200 characters maximum, author who used name correctly sometimes with additional information<br />
*DataFlags, integer, 2 bytes, with bitwise flags for type of data present<br />
**1 = image<br />
**2 = sound<br />
**4 = link to other website<br />
**8 = specimen data<br />
**0x10 (16) = scrutiny<br />
**0x20 (32) = key group<br />
**0x40 (64) = supplementary information<br />
**0x80 (128) = common name<br />
**0x100 (256) = related taxon<br />
**0x200 (512) = automatic link to other website<br />
**0x400 (1024) = ecological relationship<br />
**0x800 (2048) = valid taxon name string (used exclusively in spTestAboveIDvsTaxonNameStr)<br />
**0x1000 (4096) = has specimen(s) with latitude/longitude data useable for maps, applies to taxa at rank tribe or lower<br />
*AccessCode, integer, 4 bytes, = tblAccessCodes.AccessCode<br />
*NameStatus, integer, 1 byte<br />
**0 = valid<br />
**2 = temporary name for use until a valid name is provided (subordinate names limited to temporary names and synonyms)<br />
**4 = nomen nudum, must be at lower rank than parent (subordinate names limited to nomina nuda)<br />
**5 = nomen dubium, must be at lower rank than parent (subordinate names limited to nomina nuda and dubia)<br />
**7 = synonym (subordinate taxa not allowed)<br />
*StatusFlags, integer, 4 bytes, interpreted bitwise. We have run out of bits. To solve this, some flags will be moved to a new column UnavailFlags.<br />
**1 = informal name, compatible only with tblTaxa.NameStatus = 2 or 7. Will be moved to UnavailFlags.<br />
**2 = subsequent misspelling, compatible only with tblTaxa.NameStatus = 7. Will be moved to UnavailFlags.<br />
**4 = unjustified emendation, compatible only with tblTaxa.NameStatus = 7. New value will be 1.<br />
**8 = nomen nudum, compatible only with tblTaxa.NameStatus = 2 or 4 when rank is less than parent rank or = 7 when rank is same as parent. Will be moved to UnavailFlags.<br />
**0x10 (16) = nomen dubium, compatible only with tblTaxa.NameStatus = 5 when rank is less than parent rank or = 7 when rank is same as parent. New value will be 2.<br />
**0x20 (32) = incertae sedis, compatible only with tblTaxa.NameStatus = 0 or 2. New value will be 4.<br />
**0x40 (64) = required emendation, compatible only with tblTaxa.NameStatus = 0, 2 or 7. New value will be 8.<br />
**0x80 (128) = nomen protectum, compatible only with tblTaxa.NameStatus = 0 or 7. New value will be 0x10.<br />
**0x100 (256) = suppressed, compatible only with tblTaxa.NameStatus = 7. Will be moved to UnavailFlags.<br />
**0x200 (512) = misapplied, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7. Will be moved to UnavailFlags.<br />
**0x400 (1024) = preoccupied (genus-group names), compatible only with tblTaxa.NameStatus = 2 or 7. Will be moved to UnavailFlags.<br />
**0x800 (2048) = primary homonym (species-group names), compatible only with tblTaxa.NameStatus = 2 or 7. Will be moved to UnavailFlags.<br />
**0x1000 (4096) = secondary homonym (species-group names), compatible only with tblTaxa.NameStatus = 2 or 7. New value will be 0x20.<br />
**0x2000 (8192) = nomen oblitum, compatible only with tblTaxa.NameStatus = 7. New value will be 0x40.<br />
**0x4000 (16384) = unnecessary replacement name, compatible only with tblTaxa.NameStatus = 7. New value will be 0x80.<br />
**0x8000 (32768) = incorrect original spelling, compatible only with tblTaxa.Namestatus = 2, 4, 5 or 7. Will be moved to UnavailFlags.<br />
**0x10000 (65536) = other, explained by tblTaxa.Comment, compatible only with tblTaxa.NameStatus = 0, 2 or 7. New value will be 0x100.<br />
**0x20000 (131072) = unavailable, other reason, compatible only with tblTaxa.NameStatus = 2 or 7.<br />
**0x40000 (262144) = junior synonym, compatible only with tblTaxa.NameStatus = 7.<br />
**0x80000 (524288) = nomen novum, compatible only with tblTaxa.Namestatus = 0, 2, or 7.<br />
**0x100000 (1048576) = original name, used only for family-group names, compatible only with tblTaxa.NameStatus = 7.<br />
**0x200000 (2097152) = subsequent name, used only for family-group names, compatible with any tblTaxa.NameStatus value.<br />
**0x400000 (4194304) = junior homonym for species-group name not specified as primary or secondary, compatible only with tblTaxa.NameStatus = 2 or 7.<br />
**0x800000 (8388608) = lapsus calami, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7.<br />
**0x1000000 (16777216) = corrected lapsus calami, compatible only with tblTaxa.NameStatus = 0, 2 or 7. **0x2000000 (33554432) = nomen nudum made available, compatible only with tblTaxa.NameStatus = 0, 2 or 7.<br />
**Notes about StatusFlags.<br />
***Type data for taxa is available based on rank and name status:<br />
****No type data for ranks above superfamily.<br />
****No type data for ranks of subgenus through superfamily with name status of misapplied (0x200).<br />
****No type data for ranks above species and below subgenus.<br />
****No type data for ranks of species level and below for emendation (unjustified and required), misspelling, nomen nudum, unnecessary replacement, nomen novum, and misapplied (0x8424E) OR NameStatus = 4 (nomen nudum).<br />
***Age qualification is required for the following NameStatus values:<br />
****Junior synonym must not be older than the valid name.<br />
****Unjustified emendation, misspelling, and unnecessary replacement must not be older than the correct name.<br />
****Incorrectly formed name must not be younger than the justified emendation name.<br />
****Nomen novum must not be younger than the homonym replaced.<br />
****Nomen oblitum must not be younger than the valid name.<br />
***Taxa may have more than one status flag set. However, there are restrictions for certain status values. Unless stated below, more than one status flag may be set:<br />
****Emendation is not compatible with misspelling, unnecessary replacement, nomen nudum, incorrect original spelling, and misapplied.<br />
****Misspelling is not compatible with with emendation, unnecessary replacement, nomen nudum, incorrect original spelling, junior synonym, and misapplied.<br />
****Unnecessary replacement is not compatible with emendation, misspelling, junior synonym, and misapplied.<br />
****Nomen nudum is not compatible with emendation, misspelling, junior synonym, and misapplied.<br />
****Incorrect original spelling is not compatible with misspelling, unnecessary replacement, nomen nudum, and misapplied.<br />
****Junior synonym is not compatible with misspelling, unnecessary replacement, nomen nudum, and misapplied.<br />
****Misapplied is not compatible with emendation, misspelling, unnecessary replacement, nomen nudum, incorrect original spelling, junior synonym, and misapplied.<br />
****Note that, theoretically, the following status values may be used in combination with any other status value, but in some cases this may be illogical: Junior homonym, suppressed by ruling, unavailable (other reason), incertae sedis, nomen dubium, nomen oblitum, nomen novum, nomen protectum, unnamed.<br />
*UnavailFlags, integer, 4 bytes, interpreted bitwise. This new column will contain flags moved here from StatusFlags.<br />
**1 = informal name, compatible only with tblTaxa.NameStatus = 2 or 7<br />
**2 = subsequent misspelling, compatible only with tblTaxa.NameStatus = 7<br />
**4 = nomen nudum, compatible only with tblTaxa.NameStatus = 2 or 4 when rank is less than parent rank or = 7 when rank is same as parent<br />
**8 = suppressed, compatible only with tblTaxa.NameStatus = 7<br />
**0x10 (16) = misapplied, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7<br />
**0x20 (32) = preoccupied (genus-group names), compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x40 (64) = primary homonym (species-group names), compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x80 (128) = incorrect original spelling, compatible only with tblTaxa.Namestatus = 2, 4, 5 or 7<br />
**0x100 (256) = unavailable, other reason, compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x200 (512) = lapsus calami, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7<br />
*OriginalGenusID, integer, 4 bytes, = tblTaxa.TaxonNameID, used only for species-group taxa other than a species that has subspecies, TaxonNameID for the genus in which the species was originally described, = 0 if unknown, -1 identifies cases where the previously recorded original genus did not exist when the species was described. If a genus and subgenus have the same name, use the TaxonNameID of the subgenus.<br />
*Distribution, text, 400 characters maximum.<br />
*Ecology, text, 400 characters maximum.<br />
*Comment, text, 400 characters maximum, explanation relating to the status of the name.<br />
*ExpertID, integer, 4 bytes, = tblExperts.ExpertID for the person recorded as expert for this taxon<br />
*ExpertReason, integer, 1 byte, reason expert assigned, 0 = no expert assigned, 1 = by default, 2 = by hierarchy only, 3 = by hierarchy and geography, 11 = cascaded by default, 12 = cascaded by hierarchy only, 13 = cascaded by hierarchy and geography<br />
**When a new taxon is created or a taxon becomes valid, the ExpertID is copied from the new AboveID. If the ExpertID and ExpertReason of the AboveID is 0, the new/now valid taxon values are also 0. If the ExpertReason of the AboveID is less than 10 (but greater than 0), add 10 to the ExpertReason of the AboveID to derive the ExpertReason value for the new/now valid taxon. Use the same ExpertReason value for the new/now valid taxon if the ExpertReason of the AboveID is greater than 9.<br />
*CurrentConceptRefID, integer, 4 bytes, = tblRefs.RefID, identifies the reference that initiated the currently accepted concept. If there is no currently accepted concept for the name, then this is the reference that terminated the concept.<br />
*LifeZone, integer, 1 byte, bit values:<br />
**1 = Marine<br />
**2 = Brackish<br />
**4 = Freshwater<br />
**8 = Terrestrial<br />
*LastUpdate, smalldatetime, date and time row last updated<br />
*ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
*CreatedOn, smalldatetime, date and time row was created<br />
*CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
[[Category:TaxaTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/NomenclatorNomenclator2014-01-17T21:15:26Z<p>Dceades: </p>
<hr />
<div>'''tblNomenclator''', name combinations at rank of genus or lower<br />
<br />
*NomenclatorID, integer, 4 bytes, identifier for the name combination<br />
* To be added: FileID, integer, 4 bytes, = tblFiles.FileID<br />
* [[GenusNames|GenusNameID]], integer, 4 bytes, = tblGenusNames.GenusNameID<br />
* [[GenusNames|SubgenusNameID]], integer, 4 bytes, = tblGenusNames.GenusNameID<br />
* [[GenusNames|InfragenusNameID]], integer, 4 bytes, = tblGenusNames.GenusNameID<br />
* [[SpeciesNames|SpeciesSeriesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID<br />
* [[SpeciesNames|SpeciesGroupNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID<br />
* [[SpeciesNames|SpeciesSubgroupNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID<br />
* [[SpeciesNames|SpeciesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID<br />
* [[SpeciesNames|SubspeciesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID<br />
* InfrasubspeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID<br />
* InfrasubKind, integer, 2 bytes, kind of infrasubspecies name<br />
** 0 = [none]<br />
** 1 = form<br />
** 2 = variety<br />
* SuitableForRanks, integer, 1 byte. Suitability indicates if nomenclator row based on a citation may be used to generate a taxon name LSID.<br />
** 0 = not suitable for use: no genus name, no species name when below species name present, any non-scientific name present<br />
** 1 = suitable for genus, subgenus or infragenus<br />
** 2 = suitable for species series, species group or species subgroup<br />
** 3 = suitable for species or lowere<br />
* LastUpdate, smalldatetime, date and time of last update<br />
* ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
* CreatedOn, smalldatetime, date and time row was created<br />
* CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
[[Category:CiteRelatedTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/MatchingIDsMatchingIDs2014-01-13T17:34:45Z<p>Dceades: </p>
<hr />
<div>'''tblMatchingIDs''', related ID values in the same table.<br />
Part of this description applies only to cases where TableID = 21 (tblTaxa).<br />
<br />
*The primary key is composed of TableID, IDrelationshipID, ID1 and ID2.<br />
*TableID, integer, 4 bytes = tblTables.TableID<br />
*IDrelationshipID, integer, 1 byte, = tblIDrelationships.IDrelationship<br />
** 1 = ID2 copied from ID1 in spin off.<br />
** 2 = ID1 merged to create ID2. Applies only when a new row was created in the spun off species file.<br />
** 3 = ID2 reserved for future merge of ID1.<br />
*ID1, integer, 4 bytes<br />
*ID1FileID, integer, 4bytes<br />
*ID2, integer, 4 bytes<br />
*ID2FileID, integer, 4bytes<br />
*Status, integer, 1 byte<br />
** If IDrelationshipID = 1<br />
*** 0 = ID2 created by spin off<br />
*** 1 = Merge started, if ID1 was deleted, it has been re-created<br />
*** 2 = Values for LikeNameID and OriginalGenusID are resolved<br />
*** 5 = Values for RefID and CurrentConceptRefID resolved; merge process completed<br />
** If IDrelationshipID = 2<br />
*** 0 = ID2 has been reserved, but not created<br />
*** 1 = ID2 has been created<br />
*** 2 = Values for LikeNameID and OriginalGenusID are resolved<br />
*** 5 = Values for RefID and CurrentConceptRefID resolved; merge process completed<br />
** If IDrelationshipID = 3<br />
*** Status is not used.<br />
*LastUpdate, smalldatetime, date and time row last updated<br />
*ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
*CreatedOn, smalldatetime, date and time row was created<br />
*CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
<br />
[[Category:IDrelationshipTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/TaxonNameLSIDsTaxonNameLSIDs2014-01-11T21:15:33Z<p>Dceades: </p>
<hr />
<div>'''tblTaxonNameLSIDs''' contains infomation about LSIDs for scientific taxon names.<br />
<br />
*TaxonNameLSID, integer, 4 bytes, primary key, = ID portion of LSIDs<br />
*FileID, integer, 4 bytes, = tblFiles.FileID. Identifies which file this TaxonNameID is or was associated with. This column will be added to the table.<br />
*FullTaxonNameLSID, text, 127 bytes maximum, full LSID as displayed for users<br />
*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<br />
*NomenclatorID, integer, 4 bytes, = tblNomenclator.NomenclatorID. TaxonNameID and NomenclatorID for a unique index<br />
*TrueTxnNmLSID, integer, 4 bytes, = TxnNmLSID, available for forwarding in case an LSID must be deleted<br />
*Status, integer, 1 byte<br />
**0 = active<br />
**1 = dormant, used for deleted nominotypical subs<br />
**2 = artifact from rows erroneously added<br />
**3 = copied from other species file<br />
**4 = moved out of scope<br />
**5 = dormant, AccessCode changed to > 0, do not display LSID<br />
**6 = dormant, AccessCode changed to > 0, LSIDresolver.aspx grants confidential access to PageUser<br />
*LastUpdate, smalldatetime, date and time row last updated<br />
*ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
*CreatedOn, smalldatetime, date and time row was created<br />
*CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
<br />
[[Category:ForeignRelatedTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/TaxonNameLSIDsTaxonNameLSIDs2013-11-28T17:11:15Z<p>Dceades: </p>
<hr />
<div>'''tblTaxonNameLSIDs''' contains infomation about LSIDs for scientific taxon names.<br />
<br />
*TaxonNameLSID, integer, 4 bytes, primary key, = ID portion of LSIDs<br />
*FileID, integer, 4 bytes, = tblFiles.FileID. Identifies which file this TaxonNameID is or was associated with. This column will be added to the table.<br />
*FullTaxonNameLSID, text, 127 bytes maximum, full LSID as displayed for users<br />
*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<br />
*NomenclatorID, integer, 4 bytes, = tblNomenclator.NomenclatorID. TaxonNameID and NomenclatorID for a unique index<br />
*TrueTxnNmLSID, integer, 4 bytes, = TxnNmLSID, available for forwarding in case an LSID must be deleted<br />
*Status, integer, 1 byte<br />
**0 = active<br />
**1 = dormant, used for deleted nominotypical subs<br />
**2 = artifact from rows erroneously added<br />
**3 = moved to other species file identified in Note<br />
**4 = moved out of scope<br />
**5 = dormant, AccessCode changed to > 0, do not display LSID<br />
**6 = dormant, AccessCode changed to > 0, LSIDresolver.aspx grants confidential access to PageUser<br />
*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.<br />
*LastUpdate, smalldatetime, date and time row last updated<br />
*ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
*CreatedOn, smalldatetime, date and time row was created<br />
*CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
<br />
[[Category:ForeignRelatedTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/TaxonHistoryTaxonHistory2013-11-27T20:54:24Z<p>Dceades: </p>
<hr />
<div>'''tblTaxonHistory''', history of concepts and nomenclature for protonyms.<br />
<br />
*TaxonHistoryID, integer, 4 bytes, primary key, identifier for taxon name and concept.<br />
* [[Taxa|TaxonNameID]], integer, 4 bytes, = tblTaxon.TaxonNameID, identifier for the monomial name (protonym) associated with the history.<br />
* FileID, integer, 4 bytes, = tblFiles.FileID, the species file the row is associated with. This column is being added in late 2013. Old rows with Status = 2 (artifact) remain with FileID = 0.<br />
* SeqNum, integer, 2 bytes, sequence number within this TaxonNameID, 1-based values without gaps.<br />
* [[Nomenclator|NomenclatorID]], integer, 4 bytes, = tblNomenclator.NomenclatorID, identifier for binomial name associated with the history.<br />
* [[Refs|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.<br />
* NewNameStatusID, integer, 4 bytes, status of name when changed<br />
** 0 = unspecified<br />
** 1 = unchanged<br />
** 2 = new taxon name<br />
** 3 = made a synonym<br />
** 4 = made valid or temporary<br />
** 5 = new combination<br />
** 6 = name deleted with no related name<br />
** 7 = name deleted because of duplicate protonym, related name can be found in tblRelatedHistory<br />
** 8 = genus or species lowered to nominotypical sub<br />
** 9 = nominotypical sub raised to genus or species<br />
** 10 = name replaced by nominotypical sub<br />
** 11 = new nominotypical sub<br />
* ConceptChangeID, integer, 4 bytes, values in effect on completion of the change, permitted values:<br />
** 0 = unspecified<br />
** 1 = unchanged<br />
** 2 = new<br />
** 3 = restored<br />
** 4 = expanded<br />
** 5 = shrunk<br />
** 6 = modified<br />
** 7 = terminated<br />
** 8 = transferred<br />
* OtherHistoryID, integer, 4 bytes, = tblTaxonHistory.TaxonHistoryID, identifier for the other history ID involved in a relationship change specified in RelatedHistoryID<br />
* RelatedHistoryID, integer, 4 bytes, = tblRelatedHistory.RelatedHistoryID, identifier for the type of relationship to OtherHistoryID<br />
* UserConfirmed, bit, 1 = user has confirmed data in this row or generated from user supplied data in tblCites<br />
* UnreliableAssumption, bit, 1 = program used an unreliable assumption to create row<br />
* ArbitraryRow, bit, 1 = arbitrary row generated by program to resolve conflict, user resolution needed<br />
* Note, text, 300 characters 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.<br />
* Status, integer, 1 byte, status of the row<br />
** 0 = active<br />
** 1 = dormant, used for deleted nominotypical subs, which might be re-instated at a later time<br />
** 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.<br />
** 3 = moved to other species file identified in Note<br />
** 4 = moved out of scope<br />
* LastUpdate, smalldatetime, date and time row last updated<br />
* ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
* CreatedOn, smalldatetime, date and time row was created<br />
* CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
[[Category:TaxaTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/LSIDLSID2013-11-19T23:11:45Z<p>Dceades: /* LSIDs in Species File Software */</p>
<hr />
<div>An '''LSID''' is a life science identifier. LSIDs are used to provide a unique identifier for objects of interest in the life sciences. They facilitate useful transfer of data contained in XML files from one computer to another. When a computer receives data from two different sources, it can check the LSIDs and determine if both sets of data refer to the same object. LSIDs can also be used to help humans locate websites with information about the objects.<br />
<br />
== LSIDs in Species File Software == <br />
<br />
The original plan calls for eventual use of LSIDs for taxon names and taxon concepts; however, the only portion currently in progress is for scientific names. This means simple names at the rank of genus and higher, and binomial (including trinomial, etc.) names below the rank of genus. Protonyms, taxon concepts, images, etc. may be given LSIDs at a later time.<br />
<br />
== Activating LSIDs ==<br />
LSID tables have been added to all species file databases, but data are being added into those tables only after the tables are made active on a case by case basis. Users who have secure access may go to the page for selecting an administrative function and select "Manage use of LSIDs." The user then sees a page that allows the status to be changed between "None", "Active" and "Dormant".<br />
<br />
== External links ==<br />
* [http://en.wikipedia.org/wiki/LSID LSID - Wikipedia]<br />
* [http://lsid.tdwg.org/ LSID web resolver]<br />
<br />
[[Category: Administrators]]<br />
[[Category: Developers]]</div>Dceadeshttp://help.speciesfile.org/index.php/LSIDLSID2013-11-19T21:42:34Z<p>Dceades: /* Activating LSIDs */</p>
<hr />
<div>An '''LSID''' is a life science identifier. LSIDs are used to provide a unique identifier for objects of interest in the life sciences. They facilitate useful transfer of data contained in XML files from one computer to another. When a computer receives data from two different sources, it can check the LSIDs and determine if both sets of data refer to the same object. LSIDs can also be used to help humans locate websites with information about the objects.<br />
<br />
== LSIDs in Species File Software == <br />
<br />
The original plan calls for eventual use of LSIDs for taxon names and taxon concepts; however, the only portion currently in progress is for scientific names. This means simple names at the rank of genus and higher, and binomial (including trinomial, etc.) names below the rank of genus. Protonyms may be given LSIDs at a later time.<br />
<br />
== Activating LSIDs ==<br />
LSID tables have been added to all species file databases, but data are being added into those tables only after the tables are made active on a case by case basis. Users who have secure access may go to the page for selecting an administrative function and select "Manage use of LSIDs." The user then sees a page that allows the status to be changed between "None", "Active" and "Dormant".<br />
<br />
== External links ==<br />
* [http://en.wikipedia.org/wiki/LSID LSID - Wikipedia]<br />
* [http://lsid.tdwg.org/ LSID web resolver]<br />
<br />
[[Category: Administrators]]<br />
[[Category: Developers]]</div>Dceadeshttp://help.speciesfile.org/index.php/MatchingIDsMatchingIDs2013-11-08T20:50:53Z<p>Dceades: </p>
<hr />
<div>'''tblMatchingIDs''', related ID values in the same table.<br />
<br />
*The primary key is composed of TableID, IDrelationshipID, ID1 and ID2.<br />
*TableID, integer, 4 bytes = tblTables.TableID<br />
*IDrelationshipID, integer, 1 byte, = tblIDrelationships.IDrelationship<br />
** 1 = ID2 copied from ID1 in spin off.<br />
** 2 = ID1 merged to create ID2.<br />
** 3 = ID2 reserved for future merge of ID1.<br />
*ID1, integer, 4 bytes<br />
*ID1FileID, integer, 4bytes<br />
*ID2, integer, 4 bytes<br />
*ID2FileID, integer, 4bytes<br />
*Status, integer, 1 byte<br />
** If IDrelationshipID = 1<br />
*** 0 = ID2 created by spin off<br />
*** 1 = Merge started, if ID1 was deleted, it has been re-created<br />
*** 2 = Values for LikeNameID and OriginalGenusID are resolved<br />
*** 5 = Values for RefID and CurrentConceptRefID resolved; merge process completed<br />
** If IDrelationshipID = 2<br />
*** 0 = ID2 has been reserved, but not created<br />
*** 1 = ID2 has been created<br />
*** 2 = Values for LikeNameID and OriginalGenusID are resolved<br />
*** 5 = Values for RefID and CurrentConceptRefID resolved; merge process completed<br />
** If IDrelationshipID = 3<br />
*** Status is not used.<br />
*LastUpdate, smalldatetime, date and time row last updated<br />
*ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
*CreatedOn, smalldatetime, date and time row was created<br />
*CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
<br />
[[Category:IDrelationshipTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/MatchingIDsMatchingIDs2013-11-08T20:50:12Z<p>Dceades: </p>
<hr />
<div>'''tblMatchingIDs''', related ID values in the same table.<br />
<br />
*The primary key is composed of TableID, IDrelationshipID, ID1 and ID2.<br />
*TableID, integer, 4 bytes = tblTables.TableID<br />
*IDrelationshipID, integer, 1 byte, = tblIDrelationships.IDrelationship<br />
** 1. ID2 copied from ID1 in spin off.<br />
** 2. ID1 merged to create ID2.<br />
** 3. ID2 reserved for future merge of ID1.<br />
*ID1, integer, 4 bytes<br />
*ID1FileID, integer, 4bytes<br />
*ID2, integer, 4 bytes<br />
*ID2FileID, integer, 4bytes<br />
*Status, integer, 1 byte<br />
** If IDrelationshipID = 1<br />
*** 0 = ID2 created by spin off<br />
*** 1 = Merge started, if ID1 was deleted, it has been re-created<br />
*** 2 = Values for LikeNameID and OriginalGenusID are resolved<br />
*** 5 = Values for RefID and CurrentConceptRefID resolved; merge process completed<br />
** If IDrelationshipID = 2<br />
*** 0 = ID2 has been reserved, but not created<br />
*** 1 = ID2 has been created<br />
*** 2 = Values for LikeNameID and OriginalGenusID are resolved<br />
*** 5 = Values for RefID and CurrentConceptRefID resolved; merge process completed<br />
** If IDrelationshipID = 3<br />
*** Status is not used.<br />
*LastUpdate, smalldatetime, date and time row last updated<br />
*ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
*CreatedOn, smalldatetime, date and time row was created<br />
*CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
<br />
[[Category:IDrelationshipTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/IDrelationshipsIDrelationships2013-11-08T20:45:25Z<p>Dceades: </p>
<hr />
<div>'''tblIDrelationships''', types of relationships between IDs as used in tblMatchingIDs<br />
<br />
* IDrelationshipID, integer, 1 byte<br />
** 1. ID2 copied from ID1 in spin off. tblMatchingIDs.Status is defined as:<br />
*** 0 = ID2 created by spin off<br />
*** 1 = Merge started, if ID1 was deleted, it has been re-created<br />
*** 2 = Values for LikeNameID and OriginalGenusID are resolved<br />
*** 5 = Values for RefID and CurrentConceptRefID resolved; merge process completed<br />
** 2. ID1 merged to create ID2. tblMatchingIDs.Status is defined as:<br />
*** 0 = ID2 has been reserved, but not created<br />
*** 1 = ID2 has been created<br />
*** 2 = Values for LikeNameID and OriginalGenusID are resolved<br />
*** 5 = Values for RefID and CurrentConceptRefID resolved; merge process completed<br />
** 3. ID2 reserved for future merge of ID1. Status is not used.<br />
** 4. ID1 is the same as ID2 in a different species file. For future development.<br />
* Description, text, 50 characters maximum.<br />
* LastUpdate, smalldatetime, date and time row last updated<br />
* ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
* CreatedOn, smalldatetime, date and time row was created<br />
* CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
<br />
[[Category:IDrelationshipTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/IDrelationshipsIDrelationships2013-11-08T20:25:31Z<p>Dceades: </p>
<hr />
<div>'''tblIDrelationships''', types of relationships between IDs as used in tblMatchingIDs<br />
<br />
* IDrelationshipID, integer, 1 byte<br />
* Description, text, 50 characters maximum. The following square bullet points list values for IDrelationshipID and Description. ID1, ID2 and Status refer to columns contained in other tables shown on this page.<br />
** 1. ID2 copied from ID1 in spin off. Status is defined as:<br />
*** 0 = ID2 created by spin off<br />
*** 1 = Merge started, if ID1 was deleted, it has been re-created<br />
*** 2 = Values for LikeNameID and OriginalGenusID are resolved<br />
*** 5 = Values for RefID and CurrentConceptRefID resolved; merge process completed<br />
** 2. ID1 merged to create ID2. Status is defined as:<br />
*** 0 = ID2 has been reserved, but not created<br />
*** 1 = ID2 has been created<br />
*** 2 = Values for LikeNameID and OriginalGenusID are resolved<br />
*** 5 = Values for RefID and CurrentConceptRefID resolved; merge process completed<br />
** 3. ID2 reserved for future merge of ID1. Status is not used.<br />
** 4. ID1 is the same as ID2 in a different species file. For future development.<br />
* LastUpdate, smalldatetime, date and time row last updated<br />
* ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
* CreatedOn, smalldatetime, date and time row was created<br />
* CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
<br />
[[Category:IDrelationshipTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/List_of_tablesList of tables2013-11-08T20:20:50Z<p>Dceades: </p>
<hr />
<div><br />
See a categorized list of [[:Category:Tables|all tables in the database]]. The list below is being transformed into the categorized list.<br />
<br />
== Data about taxa ==<br />
<br />
* [[Taxa|tblTaxa]], taxon names at all ranks, including synonyms.<br />
* [[RelatedTaxa|tblRelatedTaxa]], linking table to record nomenclatural relationships between taxonomic names.<br />
* [[TaxonHistory|tblTaxonHistory]], history of concepts and nomenclature for protonyms<br />
* tblRelatedHistory, definition of values used in tblTaxonHistory.RelatedHistoryID<br />
* tblRanks, ranks in the taxonomic hierarchy<br />
* tblSupplTaxonInfo, supplementary information about taxa.<br />
* tblExperts, information about experts familiar with taxa.<br />
* tblSources, references to sources of images, sound recordings and other data.<br />
* tblCommonNames, common names for taxa.<br />
* tblLanguages, the language used for common names in a particular species file.<br />
* tblLanguageList, standard information about languages.<br />
* tblTypeGenera, citation to genus that is type for a family-group name and to oldest use of a name based on the same genus.<br />
* tblTypeSpecies, citation to species that is type for a genus-group name.<br />
* tblTypeSpeciesReasons, reasons a type species has been validly designated.<br />
* tblTypeInfo, effects of citations on types.<br />
* tblDistribution, recorded occurences in geographic areas. <br />
== Data about specimens ==<br />
{{Commons cat|SpecimenTables}}<br />
<br />
* tblSpecimens, information about specimens.<br />
* tblSpecimenCategories, categories of specimens (male, female, egg, etc.)<br />
* tblSpecimenCounts, counts for various specimen categories<br />
* tblDepos, depositories that hold specimens.<br />
* tblSpecimenStatus, lost, lost?, missing, missing?, etc.<br />
* tblSexes, sex and maturity classification for specimens.<br />
* tblIdentifications, record of identifications on labels or in publications.<br />
* tblTypeKinds, holotype, lectotype, neotype, etc.<br />
* tblLocalities, information about localities where specimens were found including geologic time period.<br />
* tblGeoLevel1, continent or other major part of the world.<br />
* tblGeoLevel2, region or large country.<br />
* tblGeoLevel3, country or portion of large country.<br />
* tblGeoLevel4, county or other smaller area.<br />
* tblGazetteer, listing of names and the corresponding values in the preceding four tables, used with human data entry.<br />
* tblSeaCoords, polygon lists for oceanic TDWG areas<br />
* tblGeoConvert1, 2, 3, 3A and 4, data used to help convert localities to standardized codes in automated process.<br />
* tblTDWGtoITIS, for conversion of the TDWG geo classification to the ITIS geo classification.<br />
* tblTimePeriods, geologic time period.<br />
* tblCollectEvents, information about the date and collector. <br />
== Data about images, sounds and ecology ==<br />
* tblImages, images of specimens and other items.<br />
* tblMIME (Multipurpose Internet Mail Extension code), supported image types.<br />
* tblImageTypes, type of image.<br />
* tblSounds, sound recordings.<br />
* tblEcoRoles, ecological roles<br />
* tblEcoRelationships, ecological relationships<br />
* tblOtherEcoTaxa, taxa in ecological relationships but outside the primary scope <br />
== Data about literature citations, etc. ==<br />
* tblAddrCountries, a list of countries used in the address book.<br />
* tblAddrStates, a list of states used in the address book.<br />
* tblCites, citations to a reference, associated with a specific taxon.<br />
* tblConceptChanges, kind of changes in taxon concepts.<br />
* tblNewNameStatus, types of status for names.<br />
* tblCiteInfoFlags, kind of information contained in citations<br />
* tblRefs, references found in publications.<br />
* tblRefAuthors, linking table to match references with authors.<br />
* tblPeople, names of people (mainly authors) including misspellings, etc.<br />
* tblPeopleReg, registry of data about authors, for future development<br />
* tblPubs, names of publications including misspellings, etc.<br />
* tblPubReg, registry of data about publications, for future development<br />
* tblPubRegDetail, items that may have multiple values for a single registry pub, for future development<br />
* tblPendingPubFiles, linking table used to track the reconciliation of data in tblPubReg and the separate tblPubs in different species files, for future development<br />
* tblPubSuccession, relationship between preceding and succeeding publications, for future development<br />
* tblNomenclator, name combinations at rank of genus or lower.<br />
* tblGenusNames, generic name for lookup in tblNomenclator.<br />
* tblSpeciesNames, species name for lookup in tblNomenclator.<br />
* tblScrutinies, years and comments from persons working on this database.<br />
* tblTaxonScrutinies, linking table to match taxa with scrutinies.<br />
* tblScrutinyAuthors, linking table to match scrutinies with persons.<br />
== Data for keys ==<br />
* tblKeyGroups, groups of one or more taxa that can be separated by using a key block.<br />
* tblGroupTaxa, subordinate to tblKeyGroups, included or excluded members of a group based on a taxon listed in tblKeyGroups.<br />
* tblKeyBlocks, decision blocks for working through keys.<br />
* tblKeyChars, pool of characters available for use in key blocks.<br />
* tblCharTypes, types of characters, for future development<br />
* tblKeyCharStates, subordinate to tblKeyChars, description of each character state for each character.<br />
* tblCharStateDetails, subordinate to tblKeyCharStates, display details for character states.<br />
* tblKeyBlockChars, linking table to match blocks and characters.<br />
* tblKeyBlockBranches, subordinate to tblKeyBlocks, list giving group selected for each branch.<br />
* tblBlockCharStates, linking table to match block character (specific to block) with key character (pool of all characters).<br />
* tblBranchCharStates, linking table for block to match branch with character state.<br />
== Data about log entries ==<br />
* tblEditLog, log of entries that alter the content of tables in species file databases.<br />
* tblEditLogTexts, text information used in log entries.<br />
* tblTestLog, log of test program runs and results.<br />
== Data about relationships between ID values, currently used only for spinning off and merging species files ==<br />
* tblTables, ID values for tables used in tblMatchingIDs<br />
* tblIDrelationships, types of relationships between IDs<br />
* tblMatchingIDs, related ID values within the same table<br />
== Data for relationships outside of species files ==<br />
* tblLinks, hyperlinks to other websites with information about a taxon.<br />
* tblWebsites, information about other websites.<br />
* tblTaxonNameLSIDs, information about LSIDs for scientific taxon names<br />
* tblTConceptLSIDs, taxon concept LSIDs, not yet implemented<br />
* tblDeletedTNameIDs, deleted taxon name IDs<br />
* tblForeignLSIDs, LSIDs issued by other entities such as Species 2000 and ZooBank<br />
== Miscellaneous tables ==<br />
* tblConstants, constant values to be referenced by programs.<br />
* tblGlossary, words that are recognized in a glossary search.<br />
* tblFiles, data about the status of various species files.<br />
* tblFileTypes, types of database files based on how they are used.<br />
* tblSources, sources of data in tables in SFSdb.<br />
* Temporary tables used for export to the Catalogue of Life<br />
<br />
[[Category:Developers]]<br />
[[Category:Lists]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/NomenclatorNomenclator2013-11-01T21:52:14Z<p>Dceades: </p>
<hr />
<div>'''tblNomenclator''', name combinations at rank of genus or lower<br />
<br />
*NomenclatorID, integer, 4 bytes, identifier for the name combination<br />
* To be added: FileID, integer, 4 bytes, = tblFiles.FileID<br />
* [[GenusNames|GenusNameID]], integer, 4 bytes, = tblGenusNames.GenusNameID<br />
* [[GenusNames|SubgenusNameID]], integer, 4 bytes, = tblGenusNames.GenusNameID<br />
* To be added: [[GenusNames|InfragenusNameID]], integer, 4 bytes, = tblGenusNames.GenusNameID<br />
* To be added: [[SpeciesNames|SpeciesSeriesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID<br />
* To be added: [[SpeciesNames|SpeciesGroupNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID<br />
* To be added: [[SpeciesNames|SpeciesSubgroupNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID<br />
* [[SpeciesNames|SpeciesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID<br />
* [[SpeciesNames|SubspeciesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID<br />
* InfrasubspeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID<br />
* InfrasubKind, integer, 2 bytes, kind of infrasubspecies name<br />
** 0 = [none]<br />
** 1 = form<br />
** 2 = variety<br />
* To be deleted: 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.<br />
* To be deleted: 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.<br />
* To be added: SuitableForRanks, integer, 1 byte. Suitability indicates if nomenclator row based on a citation may be used to generate a taxon name LSID.<br />
** 0 = not suitable for use: no genus name, no species name when below species name present, any non-scientific name present<br />
** 1 = suitable for genus, subgenus or infragenus<br />
** 2 = suitable for species series, species group or species subgroup<br />
** 3 = suitable for species or lowere<br />
* LastUpdate, smalldatetime, date and time of last update<br />
* ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
* CreatedOn, smalldatetime, date and time row was created<br />
* CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
* Not likely to be implemented: TSN, integer, 4 bytes, taxon serial number from ITIS. <br />
[[Category:CiteRelatedTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/NomenclatorNomenclator2013-11-01T21:48:10Z<p>Dceades: </p>
<hr />
<div>'''tblNomenclator''', name combinations at rank of genus or lower<br />
<br />
*NomenclatorID, integer, 4 bytes, identifier for the name combination<br />
* To be added: FileID, integer, 4 bytes, = tblFiles.FileID<br />
* [[GenusNames|GenusNameID]], integer, 4 bytes, = tblGenusNames.GenusNameID<br />
* [[GenusNames|SubgenusNameID]], integer, 4 bytes, = tblGenusNames.GenusNameID<br />
* To be added: [[GenusNames|InfragenusNameID]], integer, 4 bytes, = tblGenusNames.GenusNameID<br />
* To be added: [[SpeciesNames|SpeciesSeriesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID<br />
* To be added: [[SpeciesNames|SpeciesGroupNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID<br />
* To be added: [[SpeciesNames|SpeciesSubgroupNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID<br />
* [[SpeciesNames|SpeciesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID<br />
* [[SpeciesNames|SubspeciesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID<br />
* InfrasubspeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID<br />
* InfrasubKind, integer, 2 bytes, kind of infrasubspecies name<br />
** 0 = [none]<br />
** 1 = form<br />
** 2 = variety<br />
* To be deleted: 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.<br />
* To be deleted: 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.<br />
* To be added: SuitableForRanks, integer, 1 byte. Suitability indicates if nomenclator row based on a citation may be used to generate a taxon name LSID.<br />
** 0 = not suitable for use: no genus name, no species name when below species name present, any non-scientific name present<br />
** 1 = suitable for genus, subgenus or infragenus<br />
** 2 = suitable for species series, species group or species subgroup<br />
** 3 = suitable for species or lowere<br />
* LastUpdate, smalldatetime, date and time of last update<br />
* ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
* CreatedOn, smalldatetime, date and time row was created<br />
* CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
<br />
=== May never be implemented ===<br />
* TSN, integer, 4 bytes, taxon serial number from ITIS. <br />
[[Category:CiteRelatedTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/NomenclatorNomenclator2013-11-01T21:38:04Z<p>Dceades: Record changes under development.</p>
<hr />
<div>'''tblNomenclator''', name combinations at rank of genus or lower<br />
<br />
*NomenclatorID, integer, 4 bytes, identifier for the name combination<br />
* To be added: FileID, integer, 4 bytes, = tblFiles.FileID<br />
* [[GenusNames|GenusNameID]], integer, 4 bytes, = tblGenusNames.GenusNameID<br />
* [[GenusNames|SubgenusNameID]], integer, 4 bytes, = tblGenusNames.GenusNameID<br />
* To be added: [[GenusNames|InfragenusNameID]], integer, 4 bytes, = tblGenusNames.GenusNameID<br />
* To be added: [[SpeciesNames|SpeciesSeriesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID<br />
* To be added: [[SpeciesNames|SpeciesGroupNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID<br />
* To be added: [[SpeciesNames|SpeciesSubgroupNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID<br />
* [[SpeciesNames|SpeciesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID<br />
* [[SpeciesNames|SubspeciesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID<br />
* InfrasubspeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID<br />
* InfrasubKind, integer, 2 bytes, kind of infrasubspecies name<br />
** 0 = [none]<br />
** 1 = form<br />
** 2 = variety<br />
* To be deleted: 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.<br />
* To be deleted: 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.<br />
* To be added: SuitableForRanks, integer, 1 byte<br />
** 0 = not suitable for use<br />
** 1 = suitable for genus, subgenus or infragenus<br />
** 2 = suitable for species series, species group or species subgroup<br />
** 3 = suitable for species or lowere<br />
* LastUpdate, smalldatetime, date and time of last update<br />
* ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
* CreatedOn, smalldatetime, date and time row was created<br />
* CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
<br />
=== Not Yet Implemented ===<br />
* TSN, integer, 4 bytes, taxon serial number from ITIS. This column has not been implemented. <br />
[[Category:CiteRelatedTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/CitesCites2013-10-22T21:40:34Z<p>Dceades: </p>
<hr />
<div>'''tblCites''' contains citations to a reference and associated with a specific taxon.<br />
<br />
* [[Taxa|TaxonNameID]], integer, 4 bytes, = tblTaxa.TaxonNameID for the associated taxon<br />
* SeqNum, integer, 2 bytes, a 1-based sequence number for the citations for an individual taxon<br />
* [[Refs|RefID]], integer, 4 bytes, = tblRefs.RefID<br />
* CitePages, text, 50 characters maximum, list of pages, plates, etc. cited for this taxon<br />
* Note, text, 400 characters maximum, any additional information about what is included in the citation<br />
* NomenclatorID, integer, 4 bytes, = [[Nomenclator|tblNomenclator]].NomenclatorID, applies to taxa at rank genus or lower<br />
* NewNameStatusID, integer, 4 bytes, = [[NewNameStatus|tblNewNameStatus]].NewNameStatusID, status of new names as listed in [[NewNameStatus|tblNewNameStatus]] values 0 to 21. (Values 11 to 16 and 21 are used only in [[TaxonHistory|tblTaxonHistory]].)<br />
* TypeInfoID, integer, 4 bytes, = [[TypeInfo|tblTypeInfo]].TypeInfoID, type designation or clarification<br />
* ContentFlags, integer, 4 bytes, kinds of content as documented for [[CiteContentFlags|tblCiteContentFlags]]<br />
* ConceptChangeID, integer, 4 bytes, = [[ConceptChanges|tblConceptChanges]].ConceptChangeID, kinds of change to taxon concept as listed in [[ConceptChanges|tblContentChanges]]<br />
* CurrentConcept, bit, value 1 indicates this citation provides the current concept.<br />
* InfoFlags, integer, 2 bytes, flags for presence of types of information as listed in [[CiteInfoFlags|tblCiteInfoFlags]]<br />
* InfoFlagStatus, integer, 1 byte, status of information in InfoFlags<br />
** 0 = not data<br />
** 1 = partial data or needs review<br />
** 2 = complete data<br />
* PolynomialStatus, integer, 1 byte. A value of 1 indicates tblCites.NomenclatorID should form the basis for a taxon name LSID and be included in data sent to the Catalogue of Life and exported in Darwin Core.<br />
** 0 = no change recognized; NewNameStatus = 0, 1 or 8. Also, all taxa above genus rank have this value. Also, all cases of insufficient nomenclator information have this value. NewNameStatus can = 2 when nomenclator has data such as "? ([subgenus name])" for the original description.<br />
** 1 = first use of polynomial with a significant (see 2 below) difference from any previous polynomial; NewNameStatus = 2, 4-7, 10 or 17-19<br />
** 2 = later use of polynomial; NewNameStatus = 4, 5, 7 or 10. Differences such as presence or absence of nominotypical subgenus or subspecies name are considered not significant and not deserving a separate LSID.<br />
** 3 = treated as synonym; NewNameStatus = 3 or 9<br />
** 4 = duplicate use; NewNameStatus = 2, 4-7, 10 or 17-19. The citation duplicates a citation associated with a related taxon, which is the preferred place to use the citation. For a genus or species with subs, the sub is used to represent all duplications except for the original description of the genus or species if done without the sub. Duplicate use also applies to names initially used inappropriately (incorrect original spelling, lapsus calami, nomen nudum, junior homonym) or suppressed (nomen oblitum, suppressed). The citation where the nomenclator information matches the taxon name is used to represent all duplications, and other uses are marked as duplicate.<br />
** 5 = not used for lack of scientific name; NewNameStatus = 2 or 5<br />
** 6 = not used because of AccessCode; NewNameStatus = any<br />
** 7 = outside of primary scope; NewNameStatus = any<br />
* LastUpdate, smalldatetime, date and time of last update<br />
* ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
* CreatedOn, smalldatetime, date and time row was created<br />
* CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
<br />
[[Category:CiteRelatedTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/CitesCites2013-10-22T20:52:22Z<p>Dceades: </p>
<hr />
<div>'''tblCites''' contains citations to a reference and associated with a specific taxon.<br />
<br />
* [[Taxa|TaxonNameID]], integer, 4 bytes, = tblTaxa.TaxonNameID for the associated taxon<br />
* SeqNum, integer, 2 bytes, a 1-based sequence number for the citations for an individual taxon<br />
* [[Refs|RefID]], integer, 4 bytes, = tblRefs.RefID<br />
* CitePages, text, 50 characters maximum, list of pages, plates, etc. cited for this taxon<br />
* Note, text, 400 characters maximum, any additional information about what is included in the citation<br />
* NomenclatorID, integer, 4 bytes, = [[Nomenclator|tblNomenclator]].NomenclatorID, applies to taxa at rank genus or lower<br />
* NewNameStatusID, integer, 4 bytes, = [[NewNameStatus|tblNewNameStatus]].NewNameStatusID, status of new names as listed in [[NewNameStatus|tblNewNameStatus]] values 0 to 21. (Values 11 to 16 and 21 are used only in [[TaxonHistory|tblTaxonHistory]].)<br />
* TypeInfoID, integer, 4 bytes, = [[TypeInfo|tblTypeInfo]].TypeInfoID, type designation or clarification<br />
* ContentFlags, integer, 4 bytes, kinds of content as documented for [[CiteContentFlags|tblCiteContentFlags]]<br />
* ConceptChangeID, integer, 4 bytes, = [[ConceptChanges|tblConceptChanges]].ConceptChangeID, kinds of change to taxon concept as listed in [[ConceptChanges|tblContentChanges]]<br />
* CurrentConcept, bit, value 1 indicates this citation provides the current concept.<br />
* InfoFlags, integer, 2 bytes, flags for presence of types of information as listed in [[CiteInfoFlags|tblCiteInfoFlags]]<br />
* InfoFlagStatus, integer, 1 byte, status of information in InfoFlags<br />
** 0 = not data<br />
** 1 = partial data or needs review<br />
** 2 = complete data<br />
* PolynomialStatus, integer, 1 byte. A value of 1 indicates tblCites.NomenclatorID should form the basis for a taxon name LSID and be included in data sent to the Catalogue of Life and exported in Darwin Core.<br />
** 0 = no change recognized; NewNameStatus = 0, 1 or 8. Also, all taxa above genus rank have this value. Also, all cases of insufficient nomenclator information have this value. NewNameStatus can = 2 when nomenclator has data such as "? ([subgenus name])" for the original description.<br />
** 1 = first use of polynomial with a significant (see 8 below) difference from any previous polynomial; NewNameStatus = 2, 4-7, 10 or 17-19<br />
** 2 = later use of polynomial; NewNameStatus = 4, 5, 7 or 10<br />
** 3 = treated as synonym; NewNameStatus = 3 or 9<br />
** 4 = duplicate use; NewNameStatus = 2, 4-7, 10 or 17-19. The citation duplicates a citation associated with a related taxon, which is the preferred place to use the citation. For a genus or species with subs, the sub is used to represent all duplications except for the original description of the genus or species if done without the sub. Duplicate use also applies to names initially used inappropriately (incorrect original spelling, lapsus calami, nomen nudum, junior homonym) or suppressed (nomen oblitum, suppressed). The citation where the nomenclator information matches the taxon name is used to represent all duplications, and other uses are marked as duplicate.<br />
** 5 = not used for lack of scientific name; NewNameStatus = 2 or 5<br />
** 6 = not used because of AccessCode; NewNameStatus = any<br />
** 7 = outside of primary scope; NewNameStatus = any<br />
** 8 = first use of polynomial, but no significant difference from previous use; NewNameStatus = 4, 5, 7 or 10. Differences such as presence or absence of nominotypical subgenus or subspecies name are considered not significant and not deserving a separate LSID.<br />
* LastUpdate, smalldatetime, date and time of last update<br />
* ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
* CreatedOn, smalldatetime, date and time row was created<br />
* CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
<br />
[[Category:CiteRelatedTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/CitesCites2013-10-22T20:29:31Z<p>Dceades: </p>
<hr />
<div>'''tblCites''' contains citations to a reference and associated with a specific taxon.<br />
<br />
* [[Taxa|TaxonNameID]], integer, 4 bytes, = tblTaxa.TaxonNameID for the associated taxon<br />
* SeqNum, integer, 2 bytes, a 1-based sequence number for the citations for an individual taxon<br />
* [[Refs|RefID]], integer, 4 bytes, = tblRefs.RefID<br />
* CitePages, text, 50 characters maximum, list of pages, plates, etc. cited for this taxon<br />
* Note, text, 400 characters maximum, any additional information about what is included in the citation<br />
* NomenclatorID, integer, 4 bytes, = [[Nomenclator|tblNomenclator]].NomenclatorID, applies to taxa at rank genus or lower<br />
* NewNameStatusID, integer, 4 bytes, = [[NewNameStatus|tblNewNameStatus]].NewNameStatusID, status of new names as listed in [[NewNameStatus|tblNewNameStatus]] values 0 to 21. (Values 11 to 16 and 21 are used only in [[TaxonHistory|tblTaxonHistory]].)<br />
* TypeInfoID, integer, 4 bytes, = [[TypeInfo|tblTypeInfo]].TypeInfoID, type designation or clarification<br />
* ContentFlags, integer, 4 bytes, kinds of content as documented for [[CiteContentFlags|tblCiteContentFlags]]<br />
* ConceptChangeID, integer, 4 bytes, = [[ConceptChanges|tblConceptChanges]].ConceptChangeID, kinds of change to taxon concept as listed in [[ConceptChanges|tblContentChanges]]<br />
* CurrentConcept, bit, value 1 indicates this citation provides the current concept.<br />
* InfoFlags, integer, 2 bytes, flags for presence of types of information as listed in [[CiteInfoFlags|tblCiteInfoFlags]]<br />
* InfoFlagStatus, integer, 1 byte, status of information in InfoFlags<br />
** 0 = not data<br />
** 1 = partial data or needs review<br />
** 2 = complete data<br />
* PolynomialStatus, integer, 1 byte. A value of 1 indicates tblCites.NomenclatorID should form the basis for a taxon name LSID and be included in data sent to the Catalogue of Life and exported in Darwin Core.<br />
** 0 = no change recognized; NewNameStatus = 0, 1 or 8. Also, all taxa above genus rank have this value. Also, all cases of insufficient nomenclator information have this value. NewNameStatus can = 2 when nomenclator has data such as "? ([subgenus name])" for the original description.<br />
** 1 = first use of polynomial; NewNameStatus = 2, 4-7, 10 or 17-19<br />
** 2 = later use of polynomial; NewNameStatus = 4, 5, 7 or 10<br />
** 3 = treated as synonym; NewNameStatus = 3 or 9<br />
** 4 = duplicate use; NewNameStatus = 2, 4-7, 10 or 17-19. The citation duplicates a citation associated with a related taxon, which is the preferred place to use the citation. For a genus or species with subs, the sub is used to represent all duplications except for the original description of the genus or species if done without the sub. Duplicate use also applies to names initially used inappropriately (incorrect original spelling, lapsus calami, nomen nudum, junior homonym) or suppressed (nomen oblitum, suppressed). The citation where the nomenclator information matches the taxon name is used to represent all duplications, and other uses are marked as duplicate.<br />
** 5 = not used for lack of scientific name; NewNameStatus = 2 or 5<br />
** 6 = not used because of AccessCode; NewNameStatus = any<br />
** 7 = outside of primary scope; NewNameStatus = any<br />
** 8 = first use of polynomial, but no significant difference from previous use; NewNameStatus = 4, 5, 7 or 10<br />
* LastUpdate, smalldatetime, date and time of last update<br />
* ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
* CreatedOn, smalldatetime, date and time row was created<br />
* CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
<br />
[[Category:CiteRelatedTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/MatchingIDsMatchingIDs2013-10-18T16:52:32Z<p>Dceades: </p>
<hr />
<div>'''tblMatchingIDs''', related ID values in the same table.<br />
<br />
*The primary key is composed of TableID, IDrelationshipID, ID1 and ID2.<br />
*TableID, integer, 4 bytes = tblTables.TableID<br />
*IDrelationshipID, integer, 1 byte, = tblIDrelationships.IDrelationship<br />
*ID1, integer, 4 bytes<br />
*ID1FileID, integer, 4bytes<br />
*ID2, integer, 4 bytes<br />
*ID2FileID, integer, 4bytes<br />
*Status, integer, 1 byte, explained in tblIDrelationships.<br />
*LastUpdate, smalldatetime, date and time row last updated<br />
*ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
*CreatedOn, smalldatetime, date and time row was created<br />
*CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
<br />
[[Category:IDrelationshipTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/TaxonNameLSIDsTaxonNameLSIDs2013-09-09T21:51:34Z<p>Dceades: </p>
<hr />
<div>'''tblTaxonNameLSIDs''' contains infomation about LSIDs for scientific taxon names.<br />
<br />
*TaxonNameLSID, integer, 4 bytes, primary key, = ID portion of LSIDs<br />
*FullTaxonNameLSID, text, 127 bytes maximum, full LSID as displayed for users<br />
*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<br />
*NomenclatorID, integer, 4 bytes, = tblNomenclator.NomenclatorID. TaxonNameID and NomenclatorID for a unique index<br />
*TrueTxnNmLSID, integer, 4 bytes, = TxnNmLSID, available for forwarding in case an LSID must be deleted<br />
*Status, integer, 1 byte<br />
**0 = active<br />
**1 = dormant, used for deleted nominotypical subs<br />
**2 = artifact from rows erroneously added<br />
**3 = moved to other species file identified in Note<br />
**4 = moved out of scope<br />
**5 = dormant, AccessCode changed to > 0, do not display LSID<br />
**6 = dormant, AccessCode changed to > 0, LSIDresolver.aspx grants confidential access to PageUser<br />
*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.<br />
*LastUpdate, smalldatetime, date and time row last updated<br />
*ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
*CreatedOn, smalldatetime, date and time row was created<br />
*CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
<br />
[[Category:ForeignRelatedTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/TaxonNameLSIDsTaxonNameLSIDs2013-09-06T15:58:18Z<p>Dceades: </p>
<hr />
<div>'''tblTaxonNameLSIDs''' contains infomation about LSIDs for scientific taxon names.<br />
<br />
*TaxonNameLSID, integer, 4 bytes, primary key, = ID portion of LSIDs<br />
*FullTaxonNameLSID, text, 127 bytes maximum, full LSID as displayed for users<br />
*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<br />
*NomenclatorID, integer, 4 bytes, = tblNomenclator.NomenclatorID. TaxonNameID and NomenclatorID for a unique index<br />
*TrueTxnNmLSID, integer, 4 bytes, = TxnNmLSID, available for forwarding in case an LSID must be deleted<br />
*Status, integer, 1 byte<br />
**0 = active<br />
**1 = dormant, used for deleted nominotypical subs<br />
**2 = artifact from rows erroneously added<br />
**3 = moved to other species file identified in Note<br />
**4 = moved out of scope<br />
**5 = dormant, AccessCode changed to > 0<br />
*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.<br />
*LastUpdate, smalldatetime, date and time row last updated<br />
*ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
*CreatedOn, smalldatetime, date and time row was created<br />
*CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
<br />
[[Category:ForeignRelatedTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/Category:CoLTablesCategory:CoLTables2013-08-24T20:02:12Z<p>Dceades: </p>
<hr />
<div>{{Commons cat|CoLTables}}<br />
<br />
These tables are used to prepare, review and export data to the Catalogue of Life. All except tblCoLmetadata begin with "tmp" to indicate their temporary nature rather than "tbl" for tables that are part of the continuing species file data. TmpCoL_IDs, tmpCoLPending and tmpCoLReview are used while generating or reviewing the data. They do not contain data used by the Catalogue of Life.<br />
<br />
There is a set of archive tables not listed here. The design matches the tables listed below except the table name begins with "arcv" instead of "tmp". The columns are the same except for two added initial columns FileID and PendingReleaseDate to identify the species file and the date generated.<br />
<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/Catalogue_of_LifeCatalogue of Life2013-08-22T22:43:54Z<p>Dceades: /* Species Files in Catalogue of Life */</p>
<hr />
<div>The '''Catalogue of Life''' (CoL) was started in June 2001 by [[Species 2000]] and [http://en.wikipedia.org/wiki/Integrated_Taxonomic_Information_System Integrated Taxonomic Information System] (ITIS). Orthoptera Species File was the first Species File to send data to CoL. <br />
<br />
=Species Files in Catalogue of Life=<br />
<br />
*Aphid Species File<br />
*Blattodea Species File<br />
*Coreoidea Species File<br />
*Embioptera Species File<br />
*Mantodea Species File<br />
*Orthoptera Species File<br />
*Phasmida Species File<br />
*Plecoptera Species File<br />
*Psocodea Species File<br />
<br />
= Policy statement for sending SF data to CoL =<br />
== Annual/Rolling option ==<br />
Sent from our shop 1 August or 1 September, email reminder 1 month ahead, no response is tacit agreement. Can request delay or deny sending?<br />
== Off cycle option ==<br />
Sent at another time at curator's request.<br />
== In-house species files ==<br />
All in-house SF run through test program with fixes first.<br />
== Curators ==<br />
Ask all other curators.<br />
<br />
==References==<br />
<br />
==External links==<br />
*Catalogue of Life [http://www.catalogueoflife.org/]<br />
<br />
[[Category:Administrators]]<br />
[[Category:Developers]]</div>Dceadeshttp://help.speciesfile.org/index.php/Category:CoLTablesCategory:CoLTables2013-08-22T22:35:53Z<p>Dceades: </p>
<hr />
<div>{{Commons cat|CoLTables}}<br />
<br />
These tables are used to prepare, review and export data to the Catalogue of Life. They all begin with "tmp" to indicate their temporary nature rather than "tbl" for tables that are part of the continuing species file data. TmpCoL_IDs, tmpCoLPending and tmpCoLReview are used while generating or reviewing the data. They do not contain data used by the Catalogue of Life.<br />
<br />
There is a set of archive tables not listed here. The design matches the tables listed below except the table name begins with "arcv" instead of "tmp". The columns are the same except for two added initial columns FileID and PendingReleaseDate to identify the species file and the date generated.<br />
<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/CoLNameRefLinksCoLNameRefLinks2013-08-22T22:09:29Z<p>Dceades: added column ID</p>
<hr />
<div>'''tmpCoLNameRefLinks''', linking table for references and names<br />
<br />
*ID, integer, = tmpCoL_IDs<br />
*TaxonNameID, integer, 4 bytes, = tmpCoLAcceptedSpecies.TaxonNameID or tmpCoLAcceptedInfraSpecific.TaxonNameID or tmpCoLSynonyms.TaxonNameID<br />
*ReferenceType, text, 10 bytes maximum, = NomRef, ComNameRef, TaxAccRef, TaxSynRef or null string. Although this matches a column in the Exchange Format, the Catalogue of Life does not use the information at this time. In addition, the Standard Dataset does not include TaxSynRef, which is clearly needed for a reference that states a name is a synonym of something else. This column will be left blank until something changes at the Catalogue of Life.<br />
*RefID, integer, 4 bytes, = tmpColReferences.RefID<br />
<br />
[[Category:CoLTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/CoLAcceptedInfraSpecificCoLAcceptedInfraSpecific2013-08-22T22:03:30Z<p>Dceades: correct length of AdditionalData</p>
<hr />
<div>'''tmpCoLAcceptedInfraSpecific'''<br />
<br />
*AcceptedTaxonID, integer, 4 bytes, primary key for this table, = tmpCoL_IDs.ID<br />
*TaxonNameID, integer, 4 bytes, = tblTaxa.TaxonNameID in the species file<br />
*ParentSpeciesID, integer, 4 bytes, = tmpCoLAcceptedSpecies.AcceptedTaxonID<br />
*InfraSpecies, text, 30 character maximum, infraspecific name<br />
*InfraSpecificAuthorString, text (nvarchar), 500 character maximum, author and year for the taxon<br />
*InfraSpMarker, text, 10 character maximum<br />
*GSDNameStatus, text, 1000 character maximum, nomenclatural information about the taxon<br />
*Sp2000NameStatus, text, 30 character maximum, restricted vocabulary specified by CoL<br />
*IsFossil, text, either "0" or "1"<br />
*ExpertID, integer, = tmpExpertsForCoL.ExpertID<br />
*LifeZone, 4 characters; M for marine, B for Brackish, F for freshwater and T for Terrestrial. The letters when present are always in that sequence. Missing letters are replaced by blanks.<br />
*AdditionalData, text, 255 character maximum<br />
*InfraSpeciesURL, text, 100 character maximum, URL to find the taxon in the species file<br />
*GSDNameGUI, text, 100 character maximum, for example "urn:lsid:blattodea.speciesfile.org:taxonName:12345"<br />
<br />
[[Category:CoLTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/CoLAcceptedSpeciesCoLAcceptedSpecies2013-08-22T22:01:16Z<p>Dceades: Fix double listing of AdditionalData</p>
<hr />
<div>'''tmpCoLAcceptedSpecies'''<br />
<br />
*AcceptedTaxonID, integer, 4 bytes, primary key for this table, = tmpCoL_IDs.ID<br />
*TaxonNameID, integer, 4 bytes, = tblTaxa.TaxonNameID in the species file<br />
*OrderName, text, 30 character maximum, name of the order<br />
*Superfamily, text, 30 character maximum, name of the superfamily<br />
*Family, text, 30 character maximum, name of the family<br />
*Genus, text, 30 character maximum, name of the genus<br />
*Subgenus, text, 30 character maximum, name of the subgenus<br />
*Species, text, 30 character maximum, name of the species<br />
*AuthorString, text (nvarchar), 500 character maximum, author and year for the taxon.<br />
*GSDNameStatus, text, 1000 character maximum, nomenclatural information about the taxon<br />
*Sp2000NameStatus, text, 30 character maximum, restricted vocabulary specified by CoL<br />
*IsFossil, text, either "0" or "1"<br />
*ExpertID, integer, = tmpExpertsForCoL.ExpertID<br />
*LifeZone, 4 characters; M for marine, B for Brackish, F for freshwater and T for Terrestrial. The letters when present are always in that sequence. Missing letters are replaced by blanks.<br />
*AdditionalData, text, 255 character maximum<br />
*SpeciesURL, text, 100 character maximum, URL to find the taxon in the species file<br />
*GSDNameGUI, text, 100 character maximum, for example "urn:lsid:blattodea.speciesfile.org:taxonName:12345"<br />
<br />
[[Category:CoLTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/Taxa_(table)Taxa (table)2013-07-10T14:33:22Z<p>Dceades: </p>
<hr />
<div>'''tblTaxa''' contains taxon names at all ranks, including synonyms and other non valid names.<br />
<br />
*TaxonNameID, integer, 4 bytes, unique identifier for the taxon name. This number can be used to enter the database at this name.<br />
*FileID, integer, 4 bytes, = tblFiles.FileID<br />
*TaxonNameStr, text, 300 characters maximum. A series of TaxonNameID in text form and separated by "-". <br />
**If a taxon is at genus rank and is not a synonym, the text of TaxonNameID is followed by "g". This makes forming binomial names more efficient.<br />
**If a taxon is at subgenus rank and is not a synonym, the text of TaxonNameID is followed by "s".<br />
**For all taxa immediately subordinate to the apex taxon, TaxonNameStr begins with the TaxonNameID of the apex taxon followed by "-" (or "g-" if the apex taxon is at genus rank) and the TaxonNameID of the subordinate.<br />
**The chain of TaxonNameIDs grows moving down the hierarchy by adding "-" and the TaxonNameID (and "g" or "s" when appropriate).<br />
**For all taxa outside the primary scope, TaxonNameStr begins with "0-".<br />
***For genera (and rarely other ranks) outside the primary scope, TaxonNameStr begins with "0-0-". This is needed for tblTaxa.OriginalGenusID, for genera in nomenclator information for citations, and for taxa providing images or sounds.<br />
***For context taxa outside the primary scope, TaxonNameStr begins with "0-1-". Such taxa provide some context around the apex taxon.<br />
***For taxa previously within the primary scope but now outside, TaxonNameStr begins with "0-2-". This enables finding such taxa in searches so that users can be told about the change in status.<br />
***For reserved values of TaxonNameID, TaxonNameStr begins with "0-3-". These values are held in reserve for when private species files are merged.<br />
***For family-group taxa outside the primary scope (needed for tblTypeSpecies.FirstFamGrpNameID), TaxonNameStr begins with "0-4-".<br />
*RankID, integer, 4 bytes, = tblRanks.RankID, number for rank in hierarchy<br />
*Name, text, 30 characters maximum, name of taxon<br />
*Parens, boolean, enclose author name in parens?<br />
*AboveID, integer, 4 bytes, = tblTaxa.TaxonNameID of the next higher taxon in the hierarchy. If this taxon is a synonym or other not valid name, then this is the TaxonNameID for the valid taxon. AboveID cannot be the TaxonNameID for a genus having subgenera or a species having subspecies: In those cases, use the TaxonNameID of the nominotypical subgenus or subspecies.<br />
*LikeNameID, integer 4 bytes, = 0 unless this is a special case. Special cases are<br />
**Valid or temporary taxa<br />
***Genus, then = tblTaxa.TaxonNameID of subgenus by same name<br />
***Subgenus, then = tblTaxa.TaxonNameID of genus by same name<br />
***Species, then = tblTaxa.TaxonNameID of subspecies by same name<br />
***Subspecies, then = tblTaxa.TaxonNameID of species by same name<br />
*Extinct, integer, 1 byte, 0 = extant, 1 = extinct; if NameStatus = 7 (synonym), then the value of Extinct is ignored. Could be changed to allow additional values such as threatened, endangered and presumed extirpated.<br />
*HasPreHolocene, bit, 0 = no fossils, 1 = one or more fossils are known to exist; if NameStatus = 7 (synonym), then the value of HasPreHolocene is ignored. This will be implemented during summer, 2013.<br />
*HasModern, bit, 0 = no Recent specimens, 1 = one or more Recent specimens are known to exist; if NameStatus = 7(synonym), then the value of HasModern is ignored. This will be implemented during summer, 2013.<br />
*RefID, integer, 4 bytes, = tblRefs.RefID for the original description of the taxon. CAUTION: For family-group taxa, this is the first use of the name in its current form. The author and date for priority are based on the first use of any name based on the same type genus. To locate this information, trace via tblTypeGenera.GenusNameID to tblTypeSpecies.FirstFamGrpNameID to tblTaxa.RefID of that first name. For taxa above superfamily rank, RefID is always 0. Taxa at a rank above species and below subgenus also have RefID = 0.<br />
*NecAuthor, text, 200 characters maximum, author who used name correctly sometimes with additional information<br />
*DataFlags, integer, 2 bytes, with bitwise flags for type of data present<br />
**1 = image<br />
**2 = sound<br />
**4 = link to other website<br />
**8 = specimen data<br />
**0x10 (16) = scrutiny<br />
**0x20 (32) = key group<br />
**0x40 (64) = supplementary information<br />
**0x80 (128) = common name<br />
**0x100 (256) = related taxon<br />
**0x200 (512) = automatic link to other website<br />
**0x400 (1024) = ecological relationship<br />
**0x800 (2048) = valid taxon name string (used exclusively in spTestAboveIDvsTaxonNameStr)<br />
**0x1000 (4096) = has specimen(s) with latitude/longitude data useable for maps, applies to taxa at rank tribe or lower<br />
*AccessCode, integer, 4 bytes, = tblAccessCodes.AccessCode<br />
*NameStatus, integer, 1 byte<br />
**0 = valid<br />
**2 = temporary name for use until a valid name is provided (subordinate names limited to temporary names and synonyms)<br />
**4 = nomen nudum, must be at lower rank than parent (subordinate names limited to nomina nuda)<br />
**5 = nomen dubium, must be at lower rank than parent (subordinate names limited to nomina nuda and dubia)<br />
**7 = synonym (subordinate taxa not allowed)<br />
*StatusFlags, integer, 4 bytes, interpreted bitwise. We have run out of bits. To solve this, some flags will be moved to a new column UnavailFlags.<br />
**1 = informal name, compatible only with tblTaxa.NameStatus = 2 or 7. Will be moved to UnavailFlags.<br />
**2 = subsequent misspelling, compatible only with tblTaxa.NameStatus = 7. Will be moved to UnavailFlags.<br />
**4 = unjustified emendation, compatible only with tblTaxa.NameStatus = 7. New value will be 1.<br />
**8 = nomen nudum, compatible only with tblTaxa.NameStatus = 2 or 4 when rank is less than parent rank or = 7 when rank is same as parent. Will be moved to UnavailFlags.<br />
**0x10 (16) = nomen dubium, compatible only with tblTaxa.NameStatus = 5 when rank is less than parent rank or = 7 when rank is same as parent. New value will be 2.<br />
**0x20 (32) = incertae sedis, compatible only with tblTaxa.NameStatus = 0 or 2. New value will be 4.<br />
**0x40 (64) = required emendation, compatible only with tblTaxa.NameStatus = 0, 2 or 7. New value will be 8.<br />
**0x80 (128) = nomen protectum, compatible only with tblTaxa.NameStatus = 0 or 7. New value will be 0x10.<br />
**0x100 (256) = suppressed, compatible only with tblTaxa.NameStatus = 7. Will be moved to UnavailFlags.<br />
**0x200 (512) = misapplied, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7. Will be moved to UnavailFlags.<br />
**0x400 (1024) = preoccupied (genus-group names), compatible only with tblTaxa.NameStatus = 2 or 7. Will be moved to UnavailFlags.<br />
**0x800 (2048) = primary homonym (species-group names), compatible only with tblTaxa.NameStatus = 2 or 7. Will be moved to UnavailFlags.<br />
**0x1000 (4096) = secondary homonym (species-group names), compatible only with tblTaxa.NameStatus = 2 or 7. New value will be 0x20.<br />
**0x2000 (8192) = nomen oblitum, compatible only with tblTaxa.NameStatus = 7. New value will be 0x40.<br />
**0x4000 (16384) = unnecessary replacement name, compatible only with tblTaxa.NameStatus = 7. New value will be 0x80.<br />
**0x8000 (32768) = incorrect original spelling, compatible only with tblTaxa.Namestatus = 2, 4, 5 or 7. Will be moved to UnavailFlags.<br />
**0x10000 (65536) = other, explained by tblTaxa.Comment, compatible only with tblTaxa.NameStatus = 0, 2 or 7. New value will be 0x100.<br />
**0x20000 (131072) = unavailable, other reason, compatible only with tblTaxa.NameStatus = 2 or 7. Will be moved to UnavailFlags.<br />
**0x40000 (262144) = junior synonym, compatible only with tblTaxa.NameStatus = 7. New value will be 0x200.<br />
**0x80000 (524288) = nomen novum, compatible only with tblTaxa.Namestatus = 0, 2, or 7. New value will be 0x400.<br />
**0x100000 (1048576) = original name, used only for family-group names, compatible only with tblTaxa.NameStatus = 7. New value will be 0x800.<br />
**0x200000 (2097152) = subsequent name, used only for family-group names, compatible with any tblTaxa.NameStatus value. New value will be 0x1000.<br />
**0x400000 (4194304) = junior homonym for species-group name not specified as primary or secondary, compatible only with tblTaxa.NameStatus = 2 or 7. New value will be 0x2000.<br />
**0x800000 (8388608) = lapsus calami, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7. Will be moved to UnavailFlags.<br />
**0x1000000 (16777216) = corrected lapsus calami, compatible only with tblTaxa.NameStatus = 0, 2 or 7. New value will be 0x4000.<br />
**0x2000000 (33554432) = nomen nudum made available, compatible only with tblTaxa.NameStatus = 0, 2 or 7. New value will be 0x8000.<br />
**The following columns are planned to provide a basis for added relationships in tblRelatedTaxa.<br />
***0x1000 senior homonym (opposite junior homonym)<br />
***0x2000 correct not replaced (opposite unnecessary replacement)<br />
***0x4000 correct not emended (opposite unjustified emendation)<br />
***0x8000 correct as spelled (opposite subsequent misspelling)<br />
***0x10000 misapplied to (opposite misapplied)<br />
***0x20000 correct usage of misapplied (opposite misapplied)<br />
**Notes about StatusFlags.<br />
***Type data for taxa is available based on rank and name status:<br />
****No type data for ranks above superfamily.<br />
****No type data for ranks of subgenus through superfamily with name status of misapplied (0x200).<br />
****No type data for ranks above species and below subgenus.<br />
****No type data for ranks of species level and below for emendation (unjustified and required), misspelling, nomen nudum, unnecessary replacement, nomen novum, and misapplied (0x8424E) OR NameStatus = 4 (nomen nudum).<br />
***Age qualification is required for the following NameStatus values:<br />
****Junior synonym must not be older than the valid name.<br />
****Unjustified emendation, misspelling, and unnecessary replacement must not be older than the correct name.<br />
****Incorrectly formed name must not be younger than the justified emendation name.<br />
****Nomen novum must not be younger than the homonym replaced.<br />
****Nomen oblitum must not be younger than the valid name.<br />
***Taxa may have more than one status flag set. However, there are restrictions for certain status values. Unless stated below, more than one status flag may be set:<br />
****Emendation is not compatible with misspelling, unnecessary replacement, nomen nudum, incorrect original spelling, and misapplied.<br />
****Misspelling is not compatible with with emendation, unnecessary replacement, nomen nudum, incorrect original spelling, junior synonym, and misapplied.<br />
****Unnecessary replacement is not compatible with emendation, misspelling, junior synonym, and misapplied.<br />
****Nomen nudum is not compatible with emendation, misspelling, junior synonym, and misapplied.<br />
****Incorrect original spelling is not compatible with misspelling, unnecessary replacement, nomen nudum, and misapplied.<br />
****Junior synonym is not compatible with misspelling, unnecessary replacement, nomen nudum, and misapplied.<br />
****Misapplied is not compatible with emendation, misspelling, unnecessary replacement, nomen nudum, incorrect original spelling, junior synonym, and misapplied.<br />
****Note that, theoretically, the following status values may be used in combination with any other status value, but in some cases this may be illogical: Junior homonym, suppressed by ruling, unavailable (other reason), incertae sedis, nomen dubium, nomen oblitum, nomen novum, nomen protectum, unnamed.<br />
*UnavailFlags, integer, 4 bytes, interpreted bitwise. This new column will contain flags moved here from StatusFlags.<br />
**1 = informal name, compatible only with tblTaxa.NameStatus = 2 or 7<br />
**2 = subsequent misspelling, compatible only with tblTaxa.NameStatus = 7<br />
**4 = nomen nudum, compatible only with tblTaxa.NameStatus = 2 or 4 when rank is less than parent rank or = 7 when rank is same as parent<br />
**8 = suppressed, compatible only with tblTaxa.NameStatus = 7<br />
**0x10 (16) = misapplied, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7<br />
**0x20 (32) = preoccupied (genus-group names), compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x40 (64) = primary homonym (species-group names), compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x80 (128) = incorrect original spelling, compatible only with tblTaxa.Namestatus = 2, 4, 5 or 7<br />
**0x100 (256) = unavailable, other reason, compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x200 (512) = lapsus calami, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7<br />
*OriginalGenusID, integer, 4 bytes, = tblTaxa.TaxonNameID, used only for species-group taxa other than a species that has subspecies, TaxonNameID for the genus in which the species was originally described, = 0 if unknown, -1 identifies cases where the previously recorded original genus did not exist when the species was described. If a genus and subgenus have the same name, use the TaxonNameID of the subgenus.<br />
*Distribution, text, 400 characters maximum.<br />
*Ecology, text, 400 characters maximum.<br />
*Comment, text, 400 characters maximum, explanation relating to the status of the name.<br />
*ExpertID, integer, 4 bytes, = tblExperts.ExpertID for the person recorded as expert for this taxon<br />
*ExpertReason, integer, 1 byte, reason expert assigned, 0 = no expert assigned, 1 = by default, 2 = by hierarchy only, 3 = by hierarchy and geography, 11 = cascaded by default, 12 = cascaded by hierarchy only, 13 = cascaded by hierarchy and geography<br />
**When a new taxon is created or a taxon becomes valid, the ExpertID is copied from the new AboveID. If the ExpertID and ExpertReason of the AboveID is 0, the new/now valid taxon values are also 0. If the ExpertReason of the AboveID is less than 10 (but greater than 0), add 10 to the ExpertReason of the AboveID to derive the ExpertReason value for the new/now valid taxon. Use the same ExpertReason value for the new/now valid taxon if the ExpertReason of the AboveID is greater than 9.<br />
*CurrentConceptRefID, integer, 4 bytes, = tblRefs.RefID, identifies the reference that initiated the currently accepted concept. If there is no currently accepted concept for the name, then this is the reference that terminated the concept.<br />
*LifeZone, integer, 1 byte, bit values:<br />
**1 = Marine<br />
**2 = Brackish<br />
**4 = Freshwater<br />
**8 = Terrestrial<br />
*LastUpdate, smalldatetime, date and time row last updated<br />
*ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
*CreatedOn, smalldatetime, date and time row was created<br />
*CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
[[Category:TaxaTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/Taxa_(table)Taxa (table)2013-07-10T14:26:25Z<p>Dceades: </p>
<hr />
<div>'''tblTaxa''' contains taxon names at all ranks, including synonyms and other non valid names.<br />
<br />
*TaxonNameID, integer, 4 bytes, unique identifier for the taxon name. This number can be used to enter the database at this name.<br />
*FileID, integer, 4 bytes, = tblFiles.FileID<br />
*TaxonNameStr, text, 300 characters maximum. A series of TaxonNameID in text form and separated by "-". <br />
**If a taxon is at genus rank and is not a synonym, the text of TaxonNameID is followed by "g". This makes forming binomial names more efficient.<br />
**If a taxon is at subgenus rank and is not a synonym, the text of TaxonNameID is followed by "s".<br />
**For all taxa immediately subordinate to the apex taxon, TaxonNameStr begins with the TaxonNameID of the apex taxon followed by "-" (or "g-" if the apex taxon is at genus rank) and the TaxonNameID of the subordinate.<br />
**The chain of TaxonNameIDs grows moving down the hierarchy by adding "-" and the TaxonNameID (and "g" or "s" when appropriate).<br />
**For all taxa outside the primary scope, TaxonNameStr begins with "0-".<br />
***For genera (and rarely other ranks) outside the primary scope, TaxonNameStr begins with "0-0-". This is needed for tblTaxa.OriginalGenusID, for genera in nomenclator information for citations, and for taxa providing images or sounds.<br />
***For context taxa outside the primary scope, TaxonNameStr begins with "0-1-". Such taxa provide some context around the apex taxon.<br />
***For taxa previously within the primary scope but now outside, TaxonNameStr begins with "0-2-". This enables finding such taxa in searches so that users can be told about the change in status.<br />
***For reserved values of TaxonNameID, TaxonNameStr begins with "0-3-". These values are held in reserve for when private species files are merged.<br />
***For family-group taxa outside the primary scope (needed for tblTypeSpecies.FirstFamGrpNameID), TaxonNameStr begins with "0-4-".<br />
*RankID, integer, 4 bytes, = tblRanks.RankID, number for rank in hierarchy<br />
*Name, text, 30 characters maximum, name of taxon<br />
*Parens, boolean, enclose author name in parens?<br />
*AboveID, integer, 4 bytes, = tblTaxa.TaxonNameID of the next higher taxon in the hierarchy. If this taxon is a synonym or other not valid name, then this is the TaxonNameID for the valid taxon. AboveID cannot be the TaxonNameID for a genus having subgenera or a species having subspecies: In those cases, use the TaxonNameID of the nominotypical subgenus or subspecies.<br />
*LikeNameID, integer 4 bytes, = 0 unless this is a special case. Special cases are<br />
**Valid or temporary taxa<br />
***Genus, then = tblTaxa.TaxonNameID of subgenus by same name<br />
***Subgenus, then = tblTaxa.TaxonNameID of genus by same name<br />
***Species, then = tblTaxa.TaxonNameID of subspecies by same name<br />
***Subspecies, then = tblTaxa.TaxonNameID of species by same name<br />
*Extinct, integer, 1 byte, 0 = extant, 1 = extinct; if NameStatus is synonym, then the value of Extinct is ignored. Could be changed to allow additional values such as threatened, endangered and presumed extirpated.<br />
*HasPreHolocene, bit, 0 = no fossils, 1 = one or more fossils are known to exist; if NameStatus = 7 (synonym), then the value of HasPreHolocene is ignored. This will be implemented during summer, 2013.<br />
*HasModern, bit, 0 = no Recent specimens, 1 = one or more Recent specimens are known to exist; if NameStatus = 7(synonym), then the value of HasModern is ignored. This will be implemented during summer, 2013.<br />
*RefID, integer, 4 bytes, = tblRefs.RefID for the original description of the taxon. CAUTION: For family-group taxa, this is the first use of the name in its current form. The author and date for priority are based on the first use of any name based on the same type genus. To locate this information, trace via tblTypeGenera.GenusNameID to tblTypeSpecies.FirstFamGrpNameID to tblTaxa.RefID of that first name. For taxa above superfamily rank, RefID is always 0. Taxa at a rank above species and below subgenus also have RefID = 0.<br />
*NecAuthor, text, 200 characters maximum, author who used name correctly sometimes with additional information<br />
*DataFlags, integer, 2 bytes, with bitwise flags for type of data present<br />
**1 = image<br />
**2 = sound<br />
**4 = link to other website<br />
**8 = specimen data<br />
**0x10 (16) = scrutiny<br />
**0x20 (32) = key group<br />
**0x40 (64) = supplementary information<br />
**0x80 (128) = common name<br />
**0x100 (256) = related taxon<br />
**0x200 (512) = automatic link to other website<br />
**0x400 (1024) = ecological relationship<br />
**0x800 (2048) = valid taxon name string (used exclusively in spTestAboveIDvsTaxonNameStr)<br />
**0x1000 (4096) = has specimen(s) with latitude/longitude data useable for maps, applies to taxa at rank tribe or lower<br />
*AccessCode, integer, 4 bytes, = tblAccessCodes.AccessCode<br />
*NameStatus, integer, 1 byte<br />
**0 = valid<br />
**2 = temporary name for use until a valid name is provided (subordinate names limited to temporary names and synonyms)<br />
**4 = nomen nudum, must be at lower rank than parent (subordinate names limited to nomina nuda)<br />
**5 = nomen dubium, must be at lower rank than parent (subordinate names limited to nomina nuda and dubia)<br />
**7 = synonym (subordinate taxa not allowed)<br />
*StatusFlags, integer, 4 bytes, interpreted bitwise. We have run out of bits. To solve this, some flags will be moved to a new column UnavailFlags.<br />
**1 = informal name, compatible only with tblTaxa.NameStatus = 2 or 7. Will be moved to UnavailFlags.<br />
**2 = subsequent misspelling, compatible only with tblTaxa.NameStatus = 7. Will be moved to UnavailFlags.<br />
**4 = unjustified emendation, compatible only with tblTaxa.NameStatus = 7. New value will be 1.<br />
**8 = nomen nudum, compatible only with tblTaxa.NameStatus = 2 or 4 when rank is less than parent rank or = 7 when rank is same as parent. Will be moved to UnavailFlags.<br />
**0x10 (16) = nomen dubium, compatible only with tblTaxa.NameStatus = 5 when rank is less than parent rank or = 7 when rank is same as parent. New value will be 2.<br />
**0x20 (32) = incertae sedis, compatible only with tblTaxa.NameStatus = 0 or 2. New value will be 4.<br />
**0x40 (64) = required emendation, compatible only with tblTaxa.NameStatus = 0, 2 or 7. New value will be 8.<br />
**0x80 (128) = nomen protectum, compatible only with tblTaxa.NameStatus = 0 or 7. New value will be 0x10.<br />
**0x100 (256) = suppressed, compatible only with tblTaxa.NameStatus = 7. Will be moved to UnavailFlags.<br />
**0x200 (512) = misapplied, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7. Will be moved to UnavailFlags.<br />
**0x400 (1024) = preoccupied (genus-group names), compatible only with tblTaxa.NameStatus = 2 or 7. Will be moved to UnavailFlags.<br />
**0x800 (2048) = primary homonym (species-group names), compatible only with tblTaxa.NameStatus = 2 or 7. Will be moved to UnavailFlags.<br />
**0x1000 (4096) = secondary homonym (species-group names), compatible only with tblTaxa.NameStatus = 2 or 7. New value will be 0x20.<br />
**0x2000 (8192) = nomen oblitum, compatible only with tblTaxa.NameStatus = 7. New value will be 0x40.<br />
**0x4000 (16384) = unnecessary replacement name, compatible only with tblTaxa.NameStatus = 7. New value will be 0x80.<br />
**0x8000 (32768) = incorrect original spelling, compatible only with tblTaxa.Namestatus = 2, 4, 5 or 7. Will be moved to UnavailFlags.<br />
**0x10000 (65536) = other, explained by tblTaxa.Comment, compatible only with tblTaxa.NameStatus = 0, 2 or 7. New value will be 0x100.<br />
**0x20000 (131072) = unavailable, other reason, compatible only with tblTaxa.NameStatus = 2 or 7. Will be moved to UnavailFlags.<br />
**0x40000 (262144) = junior synonym, compatible only with tblTaxa.NameStatus = 7. New value will be 0x200.<br />
**0x80000 (524288) = nomen novum, compatible only with tblTaxa.Namestatus = 0, 2, or 7. New value will be 0x400.<br />
**0x100000 (1048576) = original name, used only for family-group names, compatible only with tblTaxa.NameStatus = 7. New value will be 0x800.<br />
**0x200000 (2097152) = subsequent name, used only for family-group names, compatible with any tblTaxa.NameStatus value. New value will be 0x1000.<br />
**0x400000 (4194304) = junior homonym for species-group name not specified as primary or secondary, compatible only with tblTaxa.NameStatus = 2 or 7. New value will be 0x2000.<br />
**0x800000 (8388608) = lapsus calami, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7. Will be moved to UnavailFlags.<br />
**0x1000000 (16777216) = corrected lapsus calami, compatible only with tblTaxa.NameStatus = 0, 2 or 7. New value will be 0x4000.<br />
**0x2000000 (33554432) = nomen nudum made available, compatible only with tblTaxa.NameStatus = 0, 2 or 7. New value will be 0x8000.<br />
**The following columns are planned to provide a basis for added relationships in tblRelatedTaxa.<br />
***0x1000 senior homonym (opposite junior homonym)<br />
***0x2000 correct not replaced (opposite unnecessary replacement)<br />
***0x4000 correct not emended (opposite unjustified emendation)<br />
***0x8000 correct as spelled (opposite subsequent misspelling)<br />
***0x10000 misapplied to (opposite misapplied)<br />
***0x20000 correct usage of misapplied (opposite misapplied)<br />
**Notes about StatusFlags.<br />
***Type data for taxa is available based on rank and name status:<br />
****No type data for ranks above superfamily.<br />
****No type data for ranks of subgenus through superfamily with name status of misapplied (0x200).<br />
****No type data for ranks above species and below subgenus.<br />
****No type data for ranks of species level and below for emendation (unjustified and required), misspelling, nomen nudum, unnecessary replacement, nomen novum, and misapplied (0x8424E) OR NameStatus = 4 (nomen nudum).<br />
***Age qualification is required for the following NameStatus values:<br />
****Junior synonym must not be older than the valid name.<br />
****Unjustified emendation, misspelling, and unnecessary replacement must not be older than the correct name.<br />
****Incorrectly formed name must not be younger than the justified emendation name.<br />
****Nomen novum must not be younger than the homonym replaced.<br />
****Nomen oblitum must not be younger than the valid name.<br />
***Taxa may have more than one status flag set. However, there are restrictions for certain status values. Unless stated below, more than one status flag may be set:<br />
****Emendation is not compatible with misspelling, unnecessary replacement, nomen nudum, incorrect original spelling, and misapplied.<br />
****Misspelling is not compatible with with emendation, unnecessary replacement, nomen nudum, incorrect original spelling, junior synonym, and misapplied.<br />
****Unnecessary replacement is not compatible with emendation, misspelling, junior synonym, and misapplied.<br />
****Nomen nudum is not compatible with emendation, misspelling, junior synonym, and misapplied.<br />
****Incorrect original spelling is not compatible with misspelling, unnecessary replacement, nomen nudum, and misapplied.<br />
****Junior synonym is not compatible with misspelling, unnecessary replacement, nomen nudum, and misapplied.<br />
****Misapplied is not compatible with emendation, misspelling, unnecessary replacement, nomen nudum, incorrect original spelling, junior synonym, and misapplied.<br />
****Note that, theoretically, the following status values may be used in combination with any other status value, but in some cases this may be illogical: Junior homonym, suppressed by ruling, unavailable (other reason), incertae sedis, nomen dubium, nomen oblitum, nomen novum, nomen protectum, unnamed.<br />
*UnavailFlags, integer, 4 bytes, interpreted bitwise. This new column will contain flags moved here from StatusFlags.<br />
**1 = informal name, compatible only with tblTaxa.NameStatus = 2 or 7<br />
**2 = subsequent misspelling, compatible only with tblTaxa.NameStatus = 7<br />
**4 = nomen nudum, compatible only with tblTaxa.NameStatus = 2 or 4 when rank is less than parent rank or = 7 when rank is same as parent<br />
**8 = suppressed, compatible only with tblTaxa.NameStatus = 7<br />
**0x10 (16) = misapplied, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7<br />
**0x20 (32) = preoccupied (genus-group names), compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x40 (64) = primary homonym (species-group names), compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x80 (128) = incorrect original spelling, compatible only with tblTaxa.Namestatus = 2, 4, 5 or 7<br />
**0x100 (256) = unavailable, other reason, compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x200 (512) = lapsus calami, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7<br />
*OriginalGenusID, integer, 4 bytes, = tblTaxa.TaxonNameID, used only for species-group taxa other than a species that has subspecies, TaxonNameID for the genus in which the species was originally described, = 0 if unknown, -1 identifies cases where the previously recorded original genus did not exist when the species was described. If a genus and subgenus have the same name, use the TaxonNameID of the subgenus.<br />
*Distribution, text, 400 characters maximum.<br />
*Ecology, text, 400 characters maximum.<br />
*Comment, text, 400 characters maximum, explanation relating to the status of the name.<br />
*ExpertID, integer, 4 bytes, = tblExperts.ExpertID for the person recorded as expert for this taxon<br />
*ExpertReason, integer, 1 byte, reason expert assigned, 0 = no expert assigned, 1 = by default, 2 = by hierarchy only, 3 = by hierarchy and geography, 11 = cascaded by default, 12 = cascaded by hierarchy only, 13 = cascaded by hierarchy and geography<br />
**When a new taxon is created or a taxon becomes valid, the ExpertID is copied from the new AboveID. If the ExpertID and ExpertReason of the AboveID is 0, the new/now valid taxon values are also 0. If the ExpertReason of the AboveID is less than 10 (but greater than 0), add 10 to the ExpertReason of the AboveID to derive the ExpertReason value for the new/now valid taxon. Use the same ExpertReason value for the new/now valid taxon if the ExpertReason of the AboveID is greater than 9.<br />
*CurrentConceptRefID, integer, 4 bytes, = tblRefs.RefID, identifies the reference that initiated the currently accepted concept. If there is no currently accepted concept for the name, then this is the reference that terminated the concept.<br />
*LifeZone, integer, 1 byte, bit values:<br />
**1 = Marine<br />
**2 = Brackish<br />
**4 = Freshwater<br />
**8 = Terrestrial<br />
*LastUpdate, smalldatetime, date and time row last updated<br />
*ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
*CreatedOn, smalldatetime, date and time row was created<br />
*CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
[[Category:TaxaTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/Taxa_(table)Taxa (table)2013-07-09T19:53:00Z<p>Dceades: </p>
<hr />
<div>'''tblTaxa''' contains taxon names at all ranks, including synonyms and other non valid names.<br />
<br />
*TaxonNameID, integer, 4 bytes, unique identifier for the taxon name. This number can be used to enter the database at this name.<br />
*FileID, integer, 4 bytes, = tblFiles.FileID<br />
*TaxonNameStr, text, 300 characters maximum. A series of TaxonNameID in text form and separated by "-". <br />
**If a taxon is at genus rank and is not a synonym, the text of TaxonNameID is followed by "g". This makes forming binomial names more efficient.<br />
**If a taxon is at subgenus rank and is not a synonym, the text of TaxonNameID is followed by "s".<br />
**For all taxa immediately subordinate to the apex taxon, TaxonNameStr begins with the TaxonNameID of the apex taxon followed by "-" (or "g-" if the apex taxon is at genus rank) and the TaxonNameID of the subordinate.<br />
**The chain of TaxonNameIDs grows moving down the hierarchy by adding "-" and the TaxonNameID (and "g" or "s" when appropriate).<br />
**For all taxa outside the primary scope, TaxonNameStr begins with "0-".<br />
***For genera (and rarely other ranks) outside the primary scope, TaxonNameStr begins with "0-0-". This is needed for tblTaxa.OriginalGenusID, for genera in nomenclator information for citations, and for taxa providing images or sounds.<br />
***For context taxa outside the primary scope, TaxonNameStr begins with "0-1-". Such taxa provide some context around the apex taxon.<br />
***For taxa previously within the primary scope but now outside, TaxonNameStr begins with "0-2-". This enables finding such taxa in searches so that users can be told about the change in status.<br />
***For reserved values of TaxonNameID, TaxonNameStr begins with "0-3-". These values are held in reserve for when private species files are merged.<br />
***For family-group taxa outside the primary scope (needed for tblTypeSpecies.FirstFamGrpNameID), TaxonNameStr begins with "0-4-".<br />
*RankID, integer, 4 bytes, = tblRanks.RankID, number for rank in hierarchy<br />
*Name, text, 30 characters maximum, name of taxon<br />
*Parens, boolean, enclose author name in parens?<br />
*AboveID, integer, 4 bytes, = tblTaxa.TaxonNameID of the next higher taxon in the hierarchy. If this taxon is a synonym or other not valid name, then this is the TaxonNameID for the valid taxon. AboveID cannot be the TaxonNameID for a genus having subgenera or a species having subspecies: In those cases, use the TaxonNameID of the nominotypical subgenus or subspecies.<br />
*LikeNameID, integer 4 bytes, = 0 unless this is a special case. Special cases are<br />
**Valid or temporary taxa<br />
***Genus, then = tblTaxa.TaxonNameID of subgenus by same name<br />
***Subgenus, then = tblTaxa.TaxonNameID of genus by same name<br />
***Species, then = tblTaxa.TaxonNameID of subspecies by same name<br />
***Subspecies, then = tblTaxa.TaxonNameID of species by same name<br />
*Extinct, integer, 1 byte, 0 = extinct, 1 = extant; if NameStatus is valid, temporary or nomen dubium, then Extinct is NULL. Could be changed to allow additional values such as threatened, endangered and presumed extirpated.<br />
*HasPreHolocene, bit, 0 = no fossils, 1 = one or more fossils are known to exist; if NameStatus is valid, temporary or nomen dubium, then HasFossil is NULL. This will be implemented during summer, 2013.<br />
*HasModern, bit, 0 = no Recent specimens, 1 = one or more Recent specimens are known to exist; if NameStatus is valid, temporary or nomen dubium, then HasRecent is NULL. This will be implemented during summer, 2013.<br />
*RefID, integer, 4 bytes, = tblRefs.RefID for the original description of the taxon. CAUTION: For family-group taxa, this is the first use of the name in its current form. The author and date for priority are based on the first use of any name based on the same type genus. To locate this information, trace via tblTypeGenera.GenusNameID to tblTypeSpecies.FirstFamGrpNameID to tblTaxa.RefID of that first name. For taxa above superfamily rank, RefID is always 0. Taxa at a rank above species and below subgenus also have RefID = 0.<br />
*NecAuthor, text, 200 characters maximum, author who used name correctly sometimes with additional information<br />
*DataFlags, integer, 2 bytes, with bitwise flags for type of data present<br />
**1 = image<br />
**2 = sound<br />
**4 = link to other website<br />
**8 = specimen data<br />
**0x10 (16) = scrutiny<br />
**0x20 (32) = key group<br />
**0x40 (64) = supplementary information<br />
**0x80 (128) = common name<br />
**0x100 (256) = related taxon<br />
**0x200 (512) = automatic link to other website<br />
**0x400 (1024) = ecological relationship<br />
**0x800 (2048) = valid taxon name string (used exclusively in spTestAboveIDvsTaxonNameStr)<br />
**0x1000 (4096) = has specimen(s) with latitude/longitude data useable for maps, applies to taxa at rank tribe or lower<br />
*AccessCode, integer, 4 bytes, = tblAccessCodes.AccessCode<br />
*NameStatus, integer, 1 byte<br />
**0 = valid<br />
**2 = temporary name for use until a valid name is provided (subordinate names limited to temporary names and synonyms)<br />
**4 = nomen nudum, must be at lower rank than parent (subordinate names limited to nomina nuda)<br />
**5 = nomen dubium, must be at lower rank than parent (subordinate names limited to nomina nuda and dubia)<br />
**7 = synonym (subordinate taxa not allowed)<br />
*StatusFlags, integer, 4 bytes, interpreted bitwise. We have run out of bits. To solve this, some flags will be moved to a new column UnavailFlags.<br />
**1 = informal name, compatible only with tblTaxa.NameStatus = 2 or 7. Will be moved to UnavailFlags.<br />
**2 = subsequent misspelling, compatible only with tblTaxa.NameStatus = 7. Will be moved to UnavailFlags.<br />
**4 = unjustified emendation, compatible only with tblTaxa.NameStatus = 7. New value will be 1.<br />
**8 = nomen nudum, compatible only with tblTaxa.NameStatus = 2 or 4 when rank is less than parent rank or = 7 when rank is same as parent. Will be moved to UnavailFlags.<br />
**0x10 (16) = nomen dubium, compatible only with tblTaxa.NameStatus = 5 when rank is less than parent rank or = 7 when rank is same as parent. New value will be 2.<br />
**0x20 (32) = incertae sedis, compatible only with tblTaxa.NameStatus = 0 or 2. New value will be 4.<br />
**0x40 (64) = required emendation, compatible only with tblTaxa.NameStatus = 0, 2 or 7. New value will be 8.<br />
**0x80 (128) = nomen protectum, compatible only with tblTaxa.NameStatus = 0 or 7. New value will be 0x10.<br />
**0x100 (256) = suppressed, compatible only with tblTaxa.NameStatus = 7. Will be moved to UnavailFlags.<br />
**0x200 (512) = misapplied, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7. Will be moved to UnavailFlags.<br />
**0x400 (1024) = preoccupied (genus-group names), compatible only with tblTaxa.NameStatus = 2 or 7. Will be moved to UnavailFlags.<br />
**0x800 (2048) = primary homonym (species-group names), compatible only with tblTaxa.NameStatus = 2 or 7. Will be moved to UnavailFlags.<br />
**0x1000 (4096) = secondary homonym (species-group names), compatible only with tblTaxa.NameStatus = 2 or 7. New value will be 0x20.<br />
**0x2000 (8192) = nomen oblitum, compatible only with tblTaxa.NameStatus = 7. New value will be 0x40.<br />
**0x4000 (16384) = unnecessary replacement name, compatible only with tblTaxa.NameStatus = 7. New value will be 0x80.<br />
**0x8000 (32768) = incorrect original spelling, compatible only with tblTaxa.Namestatus = 2, 4, 5 or 7. Will be moved to UnavailFlags.<br />
**0x10000 (65536) = other, explained by tblTaxa.Comment, compatible only with tblTaxa.NameStatus = 0, 2 or 7. New value will be 0x100.<br />
**0x20000 (131072) = unavailable, other reason, compatible only with tblTaxa.NameStatus = 2 or 7. Will be moved to UnavailFlags.<br />
**0x40000 (262144) = junior synonym, compatible only with tblTaxa.NameStatus = 7. New value will be 0x200.<br />
**0x80000 (524288) = nomen novum, compatible only with tblTaxa.Namestatus = 0, 2, or 7. New value will be 0x400.<br />
**0x100000 (1048576) = original name, used only for family-group names, compatible only with tblTaxa.NameStatus = 7. New value will be 0x800.<br />
**0x200000 (2097152) = subsequent name, used only for family-group names, compatible with any tblTaxa.NameStatus value. New value will be 0x1000.<br />
**0x400000 (4194304) = junior homonym for species-group name not specified as primary or secondary, compatible only with tblTaxa.NameStatus = 2 or 7. New value will be 0x2000.<br />
**0x800000 (8388608) = lapsus calami, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7. Will be moved to UnavailFlags.<br />
**0x1000000 (16777216) = corrected lapsus calami, compatible only with tblTaxa.NameStatus = 0, 2 or 7. New value will be 0x4000.<br />
**0x2000000 (33554432) = nomen nudum made available, compatible only with tblTaxa.NameStatus = 0, 2 or 7. New value will be 0x8000.<br />
**The following columns are planned to provide a basis for added relationships in tblRelatedTaxa.<br />
***0x1000 senior homonym (opposite junior homonym)<br />
***0x2000 correct not replaced (opposite unnecessary replacement)<br />
***0x4000 correct not emended (opposite unjustified emendation)<br />
***0x8000 correct as spelled (opposite subsequent misspelling)<br />
***0x10000 misapplied to (opposite misapplied)<br />
***0x20000 correct usage of misapplied (opposite misapplied)<br />
**Notes about StatusFlags.<br />
***Type data for taxa is available based on rank and name status:<br />
****No type data for ranks above superfamily.<br />
****No type data for ranks of subgenus through superfamily with name status of misapplied (0x200).<br />
****No type data for ranks above species and below subgenus.<br />
****No type data for ranks of species level and below for emendation (unjustified and required), misspelling, nomen nudum, unnecessary replacement, nomen novum, and misapplied (0x8424E) OR NameStatus = 4 (nomen nudum).<br />
***Age qualification is required for the following NameStatus values:<br />
****Junior synonym must not be older than the valid name.<br />
****Unjustified emendation, misspelling, and unnecessary replacement must not be older than the correct name.<br />
****Incorrectly formed name must not be younger than the justified emendation name.<br />
****Nomen novum must not be younger than the homonym replaced.<br />
****Nomen oblitum must not be younger than the valid name.<br />
***Taxa may have more than one status flag set. However, there are restrictions for certain status values. Unless stated below, more than one status flag may be set:<br />
****Emendation is not compatible with misspelling, unnecessary replacement, nomen nudum, incorrect original spelling, and misapplied.<br />
****Misspelling is not compatible with with emendation, unnecessary replacement, nomen nudum, incorrect original spelling, junior synonym, and misapplied.<br />
****Unnecessary replacement is not compatible with emendation, misspelling, junior synonym, and misapplied.<br />
****Nomen nudum is not compatible with emendation, misspelling, junior synonym, and misapplied.<br />
****Incorrect original spelling is not compatible with misspelling, unnecessary replacement, nomen nudum, and misapplied.<br />
****Junior synonym is not compatible with misspelling, unnecessary replacement, nomen nudum, and misapplied.<br />
****Misapplied is not compatible with emendation, misspelling, unnecessary replacement, nomen nudum, incorrect original spelling, junior synonym, and misapplied.<br />
****Note that, theoretically, the following status values may be used in combination with any other status value, but in some cases this may be illogical: Junior homonym, suppressed by ruling, unavailable (other reason), incertae sedis, nomen dubium, nomen oblitum, nomen novum, nomen protectum, unnamed.<br />
*UnavailFlags, integer, 4 bytes, interpreted bitwise. This new column will contain flags moved here from StatusFlags.<br />
**1 = informal name, compatible only with tblTaxa.NameStatus = 2 or 7<br />
**2 = subsequent misspelling, compatible only with tblTaxa.NameStatus = 7<br />
**4 = nomen nudum, compatible only with tblTaxa.NameStatus = 2 or 4 when rank is less than parent rank or = 7 when rank is same as parent<br />
**8 = suppressed, compatible only with tblTaxa.NameStatus = 7<br />
**0x10 (16) = misapplied, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7<br />
**0x20 (32) = preoccupied (genus-group names), compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x40 (64) = primary homonym (species-group names), compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x80 (128) = incorrect original spelling, compatible only with tblTaxa.Namestatus = 2, 4, 5 or 7<br />
**0x100 (256) = unavailable, other reason, compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x200 (512) = lapsus calami, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7<br />
*OriginalGenusID, integer, 4 bytes, = tblTaxa.TaxonNameID, used only for species-group taxa other than a species that has subspecies, TaxonNameID for the genus in which the species was originally described, = 0 if unknown, -1 identifies cases where the previously recorded original genus did not exist when the species was described. If a genus and subgenus have the same name, use the TaxonNameID of the subgenus.<br />
*Distribution, text, 400 characters maximum.<br />
*Ecology, text, 400 characters maximum.<br />
*Comment, text, 400 characters maximum, explanation relating to the status of the name.<br />
*ExpertID, integer, 4 bytes, = tblExperts.ExpertID for the person recorded as expert for this taxon<br />
*ExpertReason, integer, 1 byte, reason expert assigned, 0 = no expert assigned, 1 = by default, 2 = by hierarchy only, 3 = by hierarchy and geography, 11 = cascaded by default, 12 = cascaded by hierarchy only, 13 = cascaded by hierarchy and geography<br />
**When a new taxon is created or a taxon becomes valid, the ExpertID is copied from the new AboveID. If the ExpertID and ExpertReason of the AboveID is 0, the new/now valid taxon values are also 0. If the ExpertReason of the AboveID is less than 10 (but greater than 0), add 10 to the ExpertReason of the AboveID to derive the ExpertReason value for the new/now valid taxon. Use the same ExpertReason value for the new/now valid taxon if the ExpertReason of the AboveID is greater than 9.<br />
*CurrentConceptRefID, integer, 4 bytes, = tblRefs.RefID, identifies the reference that initiated the currently accepted concept. If there is no currently accepted concept for the name, then this is the reference that terminated the concept.<br />
*LifeZone, integer, 1 byte, bit values:<br />
**1 = Marine<br />
**2 = Brackish<br />
**4 = Freshwater<br />
**8 = Terrestrial<br />
*LastUpdate, smalldatetime, date and time row last updated<br />
*ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
*CreatedOn, smalldatetime, date and time row was created<br />
*CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
[[Category:TaxaTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/Taxa_(table)Taxa (table)2013-06-10T14:53:20Z<p>Dceades: </p>
<hr />
<div>'''tblTaxa''' contains taxon names at all ranks, including synonyms and other non valid names.<br />
<br />
*TaxonNameID, integer, 4 bytes, unique identifier for the taxon name. This number can be used to enter the database at this name.<br />
*FileID, integer, 4 bytes, = tblFiles.FileID<br />
*TaxonNameStr, text, 300 characters maximum. A series of TaxonNameID in text form and separated by "-". <br />
**If a taxon is at genus rank and is not a synonym, the text of TaxonNameID is followed by "g". This makes forming binomial names more efficient.<br />
**If a taxon is at subgenus rank and is not a synonym, the text of TaxonNameID is followed by "s".<br />
**For all taxa immediately subordinate to the apex taxon, TaxonNameStr begins with the TaxonNameID of the apex taxon followed by "-" (or "g-" if the apex taxon is at genus rank) and the TaxonNameID of the subordinate.<br />
**The chain of TaxonNameIDs grows moving down the hierarchy by adding "-" and the TaxonNameID (and "g" or "s" when appropriate).<br />
**For all taxa outside the primary scope, TaxonNameStr begins with "0-".<br />
***For genera (and rarely other ranks) outside the primary scope, TaxonNameStr begins with "0-0-". This is needed for tblTaxa.OriginalGenusID, for genera in nomenclator information for citations, and for taxa providing images or sounds.<br />
***For context taxa outside the primary scope, TaxonNameStr begins with "0-1-". Such taxa provide some context around the apex taxon.<br />
***For taxa previously within the primary scope but now outside, TaxonNameStr begins with "0-2-". This enables finding such taxa in searches so that users can be told about the change in status.<br />
***For reserved values of TaxonNameID, TaxonNameStr begins with "0-3-". These values are held in reserve for when private species files are merged.<br />
***For family-group taxa outside the primary scope (needed for tblTypeSpecies.FirstFamGrpNameID), TaxonNameStr begins with "0-4-".<br />
*RankID, integer, 4 bytes, = tblRanks.RankID, number for rank in hierarchy<br />
*Name, text, 30 characters maximum, name of taxon<br />
*Parens, boolean, enclose author name in parens?<br />
*AboveID, integer, 4 bytes, = tblTaxa.TaxonNameID of the next higher taxon in the hierarchy. If this taxon is a synonym or other not valid name, then this is the TaxonNameID for the valid taxon. AboveID cannot be the TaxonNameID for a genus having subgenera or a species having subspecies: In those cases, use the TaxonNameID of the nominotypical subgenus or subspecies.<br />
*LikeNameID, integer 4 bytes, = 0 unless this is a special case. Special cases are<br />
**Valid or temporary taxa<br />
***Genus, then = tblTaxa.TaxonNameID of subgenus by same name<br />
***Subgenus, then = tblTaxa.TaxonNameID of genus by same name<br />
***Species, then = tblTaxa.TaxonNameID of subspecies by same name<br />
***Subspecies, then = tblTaxa.TaxonNameID of species by same name<br />
*HasFossil, bit, 0 = no fossils, 1 = one or more fossils are known to exist; if NameStatus > 2, then HasFossil is NULL. This will be implemented during summer, 2013.<br />
*HasRecent, bit, 0 = no Recent specimens, 1 = one or more Recent specimens are known to exist; if NameStatus > 2, then HasRecent is NULL. This will be implemented during summer, 2013.<br />
*Extinct, integer, 1 byte, 0 = extinct, 1 = extant; if NameStatus > 2, then Extinct is NULL.) Could be changed to allow additional values such as threatened, endangered and presumed extirpated.<br />
*RefID, integer, 4 bytes, = tblRefs.RefID for the original description of the taxon. CAUTION: For family-group taxa, this is the first use of the name in its current form. The author and date for priority are based on the first use of any name based on the same type genus. To locate this information, trace via tblTypeGenera.GenusNameID to tblTypeSpecies.FirstFamGrpNameID to tblTaxa.RefID of that first name. For taxa above superfamily rank, RefID is always 0. Taxa at a rank above species and below subgenus also have RefID = 0.<br />
*NecAuthor, text, 200 characters maximum, author who used name correctly sometimes with additional information<br />
*DataFlags, integer, 2 bytes, with bitwise flags for type of data present<br />
**1 = image<br />
**2 = sound<br />
**4 = link to other website<br />
**8 = specimen data<br />
**0x10 (16) = scrutiny<br />
**0x20 (32) = key group<br />
**0x40 (64) = supplementary information<br />
**0x80 (128) = common name<br />
**0x100 (256) = related taxon<br />
**0x200 (512) = automatic link to other website<br />
**0x400 (1024) = ecological relationship<br />
**0x800 (2048) = valid taxon name string (used exclusively in spTestAboveIDvsTaxonNameStr)<br />
**0x1000 (4096) = has specimen(s) with latitude/longitude data useable for maps, applies to taxa at rank tribe or lower<br />
*AccessCode, integer, 4 bytes, = tblAccessCodes.AccessCode<br />
*NameStatus, integer, 1 byte<br />
**0 = valid<br />
**2 = temporary name for use until a valid name is provided (subordinate names limited to temporary names and synonyms)<br />
**4 = nomen nudum, must be at lower rank than parent (subordinate names limited to nomina nuda)<br />
**5 = nomen dubium, must be at lower rank than parent (subordinate names limited to nomina nuda and dubia)<br />
**7 = synonym (subordinate taxa not allowed)<br />
*StatusFlags, integer, 4 bytes, interpreted bitwise. We have run out of bits. To solve this, some flags will be moved to a new column UnavailFlags.<br />
**1 = informal name, compatible only with tblTaxa.NameStatus = 2 or 7. Will be moved to UnavailFlags.<br />
**2 = subsequent misspelling, compatible only with tblTaxa.NameStatus = 7. Will be moved to UnavailFlags.<br />
**4 = unjustified emendation, compatible only with tblTaxa.NameStatus = 7. New value will be 1.<br />
**8 = nomen nudum, compatible only with tblTaxa.NameStatus = 2 or 4 when rank is less than parent rank or = 7 when rank is same as parent. Will be moved to UnavailFlags.<br />
**0x10 (16) = nomen dubium, compatible only with tblTaxa.NameStatus = 5 when rank is less than parent rank or = 7 when rank is same as parent. New value will be 2.<br />
**0x20 (32) = incertae sedis, compatible only with tblTaxa.NameStatus = 0 or 2. New value will be 4.<br />
**0x40 (64) = required emendation, compatible only with tblTaxa.NameStatus = 0, 2 or 7. New value will be 8.<br />
**0x80 (128) = nomen protectum, compatible only with tblTaxa.NameStatus = 0 or 7. New value will be 0x10.<br />
**0x100 (256) = suppressed, compatible only with tblTaxa.NameStatus = 7. Will be moved to UnavailFlags.<br />
**0x200 (512) = misapplied, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7. Will be moved to UnavailFlags.<br />
**0x400 (1024) = preoccupied (genus-group names), compatible only with tblTaxa.NameStatus = 2 or 7. Will be moved to UnavailFlags.<br />
**0x800 (2048) = primary homonym (species-group names), compatible only with tblTaxa.NameStatus = 2 or 7. Will be moved to UnavailFlags.<br />
**0x1000 (4096) = secondary homonym (species-group names), compatible only with tblTaxa.NameStatus = 2 or 7. New value will be 0x20.<br />
**0x2000 (8192) = nomen oblitum, compatible only with tblTaxa.NameStatus = 7. New value will be 0x40.<br />
**0x4000 (16384) = unnecessary replacement name, compatible only with tblTaxa.NameStatus = 7. New value will be 0x80.<br />
**0x8000 (32768) = incorrect original spelling, compatible only with tblTaxa.Namestatus = 2, 4, 5 or 7. Will be moved to UnavailFlags.<br />
**0x10000 (65536) = other, explained by tblTaxa.Comment, compatible only with tblTaxa.NameStatus = 0, 2 or 7. New value will be 0x100.<br />
**0x20000 (131072) = unavailable, other reason, compatible only with tblTaxa.NameStatus = 2 or 7. Will be moved to UnavailFlags.<br />
**0x40000 (262144) = junior synonym, compatible only with tblTaxa.NameStatus = 7. New value will be 0x200.<br />
**0x80000 (524288) = nomen novum, compatible only with tblTaxa.Namestatus = 0, 2, or 7. New value will be 0x400.<br />
**0x100000 (1048576) = original name, used only for family-group names, compatible only with tblTaxa.NameStatus = 7. New value will be 0x800.<br />
**0x200000 (2097152) = subsequent name, used only for family-group names, compatible with any tblTaxa.NameStatus value. New value will be 0x1000.<br />
**0x400000 (4194304) = junior homonym for species-group name not specified as primary or secondary, compatible only with tblTaxa.NameStatus = 2 or 7. New value will be 0x2000.<br />
**0x800000 (8388608) = lapsus calami, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7. Will be moved to UnavailFlags.<br />
**0x1000000 (16777216) = corrected lapsus calami, compatible only with tblTaxa.NameStatus = 0, 2 or 7. New value will be 0x4000.<br />
**0x2000000 (33554432) = nomen nudum made available, compatible only with tblTaxa.NameStatus = 0, 2 or 7. New value will be 0x8000.<br />
**The following columns are planned to provide a basis for added relationships in tblRelatedTaxa.<br />
***0x1000 senior homonym (opposite junior homonym)<br />
***0x2000 correct not replaced (opposite unnecessary replacement)<br />
***0x4000 correct not emended (opposite unjustified emendation)<br />
***0x8000 correct as spelled (opposite subsequent misspelling)<br />
***0x10000 misapplied to (opposite misapplied)<br />
***0x20000 correct usage of misapplied (opposite misapplied)<br />
**Notes about StatusFlags.<br />
***Type data for taxa is available based on rank and name status:<br />
****No type data for ranks above superfamily.<br />
****No type data for ranks of subgenus through superfamily with name status of misapplied (0x200).<br />
****No type data for ranks above species and below subgenus.<br />
****No type data for ranks of species level and below for emendation (unjustified and required), misspelling, nomen nudum, unnecessary replacement, nomen novum, and misapplied (0x8424E) OR NameStatus = 4 (nomen nudum).<br />
***Age qualification is required for the following NameStatus values:<br />
****Junior synonym must not be older than the valid name.<br />
****Unjustified emendation, misspelling, and unnecessary replacement must not be older than the correct name.<br />
****Incorrectly formed name must not be younger than the justified emendation name.<br />
****Nomen novum must not be younger than the homonym replaced.<br />
****Nomen oblitum must not be younger than the valid name.<br />
***Taxa may have more than one status flag set. However, there are restrictions for certain status values. Unless stated below, more than one status flag may be set:<br />
****Emendation is not compatible with misspelling, unnecessary replacement, nomen nudum, incorrect original spelling, and misapplied.<br />
****Misspelling is not compatible with with emendation, unnecessary replacement, nomen nudum, incorrect original spelling, junior synonym, and misapplied.<br />
****Unnecessary replacement is not compatible with emendation, misspelling, junior synonym, and misapplied.<br />
****Nomen nudum is not compatible with emendation, misspelling, junior synonym, and misapplied.<br />
****Incorrect original spelling is not compatible with misspelling, unnecessary replacement, nomen nudum, and misapplied.<br />
****Junior synonym is not compatible with misspelling, unnecessary replacement, nomen nudum, and misapplied.<br />
****Misapplied is not compatible with emendation, misspelling, unnecessary replacement, nomen nudum, incorrect original spelling, junior synonym, and misapplied.<br />
****Note that, theoretically, the following status values may be used in combination with any other status value, but in some cases this may be illogical: Junior homonym, suppressed by ruling, unavailable (other reason), incertae sedis, nomen dubium, nomen oblitum, nomen novum, nomen protectum, unnamed.<br />
*UnavailFlags, integer, 4 bytes, interpreted bitwise. This new column will contain flags moved here from StatusFlags.<br />
**1 = informal name, compatible only with tblTaxa.NameStatus = 2 or 7<br />
**2 = subsequent misspelling, compatible only with tblTaxa.NameStatus = 7<br />
**4 = nomen nudum, compatible only with tblTaxa.NameStatus = 2 or 4 when rank is less than parent rank or = 7 when rank is same as parent<br />
**8 = suppressed, compatible only with tblTaxa.NameStatus = 7<br />
**0x10 (16) = misapplied, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7<br />
**0x20 (32) = preoccupied (genus-group names), compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x40 (64) = primary homonym (species-group names), compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x80 (128) = incorrect original spelling, compatible only with tblTaxa.Namestatus = 2, 4, 5 or 7<br />
**0x100 (256) = unavailable, other reason, compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x200 (512) = lapsus calami, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7<br />
*OriginalGenusID, integer, 4 bytes, = tblTaxa.TaxonNameID, used only for species-group taxa other than a species that has subspecies, TaxonNameID for the genus in which the species was originally described, = 0 if unknown, -1 identifies cases where the previously recorded original genus did not exist when the species was described. If a genus and subgenus have the same name, use the TaxonNameID of the subgenus.<br />
*Distribution, text, 400 characters maximum.<br />
*Ecology, text, 400 characters maximum.<br />
*Comment, text, 400 characters maximum, explanation relating to the status of the name.<br />
*ExpertID, integer, 4 bytes, = tblExperts.ExpertID for the person recorded as expert for this taxon<br />
*ExpertReason, integer, 1 byte, reason expert assigned, 0 = no expert assigned, 1 = by default, 2 = by hierarchy only, 3 = by hierarchy and geography, 11 = cascaded by default, 12 = cascaded by hierarchy only, 13 = cascaded by hierarchy and geography<br />
**When a new taxon is created or a taxon becomes valid, the ExpertID is copied from the new AboveID. If the ExpertID and ExpertReason of the AboveID is 0, the new/now valid taxon values are also 0. If the ExpertReason of the AboveID is less than 10 (but greater than 0), add 10 to the ExpertReason of the AboveID to derive the ExpertReason value for the new/now valid taxon. Use the same ExpertReason value for the new/now valid taxon if the ExpertReason of the AboveID is greater than 9.<br />
*CurrentConceptRefID, integer, 4 bytes, = tblRefs.RefID, identifies the reference that initiated the currently accepted concept. If there is no currently accepted concept for the name, then this is the reference that terminated the concept.<br />
*LifeZone, integer, 1 byte, bit values:<br />
**1 = Marine<br />
**2 = Brackish<br />
**4 = Freshwater<br />
**8 = Terrestrial<br />
*LastUpdate, smalldatetime, date and time row last updated<br />
*ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
*CreatedOn, smalldatetime, date and time row was created<br />
*CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
[[Category:TaxaTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/Taxa_(table)Taxa (table)2013-06-02T23:26:18Z<p>Dceades: document proposed changes to StatusFlags and UnavailFlags</p>
<hr />
<div>'''tblTaxa''' contains taxon names at all ranks, including synonyms and other non valid names.<br />
<br />
*TaxonNameID, integer, 4 bytes, unique identifier for the taxon name. This number can be used to enter the database at this name.<br />
*FileID, integer, 4 bytes, = tblFiles.FileID<br />
*TaxonNameStr, text, 300 characters maximum. A series of TaxonNameID in text form and separated by "-". <br />
**If a taxon is at genus rank and is not a synonym, the text of TaxonNameID is followed by "g". This makes forming binomial names more efficient.<br />
**If a taxon is at subgenus rank and is not a synonym, the text of TaxonNameID is followed by "s".<br />
**For all taxa immediately subordinate to the apex taxon, TaxonNameStr begins with the TaxonNameID of the apex taxon followed by "-" (or "g-" if the apex taxon is at genus rank) and the TaxonNameID of the subordinate.<br />
**The chain of TaxonNameIDs grows moving down the hierarchy by adding "-" and the TaxonNameID (and "g" or "s" when appropriate).<br />
**For all taxa outside the primary scope, TaxonNameStr begins with "0-".<br />
***For genera (and rarely other ranks) outside the primary scope, TaxonNameStr begins with "0-0-". This is needed for tblTaxa.OriginalGenusID, for genera in nomenclator information for citations, and for taxa providing images or sounds.<br />
***For context taxa outside the primary scope, TaxonNameStr begins with "0-1-". Such taxa provide some context around the apex taxon.<br />
***For taxa previously within the primary scope but now outside, TaxonNameStr begins with "0-2-". This enables finding such taxa in searches so that users can be told about the change in status.<br />
***For reserved values of TaxonNameID, TaxonNameStr begins with "0-3-". These values are held in reserve for when private species files are merged.<br />
***For family-group taxa outside the primary scope (needed for tblTypeSpecies.FirstFamGrpNameID), TaxonNameStr begins with "0-4-".<br />
*RankID, integer, 4 bytes, = tblRanks.RankID, number for rank in hierarchy<br />
*Name, text, 30 characters maximum, name of taxon<br />
*Parens, boolean, enclose author name in parens?<br />
*AboveID, integer, 4 bytes, = tblTaxa.TaxonNameID of the next higher taxon in the hierarchy. If this taxon is a synonym or other not valid name, then this is the TaxonNameID for the valid taxon. AboveID cannot be the TaxonNameID for a genus having subgenera or a species having subspecies: In those cases, use the TaxonNameID of the nominotypical subgenus or subspecies.<br />
*LikeNameID, integer 4 bytes, = 0 unless this is a special case. Special cases are<br />
**Valid or temporary taxa<br />
***Genus, then = tblTaxa.TaxonNameID of subgenus by same name<br />
***Subgenus, then = tblTaxa.TaxonNameID of genus by same name<br />
***Species, then = tblTaxa.TaxonNameID of subspecies by same name<br />
***Subspecies, then = tblTaxa.TaxonNameID of species by same name<br />
*HasFossil, bit, 0 = no fossils, 1 = one or more fossils are known to exist; if NameStatus > 2, then HasFossil is NULL. This will be implemented during summer, 2013.<br />
*HasRecent, bit, 0 = no Recent specimens, 1 = one or more Recent specimens are known to exist; if NameStatus > 2, then HasRecent is NULL. This will be implemented during summer, 2013.<br />
*Extinct, integer, 1 byte, 0 = extinct, 1 = extant; if NameStatus > 2, then Extinct is NULL.) Could be changed to allow additional values such as threatened, endangered and presumed extirpated.<br />
*RefID, integer, 4 bytes, = tblRefs.RefID for the original description of the taxon. CAUTION: For family-group taxa, this is the first use of the name in its current form. The author and date for priority are based on the first use of any name based on the same type genus. To locate this information, trace via tblTypeGenera.GenusNameID to tblTypeSpecies.FirstFamGrpNameID to tblTaxa.RefID of that first name. For taxa above superfamily rank, RefID is always 0. Taxa at a rank above species and below subgenus also have RefID = 0.<br />
*NecAuthor, text, 200 characters maximum, author who used name correctly sometimes with additional information<br />
*DataFlags, integer, 2 bytes, with bitwise flags for type of data present<br />
**1 = image<br />
**2 = sound<br />
**4 = link to other website<br />
**8 = specimen data<br />
**0x10 (16) = scrutiny<br />
**0x20 (32) = key group<br />
**0x40 (64) = supplementary information<br />
**0x80 (128) = common name<br />
**0x100 (256) = related taxon<br />
**0x200 (512) = automatic link to other website<br />
**0x400 (1024) = ecological relationship<br />
**0x800 (2048) = valid taxon name string (used exclusively in spTestAboveIDvsTaxonNameStr)<br />
**0x1000 (4096) = has specimen(s) with latitude/longitude data useable for maps, applies to taxa at rank tribe or lower<br />
*AccessCode, integer, 4 bytes, = tblAccessCodes.AccessCode<br />
*NameStatus, integer, 1 byte<br />
**0 = valid<br />
**2 = temporary name for use until a valid name is provided (subordinate names limited to temporary names and synonyms)<br />
**4 = nomen nudum, must be at lower rank than parent (subordinate names limited to nomina nuda)<br />
**5 = nomen dubium, must be at lower rank than parent (subordinate names limited to nomina nuda and dubia)<br />
**7 = synonym (subordinate taxa not allowed)<br />
*StatusFlags, integer, 4 bytes, interpreted bitwise. We have run out of bits. To solve this, some flags will be moved to a new column UnavailFlags.<br />
**1 = informal name, compatible only with tblTaxa.NameStatus = 2 or 7. Will be moved to UnavailFlags.<br />
**2 = subsequent misspelling, compatible only with tblTaxa.NameStatus = 7. Will be moved to UnavailFlags.<br />
**4 = unjustified emendation, compatible only with tblTaxa.NameStatus = 7. New value will be 1.<br />
**8 = nomen nudum, compatible only with tblTaxa.NameStatus = 2 or 4 when rank is less than parent rank or = 7 when rank is same as parent. Will be moved to UnavailFlags.<br />
**0x10 (16) = nomen dubium, compatible only with tblTaxa.NameStatus = 5 when rank is less than parent rank or = 7 when rank is same as parent. New value will be 2.<br />
**0x20 (32) = incertae sedis, compatible only with tblTaxa.NameStatus = 0 or 2. New value will be 4.<br />
**0x40 (64) = required emendation, compatible only with tblTaxa.NameStatus = 0, 2 or 7. New value will be 8.<br />
**0x80 (128) = nomen protectum, compatible only with tblTaxa.NameStatus = 0 or 7. New value will be 0x10.<br />
**0x100 (256) = suppressed, compatible only with tblTaxa.NameStatus = 7. Will be moved to UnavailFlags.<br />
**0x200 (512) = misapplied, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7. Will be moved to UnavailFlags.<br />
**0x400 (1024) = preoccupied (genus-group names), compatible only with tblTaxa.NameStatus = 2 or 7. Will be moved to UnavailFlags.<br />
**0x800 (2048) = primary homonym (species-group names), compatible only with tblTaxa.NameStatus = 2 or 7. Will be moved to UnavailFlags.<br />
**0x1000 (4096) = secondary homonym (species-group names), compatible only with tblTaxa.NameStatus = 2 or 7. New value will be 0x20.<br />
**0x2000 (8192) = nomen oblitum, compatible only with tblTaxa.NameStatus = 7. New value will be 0x40.<br />
**0x4000 (16384) = unnecessary replacement name, compatible only with tblTaxa.NameStatus = 7. New value will be 0x80.<br />
**0x8000 (32768) = incorrect original spelling, compatible only with tblTaxa.Namestatus = 2, 4, 5 or 7. Will be moved to UnavailFlags.<br />
**0x10000 (65536) = other, explained by tblTaxa.Comment, compatible only with tblTaxa.NameStatus = 0, 2 or 7. New value will be 0x100.<br />
**0x20000 (131072) = unavailable, other reason, compatible only with tblTaxa.NameStatus = 2 or 7. Will be moved to UnavailFlags.<br />
**0x40000 (262144) = junior synonym, compatible only with tblTaxa.NameStatus = 7. New value will be 0x200.<br />
**0x80000 (524288) = nomen novum, compatible only with tblTaxa.Namestatus = 0, 2, or 7. New value will be 0x400.<br />
**0x100000 (1048576) = original name, used only for family-group names, compatible only with tblTaxa.NameStatus = 7. New value will be 0x800.<br />
**0x200000 (2097152) = subsequent name, used only for family-group names, compatible with any tblTaxa.NameStatus value. New value will be 0x1000.<br />
**0x400000 (4194304) = junior homonym for species-group name not specified as primary or secondary, compatible only with tblTaxa.NameStatus = 2 or 7. New value will be 0x2000.<br />
**0x800000 (8388608) = lapsus calami, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7. Will be moved to UnavailFlags.<br />
**0x1000000 (16777216) = corrected lapsus calami, compatible only with tblTaxa.NameStatus = 0, 2 or 7. New value will be 0x4000.<br />
**0x2000000 (33554432) = nomen nudum made available, compatible only with tblTaxa.NameStatus = 0, 2 or 7. New value will be 0x8000.<br />
**The following columns are planned to provide a basis for added relationships in tblRelatedTaxa.<br />
***0x1000 senior homonym (opposite and junior homonym)<br />
***0x2000 correct not replaced (opposite unnecessary replacement)<br />
***0x4000 correct not emended (opposite unjustified emendation)<br />
***0x8000 correct as spelled (opposite subsequent misspelling)<br />
***0x10000 misapplied to (opposite misapplied)<br />
***0x20000 correct usage of misapplied (opposite misapplied)<br />
**Notes about StatusFlags.<br />
***Type data for taxa is available based on rank and name status:<br />
****No type data for ranks above superfamily.<br />
****No type data for ranks of subgenus through superfamily with name status of misapplied (0x200).<br />
****No type data for ranks above species and below subgenus.<br />
****No type data for ranks of species level and below for emendation (unjustified and required), misspelling, nomen nudum, unnecessary replacement, nomen novum, and misapplied (0x8424E) OR NameStatus = 4 (nomen nudum).<br />
***Age qualification is required for the following NameStatus values:<br />
****Junior synonym must not be older than the valid name.<br />
****Unjustified emendation, misspelling, and unnecessary replacement must not be older than the correct name.<br />
****Incorrectly formed name must not be younger than the justified emendation name.<br />
****Nomen novum must not be younger than the homonym replaced.<br />
****Nomen oblitum must not be younger than the valid name.<br />
***Taxa may have more than one status flag set. However, there are restrictions for certain status values. Unless stated below, more than one status flag may be set:<br />
****Emendation is not compatible with misspelling, unnecessary replacement, nomen nudum, incorrect original spelling, and misapplied.<br />
****Misspelling is not compatible with with emendation, unnecessary replacement, nomen nudum, incorrect original spelling, junior synonym, and misapplied.<br />
****Unnecessary replacement is not compatible with emendation, misspelling, junior synonym, and misapplied.<br />
****Nomen nudum is not compatible with emendation, misspelling, junior synonym, and misapplied.<br />
****Incorrect original spelling is not compatible with misspelling, unnecessary replacement, nomen nudum, and misapplied.<br />
****Junior synonym is not compatible with misspelling, unnecessary replacement, nomen nudum, and misapplied.<br />
****Misapplied is not compatible with emendation, misspelling, unnecessary replacement, nomen nudum, incorrect original spelling, junior synonym, and misapplied.<br />
****Note that, theoretically, the following status values may be used in combination with any other status value, but in some cases this may be illogical: Junior homonym, suppressed by ruling, unavailable (other reason), incertae sedis, nomen dubium, nomen oblitum, nomen novum, nomen protectum, unnamed.<br />
*UnavailFlags, integer, 4 bytes, interpreted bitwise. This new column will contain flags moved here from StatusFlags.<br />
**1 = informal name, compatible only with tblTaxa.NameStatus = 2 or 7<br />
**2 = subsequent misspelling, compatible only with tblTaxa.NameStatus = 7<br />
**4 = nomen nudum, compatible only with tblTaxa.NameStatus = 2 or 4 when rank is less than parent rank or = 7 when rank is same as parent<br />
**8 = suppressed, compatible only with tblTaxa.NameStatus = 7<br />
**0x10 (16) = misapplied, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7<br />
**0x20 (32) = preoccupied (genus-group names), compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x40 (64) = primary homonym (species-group names), compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x80 (128) = incorrect original spelling, compatible only with tblTaxa.Namestatus = 2, 4, 5 or 7<br />
**0x100 (256) = unavailable, other reason, compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x200 (512) = lapsus calami, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7<br />
*OriginalGenusID, integer, 4 bytes, = tblTaxa.TaxonNameID, used only for species-group taxa other than a species that has subspecies, TaxonNameID for the genus in which the species was originally described, = 0 if unknown, -1 identifies cases where the previously recorded original genus did not exist when the species was described. If a genus and subgenus have the same name, use the TaxonNameID of the subgenus.<br />
*Distribution, text, 400 characters maximum.<br />
*Ecology, text, 400 characters maximum.<br />
*Comment, text, 400 characters maximum, explanation relating to the status of the name.<br />
*ExpertID, integer, 4 bytes, = tblExperts.ExpertID for the person recorded as expert for this taxon<br />
*ExpertReason, integer, 1 byte, reason expert assigned, 0 = no expert assigned, 1 = by default, 2 = by hierarchy only, 3 = by hierarchy and geography, 11 = cascaded by default, 12 = cascaded by hierarchy only, 13 = cascaded by hierarchy and geography<br />
**When a new taxon is created or a taxon becomes valid, the ExpertID is copied from the new AboveID. If the ExpertID and ExpertReason of the AboveID is 0, the new/now valid taxon values are also 0. If the ExpertReason of the AboveID is less than 10 (but greater than 0), add 10 to the ExpertReason of the AboveID to derive the ExpertReason value for the new/now valid taxon. Use the same ExpertReason value for the new/now valid taxon if the ExpertReason of the AboveID is greater than 9.<br />
*CurrentConceptRefID, integer, 4 bytes, = tblRefs.RefID, identifies the reference that initiated the currently accepted concept. If there is no currently accepted concept for the name, then this is the reference that terminated the concept.<br />
*LifeZone, integer, 1 byte, bit values:<br />
**1 = Marine<br />
**2 = Brackish<br />
**4 = Freshwater<br />
**8 = Terrestrial<br />
*LastUpdate, smalldatetime, date and time row last updated<br />
*ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
*CreatedOn, smalldatetime, date and time row was created<br />
*CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
[[Category:TaxaTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/LocalitiesLocalities2013-05-30T16:05:09Z<p>Dceades: </p>
<hr />
<div>'''tblLocalities''' contains information about localities where specimens were found.<br />
<br />
* LocalityID, integer, 4 bytes, identifier for locality<br />
* [[Files|FileID]], integer, 4 bytes, = tblFiles.FileID<br />
* [[GeoLevel1|Level1ID]], 1 digit, = tblGeoLevel1.Level1ID<br />
** 0 = "Not recorded"<br />
* [[GeoLevel2|Level2ID]], 1 digit, = tblGeoLevel2.Level2ID. This is not a foreign key by itself; it is composite with Level1ID.<br />
** 0 = level 2 location has not been recorded<br />
* [[GeoLevel3|Level3ID]], 3 alphabetic characters, = tblGeoLevel3.Level3ID ''this is a foreign key for tblGeoLevel3''<br />
** --- = level 3 location has not been recorded<br />
** There are no spaces to pad because the foreign key has no blanks.<br />
* [[GeoLevel4|Level4ID]], 3 characters, = tblGeoLevel4.Level4ID. This is not a foreign key by itself; it is composite with Level3ID.<br />
** --- = level 4 location has not been recorded<br />
** The TDWG endorsed values are all alphabetic characters. Species File Software has added details at level 4 not recognized by TDWG. These are identified by numeric characters.<br />
* Latitude, decimal, precision 9, scale 6, degrees (+ for N, - for S), null permitted<br />
* Longitude, decimal, precision 9, scale 6, degrees (+ for E, - for W), null permitted<br />
* PrecisionCode, integer, 1 byte (still available, no longer used, will be converted for use as indicator of confidence in the supplied Lat/Long)<br />
** 0 = unspecified (default)<br />
** 1 = from locality label<br />
** 2 = estimated from map and locality label<br />
** 3 = based on county or similar modest area specified on locality label<br />
** 4 = estimated from less specific locality label<br />
* Elevation, integer, 2 bytes, elevation in meters, null permitted<br />
* MaxElevation, integer, 2 bytes, maximum elevation when there is a range, otherwise null<br />
* [[TimePeriods|TimePeriodID]], integer, 2 bytes, = tblTimePeriods.TimePeriodID, geologic time period<br />
*LocalityDetail, text, 300 characters maximum, place data not coded in any other field<br />
*TimeDetail, text, 300 characters maximum, details not coded in TimePeriodID<br />
*DataFlags, integer, 1 byte, bit flags for data status<br />
** <span class="alert">0 = conditions 1 and 2 are not present</span><br />
** 1 = The disparity between geographic levels and the Latitude & Longitude was accepted by the user<br />
** 2 = The locality was last edited by a user during a localities test run<br />
*Country, text, 100 characters maximum, name of the country of collection (It is not required that this name match any data supplied in the GeoID (above))<br />
*State, text, 100 characters maximum, name of the state or province of collection<br />
*County, text, 100 characters maximum, name of the county or precinct of collection<br />
*BodyOfWater, text, 100 characters maximum, name of the body of water of collection<br />
*PrecisionRadius, integer, 4 bytes, radius of the circle of uncertainty of the accuarcy of the latitude and longitude data<br />
*LatLongFrom, integer, 4 bytes, indicator of when the Latitude/Longitude data was applied<br />
**0 = Unknown (default)<br />
**1 = Provided by the collector at collection time<br />
**2 = Provided during data entry<br />
*LastUpdate, smalldatetime, date and time row last updated<br />
*ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
*CreatedOn, smalldatetime, date and time row was created<br />
*CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
[[Category:SpecimenTables]]<br />
[[Category:Tables]]<br />
[[Category:Fixme]]</div>Dceadeshttp://help.speciesfile.org/index.php/Taxa_(table)Taxa (table)2013-05-30T15:31:46Z<p>Dceades: add HasFossil and HasRecent as intended additions</p>
<hr />
<div>'''tblTaxa''' contains taxon names at all ranks, including synonyms and other non valid names.<br />
<br />
*TaxonNameID, integer, 4 bytes, unique identifier for the taxon name. This number can be used to enter the database at this name.<br />
*FileID, integer, 4 bytes, = tblFiles.FileID<br />
*TaxonNameStr, text, 300 characters maximum. A series of TaxonNameID in text form and separated by "-". <br />
**If a taxon is at genus rank and is not a synonym, the text of TaxonNameID is followed by "g". This makes forming binomial names more efficient.<br />
**If a taxon is at subgenus rank and is not a synonym, the text of TaxonNameID is followed by "s".<br />
**For all taxa immediately subordinate to the apex taxon, TaxonNameStr begins with the TaxonNameID of the apex taxon followed by "-" (or "g-" if the apex taxon is at genus rank) and the TaxonNameID of the subordinate.<br />
**The chain of TaxonNameIDs grows moving down the hierarchy by adding "-" and the TaxonNameID (and "g" or "s" when appropriate).<br />
**For all taxa outside the primary scope, TaxonNameStr begins with "0-".<br />
***For genera (and rarely other ranks) outside the primary scope, TaxonNameStr begins with "0-0-". This is needed for tblTaxa.OriginalGenusID, for genera in nomenclator information for citations, and for taxa providing images or sounds.<br />
***For context taxa outside the primary scope, TaxonNameStr begins with "0-1-". Such taxa provide some context around the apex taxon.<br />
***For taxa previously within the primary scope but now outside, TaxonNameStr begins with "0-2-". This enables finding such taxa in searches so that users can be told about the change in status.<br />
***For reserved values of TaxonNameID, TaxonNameStr begins with "0-3-". These values are held in reserve for when private species files are merged.<br />
***For family-group taxa outside the primary scope (needed for tblTypeSpecies.FirstFamGrpNameID), TaxonNameStr begins with "0-4-".<br />
*RankID, integer, 4 bytes, = tblRanks.RankID, number for rank in hierarchy<br />
*Name, text, 30 characters maximum, name of taxon<br />
*Parens, boolean, enclose author name in parens?<br />
*AboveID, integer, 4 bytes, = tblTaxa.TaxonNameID of the next higher taxon in the hierarchy. If this taxon is a synonym or other not valid name, then this is the TaxonNameID for the valid taxon. AboveID cannot be the TaxonNameID for a genus having subgenera or a species having subspecies: In those cases, use the TaxonNameID of the nominotypical subgenus or subspecies.<br />
*LikeNameID, integer 4 bytes, = 0 unless this is a special case. Special cases are<br />
**Valid or temporary taxa<br />
***Genus, then = tblTaxa.TaxonNameID of subgenus by same name<br />
***Subgenus, then = tblTaxa.TaxonNameID of genus by same name<br />
***Species, then = tblTaxa.TaxonNameID of subspecies by same name<br />
***Subspecies, then = tblTaxa.TaxonNameID of species by same name<br />
*HasFossil, bit, 0 = no fossils, 1 = one or more fossils are known to exist; if NameStatus > 2, then HasFossil is NULL. This will be implemented during summer, 2013.<br />
*HasRecent, bit, 0 = no Recent specimens, 1 = one or more Recent specimens are known to exist; if NameStatus > 2, then HasRecent is NULL. This will be implemented during summer, 2013.<br />
*Extinct, integer, 1 byte, 0 = extinct, 1 = extant; if NameStatus > 2, then Extinct is NULL.) Could be changed to allow additional values such as threatened, endangered and presumed extirpated.<br />
*RefID, integer, 4 bytes, = tblRefs.RefID for the original description of the taxon. CAUTION: For family-group taxa, this is the first use of the name in its current form. The author and date for priority are based on the first use of any name based on the same type genus. To locate this information, trace via tblTypeGenera.GenusNameID to tblTypeSpecies.FirstFamGrpNameID to tblTaxa.RefID of that first name. For taxa above superfamily rank, RefID is always 0. Taxa at a rank above species and below subgenus also have RefID = 0.<br />
*NecAuthor, text, 200 characters maximum, author who used name correctly sometimes with additional information<br />
*DataFlags, integer, 2 bytes, with bitwise flags for type of data present<br />
**1 = image<br />
**2 = sound<br />
**4 = link to other website<br />
**8 = specimen data<br />
**0x10 (16) = scrutiny<br />
**0x20 (32) = key group<br />
**0x40 (64) = supplementary information<br />
**0x80 (128) = common name<br />
**0x100 (256) = related taxon<br />
**0x200 (512) = automatic link to other website<br />
**0x400 (1024) = ecological relationship<br />
**0x800 (2048) = valid taxon name string (used exclusively in spTestAboveIDvsTaxonNameStr)<br />
**0x1000 (4096) = has specimen(s) with latitude/longitude data useable for maps, applies to taxa at rank tribe or lower<br />
*AccessCode, integer, 4 bytes, = tblAccessCodes.AccessCode<br />
*NameStatus, integer, 1 byte<br />
**0 = valid<br />
**2 = temporary name for use until a valid name is provided (subordinate names limited to temporary names and synonyms)<br />
**4 = nomen nudum, must be at lower rank than parent (subordinate names limited to nomina nuda)<br />
**5 = nomen dubium, must be at lower rank than parent (subordinate names limited to nomina nuda and dubia)<br />
**7 = synonym (subordinate taxa not allowed)<br />
*StatusFlags, integer, 4 bytes, interpreted bitwise<br />
**1 = informal name, compatible only with tblTaxa.NameStatus = 2 or 7<br />
**2 = subsequent misspelling, compatible only with tblTaxa.NameStatus = 7<br />
**4 = unjustified emendation, compatible only with tblTaxa.NameStatus = 7<br />
**8 = nomen nudum, compatible only with tblTaxa.NameStatus = 2 or 4 when rank is less than parent rank or = 7 when rank is same as parent<br />
**0x10 (16) = nomen dubium, compatible only with tblTaxa.NameStatus = 5 when rank is less than parent rank or = 7 when rank is same as parent<br />
**0x20 (32) = incertae sedis, compatible only with tblTaxa.NameStatus = 0 or 2<br />
**0x40 (64) = required emendation, compatible only with tblTaxa.NameStatus = 0, 2 or 7<br />
**0x80 (128) = nomen protectum, compatible only with tblTaxa.NameStatus = 0 or 7<br />
**0x100 (256) = suppressed, compatible only with tblTaxa.NameStatus = 7<br />
**0x200 (512) = misapplied, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7<br />
**0x400 (1024) = preoccupied (genus-group names), compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x800 (2048) = primary homonym (species-group names), compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x1000 (4096) = secondary homonym (species-group names), compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x2000 (8192) = nomen oblitum, compatible only with tblTaxa.NameStatus = 7<br />
**0x4000 (16384) = unnecessary replacement name, compatible only with tblTaxa.NameStatus = 7<br />
**0x8000 (32768) = incorrect original spelling, compatible only with tblTaxa.Namestatus = 2, 4, 5 or 7<br />
**0x10000 (65536) = other, explained by tblTaxa.Comment, compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x20000 (131072) = unavailable, other reason, compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x40000 (262144) = junior synonym, compatible only with tblTaxa.NameStatus = 7<br />
**0x80000 (524288) = nomen novum, compatible only with tblTaxa.Namestatus = 0, 2, or 7<br />
**0x100000 (1048576) = original name, used only for family-group names, compatible only with tblTaxa.NameStatus = 7<br />
**0x200000 (2097152) = subsequent name, used only for family-group names, compatible with any tblTaxa.NameStatus value<br />
**0x400000 (4194304) = junior homonym for species-group name not specified as primary or secondary, compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x800000 (8388608) = lapsus calami, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7<br />
**0x1000000 (16777216) = corrected lapsus calami, compatible only with tblTaxa.NameStatus = 0, 2 or 7<br />
**0x2000000 (33554432) = nomen nudum made available, compatible only with tblTaxa.NameStatus = 0, 2 or 7<br />
**Notes about StatusFlags<br />
***Type data for taxa is available based on rank and name status:<br />
****No type data for ranks above superfamily.<br />
****No type data for ranks of subgenus through superfamily with name status of misapplied (0x200).<br />
****No type data for ranks above species and below subgenus.<br />
****No type data for ranks of species level and below for emendation (unjustified and required), misspelling, nomen nudum, unnecessary replacement, nomen novum, and misapplied (0x8424E) OR NameStatus = 4 (nomen nudum).<br />
***Age qualification is required for the following NameStatus values:<br />
****Junior synonym must not be older than the valid name.<br />
****Unjustified emendation, misspelling, and unnecessary replacement must not be older than the correct name.<br />
****Incorrectly formed name must not be younger than the justified emendation name.<br />
****Nomen novum must not be younger than the homonym replaced.<br />
****Nomen oblitum must not be younger than the valid name.<br />
***Taxa may have more than one status flag set. However, there are restrictions for certain status values. Unless stated below, more than one status flag may be set:<br />
****Emendation is not compatible with misspelling, unnecessary replacement, nomen nudum, incorrect original spelling, and misapplied.<br />
****Misspelling is not compatible with with emendation, unnecessary replacement, nomen nudum, incorrect original spelling, junior synonym, and misapplied.<br />
****Unnecessary replacement is not compatible with emendation, misspelling, junior synonym, and misapplied.<br />
****Nomen nudum is not compatible with emendation, misspelling, junior synonym, and misapplied.<br />
****Incorrect original spelling is not compatible with misspelling, unnecessary replacement, nomen nudum, and misapplied.<br />
****Junior synonym is not compatible with misspelling, unnecessary replacement, nomen nudum, and misapplied.<br />
****Misapplied is not compatible with emendation, misspelling, unnecessary replacement, nomen nudum, incorrect original spelling, junior synonym, and misapplied.<br />
****Note that, theoretically, the following status values may be used in combination with any other status value, but in some cases this may be illogical: Junior homonym, suppressed by ruling, unavailable (other reason), incertae sedis, nomen dubium, nomen oblitum, nomen novum, nomen protectum, unnamed.<br />
*OriginalGenusID, integer, 4 bytes, = tblTaxa.TaxonNameID, used only for species-group taxa other than a species that has subspecies, TaxonNameID for the genus in which the species was originally described, = 0 if unknown, -1 identifies cases where the previously recorded original genus did not exist when the species was described. If a genus and subgenus have the same name, use the TaxonNameID of the subgenus.<br />
*Distribution, text, 400 characters maximum.<br />
*Ecology, text, 400 characters maximum.<br />
*Comment, text, 400 characters maximum, explanation relating to the status of the name.<br />
*ExpertID, integer, 4 bytes, = tblExperts.ExpertID for the person recorded as expert for this taxon<br />
*ExpertReason, integer, 1 byte, reason expert assigned, 0 = no expert assigned, 1 = by default, 2 = by hierarchy only, 3 = by hierarchy and geography, 11 = cascaded by default, 12 = cascaded by hierarchy only, 13 = cascaded by hierarchy and geography<br />
**When a new taxon is created or a taxon becomes valid, the ExpertID is copied from the new AboveID. If the ExpertID and ExpertReason of the AboveID is 0, the new/now valid taxon values are also 0. If the ExpertReason of the AboveID is less than 10 (but greater than 0), add 10 to the ExpertReason of the AboveID to derive the ExpertReason value for the new/now valid taxon. Use the same ExpertReason value for the new/now valid taxon if the ExpertReason of the AboveID is greater than 9.<br />
*CurrentConceptRefID, integer, 4 bytes, = tblRefs.RefID, identifies the reference that initiated the currently accepted concept. If there is no currently accepted concept for the name, then this is the reference that terminated the concept.<br />
*LifeZone, integer, 1 byte, bit values:<br />
**1 = Marine<br />
**2 = Brackish<br />
**4 = Freshwater<br />
**8 = Terrestrial<br />
*LastUpdate, smalldatetime, date and time row last updated<br />
*ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
*CreatedOn, smalldatetime, date and time row was created<br />
*CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
[[Category:TaxaTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/WebsitesWebsites2013-05-13T22:02:03Z<p>Dceades: add bit value 8 for Flags</p>
<hr />
<div>'''tblWebsites''' contains information about other websites.<br />
<br />
*WebsiteID, integer, 4 bytes, identifier for the website<br />
*Name, text, 400 characters maximum<br />
*RootLink, text, 200 characters maximum, root portion of the hyperlink<br />
*Flags, integer, 1 byte, bitwise flags<br />
**1 = used for taxon specific links<br />
**2 = used for reference links<br />
**4 = used for specimen links, unneeded flag. When on, it indicates the website provides specimen level data. There are three other types of data that do not have bits in this column. The intent to provide links from specimen records was never implemented.<br />
**8 = used for source links<br />
*LastUpdate, smalldatetime, date and time row last updated<br />
*ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
*CreatedOn, smalldatetime, date and time row was created<br />
*CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
<br />
[[Category:ForeignRelatedTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/WebsitesWebsites2013-05-06T21:43:28Z<p>Dceades: </p>
<hr />
<div>'''tblWebsites''' contains information about other websites.<br />
<br />
*WebsiteID, integer, 4 bytes, identifier for the website<br />
*Name, text, 400 characters maximum<br />
*RootLink, text, 200 characters maximum, root portion of the hyperlink<br />
*Flags, integer, 1 byte, bitwise flags<br />
**1 = used for taxon specific links<br />
**2 = used for reference links<br />
**4 = used for specimen links, unneeded flag. When on, it indicates the website provides specimen level data. There are three other types of data that do not have bits in this column. The intent to provide links from specimen records was never implemented.<br />
*LastUpdate, smalldatetime, date and time row last updated<br />
*ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
*CreatedOn, smalldatetime, date and time row was created<br />
*CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
<br />
[[Category:ForeignRelatedTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/WebsitesWebsites2013-05-06T21:40:58Z<p>Dceades: </p>
<hr />
<div>'''tblWebsites''' contains information about other websites.<br />
<br />
*WebsiteID, integer, 4 bytes, identifier for the website<br />
*Name, text, 400 characters maximum<br />
*RootLink, text, 200 characters maximum, root portion of the hyperlink<br />
*Flags, integer, 1 byte, bitwise flags<br />
**1 = used for taxon specific links<br />
**2 = used for reference links<br />
**4 = used for specimen links, poorly designed flag. When on, it indicates the website provides specimen level data. There are three other types of data that do not have bits in this column.<br />
*LastUpdate, smalldatetime, date and time row last updated<br />
*ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
*CreatedOn, smalldatetime, date and time row was created<br />
*CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
<br />
[[Category:ForeignRelatedTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/WebsitesWebsites2013-05-06T20:31:27Z<p>Dceades: </p>
<hr />
<div>'''tblWebsites''' contains information about other websites.<br />
<br />
*WebsiteID, integer, 4 bytes, identifier for the website<br />
*Name, text, 400 characters maximum<br />
*RootLink, text, 200 characters maximum, root portion of the hyperlink<br />
*Flags, integer, 1 byte, bitwise flags<br />
**1 = used for taxon specific links<br />
**2 = used for reference links<br />
**4 = used for specimen links, obsolete. This flag is on for some websites, but links are no longer used for specimens.<br />
*LastUpdate, smalldatetime, date and time row last updated<br />
*ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
*CreatedOn, smalldatetime, date and time row was created<br />
*CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
<br />
[[Category:ForeignRelatedTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/FilesFiles2013-03-08T22:30:16Z<p>Dceades: marked six columns as not in active use</p>
<hr />
<div>'''tblFiles''' contains data about the status of various species files, a single table in SFSdb.<br />
<br />
* FileID, integer, 2 bytes, identifier for the file<br />
* ServerName, text, 15 bytes maximum, name of the server that contains the database<br />
* DatabaseName, text, 30 bytes maximum, name of the database file<br />
* [[FileTypes|FileTypeID]], integer, 1 byte, = tblFileTypes.FileTypeID, type of database file<br />
* WebsiteName, text, 30 bytes maximum, name of the website as used in the URL [WebsiteName].speciesfile.org<br />
* [[Files|AboveID]], integer, 2 bytes, = FileID of the species file above it in the taxonomic hierarchy<br />
* Description, text, 1000 bytes maximum, description as found in tblConstants of the database<br />
* DateStarted, text, 20 bytes maximum<br />
* NumSpecies, integer, 4 bytes, number of valid species, not in active use<br />
* NumNames, integer, 4 bytes, total number of names, not in active use<br />
* NumCites, integer, 4 bytes, number of citations, not in active use<br />
* NumImages, integer, 4 bytes, number of images, not in active use<br />
* NumSpecimens, integer, 4 bytes, number of specimen records, not in active use<br />
* NumKeyEndPoints, integer, 4 bytes, number of end points in keys, not in active use<br />
* FileVersion, text, 20 bytes maximum, version for the file specific portion<br />
* CommonVersion, integer, 2 bytes, major version number for the shared common code<br />
* ServicePack, integer, 2 bytes, service pack number applied to the common code<br />
* Flags, integer, 2 bytes, used to manage which files use features under development<br />
<br />
[[Category:AdminTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/Taxa_(table)Taxa (table)2013-03-04T16:48:47Z<p>Dceades: </p>
<hr />
<div>'''tblTaxa''' contains taxon names at all ranks, including synonyms and other non valid names.<br />
<br />
*TaxonNameID, integer, 4 bytes, unique identifier for the taxon name. This number can be used to enter the database at this name.<br />
*FileID, integer, 4 bytes, = tblFiles.FileID<br />
*TaxonNameStr, text, 300 characters maximum. A series of TaxonNameID in text form and separated by "-". <br />
**If a taxon is at genus rank and is not a synonym, the text of TaxonNameID is followed by "g". This makes forming binomial names more efficient.<br />
**If a taxon is at subgenus rank and is not a synonym, the text of TaxonNameID is followed by "s".<br />
**For all taxa immediately subordinate to the apex taxon, TaxonNameStr begins with the TaxonNameID of the apex taxon followed by "-" (or "g-" if the apex taxon is at genus rank) and the TaxonNameID of the subordinate.<br />
**The chain of TaxonNameIDs grows moving down the hierarchy by adding "-" and the TaxonNameID (and "g" or "s" when appropriate).<br />
**For all taxa outside the primary scope, TaxonNameStr begins with "0-".<br />
***For genera (and rarely other ranks) outside the primary scope, TaxonNameStr begins with "0-0-". This is needed for tblTaxa.OriginalGenusID, for genera in nomenclator information for citations, and for taxa providing images or sounds.<br />
***For context taxa outside the primary scope, TaxonNameStr begins with "0-1-". Such taxa provide some context around the apex taxon.<br />
***For taxa previously within the primary scope but now outside, TaxonNameStr begins with "0-2-". This enables finding such taxa in searches so that users can be told about the change in status.<br />
***For reserved values of TaxonNameID, TaxonNameStr begins with "0-3-". These values are held in reserve for when private species files are merged.<br />
***For family-group taxa outside the primary scope (needed for tblTypeSpecies.FirstFamGrpNameID), TaxonNameStr begins with "0-4-".<br />
*RankID, integer, 4 bytes, = tblRanks.RankID, number for rank in hierarchy<br />
*Name, text, 30 characters maximum, name of taxon<br />
*Parens, boolean, enclose author name in parens?<br />
*AboveID, integer, 4 bytes, = tblTaxa.TaxonNameID of the next higher taxon in the hierarchy. If this taxon is a synonym or other not valid name, then this is the TaxonNameID for the valid taxon. AboveID cannot be the TaxonNameID for a genus having subgenera or a species having subspecies: In those cases, use the TaxonNameID of the nominotypical subgenus or subspecies.<br />
*LikeNameID, integer 4 bytes, = 0 unless this is a special case. Special cases are<br />
**Valid or temporary taxa<br />
***Genus, then = tblTaxa.TaxonNameID of subgenus by same name<br />
***Subgenus, then = tblTaxa.TaxonNameID of genus by same name<br />
***Species, then = tblTaxa.TaxonNameID of subspecies by same name<br />
***Subspecies, then = tblTaxa.TaxonNameID of species by same name<br />
*Extinct, integer, 1 byte, 0 = extinct, 1 = extant; if NameStatus > 2, then Extinct is NULL.) Could be changed to allow additional values such as threatened, endangered and presumed extirpated.<br />
*RefID, integer, 4 bytes, = tblRefs.RefID for the original description of the taxon. CAUTION: For family-group taxa, this is the first use of the name in its current form. The author and date for priority are based on the first use of any name based on the same type genus. To locate this information, trace via tblTypeGenera.GenusNameID to tblTypeSpecies.FirstFamGrpNameID to tblTaxa.RefID of that first name. For taxa above superfamily rank, RefID is always 0. Taxa at a rank above species and below subgenus also have RefID = 0.<br />
*NecAuthor, text, 200 characters maximum, author who used name correctly sometimes with additional information<br />
*DataFlags, integer, 2 bytes, with bitwise flags for type of data present<br />
**1 = image<br />
**2 = sound<br />
**4 = link to other website<br />
**8 = specimen data<br />
**0x10 (16) = scrutiny<br />
**0x20 (32) = key group<br />
**0x40 (64) = supplementary information<br />
**0x80 (128) = common name<br />
**0x100 (256) = related taxon<br />
**0x200 (512) = automatic link to other website<br />
**0x400 (1024) = ecological relationship<br />
**0x800 (2048) = valid taxon name string (used exclusively in spTestAboveIDvsTaxonNameStr)<br />
**0x1000 (4096) = has specimen(s) with latitude/longitude data useable for maps, applies to taxa at rank tribe or lower<br />
*AccessCode, integer, 4 bytes, = tblAccessCodes.AccessCode<br />
*NameStatus, integer, 1 byte<br />
**0 = valid<br />
**2 = temporary name for use until a valid name is provided (subordinate names limited to temporary names and synonyms)<br />
**4 = nomen nudum, must be at lower rank than parent (subordinate names limited to nomina nuda)<br />
**5 = nomen dubium, must be at lower rank than parent (subordinate names limited to nomina nuda and dubia)<br />
**7 = synonym (subordinate taxa not allowed)<br />
*StatusFlags, integer, 4 bytes, interpreted bitwise<br />
**1 = informal name, compatible only with tblTaxa.NameStatus = 2 or 7<br />
**2 = subsequent misspelling, compatible only with tblTaxa.NameStatus = 7<br />
**4 = unjustified emendation, compatible only with tblTaxa.NameStatus = 7<br />
**8 = nomen nudum, compatible only with tblTaxa.NameStatus = 2 or 4 when rank is less than parent rank or = 7 when rank is same as parent<br />
**0x10 (16) = nomen dubium, compatible only with tblTaxa.NameStatus = 5 when rank is less than parent rank or = 7 when rank is same as parent<br />
**0x20 (32) = incertae sedis, compatible only with tblTaxa.NameStatus = 0 or 2<br />
**0x40 (64) = required emendation, compatible only with tblTaxa.NameStatus = 0, 2 or 7<br />
**0x80 (128) = nomen protectum, compatible only with tblTaxa.NameStatus = 0 or 7<br />
**0x100 (256) = suppressed, compatible only with tblTaxa.NameStatus = 7<br />
**0x200 (512) = misapplied, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7<br />
**0x400 (1024) = preoccupied (genus-group names), compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x800 (2048) = primary homonym (species-group names), compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x1000 (4096) = secondary homonym (species-group names), compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x2000 (8192) = nomen oblitum, compatible only with tblTaxa.NameStatus = 7<br />
**0x4000 (16384) = unnecessary replacement name, compatible only with tblTaxa.NameStatus = 7<br />
**0x8000 (32768) = incorrect original spelling, compatible only with tblTaxa.Namestatus = 2, 4, 5 or 7<br />
**0x10000 (65536) = other, explained by tblTaxa.Comment, compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x20000 (131072) = unavailable, other reason, compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x40000 (262144) = junior synonym, compatible only with tblTaxa.NameStatus = 7<br />
**0x80000 (524288) = nomen novum, compatible only with tblTaxa.Namestatus = 0, 2, or 7<br />
**0x100000 (1048576) = original name, used only for family-group names, compatible only with tblTaxa.NameStatus = 7<br />
**0x200000 (2097152) = subsequent name, used only for family-group names, compatible with any tblTaxa.NameStatus value<br />
**0x400000 (4194304) = junior homonym for species-group name not specified as primary or secondary, compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x800000 (8388608) = lapsus calami, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7<br />
**0x1000000 (16777216) = corrected lapsus calami, compatible only with tblTaxa.NameStatus = 0, 2 or 7<br />
**0x2000000 (33554432) = nomen nudum made available, compatible only with tblTaxa.NameStatus = 0, 2 or 7<br />
**Notes about StatusFlags<br />
***Type data for taxa is available based on rank and name status:<br />
****No type data for ranks above superfamily.<br />
****No type data for ranks of subgenus through superfamily with name status of misapplied (0x200).<br />
****No type data for ranks above species and below subgenus.<br />
****No type data for ranks of species level and below for emendation (unjustified and required), misspelling, nomen nudum, unnecessary replacement, nomen novum, and misapplied (0x8424E) OR NameStatus = 4 (nomen nudum).<br />
***Age qualification is required for the following NameStatus values:<br />
****Junior synonym must not be older than the valid name.<br />
****Unjustified emendation, misspelling, and unnecessary replacement must not be older than the correct name.<br />
****Incorrectly formed name must not be younger than the justified emendation name.<br />
****Nomen novum must not be younger than the homonym replaced.<br />
****Nomen oblitum must not be younger than the valid name.<br />
***Taxa may have more than one status flag set. However, there are restrictions for certain status values. Unless stated below, more than one status flag may be set:<br />
****Emendation is not compatible with misspelling, unnecessary replacement, nomen nudum, incorrect original spelling, and misapplied.<br />
****Misspelling is not compatible with with emendation, unnecessary replacement, nomen nudum, incorrect original spelling, junior synonym, and misapplied.<br />
****Unnecessary replacement is not compatible with emendation, misspelling, junior synonym, and misapplied.<br />
****Nomen nudum is not compatible with emendation, misspelling, junior synonym, and misapplied.<br />
****Incorrect original spelling is not compatible with misspelling, unnecessary replacement, nomen nudum, and misapplied.<br />
****Junior synonym is not compatible with misspelling, unnecessary replacement, nomen nudum, and misapplied.<br />
****Misapplied is not compatible with emendation, misspelling, unnecessary replacement, nomen nudum, incorrect original spelling, junior synonym, and misapplied.<br />
****Note that, theoretically, the following status values may be used in combination with any other status value, but in some cases this may be illogical: Junior homonym, suppressed by ruling, unavailable (other reason), incertae sedis, nomen dubium, nomen oblitum, nomen novum, nomen protectum, unnamed.<br />
*OriginalGenusID, integer, 4 bytes, = tblTaxa.TaxonNameID, used only for species-group taxa other than a species that has subspecies, TaxonNameID for the genus in which the species was originally described, = 0 if unknown, -1 identifies cases where the previously recorded original genus did not exist when the species was described. If a genus and subgenus have the same name, use the TaxonNameID of the subgenus.<br />
*Distribution, text, 400 characters maximum.<br />
*Ecology, text, 400 characters maximum.<br />
*Comment, text, 400 characters maximum, explanation relating to the status of the name.<br />
*ExpertID, integer, 4 bytes, = tblExperts.ExpertID for the person recorded as expert for this taxon<br />
*ExpertReason, integer, 1 byte, reason expert assigned, 0 = no expert assigned, 1 = by default, 2 = by hierarchy only, 3 = by hierarchy and geography, 11 = cascaded by default, 12 = cascaded by hierarchy only, 13 = cascaded by hierarchy and geography<br />
**When a new taxon is created or a taxon becomes valid, the ExpertID is copied from the new AboveID. If the ExpertID and ExpertReason of the AboveID is 0, the new/now valid taxon values are also 0. If the ExpertReason of the AboveID is less than 10 (but greater than 0), add 10 to the ExpertReason of the AboveID to derive the ExpertReason value for the new/now valid taxon. Use the same ExpertReason value for the new/now valid taxon if the ExpertReason of the AboveID is greater than 9.<br />
*CurrentConceptRefID, integer, 4 bytes, = tblRefs.RefID, identifies the reference that initiated the currently accepted concept. If there is no currently accepted concept for the name, then this is the reference that terminated the concept.<br />
*LifeZone, integer, 1 byte, bit values:<br />
**1 = Marine<br />
**2 = Brackish<br />
**4 = Freshwater<br />
**8 = Terrestrial<br />
*LastUpdate, smalldatetime, date and time row last updated<br />
*ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
*CreatedOn, smalldatetime, date and time row was created<br />
*CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
[[Category:TaxaTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/Taxa_(table)Taxa (table)2013-03-04T16:45:04Z<p>Dceades: </p>
<hr />
<div>'''tblTaxa''' contains taxon names at all ranks, including synonyms and other non valid names.<br />
<br />
*TaxonNameID, integer, 4 bytes, unique identifier for the taxon name. This number can be used to enter the database at this name.<br />
*FileID, integer, 4 bytes, = tblFiles.FileID<br />
*TaxonNameStr, text, 300 characters maximum. A series of TaxonNameID in text form and separated by "-". <br />
**If a taxon is at genus rank and is not a synonym, the text of TaxonNameID is followed by "g". This makes forming binomial names more efficient.<br />
**If a taxon is at subgenus rank and is not a synonym, the text of TaxonNameID is followed by "s".<br />
**For all taxa immediately subordinate to the apex taxon, TaxonNameStr begins with the TaxonNameID of the apex taxon followed by "-" (or "g-" if the apex taxon is at genus rank) and the TaxonNameID of the subordinate.<br />
**The chain of TaxonNameIDs grows moving down the hierarchy by adding "-" and the TaxonNameID (and "g" or "s" when appropriate).<br />
**For all taxa outside the primary scope, TaxonNameStr begins with "0-".<br />
***For genera (and rarely other ranks) outside the primary scope (needed for tblTaxa.OriginalGenusID and for genera in nomenclator information for citations), TaxonNameStr begins with "0-0-".<br />
***For context taxa outside the primary scope, TaxonNameStr begins with "0-1-". Such taxa provide some context around the apex taxon.<br />
***For taxa previously within the primary scope but now outside, TaxonNameStr begins with "0-2-". This enables finding such taxa in searches so that users can be told about the change in status.<br />
***For reserved values of TaxonNameID, TaxonNameStr begins with "0-3-". These values are held in reserve for when private species files are merged.<br />
***For family-group taxa outside the primary scope (needed for tblTypeSpecies.FirstFamGrpNameID), TaxonNameStr begins with "0-4-".<br />
*RankID, integer, 4 bytes, = tblRanks.RankID, number for rank in hierarchy<br />
*Name, text, 30 characters maximum, name of taxon<br />
*Parens, boolean, enclose author name in parens?<br />
*AboveID, integer, 4 bytes, = tblTaxa.TaxonNameID of the next higher taxon in the hierarchy. If this taxon is a synonym or other not valid name, then this is the TaxonNameID for the valid taxon. AboveID cannot be the TaxonNameID for a genus having subgenera or a species having subspecies: In those cases, use the TaxonNameID of the nominotypical subgenus or subspecies.<br />
*LikeNameID, integer 4 bytes, = 0 unless this is a special case. Special cases are<br />
**Valid or temporary taxa<br />
***Genus, then = tblTaxa.TaxonNameID of subgenus by same name<br />
***Subgenus, then = tblTaxa.TaxonNameID of genus by same name<br />
***Species, then = tblTaxa.TaxonNameID of subspecies by same name<br />
***Subspecies, then = tblTaxa.TaxonNameID of species by same name<br />
*Extinct, integer, 1 byte, 0 = extinct, 1 = extant; if NameStatus > 2, then Extinct is NULL.) Could be changed to allow additional values such as threatened, endangered and presumed extirpated.<br />
*RefID, integer, 4 bytes, = tblRefs.RefID for the original description of the taxon. CAUTION: For family-group taxa, this is the first use of the name in its current form. The author and date for priority are based on the first use of any name based on the same type genus. To locate this information, trace via tblTypeGenera.GenusNameID to tblTypeSpecies.FirstFamGrpNameID to tblTaxa.RefID of that first name. For taxa above superfamily rank, RefID is always 0. Taxa at a rank above species and below subgenus also have RefID = 0.<br />
*NecAuthor, text, 200 characters maximum, author who used name correctly sometimes with additional information<br />
*DataFlags, integer, 2 bytes, with bitwise flags for type of data present<br />
**1 = image<br />
**2 = sound<br />
**4 = link to other website<br />
**8 = specimen data<br />
**0x10 (16) = scrutiny<br />
**0x20 (32) = key group<br />
**0x40 (64) = supplementary information<br />
**0x80 (128) = common name<br />
**0x100 (256) = related taxon<br />
**0x200 (512) = automatic link to other website<br />
**0x400 (1024) = ecological relationship<br />
**0x800 (2048) = valid taxon name string (used exclusively in spTestAboveIDvsTaxonNameStr)<br />
**0x1000 (4096) = has specimen(s) with latitude/longitude data useable for maps, applies to taxa at rank tribe or lower<br />
*AccessCode, integer, 4 bytes, = tblAccessCodes.AccessCode<br />
*NameStatus, integer, 1 byte<br />
**0 = valid<br />
**2 = temporary name for use until a valid name is provided (subordinate names limited to temporary names and synonyms)<br />
**4 = nomen nudum, must be at lower rank than parent (subordinate names limited to nomina nuda)<br />
**5 = nomen dubium, must be at lower rank than parent (subordinate names limited to nomina nuda and dubia)<br />
**7 = synonym (subordinate taxa not allowed)<br />
*StatusFlags, integer, 4 bytes, interpreted bitwise<br />
**1 = informal name, compatible only with tblTaxa.NameStatus = 2 or 7<br />
**2 = subsequent misspelling, compatible only with tblTaxa.NameStatus = 7<br />
**4 = unjustified emendation, compatible only with tblTaxa.NameStatus = 7<br />
**8 = nomen nudum, compatible only with tblTaxa.NameStatus = 2 or 4 when rank is less than parent rank or = 7 when rank is same as parent<br />
**0x10 (16) = nomen dubium, compatible only with tblTaxa.NameStatus = 5 when rank is less than parent rank or = 7 when rank is same as parent<br />
**0x20 (32) = incertae sedis, compatible only with tblTaxa.NameStatus = 0 or 2<br />
**0x40 (64) = required emendation, compatible only with tblTaxa.NameStatus = 0, 2 or 7<br />
**0x80 (128) = nomen protectum, compatible only with tblTaxa.NameStatus = 0 or 7<br />
**0x100 (256) = suppressed, compatible only with tblTaxa.NameStatus = 7<br />
**0x200 (512) = misapplied, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7<br />
**0x400 (1024) = preoccupied (genus-group names), compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x800 (2048) = primary homonym (species-group names), compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x1000 (4096) = secondary homonym (species-group names), compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x2000 (8192) = nomen oblitum, compatible only with tblTaxa.NameStatus = 7<br />
**0x4000 (16384) = unnecessary replacement name, compatible only with tblTaxa.NameStatus = 7<br />
**0x8000 (32768) = incorrect original spelling, compatible only with tblTaxa.Namestatus = 2, 4, 5 or 7<br />
**0x10000 (65536) = other, explained by tblTaxa.Comment, compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x20000 (131072) = unavailable, other reason, compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x40000 (262144) = junior synonym, compatible only with tblTaxa.NameStatus = 7<br />
**0x80000 (524288) = nomen novum, compatible only with tblTaxa.Namestatus = 0, 2, or 7<br />
**0x100000 (1048576) = original name, used only for family-group names, compatible only with tblTaxa.NameStatus = 7<br />
**0x200000 (2097152) = subsequent name, used only for family-group names, compatible with any tblTaxa.NameStatus value<br />
**0x400000 (4194304) = junior homonym for species-group name not specified as primary or secondary, compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x800000 (8388608) = lapsus calami, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7<br />
**0x1000000 (16777216) = corrected lapsus calami, compatible only with tblTaxa.NameStatus = 0, 2 or 7<br />
**0x2000000 (33554432) = nomen nudum made available, compatible only with tblTaxa.NameStatus = 0, 2 or 7<br />
**Notes about StatusFlags<br />
***Type data for taxa is available based on rank and name status:<br />
****No type data for ranks above superfamily.<br />
****No type data for ranks of subgenus through superfamily with name status of misapplied (0x200).<br />
****No type data for ranks above species and below subgenus.<br />
****No type data for ranks of species level and below for emendation (unjustified and required), misspelling, nomen nudum, unnecessary replacement, nomen novum, and misapplied (0x8424E) OR NameStatus = 4 (nomen nudum).<br />
***Age qualification is required for the following NameStatus values:<br />
****Junior synonym must not be older than the valid name.<br />
****Unjustified emendation, misspelling, and unnecessary replacement must not be older than the correct name.<br />
****Incorrectly formed name must not be younger than the justified emendation name.<br />
****Nomen novum must not be younger than the homonym replaced.<br />
****Nomen oblitum must not be younger than the valid name.<br />
***Taxa may have more than one status flag set. However, there are restrictions for certain status values. Unless stated below, more than one status flag may be set:<br />
****Emendation is not compatible with misspelling, unnecessary replacement, nomen nudum, incorrect original spelling, and misapplied.<br />
****Misspelling is not compatible with with emendation, unnecessary replacement, nomen nudum, incorrect original spelling, junior synonym, and misapplied.<br />
****Unnecessary replacement is not compatible with emendation, misspelling, junior synonym, and misapplied.<br />
****Nomen nudum is not compatible with emendation, misspelling, junior synonym, and misapplied.<br />
****Incorrect original spelling is not compatible with misspelling, unnecessary replacement, nomen nudum, and misapplied.<br />
****Junior synonym is not compatible with misspelling, unnecessary replacement, nomen nudum, and misapplied.<br />
****Misapplied is not compatible with emendation, misspelling, unnecessary replacement, nomen nudum, incorrect original spelling, junior synonym, and misapplied.<br />
****Note that, theoretically, the following status values may be used in combination with any other status value, but in some cases this may be illogical: Junior homonym, suppressed by ruling, unavailable (other reason), incertae sedis, nomen dubium, nomen oblitum, nomen novum, nomen protectum, unnamed.<br />
*OriginalGenusID, integer, 4 bytes, = tblTaxa.TaxonNameID, used only for species-group taxa other than a species that has subspecies, TaxonNameID for the genus in which the species was originally described, = 0 if unknown, -1 identifies cases where the previously recorded original genus did not exist when the species was described. If a genus and subgenus have the same name, use the TaxonNameID of the subgenus.<br />
*Distribution, text, 400 characters maximum.<br />
*Ecology, text, 400 characters maximum.<br />
*Comment, text, 400 characters maximum, explanation relating to the status of the name.<br />
*ExpertID, integer, 4 bytes, = tblExperts.ExpertID for the person recorded as expert for this taxon<br />
*ExpertReason, integer, 1 byte, reason expert assigned, 0 = no expert assigned, 1 = by default, 2 = by hierarchy only, 3 = by hierarchy and geography, 11 = cascaded by default, 12 = cascaded by hierarchy only, 13 = cascaded by hierarchy and geography<br />
**When a new taxon is created or a taxon becomes valid, the ExpertID is copied from the new AboveID. If the ExpertID and ExpertReason of the AboveID is 0, the new/now valid taxon values are also 0. If the ExpertReason of the AboveID is less than 10 (but greater than 0), add 10 to the ExpertReason of the AboveID to derive the ExpertReason value for the new/now valid taxon. Use the same ExpertReason value for the new/now valid taxon if the ExpertReason of the AboveID is greater than 9.<br />
*CurrentConceptRefID, integer, 4 bytes, = tblRefs.RefID, identifies the reference that initiated the currently accepted concept. If there is no currently accepted concept for the name, then this is the reference that terminated the concept.<br />
*LifeZone, integer, 1 byte, bit values:<br />
**1 = Marine<br />
**2 = Brackish<br />
**4 = Freshwater<br />
**8 = Terrestrial<br />
*LastUpdate, smalldatetime, date and time row last updated<br />
*ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
*CreatedOn, smalldatetime, date and time row was created<br />
*CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
[[Category:TaxaTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/Taxa_(table)Taxa (table)2013-03-04T15:38:36Z<p>Dceades: </p>
<hr />
<div>'''tblTaxa''' contains taxon names at all ranks, including synonyms and other non valid names.<br />
<br />
*TaxonNameID, integer, 4 bytes, unique identifier for the taxon name. This number can be used to enter the database at this name.<br />
*FileID, integer, 4 bytes, = tblFiles.FileID<br />
*TaxonNameStr, text, 300 characters maximum. A series of TaxonNameID in text form and separated by "-". <br />
**If a taxon is at genus rank and is not a synonym, the text of TaxonNameID is followed by "g". This makes forming binomial names more efficient.<br />
**If a taxon is at subgenus rank and is not a synonym, the text of TaxonNameID is followed by "s".<br />
**For all taxa immediately subordinate to the apex taxon, TaxonNameStr begins with the TaxonNameID of the apex taxon followed by "-" (or "g-" if the apex taxon is at genus rank) and the TaxonNameID of the subordinate.<br />
**The chain of TaxonNameIDs grows moving down the hierarchy by adding "-" and the TaxonNameID (and "g" or "s" when appropriate).<br />
**For all taxa outside the primary scope, TaxonNameStr begins with "0-".<br />
***For genera outside the primary scope (needed for tblTaxa.OriginalGenusID and for genera in nomenclator information for citations), TaxonNameStr begins with "0-0-".<br />
***For context taxa outside the primary scope, TaxonNameStr begins with "0-1-". Such taxa provide some context around the apex taxon.<br />
***For taxa previously within the primary scope but now outside, TaxonNameStr begins with "0-2-". This enables finding such taxa in searches so that users can be told about the change in status.<br />
***For reserved values of TaxonNameID, TaxonNameStr begins with "0-3-". These values are held in reserve for when private species files are merged.<br />
***For family-group taxa outside the primary scope (needed for tblTypeSpecies.FirstFamGrpNameID), TaxonNameStr begins with "0-4-".<br />
*RankID, integer, 4 bytes, = tblRanks.RankID, number for rank in hierarchy<br />
*Name, text, 30 characters maximum, name of taxon<br />
*Parens, boolean, enclose author name in parens?<br />
*AboveID, integer, 4 bytes, = tblTaxa.TaxonNameID of the next higher taxon in the hierarchy. If this taxon is a synonym or other not valid name, then this is the TaxonNameID for the valid taxon. AboveID cannot be the TaxonNameID for a genus having subgenera or a species having subspecies: In those cases, use the TaxonNameID of the nominotypical subgenus or subspecies.<br />
*LikeNameID, integer 4 bytes, = 0 unless this is a special case. Special cases are<br />
**Valid or temporary taxa<br />
***Genus, then = tblTaxa.TaxonNameID of subgenus by same name<br />
***Subgenus, then = tblTaxa.TaxonNameID of genus by same name<br />
***Species, then = tblTaxa.TaxonNameID of subspecies by same name<br />
***Subspecies, then = tblTaxa.TaxonNameID of species by same name<br />
*Extinct, integer, 1 byte, 0 = extinct, 1 = extant; if NameStatus > 2, then Extinct is NULL.) Could be changed to allow additional values such as threatened, endangered and presumed extirpated.<br />
*RefID, integer, 4 bytes, = tblRefs.RefID for the original description of the taxon. CAUTION: For family-group taxa, this is the first use of the name in its current form. The author and date for priority are based on the first use of any name based on the same type genus. To locate this information, trace via tblTypeGenera.GenusNameID to tblTypeSpecies.FirstFamGrpNameID to tblTaxa.RefID of that first name. For taxa above superfamily rank, RefID is always 0. Taxa at a rank above species and below subgenus also have RefID = 0.<br />
*NecAuthor, text, 200 characters maximum, author who used name correctly sometimes with additional information<br />
*DataFlags, integer, 2 bytes, with bitwise flags for type of data present<br />
**1 = image<br />
**2 = sound<br />
**4 = link to other website<br />
**8 = specimen data<br />
**0x10 (16) = scrutiny<br />
**0x20 (32) = key group<br />
**0x40 (64) = supplementary information<br />
**0x80 (128) = common name<br />
**0x100 (256) = related taxon<br />
**0x200 (512) = automatic link to other website<br />
**0x400 (1024) = ecological relationship<br />
**0x800 (2048) = valid taxon name string (used exclusively in spTestAboveIDvsTaxonNameStr)<br />
**0x1000 (4096) = has specimen(s) with latitude/longitude data useable for maps, applies to taxa at rank tribe or lower<br />
*AccessCode, integer, 4 bytes, = tblAccessCodes.AccessCode<br />
*NameStatus, integer, 1 byte<br />
**0 = valid<br />
**2 = temporary name for use until a valid name is provided (subordinate names limited to temporary names and synonyms)<br />
**4 = nomen nudum, must be at lower rank than parent (subordinate names limited to nomina nuda)<br />
**5 = nomen dubium, must be at lower rank than parent (subordinate names limited to nomina nuda and dubia)<br />
**7 = synonym (subordinate taxa not allowed)<br />
*StatusFlags, integer, 4 bytes, interpreted bitwise<br />
**1 = informal name, compatible only with tblTaxa.NameStatus = 2 or 7<br />
**2 = subsequent misspelling, compatible only with tblTaxa.NameStatus = 7<br />
**4 = unjustified emendation, compatible only with tblTaxa.NameStatus = 7<br />
**8 = nomen nudum, compatible only with tblTaxa.NameStatus = 2 or 4 when rank is less than parent rank or = 7 when rank is same as parent<br />
**0x10 (16) = nomen dubium, compatible only with tblTaxa.NameStatus = 5 when rank is less than parent rank or = 7 when rank is same as parent<br />
**0x20 (32) = incertae sedis, compatible only with tblTaxa.NameStatus = 0 or 2<br />
**0x40 (64) = required emendation, compatible only with tblTaxa.NameStatus = 0, 2 or 7<br />
**0x80 (128) = nomen protectum, compatible only with tblTaxa.NameStatus = 0 or 7<br />
**0x100 (256) = suppressed, compatible only with tblTaxa.NameStatus = 7<br />
**0x200 (512) = misapplied, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7<br />
**0x400 (1024) = preoccupied (genus-group names), compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x800 (2048) = primary homonym (species-group names), compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x1000 (4096) = secondary homonym (species-group names), compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x2000 (8192) = nomen oblitum, compatible only with tblTaxa.NameStatus = 7<br />
**0x4000 (16384) = unnecessary replacement name, compatible only with tblTaxa.NameStatus = 7<br />
**0x8000 (32768) = incorrect original spelling, compatible only with tblTaxa.Namestatus = 2, 4, 5 or 7<br />
**0x10000 (65536) = other, explained by tblTaxa.Comment, compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x20000 (131072) = unavailable, other reason, compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x40000 (262144) = junior synonym, compatible only with tblTaxa.NameStatus = 7<br />
**0x80000 (524288) = nomen novum, compatible only with tblTaxa.Namestatus = 0, 2, or 7<br />
**0x100000 (1048576) = original name, used only for family-group names, compatible only with tblTaxa.NameStatus = 7<br />
**0x200000 (2097152) = subsequent name, used only for family-group names, compatible with any tblTaxa.NameStatus value<br />
**0x400000 (4194304) = junior homonym for species-group name not specified as primary or secondary, compatible only with tblTaxa.NameStatus = 2 or 7<br />
**0x800000 (8388608) = lapsus calami, compatible only with tblTaxa.NameStatus = 2, 4, 5 or 7<br />
**0x1000000 (16777216) = corrected lapsus calami, compatible only with tblTaxa.NameStatus = 0, 2 or 7<br />
**0x2000000 (33554432) = nomen nudum made available, compatible only with tblTaxa.NameStatus = 0, 2 or 7<br />
**Notes about StatusFlags<br />
***Type data for taxa is available based on rank and name status:<br />
****No type data for ranks above superfamily.<br />
****No type data for ranks of subgenus through superfamily with name status of misapplied (0x200).<br />
****No type data for ranks above species and below subgenus.<br />
****No type data for ranks of species level and below for emendation (unjustified and required), misspelling, nomen nudum, unnecessary replacement, nomen novum, and misapplied (0x8424E) OR NameStatus = 4 (nomen nudum).<br />
***Age qualification is required for the following NameStatus values:<br />
****Junior synonym must not be older than the valid name.<br />
****Unjustified emendation, misspelling, and unnecessary replacement must not be older than the correct name.<br />
****Incorrectly formed name must not be younger than the justified emendation name.<br />
****Nomen novum must not be younger than the homonym replaced.<br />
****Nomen oblitum must not be younger than the valid name.<br />
***Taxa may have more than one status flag set. However, there are restrictions for certain status values. Unless stated below, more than one status flag may be set:<br />
****Emendation is not compatible with misspelling, unnecessary replacement, nomen nudum, incorrect original spelling, and misapplied.<br />
****Misspelling is not compatible with with emendation, unnecessary replacement, nomen nudum, incorrect original spelling, junior synonym, and misapplied.<br />
****Unnecessary replacement is not compatible with emendation, misspelling, junior synonym, and misapplied.<br />
****Nomen nudum is not compatible with emendation, misspelling, junior synonym, and misapplied.<br />
****Incorrect original spelling is not compatible with misspelling, unnecessary replacement, nomen nudum, and misapplied.<br />
****Junior synonym is not compatible with misspelling, unnecessary replacement, nomen nudum, and misapplied.<br />
****Misapplied is not compatible with emendation, misspelling, unnecessary replacement, nomen nudum, incorrect original spelling, junior synonym, and misapplied.<br />
****Note that, theoretically, the following status values may be used in combination with any other status value, but in some cases this may be illogical: Junior homonym, suppressed by ruling, unavailable (other reason), incertae sedis, nomen dubium, nomen oblitum, nomen novum, nomen protectum, unnamed.<br />
*OriginalGenusID, integer, 4 bytes, = tblTaxa.TaxonNameID, used only for species-group taxa other than a species that has subspecies, TaxonNameID for the genus in which the species was originally described, = 0 if unknown, -1 identifies cases where the previously recorded original genus did not exist when the species was described. If a genus and subgenus have the same name, use the TaxonNameID of the subgenus.<br />
*Distribution, text, 400 characters maximum.<br />
*Ecology, text, 400 characters maximum.<br />
*Comment, text, 400 characters maximum, explanation relating to the status of the name.<br />
*ExpertID, integer, 4 bytes, = tblExperts.ExpertID for the person recorded as expert for this taxon<br />
*ExpertReason, integer, 1 byte, reason expert assigned, 0 = no expert assigned, 1 = by default, 2 = by hierarchy only, 3 = by hierarchy and geography, 11 = cascaded by default, 12 = cascaded by hierarchy only, 13 = cascaded by hierarchy and geography<br />
**When a new taxon is created or a taxon becomes valid, the ExpertID is copied from the new AboveID. If the ExpertID and ExpertReason of the AboveID is 0, the new/now valid taxon values are also 0. If the ExpertReason of the AboveID is less than 10 (but greater than 0), add 10 to the ExpertReason of the AboveID to derive the ExpertReason value for the new/now valid taxon. Use the same ExpertReason value for the new/now valid taxon if the ExpertReason of the AboveID is greater than 9.<br />
*CurrentConceptRefID, integer, 4 bytes, = tblRefs.RefID, identifies the reference that initiated the currently accepted concept. If there is no currently accepted concept for the name, then this is the reference that terminated the concept.<br />
*LifeZone, integer, 1 byte, bit values:<br />
**1 = Marine<br />
**2 = Brackish<br />
**4 = Freshwater<br />
**8 = Terrestrial<br />
*LastUpdate, smalldatetime, date and time row last updated<br />
*ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
*CreatedOn, smalldatetime, date and time row was created<br />
*CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
[[Category:TaxaTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/IDrelationshipsIDrelationships2013-02-25T03:37:25Z<p>Dceades: </p>
<hr />
<div>'''tblIDrelationships''', types of relationships between IDs<br />
<br />
* IDrelationshipID, integer, 1 byte<br />
* Description, text, 50 characters maximum. The following square bullet points list values for IDrelationshipID and Description. ID1, ID2 and Status refer to columns contained in other tables shown on this page.<br />
** 1. ID2 copied from ID1 in spin off. Status is defined as:<br />
*** 0 = ID2 created by spin off<br />
*** 1 = Merge started, if ID1 was deleted, it has been re-created<br />
*** 2 = Values for LikeNameID and OriginalGenusID are resolved<br />
*** 5 = Values for RefID and CurrentConceptRefID resolved; merge process completed<br />
** 2. ID1 merged to create ID2. Status is defined as:<br />
*** 0 = ID2 has been reserved, but not created<br />
*** 1 = ID2 has been created<br />
*** 2 = Values for LikeNameID and OriginalGenusID are resolved<br />
*** 5 = Values for RefID and CurrentConceptRefID resolved; merge process completed<br />
** 3. ID2 reserved for future merge of ID1. Status is not used.<br />
** 4. ID1 is the same as ID2 in a different species file. For future development.<br />
* LastUpdate, smalldatetime, date and time row last updated<br />
* ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
* CreatedOn, smalldatetime, date and time row was created<br />
* CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
<br />
[[Category:IDrelationshipTables]]<br />
[[Category:Tables]]</div>Dceadeshttp://help.speciesfile.org/index.php/MatchingIDsMatchingIDs2013-02-24T21:20:55Z<p>Dceades: </p>
<hr />
<div>'''tblMatchingIDs''', related ID values in the same table.<br />
<br />
*TableID, integer, 4 bytes = tblTables.TableID<br />
*IDrelationshipID, integer, 1 byte, = tblIDrelationships.IDrelationship<br />
*ID1, integer, 4 bytes<br />
*ID2, integer, 4 bytes. The first four columns constitute the primary key.<br />
*Status, integer, 1 byte, explained in tblIDrelationships.<br />
*LastUpdate, smalldatetime, date and time row last updated<br />
*ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
*CreatedOn, smalldatetime, date and time row was created<br />
*CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
<br />
[[Category:IDrelationshipTables]]<br />
[[Category:Tables]]</div>Dceades