People (table)

From Species File Help
Jump to: navigation, search

tblPeople, names of people

  • PersonID, integer, 4 bytes, identifier for person
  • FileID, integer, 4 bytes, identifier for the file
  • PrefID, integer, 2 bytes, if PrefID > 0, then this is a duplicate or misspelled name and PrefID = PersonID for preferred name
  • PersonRegID, integer, 4 bytes, = tblPeopleReg.PersonRegID
  • FamilyName, text, 75 characters maximum, last name(s)
  • GivenNames, text, 75 characters maximum, given name(s)
  • GivenInitials, text, 20 characters maximum, initials of given names(s)
  • Suffix, text, 10 characters maximum, last name suffix
  • Role, integer, 2 bytes, contains data flags indicating (not necessarily in the same order in the bitmap). These bits have been reserved but are currently unused (6/22/06).
    • bit value 1 if this person is an author
    • bit value 2 if this person is a data source
    • bit value 4 if this person is a collector
    • bit value 8 if this person is an identifier
    • bit value 16 if this person is an expert
    • bit value 32 if this person is a character recorder
    • bit value 64 if there is another person in the database with the same family name. This includes alternate names, except a duplication between an alternate and its PrefID name does not count as a duplication.
    • bit value 128 if there is addressbook information available for this person
    • bit value 256 if this person is unused (deletable) no longer used
    • bit value 512 if this person has alternate names
    • bit value 1024 if this person is assigned a taxon as an expert
    • bit value 2048 if this person provides a scrutiny
  • Status, integer, 1 byte, status of reconciliation with tblPeopleReg, for future development
    • 0 = no reconciliation attempted
    • 10 = sent add request to SFSdb
    • 20 = add request acknowledged by SFSdb, no LSID available yet
    • 30 = sent modify request to SFSdb
    • 40 = modify request acknowledged by SFSdb
    • 70 = received request from SFSdb for editor decision
    • 80 = editor decision received from editor and sent to SFSdb, return acknowledgement not yet received
    • 100 = all questions resolved, LSID available from SFSdb
  • LastUpdate, smalldatetime, date and time of last update
  • 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