34248 VERS_TRIP Entity Published / External 26730 Vessel Electronic Reporting System (VERS) Data Set Completed Table contains trip level records for electronically reported data Loaded by batch 9189, 08-11-2016 10:02 Data Table Yes FVTR Table contains trip level records for electronically reported data 1 TRIP_ID NUMBER 22 Yes Yes 14 0 Active Unique trip identifier NUMBER 2 OPERATOR_PERMIT_NUM NUMBER 22 Yes No 10 0 Active Vessel operator's federal permit number NUMBER FVTR.FVTR_OPERATORS 3 SAIL_PORT_STATE VARCHAR2 2 No No Active State code for the state in which the sail port is located VARCHAR2 FVTR.FVTR_PORTS 4 SAIL_PORT_PLACE VARCHAR2 5 No No Active Port code for the port the vessel sailed from at the start of the trip VARCHAR2 FVTR.FVTR_PORTS 5 SAIL_PORT_COUNTY VARCHAR2 3 No No Active County code for the county in which the sail port is located VARCHAR2 FVTR.FVTR_PORTS 6 SAIL_DATE_GMT DATE 7 No No Active Datetime (UTC) when the vessel started the trip DATE 7 END_PORT_STATE VARCHAR2 2 No No Active State code for the state in which the end port is located VARCHAR2 FVTR.FVTR_PORTS 8 END_PORT_PLACE VARCHAR2 5 No No Active Port code for the port where the vessel ended the trip VARCHAR2 FVTR.FVTR_PORTS 9 END_PORT_COUNTY VARCHAR2 3 No No Active County code for the county in which the end port is located VARCHAR2 FVTR.FVTR_PORTS 10 END_DATE_GMT DATE 7 No No Active Datetime (UTC) when the vessel ended the trip DATE 11 TRIP_CATEGORY NUMBER 22 Yes No 1 0 Active Category code for the type of trip, see FVTR_TRIP_CATEGORIES NUMBER FVTR.FVTR_TRIP_CATEGORIES 12 CREW_SIZE NUMBER 22 No No 2 0 Active Number of crew on board the vessel including the captain NUMBER 13 NUM_ANGLERS NUMBER 22 No No 3 0 Active Number of anglers on board (applicable only to where the trip category is party or charter) NUMBER 14 TRIP_NOTES VARCHAR2 1000 No No Active Miscellaneous comments the operator wants to record in the ELB VARCHAR2 15 TRIP_ENTRY_DATE_GMT DATE 7 No No Active Datetime (UTC) at which the trip record was entered into the ELB DATE 16 FILE_NAME VARCHAR2 20 No No Active File name of the raw data file which was submitted and archived (the legal record for eVTR reporting) VARCHAR2 17 SOURCE_VERSION VARCHAR2 20 No No Active Name and version of the ELB software application used for data collection VARCHAR2 FVTR.FVTR_SOURCE_VERSIONS 18 REPORT_SOURCE VARCHAR2 10 Yes No Active Data resolution of the reported data (subtrip or haul-by-haul) VARCHAR2 FVTR.FVTR_REPORT_SOURCES 19 TRANSMISSION_DATE_GMT DATE 7 No No Active Datetime (UTC) of the transmission attempt which was successfully loaded to to the FVTR database DATE 20 ORIGINAL_TRANSMISSION_DATE_GMT DATE 7 No No Active Datetime (UTC) of the first transmission attempt DATE 21 UPLOAD_DATE_GMT DATE 7 No No Active Datetime (UTC) at which the submitted data was loaded to NEFSC servers DATE 22 CONFIRMED_FLAG VARCHAR2 1 No No Active Binary code used to indicate whether the trip has been reviewed, confirmed and locked for editing; 0=unconfirmed, 1=confirmed VARCHAR2 23 CONFIRMED_DATE_GMT DATE 7 No No Active Datetime (UTC) at which trip confirmation occurred DATE 24 CONFIRMED_BY VARCHAR2 20 No No Active Username of the individual who confirmed the trip VARCHAR2 FVTR.VERS_WEB_ACCOUNTS 25 VESSEL_PERMIT_NUM NUMBER 22 Yes No 6 0 Active Vessel's federal permit number NUMBER 26 VESSEL_HULL_ID VARCHAR2 10 Yes No Active Vessel's USCG or state registration number VARCHAR2 27 VMS_SERIAL_NUM VARCHAR2 12 No No Active Serial number of the VMS unit installed on the vessel VARCHAR2 28 FV_AP_NUM NUMBER 22 No No 38 Active Vessel's federal permit application number NUMBER FVTR.FVTR_VESSELS 29 VP_PROGRAM_CODE VARCHAR2 4 No No Active Program code selected for the current trip; see VERS_PROGRAMS VARCHAR2 FVTR.VERS_PROGRAMS 30 TRIP_ACTIVITY_TYPE NUMBER 22 Yes No 2 0 Active Activity code used to explain trips where no fishing efforts were conducted; see FVTR_TRIP_ACTIVITY_TYPES NUMBER FVTR.FVTR_TRIP_ACTIVITY_TYPES gov.noaa.nmfs.inport:34248 Patricia Jones 2016-08-11T10:02:33 SysAdmin InPortAdmin 2022-08-09T17:11:16 2016-08-23 Northeast Fisheries Science Center NEFSC 166 Water Street Woods Hole MA 02543-1026 USA (508)495-2000 https://www.nefsc.noaa.gov 8:00 a.m. to 4:30 p.m. Monday - Friday 1001 Public No 2016-08-23 1 Year 2017-08-23