PendingPubFiles
From Species File Help
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