Metadata Rubric

100%

6 / 6

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

Table: MRBYCATCH

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Bycatch

Description

Bycatch

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.
SPECIES_ITIS VARCHAR2	Itis species code, see support table MRSPECIES for descriptions.
HAILWGT NUMBER	Estimated hail weight.
HAILWGTUOM VARCHAR2	Unit of measure used for haul weight (LB, KG).
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.

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.

SPECIES_ITIS
VARCHAR2

Itis species code, see support table MRSPECIES for descriptions.

HAILWGT
NUMBER

Estimated hail weight.

HAILWGTUOM
VARCHAR2

Unit of measure used for haul weight (LB, KG).

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.

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: MRBYCATCH
Short Name:	MRBYCATCH
Status:	Completed
Abstract:	Bycatch
Notes:	Loaded by batch 9110, 08-01-2016 12:11

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	MRDBS
Description:	Bycatch

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	SPECIES_ITIS	VARCHAR2	Itis species code, see support table MRSPECIES for descriptions.
100	HAILWGT	NUMBER	Estimated hail weight.
100	HAILWGTUOM	VARCHAR2	Unit of measure used for haul weight (LB, KG).
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

SPECIES_ITIS

VARCHAR2

Itis species code, see support table MRSPECIES for descriptions.

100

HAILWGT

NUMBER

Estimated hail weight.

100

HAILWGTUOM

VARCHAR2

Unit of measure used for haul weight (LB, KG).

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

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

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

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

SPECIES_ITIS

CC ID: 340865

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	11
Required:	Yes
Primary Key:	Yes
Status:	Active
Description:	Itis species code, see support table MRSPECIES for descriptions.
General Data Type:	VARCHAR2
Foreign Key Relations:	MRDBS.MRSPECIES

HAILWGT

CC ID: 340871

Seq. Order:	5
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	8
Scale:	1
Status:	Active
Description:	Estimated hail weight.
General Data Type:	NUMBER

HAILWGTUOM

CC ID: 340872

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Unit of measure used for haul weight (LB, KG).
General Data Type:	VARCHAR2

DOE

CC ID: 340873

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

Seq. Order:	8
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: 340875

Seq. Order:	9
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: 340866

Seq. Order:	10
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: 340867

Seq. Order:	11
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: 340868

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	1
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: 340869

Seq. Order:	13
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: 340870

Seq. Order:	14
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 Item ID:	33877
GUID:	gov.noaa.nmfs.inport:33877
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

Table: MRBYCATCH

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

FISHERY

TRIPID

HAULNUM

SPECIES_ITIS

HAILWGT

HAILWGTUOM

DOE

UOE

DOC

UOC

WEB_DOE

WEB_UOE

WEB_DOC

WEB_UOC

Catalog Details