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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Table contains effort level records for electronically reported data

Description

Table contains effort level records for electronically reported data

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

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

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (NEFSC) for inquiries on this record.

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 Type:	Data Table
Active Version?:	Yes
Schema Name:	FVTR
Description:	Table contains effort level records for electronically reported data

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

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

TRIP_ID

EFFORT_NUM

START_SET_DATE_GMT

START_SET_LAT

START_SET_LON

END_SET_DATE_GMT

END_SET_LAT

END_SET_LON

START_HAUL_DATE_GMT

START_HAUL_LAT

START_HAUL_LON

END_HAUL_DATE_GMT

END_HAUL_LAT

END_HAUL_LON

DEPTH

DEPTH_UOM

TEMP

GC_GEAR_CODE

GEAR_QUANTITY

GEAR_SIZE

MESH_SIZE

MESH_TYPE

NUM_HAULS

SOAK_DURATION_DH

FAILED_EFFORT

EFFORT_ENTRY_DATE_GMT

UPLOAD_DATE_GMT

FA_AREA_CODE

FA_SUB_AREA_CODE

LORAN_BEARING1

LORAN_BEARING2

START_HAUL_LAT_DMS

START_HAUL_LON_DMS

Catalog Details