33884
Table: MRYTHAUL
MRYTHAUL
Entity
Published / External
27387
Yellowtail Tagging Data (MRDBS)
Data Set
Completed
Haul or Tow Information (yellowtail)
Loaded by batch 9110, 08-01-2016 12:11
Data Table
Yes
MRDBS
Haul or Tow Information (yellowtail)
1
FISHERY
VARCHAR2
2
Yes
Yes
Active
Fishery Code, a two character fishery identification code. See support table MRFISHERY for codes and descriptions.
VARCHAR2
MRDBS.MRHAUL
2
TRIPID
VARCHAR2
8
Yes
Yes
Active
Trip identification code, for yellowtail tagging, trip id consists of YT[year]-[sequential number of trip within year].
VARCHAR2
MRDBS.MRHAUL
3
HAULNUM
VARCHAR2
4
Yes
Yes
Active
Ordinal number of the haul within the trip, set number for shark cruises.
VARCHAR2
MRDBS.MRHAUL
4
ESTCATCHNUM
NUMBER
22
No
No
8
0
Active
Number estimated total catch .
NUMBER
5
ESTCATCHWGT
NUMBER
22
No
No
8
0
Active
Weight estimated total catch .
NUMBER
6
ESTCATCHWGTUOM
VARCHAR2
3
No
No
Active
Unit of measure for estimated catch weight.
VARCHAR2
7
ESTYTNUM
NUMBER
22
No
No
8
0
Active
Number estimated yellowtail catch.
NUMBER
8
ESTYTWGT
NUMBER
22
No
No
8
0
Active
Weight estimated yellowtail catch.
NUMBER
9
ESTYTWGTUOM
VARCHAR2
3
No
No
Active
Unit of measure for estimated yellowtail weight.
VARCHAR2
10
YTTAGGEDNUM
NUMBER
22
No
No
4
0
Active
Number yellowtail tagged.
NUMBER
11
DISCALIVE_SUBLGL
NUMBER
22
No
No
4
0
Active
Number discarded alive (sub-legal).
NUMBER
12
DISCALIVE_OTHER
NUMBER
22
No
No
4
0
Active
Number discarded alive for poor condition or total number discarded because sub-legal not counted.
NUMBER
13
DISCDEADNUM
NUMBER
22
No
No
4
0
Active
Number discarded dead.
NUMBER
14
DISCNOTPRNUM
NUMBER
22
No
No
4
0
Active
Number discarded not processed.
NUMBER
15
DISCALIVEWGT
NUMBER
22
No
No
9
3
Active
Weight discarded alive.
NUMBER
16
DISCALIVEUOM
VARCHAR2
3
No
No
Active
Unit of measure for weight discarded alive.
VARCHAR2
17
DISCDEADWGT
NUMBER
22
No
No
9
3
Active
Weight discarded dead.
NUMBER
18
DISCDEADUOM
VARCHAR2
3
No
No
Active
Unit of measure for weight discarded dead.
VARCHAR2
19
DISCNOTPRWGT
NUMBER
22
No
No
9
3
Active
Weight discarded not processed.
NUMBER
20
DISCNOTPRUOM
VARCHAR2
3
No
No
Active
Unit of measure for weight discarded not processes.
VARCHAR2
21
TAGGERCOMMENTS
VARCHAR2
200
No
No
Active
Comments.
VARCHAR2
22
LOGHAULNUM
VARCHAR2
4
No
No
Active
Original tow number used on paper logs (used for 2003, 2004 yt trips).
VARCHAR2
23
DOE
DATE
7
No
No
Active
Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS).
DATE
24
UOE
VARCHAR2
12
No
No
Active
The Oracle username of the individual who entered the new record.
VARCHAR2
25
DOC
DATE
7
No
No
Active
Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).
DATE
26
UOC
VARCHAR2
12
No
No
Active
The Oracle username of the individual who changed the current record.
VARCHAR2
27
WEB_DOE
DATE
7
No
No
Active
Date when record was inserted into Oracle by the web application. Date format (DD-MON-YYYY HH24:MI:SS).
DATE
28
WEB_UOE
VARCHAR2
12
No
No
Active
The username of the individual who entered the new record using the web application.
VARCHAR2
29
WEB_DOC
DATE
7
No
No
Active
Date when the current record was updated or changed by the web application. Date format (DD-MON-YYYY HH:MI:SS).
DATE
30
WEB_UOC
VARCHAR2
12
No
No
Active
The username of the individual who changed the current record using the web application.
VARCHAR2
gov.noaa.nmfs.inport:33884
Patricia Jones
2016-08-01T12:11:30
SysAdmin InPortAdmin
2022-08-09T17:11:14
2017-02-24
Northeast Fisheries Science Center
NEFSC
166 Water Street
Woods Hole
MA
02543-1026
USA
(508)495-2000
https://www.nefsc.noaa.gov
8:00 a.m. to 4:30 p.m. Monday - Friday
1001
Public
No
2017-02-24
1 Year
2018-02-24