KeyGroups

From Species File Help
Revision as of 11:13, 30 August 2012 by Maehr (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

tblKeyGroups, group of one or more taxa that can be separated by using a key block (only one row in table per group)

   KeyGroupID, integer, 4 bytes, identifier for group
   TaxonNameID, integer, 4 bytes, = tblTaxa.TaxonNameID, identifier for taxon that group is based upon.
   CompCode, integer, 1 byte, component code:
       1 = group matches this taxon
       2 = group includes only the taxa enumerated in tblGroupTaxa (all subordinate to the taxon identified by TaxonNameID)
       3 = group includes all the taxa subordinate to the taxon identified by TaxonNameID except those listed tblGroupTaxa.
   OtherInfo, string, 200 characters, qualifying information for the group (may be null string)
   AccessCode, integer, 4 bytes
   ImpairedFlags, integer, 4 bytes interpreted bitwise, reasons for impairment (taxonomist review needed to check if revision of related key blocks is needed).  Bit values:
       Flags under editor control
           1 = An editor marked it as under development.
           2 = An editor marked it as needing more work.
           4 = A new member was added to the group.
           8 = A member was removed from the group.
       Flags under program control
           16 = Encompassing taxon is at higher rank than necessary.
           32 = Component is not subordinate to encompassing member.
           64 = A listed taxon is not a valid or temporary name.
           128 = Count of components is inconsistent with CompCode.
           256 = There is no taxon left in group after the list of exclusions.
           512 = Included component list matches content of encompassing taxon.
           1024 = A listed component is the same as or subordinate to another listed component.
   LastUpdate, smalldatetime, date and time row last updated
   ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change
   CreatedOn, smalldatetime, date and time row was created
   CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row
Personal tools
Namespaces

Variants
Actions
Navigation
Species Files
Wiki
Toolbox