7046 CTS_INTERACTIONS Entity Published / External 5453 Cooperative Tagging Center (CTC) Data Set Completed Table Of All Tagging Interactions Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table Of All Tagging Interactions 1 ANIMAL_ID NUMBER 22 Yes No 10 0 Active Foreign Key to Animals Table NUMBER 2 AGENCY_ID VARCHAR2 3 Yes No Active Identifies Agency/Organization That Issued The Tag VARCHAR2 3 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 4 EVENT_ID NUMBER 22 Yes No 2 0 Active A code indicating (1) release or (2) recapture. NUMBER 5 TAG_DATE DATE 7 Yes No Active Date animal was released or recaptured. DATE 6 NEXT_TAG_AGENCY_ID VARCHAR2 3 No No Active Indetifies Agency That Supplied The Next_tag_id for the animal VARCHAR2 7 NEXT_TAG_ID VARCHAR2 8 No No Active Additional tag applied to another animal. Used if two or more tags are applied at the same time. VARCHAR2 8 INTERACTION_ORDER NUMBER 22 Yes No 2 0 Active Number denoting which tag on a multi-tagged animal. 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 Latitufe of location where Tagging operation was done NUMBER 18 LONGITUDE NUMBER 22 No No 30 16 Active Longitude of location where Tagging operation was done NUMBER 19 STAT_ZONE_ID NUMBER 22 No No 4 1 Active Statistical Zone Code where the release occurred. Gulf of Mexico 1.0 - 40.9, Caribbean 41.0 -75.0, Atlantic 630.0 - 751.0 NUMBER 20 COUNTRY_ID VARCHAR2 2 No No Active FIPS territorial Country Code where release/recapture occurred. VARCHAR2 21 STATE_ID VARCHAR2 2 No No Active U.S. state code if Country is US. VARCHAR2 22 WATER_BODY_ID NUMBER 22 No No 6 3 Active Statistical Zone Code for an in shore bay, river or water body. NUMBER 23 PLACE_ID VARCHAR2 3 No No Active Code identifying an unusual place where TAG1 was found. VARCHAR2 24 GEAR_ID VARCHAR2 3 No No Active Code for gear used to catch the animal. VARCHAR2 25 BAIT_TYPE VARCHAR2 1 No No Active Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown VARCHAR2 26 METHOD_ID NUMBER 22 No No 6 0 Active Code identifying a record in CTS_METHODS that contains the description of the methodology used in tagging this animal. NUMBER 27 SAMPLE_ID NUMBER 22 No No 6 0 Active Code identifying a record in CTS_SAMPLES describing this sample. NUMBER 28 CAPTAIN_AGENCY VARCHAR2 3 No No Active Identifies Agency Associated With Captain_id VARCHAR2 29 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 30 TAGGER_INITIALS VARCHAR2 3 No No Active Initials of person attaching or removing a tag. 3 characters are required. Use X for any missing characters. VARCHAR2 31 TAGGER_TYPE VARCHAR2 1 No No Active Classification of the person who releases or recaptures an animal. (C)ommercial fishermen, (N)mfs worker, (R)ecreational fisherman, (S)cientist, (U)nknown or missing. VARCHAR2 32 TAGGER_AFFILIATION VARCHAR2 3 No No Active Code for the agency the tagging is affiliated with. VARCHAR2 33 VESSEL_AGENCY VARCHAR2 3 No No Active Indentifies Agency That indicated vesseld code VARCHAR2 34 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 35 PHYSICAL_DATA_ID NUMBER 22 No No 6 0 Active Code to identify a record in CTS_Environ describing the conditions at the release/recapture site. NUMBER 36 NOTES NUMBER 22 No No 3 0 Active Note code for the first message associated with this record. NUMBER 37 FIGHTHRS NUMBER 22 No No 2 0 Active The number of hours spent fighting the fish before it was tagged. NUMBER 38 FIGHTMINS NUMBER 22 No No 2 0 Active The minutes part of the time spent fighting the fish before it was tagged. NUMBER 39 ANGLER_AGENCY_ID VARCHAR2 3 No No Active Identifies Agency Associated With Angler_id VARCHAR2 40 ANGLER_ID NUMBER 22 No No 6 0 Active Number Of Angler That Did The tagging NUMBER 41 GEOM SDO_GEOMETRY 1 No No Active GIS component Of record SDO_GEOMETRY 42 ID NUMBER 22 Yes Yes 38 Active Sequential Key NUMBER 43 DATE_ENTERED DATE 7 No No Active Date Record was entered into the system DATE gov.noaa.nmfs.inport:7046 Lee Weinberger 2008-02-22T12:10:58 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