Table: MRMVRELRECAP_01
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33879 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Release and Recapture Events for Yellowtail Fishery
DescriptionRelease 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
![]() |
![]() |
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |