Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Release and Recapture Events for Yellowtail Fishery

Description

Release and Recapture Events for Yellowtail Fishery

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.
ANIMALID
VARCHAR2
Animal identification code, animal id will be a concatenation of fishery, original tag type, color, number, and suffix.
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_COLOR
VARCHAR2
Color of tag, see support table MRTAGCOLORS for descriptions.
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.
REL_DATE
VARCHAR2
Release date.
REL_AREA
VARCHAR2
Recapture statistical area calculated from latitude and longitude.
REL_DECLAT
VARCHAR2
Release latitude in decimal degrees. (redacted)
REL_DECLON
VARCHAR2
Release longitude in decimal degrees. (redacted)
REL_TIME
VARCHAR2
Time of release.
REL_LENGTH_CM
NUMBER
Release length in centimeters.
REL_SEX
VARCHAR2
Release sex Sex ( 0 = male, 1 = female).
REL_SCALES
VARCHAR2
Scales taken at release.
REL_OBSERVATIONS
VARCHAR2
Release observations.
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.
RECAP_EVENT
NUMBER
Recapture event type, see support table MREVENTTYPES for descriptions.
RECAP_DATE
VARCHAR2
Recapture event date.
RECAP_DATEQUAL
VARCHAR2
Recapture event date quality, see support table MRDATE_QUALITY for descriptions.
RECAP_NAME
VARCHAR2
Recapture contact name. (redacted)
RECAP_HULLNUM
VARCHAR2
Recapture hull number. (redacted)
RECAP_VESSEL
VARCHAR2
Recapture vessel name. (redacted)
RECAP_INDUSTRY
VARCHAR2
Industry of contact at time of recapture.
RECAP_GEAR
VARCHAR2
Recapture gear code, see support table MRGEARS for descriptions.
RECAP_REPORTED
VARCHAR2
Recapture reported.
RECAP_LENGTH_CM
NUMBER
Recapture length in centimeters.
RECAP_LENQUAL
VARCHAR2
Recapture length quality, see support table MRLENGTH_QUALITY for descriptions.
RECAP_WEIGHT_KG
NUMBER
Recapture weight in kilograms.
RECAP_WGTQUAL
VARCHAR2
Recapture weight quality, see support table MRWEIGHT_QUALITY for descriptions.
RECAP_DEPTH_FM
NUMBER
Depth in Fathoms.
RECAP_DECLAT
VARCHAR2
Recapture latitude in decimal degrees. (redacted)
RECAP_DECLON
VARCHAR2
Recapture event decimal longitude. (redacted)
RECAP_LOCQUAL
VARCHAR2
Recapture location quality, see MRLOC_QUALITY for descriptions.
RECAP_AREA
VARCHAR2
Recapture event statistical area.
RECAP_DAYSFREE
NUMBER
Recapture event days free.
RECAP_DISTTRAVEL
NUMBER
Recapture event distance traveled.

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: MRMVRELRECAP_01
Short Name: MRMVRELRECAP_01
Status: Completed
Abstract:

Release and Recapture Events for Yellowtail Fishery

Notes:

Loaded by batch 9110, 08-01-2016 12:11

Entity Information

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

Release and Recapture Events for Yellowtail Fishery

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
FISHERY VARCHAR2 Fishery Code, a two character fishery identification code. See support table MRFISHERY for codes and descriptions.
100
ANIMALID VARCHAR2 Animal identification code, animal id will be a concatenation of fishery, original tag type, color, number, and suffix.
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_COLOR VARCHAR2 Color of tag, see support table MRTAGCOLORS for descriptions.
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
REL_DATE VARCHAR2 Release date.
100
REL_AREA VARCHAR2 Recapture statistical area calculated from latitude and longitude.
100
REL_DECLAT VARCHAR2 Release latitude in decimal degrees. (redacted)
100
REL_DECLON VARCHAR2 Release longitude in decimal degrees. (redacted)
100
REL_TIME VARCHAR2 Time of release.
100
REL_LENGTH_CM NUMBER Release length in centimeters.
100
REL_SEX VARCHAR2 Release sex Sex ( 0 = male, 1 = female).
100
REL_SCALES VARCHAR2 Scales taken at release.
100
REL_OBSERVATIONS VARCHAR2 Release observations.
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
RECAP_EVENT NUMBER Recapture event type, see support table MREVENTTYPES for descriptions.
100
RECAP_DATE VARCHAR2 Recapture event date.
100
RECAP_DATEQUAL VARCHAR2 Recapture event date quality, see support table MRDATE_QUALITY for descriptions.
100
RECAP_NAME VARCHAR2 Recapture contact name. (redacted)
100
RECAP_HULLNUM VARCHAR2 Recapture hull number. (redacted)
100
RECAP_VESSEL VARCHAR2 Recapture vessel name. (redacted)
100
RECAP_INDUSTRY VARCHAR2 Industry of contact at time of recapture.
100
RECAP_GEAR VARCHAR2 Recapture gear code, see support table MRGEARS for descriptions.
100
RECAP_REPORTED VARCHAR2 Recapture reported.
100
RECAP_LENGTH_CM NUMBER Recapture length in centimeters.
100
RECAP_LENQUAL VARCHAR2 Recapture length quality, see support table MRLENGTH_QUALITY for descriptions.
100
RECAP_WEIGHT_KG NUMBER Recapture weight in kilograms.
100
RECAP_WGTQUAL VARCHAR2 Recapture weight quality, see support table MRWEIGHT_QUALITY for descriptions.
100
RECAP_DEPTH_FM NUMBER Depth in Fathoms.
100
RECAP_DECLAT VARCHAR2 Recapture latitude in decimal degrees. (redacted)
100
RECAP_DECLON VARCHAR2 Recapture event decimal longitude. (redacted)
100
RECAP_LOCQUAL VARCHAR2 Recapture location quality, see MRLOC_QUALITY for descriptions.
100
RECAP_AREA VARCHAR2 Recapture event statistical area.
100
RECAP_DAYSFREE NUMBER Recapture event days free.
100
RECAP_DISTTRAVEL NUMBER Recapture event distance traveled.

Attribute Details

FISHERY

CC ID: 340930
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

ANIMALID

CC ID: 340941
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 14
Required: No
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

TAG_TYPE

CC ID: 340952
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
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_COLOR

CC ID: 340961
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Color of tag, see support table MRTAGCOLORS for descriptions.

General Data Type: VARCHAR2

TAG_NUMBER

CC ID: 340962
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

Tag identification number.

General Data Type: VARCHAR2

TAG_SUFFIX

CC ID: 340963
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
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

REL_DATE

CC ID: 340964
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Release date.

General Data Type: VARCHAR2

REL_AREA

CC ID: 340965
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Recapture statistical area calculated from latitude and longitude.

General Data Type: VARCHAR2

REL_DECLAT

CC ID: 340966
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 9
Required: No
Primary Key: No
Status: Active
Description:

Release latitude in decimal degrees. (redacted)

General Data Type: VARCHAR2

REL_DECLON

CC ID: 340931
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Release longitude in decimal degrees. (redacted)

General Data Type: VARCHAR2

REL_TIME

CC ID: 340932
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Time of release.

General Data Type: VARCHAR2

REL_LENGTH_CM

CC ID: 340933
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

Release length in centimeters.

General Data Type: NUMBER

REL_SEX

CC ID: 340934
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Release sex Sex ( 0 = male, 1 = female).

General Data Type: VARCHAR2

REL_SCALES

CC ID: 340935
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Scales taken at release.

General Data Type: VARCHAR2

REL_OBSERVATIONS

CC ID: 340936
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 200
Required: No
Primary Key: No
Status: Active
Description:

Release observations.

General Data Type: VARCHAR2

TRIPID

CC ID: 340937
Seq. Order: 16
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: 340938
Seq. Order: 17
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

RECAP_EVENT

CC ID: 340939
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Recapture event type, see support table MREVENTTYPES for descriptions.

General Data Type: NUMBER

RECAP_DATE

CC ID: 340940
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Recapture event date.

General Data Type: VARCHAR2

RECAP_DATEQUAL

CC ID: 340942
Seq. Order: 20
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture event date quality, see support table MRDATE_QUALITY for descriptions.

General Data Type: VARCHAR2

RECAP_NAME

CC ID: 340943
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 71
Required: No
Primary Key: No
Status: Active
Description:

Recapture contact name. (redacted)

General Data Type: VARCHAR2

RECAP_HULLNUM

CC ID: 340944
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Recapture hull number. (redacted)

General Data Type: VARCHAR2

RECAP_VESSEL

CC ID: 340945
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Recapture vessel name. (redacted)

General Data Type: VARCHAR2

RECAP_INDUSTRY

CC ID: 340946
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Industry of contact at time of recapture.

General Data Type: VARCHAR2

RECAP_GEAR

CC ID: 340947
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture gear code, see support table MRGEARS for descriptions.

General Data Type: VARCHAR2

RECAP_REPORTED

CC ID: 340948
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture reported.

General Data Type: VARCHAR2

RECAP_LENGTH_CM

CC ID: 340949
Seq. Order: 27
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

Recapture length in centimeters.

General Data Type: NUMBER

RECAP_LENQUAL

CC ID: 340950
Seq. Order: 28
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture length quality, see support table MRLENGTH_QUALITY for descriptions.

General Data Type: VARCHAR2

RECAP_WEIGHT_KG

CC ID: 340951
Seq. Order: 29
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

Recapture weight in kilograms.

General Data Type: NUMBER

RECAP_WGTQUAL

CC ID: 340953
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture weight quality, see support table MRWEIGHT_QUALITY for descriptions.

General Data Type: VARCHAR2

RECAP_DEPTH_FM

CC ID: 340954
Seq. Order: 31
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Depth in Fathoms.

General Data Type: NUMBER

RECAP_DECLAT

CC ID: 340955
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 9
Required: No
Primary Key: No
Status: Active
Description:

Recapture latitude in decimal degrees. (redacted)

General Data Type: VARCHAR2

RECAP_DECLON

CC ID: 340956
Seq. Order: 33
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Recapture event decimal longitude. (redacted)

General Data Type: VARCHAR2

RECAP_LOCQUAL

CC ID: 340957
Seq. Order: 34
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture location quality, see MRLOC_QUALITY for descriptions.

General Data Type: VARCHAR2

RECAP_AREA

CC ID: 340958
Seq. Order: 35
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Recapture event statistical area.

General Data Type: VARCHAR2

RECAP_DAYSFREE

CC ID: 340959
Seq. Order: 36
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Recapture event days free.

General Data Type: NUMBER

RECAP_DISTTRAVEL

CC ID: 340960
Seq. Order: 37
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Recapture event distance traveled.

General Data Type: NUMBER

Catalog Details

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