7122 TBF_RELEASES_V Entity Published / External 5453 Cooperative Tagging Center (CTC) Data Set Completed CTS.TBF_RELEASES_V contains informat on releases by TBF. Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT CTS.TBF_RELEASES_V contains informat on releases by TBF. 1 ANIMAL_ID NUMBER 22 Yes No 10 0 Active Unique identifier for each animal NUMBER 2 SPECIES_ID VARCHAR2 3 Yes No Active Species Code (used in MIA Tagging System) VARCHAR2 3 SEX VARCHAR2 1 No No Active Code to Indicate Sex Of Animal VARCHAR2 4 ID NUMBER 22 Yes No 38 Active A unique identifier for each interaction. NUMBER 5 TAG_ID VARCHAR2 8 Yes No Active Initial tag number applied to an animal. It consists of a 2 or 3 letter prefix and a 5 or 6 digit number. VARCHAR2 6 TAG_DATE DATE 7 Yes No Active Date animal was released or recaptured. DATE 7 PRIOR_TAG VARCHAR2 8 No No Active Any previous tag that may have been on the animal. VARCHAR2 8 INTERACTION_ORDER NUMBER 22 Yes No 2 0 Active Number denoting the order of the interaction. NUMBER 9 LENGTH NUMBER 22 No No 4 0 Active Length of animal tagged based on the lengthunit, lengthtype, and lengthdet. NUMBER 10 LENGTHUNIT VARCHAR2 2 No No Active Length measurement used: (IN) inches, (FT) feet, (MM) millimeters, (M ) meters, (UN) unknown, (CM) centimeters VARCHAR2 11 LENGTHTYPE VARCHAR2 1 No No Active Type of length measurement:(E)ye fork, (F)ork length, (L)ower jaw fork length, (S)tandard length, (T)otal length, (U)nknown length VARCHAR2 12 LENGTHDET VARCHAR2 1 No No Active Method of determining length: (E)stimated, (M)easured, (U)nknown VARCHAR2 13 WEIGHT NUMBER 22 No No 6 2 Active Weight of an animal tagged, based upon weightunit, weighttype and weightdet. NUMBER 14 WEIGHTUNIT VARCHAR2 2 No No Active Weight measurement used: (OZ) ounces, (LB) pounds, (GM) grams, (KG) Kilograms, (UN) Unknown VARCHAR2 15 WEIGHTTYPE VARCHAR2 1 No No Active Weight measurement type: (R)ound, (D)ressed, (U)nknown VARCHAR2 16 WEIGHTDET VARCHAR2 1 No No Active Method of determining weight: (E)stimated, (M)easured, (U)nknown. VARCHAR2 17 LATITUDE NUMBER 22 No No 30 16 Active Numeric value for the latitude of the tagging location. NUMBER 18 LONGITUDE NUMBER 22 No No 30 16 Active Numeric value the the longitude of the tagging location. NUMBER 19 LOCATION_NAME VARCHAR2 255 No No Active Text string describing the location where the animal was caught. VARCHAR2 20 GEAR_ID VARCHAR2 3 No No Active Code for gear used to catch the animal. VARCHAR2 21 BAIT_TYPE VARCHAR2 1 No No Active Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown VARCHAR2 22 FIGHTHRS NUMBER 22 No No 3 1 Active The number of hours spent fighting the fish before it was tagged. NUMBER 23 FIGHTMINS NUMBER 22 No No 3 1 Active The minutes part of the time spent fighting the fish before it was tagged. NUMBER 24 CAPTAIN_AGENCY_ID VARCHAR2 3 No No Active The agency code for the captain. VARCHAR2 25 CAPTAIN_ID NUMBER 22 No No 6 0 Active Unique numeric code assigned to an individual captain. Must be greater than zero or -99999. NUMBER 26 ANGLER_AGENCY_ID VARCHAR2 3 No No Active The agency code for the angler. VARCHAR2 27 ANGLER_ID NUMBER 22 No No 6 0 Active Unique identifier for each person in the database. NUMBER 28 VESSEL_AGENCY_ID VARCHAR2 3 No No Active The agency code for the vessel. VARCHAR2 29 VESSEL_ID NUMBER 22 No No 6 0 Active Agency supplied code identifying the vessel involved in the release or recapture of the animal. NUMBER gov.noaa.nmfs.inport:7122 Lee Weinberger 2008-02-22T12:11:17 SysAdmin InPortAdmin 2022-08-09T17:11:02 2021-05-05 Southeast Fisheries Science Center SEFSC 75 Virginia Beach Drive Miami FL 33149 USA (305)361-5761 www.sefsc.noaa.gov 8:00 a.m. - 4:30 p.m. EST 1001 Public No 2021-05-05 1 Year 2022-05-05