PendingPubFiles

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