Metadata Rubric

100%

6 / 6

NEFSC Metadata Library > Population and Ecosystems Monitoring and Analys... > Population Biology Branch > Enhanced Biological Sampling Data >

TRIP_DATA

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

Item Identification

Title:	TRIP_DATA
Short Name:	TRIP_DATA
Status:	Completed
Abstract:	This table has the vessel operations data for the fishing efforts that specimens were obtained from Study Fleet vessels. Data comes from FVTR.CRPP_VERS_EFFORT, NERS.GTE_EFFORTS, and is linked via NERS.SF_BIOSAMP_REQUEST_SAMPLES.

Entity Information

Entity Type:	Data Table
Active Version?:	Yes
Description:	This table has the vessel operations data for the fishing efforts that specimens were obtained from Study Fleet vessels. Data comes from FVTR.CRPP_VERS_EFFORT, NERS.GTE_EFFORTS, and is linked via NERS.SF_BIOSAMP_REQUEST_SAMPLES.

Data Attributes

Attribute Summary

	Name	Type	Description
100	FISH_ID_CODE	VARCHAR2	Unique code for each sampled fish. Assigned and dependent on FISH_ORGANISM.FISH_ID_CODE
100	TRIP_IDENTIFIER_BARCODE	VARCHAR2	Unique identifier that identifies the specific request number the fish came from and the final container (cooler or tote) for the fish from a specified tow. It is a concatenation of the SBR_REQUEST_ID and TOTE_ID columns with an underscore between. It is used to join the catch data from NERS and FVTR by matching to those 2 columns in NERS.SF_BIOSAMP_REQUEST_SAMPLES.
100	SPECIES_ITIS	VARCHAR2	Integrated Taxonomic Information System Code; support table VERS.SFLT_SPECIES_CODES
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	Not used
100	FA_AREA_CODE	VARCHAR2	ACCSP area or waterbody code. Same code as the AREA in the CFDBS AREA table.
100	FA_SUB_AREA_CODE	VARCHAR2	ACCSP sub area or waterbody code. Same code as the NEMAREA code in the CFDBS AREA table.
100	SBR_REQUEST_ID	VARCHAR2	Unique biosample request identification number
100	LINK	VARCHAR2	Identifier for joining data with NERS and FVTR. Same as TRIP_IDENTIFIER_BARCODE.
100	FVTR_TRIP_ID	NUMBER	Unique trip identifier generated in FLDRS software
100	ELB_EFFORT_NUM	VARCHAR2	Unique effort identifier within a trip
100	TRIP_ID	NUMBER	Unique trip identifier generated in FLDRS software
100	EFFORT_NUM	VARCHAR2	Unique effort identifier within a trip
100	CALC_DUR_HR	DATE	Duration of the effort in hours
100	CALC_DIST_NM	NUMBER	Total distance towed in nautical miles
100	MIN_TEMP_C	NUMBER	Min temperature in Celsius
100	MEAN_TEMP_C	NUMBER	Mean temperature in Celsius
100	MAX_TEMP_C	NUMBER	Max temperature in Celsius
100	MIN_DPTH_M	NUMBER	Min depth in meters
100	MEAN_DPTH_M	NUMBER	Mean depth in meters
100	MAX_DPTH_M	NUMBER	Max depth in meters
100	MIN_SPD_NMPH	NUMBER	Min vessel speed in nautical miles per hour
100	MEAN_SPD_NMPH	NUMBER	Mean vessel speed in nautical miles per hour
100	MAX_SPD_NMPH	NUMBER	Max vessel speed in nautical miles per hour
100	GTE_CODE	VARCHAR2	GTE codes (A unique identifier of a data quality issue) for the effort; supporting table NERS.GTE_CODES
100	GEAR_CODE	VARCHAR2	Concatenation of ACCSP and VTR gear codes used to map gears between the two data sets

Name

Type

Description

100

FISH_ID_CODE

VARCHAR2

Unique code for each sampled fish. Assigned and dependent on FISH_ORGANISM.FISH_ID_CODE

100

TRIP_IDENTIFIER_BARCODE

VARCHAR2

Unique identifier that identifies the specific request number the fish came from and the final container (cooler or tote) for the fish from a specified tow. It is a concatenation of the SBR_REQUEST_ID and TOTE_ID columns with an underscore between. It is used to join the catch data from NERS and FVTR by matching to those 2 columns in NERS.SF_BIOSAMP_REQUEST_SAMPLES.

100

SPECIES_ITIS

VARCHAR2

Integrated Taxonomic Information System Code; support table VERS.SFLT_SPECIES_CODES

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

Not used

100

FA_AREA_CODE

VARCHAR2

ACCSP area or waterbody code. Same code as the AREA in the CFDBS AREA table.

100

FA_SUB_AREA_CODE

VARCHAR2

ACCSP sub area or waterbody code. Same code as the NEMAREA code in the CFDBS AREA table.

100

SBR_REQUEST_ID

VARCHAR2

Unique biosample request identification number

100

LINK

VARCHAR2

Identifier for joining data with NERS and FVTR. Same as TRIP_IDENTIFIER_BARCODE.

100

FVTR_TRIP_ID

NUMBER

Unique trip identifier generated in FLDRS software

100

ELB_EFFORT_NUM

VARCHAR2

Unique effort identifier within a trip

100

TRIP_ID

NUMBER

Unique trip identifier generated in FLDRS software

100

EFFORT_NUM

VARCHAR2

Unique effort identifier within a trip

100

CALC_DUR_HR

DATE

Duration of the effort in hours

100

CALC_DIST_NM

NUMBER

Total distance towed in nautical miles

100

MIN_TEMP_C

NUMBER

Min temperature in Celsius

100

MEAN_TEMP_C

NUMBER

Mean temperature in Celsius

100

MAX_TEMP_C

NUMBER

Max temperature in Celsius

100

MIN_DPTH_M

NUMBER

Min depth in meters

100

MEAN_DPTH_M

NUMBER

Mean depth in meters

100

MAX_DPTH_M

NUMBER

Max depth in meters

100

MIN_SPD_NMPH

NUMBER

Min vessel speed in nautical miles per hour

100

MEAN_SPD_NMPH

NUMBER

Mean vessel speed in nautical miles per hour

100

MAX_SPD_NMPH

NUMBER

Max vessel speed in nautical miles per hour

100

GTE_CODE

VARCHAR2

GTE codes (A unique identifier of a data quality issue) for the effort; supporting table NERS.GTE_CODES

100

GEAR_CODE

VARCHAR2

Concatenation of ACCSP and VTR gear codes used to map gears between the two data sets

Attribute Details

FISH_ID_CODE

CC ID: 362262

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Unique code for each sampled fish. Assigned and dependent on FISH_ORGANISM.FISH_ID_CODE
General Data Type:	VARCHAR2

TRIP_IDENTIFIER_BARCODE

CC ID: 362263

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique identifier that identifies the specific request number the fish came from and the final container (cooler or tote) for the fish from a specified tow. It is a concatenation of the SBR_REQUEST_ID and TOTE_ID columns with an underscore between. It is used to join the catch data from NERS and FVTR by matching to those 2 columns in NERS.SF_BIOSAMP_REQUEST_SAMPLES.
General Data Type:	VARCHAR2

SPECIES_ITIS

CC ID: 362264

Seq. Order:	50
Data Storage Type:	VARCHAR2
Max Length:	11
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Integrated Taxonomic Information System Code; support table VERS.SFLT_SPECIES_CODES
General Data Type:	VARCHAR2

START_SET_DATE_GMT

CC ID: 362265

Seq. Order:	51
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: 362266

Seq. Order:	52
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: 362267

Seq. Order:	53
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: 362268

Seq. Order:	54
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: 362269

Seq. Order:	55
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
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: 362270

Seq. Order:	56
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: 362271

Seq. Order:	57
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: 362272

Seq. Order:	58
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
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: 362273

Seq. Order:	59
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: 362274

Seq. Order:	60
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: 362275

Seq. Order:	61
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
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: 362276

Seq. Order:	62
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: 362277

Seq. Order:	63
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: 362278

Seq. Order:	64
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Unit of measure for DEPTH
General Data Type:	VARCHAR2

TEMP

CC ID: 362279

Seq. Order:	65
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Scale:	2
Status:	Active
Description:	Not used
General Data Type:	NUMBER

FA_AREA_CODE

CC ID: 362280

Seq. Order:	66
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	Yes
Primary Key:	No
Status:	Active
Description:	ACCSP area or waterbody code. Same code as the AREA in the CFDBS AREA table.
General Data Type:	VARCHAR2

FA_SUB_AREA_CODE

CC ID: 362281

Seq. Order:	67
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	Yes
Primary Key:	No
Status:	Active
Description:	ACCSP sub area or waterbody code. Same code as the NEMAREA code in the CFDBS AREA table.
General Data Type:	VARCHAR2

SBR_REQUEST_ID

CC ID: 362282

Seq. Order:	68
Data Storage Type:	VARCHAR2
Max Length:	15
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Unique biosample request identification number
General Data Type:	VARCHAR2

LINK

CC ID: 362283

Seq. Order:	69
Data Storage Type:	VARCHAR2
Max Length:	21
Required:	No
Primary Key:	No
Status:	Active
Description:	Identifier for joining data with NERS and FVTR. Same as TRIP_IDENTIFIER_BARCODE.
General Data Type:	VARCHAR2

FVTR_TRIP_ID

CC ID: 362284

Seq. Order:	70
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	14
Scale:	0
Status:	Active
Description:	Unique trip identifier generated in FLDRS software
General Data Type:	NUMBER

ELB_EFFORT_NUM

CC ID: 362285

Seq. Order:	71
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Unique effort identifier within a trip
General Data Type:	VARCHAR2

TRIP_ID

CC ID: 362286

Seq. Order:	72
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Unique trip identifier generated in FLDRS software
General Data Type:	NUMBER

EFFORT_NUM

CC ID: 362287

Seq. Order:	73
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique effort identifier within a trip
General Data Type:	VARCHAR2

CALC_DUR_HR

CC ID: 362288

Seq. Order:	74
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Duration of the effort in hours
General Data Type:	DATE

CALC_DIST_NM

CC ID: 362289

Seq. Order:	75
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	5
Scale:	2
Status:	Active
Description:	Total distance towed in nautical miles
General Data Type:	NUMBER

MIN_TEMP_C

CC ID: 362290

Seq. Order:	76
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	2
Status:	Active
Description:	Min temperature in Celsius
General Data Type:	NUMBER

MEAN_TEMP_C

CC ID: 362291

Seq. Order:	77
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	2
Status:	Active
Description:	Mean temperature in Celsius
General Data Type:	NUMBER

MAX_TEMP_C

CC ID: 362292

Seq. Order:	78
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	2
Status:	Active
Description:	Max temperature in Celsius
General Data Type:	NUMBER

MIN_DPTH_M

CC ID: 362293

Seq. Order:	79
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	5
Scale:	2
Status:	Active
Description:	Min depth in meters
General Data Type:	NUMBER

MEAN_DPTH_M

CC ID: 362294

Seq. Order:	80
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	5
Scale:	2
Status:	Active
Description:	Mean depth in meters
General Data Type:	NUMBER

MAX_DPTH_M

CC ID: 362295

Seq. Order:	81
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	5
Scale:	2
Status:	Active
Description:	Max depth in meters
General Data Type:	NUMBER

MIN_SPD_NMPH

CC ID: 362296

Seq. Order:	82
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	2
Status:	Active
Description:	Min vessel speed in nautical miles per hour
General Data Type:	NUMBER

MEAN_SPD_NMPH

CC ID: 362297

Seq. Order:	83
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	2
Status:	Active
Description:	Mean vessel speed in nautical miles per hour
General Data Type:	NUMBER

MAX_SPD_NMPH

CC ID: 362298

Seq. Order:	84
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	2
Status:	Active
Description:	Max vessel speed in nautical miles per hour
General Data Type:	NUMBER

GTE_CODE

CC ID: 362299

Seq. Order:	85
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	GTE codes (A unique identifier of a data quality issue) for the effort; supporting table NERS.GTE_CODES
General Data Type:	VARCHAR2

GEAR_CODE

CC ID: 362300

Seq. Order:	86
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Concatenation of ACCSP and VTR gear codes used to map gears between the two data sets
General Data Type:	VARCHAR2

Catalog Details

Catalog Item ID:	35896
GUID:	gov.noaa.nmfs.inport:35896
Metadata Record Created By:	Patricia L Jones
Metadata Record Created:	2016-12-07 13:28+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2016-12-07
Owner Org:	NEFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2016-12-07
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2017-12-07