Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Data Management Systems (DMS) > Vessel Electronic Reporting System (VERS) >

Table: VERS_TRIP

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:34248  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Table contains trip level records for electronically reported data

Description

Table contains trip level records for electronically reported data

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
TRIP_ID
NUMBER 		Unique trip identifier
OPERATOR_PERMIT_NUM
NUMBER 		Vessel operator's federal permit number
SAIL_PORT_STATE
VARCHAR2 		State code for the state in which the sail port is located
SAIL_PORT_PLACE
VARCHAR2 		Port code for the port the vessel sailed from at the start of the trip
SAIL_PORT_COUNTY
VARCHAR2 		County code for the county in which the sail port is located
SAIL_DATE_GMT
DATE 		Datetime (UTC) when the vessel started the trip
END_PORT_STATE
VARCHAR2 		State code for the state in which the end port is located
END_PORT_PLACE
VARCHAR2 		Port code for the port where the vessel ended the trip
END_PORT_COUNTY
VARCHAR2 		County code for the county in which the end port is located
END_DATE_GMT
DATE 		Datetime (UTC) when the vessel ended the trip
TRIP_CATEGORY
NUMBER 		Category code for the type of trip, see FVTR_TRIP_CATEGORIES
CREW_SIZE
NUMBER 		Number of crew on board the vessel including the captain
NUM_ANGLERS
NUMBER 		Number of anglers on board (applicable only to where the trip category is party or charter)
TRIP_NOTES
VARCHAR2 		Miscellaneous comments the operator wants to record in the ELB
TRIP_ENTRY_DATE_GMT
DATE 		Datetime (UTC) at which the trip record was entered into the ELB
FILE_NAME
VARCHAR2 		File name of the raw data file which was submitted and archived (the legal record for eVTR reporting)
SOURCE_VERSION
VARCHAR2 		Name and version of the ELB software application used for data collection
REPORT_SOURCE
VARCHAR2 		Data resolution of the reported data (subtrip or haul-by-haul)
TRANSMISSION_DATE_GMT
DATE 		Datetime (UTC) of the transmission attempt which was successfully loaded to to the FVTR database
ORIGINAL_TRANSMISSION_DATE_GMT
DATE 		Datetime (UTC) of the first transmission attempt
UPLOAD_DATE_GMT
DATE 		Datetime (UTC) at which the submitted data was loaded to NEFSC servers
CONFIRMED_FLAG
VARCHAR2 		Binary code used to indicate whether the trip has been reviewed, confirmed and locked for editing; 0=unconfirmed, 1=confirmed
CONFIRMED_DATE_GMT
DATE 		Datetime (UTC) at which trip confirmation occurred
CONFIRMED_BY
VARCHAR2 		Username of the individual who confirmed the trip
VESSEL_PERMIT_NUM
NUMBER 		Vessel's federal permit number
VESSEL_HULL_ID
VARCHAR2 		Vessel's USCG or state registration number
VMS_SERIAL_NUM
VARCHAR2 		Serial number of the VMS unit installed on the vessel
FV_AP_NUM
NUMBER 		Vessel's federal permit application number
VP_PROGRAM_CODE
VARCHAR2 		Program code selected for the current trip; see VERS_PROGRAMS
TRIP_ACTIVITY_TYPE
NUMBER 		Activity code used to explain trips where no fishing efforts were conducted; see FVTR_TRIP_ACTIVITY_TYPES

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (NEFSC) for inquiries on this record.

Item Identification

Title: Table: VERS_TRIP
Short Name: VERS_TRIP
Status: Completed
Abstract:

Table contains trip level records for electronically reported data
Notes:

Loaded by batch 9189, 08-11-2016 10:02

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: FVTR
Description:

Table contains trip level records for electronically reported data

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key TRIP_ID NUMBER Unique trip identifier
100
 OPERATOR_PERMIT_NUM NUMBER Vessel operator's federal permit number
100
 SAIL_PORT_STATE VARCHAR2 State code for the state in which the sail port is located
100
 SAIL_PORT_PLACE VARCHAR2 Port code for the port the vessel sailed from at the start of the trip
100
 SAIL_PORT_COUNTY VARCHAR2 County code for the county in which the sail port is located
100
 SAIL_DATE_GMT DATE Datetime (UTC) when the vessel started the trip
100
 END_PORT_STATE VARCHAR2 State code for the state in which the end port is located
100
 END_PORT_PLACE VARCHAR2 Port code for the port where the vessel ended the trip
100
 END_PORT_COUNTY VARCHAR2 County code for the county in which the end port is located
100
 END_DATE_GMT DATE Datetime (UTC) when the vessel ended the trip
100
 TRIP_CATEGORY NUMBER Category code for the type of trip, see FVTR_TRIP_CATEGORIES
100
 CREW_SIZE NUMBER Number of crew on board the vessel including the captain
100
 NUM_ANGLERS NUMBER Number of anglers on board (applicable only to where the trip category is party or charter)
100
 TRIP_NOTES VARCHAR2 Miscellaneous comments the operator wants to record in the ELB
100
 TRIP_ENTRY_DATE_GMT DATE Datetime (UTC) at which the trip record was entered into the ELB
100
 FILE_NAME VARCHAR2 File name of the raw data file which was submitted and archived (the legal record for eVTR reporting)
100
 SOURCE_VERSION VARCHAR2 Name and version of the ELB software application used for data collection
100
 REPORT_SOURCE VARCHAR2 Data resolution of the reported data (subtrip or haul-by-haul)
100
 TRANSMISSION_DATE_GMT DATE Datetime (UTC) of the transmission attempt which was successfully loaded to to the FVTR database
100
 ORIGINAL_TRANSMISSION_DATE_GMT DATE Datetime (UTC) of the first transmission attempt
100
 UPLOAD_DATE_GMT DATE Datetime (UTC) at which the submitted data was loaded to NEFSC servers
100
 CONFIRMED_FLAG VARCHAR2 Binary code used to indicate whether the trip has been reviewed, confirmed and locked for editing; 0=unconfirmed, 1=confirmed
100
 CONFIRMED_DATE_GMT DATE Datetime (UTC) at which trip confirmation occurred
100
 CONFIRMED_BY VARCHAR2 Username of the individual who confirmed the trip
100
 VESSEL_PERMIT_NUM NUMBER Vessel's federal permit number
100
 VESSEL_HULL_ID VARCHAR2 Vessel's USCG or state registration number
100
 VMS_SERIAL_NUM VARCHAR2 Serial number of the VMS unit installed on the vessel
100
 FV_AP_NUM NUMBER Vessel's federal permit application number
100
 VP_PROGRAM_CODE VARCHAR2 Program code selected for the current trip; see VERS_PROGRAMS
100
 TRIP_ACTIVITY_TYPE NUMBER Activity code used to explain trips where no fishing efforts were conducted; see FVTR_TRIP_ACTIVITY_TYPES

Attribute Details

TRIP_ID

CC ID: 344076
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 14
Scale: 0
Status: Active
Description:

Unique trip identifier
General Data Type: NUMBER

OPERATOR_PERMIT_NUM

CC ID: 344062
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Vessel operator's federal permit number
General Data Type: NUMBER
Foreign Key Relations:

FVTR.FVTR_OPERATORS

SAIL_PORT_STATE

CC ID: 344063
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

State code for the state in which the sail port is located
General Data Type: VARCHAR2
Foreign Key Relations:

FVTR.FVTR_PORTS

SAIL_PORT_PLACE

CC ID: 344064
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Port code for the port the vessel sailed from at the start of the trip
General Data Type: VARCHAR2
Foreign Key Relations:

FVTR.FVTR_PORTS

SAIL_PORT_COUNTY

CC ID: 344065
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

County code for the county in which the sail port is located
General Data Type: VARCHAR2
Foreign Key Relations:

FVTR.FVTR_PORTS

SAIL_DATE_GMT

CC ID: 344091
Seq. Order: 6
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Datetime (UTC) when the vessel started the trip
General Data Type: DATE

END_PORT_STATE

CC ID: 344066
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

State code for the state in which the end port is located
General Data Type: VARCHAR2
Foreign Key Relations:

FVTR.FVTR_PORTS

END_PORT_PLACE

CC ID: 344067
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Port code for the port where the vessel ended the trip
General Data Type: VARCHAR2
Foreign Key Relations:

FVTR.FVTR_PORTS

END_PORT_COUNTY

CC ID: 344068
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

County code for the county in which the end port is located
General Data Type: VARCHAR2
Foreign Key Relations:

FVTR.FVTR_PORTS

END_DATE_GMT

CC ID: 344077
Seq. Order: 10
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Datetime (UTC) when the vessel ended the trip
General Data Type: DATE

TRIP_CATEGORY

CC ID: 344072
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Category code for the type of trip, see FVTR_TRIP_CATEGORIES
General Data Type: NUMBER
Foreign Key Relations:

FVTR.FVTR_TRIP_CATEGORIES

CREW_SIZE

CC ID: 344078
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Number of crew on board the vessel including the captain
General Data Type: NUMBER

NUM_ANGLERS

CC ID: 344079
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Number of anglers on board (applicable only to where the trip category is party or charter)
General Data Type: NUMBER

TRIP_NOTES

CC ID: 344080
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 1000
Required: No
Primary Key: No
Status: Active
Description:

Miscellaneous comments the operator wants to record in the ELB
General Data Type: VARCHAR2

TRIP_ENTRY_DATE_GMT

CC ID: 344081
Seq. Order: 15
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Datetime (UTC) at which the trip record was entered into the ELB
General Data Type: DATE

FILE_NAME

CC ID: 344082
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

File name of the raw data file which was submitted and archived (the legal record for eVTR reporting)
General Data Type: VARCHAR2

SOURCE_VERSION

CC ID: 344070
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Name and version of the ELB software application used for data collection
General Data Type: VARCHAR2
Foreign Key Relations:

FVTR.FVTR_SOURCE_VERSIONS

REPORT_SOURCE

CC ID: 344069
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 10
Required: Yes
Primary Key: No
Status: Active
Description:

Data resolution of the reported data (subtrip or haul-by-haul)
General Data Type: VARCHAR2
Foreign Key Relations:

FVTR.FVTR_REPORT_SOURCES

TRANSMISSION_DATE_GMT

CC ID: 344083
Seq. Order: 19
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Datetime (UTC) of the transmission attempt which was successfully loaded to to the FVTR database
General Data Type: DATE

ORIGINAL_TRANSMISSION_DATE_GMT

CC ID: 344084
Seq. Order: 20
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Datetime (UTC) of the first transmission attempt
General Data Type: DATE

UPLOAD_DATE_GMT

CC ID: 344085
Seq. Order: 21
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Datetime (UTC) at which the submitted data was loaded to NEFSC servers
General Data Type: DATE

CONFIRMED_FLAG

CC ID: 344086
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Binary code used to indicate whether the trip has been reviewed, confirmed and locked for editing; 0=unconfirmed, 1=confirmed
General Data Type: VARCHAR2

CONFIRMED_DATE_GMT

CC ID: 344087
Seq. Order: 23
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Datetime (UTC) at which trip confirmation occurred
General Data Type: DATE

CONFIRMED_BY

CC ID: 344075
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Username of the individual who confirmed the trip
General Data Type: VARCHAR2
Foreign Key Relations:

FVTR.VERS_WEB_ACCOUNTS

VESSEL_PERMIT_NUM

CC ID: 344088
Seq. Order: 25
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

Vessel's federal permit number
General Data Type: NUMBER

VESSEL_HULL_ID

CC ID: 344089
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 10
Required: Yes
Primary Key: No
Status: Active
Description:

Vessel's USCG or state registration number
General Data Type: VARCHAR2

VMS_SERIAL_NUM

CC ID: 344090
Seq. Order: 27
Data Storage Type: VARCHAR2
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

Serial number of the VMS unit installed on the vessel
General Data Type: VARCHAR2

FV_AP_NUM

CC ID: 344073
Seq. Order: 28
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Vessel's federal permit application number
General Data Type: NUMBER
Foreign Key Relations:

FVTR.FVTR_VESSELS

VP_PROGRAM_CODE

CC ID: 344074
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Program code selected for the current trip; see VERS_PROGRAMS
General Data Type: VARCHAR2
Foreign Key Relations:

FVTR.VERS_PROGRAMS

TRIP_ACTIVITY_TYPE

CC ID: 344071
Seq. Order: 30
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Activity code used to explain trips where no fishing efforts were conducted; see FVTR_TRIP_ACTIVITY_TYPES
General Data Type: NUMBER
Foreign Key Relations:

FVTR.FVTR_TRIP_ACTIVITY_TYPES

Catalog Details

Catalog Item ID: 34248
GUID: gov.noaa.nmfs.inport:34248
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-08-11 10:02+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-08-23
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-08-23
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-08-23