Metadata Rubric

100%

6 / 6

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

Table: MRMVRELRECAP_AREAS01

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Release and Recapture Statistical Areas for Yellowtail Fishery

Description

Release and Recapture Statistical Areas for Yellowtail Fishery

Entity Type
Data Table

Data Attribute / Type	Description
TAG_TYPE VARCHAR2	Style of tag, see support table MRTAGTYPES for descriptions. (Note: For yellowtail, data storage tags were migrated to tag type 40 in MRDBS, before migration, they were tag type 03)
TAG_NUMBER VARCHAR2	Tag identification number.
TAG_SUFFIX VARCHAR2	Tag suffix, for yellowtail, suffix A or B were used for transcription errors when recording tag or tag was removed from a poor condition fish and reused.
ANIMALID VARCHAR2	Animal identification code, animal id will be a concatenation of fishery, original tag type, color, number, and suffix.
REL_EVENTNUM NUMBER	Release event number.
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.
REL_ENTSTATAREA VARCHAR2	Release statistical area as entered from captain's log.
REL_CALCSTATAREA VARCHAR2	Release statistical area calculated from latitude and longitude.
REC_EVENTNUM NUMBER	Recapture event number.
REC_STATAREA VARCHAR2	Recapture statistical area from latitude and longitude.

Data Attribute / Type

Description

TAG_TYPE
VARCHAR2

Style of tag, see support table MRTAGTYPES for descriptions. (Note: For yellowtail, data storage tags were migrated to tag type 40 in MRDBS, before migration, they were tag type 03)

TAG_NUMBER
VARCHAR2

Tag identification number.

TAG_SUFFIX
VARCHAR2

Tag suffix, for yellowtail, suffix A or B were used for transcription errors when recording tag or tag was removed from a poor condition fish and reused.

ANIMALID
VARCHAR2

Animal identification code, animal id will be a concatenation of fishery, original tag type, color, number, and suffix.

REL_EVENTNUM
NUMBER

Release event number.

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.

REL_ENTSTATAREA
VARCHAR2

Release statistical area as entered from captain's log.

REL_CALCSTATAREA
VARCHAR2

Release statistical area calculated from latitude and longitude.

REC_EVENTNUM
NUMBER

Recapture event number.

REC_STATAREA
VARCHAR2

Recapture statistical area from latitude and longitude.

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: MRMVRELRECAP_AREAS01
Short Name:	MRMVRELRECAP_AREAS01
Status:	Completed
Abstract:	Release and Recapture Statistical Areas for Yellowtail Fishery
Notes:	Loaded by batch 9110, 08-01-2016 12:11

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	MRDBS
Description:	Release and Recapture Statistical Areas for Yellowtail Fishery

Attribute Summary

	Name	Type	Description
100	TAG_TYPE	VARCHAR2	Style of tag, see support table MRTAGTYPES for descriptions. (Note: For yellowtail, data storage tags were migrated to tag type 40 in MRDBS, before migration, they were tag type 03)
100	TAG_NUMBER	VARCHAR2	Tag identification number.
100	TAG_SUFFIX	VARCHAR2	Tag suffix, for yellowtail, suffix A or B were used for transcription errors when recording tag or tag was removed from a poor condition fish and reused.
100	ANIMALID	VARCHAR2	Animal identification code, animal id will be a concatenation of fishery, original tag type, color, number, and suffix.
100	REL_EVENTNUM	NUMBER	Release event number.
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	REL_ENTSTATAREA	VARCHAR2	Release statistical area as entered from captain's log.
100	REL_CALCSTATAREA	VARCHAR2	Release statistical area calculated from latitude and longitude.
100	REC_EVENTNUM	NUMBER	Recapture event number.
100	REC_STATAREA	VARCHAR2	Recapture statistical area from latitude and longitude.

Name

Type

Description

100

TAG_TYPE

VARCHAR2

Style of tag, see support table MRTAGTYPES for descriptions. (Note: For yellowtail, data storage tags were migrated to tag type 40 in MRDBS, before migration, they were tag type 03)

100

TAG_NUMBER

VARCHAR2

Tag identification number.

100

TAG_SUFFIX

VARCHAR2

Tag suffix, for yellowtail, suffix A or B were used for transcription errors when recording tag or tag was removed from a poor condition fish and reused.

100

ANIMALID

VARCHAR2

Animal identification code, animal id will be a concatenation of fishery, original tag type, color, number, and suffix.

100

REL_EVENTNUM

NUMBER

Release event number.

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

REL_ENTSTATAREA

VARCHAR2

Release statistical area as entered from captain's log.

100

REL_CALCSTATAREA

VARCHAR2

Release statistical area calculated from latitude and longitude.

100

REC_EVENTNUM

NUMBER

Recapture event number.

100

REC_STATAREA

VARCHAR2

Recapture statistical area from latitude and longitude.

Attribute Details

TAG_TYPE

CC ID: 340967

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Style of tag, see support table MRTAGTYPES for descriptions. (Note: For yellowtail, data storage tags were migrated to tag type 40 in MRDBS, before migration, they were tag type 03)
General Data Type:	VARCHAR2

TAG_NUMBER

CC ID: 340970

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Tag identification number.
General Data Type:	VARCHAR2

TAG_SUFFIX

CC ID: 340971

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Tag suffix, for yellowtail, suffix A or B were used for transcription errors when recording tag or tag was removed from a poor condition fish and reused.
General Data Type:	VARCHAR2

ANIMALID

CC ID: 340972

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	14
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Animal identification code, animal id will be a concatenation of fishery, original tag type, color, number, and suffix.
General Data Type:	VARCHAR2

REL_EVENTNUM

CC ID: 340973

Seq. Order:	5
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Release event number.
General Data Type:	NUMBER

TRIPID

CC ID: 340974

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	No
Primary Key:	No
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

HAULNUM

CC ID: 340975

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Ordinal number of the haul within the trip, set number for shark cruises.
General Data Type:	VARCHAR2

REL_ENTSTATAREA

CC ID: 340976

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Release statistical area as entered from captain's log.
General Data Type:	VARCHAR2

REL_CALCSTATAREA

CC ID: 340977

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Release statistical area calculated from latitude and longitude.
General Data Type:	VARCHAR2

REC_EVENTNUM

CC ID: 340968

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Recapture event number.
General Data Type:	NUMBER

REC_STATAREA

CC ID: 340969

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Recapture statistical area from latitude and longitude.
General Data Type:	VARCHAR2

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

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

TAG_TYPE

TAG_NUMBER

TAG_SUFFIX

ANIMALID

REL_EVENTNUM

TRIPID

HAULNUM

REL_ENTSTATAREA

REL_CALCSTATAREA

REC_EVENTNUM

REC_STATAREA

Catalog Details