Table: VERS_EFFORT
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34235 | Updated: August 9, 2022 | Published / External
Entity Information
| Entity Type: | Data Table |
|---|---|
| Active Version?: | Yes |
| Schema Name: | FVTR |
| Description: |
Table contains effort level records for electronically reported data |
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
|
TRIP_ID | NUMBER | Unique trip identifier |
|
100
|
|
EFFORT_NUM | NUMBER | Unique identifier for the effort |
|
100
|
START_SET_DATE_GMT | DATE | Datetime (UTC) when the gear is first placed in the water at the start of the fishing effort | |
|
100
|
START_SET_LAT | NUMBER | Latitude where the gear is first placed in the water at the start of the fishing effort (ddmm.mmmm) | |
|
100
|
START_SET_LON | NUMBER | Longitude where the gear is first placed in the water at the start of the fishing effort (dddmm.mmmm) | |
|
100
|
END_SET_DATE_GMT | DATE | Datetime (UTC) when setting of the gear has stopped and the gear begins to fish | |
|
100
|
END_SET_LAT | NUMBER | Latitude where the setting of the gear has stopped and the gear begins to fish (ddmm.mmmm) | |
|
100
|
END_SET_LON | NUMBER | Longitude where the setting of the gear has stopped and the gear begins to fish (dddmm.mmmm) | |
|
100
|
START_HAUL_DATE_GMT | DATE | Datetime (UTC) when fishing stops and hauling the gear starts | |
|
100
|
START_HAUL_LAT | NUMBER | Latitude where fishing stops and hauling the gear starts (ddmm.mmmm) | |
|
100
|
START_HAUL_LON | NUMBER | Longitude where fishing stops and hauling the gear starts (dddmm.mmmm) | |
|
100
|
END_HAUL_DATE_GMT | DATE | Datetime (UTC) when the gear has been completely hauled and is back aboard the vessel | |
|
100
|
END_HAUL_LAT | NUMBER | Latitude where the gear has been completely hauled and is back aboard the vessel (ddmm.mmmm) | |
|
100
|
END_HAUL_LON | NUMBER | Longitude where the gear has been completely hauled and is back aboard the vessel (dddmm.mmmm) | |
|
100
|
DEPTH | NUMBER | Fishing depth of the gear | |
|
100
|
DEPTH_UOM | VARCHAR2 | Unit of measure for DEPTH | |
|
100
|
TEMP | NUMBER | Water temperature (degrees C) | |
|
100
|
GC_GEAR_CODE | VARCHAR2 | Gear code for the gear type used during the fishing effort; see FVTR_GEAR_CODES | |
|
100
|
GEAR_QUANTITY | NUMBER | Number of pieces of gear fished simultaneously (for subtrip reporting, this will be an average of gear pieces fished for the relevant hauls) | |
|
100
|
GEAR_SIZE | NUMBER | Size of the gear being fished (for subtrip reporting, this will be an average of gears fished for the relevant hauls) | |
|
100
|
MESH_SIZE | NUMBER | Size of the mesh or ring used on the fishing gear (for subtrip reporting, this will be an average of gears fished for the relevant hauls) | |
|
100
|
MESH_TYPE | VARCHAR2 | Type of mesh being fished on trawl or gillnet gear; see FVTR_MESH_TYPES | |
|
100
|
NUM_HAULS | NUMBER | Number of hauls contained within the subtrip (always equals 1 when reporting at the haul-by-haul level) | |
|
100
|
SOAK_DURATION_DH | NUMBER | Soak or haul duration of the fishing effort (h.hh) | |
|
100
|
FAILED_EFFORT | VARCHAR2 | Binary code used to indicate a 'water haul' or fishing effort without catch; 0=valid effort, 1=failed effort | |
|
100
|
EFFORT_ENTRY_DATE_GMT | DATE | Datetime (UTC) at which the effort record was entered into the ELB | |
|
100
|
UPLOAD_DATE_GMT | DATE | Datetime (UTC) at which the submitted data was loaded to NEFSC servers | |
|
100
|
FA_AREA_CODE | VARCHAR2 | Statistical area in which the fishing effort occurred, value assigned based on the START_HAUL_LAT and START_HAUL_LON point location (see FVTR_FISHING_AREAS) | |
|
100
|
FA_SUB_AREA_CODE | VARCHAR2 | Inshore area code within the statistical area in which the fishing effort occurred, value assigned based on the START_HAUL_LAT and START_HAUL_LON point location (see FVTR_FISHING_AREAS) | |
|
100
|
LORAN_BEARING1 | VARCHAR2 | First loran chain bearing corresponding to the average position of all efforts within a sub-trip (not collected when reporting via ELB at the haul-by-haul level) | |
|
100
|
LORAN_BEARING2 | VARCHAR2 | Second loran chain bearing corresponding to the average position of all efforts within a sub-trip (not collected when reporting via ELB at the haul-by-haul level) | |
|
100
|
START_HAUL_LAT_DMS | VARCHAR2 | Currently not used | |
|
100
|
START_HAUL_LON_DMS | VARCHAR2 | Currently not used |
Attribute Details
TRIP_ID
| 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 |
| Foreign Key Relations: |
FVTR.VERS_TRIP |
EFFORT_NUM
| Seq. Order: | 2 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | Yes |
| Primary Key: | Yes |
| Precision: | 3 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Unique identifier for the effort |
| General Data Type: | NUMBER |
START_SET_DATE_GMT
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Datetime (UTC) when the gear is first placed in the water at the start of the fishing effort |
| General Data Type: | DATE |
START_SET_LAT
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 11 |
| Scale: | 6 |
| Status: | Active |
| Description: |
Latitude where the gear is first placed in the water at the start of the fishing effort (ddmm.mmmm) |
| General Data Type: | NUMBER |
START_SET_LON
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 11 |
| Scale: | 6 |
| Status: | Active |
| Description: |
Longitude where the gear is first placed in the water at the start of the fishing effort (dddmm.mmmm) |
| General Data Type: | NUMBER |
END_SET_DATE_GMT
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Datetime (UTC) when setting of the gear has stopped and the gear begins to fish |
| General Data Type: | DATE |
END_SET_LAT
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 11 |
| Scale: | 6 |
| Status: | Active |
| Description: |
Latitude where the setting of the gear has stopped and the gear begins to fish (ddmm.mmmm) |
| General Data Type: | NUMBER |
END_SET_LON
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 11 |
| Scale: | 6 |
| Status: | Active |
| Description: |
Longitude where the setting of the gear has stopped and the gear begins to fish (dddmm.mmmm) |
| General Data Type: | NUMBER |
START_HAUL_DATE_GMT
| Seq. Order: | 9 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Datetime (UTC) when fishing stops and hauling the gear starts |
| General Data Type: | DATE |
START_HAUL_LAT
| Seq. Order: | 10 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 11 |
| Scale: | 6 |
| Status: | Active |
| Description: |
Latitude where fishing stops and hauling the gear starts (ddmm.mmmm) |
| General Data Type: | NUMBER |
START_HAUL_LON
| Seq. Order: | 11 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 11 |
| Scale: | 6 |
| Status: | Active |
| Description: |
Longitude where fishing stops and hauling the gear starts (dddmm.mmmm) |
| General Data Type: | NUMBER |
END_HAUL_DATE_GMT
| Seq. Order: | 12 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Datetime (UTC) when the gear has been completely hauled and is back aboard the vessel |
| General Data Type: | DATE |
END_HAUL_LAT
| Seq. Order: | 13 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 11 |
| Scale: | 6 |
| Status: | Active |
| Description: |
Latitude where the gear has been completely hauled and is back aboard the vessel (ddmm.mmmm) |
| General Data Type: | NUMBER |
END_HAUL_LON
| Seq. Order: | 14 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 11 |
| Scale: | 6 |
| Status: | Active |
| Description: |
Longitude where the gear has been completely hauled and is back aboard the vessel (dddmm.mmmm) |
| General Data Type: | NUMBER |
DEPTH
| Seq. Order: | 15 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Fishing depth of the gear |
| General Data Type: | NUMBER |
DEPTH_UOM
| Seq. Order: | 16 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unit of measure for DEPTH |
| General Data Type: | VARCHAR2 |
| Foreign Key Relations: |
FVTR.FVTR_UNITS_OF_MEASURE |
TEMP
| Seq. Order: | 17 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 5 |
| Scale: | 2 |
| Status: | Active |
| Description: |
Water temperature (degrees C) |
| General Data Type: | NUMBER |
GC_GEAR_CODE
| Seq. Order: | 18 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 6 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Gear code for the gear type used during the fishing effort; see FVTR_GEAR_CODES |
| General Data Type: | VARCHAR2 |
| Foreign Key Relations: |
FVTR.FVTR_GEAR_CODES |
GEAR_QUANTITY
| Seq. Order: | 19 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Number of pieces of gear fished simultaneously (for subtrip reporting, this will be an average of gear pieces fished for the relevant hauls) |
| General Data Type: | NUMBER |
GEAR_SIZE
| Seq. Order: | 20 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 1 |
| Status: | Active |
| Description: |
Size of the gear being fished (for subtrip reporting, this will be an average of gears fished for the relevant hauls) |
| General Data Type: | NUMBER |
MESH_SIZE
| Seq. Order: | 21 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 3 |
| Status: | Active |
| Description: |
Size of the mesh or ring used on the fishing gear (for subtrip reporting, this will be an average of gears fished for the relevant hauls) |
| General Data Type: | NUMBER |
MESH_TYPE
| Seq. Order: | 22 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Type of mesh being fished on trawl or gillnet gear; see FVTR_MESH_TYPES |
| General Data Type: | VARCHAR2 |
| Foreign Key Relations: |
FVTR.FVTR_MESH_TYPES |
NUM_HAULS
| Seq. Order: | 23 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 3 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Number of hauls contained within the subtrip (always equals 1 when reporting at the haul-by-haul level) |
| General Data Type: | NUMBER |
SOAK_DURATION_DH
| Seq. Order: | 24 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 2 |
| Status: | Active |
| Description: |
Soak or haul duration of the fishing effort (h.hh) |
| General Data Type: | NUMBER |
FAILED_EFFORT
| Seq. Order: | 25 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Binary code used to indicate a 'water haul' or fishing effort without catch; 0=valid effort, 1=failed effort |
| General Data Type: | VARCHAR2 |
EFFORT_ENTRY_DATE_GMT
| Seq. Order: | 26 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Datetime (UTC) at which the effort record was entered into the ELB |
| General Data Type: | DATE |
UPLOAD_DATE_GMT
| Seq. Order: | 27 |
|---|---|
| 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 |
FA_AREA_CODE
| Seq. Order: | 28 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Statistical area in which the fishing effort occurred, value assigned based on the START_HAUL_LAT and START_HAUL_LON point location (see FVTR_FISHING_AREAS) |
| General Data Type: | VARCHAR2 |
| Foreign Key Relations: |
FVTR.FVTR_FISHING_AREAS |
FA_SUB_AREA_CODE
| Seq. Order: | 29 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 5 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Inshore area code within the statistical area in which the fishing effort occurred, value assigned based on the START_HAUL_LAT and START_HAUL_LON point location (see FVTR_FISHING_AREAS) |
| General Data Type: | VARCHAR2 |
| Foreign Key Relations: |
FVTR.FVTR_FISHING_AREAS |
LORAN_BEARING1
| Seq. Order: | 30 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
First loran chain bearing corresponding to the average position of all efforts within a sub-trip (not collected when reporting via ELB at the haul-by-haul level) |
| General Data Type: | VARCHAR2 |
LORAN_BEARING2
| Seq. Order: | 31 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Second loran chain bearing corresponding to the average position of all efforts within a sub-trip (not collected when reporting via ELB at the haul-by-haul level) |
| General Data Type: | VARCHAR2 |
START_HAUL_LAT_DMS
| Seq. Order: | 32 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 6 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Currently not used |
| General Data Type: | VARCHAR2 |
START_HAUL_LON_DMS
| Seq. Order: | 33 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 7 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Currently not used |
| General Data Type: | VARCHAR2 |
Catalog Details
| Catalog Item ID: | 34235 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:34235 |
| 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 |