From Species File Help
Jump to: navigation, search

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
Personal tools

Species Files