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