Pubs

From Species File Help
Jump to: navigation, search

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
Personal tools
Namespaces

Variants
Actions
Navigation
Species Files
Wiki
Toolbox