PendingPubFiles
From Species File Help
(Difference between revisions)
(created page) |
(formatting, cat) |
||
Line 1: | Line 1: | ||
'''tblPendingPubFiles''', linking table used to track the reconciliation of data in tblPubReg and the separate tblPubs in different species files, for future development | '''tblPendingPubFiles''', linking table used to track the reconciliation of data in tblPubReg and the separate tblPubs in different species files, for future development | ||
− | + | *FileID = tblFiles.FileID, integer, 4 bytes, this plus PubRegID constitutes the primary key | |
− | + | *PubID, integer, 4 bytes, = tblPubs.PubID | |
− | + | *PubRegID, integer, 4 bytes, = tblPubReg.PubRegID | |
− | + | *Status, integer, 1 byte, status of reconciling tblPubReg with tblPubs in the species file | |
− | + | **1-50 = waiting for response from species file editor | |
− | + | ***1 = Preferred pub not found in tblPubReg | |
− | + | ***2 = Registry editor has proposed change | |
− | + | ***11 = Registry editor rejected proposed addition | |
− | + | ***12 = Registry editor rejected proposed change | |
− | + | ***13 = Message from registry editor waiting | |
− | + | ***21 = Registry has accepted proposal from species file | |
− | + | **51-100 = waiting for response from registry editor | |
− | + | ***51 = Species file editor proposed adding a pub to the registry | |
− | + | ***52 = Species file editor initiated a proposed change | |
− | + | ***53 = Service pack or test program found a proposed change | |
− | + | ***61 = Species file editor indicated belief that species file version is correct | |
− | + | ***81 = Message from species file editor waiting | |
− | + | ***91 = Species file has accepted proposal from registry editor | |
− | + | ***92 = Species file editor chooses not to include this pub in registry | |
− | + | **No code for completed; the row is deleted. | |
− | + | *Messages, text, 4000 character maximum | |
− | + | *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:53, 8 September 2012
tblPendingPubFiles, linking table used to track the reconciliation of data in tblPubReg and the separate tblPubs in different species files, for future development
- FileID = tblFiles.FileID, integer, 4 bytes, this plus PubRegID constitutes the primary key
- PubID, integer, 4 bytes, = tblPubs.PubID
- PubRegID, integer, 4 bytes, = tblPubReg.PubRegID
- Status, integer, 1 byte, status of reconciling tblPubReg with tblPubs in the species file
- 1-50 = waiting for response from species file editor
- 1 = Preferred pub not found in tblPubReg
- 2 = Registry editor has proposed change
- 11 = Registry editor rejected proposed addition
- 12 = Registry editor rejected proposed change
- 13 = Message from registry editor waiting
- 21 = Registry has accepted proposal from species file
- 51-100 = waiting for response from registry editor
- 51 = Species file editor proposed adding a pub to the registry
- 52 = Species file editor initiated a proposed change
- 53 = Service pack or test program found a proposed change
- 61 = Species file editor indicated belief that species file version is correct
- 81 = Message from species file editor waiting
- 91 = Species file has accepted proposal from registry editor
- 92 = Species file editor chooses not to include this pub in registry
- No code for completed; the row is deleted.
- 1-50 = waiting for response from species file editor
- Messages, text, 4000 character maximum
- 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