Metadata Rubric

100%

6 / 6

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

Table: MRSTOCKAREAS

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Stock areas

Description

Stock areas

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.
STOCKCD VARCHAR2	Stock area code.
STOCKID VARCHAR2	Abbreviated description of stock ares.
SPECIES_ITIS VARCHAR2	Itis species code, see support table MRSPECIES for descriptions.
STOCK_DESC VARCHAR2	Stock area description.
STOCK_AREA_DEF VARCHAR2	List of statistical areas in stock area (comma delimited list).
STOCK_AREA_QUERYSTR VARCHAR2	List of statistical areas in stock area (comma delimited list formatted for sql query).
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.

Data Attribute / Type

Description

FISHERY
VARCHAR2

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

STOCKCD
VARCHAR2

Stock area code.

STOCKID
VARCHAR2

Abbreviated description of stock ares.

SPECIES_ITIS
VARCHAR2

Itis species code, see support table MRSPECIES for descriptions.

STOCK_DESC
VARCHAR2

Stock area description.

STOCK_AREA_DEF
VARCHAR2

List of statistical areas in stock area (comma delimited list).

STOCK_AREA_QUERYSTR
VARCHAR2

List of statistical areas in stock area (comma delimited list formatted for sql query).

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.

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: MRSTOCKAREAS
Short Name:	MRSTOCKAREAS
Status:	Completed
Abstract:	Stock areas
Notes:	Loaded by batch 9111, 08-01-2016 12:11

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

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	STOCKCD	VARCHAR2	Stock area code.
100	STOCKID	VARCHAR2	Abbreviated description of stock ares.
100	SPECIES_ITIS	VARCHAR2	Itis species code, see support table MRSPECIES for descriptions.
100	STOCK_DESC	VARCHAR2	Stock area description.
100	STOCK_AREA_DEF	VARCHAR2	List of statistical areas in stock area (comma delimited list).
100	STOCK_AREA_QUERYSTR	VARCHAR2	List of statistical areas in stock area (comma delimited list formatted for sql query).
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.

Name

Type

Description

100

FISHERY

VARCHAR2

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

100

STOCKCD

VARCHAR2

Stock area code.

100

STOCKID

VARCHAR2

Abbreviated description of stock ares.

100

SPECIES_ITIS

VARCHAR2

Itis species code, see support table MRSPECIES for descriptions.

100

STOCK_DESC

VARCHAR2

Stock area description.

100

STOCK_AREA_DEF

VARCHAR2

List of statistical areas in stock area (comma delimited list).

100

STOCK_AREA_QUERYSTR

VARCHAR2

List of statistical areas in stock area (comma delimited list formatted for sql query).

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.

Attribute Details

FISHERY

CC ID: 341374

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

STOCKCD

CC ID: 341377

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	Yes
Primary Key:	Yes
Status:	Active
Description:	Stock area code.
General Data Type:	VARCHAR2

STOCKID

CC ID: 341378

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Abbreviated description of stock ares.
General Data Type:	VARCHAR2

SPECIES_ITIS

CC ID: 341379

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

STOCK_DESC

CC ID: 341380

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	40
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Stock area description.
General Data Type:	VARCHAR2

STOCK_AREA_DEF

CC ID: 341381

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	60
Required:	No
Primary Key:	No
Status:	Active
Description:	List of statistical areas in stock area (comma delimited list).
General Data Type:	VARCHAR2

STOCK_AREA_QUERYSTR

CC ID: 341382

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	240
Required:	No
Primary Key:	No
Status:	Active
Description:	List of statistical areas in stock area (comma delimited list formatted for sql query).
General Data Type:	VARCHAR2

DOE

CC ID: 341383

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

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

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

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

Catalog Item ID:	33912
GUID:	gov.noaa.nmfs.inport:33912
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: MRSTOCKAREAS

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

FISHERY

STOCKCD

STOCKID

SPECIES_ITIS

STOCK_DESC

STOCK_AREA_DEF

STOCK_AREA_QUERYSTR

DOE

UOE

DOC

UOC

Catalog Details