KeyGroups
From Species File Help
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.
- Flags under editor control
- 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