From Species File Help
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

Species Files