People (table)
From Species File Help
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