People (table)
From Species File Help
(Difference between revisions)
(created page) |
(formatting, cat) |
||
Line 1: | Line 1: | ||
'''tblPeople''', names of people | '''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 | |
[[Category:CiteRelatedTables]] | [[Category:CiteRelatedTables]] | ||
+ | [[Category:Tables]] |
Latest revision as of 12:57, 8 September 2012
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