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