5453 Cooperative Tagging Data Data Set Published / External 1946 Cooperative Tagging System Project In Work The Cooperative Tagging Center (CTC) began as the Cooperative Game Fish Tagging Program (GTP) at Woods Hole Oceanographic Institute (WHOI) in 1954. The GTP was started by Dr. Frank J. Mather III with an initial focus on bluefin tuna. The program quickly expanded to include billfish in 1973 and became a joint effort between the National Marine Fisheries Service (NMFS) and WHOI. In 1980 the Miami Laboratory of the NMFSs Southeast Fisheries Science Center (SEFSC) took complete responsibility for the operation, funding, and maintenance of the GTP (CTC History). In 1992 the SEFSC changed the program name to the CTC due to an increase in tagging efforts for a wider variety of species, as well as an increase in tagging research needs and requests for tagging data. Constituents have tagged over 270,000 fish of nearly 80 different species, however, today the CTC focuses solely on the tagging of billfish and tuna in the Atlantic Ocean, Gulf of Mexico, and Caribbean Sea. The purpose of the data set is to examine movement patterns of highly migratorty fish species. The data set is also useful for estimating mortality rates and determining species longevity. The dataset is provided to The International Commission for the Conservation of Atlantic Tunas on a yearly basis and is used for species stock assessments. The majority of data is on highly migratory species such as billfish and tuna, however there is data on nearly 80 species Theme Fisheries-Independent Data Theme Tagging Theme Tuna Theme anglers Theme billfish Theme fishery-dependent Theme gear Theme marlin Theme swordfish Theme waterbody Temporal 1940-present Spatial Atlantic Ocean Spatial Caribbean Spatial Gulf Of Mexico Spatial mediterarean Spatial pacific Southeast Fisheries Science Center Miami FL USA Location Of The Main Office Of The South East Fisheries Science Center Data Set Database As Needed Table (digital) Entities May Be Oracle Tables and/or Oracle Views. N/A N/A N/A 7022 CHECKTRANMISSIONS Published / External Completed View Of information about depl;oyed archival tags Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT View Of information about depl;oyed archival tags 1 ARGOS_PTT_ID VARCHAR2 10 Yes No Active Link to ARGOS Table VARCHAR2 2 ARCHIVAL_TAG_ID VARCHAR2 10 Yes No Active Archival Tagnumber VARCHAR2 3 FIRST_TRANSMISSION VARCHAR2 10 No No Active First Transmission Date VARCHAR2 4 LAST_TRANSMISSION VARCHAR2 10 No No Active Last transmission Dare VARCHAR2 5 TRANSMISSIONS NUMBER 22 No No 38 Active Numner Of transmissions NUMBER 6 DAYS_TRANSMITTING NUMBER 22 No No 38 Active Number of days transmitting NUMBER 7 DEPLOYMENT_DATE VARCHAR2 10 No No Active Date Deployed VARCHAR2 8 POP_OFF_DATE VARCHAR2 10 No No Active Date tagged poped off VARCHAR2 9 DEPLOYMENT_LATITUDE VARCHAR2 7 No No Active Deployment Latitude VARCHAR2 10 DEPLOYMENT_LONGITUDE VARCHAR2 7 No No Active Deployment Longitude VARCHAR2 11 PAT_NAME VARCHAR2 50 No No Active Name Of Archival tag series VARCHAR2 7023 CHECK_TRANSMISSIONS Published / External Completed Table listing information about archival tags by principal investigators Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT Table listing information about archival tags by principal investigators 1 INVESTIGATOR VARCHAR2 100 No No Active Name of Investigator VARCHAR2 2 ARGOS_PTT_ID VARCHAR2 10 Yes No Active Link to Argos table VARCHAR2 3 ARCHIVAL_TAG_ID VARCHAR2 10 Yes No Active Archival Tag Number VARCHAR2 4 PAT_NAME VARCHAR2 50 No No Active Name Of Popup Archival Tag VARCHAR2 5 FIRST_TRANSMISSION DATE 7 No No Active Date Of First transmission DATE 6 LAST_TRANSMISSION DATE 7 No No Active Date Of Last transmission DATE 7 TRANSMISSIONS NUMBER 22 No No 38 Active Number Of transmission NUMBER 8 DAYS_TRANSMITTING NUMBER 22 No No 38 Active Number Of Days Tag was transmitting information NUMBER 9 DEPLOYMENT_DATE DATE 7 No No Active Date tag was deployed DATE 10 POP_OFF_DATE DATE 7 No No Active Date popoff archival tag popped off DATE 11 DEPLOYMENT_LATITUDE NUMBER 22 No No 38 Active Latitude Of tag deployment NUMBER 12 DEPLOYMENT_LONGITUDE NUMBER 22 No No 38 Active Longitude Of tag deployment NUMBER 7024 CTS_ADDRESS_LOCATIONS Published / External Completed Code Table Listing Location Codes and their descriptions Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Code Table Listing Location Codes and their descriptions 1 LOCATION_CODE NUMBER 22 Yes No 38 Active Location Code NUMBER 2 LOCATION_DESCRIPTION VARCHAR2 50 No No Active Description Of Location VARCHAR2 7025 CTS_ADDRESS_STATUS Published / External Completed Code Table Listing Status Codes and their descriptions Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Code Table Listing Status Codes and their descriptions 1 STATUS_CODE NUMBER 22 Yes No 38 Active Status Code NUMBER 2 STATUS_DESCRIPTION VARCHAR2 50 No No Active Status description VARCHAR2 7026 CTS_AGENCIES Published / External Completed Table Of Valid Agencies/Organizations Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table Of Valid Agencies/Organizations 1 AGENCY_ID VARCHAR2 3 Yes Yes Active The three character agency code. VARCHAR2 2 NAME VARCHAR2 50 No No Active The agency name. VARCHAR2 3 ADDRESS_1 VARCHAR2 100 No No Active First Line Of Agency Address VARCHAR2 4 ADDRESS_2 VARCHAR2 100 No No Active Second line of agency address. VARCHAR2 5 ADDRESS_3 VARCHAR2 100 No No Active Third line of agency address. VARCHAR2 6 ADDRESS_4 VARCHAR2 100 No No Active Fourth line of agency address. VARCHAR2 7 CONTACT_NAME VARCHAR2 50 No No Active The person who can answer questions about this agency's data. VARCHAR2 8 CONTACT_PHONE VARCHAR2 13 No No Active The agency phone number. VARCHAR2 7027 CTS_ANGLERS Published / External Completed CTSPAT.CTS_ANGLERS tells who released or recaptured an animal.Each angler is identified by a unique 1 to 6 digit number assigned bytheir agency. Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT CTSPAT.CTS_ANGLERS tells who released or recaptured an animal.Each angler is identified by a unique 1 to 6 digit number assigned bytheir agency. 1 AGENCY_ID VARCHAR2 3 Yes Yes Active Code for the agency assigning angler codes. VARCHAR2 2 ANGLER_ID NUMBER 22 Yes Yes 6 0 Active Unique numeric code assigned to an individual angler. Must be greater than zero. NUMBER 3 TITLE VARCHAR2 30 No No Active The title or salutation for greeting this angler when letters are sent. VARCHAR2 4 FNAME VARCHAR2 30 No No Active The angler's first name. VARCHAR2 5 M_INITIAL VARCHAR2 1 No No Active The angler's middle initial. VARCHAR2 6 LNAME VARCHAR2 30 Yes No Active The angler's last name. VARCHAR2 7 SUFFIX VARCHAR2 20 No No Active The suffix such as Jr. or Sr. for an angler. VARCHAR2 8 ADDRESS_1 VARCHAR2 50 No No Active The first line of the angler's address. VARCHAR2 9 ADDRESS_2 VARCHAR2 30 No No Active The second line of the angler's address. VARCHAR2 10 CITY VARCHAR2 30 Yes No Active City where angler receives mail. VARCHAR2 11 STATE_ID VARCHAR2 30 No No Active U.S. state where angler receives mail. Not allowed for a foreign address. VARCHAR2 12 ZIPCODE VARCHAR2 10 No No Active The angler's zip code. VARCHAR2 13 COUNTRY_ID VARCHAR2 30 No No Active Country where angler receives mail. VARCHAR2 14 HOME_NUMBER VARCHAR2 30 No No Active The angler's home phone number. VARCHAR2 15 WORK_NUMBER VARCHAR2 30 No No Active The angler's work phone number. VARCHAR2 16 MOBILE_NUMBER VARCHAR2 30 No No Active The angler's mobilephone number. VARCHAR2 17 FAX_NUMBER VARCHAR2 30 No No Active The angler's facsimile phone number. VARCHAR2 18 EMAIL VARCHAR2 50 No No Active The angler's email address VARCHAR2 19 NOTES NUMBER 22 No No 3 0 Active The number for a note on the angler. NUMBER 20 EDITCYC NUMBER 22 No No 2 0 Active A control field, (0) indicates an add, (1) indicates an update. Once updated, records are stored with a value of 0 in this field. NUMBER 7028 CTS_ANGLERS_V Published / External Completed View Of Anglers with decodes Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT View Of Anglers with decodes 1 ANGLER_ID NUMBER 22 Yes No 6 0 Active Unique numeric code assigned to an individual angler. Must be greater than zero. NUMBER 2 AGENCY_ID VARCHAR2 3 Yes No Active Code for the agency assigning angler codes. VARCHAR2 3 AGENCY_NAME VARCHAR2 50 No No Active Agency Name Corresponding To Agency ID VARCHAR2 4 FNAME VARCHAR2 30 No No Active The angler's first name. VARCHAR2 5 M_INITIAL VARCHAR2 1 No No Active The angler's middle initial. VARCHAR2 6 LNAME VARCHAR2 30 Yes No Active The angler's last name. VARCHAR2 7 TITLE VARCHAR2 30 No No Active The title or salutation for greeting this angler when letters are sent. VARCHAR2 8 SUFFIX VARCHAR2 20 No No Active The suffix such as Jr. or Sr. for an angler. VARCHAR2 9 ADDRESS_1 VARCHAR2 50 No No Active The first line of the angler's address. VARCHAR2 10 ADDRESS_2 VARCHAR2 30 No No Active The second line of the angler's address. VARCHAR2 11 CITY VARCHAR2 30 Yes No Active City where angler receives mail. VARCHAR2 12 STATE_ID VARCHAR2 30 No No Active U.S. state where angler receives mail. Not allowed for a foreign address. VARCHAR2 13 STATE_NAME VARCHAR2 30 No No Active State Name COrresponding to State Code VARCHAR2 14 COUNTRY_ID VARCHAR2 30 No No Active Country where angler receives mail. VARCHAR2 15 COUNTRY_NAME VARCHAR2 50 No No Active Country Name Corresponding to Country Code VARCHAR2 16 ZIPCODE VARCHAR2 10 No No Active The angler's zip code. VARCHAR2 17 HOME_NUMBER VARCHAR2 30 No No Active The angler's home phone number. VARCHAR2 18 WORK_NUMBER VARCHAR2 30 No No Active The angler's work phone number. VARCHAR2 19 MOBILE_NUMBER VARCHAR2 30 No No Active The angler's mobilephone number. VARCHAR2 20 FAX_NUMBER VARCHAR2 30 No No Active The angler's facsimile phone number. VARCHAR2 21 EMAIL VARCHAR2 50 No No Active The angler's email address VARCHAR2 22 NOTES NUMBER 22 No No 3 0 Active The number for a note on the angler. NUMBER 23 NOTE_DESCRIPTION VARCHAR2 50 No No Active Description Of Note Code VARCHAR2 7029 CTS_ANGLER_NOTES Published / External Completed Code Table Listing Possible Notes Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Code Table Listing Possible Notes 1 NOTE_ID NUMBER 22 Yes No 38 Active Numeric Note Code NUMBER 2 NOTE_DESCRIPTION VARCHAR2 50 No No Active Description associated With Code VARCHAR2 7030 CTS_ANIMALS Published / External Completed Table Of Animals Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table Of Animals 1 ANIMAL_ID NUMBER 22 Yes Yes 10 0 Active Sequential Key NUMBER 2 SPECIES_ID VARCHAR2 3 Yes No Active Species Of Animal VARCHAR2 3 SEX VARCHAR2 1 No No Active Sex Of Animal VARCHAR2 4 GEOM SDO_GEOMETRY 1 No No Active Geospacial Component Of Record SDO_GEOMETRY 7031 CTS_ANIMALS_SEARCH_V Published / External Completed View Of animal with species and sex decoded which is a result of a search Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT View Of animal with species and sex decoded which is a result of a search 1 ANIMAL_ID NUMBER 22 Yes No 10 0 Active Sequential Key / Link To CTS_INTERACTION Record NUMBER 2 SPECIES_ID VARCHAR2 3 Yes No Active Species Code VARCHAR2 3 SPECIES_NAME VARCHAR2 21 No No Active Common Name VARCHAR2 4 SEX VARCHAR2 1 No No Active Code To Indicate Sex Of Animal VARCHAR2 5 SEX_DESCRIPTION VARCHAR2 10 Yes No Active Decode Of Code To Indicate Sez Of Animal VARCHAR2 7032 CTS_ANIMALS_V Published / External Completed View Of animal with species and sex decoded Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT View Of animal with species and sex decoded 1 ANIMAL_ID NUMBER 22 Yes No 10 0 Active Sequential Key / Link To CTS_INTERACTION Record NUMBER 2 SPECIES_ID VARCHAR2 3 Yes No Active Species Code VARCHAR2 3 SPECIES_NAME VARCHAR2 21 No No Active Common Name VARCHAR2 4 SEX VARCHAR2 1 No No Active Code To Indicate Sex Of Animal VARCHAR2 5 SEX_DESCRIPTION VARCHAR2 10 Yes No Active Decode Of Code To Indicate Sez Of Animal VARCHAR2 7033 CTS_ANIMAL_NOTES Published / External Completed Table Of Valid Notes Describing Animal Condition at Tagging Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table Of Valid Notes Describing Animal Condition at Tagging 1 NOTE_ID NUMBER 22 Yes No 38 Active Note Cpde NUMBER 2 NOTE_DESCRIPTION VARCHAR2 50 No No Active Code Description VARCHAR2 7034 CTS_ARGOS Published / External Completed Table Of Transmission Records Of Archival Tags Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table Of Transmission Records Of Archival Tags 1 ARGOS_PTT_ID VARCHAR2 10 Yes No Active The unique PTT id of the transmitter used by the Argos Satellite Transmission Service provider. VARCHAR2 2 TRANSMISSION_DATE DATE 7 Yes No Active Date Information Was Transmitted (Just the information to the date level) DATE 3 TRANSMISSION_TIME VARCHAR2 10 Yes No Active Transmitted (Just the information to the time level) VARCHAR2 4 LOCATION_CODE VARCHAR2 3 No No Active Location Code VARCHAR2 5 X_QUALITY_INDICATOR NUMBER 22 No No 38 Active Characterizes the residual error on the frequency calculation. 0 means the residual error is not calculated, 6 means the error is less than 0.15 Hz. . NUMBER 6 Y_QUALITY_INDICATOR NUMBER 22 No No 1 0 Active Concerns the medium-term oscillator drift between two satellite passes. 0 means the results are more than 12 hours apart, 8 means that the drift is less than 0.2 Hz/minute. NUMBER 7 X1_COORD NUMBER 22 No No 11 6 Active First longitude value given by the Argos Satellite to identify the possible location of the transmitter during transmission. NUMBER 8 Y1_COORD NUMBER 22 No No 11 6 Active First latitude value given by the Argos Satellite to identify the possible location of the transmitter during transmission. NUMBER 9 X2_COORD NUMBER 22 No No 11 6 Active Second longitude value given by the Argos Satellite to identify the possible location of the transmitter during transmission. NUMBER 10 Y2_COORD NUMBER 22 No No 11 6 Active Second longitude value given by the Argos Satellite to identify the possible location of the transmitter during transmission. NUMBER 11 MESSAGE_COUNT NUMBER 22 No No 38 0 Active Number of messages send during the transmission. NUMBER 12 ARCHIVAL_TAG_ID VARCHAR2 10 No No Active Archival Tag ID provided by the manufacturer. VARCHAR2 13 ID NUMBER 22 Yes Yes 38 Active Sequential Key NUMBER 7035 CTS_ARGOS_COUNT_V Published / External Completed List Of Archival Tags and the number of messages recieved per that tag Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT List Of Archival Tags and the number of messages recieved per that tag 1 ARCHIVAL_TAG_ID VARCHAR2 10 No No Active Archival Tag Id VARCHAR2 2 MESSAGES NUMBER 22 No No 38 Active Number Of Messages NUMBER 7036 CTS_BAIT_TYPES Published / External Completed Table Of Valid Bait Types Used while fishing Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table Of Valid Bait Types Used while fishing 1 BAIT_TYPE VARCHAR2 50 No No Active Bait Type Description VARCHAR2 2 BAIT_ID VARCHAR2 1 No No Active Code Associated WIth Bait Type VARCHAR2 7037 CTS_BLEEDING Published / External Completed Table Of Valid Bleeding Levels Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table Of Valid Bleeding Levels 1 BLEEDING_LEVELS VARCHAR2 20 No No Active Bleeding Level VARCHAR2 7038 CTS_COLORS Published / External Completed Table of Valid Tag Colors Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table of Valid Tag Colors 1 COLOR_ID VARCHAR2 3 Yes No Active Mnemonic Color Code VARCHAR2 2 COLOR_DESCRIPTION VARCHAR2 50 No No Active Code Description VARCHAR2 7039 CTS_COUNTRIES Published / External Completed Table Of Valid Country Codes Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table Of Valid Country Codes 1 COUNTRY_ID VARCHAR2 2 Yes Yes Active The 3 character country code. VARCHAR2 2 COUNTRY_NAME VARCHAR2 50 No No Active The country name. VARCHAR2 7040 CTS_DISTRIBUTED_TAGS Published / External Completed CTS.CTS_DISTRIBUTED_TAGS describes what tags were issued to individual anglersand what rewards were paid for recovering tags. Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT CTS.CTS_DISTRIBUTED_TAGS describes what tags were issued to individual anglersand what rewards were paid for recovering tags. 1 AGENCY_ID VARCHAR2 5 Yes Yes Active Code for agency assigning the tags. VARCHAR2 2 TAG_TYPE_ID VARCHAR2 3 Yes Yes Active Key to Type Of Tag VARCHAR2 3 BEGINTAG VARCHAR2 8 Yes Yes Active Lowest tag number of a set of consecutive tags assigned to an angler. VARCHAR2 4 ENDTAG VARCHAR2 8 Yes No Active Highest tag number of a set of consecutive tags assigned to an angler. Format: aannnnnn where: aa = tag prefix. (must be same as BEGINTAG) nnnnnn = tag number. (must be = > than BEGINTAG nnnnnn) VARCHAR2 5 FIRST_COLOR VARCHAR2 3 No No Active First Color On Tag VARCHAR2 6 SECOND_COLOR VARCHAR2 3 No No Active Second Color On Tag VARCHAR2 7 LENGTH_CM NUMBER 22 No No 38 Active Tag Length In Centimeters NUMBER 8 RECEIVING_AGENCY_ID VARCHAR2 3 No No Active Code for agency receiving the set of tags. (Required if ANGLER is .99999) VARCHAR2 9 RETURN_ADDRESS_ID NUMBER 22 Yes No 2 0 Active Address code where tags should be returned. NUMBER 10 TAGS_ASSIGNED VARCHAR2 1 No No Active Flag to indicate if this set has been assigned to an angler. Options: Y-yes, N-no, U-unknown. VARCHAR2 11 TAGS_ASSIGNED_DATE DATE 7 No No Active Date set of tags were assigned. (Required if ASSIGNED = Yes) Format: mm/dd/yy DATE 12 ANGLER_AGENCY_ID VARCHAR2 5 No No Active Angler code of angler assigned the set of tags. (Required if RECEIVAGE is blank) VARCHAR2 13 ANGLER_ID NUMBER 22 No No 38 Active Name of angler, agency, or party assigned the set of tags. NUMBER 14 KIT_SENT VARCHAR2 1 No No Active Flag indicating if complete kit was sent to party receiving tags. Options: Y-yes, N-no. U-unknown VARCHAR2 15 REPLY_DATE DATE 7 No No Active Date reply acknowledgement was received. DATE 16 REWARD_AMOUNT NUMBER 22 No No 6 2 Active Whole dollar amount of the reward sent for the return of the tag. Where: nnn = 0 to 998 Or 999 for non-monetary incentive offered, i.e. hats, t-shirts, flags. NUMBER 17 AV_EDITCYC NUMBER 22 No No 2 0 Active A control field, (0) indicates an add, (1) indicates an update. Once updated, records are stored with a value of 0 in this field. NUMBER 18 AV_EDITDAT DATE 7 No No Active The date the record was initially entered, or last updated, whichever is later. DATE 19 AV_DELEDAT DATE 7 No No Active A control field used to delete existing records from this table. No records are stored with a value in this field. DATE 7041 CTS_EVENTS Published / External Completed Table Of Valid Tagging Events Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table Of Valid Tagging Events 1 EVENT_ID NUMBER 22 Yes Yes 2 0 Active The numeric code assigned to this event. NUMBER 2 EVENT_DESCRIPTION VARCHAR2 40 No No Active The description of the event. VARCHAR2 7042 CTS_FISHING_METHODS Published / External Completed Table Of Valid Fishing Methods Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table Of Valid Fishing Methods 1 FISHING_METHOD VARCHAR2 50 No No Active Fishing Method VARCHAR2 7043 CTS_GEAR Published / External Completed Table Of Valid Gear Codes Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table Of Valid Gear Codes 1 GEAR_ID VARCHAR2 3 Yes Yes Active The mnemonic code for the gear. VARCHAR2 2 GEAR_NAME VARCHAR2 25 No No Active The description of the gear. VARCHAR2 7044 CTS_HOOK_LOCATIONS Published / External Completed Table of Valid Hook Locations Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table of Valid Hook Locations 1 LOCATION VARCHAR2 50 No No Active Hook Location VARCHAR2 7045 CTS_HOOK_TYPES Published / External Completed Table Of Valid Hook Types Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table Of Valid Hook Types 1 HOOK_TYPE VARCHAR2 50 No No Active Type Of Hook Used VARCHAR2 7046 CTS_INTERACTIONS Published / External 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 7047 CTS_INTERACTIONS_EXTRACT_V Published / External Completed View Of data starting with 01/01/2003 Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT View Of data starting with 01/01/2003 1 ANIMAL_ID NUMBER 22 Yes No 10 0 Active Key to Identifies Animal NUMBER 2 AGENCY_ID VARCHAR2 3 Yes No Active Code to Indicate Tagging agency of identifying tag on animal (tag1) VARCHAR2 3 AGENCY_NAME VARCHAR2 50 No No Active Agency Name VARCHAR2 4 TAG_ID VARCHAR2 8 Yes No Active Tagnumber VARCHAR2 5 EVENT_ID NUMBER 22 Yes No 2 0 Active Code to identify tagging event NUMBER 6 TAG_DATE VARCHAR2 10 No No Active Date animal was released or recaptured. VARCHAR2 7 NEXT_TAG_AGENCY_ID VARCHAR2 3 No No Active Agency Id associated with value in the nexttag column VARCHAR2 8 NEXT_TAG_ID VARCHAR2 8 No No Active Code to Indicate Tagging agency of identifying tag on animal (nexttag) VARCHAR2 9 INTERACTION_ORDER NUMBER 22 Yes No 2 0 Active Number denoting the order of the interaction. NUMBER 10 LENGTH NUMBER 22 No No 4 0 Active Length of animal tagged based on the lengthunit, lengthtype, and lengthdet. NUMBER 11 LENGTHUNIT VARCHAR2 2 No No Active Length Units VARCHAR2 12 LENGTHTYPE VARCHAR2 1 No No Active Type Of Length Measurment Taken VARCHAR2 13 LENGTHDET VARCHAR2 1 No No Active How Length Was Measurment was determined VARCHAR2 14 WEIGHT NUMBER 22 No No 6 2 Active Weight of an animal tagged, based upon weightunit, weighttype and weightdet. NUMBER 15 WEIGHTUNIT VARCHAR2 2 No No Active Weight Units VARCHAR2 16 WEIGHTTYPE VARCHAR2 1 No No Active Type Of Weight Mesurment Taken VARCHAR2 17 WEIGHTDET VARCHAR2 1 No No Active How weight measurement was determined VARCHAR2 18 LATITUDE NUMBER 22 No No 30 16 Active Numeric value for the latitude of the tagging location. NUMBER 19 LONGITUDE NUMBER 22 No No 30 16 Active Numeric value the the longitude of the tagging location. NUMBER 20 STAT_ZONE_ID NUMBER 22 No No 4 1 Active Code to indciate State Zone NUMBER 21 COUNTRY_ID VARCHAR2 2 No No Active Cde to indicate Country VARCHAR2 22 STATE_ID VARCHAR2 2 No No Active Code to indicate state VARCHAR2 23 WATER_BODY_ID NUMBER 22 No No 6 3 Active Code to Indicate waterbody of where tagging took place NUMBER 24 PLACE_ID VARCHAR2 3 No No Active Code to indicate place of wheer tagging took palce VARCHAR2 25 GEAR_ID VARCHAR2 3 No No Active Code for gear used to catch the animal. VARCHAR2 26 GEAR_NAME VARCHAR2 25 No No Active Common Name For Gear used in fishing VARCHAR2 27 BAIT_TYPE VARCHAR2 1 No No Active Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown VARCHAR2 28 METHOD_ID NUMBER 22 No No 6 0 Active Code To indicate tagging methodology Used NUMBER 29 SAMPLE_ID NUMBER 22 No No 6 0 Active Code to indicate Sampling Methodology NUMBER 30 CAPTAIN_AGENCY VARCHAR2 3 No No Active COde to indicate agency which assigned angler code for boat captain VARCHAR2 31 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 32 TAGGER_INITIALS VARCHAR2 3 No No Active Initials Of Taggers VARCHAR2 33 TAGGER_AFFILIATION VARCHAR2 3 No No Active Code Of Agency that is affiliated With The Tagger VARCHAR2 34 VESSEL_AGENCY VARCHAR2 3 No No Active Agency For Vessel COode VARCHAR2 35 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 36 PHYSICAL_DATA_ID NUMBER 22 No No 6 0 Active Physical Data Identification Number NUMBER 37 NOTES NUMBER 22 No No 3 0 Active Any Other Notes On Tagging NUMBER 38 FIGHTHRS NUMBER 22 No No 2 0 Active Whole Number Of houirs spent landing The animal NUMBER 39 FIGHTMINS NUMBER 22 No No 2 0 Active Number Of minutes (up to 59) landing the animal NUMBER 40 ANGLER_AGENCY_ID VARCHAR2 3 No No Active Agency Id associated with the angler number is VARCHAR2 41 ANGLER_ID NUMBER 22 No No 6 0 Active Unique identifier for each person in the database. NUMBER 42 ID NUMBER 22 Yes No 38 Active Identifies Ang;er NUMBER 43 DATE_ENTERED VARCHAR2 10 No No Active The date the data was entered. VARCHAR2 44 SPECIES_ID VARCHAR2 3 No No Active Species Code VARCHAR2 45 SEX VARCHAR2 1 No No Active Code to indicate sex of the animal VARCHAR2 7048 CTS_INTERACTIONS_SEARCH_V Published / External Completed View Of data starting with 01/01/2003 Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT View Of data starting with 01/01/2003 1 ANIMAL_ID NUMBER 22 Yes No 10 0 Active Key to Identifies Animal NUMBER 2 AGENCY_ID VARCHAR2 3 Yes No Active Code to Indicate Tagging agency of identifying tag on animal (tag1) VARCHAR2 3 TAG_ID VARCHAR2 8 Yes No Active Tagnumber VARCHAR2 4 EVENT_ID NUMBER 22 Yes No 2 0 Active Code to identify tagging event NUMBER 5 TAG_DATE VARCHAR2 10 No No Active Date animal was released or recaptured. VARCHAR2 6 TAGDATE DATE 7 Yes No Active Date Animal Was Tagged DATE 7 NEXT_TAG_AGENCY_ID VARCHAR2 3 No No Active Agency Id associated with value in the nexttag column VARCHAR2 8 NEXT_TAG_ID VARCHAR2 8 No No Active Code to Indicate Tagging agency of identifying tag on animal (nexttag) VARCHAR2 9 INTERACTION_ORDER NUMBER 22 Yes No 2 0 Active Number denoting the order of the interaction. NUMBER 10 LENGTH NUMBER 22 No No 4 0 Active Length of animal tagged based on the lengthunit, lengthtype, and lengthdet. NUMBER 11 LENGTHUNIT VARCHAR2 2 No No Active Length Units VARCHAR2 12 LENGTHTYPE VARCHAR2 1 No No Active Type Of Length Measurment Taken VARCHAR2 13 LENGTHDET VARCHAR2 1 No No Active How Length Was Measurment was determined VARCHAR2 14 WEIGHT NUMBER 22 No No 6 2 Active Weight of an animal tagged, based upon weightunit, weighttype and weightdet. NUMBER 15 WEIGHTUNIT VARCHAR2 2 No No Active Weight Units VARCHAR2 16 WEIGHTTYPE VARCHAR2 1 No No Active Type Of Weight Mesurment Taken VARCHAR2 17 WEIGHTDET VARCHAR2 1 No No Active How weight measurement was determined VARCHAR2 18 LATITUDE NUMBER 22 No No 30 16 Active Numeric value for the latitude of the tagging location. NUMBER 19 LONGITUDE NUMBER 22 No No 30 16 Active Numeric value the the longitude of the tagging location. NUMBER 20 STAT_ZONE_ID NUMBER 22 No No 4 1 Active Code to indciate State Zone NUMBER 21 COUNTRY_ID VARCHAR2 2 No No Active Cde to indicate Country VARCHAR2 22 STATE_ID VARCHAR2 2 No No Active Code to indicate state VARCHAR2 23 WATER_BODY_ID NUMBER 22 No No 6 3 Active Code to Indicate waterbody of where tagging took place NUMBER 24 PLACE_ID VARCHAR2 3 No No Active Code to indicate place of wheer tagging took palce VARCHAR2 25 GEAR_ID VARCHAR2 3 No No Active Code for gear used to catch the animal. VARCHAR2 26 BAIT_TYPE VARCHAR2 1 No No Active Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown VARCHAR2 27 METHOD_ID NUMBER 22 No No 6 0 Active Code To indicate tagging methodology Used NUMBER 28 SAMPLE_ID NUMBER 22 No No 6 0 Active Code to indicate Sampling Methodology NUMBER 29 CAPTAIN_AGENCY VARCHAR2 3 No No Active COde to indicate agency which assigned angler code for boat captain VARCHAR2 30 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 31 TAGGER_INITIALS VARCHAR2 3 No No Active Initials Of Taggers VARCHAR2 32 TAGGER_TYPE VARCHAR2 1 No No Active Code to indicate the type of tagger that tagged this animal VARCHAR2 33 TAGGER_AFFILIATION VARCHAR2 3 No No Active Code Of Agency that is affiliated With The Tagger VARCHAR2 34 VESSEL_AGENCY VARCHAR2 3 No No Active Agency For Vessel COode VARCHAR2 35 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 36 PHYSICAL_DATA_ID NUMBER 22 No No 6 0 Active Physical Data Identification Number NUMBER 37 NOTES NUMBER 22 No No 3 0 Active Any Other Notes On Tagging NUMBER 38 FIGHTHRS NUMBER 22 No No 2 0 Active Whole Number Of houirs spent landing The animal NUMBER 39 FIGHTMINS NUMBER 22 No No 2 0 Active Number Of minutes (up to 59) landing the animal NUMBER 40 ANGLER_AGENCY_ID VARCHAR2 3 No No Active Agency Id associated with the angler number is VARCHAR2 41 ANGLER_ID NUMBER 22 No No 6 0 Active Unique identifier for each person in the database. NUMBER 42 ID NUMBER 22 Yes No 38 Active Identifies Ang;er NUMBER 43 DATE_ENTERED VARCHAR2 10 No No Active The date the data was entered. VARCHAR2 44 SPECIES_ID VARCHAR2 3 Yes No Active Species Code VARCHAR2 45 SEX VARCHAR2 1 No No Active Code to indicate sex of the animal VARCHAR2 7049 CTS_INTERACTIONS_V Published / External Completed View Of data starting with 01/01/2003 Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT View Of data starting with 01/01/2003 1 ANIMAL_ID NUMBER 22 Yes No 10 0 Active Key to Identifies Animal NUMBER 2 AGENCY_ID VARCHAR2 3 Yes No Active Code to Indicate Tagging agency of identifying tag on animal (tag1) VARCHAR2 3 TAG_ID VARCHAR2 8 Yes No Active Tagnumber VARCHAR2 4 EVENT_ID NUMBER 22 Yes No 2 0 Active Code to identify tagging event NUMBER 5 TAG_DATE VARCHAR2 10 No No Active Date animal was released or recaptured. VARCHAR2 6 NEXT_TAG_AGENCY_ID VARCHAR2 3 No No Active Agency Id associated with value in the nexttag column VARCHAR2 7 NEXT_TAG_ID VARCHAR2 8 No No Active Code to Indicate Tagging agency of identifying tag on animal (nexttag) 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 Units VARCHAR2 11 LENGTHTYPE VARCHAR2 1 No No Active Type Of Length Measurment Taken VARCHAR2 12 LENGTHDET VARCHAR2 1 No No Active How Length Was Measurment was determined 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 Units VARCHAR2 15 WEIGHTTYPE VARCHAR2 1 No No Active Type Of Weight Mesurment Taken VARCHAR2 16 WEIGHTDET VARCHAR2 1 No No Active How weight measurement was determined 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 STAT_ZONE_ID NUMBER 22 No No 4 1 Active Code to indciate State Zone NUMBER 20 COUNTRY_ID VARCHAR2 2 No No Active Cde to indicate Country VARCHAR2 21 STATE_ID VARCHAR2 2 No No Active Code to indicate state VARCHAR2 22 WATER_BODY_ID NUMBER 22 No No 6 3 Active Code to Indicate waterbody of where tagging took place NUMBER 23 PLACE_ID VARCHAR2 3 No No Active Code to indicate place of wheer tagging took palce 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 To indicate tagging methodology Used NUMBER 27 SAMPLE_ID NUMBER 22 No No 6 0 Active Code to indicate Sampling Methodology NUMBER 28 CAPTAIN_AGENCY VARCHAR2 3 No No Active COde to indicate agency which assigned angler code for boat captain 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 Taggers VARCHAR2 31 TAGGER_AFFILIATION VARCHAR2 3 No No Active Code Of Agency that is affiliated With The Tagger VARCHAR2 32 VESSEL_AGENCY VARCHAR2 3 No No Active Agency For Vessel COode VARCHAR2 33 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 34 PHYSICAL_DATA_ID NUMBER 22 No No 6 0 Active Physical Data Identification Number NUMBER 35 NOTES NUMBER 22 No No 3 0 Active Any Other Notes On Tagging NUMBER 36 FIGHTHRS NUMBER 22 No No 2 0 Active Whole Number Of houirs spent landing The animal NUMBER 37 FIGHTMINS NUMBER 22 No No 2 0 Active Number Of minutes (up to 59) landing the animal NUMBER 38 ANGLER_AGENCY_ID VARCHAR2 3 No No Active Agency Id associated with the angler number is VARCHAR2 39 ANGLER_ID NUMBER 22 No No 6 0 Active Unique identifier for each person in the database. NUMBER 40 ID NUMBER 22 Yes No 38 Active Identifies Ang;er NUMBER 41 DATE_ENTERED VARCHAR2 10 No No Active The date the data was entered. VARCHAR2 42 SPECIES_ID VARCHAR2 3 No No Active Species Code VARCHAR2 43 SEX VARCHAR2 1 No No Active Code to indicate sex of the animal VARCHAR2 7050 CTS_KFTRACK Published / External Completed This table contains the results of the Kalman Filter geolocation algorithm. Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT This table contains the results of the Kalman Filter geolocation algorithm. 1 ARCHIVAL_TAG_ID VARCHAR2 10 Yes No Active Archival Tag ID provided by the manufacturer. VARCHAR2 2 POINT_ID NUMBER 22 Yes No 38 Active The identification number of the point NUMBER 3 POINT_DATE DATE 7 Yes No Active The date the location was generated. DATE 4 DAYS NUMBER 22 No No 38 Active Number of days from the beginning NUMBER 5 J NUMBER 22 No No 38 Active Julian Date NUMBER 6 VY NUMBER 22 No No 38 Active Model parameter NUMBER 7 AX NUMBER 22 No No 38 Active Model parameter NUMBER 8 AY NUMBER 22 No No 38 Active Model parameter NUMBER 9 OX NUMBER 22 No No 38 Active Original Longitude NUMBER 10 OY NUMBER 22 No No 38 Active Original Latitude NUMBER 11 PX NUMBER 22 No No 38 Active Kalman Filter Longitude NUMBER 12 PY NUMBER 22 No No 38 Active Kalman Filter Latitude NUMBER 13 SX NUMBER 22 No No 38 Active Smoothed Longitude NUMBER 14 SY NUMBER 22 No No 38 Active Smoother Latitude NUMBER 15 O_GEOM SDO_GEOMETRY 1 No No Active Oracle SDO_Geometry of the original track SDO_GEOMETRY 16 P_GEOM SDO_GEOMETRY 1 No No Active Oracle SDO_Geometry of the KF track SDO_GEOMETRY 17 S_GEOM SDO_GEOMETRY 1 No No Active Oracle SDO_Geometry of the smoothed KF track SDO_GEOMETRY 18 ID NUMBER 22 Yes Yes 38 Active Sequential Key NUMBER 7051 CTS_LENGTH_DETERMINATION Published / External Completed Table Of Valid Methods Of Length Determination/Measurement Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table Of Valid Methods Of Length Determination/Measurement 1 LENGTH_CODE VARCHAR2 1 Yes No Active Mnemonic Length Determination Code VARCHAR2 2 LENGTH_DESCRIPTION VARCHAR2 50 No No Active Code Description VARCHAR2 7052 CTS_LENGTH_TYPE Published / External Completed Table Of Valid Length Type Codes and their descriptions Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table Of Valid Length Type Codes and their descriptions 1 TYPE_CODE VARCHAR2 1 Yes No Active Length Type Code VARCHAR2 2 TYPE_DESCRIPTION VARCHAR2 50 No No Active Description Of Length Type Code VARCHAR2 7053 CTS_LENGTH_UNIT Published / External Completed Table Of Valid Length Codes Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table Of Valid Length Codes 1 UNIT_CODE VARCHAR2 2 Yes No Active Mnemonic Length Code/Unit VARCHAR2 2 UNIT_DESCRIPTION VARCHAR2 50 No No Active Description VARCHAR2 7054 CTS_LETTERS_V Published / External Completed View to hold information to create letters to anglers and ca[tians when a ftagged fish is recaptured Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT View to hold information to create letters to anglers and ca[tians when a ftagged fish is recaptured 1 INTERACTION_ID NUMBER 22 No No 38 Active Link to interaction record NUMBER 2 ANIMAL_ID NUMBER 22 No No 10 0 Active Animal Id NUMBER 3 TAG_ID VARCHAR2 12 No No Active Tagnumber VARCHAR2 4 SPECIES_ID VARCHAR2 3 No No Active Species Code VARCHAR2 5 SPECIES_NAME VARCHAR2 21 No No Active Species Name VARCHAR2 6 TAG_DATE VARCHAR2 10 No No Active Date animal was tagged VARCHAR2 7 LOCATION VARCHAR2 13 No No Active location of recapture VARCHAR2 8 LENGTH NUMBER 22 No No 4 0 Active Length Of recpatured fish NUMBER 9 WEIGHT NUMBER 22 No No 6 2 Active Weight of recaptured fish NUMBER 10 FISHERMAN_NAME VARCHAR2 61 No No Active Fisherman's name VARCHAR2 11 ADDRESS_1 VARCHAR2 50 No No Active First Line address VARCHAR2 12 ADDRESS_2 VARCHAR2 30 No No Active Second Line address VARCHAR2 13 CITY VARCHAR2 30 No No Active CIty VARCHAR2 14 STATE_NAME VARCHAR2 30 No No Active State VARCHAR2 15 ZIPCODE VARCHAR2 10 No No Active Zipcode VARCHAR2 16 COUNTRY_NAME VARCHAR2 50 No No Active country VARCHAR2 7055 CTS_LOCATION_LATLONG Published / External Completed Table Of Valid Location Codes Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table Of Valid Location Codes 1 ID NUMBER 22 No No 38 Active Sequential Key NUMBER 2 LOCATION_NAME VARCHAR2 200 No No Active Location Name VARCHAR2 3 LOCALITY_1 VARCHAR2 100 Yes No Active Locality One Description (Most specific Locality Description) VARCHAR2 4 LOCALITY_2 VARCHAR2 100 Yes No Active Locality Two Description (Next most descriptive locality description) VARCHAR2 5 LOCALITY_3 VARCHAR2 100 Yes No Active Locality Three Information (most gernal locality description. It is often at the US stete or country level) VARCHAR2 6 LATITUDE NUMBER 22 Yes No 38 Active Specified Latitude NUMBER 7 LONGITUDE NUMBER 22 Yes No 38 Active Specified Longitude NUMBER 7056 CTS_MULTITAG Published / External Completed Keeps Track of Multi Tagged Fish Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Keeps Track of Multi Tagged Fish 1 CTS_INTERACTIONS_ANIMAL_ID NUMBER 22 Yes Yes 10 0 Active Foreign Key To Animal record NUMBER 2 CTS_INTERACTIONS_INTERACTION_O NUMBER 22 Yes Yes 2 0 Active Foreign Key To CTS_INTERACTIONS Record NUMBER 3 AGENCY_ID VARCHAR2 3 Yes Yes Active Foriegn Key to Agency Table For Tag ID VARCHAR2 4 TAG_ID VARCHAR2 8 Yes Yes Active Tag Id Number VARCHAR2 5 NEXT_TAG_AGENCY_ID VARCHAR2 3 Yes Yes Active Foriegn Key to Agency Table For Next Tag ID VARCHAR2 6 NEXT_TAG_ID VARCHAR2 8 Yes Yes Active Next Tag ID Number VARCHAR2 7 DATE_APPLIED DATE 7 Yes No Active Date tag was applied DATE 8 DATE_REMOVED DATE 7 No No Active Date Tabe was removed DATE 7057 CTS_PAT_INVESTIGATORS Published / External Completed Table Of Popup ARchival Tag Investigators Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table Of Popup ARchival Tag Investigators 1 AGENCY_ID VARCHAR2 5 Yes No Active Foreign Key To Agency Table VARCHAR2 2 INVESTIGATOR_ID NUMBER 22 Yes Yes 5 0 Active Primary Key NUMBER 3 NAME VARCHAR2 100 No No Active Investigator Name VARCHAR2 4 ADDRESS_1 VARCHAR2 100 No No Active First Line Of Address For Investigator VARCHAR2 5 ADDRESS_2 VARCHAR2 100 No No Active Second Line Of Address For Investigator VARCHAR2 6 CITY VARCHAR2 50 No No Active City of Mailing address For Investigator VARCHAR2 7 STATE VARCHAR2 50 No No Active State of Mailing address For Investigator VARCHAR2 8 ZIPCODE VARCHAR2 10 No No Active Zipcode of Mailing address For Investigator VARCHAR2 9 COUNTRY VARCHAR2 100 No No Active Country of Mailing address For Investigator VARCHAR2 10 PHONE VARCHAR2 20 No No Active Phone Number of Investigator VARCHAR2 11 FAX VARCHAR2 20 No No Active Facsimilie Number For Investigator VARCHAR2 12 EMAIL VARCHAR2 50 No No Active Electronic mail address For Investigator VARCHAR2 7058 CTS_PAT_LOCATIONS Published / External Completed Table Of Popup Archival Tag Locations Generated Using the Light-based Geolocation Algorithm. Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table Of Popup Archival Tag Locations Generated Using the Light-based Geolocation Algorithm. 1 ARGOS_PTT_ID VARCHAR2 10 Yes No Active The unique PTT id of the transmitter used by the Argos Satellite Transmission Service provider. VARCHAR2 2 LONGITUDE NUMBER 22 No No 20 14 Active Longitude value estimated using the midday algorithm where the highest light levels were recorded. NUMBER 3 YEAR NUMBER 22 Yes No 4 0 Active (Year Component) Times Of Reading NUMBER 4 MONTH NUMBER 22 Yes No 2 0 Active (Month Component) Times Of Reading NUMBER 5 DAY NUMBER 22 Yes No 2 0 Active (Day Component) Times Of Reading NUMBER 6 MIDHOUR NUMBER 22 No No 2 0 Active The hour when the lowest light level was recorded. NUMBER 7 MIDMINUTE NUMBER 22 No No 2 0 Active The minute when the lowest light level was recorded. NUMBER 8 LATITUDE NUMBER 22 No No 20 14 Active Latitude estimate using the light-based (length of day) geolocation algorithm. NUMBER 9 LAT_MSD FLOAT 22 No No 126 Active Mean standard deviation for latitude value. FLOAT 10 LON_MSD FLOAT 22 No No 126 Active Mean standard deviation for longitude value. FLOAT 11 LOC_RECORD NUMBER 22 Yes No 38 Active Location Record NUMBER 12 GEOM SDO_GEOMETRY 1 No No Active The Oracle SDO_Geometry object used to store the point location. SDO_GEOMETRY 13 ARCHIVAL_TAG_ID VARCHAR2 10 Yes No Active Archival Tag ID provided by the manufacturer. VARCHAR2 14 ID NUMBER 22 Yes Yes 38 Active Sequence to uniquely identify each record in this table. NUMBER 7059 CTS_PAT_LOCATIONS_PERF_V Published / External Completed View Listing number of location records per Archival Tag Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT View Listing number of location records per Archival Tag 1 ARCHIVAL_TAG_ID VARCHAR2 10 Yes No Active Archival Tag Number VARCHAR2 2 LOCATIONS_COUNT NUMBER 22 No No 38 Active Number of Records Per Archival Tag NUMBER 3 RELEASE_DATE DATE 7 No No Active Date Animal was released with Archival Tag DATE 4 ACTUAL_POP_OFF_DATE DATE 7 No No Active Date Archival Tag popped off of the animal DATE 7060 CTS_PAT_PDT Published / External Completed Profile at Depth and Time (PDT) - a sampling of the depths that the tag experienced with minimum and maximum values for temperature at each. Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Profile at Depth and Time (PDT) - a sampling of the depths that the tag experienced with minimum and maximum values for temperature at each. 1 ARGOS_PTT_ID VARCHAR2 10 Yes No Active Link to ARGOS Table VARCHAR2 2 RECEPTION_DATE DATE 7 Yes No Active Date Information Wa Received DATE 3 RECEPTION_TIME VARCHAR2 10 Yes No Active Time Information Was Recieved VARCHAR2 4 DEPTH_1 NUMBER 22 No No 4 0 Active Depth One Measurement NUMBER 5 D1_MIN_TEMP NUMBER 22 No No 5 1 Active Depth One Minimum Temperature NUMBER 6 D1_MAX_TEMP NUMBER 22 No No 5 1 Active Depth One Maximum Temperature NUMBER 7 DEPTH_2 NUMBER 22 No No 4 0 Active Depth Two Measurement NUMBER 8 D2_MIN_TEMP NUMBER 22 No No 5 1 Active Depth Two Minimum Temperature NUMBER 9 D2_MAX_TEMP NUMBER 22 No No 5 1 Active Depth Two Maximum Temperature NUMBER 10 DEPTH_3 NUMBER 22 No No 4 0 Active Depth Three Measurement NUMBER 11 D3_MIN_TEMP NUMBER 22 No No 5 1 Active Depth Three Minimum Temperature NUMBER 12 D3_MAX_TEMP NUMBER 22 No No 5 1 Active Depth Three Maximum Temperature NUMBER 13 DEPTH_4 VARCHAR2 240 No No Active Depth Four Measurement VARCHAR2 14 D4_MIN_TEMP NUMBER 22 No No 5 1 Active Depth Four Minimum Temperature NUMBER 15 D4_MAX_TEMP NUMBER 22 No No 5 1 Active Depth Four Maximum Temperature NUMBER 16 DEPTH_5 NUMBER 22 No No 38 Active Depth five measurement NUMBER 17 D5_MIN_TEMP NUMBER 22 No No 5 1 Active Depth Five Minimum Temperature NUMBER 18 D5_MAX_TEMP NUMBER 22 No No 5 1 Active Depth Fivet Maximum Temperature NUMBER 19 DEPTH_6 NUMBER 22 No No 4 0 Active Depth Six Measurement NUMBER 20 D6_MIN_TEMP NUMBER 22 No No 5 1 Active Depth Six Minimum Temperature NUMBER 21 D6_MAX_TEMP NUMBER 22 No No 5 1 Active Depth Six Maximum Temperature NUMBER 22 DEPTH_7 NUMBER 22 No No 4 0 Active Depth Seven Measurement NUMBER 23 D7_MIN_TEMP NUMBER 22 No No 5 1 Active Depth Seven Minimum Temperature NUMBER 24 D7_MAX_TEMP NUMBER 22 No No 5 1 Active Depth Seven Maximum Temperature NUMBER 25 DEPTH_8 NUMBER 22 No No 4 0 Active Depth Eight Measurement NUMBER 26 D8_MIN_TEMP NUMBER 22 No No 5 1 Active Depth Eight Minimum Temperature NUMBER 27 D8_MAX_TEMP NUMBER 22 No No 5 1 Active Depth Eight Maximum Temperature NUMBER 28 YEAR NUMBER 22 Yes No 4 0 Active Calender Year Measurement Was Taken NUMBER 29 MONTH NUMBER 22 Yes No 2 0 Active Calender Month Measurement Was Taken NUMBER 30 DAY NUMBER 22 Yes No 2 0 Active Calender Day Measurement Was Taken NUMBER 31 HOUR NUMBER 22 Yes No 2 0 Active Time Measurement Was Taken NUMBER 32 REPEATS NUMBER 22 No No 3 0 Active Number Of Times Measurement Was Repeated NUMBER 33 ARCHIVAL_TAG_ID VARCHAR2 10 Yes No Active Archival Tag ID provided by the manufacturer. VARCHAR2 34 ID NUMBER 22 Yes Yes 38 Active Sequential Key NUMBER 7061 CTS_PAT_PDT_PERF_V Published / External Completed PAT PDT Performance View Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT PAT PDT Performance View 1 ARCHIVAL_TAG_ID VARCHAR2 10 Yes No Active Archival Tag ID provided by the manufacturer. VARCHAR2 2 PDT_HISTOGRAM_COUNT NUMBER 22 No No 38 Active Histogram Count NUMBER 3 RELEASE_DATE DATE 7 No No Active Date Tag Was Applied On Fish DATE 4 ACTUAL_POP_OFF_DATE DATE 7 No No Active Date Tag Popped Off Of The Fish DATE 7062 CTS_PAT_RAW Published / External Completed Raw Data Transmitted By The satelite Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Raw Data Transmitted By The satelite 1 ARGOS_PTT_ID VARCHAR2 10 Yes No Active The unique PTT id of the transmitter used by the Argos Satellite Transmission Service provider. VARCHAR2 2 RECEPTION_DATE DATE 7 Yes No Active The date the data was received by the satellite. DATE 3 RECEPTION_TIME VARCHAR2 10 Yes No Active The time the data was received by the satellite. VARCHAR2 4 BYTE01 NUMBER 22 No No 38 Active The first byte transmitted by the transmitter to the satellite. NUMBER 5 BYTE02 NUMBER 22 No No 38 Active The second byte transmitted by the transmitter to the satellite. NUMBER 6 BYTE03 NUMBER 22 No No 38 Active The third byte transmitted by the transmitter to the satellite. NUMBER 7 BYTE04 NUMBER 22 No No 38 Active The fourth byte transmitted by the transmitter to the satellite. NUMBER 8 BYTE05 NUMBER 22 No No 38 Active The fifth byte transmitted by the transmitter to the satellite. NUMBER 9 BYTE06 NUMBER 22 No No 38 Active The sixth byte transmitted by the transmitter to the satellite. NUMBER 10 BYTE07 NUMBER 22 No No 38 Active The seventh byte transmitted by the transmitter to the satellite. NUMBER 11 BYTE08 NUMBER 22 No No 38 Active The eigth byte transmitted by the transmitter to the satellite. NUMBER 12 BYTE09 NUMBER 22 No No 38 Active The ninth byte transmitted by the transmitter to the satellite. NUMBER 13 BYTE10 NUMBER 22 No No 38 Active The tenth byte transmitted by the transmitter to the satellite. NUMBER 14 BYTE11 NUMBER 22 No No 38 Active The eleventh byte transmitted by the transmitter to the satellite. NUMBER 15 BYTE12 NUMBER 22 No No 38 Active The twelveth byte transmitted by the transmitter to the satellite. NUMBER 16 BYTE13 NUMBER 22 No No 38 Active The thirteenth byte transmitted by the transmitter to the satellite. NUMBER 17 BYTE14 NUMBER 22 No No 38 Active The fourteenth byte transmitted by the transmitter to the satellite. NUMBER 18 BYTE15 NUMBER 22 No No 38 Active The fifteenth byte transmitted by the transmitter to the satellite. NUMBER 19 BYTE16 NUMBER 22 No No 38 Active The sixteenth byte transmitted by the transmitter to the satellite. NUMBER 20 BYTE17 NUMBER 22 No No 38 Active The seventeenth byte transmitted by the transmitter to the satellite. NUMBER 21 BYTE18 NUMBER 22 No No 38 Active The eigthteenth byte transmitted by the transmitter to the satellite. NUMBER 22 BYTE19 NUMBER 22 No No 38 Active The nineteenth byte transmitted by the transmitter to the satellite. NUMBER 23 BYTE20 NUMBER 22 No No 38 Active The twentieth byte transmitted by the transmitter to the satellite. NUMBER 24 BYTE21 NUMBER 22 No No 38 Active The 21st byte transmitted by the transmitter to the satellite. NUMBER 25 BYTE22 NUMBER 22 No No 38 Active The 22nd byte transmitted by the transmitter to the satellite. NUMBER 26 BYTE23 NUMBER 22 No No 38 Active The 23rd byte transmitted by the transmitter to the satellite. NUMBER 27 BYTE24 NUMBER 22 No No 38 Active The 24th byte transmitted by the transmitter to the satellite. NUMBER 28 BYTE25 NUMBER 22 No No 38 Active The 25th byte transmitted by the transmitter to the satellite. NUMBER 29 BYTE26 NUMBER 22 No No 38 Active The 26th byte transmitted by the transmitter to the satellite. NUMBER 30 BYTE27 NUMBER 22 No No 38 Active The 27th byte transmitted by the transmitter to the satellite. NUMBER 31 BYTE28 NUMBER 22 No No 38 Active The 28th byte transmitted by the transmitter to the satellite. NUMBER 32 BYTE29 NUMBER 22 No No 38 Active The 29th byte transmitted by the transmitter to the satellite. NUMBER 33 BYTE30 NUMBER 22 No No 38 Active The 30th byte transmitted by the transmitter to the satellite. NUMBER 34 BYTE31 NUMBER 22 No No 38 Active The 31st byte transmitted by the transmitter to the satellite. NUMBER 35 BYTE32 NUMBER 22 No No 38 Active The 32nd byte transmitted by the transmitter to the satellite. NUMBER 36 YEAR NUMBER 22 Yes No 4 0 Active The year the data was collected by the tag. NUMBER 37 MONTH NUMBER 22 Yes No 2 0 Active The month the data was collected by the tag. NUMBER 38 DAY NUMBER 22 Yes No 2 0 Active The day the data was collected by the tag. NUMBER 39 HOUR NUMBER 22 Yes No 2 0 Active The hour the data was collected by the tag. NUMBER 40 DATE_CHECKSUM NUMBER 22 No No 38 Active Error catching values developed by the tag manufacturer. NUMBER 41 DEPTH_CHECKSUM NUMBER 22 No No 38 Active Error catching values developed by the tag manufacturer. NUMBER 42 TEMP_CHECKSUM NUMBER 22 No No 38 Active Error catching values developed by the tag manufacturer. NUMBER 43 LOCATION_CHECKSUM NUMBER 22 No No 38 Active Error catching values developed by the tag manufacturer. NUMBER 44 ARCHIVAL_TAG_ID VARCHAR2 10 Yes No Active Archival Tag ID provided by the manufacturer. VARCHAR2 45 ID NUMBER 22 Yes Yes 38 Active Sequence to give each record a unique identifier. NUMBER 7063 CTS_PAT_STATUS Published / External Completed The status of the tag at the time of transmission. Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT The status of the tag at the time of transmission. 1 ARGOS_PTT_ID VARCHAR2 10 Yes No Active The unique PTT id of the transmitter used by the Argos Satellite Transmission Service provider. VARCHAR2 2 RECEPTION_DATE DATE 7 Yes No Active The data the satellite received the data from the transmitter. DATE 3 RECEPTION_TIME VARCHAR2 10 Yes No Active The time the satellite received the data from the transmitter. VARCHAR2 4 TRANSMISSIONS NUMBER 22 No No 10 0 Active The number of transmissions received. NUMBER 5 TRANSMISSION_TIME VARCHAR2 10 No No Active The amount of time it took to receive the transmissions. VARCHAR2 6 DEEP_DIVE_COUNT NUMBER 22 No No 4 0 Active The number of deep dives registered by the tag. NUMBER 7 BATTERY_VOLTAGE NUMBER 22 No No 5 2 Active Current battery voltage at time of transmission. Gives an indication of how many transmissions the tag could send. NUMBER 8 PREMATURE_RELEASE_DEPTH NUMBER 22 No No 5 0 Active The depth at which a premature release occured (if any). NUMBER 9 PR_DETECTION_YEAR NUMBER 22 No No 4 0 Active The year when the premature release occurred. NUMBER 10 PR_DETECTION_MONTH NUMBER 22 No No 2 0 Active The month when the premature release occurred. NUMBER 11 PR_DETECTION_DAY NUMBER 22 No No 2 0 Active The day when the premature release occurred. NUMBER 12 PR_DETECTION_HOUR NUMBER 22 No No 2 0 Active The hour when the premature release occurred. NUMBER 13 PR_DETECTION_MINUTE NUMBER 22 No No 2 0 Active The minute when the premature release occurred. NUMBER 14 LAST_DEEP_DIVE_M NUMBER 22 No No 6 2 Active The depth of the last deepest dive in meters. NUMBER 15 LAST_DEEP_DIVE_YEAR NUMBER 22 No No 4 0 Active The year when the deepest dive occurred. NUMBER 16 LAST_DEEP_DIVE_MONTH NUMBER 22 No No 2 0 Active The month when the deepest dive occurred. NUMBER 17 LAST_DEEP_DIVE_DAY NUMBER 22 No No 2 0 Active The day when the deepest dive occurred. NUMBER 18 LAST_DEEP_DIVE_HOUR NUMBER 22 No No 2 0 Active The hour when the deepest dive occurred. NUMBER 19 LAST_DEEP_DIVE_MINUTE NUMBER 22 No No 2 0 Active The minute when the deepest dive occurred. NUMBER 20 ARCHIVAL_TAG_ID VARCHAR2 10 Yes No Active Archival Tag ID provided by the manufacturer. VARCHAR2 21 ID NUMBER 22 Yes Yes 38 Active Sequence to give each record a unique identifier. NUMBER 7064 CTS_PAT_STATUS_PERF_V Published / External Completed PAT Status Performance View Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT PAT Status Performance View 1 ARCHIVAL_TAG_ID VARCHAR2 10 Yes No Active Archival Tag ID provided by the manufacturer. VARCHAR2 2 MAX_TRANSMISSIONS NUMBER 22 No No 38 Active Maximum Number Of Transmissions NUMBER 3 MAX_BATTERY NUMBER 22 No No 38 Active Maximum Battery Voltage NUMBER 4 MIN_BATTERY NUMBER 22 No No 38 Active Minimum Battery Voltage NUMBER 7065 CTS_PAT_TAD Published / External Completed Time At Depth (TAD) - the amount of time the tag spent in a pre-defined depth bin. Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Time At Depth (TAD) - the amount of time the tag spent in a pre-defined depth bin. 1 ARGOS_PTT_ID VARCHAR2 10 Yes No Active The unique PTT id of the transmitter used by the Argos Satellite Transmission Service provider. VARCHAR2 2 RECEPTION_DATE DATE 7 Yes No Active The date the data was received by the satellite. DATE 3 RECEPTION_TIME VARCHAR2 10 Yes No Active The time the data was received by the satellite. VARCHAR2 4 BIN_1 FLOAT 22 No No 9 Active The percentage of time the tag spent in the first depth bin as defined by the user and reported in CTS_PAT_TAG_BIN. FLOAT 5 BIN_2 FLOAT 22 No No 9 Active The percentage of time the tag spent in the second depth bin as defined by the user and reported in CTS_PAT_TAG_BIN. FLOAT 6 BIN_3 FLOAT 22 No No 9 Active The percentage of time the tag spent in the third depth bin as defined by the user and reported in CTS_PAT_TAG_BIN. FLOAT 7 BIN_4 FLOAT 22 No No 9 Active The percentage of time the tag spent in the fourth depth bin as defined by the user and reported in CTS_PAT_TAG_BIN. FLOAT 8 BIN_5 FLOAT 22 No No 9 Active The percentage of time the tag spent in the fifth depth bin as defined by the user and reported in CTS_PAT_TAG_BIN. FLOAT 9 BIN_6 FLOAT 22 No No 9 Active The percentage of time the tag spent in the sixth depth bin as defined by the user and reported in CTS_PAT_TAG_BIN. FLOAT 10 BIN_7 FLOAT 22 No No 9 Active The percentage of time the tag spent in the seventh depth bin as defined by the user and reported in CTS_PAT_TAG_BIN. FLOAT 11 BIN_8 FLOAT 22 No No 9 Active The percentage of time the tag spent in the eigth depth bin as defined by the user and reported in CTS_PAT_TAG_BIN. FLOAT 12 BIN_9 FLOAT 22 No No 9 Active The percentage of time the tag spent in the ninth depth bin as defined by the user and reported in CTS_PAT_TAG_BIN. FLOAT 13 BIN_10 FLOAT 22 No No 9 Active The percentage of time the tag spent in the tenth depth bin as defined by the user and reported in CTS_PAT_TAG_BIN. FLOAT 14 BIN_11 FLOAT 22 No No 9 Active The percentage of time the tag spent in the eleventh depth bin as defined by the user and reported in CTS_PAT_TAG_BIN. FLOAT 15 BIN_12 FLOAT 22 No No 9 Active The percentage of time the tag spent in the twelvth depth bin as defined by the user and reported in CTS_PAT_TAG_BIN. FLOAT 16 YEAR NUMBER 22 Yes No 4 0 Active The year the data was collected. NUMBER 17 MONTH NUMBER 22 Yes No 2 0 Active The month the data was collected. NUMBER 18 DAY NUMBER 22 Yes No 2 0 Active The day the data was collected. NUMBER 19 HOUR NUMBER 22 Yes No 2 0 Active The hour the data was collected. NUMBER 20 REPEATS NUMBER 22 No No 4 0 Active The number of times the data from this day was transmitted. NUMBER 21 ARCHIVAL_TAG_ID VARCHAR2 10 Yes No Active Archival Tag ID provided by the manufacturer. VARCHAR2 22 ID NUMBER 22 Yes Yes 38 Active Sequence to give each record a unique identifier. NUMBER 7066 CTS_PAT_TAD_PERF_V Published / External Completed PAT TAD Performance View Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT PAT TAD Performance View 1 ARCHIVAL_TAG_ID VARCHAR2 10 Yes No Active Archival Tagn Number VARCHAR2 2 DEPTH_HISTOGRAM_COUNT NUMBER 22 No No 38 Active Depth Histogram Count NUMBER 3 RELEASE_DATE DATE 7 No No Active Date Archival Tag Was Applied DATE 4 ACTUAL_POP_OFF_DATE DATE 7 No No Active Actual Data Arhcival Tag Popped Off Of Fish DATE 7067 CTS_PAT_TAG Published / External Completed Information about the tag, its hardware configuration, and programming parameters. Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Information about the tag, its hardware configuration, and programming parameters. 1 ANIMAL_ID NUMBER 22 No No 10 0 Active The unique identifier for the animal that the tag was attached. Foreign key to the CTS_ANIMALS table. NUMBER 2 ARGOS_PTT_ID VARCHAR2 10 Yes No Active The unique PTT id of the transmitter used by the Argos Satellite Transmission Service provider. VARCHAR2 3 ARCHIVAL_TAG_ID VARCHAR2 10 Yes No Active Archival Tag ID provided by the manufacturer. VARCHAR2 4 INVESTIGATOR_ID NUMBER 22 Yes No 5 0 Active The unique identifier of the investigator that is reponsible for the deployment of the tag. This is a foreign key to the CTS_PAT_INVESTIGATORS table. NUMBER 5 BIN_PROFILE_ID NUMBER 22 Yes No 5 0 Active The id of the bin profile used by this tag. Foreign key to the CTS_PAT_TAG_BIN table. NUMBER 6 TAG_RESOLUTION_ID NUMBER 22 Yes No 38 Active The resolution parameters associated with the tag. Foreign key to the CTS_PAT_TAG_RESOLUTION table. NUMBER 7 PROGRAM_DATE DATE 7 No No Active The date the tag was programmed by the user. DATE 8 RELEASE_DATE DATE 7 No No Active The date the tag was released on an animal. DATE 9 RELEASE_LATITUDE NUMBER 22 No No 38 Active The latitude of the location where the animal and the tag were released. NUMBER 10 RELEASE_LONGITUDE NUMBER 22 No No 38 Active The longitude of the location where the animal and the tag were released. NUMBER 11 POPOFF_LATITUDE NUMBER 22 No No 38 Active The latitude of the location where the tag popped off and began transmitting. NUMBER 12 POPOFF_LONGITUDE NUMBER 22 No No 38 Active The longitude of the location where the tag popped off and began transmitting. NUMBER 13 ACTUAL_POP_OFF_DATE DATE 7 No No Active The actual date when the tag popped off. This may be the date the tag started transmitting or some days before depending on the premature release parameters. DATE 14 PROGRAMMED_POP_OFF_DATE DATE 7 No No Active When the tag was programmed to pop off and begin transmitting. DATE 15 REPORTING_FREQ_HOURS NUMBER 22 No No 38 Active The reporting frequency in hours. This parameter determines how often the tag will summarize the data. The data will be collected and a summary report will be generated for the specified period . NUMBER 16 DEPTH_OPERATIONAL_MIN_MTR NUMBER 22 No No 38 Active The minimum operational depth of the tag. NUMBER 17 DEPTH_OPERATIONAL_MAX_MTR NUMBER 22 No No 38 Active The maximum operational depth of the tag. NUMBER 18 DEPTH_OPERATIONAL_RES_MTR NUMBER 22 No No 38 Active The resolution of the depth sensor. NUMBER 19 LIGHT_OPERATIONAL_MIN_LLU NUMBER 22 No No 38 Active The minimum operational light level. NUMBER 20 LIGHT_OPERATIONAL_MAX_LLU NUMBER 22 No No 38 Active The maximum operational light level. NUMBER 21 TEMP_OPERATIONAL_MIN_C NUMBER 22 No No 38 Active The minimum operational temperature. NUMBER 22 TEMP_OPERATIONAL_MAX_C NUMBER 22 No No 38 Active The maximum operational temperature. NUMBER 23 LIGHT_OPERATIONAL_RES_LLU NUMBER 22 No No 38 Active The resolution of the light sensor. NUMBER 24 TEMP_OPERATIONAL_RES_C NUMBER 22 No No 38 Active The resolution of the temperature sensor. NUMBER 25 DEPTH_SAMPLE_FREQ_MINUTES NUMBER 22 No No 38 Active How often the depth will be sampled. NUMBER 26 TEMP_SAMPLE_FREQ_MINUTES NUMBER 22 No No 38 Active How often the temperature will be sampled. NUMBER 27 LIGHT_SAMPLE_FREQ_MINUTES NUMBER 22 No No 38 Active How often the light level will be sampled. NUMBER 28 RTC_TEMP_SAMPLE_FREQ_MINUTES NUMBER 22 No No 38 Active How often the RTC Temperature will be sampled. NUMBER 29 BATTERY_SAMPLE_FREQ_MINUTES NUMBER 22 No No 38 Active How often the battery level will be sampled. NUMBER 30 DEPTH_TEMP_SAMPLE_FREQ_MINUTES NUMBER 22 No No 38 Active How often the minimum and maximum temperature at depth will be sampled. NUMBER 31 HISTOGRAM_MEMORY_KB NUMBER 22 No No 38 Active The amount of system memory dedicated to storing histograms. NUMBER 32 HISTOGRAM_PRIORITY VARCHAR2 10 No No Active The priority of transmitting the histogram data. VARCHAR2 33 PDT_MEMORY_KB NUMBER 22 No No 38 Active The amount of system memory dedicated to storing PDT data. NUMBER 34 PDT_PRIORITY VARCHAR2 10 No No Active The priority of transmitting the PDT data. VARCHAR2 35 LOCATION_MEMORY_KB NUMBER 22 No No 38 Active The amount of system memory dedicated to storing location information. NUMBER 36 LOCATION_PRIORITY VARCHAR2 10 No No Active The priority of transmitting the location data. VARCHAR2 37 ARCHIVAL_MEMORY_KB NUMBER 22 No No 38 Active The amount of system memory dedicated to storing the high-frequency archival data. NUMBER 38 STATUS_INTERVAL NUMBER 22 No No 38 Active How often the transmitter will send status messages to the satellite. NUMBER 39 PREMATURE_RELEASE VARCHAR2 1 No No Active Is the Premature Release feature enabled. VARCHAR2 40 PREMATURE_RELEASE_TIME_HRS NUMBER 22 No No 38 Active The amount of time used to determine if the premature release criteria has been met. NUMBER 41 NUMBER_OF_OUTLIERS NUMBER 22 No No 38 Active The number of outliers allowed during the evaluation of the premature release criteria. NUMBER 42 DETECTION_DEPTH NUMBER 22 No No 38 Active The depth to begin implementing the premature release criteria. NUMBER 43 FIRST_TRANSMISSION_DATE DATE 7 No No Active The date the first transmission was received by the satellite. DATE 44 DEPLOYER VARCHAR2 30 No No Active The person who deployed the tag. VARCHAR2 45 HOOK_LOCATION VARCHAR2 20 No No Active The location of the hook on the animal. VARCHAR2 46 HOOK_TYPE VARCHAR2 20 No No Active The type of hook used to catch the animal. VARCHAR2 47 FISHING_METHOD VARCHAR2 50 No No Active The fishing method used to capture the animal. VARCHAR2 48 BLEEDING VARCHAR2 20 No No Active Whether the animal was bleeding during tagging. VARCHAR2 49 BAIT_TYPE VARCHAR2 20 No No Active The bait used to capture the animal. VARCHAR2 50 SNOOTER VARCHAR2 1 No No Active Did the deployer use a Snooter to capture and restrain the animal. VARCHAR2 51 RESUSCITATION VARCHAR2 1 No No Active Was the animal resuscitated prior to release. VARCHAR2 52 RELEASE_CONDITION VARCHAR2 50 No No Active The condition of the animal when it was released. VARCHAR2 53 COMMENTS VARCHAR2 500 No No Active Any comments pertaining to the capture, tagging, and release of the animal. VARCHAR2 54 RESUSCITATION_TIME NUMBER 22 No No 38 Active The amount of time the animal was resuscitated. NUMBER 55 BLEEDING_TIME NUMBER 22 No No 38 Active The amount of time the animal was bleeding. NUMBER 56 PAT_NAME VARCHAR2 50 No No Active The name given to the Pop-off Archival Tag. VARCHAR2 57 RELEAST_TIME_HOUR NUMBER 22 No No 38 Active The hour the animal and the tag were released. NUMBER 58 RELEASE_TIME_MINUTE NUMBER 22 No No 38 Active The minute the animal and the tag were released. NUMBER 59 DETECTION_RES NUMBER 22 No No 5 0 Active The resolution used for the premature release detection. NUMBER 60 TRIP_ID VARCHAR2 6 No No Active The unique identifier for the trip. VARCHAR2 61 HOOK_REMOVED VARCHAR2 1 No No Active Was the hook removed from the animal prior to release. VARCHAR2 62 ATTACHED_LINE_LENGTH FLOAT 22 No No 126 Active The length of line attached to the animal if the hook was not removed. FLOAT 63 REC_MESSAGES NUMBER 22 No No 38 Active The number of messages received by the tag. Used as an indicator of tag performance. NUMBER 64 CONV_TAG_AGENCY VARCHAR2 3 No No Active Conventional Tag Agency VARCHAR2 65 CONV_TAG_ID VARCHAR2 8 No No Active Conventional Tag ID VARCHAR2 66 DEPLOY_GEOM SDO_GEOMETRY 1 No No Active The Oracle SDO_Geometry representing the point location of the deployment. SDO_GEOMETRY 67 POPOFF_GEOM SDO_GEOMETRY 1 No No Active The Oracle SDO_Geometry representing the point location of the pop-off/first transmission. SDO_GEOMETRY 68 OTRACK_GEOM SDO_GEOMETRY 1 No No Active The Oracle SDO_Geometry representing the polyline of the original track derived from the light-based geolocations. SDO_GEOMETRY 69 PTRACK_GEOM SDO_GEOMETRY 1 No No Active The Oracle SDO_Geometry representing the polyline of the probability track generated by the Kalman Filter algorithm. SDO_GEOMETRY 70 STRACK_GEOM SDO_GEOMETRY 1 No No Active The Oracle SDO_Geometry representing the polyline of the smoothed track generated by the Kalman Filter algorithm. SDO_GEOMETRY 71 VERSION NUMBER 22 Yes No 38 Active The version of the pop-off archival tag. NUMBER 72 MANUFACTURE_DATE DATE 7 Yes No Active The date the tag was manufactured. DATE 73 ID NUMBER 22 Yes Yes 38 Active Sequence to give each record a unique identifier. NUMBER 7068 CTS_PAT_TAG_BIN Published / External Completed The bins defined for each tag. Each tag can be programmed to collect data in different temperature and depth bins. Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT The bins defined for each tag. Each tag can be programmed to collect data in different temperature and depth bins. 1 BIN_PROFILE_ID NUMBER 22 Yes Yes 5 0 Active Unique identifier given to each record. NUMBER 2 BIN01 NUMBER 22 No No 5 0 Active The percentage of time the tag spent in the first temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN. NUMBER 3 BIN02 NUMBER 22 No No 5 0 Active The maximum depth of the second bin. NUMBER 4 BIN03 NUMBER 22 No No 5 0 Active The maximum depth of the third bin. NUMBER 5 BIN04 NUMBER 22 No No 5 0 Active The maximum depth of the fourth bin. NUMBER 6 BIN05 NUMBER 22 No No 5 0 Active The maximum depth of the fifth bin. NUMBER 7 BIN06 NUMBER 22 No No 5 0 Active The maximum depth of the sixth bin. NUMBER 8 BIN07 NUMBER 22 No No 5 0 Active The maximum depth of the seventh bin. NUMBER 9 BIN08 NUMBER 22 No No 5 0 Active The maximum depth of the eigth bin. NUMBER 10 BIN09 NUMBER 22 No No 5 0 Active The maximum depth of the ninth bin. NUMBER 11 BIN10 NUMBER 22 No No 5 0 Active The maximum depth of the tenth bin. NUMBER 12 BIN11 NUMBER 22 No No 5 0 Active The maximum depth of the eleventh bin. NUMBER 13 BIN12 NUMBER 22 No No 5 0 Active The maximum depth of the 12th bin. NUMBER 14 BIN13 NUMBER 22 No No 5 0 Active The maximum temperature of the first bin. NUMBER 15 BIN14 NUMBER 22 No No 5 0 Active The maximum temperature of the second bin. NUMBER 16 BIN15 NUMBER 22 No No 5 0 Active The maximum temperature of the third bin. NUMBER 17 BIN16 NUMBER 22 No No 5 0 Active The maximum temperature of the fourth bin. NUMBER 18 BIN17 NUMBER 22 No No 5 0 Active The maximum temperature of the fifth bin. NUMBER 19 BIN18 NUMBER 22 No No 5 0 Active The maximum temperature of the sixth bin. NUMBER 20 BIN19 NUMBER 22 No No 5 0 Active The maximum temperature of the seventh bin. NUMBER 21 BIN20 NUMBER 22 No No 5 0 Active The maximum temperature of the eigth bin. NUMBER 22 BIN21 NUMBER 22 No No 5 0 Active The maximum temperature of the ninth bin. NUMBER 23 BIN22 NUMBER 22 No No 5 0 Active The maximum temperature of the tenth bin. NUMBER 24 BIN23 NUMBER 22 No No 5 0 Active The maximum temperature of the eleventh bin. NUMBER 25 BIN24 NUMBER 22 No No 5 0 Active The maximum temperature of the 12th bin. NUMBER 7069 CTS_PAT_TAG_DAYS_V Published / External Completed View Of PAT information With Decodes Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT View Of PAT information With Decodes 1 ID NUMBER 22 Yes No 38 Active Sequential Key NUMBER 2 ARCHIVAL_TAG_ID VARCHAR2 10 Yes No Active Archival Tag ID provided by the manufacturer. VARCHAR2 3 PAT_NAME VARCHAR2 50 No No Active Manufacturer Of Archival Tag VARCHAR2 4 INVESTIGATOR_ID NUMBER 22 Yes No 5 0 Active Key to Principal Investigator Table NUMBER 5 RELEASE_DATE DATE 7 No No Active Date Archival Tag was applied DATE 6 PROGRAMMED_POP_OFF_DATE DATE 7 No No Active Date That Tag was Programmed To Popoff DATE 7 ACTUAL_POP_OFF_DATE DATE 7 No No Active Actual Date Tag Popped Off DATE 8 FIRST_TRANSMISSION_DATE DATE 7 No No Active Date Of First Transmission Of Archival Tag DATE 9 DAYS_AT_LARGE NUMBER 22 No No 38 Active Number Of Days Tag was sending data NUMBER 10 DAYS_ON_ANIMAL NUMBER 22 No No 38 Active Number of days tag was on animal NUMBER 11 FULL_DEPLOY_100 NUMBER 22 No No 38 Active Full Deployment % NUMBER 12 ACTUAL_DEPLOY_100 NUMBER 22 No No 38 Active Actual Deployment % NUMBER 13 LOCATION_PRIORITY VARCHAR2 10 No No Active Location Priority VARCHAR2 14 HISTOGRAM_PRIORITY VARCHAR2 10 No No Active Histogram Priority VARCHAR2 15 PDT_PRIORITY VARCHAR2 10 No No Active PDT Priority VARCHAR2 16 REPORTING_FREQ_HOURS NUMBER 22 No No 38 Active Reporting Frequency In Hours NUMBER 17 LOCATION_MEMORY_KB NUMBER 22 No No 38 Active LOcation Memory In KB NUMBER 18 HISTOGRAM_MEMORY_KB NUMBER 22 No No 38 Active Histogram Memory In KB NUMBER 19 PDT_MEMORY_KB NUMBER 22 No No 38 Active PDT Memory In KB NUMBER 20 NAME VARCHAR2 100 No No Active Name Of Primary Investigator VARCHAR2 7070 CTS_PAT_TAG_PERFORMANCE_V Published / External Completed PAT TAG Performance View Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT PAT TAG Performance View 1 ID NUMBER 22 Yes No 38 Active Sequential Key NUMBER 2 NAME VARCHAR2 100 No No Active Name Of Primary Investigator VARCHAR2 3 ARCHIVAL_TAG_ID VARCHAR2 10 Yes No Active Archival Tag Number VARCHAR2 4 PAT_NAME VARCHAR2 50 No No Active Archival Tag Name VARCHAR2 5 INVESTIGATOR_ID NUMBER 22 Yes No 5 0 Active Key To Primary Investigator Table NUMBER 6 RELEASE_DATE DATE 7 No No Active Date Tag was applied to animal DATE 7 PROGRAMMED_POP_OFF_DATE DATE 7 No No Active Date Tag is programmed to fall off of animal DATE 8 ACTUAL_POP_OFF_DATE DATE 7 No No Active Actual Date Tag popped Off of animal DATE 9 FIRST_TRANSMISSION_DATE DATE 7 No No Active First Tranmission date Of archival tag DATE 10 DAYS_AT_LARGE NUMBER 22 No No 38 Active Number Of Days Archival Tag is transmitting data NUMBER 11 DAYS_ON_ANIMAL NUMBER 22 No No 38 Active Number Of Days Archival Tag is on animal NUMBER 12 FULL_DEPLOY_100 NUMBER 22 No No 38 Active Full Deployment % NUMBER 13 ACTUAL_DEPLOY_100 NUMBER 22 No No 38 Active Actual Deployment % NUMBER 14 LOCATION_PRIORITY VARCHAR2 10 No No Active Location Priority VARCHAR2 15 HISTOGRAM_PRIORITY VARCHAR2 10 No No Active Histogram Priority VARCHAR2 16 PDT_PRIORITY VARCHAR2 10 No No Active PDT Priority VARCHAR2 17 REPORTING_FREQ_HOURS NUMBER 22 No No 38 Active Archival Tag Reporting Frequency In Hours NUMBER 18 LOCATION_MEMORY_KB NUMBER 22 No No 38 Active Location Memory IN KB NUMBER 19 HISTOGRAM_MEMORY_KB NUMBER 22 No No 38 Active Histogram Memory in KB NUMBER 20 PDT_MEMORY_KB NUMBER 22 No No 38 Active PDT Memory In KB NUMBER 21 DEPTH_HISTOGRAM_COUNT NUMBER 22 No No 38 Active Depth Histogram Count NUMBER 22 TEMP_HISTOGRAM_COUNT NUMBER 22 No No 38 Active Temporary Histogram Count NUMBER 23 PDT_HISTOGRAM_COUNT NUMBER 22 No No 38 Active PDT Histogram Count NUMBER 24 LOCATIONS_COUNT NUMBER 22 No No 38 Active Number Of Locations NUMBER 25 MESSAGES NUMBER 22 No No 38 Active Number Of Messages NUMBER 26 MAX_TRANSMISSIONS NUMBER 22 No No 38 Active Maimum Number Of Transmissions NUMBER 27 MAX_BATTERY NUMBER 22 No No 38 Active Maximum Battery Voltage NUMBER 28 MIN_BATTERY NUMBER 22 No No 38 Active Minimum Battert Voltage NUMBER 7071 CTS_PAT_TAG_RESOLUTION Published / External Completed The resolution of the sensors (depth, temperature, light, etc.) used in the tag. Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT The resolution of the sensors (depth, temperature, light, etc.) used in the tag. 1 TAG_RESOLUTION_ID NUMBER 22 Yes No 38 Active Identifier to associate all resolution records to a particular resolution profile. NUMBER 2 TYPE VARCHAR2 10 Yes No Active The type of sensor (light, temperature, depth, etc.) VARCHAR2 3 MINIMUM NUMBER 22 Yes No 38 Active The minimum operating parameter of the sensor. NUMBER 4 RESOLUTION NUMBER 22 No No 38 Active The resolution of the sensor. NUMBER 5 ID NUMBER 22 Yes Yes 38 Active Unique identifer for each resolution record. NUMBER 7072 CTS_PAT_TAT Published / External Completed Time At Temperature (TAT) - the amount of time the tag spent in a pre-defined temperature bin. Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Time At Temperature (TAT) - the amount of time the tag spent in a pre-defined temperature bin. 1 ARGOS_PTT_ID VARCHAR2 10 Yes No Active The unique PTT id of the transmitter used by the Argos Satellite Transmission Service provider. VARCHAR2 2 RECEPTION_DATE DATE 7 Yes No Active The date the data was received by the satellite. DATE 3 RECEPTION_TIME VARCHAR2 10 Yes No Active The time the data was received by the satellite. VARCHAR2 4 BIN_1 FLOAT 22 No No 9 Active The percentage of time the tag spent in the first temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN. FLOAT 5 BIN_2 FLOAT 22 No No 9 Active The percentage of time the tag spent in the second temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN. FLOAT 6 BIN_3 FLOAT 22 No No 9 Active The percentage of time the tag spent in the third temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN. FLOAT 7 BIN_4 FLOAT 22 No No 9 Active The percentage of time the tag spent in the fourth temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN. FLOAT 8 BIN_5 FLOAT 22 No No 9 Active The percentage of time the tag spent in the fifth temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN. FLOAT 9 BIN_6 FLOAT 22 No No 9 Active The percentage of time the tag spent in the sixth temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN. FLOAT 10 BIN_7 FLOAT 22 No No 9 Active The percentage of time the tag spent in the seventh temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN. FLOAT 11 BIN_8 FLOAT 22 No No 9 Active The percentage of time the tag spent in the eighth temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN. FLOAT 12 BIN_9 FLOAT 22 No No 9 Active The percentage of time the tag spent in the ninth temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN. FLOAT 13 BIN_10 FLOAT 22 No No 9 Active The percentage of time the tag spent in the tenth temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN. FLOAT 14 BIN_11 FLOAT 22 No No 9 Active The percentage of time the tag spent in the eleventh temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN. FLOAT 15 BIN_12 FLOAT 22 No No 9 Active The percentage of time the tag spent in the twelveth temperature bin as defined by the user and reported in CTS_PAT_TAG_BIN. FLOAT 16 YEAR NUMBER 22 Yes No 4 0 Active The year the data was collected. NUMBER 17 MONTH NUMBER 22 Yes No 2 0 Active The month the data was collected. NUMBER 18 DAY NUMBER 22 Yes No 2 0 Active The day the data was collected. NUMBER 19 HOUR NUMBER 22 Yes No 2 0 Active The hour the data was collected. NUMBER 20 REPEATS NUMBER 22 No No 4 0 Active The number of times the data from this day was transmitted. NUMBER 21 ARCHIVAL_TAG_ID VARCHAR2 10 Yes No Active Archival Tag ID provided by the manufacturer. VARCHAR2 22 ID NUMBER 22 Yes Yes 38 Active Sequence to give each record a unique identifier. NUMBER 7073 CTS_PAT_TAT_PERF_V Published / External Completed PAT TAT Performance View Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT PAT TAT Performance View 1 ARCHIVAL_TAG_ID VARCHAR2 10 Yes No Active Archival Tag Applied VARCHAR2 2 TEMP_HISTOGRAM_COUNT NUMBER 22 No No 38 Active Temporary Histogram Count Per Tag NUMBER 3 RELEASE_DATE DATE 7 No No Active Date Tag was applied to animal DATE 4 ACTUAL_POP_OFF_DATE DATE 7 No No Active Date Tag popped off of animal DATE 7074 CTS_PHYSICAL_DATA Published / External Completed Environmental observations of the location where the animal was caught. Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Environmental observations of the location where the animal was caught. 1 PHYSICAL_DATA_ID NUMBER 22 Yes Yes 6 0 Active Code for agency collecting the environment data. NUMBER 2 WATERCOLOR VARCHAR2 3 No No Active Code to identify water color. VARCHAR2 3 WATER_DEPTH_M NUMBER 22 No No 4 0 Active Depth of water in feet at site. NUMBER 4 SURFACE_TEMP_DEGC NUMBER 22 No No 4 2 Active The surface temperature of the water in degrees centigrade. NUMBER 5 SURFACE_SALINITY_PPT NUMBER 22 No No 4 2 Active Surface salinity in PARTS/1000 at the site. NUMBER 6 SURFACE_DO_MGPL NUMBER 22 No No 4 1 Active Surface dissolved oxygen at the site (milligrams/liter of water). NUMBER 7 AIR_TEMP_DEGC NUMBER 22 No No 4 1 Active Air temperature at the site in degrees centigrade. NUMBER 8 WIND_SPEED_KNOTS NUMBER 22 No No 2 0 Active Wind speed at the site in knots. NUMBER 9 WIND_DIRECTION_DEG NUMBER 22 No No 3 0 Active Wind direction at the site in compass degrees. NUMBER 10 PERCENT_CLOUD_COVER NUMBER 22 No No 3 0 Active Percentage of cloud cover at the site. NUMBER 11 EDITCYC NUMBER 22 No No 2 0 Active A control field, (0) indicates an add, (1) indicates an update. Once update, records are stored with a value of 0 in this field. NUMBER 12 EDITDAT DATE 7 No No Active The date the record was initially entered, or last updated, whichever is later. DATE 13 DELEDAT DATE 7 No No Active A control field used to delete existing records from this table. No records are stored with a value in this field. DATE 7075 CTS_PLACES Published / External Completed Table Of Valid Place Codes Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table Of Valid Place Codes 1 PLACE_ID VARCHAR2 3 Yes Yes Active The place code where the tag was found. VARCHAR2 2 PLACE_DESCRIPTION VARCHAR2 30 No No Active Place name. VARCHAR2 7076 CTS_PRIORITY Published / External Completed Table Of Valid Priority Descriptions. Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table Of Valid Priority Descriptions. 1 PRIORITY VARCHAR2 10 No No Active Property Description VARCHAR2 7077 CTS_RECAPTURE_LOOKUP_V Published / External Completed View of Tags Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT View of Tags 1 ANIMAL_ID NUMBER 22 No No 10 0 Active Sequential Key NUMBER 2 INTERACTION_ORDER NUMBER 22 No No 2 0 Active Code To indicate last cycle of release recapture. 1 = initial release, 2 = recpature,3=release after recapture,4=recapture after second release etc NUMBER 3 AGENCY_ID VARCHAR2 3 No No Active Agency Cose Associated With First Tag VARCHAR2 4 TAG_ID VARCHAR2 8 No No Active First Tag Number VARCHAR2 5 NEXT_TAG_AGENCY_ID VARCHAR2 3 No No Active Code Of Agency Associated With Second Tag On Record VARCHAR2 6 NEXT_TAG_ID VARCHAR2 8 No No Active Tag Number Of Second Tag On Record VARCHAR2 7 TAG_DATE VARCHAR2 10 No No Active Date Tag Was Applied VARCHAR2 7078 CTS_RELEASE_CONDITIONS Published / External Completed Table Of Valid Release Conditions Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table Of Valid Release Conditions 1 RELEASE_CONDITION VARCHAR2 50 No No Active Release condition VARCHAR2 7079 CTS_RETURNED_TAGS Published / External Completed Used To hold information on returned tags until they are processed Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Used To hold information on returned tags until they are processed 1 TAG_ID VARCHAR2 8 No No Active Tag Number VARCHAR2 2 TAG_DATE DATE 7 No No Active Date Animal was recaptured DATE 3 MY_COMMENTS VARCHAR2 200 No No Active ANy Other comment about this fish or record VARCHAR2 7080 CTS_SAMPLES Published / External Completed Data Table describing sampling done Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Data Table describing sampling done 1 SAMPLE_ID NUMBER 22 Yes Yes 6 0 Active Code for agency collecting the sample data. NUMBER 2 SAMPLE_TYPE VARCHAR2 30 Yes Yes Active Code to indicate type of sample done VARCHAR2 3 AMOUNT_SAMPLED NUMBER 22 No No 6 2 Active Measurement of the quantity of what was sampled. NUMBER 4 SAMPLE_UNITS VARCHAR2 4 No No Active Units Of Sampling Meausrements VARCHAR2 5 SAMPLE_DESCRIPTION VARCHAR2 200 No No Active Description Of Sampling Methodology VARCHAR2 6 EDITCYC NUMBER 22 No No 2 0 Active A control field, (0) indicates an add, (1) indicates an update. Once update, records are stored with a value of 0 in this field. NUMBER 7 EDITDAT DATE 7 No No Active The date the record was initially entered, or last updated, whichever is later. DATE 8 DELEDAT DATE 7 No No Active A control field used to delete existing records from this table. No records are stored with a value in this field. DATE 7081 CTS_SEX Published / External Completed Table Of Valid Sex Codes Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table Of Valid Sex Codes 1 SEX_ID VARCHAR2 1 Yes No Active Mnemonic Sex Code VARCHAR2 2 SEX_DESCRIPTION VARCHAR2 10 Yes No Active Code Description VARCHAR2 7082 CTS_SPECIES Published / External Completed Table Of Valid Species Codes Used in NMFS Cooperative Tagging System Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table Of Valid Species Codes Used in NMFS Cooperative Tagging System 1 SPECIES_ID VARCHAR2 3 Yes Yes Active The 3 letter species code Used in the CTS System VARCHAR2 2 COMMON_NAME VARCHAR2 21 No No Active The common name for the fish species. VARCHAR2 3 SCIENTIFIC_NAME VARCHAR2 46 No No Active The scientific name for the fish's species. VARCHAR2 4 MAX_SUST_VELOCITY NUMBER 22 No No 3 0 Active Maxium Sustained Velocity (often null) NUMBER 7083 CTS_STATES Published / External Completed Table Of Valid State Codes Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table Of Valid State Codes 1 STATE_ID VARCHAR2 2 Yes Yes Active Mnemonic state code. VARCHAR2 2 STATE_NAME VARCHAR2 30 No No Active The state name. VARCHAR2 7084 CTS_STATES_V Published / External Completed View Of Valid State Codes with the associated state name Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT View Of Valid State Codes with the associated state name 1 STATE_ID VARCHAR2 30 No No Active State Code VARCHAR2 2 STATE_NAME VARCHAR2 30 No No Active State Name VARCHAR2 7085 CTS_SUBAREAS Published / External Completed Table Of Valid subarea codes Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table Of Valid subarea codes 1 SUBAREA_ID VARCHAR2 3 Yes No Active Menmonic Subarea Code VARCHAR2 2 SUBAREA_DESCRIPTION VARCHAR2 50 No No Active Subarea Description VARCHAR2 3 SUBAREA_COUNTRY VARCHAR2 10 No No Active Country Code Associated WIth Subarea VARCHAR2 4 SUBAREA_STATE VARCHAR2 10 No No Active State Code Associated WIth Subarea VARCHAR2 7086 CTS_TAGGER_TYPE Published / External Completed Table Of Valid Tagger Types Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table Of Valid Tagger Types 1 TAGGER_ID VARCHAR2 3 Yes No Active Tagger Type Mnemonic Code VARCHAR2 2 TAGGER_DESCRIPTION VARCHAR2 50 No No Active Tagger Type Description VARCHAR2 7087 CTS_TAGGING_LOCATION Published / External Completed Table Of Valid Location Codes Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table Of Valid Location Codes 1 LOCATION_ID VARCHAR2 3 Yes No Active Mnemonic Location Code VARCHAR2 2 LOCATION_DESCRIPTION VARCHAR2 50 No No Active LOcation Description VARCHAR2 7088 CTS_TAGGING_METHODS Published / External Completed Table Of Valid Tagging Methods Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table Of Valid Tagging Methods 1 METHOD_ID NUMBER 22 Yes Yes 6 0 Active Code identifying this description of the methodology used in the tagging of this animal. NUMBER 2 TAG_TIME_MINS NUMBER 22 No No 4 0 Active Time taken to tag and release the animal. NUMBER 3 TAGGING_PLATFORM VARCHAR2 1 No No Active Place fish was tagged: B-boat, W-water, N-net, U-unknown VARCHAR2 4 HOOKS_REMOVED VARCHAR2 1 No No Active Were hooks removed from animal?Y-yes, N-no, U-unknown VARCHAR2 5 ANIMAL_RETAINED VARCHAR2 1 No No Active Was animal kept alive and retained after catch for later determination of survival rates? Y-yes, N-no, U-unknown VARCHAR2 6 ANIMAL_MOVED VARCHAR2 1 No No Active Was tagged animal removed to new location before release? Y-yes, N-no, U-unknown VARCHAR2 7089 CTS_TAG_TYPES Published / External Completed Table Of Valid Tah Types Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table Of Valid Tah Types 1 TAG_TYPE VARCHAR2 3 Yes No Active Mnemonic Tag Type Code VARCHAR2 2 TAG_DESCRIPTION VARCHAR2 50 No No Active Tag Type Description VARCHAR2 7090 CTS_USER_APPLICATIONS_V Published / External Completed Table to indicate valid users of CTSPAT Tables Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT Table to indicate valid users of CTSPAT Tables 1 ID NUMBER 22 No No 38 Active Sequential Key NUMBER 2 USERNAME VARCHAR2 50 No No Active Oracle Id VARCHAR2 3 APPLICATION CHAR 3 No No Active Indicates Application For Which user is authrorized CHAR 7091 CTS_USER_PROFILES Published / External Completed Control Table Used For System Access Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Control Table Used For System Access 1 ID NUMBER 22 Yes No 38 Active Sequential Key NUMBER 2 FULLNAME VARCHAR2 200 No No Active Full Name Of User VARCHAR2 3 USERNAME VARCHAR2 50 No No Active Oracle Id of system user VARCHAR2 4 PASSWORD VARCHAR2 50 No No Active password for this system VARCHAR2 5 IS_CTS VARCHAR2 1 No No Active Is This person a CTS User VARCHAR2 6 IS_PAT VARCHAR2 1 No No Active Is This person a Popup Arhcival Tag User VARCHAR2 7092 CTS_VESSELS Published / External Completed Table Of Valid Vessels Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table Of Valid Vessels 1 AGENCY_ID VARCHAR2 3 Yes Yes Active Code for agency collecting this vessel information. VARCHAR2 2 VESSEL_ID NUMBER 22 Yes Yes 6 0 Active Agency-supplied code identifying the vessel involved in the release or recapture of the animal. NUMBER 3 VESSEL_NAME VARCHAR2 25 No No Active Vessel name. VARCHAR2 4 COUNTRY_ID VARCHAR2 2 No No Active Country of registration of the vessel. VARCHAR2 7093 CTS_WATER_BODIES Published / External Completed Table Of Valid Water Body Code Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table Of Valid Water Body Code 1 WATER_BODY_ID NUMBER 22 Yes Yes 6 3 Active The water body code. NUMBER 2 WATER_BODY_NAME VARCHAR2 60 No No Active The name of the water body. VARCHAR2 3 LATITUDE NUMBER 22 No No 14 6 Active Latitude Where Waterbody can be found NUMBER 4 LONGITUDE NUMBER 22 No No 14 6 Active Longitude Where Waterbody can be found NUMBER 7094 CTS_WEIGHT_DETERMINATION Published / External Completed Table of Valid Weight Determination Codes Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table of Valid Weight Determination Codes 1 WEIGHT_ID VARCHAR2 1 Yes No Active Weight Determination Code VARCHAR2 2 WEIGHT_DESCRIPTION VARCHAR2 50 No No Active Weight Determination Description. VARCHAR2 7095 CTS_WEIGHT_TYPE Published / External Completed Table Of Valid Weight Types Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table Of Valid Weight Types 1 TYPE_ID VARCHAR2 1 Yes No Active Mnemonic Code VARCHAR2 2 TYPE_DESCRIPTION VARCHAR2 50 No No Active Code Description VARCHAR2 7096 CTS_WEIGHT_UNIT Published / External Completed Table Of Valid Weight Units Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table Of Valid Weight Units 1 UNIT_ID VARCHAR2 3 Yes No Active Mnemonic Weight Unit Code VARCHAR2 2 UNIT_DESCRIPTION VARCHAR2 50 No No Active Weight Unit Code Description VARCHAR2 7097 CTS_YESNO Published / External Completed Table Of Valid Answer Codes Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table Of Valid Answer Codes 1 ANSWER_CODE VARCHAR2 1 No No Active Mnemonic Answer Code VARCHAR2 2 ANSWER VARCHAR2 3 No No Active Answer Code Description VARCHAR2 7098 FIFTH_INTERACTIONS_V Published / External Completed View Of Fifth Tagging Interactions Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT View Of Fifth Tagging Interactions 1 ANIMAL_ID NUMBER 22 Yes No 10 0 Active Key to Identifies Animal NUMBER 2 SPECIES VARCHAR2 3 Yes No Active Species Code Used In NMFS Tagging Program VARCHAR2 3 SEX VARCHAR2 1 No No Active Code to indicate sex of the animal VARCHAR2 4 AGENCY_ID VARCHAR2 3 Yes No Active Code to Indicate Tagging agency of identifying tag on animal (tag1) VARCHAR2 5 TAG_ID VARCHAR2 8 Yes No Active Tagnumber VARCHAR2 6 EVENT_ID NUMBER 22 Yes No 2 0 Active Code to identify tagging event NUMBER 7 TAG_DATE DATE 7 Yes No Active Date animal was released or recaptured. DATE 8 NEXT_TAG_AGENCY VARCHAR2 3 No No Active Code For Agency That Issued the next tag (second tag) on this record VARCHAR2 9 NEXT_TAG_ID VARCHAR2 8 No No Active Code to Indicate Tagging agency of identifying tag on animal (nexttag) VARCHAR2 10 INTERACTION_ORDER NUMBER 22 Yes No 2 0 Active Number denoting the order of the interaction. NUMBER 11 LENGTH NUMBER 22 No No 4 0 Active Length of animal tagged based on the lengthunit, lengthtype, and lengthdet. NUMBER 12 LENGTH_UNIT VARCHAR2 2 No No Active Units for Length Measurement VARCHAR2 13 LENGTH_TYPE VARCHAR2 1 No No Active Code to determine The Type Of Length MEasurement taken VARCHAR2 14 LENGTH_DETERMINATION VARCHAR2 1 No No Active Code To Indicate How Length Was determined VARCHAR2 15 WEIGHT NUMBER 22 No No 6 2 Active Weight of an animal tagged, based upon weightunit, weighttype and weightdet. NUMBER 16 WEIGHT_UNIT VARCHAR2 2 No No Active Units for Weight Measurement VARCHAR2 17 WEIGHT_TYPE VARCHAR2 1 No No Active Code For Type Of Weight Measurement VARCHAR2 18 WEIGHT_DETERMINATION VARCHAR2 1 No No Active Code For How Weight Was Determined VARCHAR2 19 LATITUDE NUMBER 22 No No 30 16 Active Numeric value for the latitude of the tagging location. NUMBER 20 LONGITUDE NUMBER 22 No No 30 16 Active Numeric value the the longitude of the tagging location. NUMBER 21 STAT_ZONE_ID NUMBER 22 No No 4 1 Active Code to indciate State Zone NUMBER 22 COUNTRY_ID VARCHAR2 2 No No Active Cde to indicate Country VARCHAR2 23 STATE_ID VARCHAR2 2 No No Active Code to indicate state VARCHAR2 24 WATER_BODY_ID NUMBER 22 No No 6 3 Active Code to Indicate waterbody of where tagging took place NUMBER 25 PLACE_ID VARCHAR2 3 No No Active Code to indicate place of wheer tagging took palce VARCHAR2 26 GEAR_ID VARCHAR2 3 No No Active Code for gear used to catch the animal. VARCHAR2 27 BAIT_TYPE VARCHAR2 1 No No Active Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown VARCHAR2 28 METHOD_ID NUMBER 22 No No 6 0 Active Code To indicate tagging methodology Used NUMBER 29 SAMPLE_ID NUMBER 22 No No 6 0 Active Code to indicate Sampling Methodology NUMBER 30 CAPTAIN_AGENCY VARCHAR2 3 No No Active COde to indicate agency which assigned angler code for boat captain VARCHAR2 31 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 32 TAGGER_INITIALS VARCHAR2 3 No No Active Initials Of Taggers VARCHAR2 33 TAGGER_TYPE VARCHAR2 1 No No Active Indicates Type Of Tagger VARCHAR2 34 TAGGER_AFFILIATION VARCHAR2 3 No No Active Code Of Agency that is affiliated With The Tagger VARCHAR2 35 VESSEL_AGENCY VARCHAR2 3 No No Active Agency For Vessel COode VARCHAR2 36 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 37 PHYSICAL_DATA_ID NUMBER 22 No No 6 0 Active Physical Data Identification Number NUMBER 38 NOTES NUMBER 22 No No 3 0 Active Any Other Notes On Tagging NUMBER 39 FIGHT_HOURS NUMBER 22 No No 2 0 Active Number Of Hours Spent FIghting/Landings Fish NUMBER 40 FIGHT_MINUTES NUMBER 22 No No 2 0 Active Number Of Minutes (up to 59) spent FIghting/Landings Fish NUMBER 41 ANGLER_AGENCY VARCHAR2 3 No No Active Agency That Has Angler Code list VARCHAR2 42 ANGLER_ID NUMBER 22 No No 6 0 Active Unique identifier for each person in the database. NUMBER 43 DATE_ENTERED DATE 7 No No Active The date the data was entered. DATE 7099 FIRST_INTERACTIONS_V Published / External Completed View Of FIrst Tagging Interactions Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT View Of FIrst Tagging Interactions 1 ANIMAL_ID NUMBER 22 Yes No 10 0 Active Key to Identifies Animal NUMBER 2 SPECIES VARCHAR2 3 Yes No Active Species Code Used In NMFS Tagging Program VARCHAR2 3 SEX VARCHAR2 1 No No Active Code to indicate sex of the animal VARCHAR2 4 AGENCY_ID VARCHAR2 3 Yes No Active Code to Indicate Tagging agency of identifying tag on animal (tag1) VARCHAR2 5 TAG_ID VARCHAR2 8 Yes No Active Tagnumber VARCHAR2 6 EVENT_ID NUMBER 22 Yes No 2 0 Active Code to identify tagging event NUMBER 7 TAG_DATE DATE 7 Yes No Active Date animal was released or recaptured. DATE 8 NEXT_TAG_AGENCY VARCHAR2 3 No No Active Code For Agency That Issued the next tag (second tag) on this record VARCHAR2 9 NEXT_TAG_ID VARCHAR2 8 No No Active Code to Indicate Tagging agency of identifying tag on animal (nexttag) VARCHAR2 10 INTERACTION_ORDER NUMBER 22 Yes No 2 0 Active Number denoting the order of the interaction. NUMBER 11 LENGTH NUMBER 22 No No 4 0 Active Length of animal tagged based on the lengthunit, lengthtype, and lengthdet. NUMBER 12 LENGTH_UNIT VARCHAR2 2 No No Active Units for Length Measurement VARCHAR2 13 LENGTH_TYPE VARCHAR2 1 No No Active Code to determine The Type Of Length MEasurement taken VARCHAR2 14 LENGTH_DETERMINATION VARCHAR2 1 No No Active Code To Indicate How Length Was determined VARCHAR2 15 WEIGHT NUMBER 22 No No 6 2 Active Weight of an animal tagged, based upon weightunit, weighttype and weightdet. NUMBER 16 WEIGHT_UNIT VARCHAR2 2 No No Active Units for Weight Measurement VARCHAR2 17 WEIGHT_TYPE VARCHAR2 1 No No Active Code For Type Of Weight Measurement VARCHAR2 18 WEIGHT_DETERMINATION VARCHAR2 1 No No Active Code For How Weight Was Determined VARCHAR2 19 LATITUDE NUMBER 22 No No 30 16 Active Numeric value for the latitude of the tagging location. NUMBER 20 LONGITUDE NUMBER 22 No No 30 16 Active Numeric value the the longitude of the tagging location. NUMBER 21 STAT_ZONE_ID NUMBER 22 No No 4 1 Active Code to indciate State Zone NUMBER 22 COUNTRY_ID VARCHAR2 2 No No Active Cde to indicate Country VARCHAR2 23 STATE_ID VARCHAR2 2 No No Active Code to indicate state VARCHAR2 24 WATER_BODY_ID NUMBER 22 No No 6 3 Active Code to Indicate waterbody of where tagging took place NUMBER 25 PLACE_ID VARCHAR2 3 No No Active Code to indicate place of wheer tagging took palce VARCHAR2 26 GEAR_ID VARCHAR2 3 No No Active Code for gear used to catch the animal. VARCHAR2 27 BAIT_TYPE VARCHAR2 1 No No Active Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown VARCHAR2 28 METHOD_ID NUMBER 22 No No 6 0 Active Code To indicate tagging methodology Used NUMBER 29 SAMPLE_ID NUMBER 22 No No 6 0 Active Code to indicate Sampling Methodology NUMBER 30 CAPTAIN_AGENCY VARCHAR2 3 No No Active COde to indicate agency which assigned angler code for boat captain VARCHAR2 31 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 32 TAGGER_INITIALS VARCHAR2 3 No No Active Initials Of Taggers VARCHAR2 33 TAGGER_TYPE VARCHAR2 1 No No Active Indicates Type Of Tagger VARCHAR2 34 TAGGER_AFFILIATION VARCHAR2 3 No No Active Code Of Agency that is affiliated With The Tagger VARCHAR2 35 VESSEL_AGENCY VARCHAR2 3 No No Active Agency For Vessel COode VARCHAR2 36 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 37 PHYSICAL_DATA_ID NUMBER 22 No No 6 0 Active Physical Data Identification Number NUMBER 38 NOTES NUMBER 22 No No 3 0 Active Any Other Notes On Tagging NUMBER 39 FIGHT_HOURS NUMBER 22 No No 2 0 Active Number Of Hours Spent FIghting/Landings Fish NUMBER 40 FIGHT_MINUTES NUMBER 22 No No 2 0 Active Number Of Minutes (up to 59) spent FIghting/Landings Fish NUMBER 41 ANGLER_AGENCY VARCHAR2 3 No No Active Agency That Has Angler Code list VARCHAR2 42 ANGLER_ID NUMBER 22 No No 6 0 Active Unique identifier for each person in the database. NUMBER 43 DATE_ENTERED DATE 7 No No Active The date the data was entered. DATE 7100 FOURTH_INTERACTIONS_V Published / External Completed View Of Fourth Tagging Interaction Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT View Of Fourth Tagging Interaction 1 ANIMAL_ID NUMBER 22 Yes No 10 0 Active Key to Identifies Animal NUMBER 2 SPECIES VARCHAR2 3 Yes No Active Species Code Used In NMFS Tagging Program VARCHAR2 3 SEX VARCHAR2 1 No No Active Code to indicate sex of the animal VARCHAR2 4 AGENCY_ID VARCHAR2 3 Yes No Active Code to Indicate Tagging agency of identifying tag on animal (tag1) VARCHAR2 5 TAG_ID VARCHAR2 8 Yes No Active Tagnumber VARCHAR2 6 EVENT_ID NUMBER 22 Yes No 2 0 Active Code to identify tagging event NUMBER 7 TAG_DATE DATE 7 Yes No Active Date animal was released or recaptured. DATE 8 NEXT_TAG_AGENCY VARCHAR2 3 No No Active Code For Agency That Issued the next tag (second tag) on this record VARCHAR2 9 NEXT_TAG_ID VARCHAR2 8 No No Active Code to Indicate Tagging agency of identifying tag on animal (nexttag) VARCHAR2 10 INTERACTION_ORDER NUMBER 22 Yes No 2 0 Active Number denoting the order of the interaction. NUMBER 11 LENGTH NUMBER 22 No No 4 0 Active Length of animal tagged based on the lengthunit, lengthtype, and lengthdet. NUMBER 12 LENGTH_UNIT VARCHAR2 2 No No Active Units for Length Measurement VARCHAR2 13 LENGTH_TYPE VARCHAR2 1 No No Active Code to determine The Type Of Length MEasurement taken VARCHAR2 14 LENGTH_DETERMINATION VARCHAR2 1 No No Active Code To Indicate How Length Was determined VARCHAR2 15 WEIGHT NUMBER 22 No No 6 2 Active Weight of an animal tagged, based upon weightunit, weighttype and weightdet. NUMBER 16 WEIGHT_UNIT VARCHAR2 2 No No Active Units for Weight Measurement VARCHAR2 17 WEIGHT_TYPE VARCHAR2 1 No No Active Code For Type Of Weight Measurement VARCHAR2 18 WEIGHT_DETERMINATION VARCHAR2 1 No No Active Code For How Weight Was Determined VARCHAR2 19 LATITUDE NUMBER 22 No No 30 16 Active Numeric value for the latitude of the tagging location. NUMBER 20 LONGITUDE NUMBER 22 No No 30 16 Active Numeric value the the longitude of the tagging location. NUMBER 21 STAT_ZONE_ID NUMBER 22 No No 4 1 Active Code to indciate State Zone NUMBER 22 COUNTRY_ID VARCHAR2 2 No No Active Cde to indicate Country VARCHAR2 23 STATE_ID VARCHAR2 2 No No Active Code to indicate state VARCHAR2 24 WATER_BODY_ID NUMBER 22 No No 6 3 Active Code to Indicate waterbody of where tagging took place NUMBER 25 PLACE_ID VARCHAR2 3 No No Active Code to indicate place of wheer tagging took palce VARCHAR2 26 GEAR_ID VARCHAR2 3 No No Active Code for gear used to catch the animal. VARCHAR2 27 BAIT_TYPE VARCHAR2 1 No No Active Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown VARCHAR2 28 METHOD_ID NUMBER 22 No No 6 0 Active Code To indicate tagging methodology Used NUMBER 29 SAMPLE_ID NUMBER 22 No No 6 0 Active Code to indicate Sampling Methodology NUMBER 30 CAPTAIN_AGENCY VARCHAR2 3 No No Active COde to indicate agency which assigned angler code for boat captain VARCHAR2 31 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 32 TAGGER_INITIALS VARCHAR2 3 No No Active Initials Of Taggers VARCHAR2 33 TAGGER_TYPE VARCHAR2 1 No No Active Indicates Type Of Tagger VARCHAR2 34 TAGGER_AFFILIATION VARCHAR2 3 No No Active Code Of Agency that is affiliated With The Tagger VARCHAR2 35 VESSEL_AGENCY VARCHAR2 3 No No Active Agency For Vessel COode VARCHAR2 36 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 37 PHYSICAL_DATA_ID NUMBER 22 No No 6 0 Active Physical Data Identification Number NUMBER 38 NOTES NUMBER 22 No No 3 0 Active Any Other Notes On Tagging NUMBER 39 FIGHT_HOURS NUMBER 22 No No 2 0 Active Number Of Hours Spent FIghting/Landings Fish NUMBER 40 FIGHT_MINUTES NUMBER 22 No No 2 0 Active Number Of Minutes (up to 59) spent FIghting/Landings Fish NUMBER 41 ANGLER_AGENCY VARCHAR2 3 No No Active Agency That Has Angler Code list VARCHAR2 42 ANGLER_ID NUMBER 22 No No 6 0 Active Unique identifier for each person in the database. NUMBER 43 DATE_ENTERED DATE 7 No No Active The date the data was entered. DATE 7101 HABITATMATRIX_V Published / External Completed View Of Habitat Matrix Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT View Of Habitat Matrix 1 ARCHIVAL_TAG_ID VARCHAR2 10 Yes No Active Archival Tag (Number) VARCHAR2 2 RECEPTION_DATE DATE 7 Yes No Active Date INformation Wa Received DATE 3 RECEPTION_TIME VARCHAR2 10 Yes No Active Time Information Was Recieved VARCHAR2 4 DEPTH_1 NUMBER 22 No No 38 Active Depth One Measurement NUMBER 5 D1_MIN_TEMP NUMBER 22 No No 38 Active Depth One Minimum Temperature NUMBER 6 D1_MAX_TEMP NUMBER 22 No No 38 Active Depth One Maximum Temperature NUMBER 7 DEPTH_2 NUMBER 22 No No 38 Active Depth Two Measurement NUMBER 8 D2_MIN_TEMP NUMBER 22 No No 38 Active Depth Two Minimum Temperature NUMBER 9 D2_MAX_TEMP NUMBER 22 No No 38 Active Depth Two Maximum Temperature NUMBER 10 DEPTH_3 NUMBER 22 No No 38 Active Depth Three Measurement NUMBER 11 D3_MIN_TEMP NUMBER 22 No No 38 Active Depth Three Minimum Temperature NUMBER 12 D3_MAX_TEMP NUMBER 22 No No 38 Active Depth Three Maximum Temperature NUMBER 13 DEPTH_4 VARCHAR2 240 No No Active Depth Four Measurement VARCHAR2 14 D4_MIN_TEMP NUMBER 22 No No 38 Active Depth Four Minimum Temperature NUMBER 15 D4_MAX_TEMP NUMBER 22 No No 38 Active Depth Four Maximum Temperature NUMBER 16 DEPTH_5 NUMBER 22 No No 38 Active Depth Five Measurement NUMBER 17 D5_MIN_TEMP NUMBER 22 No No 38 Active Depth Five Minimum Temperature NUMBER 18 D5_MAX_TEMP NUMBER 22 No No 38 Active Depth Fivet Maximum Temperature NUMBER 19 DEPTH_6 NUMBER 22 No No 38 Active Depth Six Measurement NUMBER 20 D6_MIN_TEMP NUMBER 22 No No 38 Active Depth Six Minimum Temperature NUMBER 21 D6_MAX_TEMP NUMBER 22 No No 38 Active Depth Six Maximum Temperature NUMBER 22 DEPTH_7 NUMBER 22 No No 38 Active Depth Seven Measurement NUMBER 23 D7_MIN_TEMP NUMBER 22 No No 38 Active Depth Seven Minimum Temperature NUMBER 24 D7_MAX_TEMP NUMBER 22 No No 38 Active Depth Seven Maximum Temperature NUMBER 25 DEPTH_8 NUMBER 22 No No 38 Active Depth Eight Measurement NUMBER 26 D8_MIN_TEMP NUMBER 22 No No 38 Active Depth Eight Minimum Temperature NUMBER 27 D8_MAX_TEMP NUMBER 22 No No 38 Active Depth Eight Maximum Temperature NUMBER 28 YEAR NUMBER 22 Yes No 4 0 Active Calender Year Measurement Was Taken NUMBER 29 MONTH NUMBER 22 Yes No 2 0 Active Calender Month Measurement Was Taken NUMBER 30 DAY NUMBER 22 Yes No 2 0 Active Calender Day Measurement Was Taken NUMBER 31 HOUR NUMBER 22 Yes No 2 0 Active Time MEasurement Was Taken NUMBER 32 REPEATS NUMBER 22 No No 3 0 Active Number Of Times Measurement Was Repeated NUMBER 7102 ICCAT_V Published / External Completed View Of Data That is used for ICCAT Report Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT View Of Data That is used for ICCAT Report 1 ANIMAL_ID NUMBER 22 Yes No 10 0 Active Key to Identifies Animal NUMBER 2 SPECIES VARCHAR2 3 Yes No Active Species Code Used In NMFS Tagging Program VARCHAR2 3 SEX VARCHAR2 1 No No Active Code to indicate sex of the animal VARCHAR2 4 AGENCY_ID_1 VARCHAR2 3 Yes No Active Code to Indicate Tagging agency of identifying tag on animal (tag1) at first tagging interaction VARCHAR2 5 TAG_ID_1 VARCHAR2 8 Yes No Active Tagnumber at first tagging interaction VARCHAR2 6 EVENT_ID_1 NUMBER 22 Yes No 2 0 Active Code to Indicate Tagging Event at first tagging interaction NUMBER 7 TAG_DATE_1 VARCHAR2 10 No No Active Date animal was released or recaptured t first tagging interaction. VARCHAR2 8 NEXT_TAG_AGENCY_1 VARCHAR2 3 No No Active Code For Agency That Issued the next tag (second tag) on this record at first tagging interaction VARCHAR2 9 NEXT_TAG_ID_1 VARCHAR2 8 No No Active Code to Indicate Tagging agency of identifying tag on animal (nexttag) at first tagging interaction VARCHAR2 10 INTERACTION_ORDER_1 NUMBER 22 Yes No 2 0 Active Number denoting the order of the interaction at first tagging interaction. NUMBER 11 LENGTH_1 NUMBER 22 No No 4 0 Active Length of animal tagged based on the lengthunit, lengthtype, and lengthdet at first tagging interaction. NUMBER 12 LENGTH_UNIT_1 VARCHAR2 2 No No Active Units for Length Measurement at first tagging interaction. VARCHAR2 13 LENGTH_TYPE_1 VARCHAR2 1 No No Active Code to determine The Type Of Length Measurement taken at first tagging interaction. VARCHAR2 14 LENGTH_DETERMINATION_1 VARCHAR2 1 No No Active Code To Indicate How Length Was determined at first tagging interaction VARCHAR2 15 WEIGHT_1 NUMBER 22 No No 6 2 Active Weight of an animal tagged, based upon weightunit, weighttype and weightdet at first tagging interaction. NUMBER 16 WEIGHT_UNIT_1 VARCHAR2 2 No No Active Units for Weight Measurement t first tagging interaction. VARCHAR2 17 WEIGHT_TYPE_1 VARCHAR2 1 No No Active Code For Type Of Weight Measurement at first tagging interaction. VARCHAR2 18 WEIGHT_DETERMINATION_1 VARCHAR2 1 No No Active Code For How Weight Was Determined at first tagging interaction. VARCHAR2 19 LATITUDE_1 NUMBER 22 No No 30 16 Active Numeric value for the latitude of the tagging location at first tagging interaction. NUMBER 20 LONGITUDE_1 NUMBER 22 No No 30 16 Active Numeric value the the longitude of the tagging location at first tagging interaction. NUMBER 21 STAT_ZONE_ID_1 NUMBER 22 No No 4 1 Active Code to indciate State Zone at first tagging interaction NUMBER 22 COUNTRY_ID_1 VARCHAR2 2 No No Active Code to indicate Country at first tagging interaction VARCHAR2 23 STATE_ID_1 VARCHAR2 2 No No Active Code to indicate state at first tagging interaction VARCHAR2 24 WATER_BODY_ID_1 NUMBER 22 No No 6 3 Active Code to Indicate waterbody of where tagging took place at first tagging interaction NUMBER 25 PLACE_ID_1 VARCHAR2 3 No No Active Code to indicate place of wheer tagging took place at first tagging interaction VARCHAR2 26 GEAR_ID_1 VARCHAR2 3 No No Active Code for gear used to catch the animal at first tagging interaction. VARCHAR2 27 BAIT_TYPE_1 VARCHAR2 1 No No Active Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown at first tagging interaction. VARCHAR2 28 METHOD_ID_1 NUMBER 22 No No 6 0 Active Code To indicate tagging methodology Used at first tagging interaction NUMBER 29 SAMPLE_ID_1 NUMBER 22 No No 6 0 Active Code to indicate Sampling Methodology at first tagging interaction NUMBER 30 CAPTAIN_AGENCY_1 VARCHAR2 3 No No Active Code to indicate agency which assigned angler code for boat captain at first tagging interaction. VARCHAR2 31 CAPTAIN_ID_1 NUMBER 22 No No 6 0 Active Unique numeric code assigned to an individual captain. Must be greater than zero or -99999 at first tagging interaction. NUMBER 32 TAGGER_INITIALS_1 VARCHAR2 3 No No Active Initials Of Taggers at first tagging interaction. VARCHAR2 33 TAGGER_TYPE_1 VARCHAR2 1 No No Active Indicates Type Of Tagger at first tagging interaction. VARCHAR2 34 TAGGER_AFFILIATION_1 VARCHAR2 3 No No Active Code Of Agency that is affiliated With The Tagger at first tagging interaction. VARCHAR2 35 VESSEL_AGENCY_1 VARCHAR2 3 No No Active Agency For Vessel Code at first tagging interaction. VARCHAR2 36 VESSEL_ID_1 NUMBER 22 No No 6 0 Active Agency supplied code identifying the vessel involved in the release or recapture of the animal at first tagging interaction. NUMBER 37 PHYSICAL_DATA_ID_1 NUMBER 22 No No 6 0 Active Physical Data Identification Number at first tagging interaction NUMBER 38 NOTES_1 NUMBER 22 No No 3 0 Active Any Other Notes On Tagging at first tagging interaction NUMBER 39 FIGHT_HOURS_1 NUMBER 22 No No 2 0 Active Number Of Hours Spent FIghting/Landings Fish at first tagging interaction NUMBER 40 FIGHT_MINUTES_1 NUMBER 22 No No 2 0 Active Number Of Minutes (up to 59) spent FIghting/Landings Fish at first tagging interaction NUMBER 41 ANGLER_AGENCY_1 VARCHAR2 3 No No Active Agency That Has Angler Code list at first tagging interaction VARCHAR2 42 ANGLER_ID_1 NUMBER 22 No No 6 0 Active Angler Code at first tagging interaction . NUMBER 43 DATE_ENTERED_1 DATE 7 No No Active The date the data was entered at first tagging interaction. DATE 44 AGENCY_ID_2 VARCHAR2 3 No No Active Code to Indicate Tagging agency of identifying tag on animal (tag1) at second tagging interaction VARCHAR2 45 TAG_ID_2 VARCHAR2 8 No No Active Tagnumber at second tagging interaction VARCHAR2 46 EVENT_ID_2 NUMBER 22 No No 2 0 Active Code to Indicate Tagging Event at second tagging interaction NUMBER 47 TAG_DATE_2 VARCHAR2 10 No No Active Date animal was released or recaptured t second tagging interaction. VARCHAR2 48 NEXT_TAG_AGENCY_2 VARCHAR2 3 No No Active Code For Agency That Issued the next tag (second tag) on this record at second tagging interaction VARCHAR2 49 NEXT_TAG_ID_2 VARCHAR2 8 No No Active Code to Indicate Tagging agency of identifying tag on animal (nexttag) at second tagging interaction VARCHAR2 50 INTERACTION_ORDER_2 NUMBER 22 No No 2 0 Active Number denoting the order of the interaction at second tagging interaction. NUMBER 51 LENGTH_2 NUMBER 22 No No 4 0 Active Length of animal tagged based on the lengthunit, lengthtype, and lengthdet at second tagging interaction. NUMBER 52 LENGTH_UNIT_2 VARCHAR2 2 No No Active Units for Length Measurement at second tagging interaction. VARCHAR2 53 LENGTH_TYPE_2 VARCHAR2 1 No No Active Code to determine The Type Of Length Measurement taken at second tagging interaction. VARCHAR2 54 LENGTH_DETERMINATION_2 VARCHAR2 1 No No Active Code To Indicate How Length Was determined at second tagging interaction VARCHAR2 55 WEIGHT_2 NUMBER 22 No No 6 2 Active Weight of an animal tagged, based upon weightunit, weighttype and weightdet at second tagging interaction. NUMBER 56 WEIGHT_UNIT_2 VARCHAR2 2 No No Active Units for Weight Measurement t second tagging interaction. VARCHAR2 57 WEIGHT_TYPE_2 VARCHAR2 1 No No Active Code For Type Of Weight Measurement at second tagging interaction. VARCHAR2 58 WEIGHT_DETERMINATION_2 VARCHAR2 1 No No Active Code For How Weight Was Determined at second tagging interaction. VARCHAR2 59 LATITUDE_2 NUMBER 22 No No 30 16 Active Numeric value for the latitude of the tagging location at second tagging interaction. NUMBER 60 LONGITUDE_2 NUMBER 22 No No 30 16 Active Numeric value the the longitude of the tagging location at second tagging interaction. NUMBER 61 STAT_ZONE_ID_2 NUMBER 22 No No 4 1 Active Code to indciate State Zone at second tagging interaction NUMBER 62 COUNTRY_ID_2 VARCHAR2 2 No No Active Code to indicate Country at second tagging interaction VARCHAR2 63 STATE_ID_2 VARCHAR2 2 No No Active Code to indicate state at second tagging interaction VARCHAR2 64 WATER_BODY_ID_2 NUMBER 22 No No 6 3 Active Code to Indicate waterbody of where tagging took place at second tagging interaction NUMBER 65 PLACE_ID_2 VARCHAR2 3 No No Active Code to indicate place of wheer tagging took place at second tagging interaction VARCHAR2 66 GEAR_ID_2 VARCHAR2 3 No No Active Code for gear used to catch the animal at second tagging interaction. VARCHAR2 67 BAIT_TYPE_2 VARCHAR2 1 No No Active Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown at second tagging interaction. VARCHAR2 68 METHOD_ID_2 NUMBER 22 No No 6 0 Active Code To indicate tagging methodology Used at second tagging interaction NUMBER 69 SAMPLE_ID_2 NUMBER 22 No No 6 0 Active Code to indicate Sampling Methodology at second tagging interaction NUMBER 70 CAPTAIN_AGENCY_2 VARCHAR2 3 No No Active Code to indicate agency which assigned angler code for boat captain at second tagging interaction. VARCHAR2 71 CAPTAIN_ID_2 NUMBER 22 No No 6 0 Active Unique numeric code assigned to an individual captain. Must be greater than zero or -99999 at second tagging interaction. NUMBER 72 TAGGER_INITIALS_2 VARCHAR2 3 No No Active Initials Of Taggers at second tagging interaction. VARCHAR2 73 TAGGER_TYPE_2 VARCHAR2 1 No No Active Indicates Type Of Tagger at second tagging interaction. VARCHAR2 74 TAGGER_AFFILIATION_2 VARCHAR2 3 No No Active Code Of Agency that is affiliated With The Tagger at second tagging interaction. VARCHAR2 75 VESSEL_AGENCY_2 VARCHAR2 3 No No Active Agency For Vessel Code at second tagging interaction. VARCHAR2 76 VESSEL_ID_2 NUMBER 22 No No 6 0 Active Agency supplied code identifying the vessel involved in the release or recapture of the animal at second tagging interaction. NUMBER 77 PHYSICAL_DATA_ID_2 NUMBER 22 No No 6 0 Active Physical Data Identification Number at second tagging interaction NUMBER 78 NOTES_2 NUMBER 22 No No 3 0 Active Any Other Notes On Tagging at second tagging interaction NUMBER 79 FIGHT_HOURS_2 NUMBER 22 No No 2 0 Active Number Of Hours Spent FIghting/Landings Fish at second tagging interaction NUMBER 80 FIGHT_MINUTES_2 NUMBER 22 No No 2 0 Active Number Of Minutes (up to 59) spent FIghting/Landings Fish at second tagging interaction NUMBER 81 ANGLER_AGENCY_2 VARCHAR2 3 No No Active Agency That Has Angler Code list at second tagging interaction VARCHAR2 82 ANGLER_ID_2 NUMBER 22 No No 6 0 Active Angler Code at second tagging interaction . NUMBER 83 DATE_ENTERED_2 DATE 7 No No Active The date the data was entered at second tagging interaction. DATE 84 AGENCY_ID_3 VARCHAR2 3 No No Active Code to Indicate Tagging agency of identifying tag on animal (tag1) at third tagging interaction VARCHAR2 85 TAG_ID_3 VARCHAR2 8 No No Active Tagnumber at third tagging interaction VARCHAR2 86 EVENT_ID_3 NUMBER 22 No No 2 0 Active Code to Indicate Tagging Event at third tagging interaction NUMBER 87 TAG_DATE_3 VARCHAR2 10 No No Active Date animal was released or recaptured t third tagging interaction. VARCHAR2 88 NEXT_TAG_AGENCY_3 VARCHAR2 3 No No Active Code For Agency That Issued the next tag (third tag) on this record at third tagging interaction VARCHAR2 89 NEXT_TAG_ID_3 VARCHAR2 8 No No Active Code to Indicate Tagging agency of identifying tag on animal (nexttag) at third tagging interaction VARCHAR2 90 INTERACTION_ORDER_3 NUMBER 22 No No 2 0 Active Number denoting the order of the interaction at third tagging interaction. NUMBER 91 LENGTH_3 NUMBER 22 No No 4 0 Active Length of animal tagged based on the lengthunit, lengthtype, and lengthdet at third tagging interaction. NUMBER 92 LENGTH_UNIT_3 VARCHAR2 2 No No Active Units for Length Measurement at third tagging interaction. VARCHAR2 93 LENGTH_TYPE_3 VARCHAR2 1 No No Active Code to determine The Type Of Length Measurement taken at third tagging interaction. VARCHAR2 94 LENGTH_DETERMINATION_3 VARCHAR2 1 No No Active Code To Indicate How Length Was determined at third tagging interaction VARCHAR2 95 WEIGHT_3 NUMBER 22 No No 6 2 Active Weight of an animal tagged, based upon weightunit, weighttype and weightdet at third tagging interaction. NUMBER 96 WEIGHT_UNIT_3 VARCHAR2 2 No No Active Units for Weight Measurement t third tagging interaction. VARCHAR2 97 WEIGHT_TYPE_3 VARCHAR2 1 No No Active Code For Type Of Weight Measurement at third tagging interaction. VARCHAR2 98 WEIGHT_DETERMINATION_3 VARCHAR2 1 No No Active Code For How Weight Was Determined at third tagging interaction. VARCHAR2 99 LATITUDE_3 NUMBER 22 No No 30 16 Active Numeric value for the latitude of the tagging location at third tagging interaction. NUMBER 100 LONGITUDE_3 NUMBER 22 No No 30 16 Active Numeric value the the longitude of the tagging location at third tagging interaction. NUMBER 101 STAT_ZONE_ID_3 NUMBER 22 No No 4 1 Active Code to indciate State Zone at third tagging interaction NUMBER 102 COUNTRY_ID_3 VARCHAR2 2 No No Active Code to indicate Country at third tagging interaction VARCHAR2 103 STATE_ID_3 VARCHAR2 2 No No Active Code to indicate state at third tagging interaction VARCHAR2 104 WATER_BODY_ID_3 NUMBER 22 No No 6 3 Active Code to Indicate waterbody of where tagging took place at third tagging interaction NUMBER 105 PLACE_ID_3 VARCHAR2 3 No No Active Code to indicate place of wheer tagging took place at third tagging interaction VARCHAR2 106 GEAR_ID_3 VARCHAR2 3 No No Active Code for gear used to catch the animal at third tagging interaction. VARCHAR2 107 BAIT_TYPE_3 VARCHAR2 1 No No Active Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown at third tagging interaction. VARCHAR2 108 METHOD_ID_3 NUMBER 22 No No 6 0 Active Code To indicate tagging methodology Used at third tagging interaction NUMBER 109 SAMPLE_ID_3 NUMBER 22 No No 6 0 Active Code to indicate Sampling Methodology at third tagging interaction NUMBER 110 CAPTAIN_AGENCY_3 VARCHAR2 3 No No Active Code to indicate agency which assigned angler code for boat captain at third tagging interaction. VARCHAR2 111 CAPTAIN_ID_3 NUMBER 22 No No 6 0 Active Unique numeric code assigned to an individual captain. Must be greater than zero or -99999 at third tagging interaction. NUMBER 112 TAGGER_INITIALS_3 VARCHAR2 3 No No Active Initials Of Taggers at third tagging interaction. VARCHAR2 113 TAGGER_TYPE_3 VARCHAR2 1 No No Active Indicates Type Of Tagger at third tagging interaction. VARCHAR2 114 TAGGER_AFFILIATION_3 VARCHAR2 3 No No Active Code Of Agency that is affiliated With The Tagger at third tagging interaction. VARCHAR2 115 VESSEL_AGENCY_3 VARCHAR2 3 No No Active Agency For Vessel Code at third tagging interaction. VARCHAR2 116 VESSEL_ID_3 NUMBER 22 No No 6 0 Active Agency supplied code identifying the vessel involved in the release or recapture of the animal at third tagging interaction. NUMBER 117 PHYSICAL_DATA_ID_3 NUMBER 22 No No 6 0 Active Physical Data Identification Number at third tagging interaction NUMBER 118 NOTES_3 NUMBER 22 No No 3 0 Active Any Other Notes On Tagging at third tagging interaction NUMBER 119 FIGHT_HOURS_3 NUMBER 22 No No 2 0 Active Number Of Hours Spent FIghting/Landings Fish at third tagging interaction NUMBER 120 FIGHT_MINUTES_3 NUMBER 22 No No 2 0 Active Number Of Minutes (up to 59) spent FIghting/Landings Fish at third tagging interaction NUMBER 121 ANGLER_AGENCY_3 VARCHAR2 3 No No Active Agency That Has Angler Code list at third tagging interaction VARCHAR2 122 ANGLER_ID_3 NUMBER 22 No No 6 0 Active Angler Code at third tagging interaction . NUMBER 123 DATE_ENTERED_3 DATE 7 No No Active The date the data was entered at third tagging interaction. DATE 124 AGENCY_ID_4 VARCHAR2 3 No No Active Code to Indicate Tagging agency of identifying tag on animal (tag1) at fourth tagging interaction VARCHAR2 125 TAG_ID_4 VARCHAR2 8 No No Active Tagnumber at fourth tagging interaction VARCHAR2 126 EVENT_ID_4 NUMBER 22 No No 2 0 Active Code to Indicate Tagging Event at fourth tagging interaction NUMBER 127 TAG_DATE_4 VARCHAR2 10 No No Active Date animal was released or recaptured t fourth tagging interaction. VARCHAR2 128 NEXT_TAG_AGENCY_4 VARCHAR2 3 No No Active Code For Agency That Issued the next tag (fourth tag) on this record at fourth tagging interaction VARCHAR2 129 NEXT_TAG_ID_4 VARCHAR2 8 No No Active Code to Indicate Tagging agency of identifying tag on animal (nexttag) at fourth tagging interaction VARCHAR2 130 INTERACTION_ORDER_4 NUMBER 22 No No 2 0 Active Number denoting the order of the interaction at fourth tagging interaction. NUMBER 131 LENGTH_4 NUMBER 22 No No 4 0 Active Length of animal tagged based on the lengthunit, lengthtype, and lengthdet at fourth tagging interaction. NUMBER 132 LENGTH_UNIT_4 VARCHAR2 2 No No Active Units for Length Measurement at fourth tagging interaction. VARCHAR2 133 LENGTH_TYPE_4 VARCHAR2 1 No No Active Code to determine The Type Of Length Measurement taken at fourth tagging interaction. VARCHAR2 134 LENGTH_DETERMINATION_4 VARCHAR2 1 No No Active Code To Indicate How Length Was determined at fourth tagging interaction VARCHAR2 135 WEIGHT_4 NUMBER 22 No No 6 2 Active Weight of an animal tagged, based upon weightunit, weighttype and weightdet at fourth tagging interaction. NUMBER 136 WEIGHT_UNIT_4 VARCHAR2 2 No No Active Units for Weight Measurement t fourth tagging interaction. VARCHAR2 137 WEIGHT_TYPE_4 VARCHAR2 1 No No Active Code For Type Of Weight Measurement at fourth tagging interaction. VARCHAR2 138 WEIGHT_DETERMINATION_4 VARCHAR2 1 No No Active Code For How Weight Was Determined at fourth tagging interaction. VARCHAR2 139 LATITUDE_4 NUMBER 22 No No 30 16 Active Numeric value for the latitude of the tagging location at fourth tagging interaction. NUMBER 140 LONGITUDE_4 NUMBER 22 No No 30 16 Active Numeric value the the longitude of the tagging location at fourth tagging interaction. NUMBER 141 STAT_ZONE_ID_4 NUMBER 22 No No 4 1 Active Code to indciate State Zone at fourth tagging interaction NUMBER 142 COUNTRY_ID_4 VARCHAR2 2 No No Active Code to indicate Country at fourth tagging interaction VARCHAR2 143 STATE_ID_4 VARCHAR2 2 No No Active Code to indicate state at fourth tagging interaction VARCHAR2 144 WATER_BODY_ID_4 NUMBER 22 No No 6 3 Active Code to Indicate waterbody of where tagging took place at fourth tagging interaction NUMBER 145 PLACE_ID_4 VARCHAR2 3 No No Active Code to indicate place of wheer tagging took place at fourth tagging interaction VARCHAR2 146 GEAR_ID_4 VARCHAR2 3 No No Active Code for gear used to catch the animal at fourth tagging interaction. VARCHAR2 147 BAIT_TYPE_4 VARCHAR2 1 No No Active Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown at fourth tagging interaction. VARCHAR2 148 METHOD_ID_4 NUMBER 22 No No 6 0 Active Code To indicate tagging methodology Used at fourth tagging interaction NUMBER 149 SAMPLE_ID_4 NUMBER 22 No No 6 0 Active Code to indicate Sampling Methodology at fourth tagging interaction NUMBER 150 CAPTAIN_AGENCY_4 VARCHAR2 3 No No Active Code to indicate agency which assigned angler code for boat captain at fourth tagging interaction. VARCHAR2 151 CAPTAIN_ID_4 NUMBER 22 No No 6 0 Active Unique numeric code assigned to an individual captain. Must be greater than zero or -99999 at fourth tagging interaction. NUMBER 152 TAGGER_INITIALS_4 VARCHAR2 3 No No Active Initials Of Taggers at fourth tagging interaction. VARCHAR2 153 TAGGER_TYPE_4 VARCHAR2 1 No No Active Indicates Type Of Tagger at fourth tagging interaction. VARCHAR2 154 TAGGER_AFFILIATION_4 VARCHAR2 3 No No Active Code Of Agency that is affiliated With The Tagger at fourth tagging interaction. VARCHAR2 155 VESSEL_AGENCY_4 VARCHAR2 3 No No Active Agency For Vessel Code at fourth tagging interaction. VARCHAR2 156 VESSEL_ID_4 NUMBER 22 No No 6 0 Active Agency supplied code identifying the vessel involved in the release or recapture of the animal at fourth tagging interaction. NUMBER 157 PHYSICAL_DATA_ID_4 NUMBER 22 No No 6 0 Active Physical Data Identification Number at fourth tagging interaction NUMBER 158 NOTES_4 NUMBER 22 No No 3 0 Active Any Other Notes On Tagging at fourth tagging interaction NUMBER 159 FIGHT_HOURS_4 NUMBER 22 No No 2 0 Active Number Of Hours Spent FIghting/Landings Fish at fourth tagging interaction NUMBER 160 FIGHT_MINUTES_4 NUMBER 22 No No 2 0 Active Number Of Minutes (up to 59) spent FIghting/Landings Fish at fourth tagging interaction NUMBER 161 ANGLER_AGENCY_4 VARCHAR2 3 No No Active Agency That Has Angler Code list at fourth tagging interaction VARCHAR2 162 ANGLER_ID_4 NUMBER 22 No No 6 0 Active Angler Code at fourth tagging interaction . NUMBER 163 DATE_ENTERED_4 DATE 7 No No Active The date the data was entered at fourth tagging interaction. DATE 164 AGENCY_ID_5 VARCHAR2 3 No No Active Code to Indicate Tagging agency of identifying tag on animal (tag1) at fifth tagging interaction VARCHAR2 165 TAG_ID_5 VARCHAR2 8 No No Active Tagnumber at fifth tagging interaction VARCHAR2 166 EVENT_ID_5 NUMBER 22 No No 2 0 Active Code to Indicate Tagging Event at fifth tagging interaction NUMBER 167 TAG_DATE_5 VARCHAR2 10 No No Active Date animal was released or recaptured t fifth tagging interaction. VARCHAR2 168 NEXT_TAG_AGENCY_5 VARCHAR2 3 No No Active Code For Agency That Issued the next tag (fifth tag) on this record at fifth tagging interaction VARCHAR2 169 NEXT_TAG_ID_5 VARCHAR2 8 No No Active Code to Indicate Tagging agency of identifying tag on animal (nexttag) at fifth tagging interaction VARCHAR2 170 INTERACTION_ORDER_5 NUMBER 22 No No 2 0 Active Number denoting the order of the interaction at fifth tagging interaction. NUMBER 171 LENGTH_5 NUMBER 22 No No 4 0 Active Length of animal tagged based on the lengthunit, lengthtype, and lengthdet at fifth tagging interaction. NUMBER 172 LENGTH_UNIT_5 VARCHAR2 2 No No Active Units for Length Measurement at fifth tagging interaction. VARCHAR2 173 LENGTH_TYPE_5 VARCHAR2 1 No No Active Code to determine The Type Of Length Measurement taken at fifth tagging interaction. VARCHAR2 174 LENGTH_DETERMINATION_5 VARCHAR2 1 No No Active Code To Indicate How Length Was determined at fifth tagging interaction VARCHAR2 175 WEIGHT_5 NUMBER 22 No No 6 2 Active Weight of an animal tagged, based upon weightunit, weighttype and weightdet at fifth tagging interaction. NUMBER 176 WEIGHT_UNIT_5 VARCHAR2 2 No No Active Units for Weight Measurement t fifth tagging interaction. VARCHAR2 177 WEIGHT_TYPE_5 VARCHAR2 1 No No Active Code For Type Of Weight Measurement at fifth tagging interaction. VARCHAR2 178 WEIGHT_DETERMINATION_5 VARCHAR2 1 No No Active Code For How Weight Was Determined at fifth tagging interaction. VARCHAR2 179 LATITUDE_5 NUMBER 22 No No 30 16 Active Numeric value for the latitude of the tagging location at fifth tagging interaction. NUMBER 180 LONGITUDE_5 NUMBER 22 No No 30 16 Active Numeric value the the longitude of the tagging location at fifth tagging interaction. NUMBER 181 STAT_ZONE_ID_5 NUMBER 22 No No 4 1 Active Code to indciate State Zone at fifth tagging interaction NUMBER 182 COUNTRY_ID_5 VARCHAR2 2 No No Active Code to indicate Country at fifth tagging interaction VARCHAR2 183 STATE_ID_5 VARCHAR2 2 No No Active Code to indicate state at fifth tagging interaction VARCHAR2 184 WATER_BODY_ID_5 NUMBER 22 No No 6 3 Active Code to Indicate waterbody of where tagging took place at fifth tagging interaction NUMBER 185 PLACE_ID_5 VARCHAR2 3 No No Active Code to indicate place of wheer tagging took place at fifth tagging interaction VARCHAR2 186 GEAR_ID_5 VARCHAR2 3 No No Active Code for gear used to catch the animal at fifth tagging interaction. VARCHAR2 187 BAIT_TYPE_5 VARCHAR2 1 No No Active Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown at fifth tagging interaction. VARCHAR2 188 METHOD_ID_5 NUMBER 22 No No 6 0 Active Code To indicate tagging methodology Used at fifth tagging interaction NUMBER 189 SAMPLE_ID_5 NUMBER 22 No No 6 0 Active Code to indicate Sampling Methodology at fifth tagging interaction NUMBER 190 CAPTAIN_AGENCY_5 VARCHAR2 3 No No Active Code to indicate agency which assigned angler code for boat captain at fifth tagging interaction. VARCHAR2 191 CAPTAIN_ID_5 NUMBER 22 No No 6 0 Active Unique numeric code assigned to an individual captain. Must be greater than zero or -99999 at fifth tagging interaction. NUMBER 192 TAGGER_INITIALS_5 VARCHAR2 3 No No Active Initials Of Taggers at fifth tagging interaction. VARCHAR2 193 TAGGER_TYPE_5 VARCHAR2 1 No No Active Indicates Type Of Tagger at fifth tagging interaction. VARCHAR2 194 TAGGER_AFFILIATION_5 VARCHAR2 3 No No Active Code Of Agency that is affiliated With The Tagger at fifth tagging interaction. VARCHAR2 195 VESSEL_AGENCY_5 VARCHAR2 3 No No Active Agency For Vessel Code at fifth tagging interaction. VARCHAR2 196 VESSEL_ID_5 NUMBER 22 No No 6 0 Active Agency supplied code identifying the vessel involved in the release or recapture of the animal at fifth tagging interaction. NUMBER 197 PHYSICAL_DATA_ID_5 NUMBER 22 No No 6 0 Active Physical Data Identification Number at fifth tagging interaction NUMBER 198 NOTES_5 NUMBER 22 No No 3 0 Active Any Other Notes On Tagging at fifth tagging interaction NUMBER 199 FIGHT_HOURS_5 NUMBER 22 No No 2 0 Active Number Of Hours Spent FIghting/Landings Fish at fifth tagging interaction NUMBER 200 FIGHT_MINUTES_5 NUMBER 22 No No 2 0 Active Number Of Minutes (up to 59) spent FIghting/Landings Fish at fifth tagging interaction NUMBER 201 ANGLER_AGENCY_5 VARCHAR2 3 No No Active Agency That Has Angler Code list at fifth tagging interaction VARCHAR2 202 ANGLER_ID_5 NUMBER 22 No No 6 0 Active Angler Code at fifth tagging interaction . NUMBER 203 DATE_ENTERED_5 DATE 7 No No Active The date the data was entered at fifth tagging interaction. DATE 7103 LOCATIONS_VIEW Published / External Completed View Of Archival Tag Locations Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT View Of Archival Tag Locations 1 ARCHIVAL_TAG_ID VARCHAR2 10 No No Active Archival Tag Number VARCHAR2 2 DAY NUMBER 22 No No 38 Active Day NUMBER 3 MONTH NUMBER 22 No No 38 Active Month NUMBER 4 YEAR NUMBER 22 No No 38 Active Year NUMBER 5 LONGITUDE NUMBER 22 No No 38 Active Latitude Location NUMBER 6 LATITUDE NUMBER 22 No No 38 Active Longitude Location NUMBER 7104 PAT_TAG_BIN_TYPES Published / External Completed Table Of Valid PAT Bin Types Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table Of Valid PAT Bin Types 1 TYPE VARCHAR2 10 Yes No Active Bin Type Description VARCHAR2 7105 PDT_AGG_V Published / External Completed Profile at Depth and Time (PDT) - giving only temperature ranges and first depth measurement Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT Profile at Depth and Time (PDT) - giving only temperature ranges and first depth measurement 1 DEPTH NUMBER 22 No No 4 0 Active Depth NUMBER 2 MIN_TEMP NUMBER 22 No No 5 1 Active Minimum Temperature NUMBER 3 MAX_TEMP NUMBER 22 No No 5 1 Active Maximum Temperature NUMBER 4 AVE_TEMP NUMBER 22 No No 38 Active Average Temperature NUMBER 7106 RECAPTURES_VW Published / External Completed View Of Recaptured animals with the GIS Components Of The recpature Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT View Of Recaptured animals with the GIS Components Of The recpature 1 ANIMAL_ID NUMBER 22 Yes No 10 0 Active Anumal ID NUMBER 2 GEOM SDO_GEOMETRY 64 No No Active GIS Information SDO_GEOMETRY 7107 SECOND_INTERACTIONS_V Published / External Completed View of First Recapture Records Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT View of First Recapture Records 1 ANIMAL_ID NUMBER 22 Yes No 10 0 Active Key to Identifies Animal NUMBER 2 SPECIES VARCHAR2 3 Yes No Active Species Code Used In NMFS Tagging Program VARCHAR2 3 SEX VARCHAR2 1 No No Active Code to indicate sex of the animal VARCHAR2 4 AGENCY_ID VARCHAR2 3 Yes No Active Code to Indicate Tagging agency of identifying tag on animal (tag1) VARCHAR2 5 TAG_ID VARCHAR2 8 Yes No Active Tagnumber VARCHAR2 6 EVENT_ID NUMBER 22 Yes No 2 0 Active Code to identify tagging event NUMBER 7 TAG_DATE DATE 7 Yes No Active Date animal was released or recaptured. DATE 8 NEXT_TAG_AGENCY VARCHAR2 3 No No Active Code For Agency That Issued the next tag (second tag) on this record VARCHAR2 9 NEXT_TAG_ID VARCHAR2 8 No No Active Code to Indicate Tagging agency of identifying tag on animal (nexttag) VARCHAR2 10 INTERACTION_ORDER NUMBER 22 Yes No 2 0 Active Number denoting the order of the interaction. NUMBER 11 LENGTH NUMBER 22 No No 4 0 Active Length of animal tagged based on the lengthunit, lengthtype, and lengthdet. NUMBER 12 LENGTH_UNIT VARCHAR2 2 No No Active Units for Length Measurement VARCHAR2 13 LENGTH_TYPE VARCHAR2 1 No No Active Code to determine The Type Of Length MEasurement taken VARCHAR2 14 LENGTH_DETERMINATION VARCHAR2 1 No No Active Code To Indicate How Length Was determined VARCHAR2 15 WEIGHT NUMBER 22 No No 6 2 Active Weight of an animal tagged, based upon weightunit, weighttype and weightdet. NUMBER 16 WEIGHT_UNIT VARCHAR2 2 No No Active Units for Weight Measurement VARCHAR2 17 WEIGHT_TYPE VARCHAR2 1 No No Active Code For Type Of Weight Measurement VARCHAR2 18 WEIGHT_DETERMINATION VARCHAR2 1 No No Active Code For How Weight Was Determined VARCHAR2 19 LATITUDE NUMBER 22 No No 30 16 Active Numeric value for the latitude of the tagging location. NUMBER 20 LONGITUDE NUMBER 22 No No 30 16 Active Numeric value the the longitude of the tagging location. NUMBER 21 STAT_ZONE_ID NUMBER 22 No No 4 1 Active Code to indciate State Zone NUMBER 22 COUNTRY_ID VARCHAR2 2 No No Active Cde to indicate Country VARCHAR2 23 STATE_ID VARCHAR2 2 No No Active Code to indicate state VARCHAR2 24 WATER_BODY_ID NUMBER 22 No No 6 3 Active Code to Indicate waterbody of where tagging took place NUMBER 25 PLACE_ID VARCHAR2 3 No No Active Code to indicate place of wheer tagging took palce VARCHAR2 26 GEAR_ID VARCHAR2 3 No No Active Code for gear used to catch the animal. VARCHAR2 27 BAIT_TYPE VARCHAR2 1 No No Active Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown VARCHAR2 28 METHOD_ID NUMBER 22 No No 6 0 Active Code To indicate tagging methodology Used NUMBER 29 SAMPLE_ID NUMBER 22 No No 6 0 Active Code to indicate Sampling Methodology NUMBER 30 CAPTAIN_AGENCY VARCHAR2 3 No No Active COde to indicate agency which assigned angler code for boat captain VARCHAR2 31 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 32 TAGGER_INITIALS VARCHAR2 3 No No Active Initials Of Taggers VARCHAR2 33 TAGGER_TYPE VARCHAR2 1 No No Active Indicates Type Of Tagger VARCHAR2 34 TAGGER_AFFILIATION VARCHAR2 3 No No Active Code Of Agency that is affiliated With The Tagger VARCHAR2 35 VESSEL_AGENCY VARCHAR2 3 No No Active Agency For Vessel COode VARCHAR2 36 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 37 PHYSICAL_DATA_ID NUMBER 22 No No 6 0 Active Physical Data Identification Number NUMBER 38 NOTES NUMBER 22 No No 3 0 Active Any Other Notes On Tagging NUMBER 39 FIGHT_HOURS NUMBER 22 No No 2 0 Active Number Of Hours Spent FIghting/Landings Fish NUMBER 40 FIGHT_MINUTES NUMBER 22 No No 2 0 Active Number Of Minutes (up to 59) spent FIghting/Landings Fish NUMBER 41 ANGLER_AGENCY VARCHAR2 3 No No Active Agency That Has Angler Code list VARCHAR2 42 ANGLER_ID NUMBER 22 No No 6 0 Active Unique identifier for each person in the database. NUMBER 43 DATE_ENTERED DATE 7 No No Active The date the data was entered. DATE 7108 SEL_ANIMALS_DATA Published / External Completed View Listing Selected Animals and their associated species code and code to indicate sex of animal Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT View Listing Selected Animals and their associated species code and code to indicate sex of animal 1 ANIMAL_ID NUMBER 22 Yes No 10 0 Active Sequential Key To identify animal NUMBER 2 SPECIES_ID VARCHAR2 3 Yes No Active Species Code VARCHAR2 3 SEX VARCHAR2 1 No No Active Code To Indicate Sex Of Animal VARCHAR2 7109 SEL_ANIMALS_V Published / External Completed ANimals in 2001 That Had Interactions Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT ANimals in 2001 That Had Interactions 1 ANIMAL_ID NUMBER 22 Yes No 10 0 Active Animal ID NUMBER 7110 SEL_TBF_INTERACTIONS Published / External Completed Table Of Selected Tagging Interactions Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Table Of Selected Tagging Interactions 1 TAG_ID VARCHAR2 8 No No Active Tag Id Number VARCHAR2 7111 TBF_ANGLERS Published / External Completed Copy of Angler Table From The Bullfish Foundation Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Copy of Angler Table From The Bullfish Foundation 1 ANGLER_ID NUMBER 22 Yes Yes 38 0 Active Angler Number (Artificial Key) NUMBER 2 DATEENTERED DATE 7 No No Active Date Record Was Entered DATE 3 ORGANIZATION VARCHAR2 100 No No Active Organization Angler Noted to be being a member of VARCHAR2 4 TITLE VARCHAR2 20 No No Active Title Of Angler (Mr, Captain, DR etc) VARCHAR2 5 FIRSTNAME VARCHAR2 30 No No Active Angler FIrst Name VARCHAR2 6 LASTNAME VARCHAR2 30 Yes No Active Angler Last Name VARCHAR2 7 SUFFIX VARCHAR2 20 No No Active Suffic Of Angler Name (Jr. Sr. 111 etc) VARCHAR2 8 ADDRESS1 VARCHAR2 100 No No Active First Line Of Angler Address VARCHAR2 9 ADDRESS2 VARCHAR2 100 No No Active Second Line Of Angler Address VARCHAR2 10 CITY VARCHAR2 50 Yes No Active City Of Angler Address VARCHAR2 11 STATE VARCHAR2 30 Yes No Active State Of Angler Address VARCHAR2 12 ZIP VARCHAR2 30 Yes No Active ZIp Code Of Angler Address VARCHAR2 13 COUNTRY VARCHAR2 30 No No Active Country Of Angler Address VARCHAR2 14 HOMEPHONE VARCHAR2 30 No No Active Home phone Number Of Angler VARCHAR2 15 WORKPHONE VARCHAR2 30 No No Active Work phone Number Of Angler VARCHAR2 16 MISC VARCHAR2 100 No No Active Miscellaneous Note About the Angler VARCHAR2 17 FAX VARCHAR2 15 No No Active Fax Of Angler VARCHAR2 18 LAST_UPDATE DATE 7 No No Active Data Record Was Last Updated DATE 19 CLEAN VARCHAR2 5 No No Active Code to indicate cleanliness of data VARCHAR2 20 FOREIGN_ZIP VARCHAR2 30 No No Active vetigal column having no use VARCHAR2 21 BOAT VARCHAR2 50 No No Active Boat Name Of WHere Angler Fished, VARCHAR2 22 FLEET VARCHAR2 10 No No Active Is a fleet associated with the boat. (Y if YEs, otherwise blank( VARCHAR2 23 FLEETNAME VARCHAR2 20 No No Active Fleetname When Boat is associated WIth a Fleet VARCHAR2 7112 TBF_ANIMALS Published / External Completed List Of Animal From The BIll Fish Foundation with Species Codes Converted To Codes Used in Tagging Application Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT List Of Animal From The BIll Fish Foundation with Species Codes Converted To Codes Used in Tagging Application 1 ANIMAL_ID NUMBER 22 Yes Yes 10 0 Active Animal Id Number NUMBER 2 SPECIES_ID VARCHAR2 3 Yes No Active Species Code VARCHAR2 3 SEX VARCHAR2 1 No No Active Sex Code VARCHAR2 4 GEOM SDO_GEOMETRY 1 No No Active Geometry SDO_GEOMETRY 7113 TBF_CAPTURE Published / External Completed CTS.TBF_CAPTURE is the primary table of the CTS systems.It contains the information on the actual tagging event, such as,the initial release, the recapture or the re-release of an animal. Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT CTS.TBF_CAPTURE is the primary table of the CTS systems.It contains the information on the actual tagging event, such as,the initial release, the recapture or the re-release of an animal. 1 TAG_ID VARCHAR2 8 Yes Yes 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 2 TAG_DATE DATE 7 No No Active Date animal was released or recaptured. DATE 3 FISHCODE VARCHAR2 10 Yes No Active TBF Fish Code VARCHAR2 4 FISH VARCHAR2 50 No No Active Name Of Fish VARCHAR2 5 RERELEASED VARCHAR2 20 No No Active Was Fish Released After It was Recaptured VARCHAR2 6 RECAPTURE_DATE DATE 7 Yes Yes Active Date Animal Was Recaptured DATE 7 LOCALITY VARCHAR2 130 No No Active Locality Where Fish Was Recaptured VARCHAR2 8 LENGTH2 VARCHAR2 30 No No Active Length MEasurement at time of second recpature VARCHAR2 9 WEIGHT2 VARCHAR2 30 No No Active Weight measurement at time of second recapture VARCHAR2 10 ANGLER2 VARCHAR2 30 No No Active Angler Number Of recapturing Angler VARCHAR2 11 A2FIRST VARCHAR2 50 No No Active Recapturing Angler First Name VARCHAR2 12 A2LAST VARCHAR2 50 No No Active Recapturing Angler Last Name VARCHAR2 13 FISH_CONDITION VARCHAR2 50 No No Active Descriptive Fish Condition at time of recapture VARCHAR2 14 DAYSATLARGE VARCHAR2 50 No No Active Number Of Days ANimal Was At Large VARCHAR2 15 NMFS_SHED VARCHAR2 20 No No Active Was The NMFS Tag Shed At time of recapture VARCHAR2 16 LAT2 VARCHAR2 30 No No Active Latitude at Time Of Recapture VARCHAR2 17 LON2 VARCHAR2 30 No No Active Longitude at Time Of Recapture VARCHAR2 18 REMARKS2 VARCHAR2 130 No No Active Remarks About Recapture VARCHAR2 19 RETAG VARCHAR2 20 No No Active Inicates If animal Was animal retagged VARCHAR2 20 NEWTAG VARCHAR2 10 No No Active If a new tag is applied to a fish upon re-release, this is the number of that tag VARCHAR2 21 LORAN VARCHAR2 50 No No Active Loran reading for location of recapture VARCHAR2 22 RECAPTURE VARCHAR2 20 No No Active Was This a Recapture Record VARCHAR2 23 EDIT VARCHAR2 20 No No Active Was Recorded Editted After Entry VARCHAR2 24 NS VARCHAR2 20 No No Active Second Latitude Hemisphere Meaurement VARCHAR2 25 EW VARCHAR2 20 No No Active Second Longitde Hemiphere Measurement VARCHAR2 26 WT1 VARCHAR2 30 No No Active Second Weight Measurment VARCHAR2 27 LTH1 VARCHAR2 30 No No Active Second Length Measurement VARCHAR2 28 CODE2 FLOAT 22 No No 126 Active Second Tagnumber FLOAT 29 CODE4 FLOAT 22 No No 126 Active Fourth Tagnumber FLOAT 30 C2FIRST VARCHAR2 50 No No Active Boat Captain First Name VARCHAR2 31 C2LAST VARCHAR2 50 No No Active Boat Captain Last Name VARCHAR2 32 BOAT VARCHAR2 100 No No Active Boat Name VARCHAR2 33 GEAR VARCHAR2 30 No No Active Code for gear used to catch the animal. VARCHAR2 34 LASTUPDATE DATE 7 No No Active Date Record has last been updated DATE 35 OCEAN VARCHAR2 50 No No Active Logical Flag to indicate If Fish was caught in the opern waters of an ocean VARCHAR2 36 KILLED VARCHAR2 20 No No Active Was Fished Killed Upon Recapture VARCHAR2 37 NMFS_STUDY VARCHAR2 20 No No Active Is This data used as part of NMFS (tag shedding) study VARCHAR2 38 LONGLINE VARCHAR2 20 No No Active Was a longline used to catch fish VARCHAR2 39 LJFT VARCHAR2 20 No No Active LJFT Measurement VARCHAR2 40 ORIG_FOUND VARCHAR2 20 No No Active Was original tag still on fish VARCHAR2 41 OLD_LOCALITY VARCHAR2 100 No No Active Old Location Code VARCHAR2 42 LATDEG FLOAT 22 No No 126 Active Degrees latitude where animal was released/recaptured. Range 0 to 90 degrees. FLOAT 43 LATMIN FLOAT 22 No No 126 Active Minutes of latitude where animal was released/recaptured. Range 0 - 59.99 minutes. FLOAT 44 LATHEM VARCHAR2 10 No No Active Hemisphere of latitude where animal was released/recaptured. (N)orth, (S)outh, (U)nknown VARCHAR2 45 LONDEG FLOAT 22 No No 126 Active Degrees of longitude where animal was released/recaptured. Range 0 to 180 degrees FLOAT 46 LONMIN FLOAT 22 No No 126 Active Minutes of longitude where animal was released/recaptured. Range 0 - 59.99 minutes. FLOAT 47 LONHEM VARCHAR2 10 No No Active Hemisphere of longitude where animal was released/recaptured: (E)ast, (W)est, (U)nknown VARCHAR2 48 LENGTH FLOAT 22 No No 126 Active Length of animal tagged based on the lengthunit, lengthtype, and lengthdet. FLOAT 49 LENGTHUNIT VARCHAR2 10 No No Active Length measurement used: (IN) inches, (FT) feet, (MM) millimeters, (M ) meters, (UN) unknown, (CM) centimeters VARCHAR2 50 LENGTHTYPE VARCHAR2 10 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 51 LENGTHDETERMINATION VARCHAR2 10 No No Active How Length Was Determined VARCHAR2 52 WEIGHT FLOAT 22 No No 126 Active Weight of an animal tagged, based upon weightunit, weighttype and weightdet. FLOAT 53 WEIGHTUNIT VARCHAR2 10 No No Active Weight measurement used: (OZ) ounces, (LB) pounds, (GM) grams, (KG) Kilograms, (UN) Unknown VARCHAR2 54 WEIGHTTYPE VARCHAR2 10 No No Active Weight measurement type: (R)ound, (D)ressed, (U)nknown VARCHAR2 55 WEIGHTDETERMINATION VARCHAR2 10 No No Active How Weight Was Determined VARCHAR2 56 FIGHT_HRS FLOAT 22 No No 126 Active Number Of Hours Spent Fighting FIsh Until Landings FLOAT 57 FIGHT_MINS FLOAT 22 No No 126 Active Number Of Minutes Spent Fighting FIsh Until Landings FLOAT 58 DUPLICATE_NAME VARCHAR2 8 No No Active Tag Number To Refernce For Doubly Tagged Fished VARCHAR2 7114 TBF_CAPTURE_ANIMALS_V Published / External Completed View Of Animals Captured That had been tagged with (TBF) Tags Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT View Of Animals Captured That had been tagged with (TBF) Tags 1 TBF_TAG VARCHAR2 8 Yes No Active (TBF) Tagnumber VARCHAR2 2 TBF_SPECIES VARCHAR2 10 Yes No Active (TBF) Species Code VARCHAR2 3 ANIMAL_ID NUMBER 22 No No 10 0 Active Animal Id NUMBER 4 INTERACTION_ORDER NUMBER 22 No No 2 0 Active Interaction Order NUMBER 7115 TBF_CAPTURE_DISTINCT_TAGS_V Published / External Completed View Of Distinct Billfish Foundation Tags That Have Been Recaptured Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT View Of Distinct Billfish Foundation Tags That Have Been Recaptured 1 TBF_TAG VARCHAR2 8 Yes No Active (TBF) Tagnumber VARCHAR2 2 TBF_SPECIES VARCHAR2 10 Yes No Active (TBF) Species Code VARCHAR2 7116 TBF_CAPTURE_LINK_V Published / External Completed View Connecting Data In Billfish Assocation Tables WIth that iof tables in CTS System Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT View Connecting Data In Billfish Assocation Tables WIth that iof tables in CTS System 1 TBF_TAG VARCHAR2 8 Yes No Active Billfish Agency Tag Number VARCHAR2 2 TBF_DATE DATE 7 Yes No Active Date Billfish Agency Tag Was Applied DATE 3 TBF_SPECIES VARCHAR2 10 Yes No Active Billfish Association Species Code VARCHAR2 4 ANIMAL_ID NUMBER 22 No No 10 0 Active Sequential Key NUMBER 5 CTS_TAG VARCHAR2 8 No No Active Tag Number Of Agency In CTS System VARCHAR2 6 CTS_AGENCY VARCHAR2 3 No No Active CTS Agency Code VARCHAR2 7 CTS_DATE VARCHAR2 10 No No Active Date Other (CTS) Tag was Applied VARCHAR2 8 INTERACTION_ORDER NUMBER 22 No No 2 0 Active Code To indicate Whether Tagging Action Was A Release Or Recpature NUMBER 7117 TBF_CTS_ANGLERS_V Published / External Completed View Joing ANgler Table For Agency MIA and TBF Angler Table to see difference in spelling between names Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT View Joing ANgler Table For Agency MIA and TBF Angler Table to see difference in spelling between names 1 ANGLER_ID NUMBER 22 Yes No 38 0 Active Angler Number NUMBER 2 FIRSTNAME VARCHAR2 30 No No Active Angler FIrst Name In TBF Angler Table VARCHAR2 3 LASTNAME VARCHAR2 30 Yes No Active Angler Last Name In TBF Angler Table VARCHAR2 4 FNAME VARCHAR2 30 No No Active Angler FIrst Name In Angler Table For Agency MIA VARCHAR2 5 LNAME VARCHAR2 30 No No Active Angler Last Name In Angler Table For Agency MIA VARCHAR2 7118 TBF_FIRST_RECAPTURES_V Published / External Completed CTS.TBF_FIRST_RECAPTURES_V contains informat on first recaptures by TBF. Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT CTS.TBF_FIRST_RECAPTURES_V contains informat on first recaptures 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 7119 TBF_INTERACTIONS Published / External Completed CTS.TBF_INTERACTIONS is the primary table of the CTS systems.It contains the information on the actual tagging event, such as,the initial release, the recapture or the re-release of an animal. Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT CTS.TBF_INTERACTIONS is the primary table of the CTS systems.It contains the information on the actual tagging event, such as,the initial release, the recapture or the re-release of an animal. 1 ANIMAL_ID NUMBER 22 Yes No 10 0 Active Unique identifier for each animal NUMBER 2 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 3 TAG_DATE DATE 7 Yes No Active Date animal was released or recaptured. DATE 4 PRIOR_TAG VARCHAR2 8 No No Active Any previous tag that may have been on the animal. VARCHAR2 5 INTERACTION_ORDER NUMBER 22 Yes No 2 0 Active Number denoting the order of the interaction. NUMBER 6 LENGTH NUMBER 22 No No 4 0 Active Length of animal tagged based on the lengthunit, lengthtype, and lengthdet. NUMBER 7 LENGTHUNIT VARCHAR2 2 No No Active Length measurement used: (IN) inches, (FT) feet, (MM) millimeters, (M ) meters, (UN) unknown, (CM) centimeters VARCHAR2 8 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 9 LENGTHDET VARCHAR2 1 No No Active Method of determining length: (E)stimated, (M)easured, (U)nknown VARCHAR2 10 WEIGHT NUMBER 22 No No 6 2 Active Weight of an animal tagged, based upon weightunit, weighttype and weightdet. NUMBER 11 WEIGHTUNIT VARCHAR2 2 No No Active Weight measurement used: (OZ) ounces, (LB) pounds, (GM) grams, (KG) Kilograms, (UN) Unknown VARCHAR2 12 WEIGHTTYPE VARCHAR2 1 No No Active Weight measurement type: (R)ound, (D)ressed, (U)nknown VARCHAR2 13 WEIGHTDET VARCHAR2 1 No No Active Method of determining weight: (E)stimated, (M)easured, (U)nknown. VARCHAR2 14 LATITUDE NUMBER 22 No No 30 16 Active Numeric value for the latitude of the tagging location. NUMBER 15 LONGITUDE NUMBER 22 No No 30 16 Active Numeric value the the longitude of the tagging location. NUMBER 16 LOCATION_NAME VARCHAR2 255 No No Active Text string describing the location where the animal was caught. VARCHAR2 17 GEAR_ID VARCHAR2 3 No No Active Code for gear used to catch the animal. VARCHAR2 18 BAIT_TYPE VARCHAR2 1 No No Active Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown VARCHAR2 19 CAPTAIN_AGENCY_ID VARCHAR2 3 No No Active The agency code for the captain. VARCHAR2 20 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 21 VESSEL_AGENCY_ID VARCHAR2 3 No No Active The agency code for the vessel. VARCHAR2 22 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 23 FIGHTHRS NUMBER 22 No No 3 1 Active The number of hours spent fighting the fish before it was tagged. NUMBER 24 FIGHTMINS NUMBER 22 No No 3 1 Active The minutes part of the time spent fighting the fish before it was tagged. NUMBER 25 ANGLER_AGENCY_ID VARCHAR2 3 No No Active The agency code for the angler. VARCHAR2 26 ANGLER_ID NUMBER 22 No No 6 0 Active Unique identifier for each person in the database. NUMBER 27 GEOM SDO_GEOMETRY 1 No No Active Oracle Spatial vector geometry object to store the track. SDO_GEOMETRY 28 ID NUMBER 22 Yes Yes 38 Active A unique identifier for each interaction. NUMBER 29 DATE_ENTERED DATE 7 No No Active The date the data was entered. DATE 7120 TBF_NEW_DISTINCT_TAGS_V Published / External Completed List Of Distinct TBF Tags Loaded by batch 2083, 02-22-2008 12:10 Data View Yes CTSPAT List Of Distinct TBF Tags 1 TBF_TAG VARCHAR2 8 Yes No Active TBF Tagnumber VARCHAR2 2 TBF_SPECIES VARCHAR2 10 Yes No Active TBF Species Code VARCHAR2 7121 TBF_PERSONS Published / External Completed Person Table From The Bill Fish Foundation Loaded by batch 2083, 02-22-2008 12:10 Data Table Yes CTSPAT Person Table From The Bill Fish Foundation 1 AGENCY_ID VARCHAR2 3 Yes No Active Code identifying the agency the person is affiliated. VARCHAR2 2 ID NUMBER 22 Yes Yes 38 Active Unique identifer for each person. NUMBER 3 TITLE VARCHAR2 20 No No Active The persons official title ('CAPT.', 'Mr.', 'Mrs.') VARCHAR2 4 FIRSTNAME VARCHAR2 30 No No Active First Name VARCHAR2 5 LASTNAME VARCHAR2 30 Yes No Active Last Name VARCHAR2 6 M_INITIAL VARCHAR2 2 No No Active Midle Iniitial VARCHAR2 7 SUFFIX VARCHAR2 20 No No Active Name Suffix (like Jr) VARCHAR2 8 ADDRESS1 VARCHAR2 100 No No Active First Line Of Address VARCHAR2 9 ADDRESS2 VARCHAR2 100 No No Active Second Line Of Address VARCHAR2 10 CITY VARCHAR2 50 No No Active City of mailing address VARCHAR2 11 STATE VARCHAR2 30 No No Active Stae Of mailling address VARCHAR2 12 ZIP VARCHAR2 30 No No Active Zipcode Of Mailing Address VARCHAR2 13 COUNTRY VARCHAR2 30 No No Active Country Of Mailing Address VARCHAR2 14 HOME_NUMBER VARCHAR2 30 No No Active Home Phone Number VARCHAR2 15 WORK_NUMBER VARCHAR2 30 No No Active Work Phone Number VARCHAR2 16 MOBILE_NUMBER VARCHAR2 100 No No Active Mobile/Celluar Number VARCHAR2 17 FAX_NUMBER VARCHAR2 15 No No Active Facsimile Number VARCHAR2 18 EMAIL VARCHAR2 50 No No Active Email Address VARCHAR2 Data Steward 2000 Person Orbesen, Eric Eric.Orbesen@noaa.gov 75 Virginia Beach Drive Miami 33149 305-361-4253 Contact by email preferred. Data Steward 1985-01-01 2011 Person Prince, Eric Distributor 1954 Organization Southeast Fisheries Science Center SEFSC https://ror.org/0396y0w87 75 Virginia Beach Drive Miami FL 33149 USA (305)361-5761 https://www.fisheries.noaa.gov/about/southeast-fisheries-science-center About SEFSC Online Resource 8:00 a.m. - 4:30 p.m. EST Metadata Contact 2000 Person Orbesen, Eric Eric.Orbesen@noaa.gov 75 Virginia Beach Drive Miami 33149 305-361-4253 Contact by email preferred. Point of Contact 2015 Person Hoolihan, John john.hoolihan@noaa.gov 75 Virginia Beach Drive Miami FL 33149 USA 305-365-4116 Ground Condition -97 -64 42 3 CTS uses latitude and longitude to identify where the animal is released and recaptured. Most of the events occurs between latitude 3 - 42 N and 64 - 97 W. It includes the Atlantic Ocean, Gulf of Mexico, and Caribbean Sea Continuing 2011 -179 179 50 -50 Global Range 1954 2010 Sensitive . TBD The data will be available from a public web server once an access methodology has been developed. Angler names and addresses TBD If the tag date for an initial release in Jan 1, 1940, it means that the the initial tag data is not known Oracle Database Constituent based tagging programs are susceptible to both recording and input errors. We are currently scanning historical data cards and examining the database for suspect locations (on land, or in an unexpected location based on species preferences) and correcting any errors. No 0 Yes Yes No 365 This data is currently wavered under the current NOAA guidelines for relational databases. To Be Determined 365 The data resides on a secure government network requiring multi-factor authentication for network access. 1 Data is inputted into an oracle database and yearly the data is examined using arcgis to identify suspect locations. 7024 Entity 7025 Entity 7026 Entity 7027 Entity 7029 Entity 7030 Entity 7033 Entity 7034 Entity 7036 Entity 7037 Entity 7038 Entity 7039 Entity 7040 Entity 7041 Entity 7042 Entity 7043 Entity 7044 Entity 7045 Entity 7046 Entity 7050 Entity 7051 Entity 7052 Entity 7053 Entity 7055 Entity 7056 Entity 7057 Entity 7058 Entity 7060 Entity 7062 Entity 7063 Entity 7065 Entity 7067 Entity 7068 Entity 7071 Entity 7072 Entity 7074 Entity 7075 Entity 7076 Entity 7078 Entity 7079 Entity 7080 Entity 7081 Entity 7082 Entity 7083 Entity 7085 Entity 7086 Entity 7087 Entity 7088 Entity 7089 Entity 7091 Entity 7092 Entity 7093 Entity 7094 Entity 7095 Entity 7096 Entity 7097 Entity 7104 Entity 7110 Entity 7111 Entity 7112 Entity 7113 Entity 7119 Entity 7121 Entity 7124 Entity 7022 Entity 7023 Entity 7028 Entity 7031 Entity 7032 Entity 7035 Entity 7047 Entity 7048 Entity 7049 Entity 7054 Entity 7059 Entity 7061 Entity 7064 Entity 7066 Entity 7069 Entity 7070 Entity 7073 Entity 7077 Entity 7084 Entity 7090 Entity 7098 Entity 7099 Entity 7100 Entity 7101 Entity 7102 Entity 7103 Entity 7105 Entity 7106 Entity 7107 Entity 7108 Entity 7109 Entity 7114 Entity 7115 Entity 7116 Entity 7117 Entity 7118 Entity 7120 Entity 7122 Entity 7123 Entity 7125 Entity 7126 Entity gov.noaa.nmfs.inport:5453 Lee Weinberger 2007-10-16T08:26:31 SysAdmin InPortAdmin 2026-03-04T19:17:18 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 No 2021-05-05 1 Year 2022-05-05