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: FVTR_GEAR_CODES

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

Summary

Abstract

Table lists accepted gear types and data validation parameters

Description

Table lists accepted gear types and data validation parameters

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
GEAR_CODE
VARCHAR2 		Concatenation of ACCSP and VTR gear codes used to map gears between the two data sets
ACCSP_GEAR_CODE
VARCHAR2 		ACCSP gear code
VTR_GEAR_CODE
VARCHAR2 		VTR gear code
VTR_GEAR_NAME
VARCHAR2 		VTR gear code description
VTR_DISPLAY_FLAG
VARCHAR2 		Binary code used to indicate which gears are valid for VTR reporting, 1=valid, 0=invalid
ACCSP_GEAR_NAME
VARCHAR2 		ACCSP gear code description
ST_GEAR_QTY_MEAS
VARCHAR2 		VTR required measurement - quantity of gear being fished per haul for sub-trip efforts
GEAR_QTY_UNIT
VARCHAR2 		Unit of measure for GEAR_QTY_MEAS
MIN_GEAR_QTY
NUMBER 		Minimum acceptable value associated with GEAR_QTY_MEAS
MAX_GEAR_QTY
NUMBER 		Maximum acceptable value associated with GEAR_QTY_MEAS
ST_SOAK_TIME_MEAS
VARCHAR2 		VTR required measurement - duration of gear deployment for sub-trip efforts
SOAK_TIME_UNIT
VARCHAR2 		Unit of measure for SOAK_TIME_MEAS
MIN_SOAK_TIME
NUMBER 		Minimum acceptable value associated with SOAK_TIME_MEAS
MAX_SOAK_TIME
NUMBER 		Maximum acceptable value associated with SOAK_TIME_MEAS
NHAULS_MEAS
VARCHAR2 		VTR required measurement - total number of tows, sets, or strings hauled
NHAULS_UNIT
VARCHAR2 		Unit of measure for NHAULS_MEAS
MIN_HAULS
NUMBER 		Minimum acceptable value associated with NHAULS_MEAS
MAX_HAULS
NUMBER 		Maximum acceptable value associated with MIN_HAULS
GEAR_SIZE_MEAS
VARCHAR2 		VTR required measurement - size of the gear being fished, avg. used if GEAR_QTY_MEAS is gt 1
GEAR_SIZE_UNIT
VARCHAR2 		Unit of measure for GEAR_SIZE_MEAS
MIN_GEAR_SIZE
NUMBER 		Minimum acceptable value associated with GEAR_SIZE_MEAS
MAX_GEAR_SIZE
NUMBER 		Maximum acceptable value associated with GEAR_SIZE_MEAS
MESH_RING_SIZE_MEAS
VARCHAR2 		VTR required measurement - mesh, ring or entrance size of gear being fished, avg. used if GEAR_QTY_MEAS is gt 1
MESH_RING_SIZE_UNIT
VARCHAR2 		Unit of measure for MESH_RING_SIZE_MEAS
MIN_MESH_RING_SIZE
NUMBER 		Minimum acceptable value associated with MESH_RING_SIZE_MEAS
MAX_MESH_RING_SIZE
NUMBER 		Maximum acceptable value associated with MESH_RING_SIZE_MEAS
NEGEAR
VARCHAR2 		Gear coding equivalent for CFDBS and OBDBS databases
HBH_GEAR_QTY_MEAS
VARCHAR2 		VTR required measurement - quantity of gear being fished per haul for haul-by-haul efforts
MESH_TYPE_DISPLAYED
VARCHAR2 		Binary code used to indicate whether MESH_TYPE is relevant for the gear type during electronic logbook data collection (see FVTR.VERS_EFFORT); 1=display mesh type, 0=not display mesh type
FMCODE
VARCHAR2 		Gear category type indicator; F=fixed, M=mobile, O=other
HBH_SOAK_TIME_MEAS
VARCHAR2 		VTR required measurement - duration of gear deployment for haul-by-haul efforts

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: FVTR_GEAR_CODES
Short Name: FVTR_GEAR_CODES
Status: Completed
Abstract:

Table lists accepted gear types and data validation parameters
Notes:

Loaded by batch 9190, 08-11-2016 16:37

Entity Information

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

Table lists accepted gear types and data validation parameters

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key GEAR_CODE VARCHAR2 Concatenation of ACCSP and VTR gear codes used to map gears between the two data sets
100
 ACCSP_GEAR_CODE VARCHAR2 ACCSP gear code
100
 VTR_GEAR_CODE VARCHAR2 VTR gear code
100
 VTR_GEAR_NAME VARCHAR2 VTR gear code description
100
 VTR_DISPLAY_FLAG VARCHAR2 Binary code used to indicate which gears are valid for VTR reporting, 1=valid, 0=invalid
100
 ACCSP_GEAR_NAME VARCHAR2 ACCSP gear code description
100
 ST_GEAR_QTY_MEAS VARCHAR2 VTR required measurement - quantity of gear being fished per haul for sub-trip efforts
100
 GEAR_QTY_UNIT VARCHAR2 Unit of measure for GEAR_QTY_MEAS
100
 MIN_GEAR_QTY NUMBER Minimum acceptable value associated with GEAR_QTY_MEAS
100
 MAX_GEAR_QTY NUMBER Maximum acceptable value associated with GEAR_QTY_MEAS
100
 ST_SOAK_TIME_MEAS VARCHAR2 VTR required measurement - duration of gear deployment for sub-trip efforts
100
 SOAK_TIME_UNIT VARCHAR2 Unit of measure for SOAK_TIME_MEAS
100
 MIN_SOAK_TIME NUMBER Minimum acceptable value associated with SOAK_TIME_MEAS
100
 MAX_SOAK_TIME NUMBER Maximum acceptable value associated with SOAK_TIME_MEAS
100
 NHAULS_MEAS VARCHAR2 VTR required measurement - total number of tows, sets, or strings hauled
100
 NHAULS_UNIT VARCHAR2 Unit of measure for NHAULS_MEAS
100
 MIN_HAULS NUMBER Minimum acceptable value associated with NHAULS_MEAS
100
 MAX_HAULS NUMBER Maximum acceptable value associated with MIN_HAULS
100
 GEAR_SIZE_MEAS VARCHAR2 VTR required measurement - size of the gear being fished, avg. used if GEAR_QTY_MEAS is gt 1
100
 GEAR_SIZE_UNIT VARCHAR2 Unit of measure for GEAR_SIZE_MEAS
100
 MIN_GEAR_SIZE NUMBER Minimum acceptable value associated with GEAR_SIZE_MEAS
100
 MAX_GEAR_SIZE NUMBER Maximum acceptable value associated with GEAR_SIZE_MEAS
100
 MESH_RING_SIZE_MEAS VARCHAR2 VTR required measurement - mesh, ring or entrance size of gear being fished, avg. used if GEAR_QTY_MEAS is gt 1
100
 MESH_RING_SIZE_UNIT VARCHAR2 Unit of measure for MESH_RING_SIZE_MEAS
100
 MIN_MESH_RING_SIZE NUMBER Minimum acceptable value associated with MESH_RING_SIZE_MEAS
100
 MAX_MESH_RING_SIZE NUMBER Maximum acceptable value associated with MESH_RING_SIZE_MEAS
100
 NEGEAR VARCHAR2 Gear coding equivalent for CFDBS and OBDBS databases
100
 HBH_GEAR_QTY_MEAS VARCHAR2 VTR required measurement - quantity of gear being fished per haul for haul-by-haul efforts
100
 MESH_TYPE_DISPLAYED VARCHAR2 Binary code used to indicate whether MESH_TYPE is relevant for the gear type during electronic logbook data collection (see FVTR.VERS_EFFORT); 1=display mesh type, 0=not display mesh type
100
 FMCODE VARCHAR2 Gear category type indicator; F=fixed, M=mobile, O=other
100
 HBH_SOAK_TIME_MEAS VARCHAR2 VTR required measurement - duration of gear deployment for haul-by-haul efforts

Attribute Details

GEAR_CODE

CC ID: 344154
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 6
Required: Yes
Primary Key: Yes
Status: Active
Description:

Concatenation of ACCSP and VTR gear codes used to map gears between the two data sets
General Data Type: VARCHAR2

ACCSP_GEAR_CODE

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

ACCSP gear code
General Data Type: VARCHAR2

VTR_GEAR_CODE

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

VTR gear code
General Data Type: VARCHAR2

VTR_GEAR_NAME

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

VTR gear code description
General Data Type: VARCHAR2

VTR_DISPLAY_FLAG

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

Binary code used to indicate which gears are valid for VTR reporting, 1=valid, 0=invalid
General Data Type: VARCHAR2

ACCSP_GEAR_NAME

CC ID: 344177
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 40
Required: Yes
Primary Key: No
Status: Active
Description:

ACCSP gear code description
General Data Type: VARCHAR2

ST_GEAR_QTY_MEAS

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

VTR required measurement - quantity of gear being fished per haul for sub-trip efforts
General Data Type: VARCHAR2

GEAR_QTY_UNIT

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

Unit of measure for GEAR_QTY_MEAS
General Data Type: VARCHAR2
Foreign Key Relations:

FVTR.FVTR_UNITS_OF_MEASURE

MIN_GEAR_QTY

CC ID: 344179
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Minimum acceptable value associated with GEAR_QTY_MEAS
General Data Type: NUMBER

MAX_GEAR_QTY

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

Maximum acceptable value associated with GEAR_QTY_MEAS
General Data Type: NUMBER

ST_SOAK_TIME_MEAS

CC ID: 344156
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 50
Required: Yes
Primary Key: No
Status: Active
Description:

VTR required measurement - duration of gear deployment for sub-trip efforts
General Data Type: VARCHAR2

SOAK_TIME_UNIT

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

Unit of measure for SOAK_TIME_MEAS
General Data Type: VARCHAR2
Foreign Key Relations:

FVTR.FVTR_UNITS_OF_MEASURE

MIN_SOAK_TIME

CC ID: 344157
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

Minimum acceptable value associated with SOAK_TIME_MEAS
General Data Type: NUMBER

MAX_SOAK_TIME

CC ID: 344158
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

Maximum acceptable value associated with SOAK_TIME_MEAS
General Data Type: NUMBER

NHAULS_MEAS

CC ID: 344159
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 50
Required: Yes
Primary Key: No
Status: Active
Description:

VTR required measurement - total number of tows, sets, or strings hauled
General Data Type: VARCHAR2

NHAULS_UNIT

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

Unit of measure for NHAULS_MEAS
General Data Type: VARCHAR2
Foreign Key Relations:

FVTR.FVTR_UNITS_OF_MEASURE

MIN_HAULS

CC ID: 344160
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Minimum acceptable value associated with NHAULS_MEAS
General Data Type: NUMBER

MAX_HAULS

CC ID: 344161
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Maximum acceptable value associated with MIN_HAULS
General Data Type: NUMBER

GEAR_SIZE_MEAS

CC ID: 344162
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 50
Required: Yes
Primary Key: No
Status: Active
Description:

VTR required measurement - size of the gear being fished, avg. used if GEAR_QTY_MEAS is gt 1
General Data Type: VARCHAR2

GEAR_SIZE_UNIT

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

Unit of measure for GEAR_SIZE_MEAS
General Data Type: VARCHAR2
Foreign Key Relations:

FVTR.FVTR_UNITS_OF_MEASURE

MIN_GEAR_SIZE

CC ID: 344164
Seq. Order: 21
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 1
Status: Active
Description:

Minimum acceptable value associated with GEAR_SIZE_MEAS
General Data Type: NUMBER

MAX_GEAR_SIZE

CC ID: 344165
Seq. Order: 22
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 1
Status: Active
Description:

Maximum acceptable value associated with GEAR_SIZE_MEAS
General Data Type: NUMBER

MESH_RING_SIZE_MEAS

CC ID: 344166
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 50
Required: Yes
Primary Key: No
Status: Active
Description:

VTR required measurement - mesh, ring or entrance size of gear being fished, avg. used if GEAR_QTY_MEAS is gt 1
General Data Type: VARCHAR2

MESH_RING_SIZE_UNIT

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

Unit of measure for MESH_RING_SIZE_MEAS
General Data Type: VARCHAR2
Foreign Key Relations:

FVTR.FVTR_UNITS_OF_MEASURE

MIN_MESH_RING_SIZE

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

Minimum acceptable value associated with MESH_RING_SIZE_MEAS
General Data Type: NUMBER

MAX_MESH_RING_SIZE

CC ID: 344168
Seq. Order: 26
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 3
Status: Active
Description:

Maximum acceptable value associated with MESH_RING_SIZE_MEAS
General Data Type: NUMBER

NEGEAR

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

Gear coding equivalent for CFDBS and OBDBS databases
General Data Type: VARCHAR2

HBH_GEAR_QTY_MEAS

CC ID: 344170
Seq. Order: 28
Data Storage Type: VARCHAR2
Max Length: 50
Required: Yes
Primary Key: No
Status: Active
Description:

VTR required measurement - quantity of gear being fished per haul for haul-by-haul efforts
General Data Type: VARCHAR2

MESH_TYPE_DISPLAYED

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

Binary code used to indicate whether MESH_TYPE is relevant for the gear type during electronic logbook data collection (see FVTR.VERS_EFFORT); 1=display mesh type, 0=not display mesh type
General Data Type: VARCHAR2

FMCODE

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

Gear category type indicator; F=fixed, M=mobile, O=other
General Data Type: VARCHAR2

HBH_SOAK_TIME_MEAS

CC ID: 344174
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 50
Required: Yes
Primary Key: No
Status: Active
Description:

VTR required measurement - duration of gear deployment for haul-by-haul efforts
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 34257
GUID: gov.noaa.nmfs.inport:34257
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-08-11 16:37+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