Metadata Rubric

100%

6 / 6

NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Northeast Cooperative Research Program (NCRP) > Yellowtail Tagging Data (MRDBS) >

Table: MRYTHAUL

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

Item Identification

Title:	Table: MRYTHAUL
Short Name:	MRYTHAUL
Status:	Completed
Abstract:	Haul or Tow Information (yellowtail)
Notes:	Loaded by batch 9110, 08-01-2016 12:11

Entity Information

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	MRDBS
Description:	Haul or Tow Information (yellowtail)

Data Attributes

Attribute Summary

	Name	Type	Description
100	FISHERY	VARCHAR2	Fishery Code, a two character fishery identification code. See support table MRFISHERY for codes and descriptions.
100	TRIPID	VARCHAR2	Trip identification code, for yellowtail tagging, trip id consists of YT[year]-[sequential number of trip within year].
100	HAULNUM	VARCHAR2	Ordinal number of the haul within the trip, set number for shark cruises.
100	ESTCATCHNUM	NUMBER	Number estimated total catch .
100	ESTCATCHWGT	NUMBER	Weight estimated total catch .
100	ESTCATCHWGTUOM	VARCHAR2	Unit of measure for estimated catch weight.
100	ESTYTNUM	NUMBER	Number estimated yellowtail catch.
100	ESTYTWGT	NUMBER	Weight estimated yellowtail catch.
100	ESTYTWGTUOM	VARCHAR2	Unit of measure for estimated yellowtail weight.
100	YTTAGGEDNUM	NUMBER	Number yellowtail tagged.
100	DISCALIVE_SUBLGL	NUMBER	Number discarded alive (sub-legal).
100	DISCALIVE_OTHER	NUMBER	Number discarded alive for poor condition or total number discarded because sub-legal not counted.
100	DISCDEADNUM	NUMBER	Number discarded dead.
100	DISCNOTPRNUM	NUMBER	Number discarded not processed.
100	DISCALIVEWGT	NUMBER	Weight discarded alive.
100	DISCALIVEUOM	VARCHAR2	Unit of measure for weight discarded alive.
100	DISCDEADWGT	NUMBER	Weight discarded dead.
100	DISCDEADUOM	VARCHAR2	Unit of measure for weight discarded dead.
100	DISCNOTPRWGT	NUMBER	Weight discarded not processed.
100	DISCNOTPRUOM	VARCHAR2	Unit of measure for weight discarded not processes.
100	TAGGERCOMMENTS	VARCHAR2	Comments.
100	LOGHAULNUM	VARCHAR2	Original tow number used on paper logs (used for 2003, 2004 yt trips).
100	DOE	DATE	Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS).
100	UOE	VARCHAR2	The Oracle username of the individual who entered the new record.
100	DOC	DATE	Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).
100	UOC	VARCHAR2	The Oracle username of the individual who changed the current record.
100	WEB_DOE	DATE	Date when record was inserted into Oracle by the web application. Date format (DD-MON-YYYY HH24:MI:SS).
100	WEB_UOE	VARCHAR2	The username of the individual who entered the new record using the web application.
100	WEB_DOC	DATE	Date when the current record was updated or changed by the web application. Date format (DD-MON-YYYY HH:MI:SS).
100	WEB_UOC	VARCHAR2	The username of the individual who changed the current record using the web application.

Name

Type

Description

100

FISHERY

VARCHAR2

Fishery Code, a two character fishery identification code. See support table MRFISHERY for codes and descriptions.

100

TRIPID

VARCHAR2

Trip identification code, for yellowtail tagging, trip id consists of YT[year]-[sequential number of trip within year].

100

HAULNUM

VARCHAR2

Ordinal number of the haul within the trip, set number for shark cruises.

100

ESTCATCHNUM

NUMBER

Number estimated total catch .

100

ESTCATCHWGT

NUMBER

Weight estimated total catch .

100

ESTCATCHWGTUOM

VARCHAR2

Unit of measure for estimated catch weight.

100

ESTYTNUM

NUMBER

Number estimated yellowtail catch.

100

ESTYTWGT

NUMBER

Weight estimated yellowtail catch.

100

ESTYTWGTUOM

VARCHAR2

Unit of measure for estimated yellowtail weight.

100

YTTAGGEDNUM

NUMBER

Number yellowtail tagged.

100

DISCALIVE_SUBLGL

NUMBER

Number discarded alive (sub-legal).

100

DISCALIVE_OTHER

NUMBER

Number discarded alive for poor condition or total number discarded because sub-legal not counted.

100

DISCDEADNUM

NUMBER

Number discarded dead.

100

DISCNOTPRNUM

NUMBER

Number discarded not processed.

100

DISCALIVEWGT

NUMBER

Weight discarded alive.

100

DISCALIVEUOM

VARCHAR2

Unit of measure for weight discarded alive.

100

DISCDEADWGT

NUMBER

Weight discarded dead.

100

DISCDEADUOM

VARCHAR2

Unit of measure for weight discarded dead.

100

DISCNOTPRWGT

NUMBER

Weight discarded not processed.

100

DISCNOTPRUOM

VARCHAR2

Unit of measure for weight discarded not processes.

100

TAGGERCOMMENTS

VARCHAR2

Comments.

100

LOGHAULNUM

VARCHAR2

Original tow number used on paper logs (used for 2003, 2004 yt trips).

100

DOE

DATE

Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS).

100

UOE

VARCHAR2

The Oracle username of the individual who entered the new record.

100

DOC

DATE

Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).

100

UOC

VARCHAR2

The Oracle username of the individual who changed the current record.

100

WEB_DOE

DATE

Date when record was inserted into Oracle by the web application. Date format (DD-MON-YYYY HH24:MI:SS).

100

WEB_UOE

VARCHAR2

The username of the individual who entered the new record using the web application.

100

WEB_DOC

DATE

Date when the current record was updated or changed by the web application. Date format (DD-MON-YYYY HH:MI:SS).

100

WEB_UOC

VARCHAR2

The username of the individual who changed the current record using the web application.

Attribute Details

FISHERY

CC ID: 341141

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	Yes
Primary Key:	Yes
Status:	Active
Description:	Fishery Code, a two character fishery identification code. See support table MRFISHERY for codes and descriptions.
General Data Type:	VARCHAR2
Foreign Key Relations:	MRDBS.MRHAUL

TRIPID

CC ID: 341142

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	Yes
Primary Key:	Yes
Status:	Active
Description:	Trip identification code, for yellowtail tagging, trip id consists of YT[year]-[sequential number of trip within year].
General Data Type:	VARCHAR2
Foreign Key Relations:	MRDBS.MRHAUL

HAULNUM

CC ID: 341143

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	Yes
Primary Key:	Yes
Status:	Active
Description:	Ordinal number of the haul within the trip, set number for shark cruises.
General Data Type:	VARCHAR2
Foreign Key Relations:	MRDBS.MRHAUL

ESTCATCHNUM

CC ID: 341165

Seq. Order:	4
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	8
Scale:	0
Status:	Active
Description:	Number estimated total catch .
General Data Type:	NUMBER

ESTCATCHWGT

CC ID: 341166

Seq. Order:	5
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	8
Scale:	0
Status:	Active
Description:	Weight estimated total catch .
General Data Type:	NUMBER

ESTCATCHWGTUOM

CC ID: 341167

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Unit of measure for estimated catch weight.
General Data Type:	VARCHAR2

ESTYTNUM

CC ID: 341168

Seq. Order:	7
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	8
Scale:	0
Status:	Active
Description:	Number estimated yellowtail catch.
General Data Type:	NUMBER

ESTYTWGT

CC ID: 341169

Seq. Order:	8
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	8
Scale:	0
Status:	Active
Description:	Weight estimated yellowtail catch.
General Data Type:	NUMBER

ESTYTWGTUOM

CC ID: 341170

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Unit of measure for estimated yellowtail weight.
General Data Type:	VARCHAR2

YTTAGGEDNUM

CC ID: 341144

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Number yellowtail tagged.
General Data Type:	NUMBER

DISCALIVE_SUBLGL

CC ID: 341145

Seq. Order:	11
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Number discarded alive (sub-legal).
General Data Type:	NUMBER

DISCALIVE_OTHER

CC ID: 341146

Seq. Order:	12
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Number discarded alive for poor condition or total number discarded because sub-legal not counted.
General Data Type:	NUMBER

DISCDEADNUM

CC ID: 341147

Seq. Order:	13
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Number discarded dead.
General Data Type:	NUMBER

DISCNOTPRNUM

CC ID: 341148

Seq. Order:	14
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Number discarded not processed.
General Data Type:	NUMBER

DISCALIVEWGT

CC ID: 341149

Seq. Order:	15
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	9
Scale:	3
Status:	Active
Description:	Weight discarded alive.
General Data Type:	NUMBER

DISCALIVEUOM

CC ID: 341150

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Unit of measure for weight discarded alive.
General Data Type:	VARCHAR2

DISCDEADWGT

CC ID: 341151

Seq. Order:	17
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	9
Scale:	3
Status:	Active
Description:	Weight discarded dead.
General Data Type:	NUMBER

DISCDEADUOM

CC ID: 341152

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Unit of measure for weight discarded dead.
General Data Type:	VARCHAR2

DISCNOTPRWGT

CC ID: 341153

Seq. Order:	19
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	9
Scale:	3
Status:	Active
Description:	Weight discarded not processed.
General Data Type:	NUMBER

DISCNOTPRUOM

CC ID: 341154

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Unit of measure for weight discarded not processes.
General Data Type:	VARCHAR2

TAGGERCOMMENTS

CC ID: 341155

Seq. Order:	21
Data Storage Type:	VARCHAR2
Max Length:	200
Required:	No
Primary Key:	No
Status:	Active
Description:	Comments.
General Data Type:	VARCHAR2

LOGHAULNUM

CC ID: 341156

Seq. Order:	22
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Original tow number used on paper logs (used for 2003, 2004 yt trips).
General Data Type:	VARCHAR2

DOE

CC ID: 341157

Seq. Order:	23
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS).
General Data Type:	DATE

UOE

CC ID: 341158

Seq. Order:	24
Data Storage Type:	VARCHAR2
Max Length:	12
Required:	No
Primary Key:	No
Status:	Active
Description:	The Oracle username of the individual who entered the new record.
General Data Type:	VARCHAR2

DOC

CC ID: 341159

Seq. Order:	25
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).
General Data Type:	DATE

UOC

CC ID: 341160

Seq. Order:	26
Data Storage Type:	VARCHAR2
Max Length:	12
Required:	No
Primary Key:	No
Status:	Active
Description:	The Oracle username of the individual who changed the current record.
General Data Type:	VARCHAR2

WEB_DOE

CC ID: 341161

Seq. Order:	27
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date when record was inserted into Oracle by the web application. Date format (DD-MON-YYYY HH24:MI:SS).
General Data Type:	DATE

WEB_UOE

CC ID: 341162

Seq. Order:	28
Data Storage Type:	VARCHAR2
Max Length:	12
Required:	No
Primary Key:	No
Status:	Active
Description:	The username of the individual who entered the new record using the web application.
General Data Type:	VARCHAR2

WEB_DOC

CC ID: 341163

Seq. Order:	29
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date when the current record was updated or changed by the web application. Date format (DD-MON-YYYY HH:MI:SS).
General Data Type:	DATE

WEB_UOC

CC ID: 341164

Seq. Order:	30
Data Storage Type:	VARCHAR2
Max Length:	12
Required:	No
Primary Key:	No
Status:	Active
Description:	The username of the individual who changed the current record using the web application.
General Data Type:	VARCHAR2

Catalog Details

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