Table: VERS_EFFORT
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34235 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Table contains effort level records for electronically reported data
DescriptionTable contains effort level records for electronically reported data
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
TRIP_ID
NUMBER |
Unique trip identifier |
EFFORT_NUM
NUMBER |
Unique identifier for the effort |
START_SET_DATE_GMT
DATE |
Datetime (UTC) when the gear is first placed in the water at the start of the fishing effort |
START_SET_LAT
NUMBER |
Latitude where the gear is first placed in the water at the start of the fishing effort (ddmm.mmmm) |
START_SET_LON
NUMBER |
Longitude where the gear is first placed in the water at the start of the fishing effort (dddmm.mmmm) |
END_SET_DATE_GMT
DATE |
Datetime (UTC) when setting of the gear has stopped and the gear begins to fish |
END_SET_LAT
NUMBER |
Latitude where the setting of the gear has stopped and the gear begins to fish (ddmm.mmmm) |
END_SET_LON
NUMBER |
Longitude where the setting of the gear has stopped and the gear begins to fish (dddmm.mmmm) |
START_HAUL_DATE_GMT
DATE |
Datetime (UTC) when fishing stops and hauling the gear starts |
START_HAUL_LAT
NUMBER |
Latitude where fishing stops and hauling the gear starts (ddmm.mmmm) |
START_HAUL_LON
NUMBER |
Longitude where fishing stops and hauling the gear starts (dddmm.mmmm) |
END_HAUL_DATE_GMT
DATE |
Datetime (UTC) when the gear has been completely hauled and is back aboard the vessel |
END_HAUL_LAT
NUMBER |
Latitude where the gear has been completely hauled and is back aboard the vessel (ddmm.mmmm) |
END_HAUL_LON
NUMBER |
Longitude where the gear has been completely hauled and is back aboard the vessel (dddmm.mmmm) |
DEPTH
NUMBER |
Fishing depth of the gear |
DEPTH_UOM
VARCHAR2 |
Unit of measure for DEPTH |
TEMP
NUMBER |
Water temperature (degrees C) |
GC_GEAR_CODE
VARCHAR2 |
Gear code for the gear type used during the fishing effort; see FVTR_GEAR_CODES |
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) |
GEAR_SIZE
NUMBER |
Size of the gear being fished (for subtrip reporting, this will be an average of gears fished for the relevant hauls) |
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) |
MESH_TYPE
VARCHAR2 |
Type of mesh being fished on trawl or gillnet gear; see FVTR_MESH_TYPES |
NUM_HAULS
NUMBER |
Number of hauls contained within the subtrip (always equals 1 when reporting at the haul-by-haul level) |
SOAK_DURATION_DH
NUMBER |
Soak or haul duration of the fishing effort (h.hh) |
FAILED_EFFORT
VARCHAR2 |
Binary code used to indicate a 'water haul' or fishing effort without catch; 0=valid effort, 1=failed effort |
EFFORT_ENTRY_DATE_GMT
DATE |
Datetime (UTC) at which the effort record was entered into the ELB |
UPLOAD_DATE_GMT
DATE |
Datetime (UTC) at which the submitted data was loaded to NEFSC servers |
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) |
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) |
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) |
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) |
START_HAUL_LAT_DMS
VARCHAR2 |
Currently not used |
START_HAUL_LON_DMS
VARCHAR2 |
Currently not used |
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_EFFORT |
---|---|
Short Name: | VERS_EFFORT |
Status: | Completed |
Abstract: |
Table contains effort 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 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 |