PeopleReg

tblPeopleReg, registry of data about authors, for future development

   PersonRegID, integer, 4 bytes, identifier for registered person
   PrefRegID, integer, 4 bytes, if PrefRegID > 0, then this is a duplicate or misspelled name and PrefID = PersonRegID for the preferred name.  Note that even if the following five columns have the same values, a separate row is needed when PrefID differs.
   FamilyName, text, 50 characters maximum
   GivenNames, text, 75 characters maximum
   GivenInitials, text, 20 characters maximum
   LSID, text, 100 bytes maximum, the life science ID as assigned by ZooBank
   Status, integer, 1 byte, status of reconciling tblPeopleReg with ZooBank
       0 = no reconciliation attempted
       5 = waiting for software development
       10 = sent query to ZooBank
       20 = received response from ZooBank with one or more possible matches
       30 = initiated inquiries to one or more species files that use the author name
       40 = sent query to ZooBank requesting that the name be added and an LSID be assigned
       50 = reconciliation with ZooBank completed
   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