Attachment 8 Topsail Database Tables.xlsx

11 KB Posted

Attached to
Vessel Monitoring System
Solicitation number
1305M2-21-Q-NFFK-0097
Issued by

About this file

Written by GovTribe AI ·

This document provides details on database tables used in the Topsail Vessel Monitoring System. There are over 60 tables that store configuration settings, valid codes, vessel and trip declaration data, permit and contact information, email logs, position reports, and test unit records for the Northeast region. The tables are shared between the NOAA Northeast Fisheries Science Center and Greater Atlantic Regional Fisheries Office for monitoring commercial fishing vessels in the area. The related federal contract opportunity is solicitation number 1305M2-21-Q-NFFK-0097 for a Vessel Monitoring System. The opportunity is posted by the Department of Commerce National Oceanic and Atmospheric Administration.

View the file

Other files

File Type Posted
RFQ 1305M2-21-Q-NFFK-0097-0004.pdf PDF
RFQ 1305M2-21-Q-NFFK-0097.pdf PDF
RFQ 1305M2-21-Q-NFFK-0097-0004.pdf PDF
RFQ Amendment 1305M221QNFFK0097-0003.pdf PDF
RFQ 1305M2-21-Q-NFFK-0097.pdf PDF
RFQ Amendment 1305M221QNFFK0097-0002.pdf PDF
Attachment 1 Performance Work Statement.pdf PDF
Attachment 2 Pricing Schedule.xlsx XLSX spreadsheet
RFQ 1305M2-21-Q-NFFK-0097.pdf PDF
Attachment 7 Topsail Programmers Guide.pdf PDF
Attachment 1 Performance Work Statement.pdf PDF
Attachment 6 Topsail Overview.pdf PDF
RFQ Amendment 1305M221QNFFK0097-0001.pdf PDF
Attachment 2 Pricing Schedule.xlsx XLSX spreadsheet
Attachment 2 Pricing Schedule.xlsx XLSX spreadsheet
RFQ 1305M2-21-Q-NFFK-0097.pdf PDF
Attachment 5_Subcontract Plan Template.pdf PDF
Attachment 4 Past Performance Questionnaire.pdf PDF
Attachment 3 Accounting System Questionnaire.doc DOC document
Attachment 1 Performance Work Statement.pdf PDF
Show all 20

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Topsail (NEVMS) Database Tables

TABLE_OR_VIEWDESCRIPTION
NEVMS.DATABASE_SETTINGSDatabase configuration settings.
DCL_ALL_CODESValid Northeast VMS declaration codes.
DCL_AREA_IDENTIFIERValid Northeast VMS declaration area codes.
DCL_BROAD_STOCK_AREAValid Northeast VMS broad stock area codes.
DCL_DAYS_AT_SEAValid Northeast VMS DAS codes.
DCL_GEAR_TYPEValid Northeast VMS gear codes.
DCL_PLAN_CODEValid Northeast VMS plan codes.
DCL_PROGRAM_CODEValid Northeast VMS program codes.
DCL_TRANSITION_PAIRSValid Northeast VMS transition pairs.
DCL_TRIP_MODIFIERValid Northeast VMS trip modifier codes.
EXCLUDED_EMAILSEmail addresses to be excluded from Topsail automated emails.
FLIP_FLEX_RULESNortheast VMS declaration flip-flex rule table.
NEVMS.FORM_BOATRACS_DECLARATIONBoatracs Activity Reports, but only the successful declarations (depreciated).
NEVMS.FORM_NED_HERRING_CATCHNortheast Format 13 eForms data (depreciated).
NEVMS.FORM_NED_HERRING_PRELANDNortheast Format 13 eForms data (depreciated).
NEVMS.FORM_NED_MACK_PRELANDNortheast Format 13 eForms data (depreciated).
NEVMS.FORM_NED_MACK_SQUID_CATCHNortheast Format 13 eForms data (depreciated).
NEVMS.FORM_NED_MONK_ADJUSTNortheast Format 13 eForms data (depreciated).
NEVMS.FORM_NED_MULTS_CATCHNortheast Format 13 eForms data (depreciated).
NEVMS.FORM_NED_MULTS_HAIL_ENDNortheast Format 13 eForms data (depreciated).
NEVMS.FORM_NED_MULTS_HAIL_STARTNortheast Format 13 eForms data (depreciated).
NEVMS.FORM_NED_RSA_EFP_HAIL_ENDNortheast Format 13 eForms data (depreciated).
NEVMS.FORM_NED_RSA_EFP_HAIL_STARTNortheast Format 13 eForms data (depreciated).
NEVMS.FORM_NED_SCALLOP_CATCHNortheast Format 13 eForms data (depreciated).
NEVMS.FORM_NED_SCALLOP_PRELANDNortheast Format 13 eForms data (depreciated).
NEVMS.GIS_UTL_MULTILINETemporary Geometries.
NEVMS.GIS_UTL_POINTTemporary Geometries.
NEVMS.GIS_UTL_POLYGONTemporary Geometries.
INDUSTRY_CONTACT_HISTORYArchive of Northeast VMS Industry Contact Log.
NEVMS.NEVMS_IVR_RCMF_CODESValid IVR redeclaration codes. Shared with GARFO.
NEVMS.PERMIT_VESSEL_INFOCopy of current GARFO permits data for Northeast VMS data.
NEVMS.PLSQL_ERRORSTopsail Oracle error report log (temporary).
NEVMS.SERVICE_MESSAGESTopsail application error report log.
NEVMS.TOPSAIL_SETTINGSTopsail application configuration settings.
NEVMS.TRIPGEN_STATUSCurrent Topsail tripgen status values.
NEVMS.TRIP_DECLARATIONSTopsail history of trip declarations by all vendors. Augments vTrack's data with McMurdo declarations.
NEVMS.VALID_DECLARATION_CODESList of current valid trip declaration codes.
NEVMS.VESSEL_ANCILLARY_EQUIPAGEList of current Northeast VMS vessels with secondary VMS transceivers.
NEVMS.VMS_EMAIL_HISTORYLog table of all emails sent by Topsail since 26-Jun-2-14 (988380 emails to date).
NEVMS.VMS_NAFO_ERRORSList of NAFO message errors. Shared with GARFO.
NEVMS.VMS_NAFO_SENTList of NAFO messages sent. Shared with GARFO. Includes position reports.
NEVMS.VMS_NAFO_TRIPSList of NAFO trips, copied from NEDSHARE. Shared with GARFO. (Out of date.)
NEVMS.VMS_NAFO_VESSELSList of NAFO vessels, copied from NEDSHARE. Shared with GARFO.
NEVMS.VMS_OLE_DROP_BOXList of selected OLE Drop Box emails (Canadian transshipment, NAFO). Shared with GARFO.
NEVMS.VMS_PWR_DWNList of current LOE powered-down vessels, copied from NEDSHARE.
NEVMS.VMS_PWR_DWN_HISTORYArchive of LOE powered-down vessels, copied from NEDSHARE.
NEVMS.VMS_TEST_UNITSList of known VMS test units. Maintained manually. Shared with GARFO.
NEVMS.VMS_TRIP_END_EMAILArchive of automated trip end emails.
NEVMS.VMS_TRIP_START_EMAILArchive of automated trip start emails.
NEVMS.VMS_VESSEL_EMAILSJournal of trip notification emails sent by Topsail since 02-Mar-2011 (930503) to date.
NEVMS.VMS_VESSEL_INFOInformation on current Northeast VMS vessels. Updated nightly. Shared with GARFO.
NEVMS.VMS_VESSEL_TRIPSJournal of Northeast VMS trips for which Topsail sent trip notifications since 27-Mar-2011. (326620 to date).
NEVMS.FMC_ACTIVE_NEVMS_VESSELS_VView of active Northeast VMS vessels, shared with GARFO.
NEVMS.VMS_CANADIAN_TRANSSHIPMENT_VView of Canadian Transshipment data, shared with GARFO.
NEVMS.VMS_NAFO_ERRORS_VView of NAFO message errors, shared with GARFO.
NEVMS.VMS_NAFO_SENT_VView of NAFO messages, shared with GARFO.
NEVMS.VMS_NAFO_TRIPS_VView of NAFO trip information (VTR numbers), shared with GARFO.
NEVMS.VMS_NAFO_VESSELS_VView of NAFO vessel information, shared with GARFO.
NEVMS.FMC_POS_LATEST_VView of latest Northeast VMS vessel positions, shared with GARFO.
NEVMS.VMS_POS_NED_VView of recent NEVMS vessel positions, shared with GARFO for APSD use. (Limited to NED region, 45 days).
NEVMS.NEVMS_IVR_RCMF_CODES_VView of valid IVR redeclaration codes, shared with GARFO.
NEVMS.VMS_PWR_DWN_VView of Northeast VMS vessels currently on LOE authorized powered-down status, shared with GARFO.
NEVMS.VMS_PWRDWN_INFO_VView of augmented Northeast VMS vessel LOE powered-down information, shared with GARFO.
NEVMS.VMS_TEST_UNITS_VView of known VMS test units, shared with GARFO.
NEVMS.PWRDWNPL/SQL package shared with GARFO for identifying LOE reporting exceptions.

File details come from the government source that posted it. Updated .