Metadata Rubric

100%

6 / 6

NEFSC Metadata Library > Data Management Systems (DMS) > Vessel Electronic Reporting System (VERS) >

Table: VERS_EFFORT

Entity (ENT) | Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:34235 | Updated: August 9, 2022 | Published / External

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

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

CC ID: 343973

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

CC ID: 343982

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

CC ID: 343990

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

CC ID: 343995

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

CC ID: 343996

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

CC ID: 343997

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

CC ID: 343998

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

CC ID: 343999

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

CC ID: 344000

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

CC ID: 343974

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

CC ID: 343975

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

CC ID: 343976

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

CC ID: 343977

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

CC ID: 343978

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

CC ID: 343979

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

CC ID: 343972

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

CC ID: 343980

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

CC ID: 343970

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

CC ID: 343981

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

CC ID: 343983

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

CC ID: 343984

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

CC ID: 343971

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

CC ID: 343985

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

CC ID: 343986

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

CC ID: 343987

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

CC ID: 343988

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

CC ID: 343989

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

CC ID: 343968

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

CC ID: 343969

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

CC ID: 343991

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

CC ID: 343992

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

CC ID: 343993

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

CC ID: 343994

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