Pubs

tblPubs, publications, including duplicate and misspelled names

   PubID, integer, 4 bytes, identifier for the publication
   PrefID, integer, 4 bytes, if PrefID > 0, then this is a duplicate or misspelled name and PrefID = PubID for preferred name
   FileID, integer, 4 bytes, identifier for the file
   PubType, 1 byte, 1 = journal, (2 not used), 3 = book or CD, 4 = unpublished
   ShortName, text, nvarchar(400), abbreviated journal name or book title or unpublished source
   FullName, text, nvarchar(400), full journal name or book title or unpublished source
   Note, text, 500 characters maximum, miscellaneous information
   Publisher, text, nvarchar(300), publisher for PubType = 3 (otherwise = "")
   PlacePublished, text, nvarchar(200), place published for PubType = 3 (otherwise = "")
   PubRegID, integer, 4 bytes = tblPubReg.PubRegID, = 0 except when Status = 4, for future development
   Status, integer, 1 byte, status of reconciliation with tblPubReg, for future development
       0 = reconciliation not attempted, this value should not continue after future development
       1 = Waiting for a response from species file editor
       2 = Waiting for a response from registry editor
       3 = Species file editor has decided it does not belong in registry
       4 = Fully reconciled with the registry
   StartYear, integer, 2 bytes, minimum tblPubRegDetail.StartYear for the publication, for future development
   EndYear, integer, 2 bytes, maximum tblPubRegDetail.EndYear for publication, for future development
   BHL, integer, 4 bytes, ID from Biodiversity Heritage Libarary, for future development
   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