People (table)

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