Table: FVTR_GEAR_CODES
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34257 | Updated: August 9, 2022 | Published / External
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
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
|
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 |