Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
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 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Haul or Tow Information (yellowtail)

Description

Haul or Tow Information (yellowtail)

Entity Information

Entity Type
Data Table

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

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

Rubric Score Primary Key? Name Type Description
100
 Primary Key FISHERY VARCHAR2 Fishery Code, a two character fishery identification code. See support table MRFISHERY for codes and descriptions.
100
 Primary Key TRIPID VARCHAR2 Trip identification code, for yellowtail tagging, trip id consists of YT[year]-[sequential number of trip within year].
100
 Primary Key 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