33879 MRMVRELRECAP_01 Entity Published / External 27387 Yellowtail Tagging Data (MRDBS) Data Set Completed Release and Recapture Events for Yellowtail Fishery Loaded by batch 9110, 08-01-2016 12:11 Data Table Yes MRDBS Release and Recapture Events for Yellowtail Fishery 1 FISHERY VARCHAR2 2 No No Active Fishery Code, a two character fishery identification code. See support table MRFISHERY for codes and descriptions. VARCHAR2 2 ANIMALID VARCHAR2 14 No No Active Animal identification code, animal id will be a concatenation of fishery, original tag type, color, number, and suffix. VARCHAR2 3 TAG_TYPE VARCHAR2 2 No No Active 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) VARCHAR2 4 TAG_COLOR VARCHAR2 2 No No Active Color of tag, see support table MRTAGCOLORS for descriptions. VARCHAR2 5 TAG_NUMBER VARCHAR2 6 No No Active Tag identification number. VARCHAR2 6 TAG_SUFFIX VARCHAR2 1 No No Active 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. VARCHAR2 7 REL_DATE VARCHAR2 10 No No Active Release date. VARCHAR2 8 REL_AREA VARCHAR2 3 No No Active Recapture statistical area calculated from latitude and longitude. VARCHAR2 9 REL_DECLAT VARCHAR2 9 No No Active Release latitude in decimal degrees. (redacted) VARCHAR2 10 REL_DECLON VARCHAR2 10 No No Active Release longitude in decimal degrees. (redacted) VARCHAR2 11 REL_TIME VARCHAR2 5 No No Active Time of release. VARCHAR2 12 REL_LENGTH_CM NUMBER 22 No No 6 2 Active Release length in centimeters. NUMBER 13 REL_SEX VARCHAR2 1 No No Active Release sex Sex ( 0 = male, 1 = female). VARCHAR2 14 REL_SCALES VARCHAR2 5 No No Active Scales taken at release. VARCHAR2 15 REL_OBSERVATIONS VARCHAR2 200 No No Active Release observations. VARCHAR2 16 TRIPID VARCHAR2 8 No No Active Trip identification code, for yellowtail tagging, trip id consists of YT[year]-[sequential number of trip within year]. VARCHAR2 17 HAULNUM VARCHAR2 4 No No Active Ordinal number of the haul within the trip, set number for shark cruises. VARCHAR2 18 RECAP_EVENT NUMBER 22 No No 3 0 Active Recapture event type, see support table MREVENTTYPES for descriptions. NUMBER 19 RECAP_DATE VARCHAR2 10 No No Active Recapture event date. VARCHAR2 20 RECAP_DATEQUAL VARCHAR2 2 No No Active Recapture event date quality, see support table MRDATE_QUALITY for descriptions. VARCHAR2 21 RECAP_NAME VARCHAR2 71 No No Active Recapture contact name. (redacted) VARCHAR2 22 RECAP_HULLNUM VARCHAR2 10 No No Active Recapture hull number. (redacted) VARCHAR2 23 RECAP_VESSEL VARCHAR2 40 No No Active Recapture vessel name. (redacted) VARCHAR2 24 RECAP_INDUSTRY VARCHAR2 2 No No Active Industry of contact at time of recapture. VARCHAR2 25 RECAP_GEAR VARCHAR2 2 No No Active Recapture gear code, see support table MRGEARS for descriptions. VARCHAR2 26 RECAP_REPORTED VARCHAR2 2 No No Active Recapture reported. VARCHAR2 27 RECAP_LENGTH_CM NUMBER 22 No No 6 2 Active Recapture length in centimeters. NUMBER 28 RECAP_LENQUAL VARCHAR2 2 No No Active Recapture length quality, see support table MRLENGTH_QUALITY for descriptions. VARCHAR2 29 RECAP_WEIGHT_KG NUMBER 22 No No 6 2 Active Recapture weight in kilograms. NUMBER 30 RECAP_WGTQUAL VARCHAR2 2 No No Active Recapture weight quality, see support table MRWEIGHT_QUALITY for descriptions. VARCHAR2 31 RECAP_DEPTH_FM NUMBER 22 No No 38 Active Depth in Fathoms. NUMBER 32 RECAP_DECLAT VARCHAR2 9 No No Active Recapture latitude in decimal degrees. (redacted) VARCHAR2 33 RECAP_DECLON VARCHAR2 10 No No Active Recapture event decimal longitude. (redacted) VARCHAR2 34 RECAP_LOCQUAL VARCHAR2 2 No No Active Recapture location quality, see MRLOC_QUALITY for descriptions. VARCHAR2 35 RECAP_AREA VARCHAR2 3 No No Active Recapture event statistical area. VARCHAR2 36 RECAP_DAYSFREE NUMBER 22 No No 5 0 Active Recapture event days free. NUMBER 37 RECAP_DISTTRAVEL NUMBER 22 No No 5 0 Active Recapture event distance traveled. NUMBER gov.noaa.nmfs.inport:33879 Patricia Jones 2016-08-01T12:11:30 SysAdmin InPortAdmin 2022-08-09T17:11:14 2017-02-24 Northeast Fisheries Science Center NEFSC 166 Water Street Woods Hole MA 02543-1026 USA (508)495-2000 https://www.nefsc.noaa.gov 8:00 a.m. to 4:30 p.m. Monday - Friday 1001 Public No 2017-02-24 1 Year 2018-02-24