PendingPubFiles

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.
• 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