Table: MRMVRELRECAP_01
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33879 | Updated: August 9, 2022 | Published / External
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
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 |