PeopleReg
From Species File Help
tblPeopleReg, registry of data about authors, for future development
- PersonRegID, integer, 4 bytes, identifier for registered person
- PrefRegID, integer, 4 bytes, if PrefRegID > 0, then this is a duplicate or misspelled name and PrefID = PersonRegID for the preferred name. Note that even if the following five columns have the same values, a separate row is needed when PrefID differs.
- FamilyName, text, 50 characters maximum
- GivenNames, text, 75 characters maximum
- GivenInitials, text, 20 characters maximum
- LSID, text, 100 bytes maximum, the life science ID as assigned by ZooBank
- Status, integer, 1 byte, status of reconciling tblPeopleReg with ZooBank
- 0 = no reconciliation attempted
- 5 = waiting for software development
- 10 = sent query to ZooBank
- 20 = received response from ZooBank with one or more possible matches
- 30 = initiated inquiries to one or more species files that use the author name
- 40 = sent query to ZooBank requesting that the name be added and an LSID be assigned
- 50 = reconciliation with ZooBank completed
- LastUpdate, smalldatetime, date and time row last updated
- 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