People (table)

From Species File Help
(Difference between revisions)
Jump to: navigation, search
(created page)
 
(formatting, cat)
 
Line 1: Line 1:
 
'''tblPeople''', names of people
 
'''tblPeople''', names of people
  
    PersonID, integer, 4 bytes, identifier for person
+
*PersonID, integer, 4 bytes, identifier for person
    FileID, integer, 4 bytes, identifier for the file
+
*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
+
*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
+
*PersonRegID, integer, 4 bytes, = tblPeopleReg.PersonRegID
    FamilyName, text, 75 characters maximum, last name(s)
+
*FamilyName, text, 75 characters maximum, last name(s)
    GivenNames, text, 75 characters maximum, given name(s)
+
*GivenNames, text, 75 characters maximum, given name(s)
    GivenInitials, text, 20 characters maximum, initials of given names(s)
+
*GivenInitials, text, 20 characters maximum, initials of given names(s)
    Suffix, text, 10 characters maximum, last name suffix
+
*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).
+
*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 1 if this person is an author
        bit value 2 if this person is a data source
+
**bit value 2 if this person is a data source
        bit value 4 if this person is a collector
+
**bit value 4 if this person is a collector
        bit value 8 if this person is an identifier
+
**bit value 8 if this person is an identifier
        bit value 16 if this person is an expert
+
**bit value 16 if this person is an expert
        bit value 32 if this person is a character recorder
+
**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 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 128 if there is addressbook information available for this person
        bit value 256 if this person is unused (deletable) no longer used
+
**bit value 256 if this person is unused (deletable) no longer used
        bit value 512 if this person has alternate names
+
**bit value 512 if this person has alternate names
        bit value 1024 if this person is assigned a taxon as an expert
+
**bit value 1024 if this person is assigned a taxon as an expert
        bit value 2048 if this person provides a scrutiny
+
**bit value 2048 if this person provides a scrutiny
    Status, integer, 1 byte, status of reconciliation with tblPeopleReg, for future development
+
*Status, integer, 1 byte, status of reconciliation with tblPeopleReg, for future development
        0 = no reconciliation attempted
+
**0 = no reconciliation attempted
        10 = sent add request to SFSdb
+
**10 = sent add request to SFSdb
        20 = add request acknowledged by SFSdb, no LSID available yet
+
**20 = add request acknowledged by SFSdb, no LSID available yet
        30 = sent modify request to SFSdb
+
**30 = sent modify request to SFSdb
        40 = modify request acknowledged by SFSdb
+
**40 = modify request acknowledged by SFSdb
        70 = received request from SFSdb for editor decision
+
**70 = received request from SFSdb for editor decision
        80 = editor decision received from editor and sent to SFSdb, return acknowledgement not yet received
+
**80 = editor decision received from editor and sent to SFSdb, return acknowledgement not yet received
        100 = all questions resolved, LSID available from SFSdb
+
**100 = all questions resolved, LSID available from SFSdb
    LastUpdate, smalldatetime, date and time of last update
+
*LastUpdate, smalldatetime, date and time of last update
    ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change
+
*ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change
    CreatedOn, smalldatetime, date and time row was created
+
*CreatedOn, smalldatetime, date and time row was created
    CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row
+
*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
Personal tools
Namespaces

Variants
Actions
Navigation
Species Files
Wiki
Toolbox