KeyGroups

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