27387 Yellowtail Tagging Data (MRDBS) Data Set Published / External 23136 Northeast Cooperative Research Program (NCRP) Project Completed The Yellowtail Flounder Tagging Program began in 2003 and works with commercial fishermen to tag and release yellowtaiI flounder with pink and yellow disc tags or green data storage tags throughout New England. The location, date and various Information is recorded upon the release of the tagged fish and the same information is recorded when the fish is recaptured by fishermen or other reporters. From this information stock movements, mortality, and growth can be estimated which leads to more accurate biological and stock assessments. The yellowtall flounder fishery is one of the most valuable and productive in New England, however more information is needed for accurate assessments and management plans. The major goals of this tagging program are to estimate yellowtail movement between the three stock areas, namely Cape Cod/Gulf of Maine, Georges Bank, and Southern New England/Mid-Atlantic. Also to estimate mortality rates within the stock areas and observe growth and behavior. It is highly recommended that all data request be accompanied by a request for summary of support tables to guide the end-user on data input and data applications. Theme Cooperative research Theme behavior Theme growth Theme mortality rates Theme recapture Theme release Theme tag Theme tagging program Theme yellowtail flounder Spatial Cape Cod Spatial Georges Bank Spatial Gulf of Maine Spatial Mid-Atlantic Spatial Southern New England NEFSC Woods Hole Lab Woods Hole MA USA Data Set Oracle Database As Needed Table (digital) Conventional disk tags (point-to-point location) and Lotek archival tags (geolocation based on depth and temperature signals from fish movement) Commercial Fishing vessels Commercial trawl and gill net gear for fish sampling and occasional deployment of hydrolab equipment for collecting water quality samples 33877 MRBYCATCH Published / External Completed Bycatch Loaded by batch 9110, 08-01-2016 12:11 Data Table Yes MRDBS Bycatch 1 FISHERY VARCHAR2 2 Yes Yes Active Fishery Code, a two character fishery identification code. See support table MRFISHERY for codes and descriptions. VARCHAR2 MRDBS.MRHAUL 2 TRIPID VARCHAR2 8 Yes Yes Active Trip identification code, for yellowtail tagging, trip id consists of YT[year]-[sequential number of trip within year]. VARCHAR2 MRDBS.MRHAUL 3 HAULNUM VARCHAR2 4 Yes Yes Active Ordinal number of the haul within the trip, set number for shark cruises. VARCHAR2 MRDBS.MRHAUL 4 SPECIES_ITIS VARCHAR2 11 Yes Yes Active Itis species code, see support table MRSPECIES for descriptions. VARCHAR2 MRDBS.MRSPECIES 5 HAILWGT NUMBER 22 No No 8 1 Active Estimated hail weight. NUMBER 6 HAILWGTUOM VARCHAR2 3 No No Active Unit of measure used for haul weight (LB, KG). VARCHAR2 7 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). DATE 8 UOE VARCHAR2 12 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 9 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). DATE 10 UOC VARCHAR2 12 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 11 WEB_DOE DATE 7 No No Active Date when record was inserted into Oracle by the web application. Date format (DD-MON-YYYY HH24:MI:SS). DATE 12 WEB_UOE VARCHAR2 1 No No Active The username of the individual who entered the new record using the web application. VARCHAR2 13 WEB_DOC DATE 7 No No Active Date when the current record was updated or changed by the web application. Date format (DD-MON-YYYY HH:MI:SS). DATE 14 WEB_UOC VARCHAR2 12 No No Active The username of the individual who changed the current record using the web application. VARCHAR2 33878 MRHAUL Published / External Completed Haul or Tow Information Loaded by batch 9110, 08-01-2016 12:11 Data Table Yes MRDBS Haul or Tow Information 1 FISHERY VARCHAR2 2 Yes Yes Active Fishery Code, a two character fishery identification code. See support table MRFISHERY for codes and descriptions. VARCHAR2 MRDBS.MRTRIP 2 TRIPID VARCHAR2 8 Yes Yes Active Trip identification code, for yellowtail tagging, trip id consists of YT[year]-[sequential number of trip within year]. VARCHAR2 MRDBS.MRTRIP 3 HAULNUM VARCHAR2 4 Yes Yes Active Ordinal number of the haul within the trip, set number for shark cruises. VARCHAR2 4 HAULDATE DATE 7 No No Active Haul date. DATE 5 BEGINTIME VARCHAR2 4 No No Active Beginning time for haul (24 hr.). VARCHAR2 6 ENDTIME VARCHAR2 4 No No Active Ending time for haul (24 hr.). VARCHAR2 7 HAULTIMEZONE VARCHAR2 3 No No Active Time zone used for begin and end time. VARCHAR2 8 BEGLATDEG VARCHAR2 2 No No Active Beginning latitude degrees. (redacted) VARCHAR2 9 BEGLATMIN VARCHAR2 2 No No Active Beginning latitude minutes. (redacted) VARCHAR2 10 BEGLATSEC VARCHAR2 2 No No Active Beginning latitude seconds. (redacted) VARCHAR2 11 ENDLATDEG VARCHAR2 2 No No Active Ending latitude degrees. (redacted) VARCHAR2 12 ENDLATMIN VARCHAR2 2 No No Active Ending latitude minutes. (redacted) VARCHAR2 13 ENDLATSEC VARCHAR2 2 No No Active Ending latitude seconds. (redacted) VARCHAR2 14 MIDLATDEG VARCHAR2 2 No No Active Mid-point latitude degrees. (redacted) VARCHAR2 15 MIDLATMIN VARCHAR2 2 No No Active Mid-point latitude minutes. (redacted) VARCHAR2 16 MIDLATSEC VARCHAR2 2 No No Active Mid-point latitude seconds. (redacted) VARCHAR2 17 BEGLONDEG VARCHAR2 3 No No Active Beginning longitude degrees. (redacted) VARCHAR2 18 BEGLONMIN VARCHAR2 2 No No Active Beginning longitude minutes. (redacted) VARCHAR2 19 BEGLONSEC VARCHAR2 2 No No Active Beginning longitude seconds. (redacted) VARCHAR2 20 ENDLONDEG VARCHAR2 3 No No Active Ending longitude degrees. (redacted) VARCHAR2 21 ENDLONMIN VARCHAR2 2 No No Active Ending longitude minutes. (redacted) VARCHAR2 22 ENDLONSEC VARCHAR2 2 No No Active Ending longitude seconds. (redacted) VARCHAR2 23 MIDLONDEG VARCHAR2 3 No No Active Mid-point longitude degrees. (redacted) VARCHAR2 24 MIDLONMIN VARCHAR2 2 No No Active Mid-point longitude minutes. (redacted) VARCHAR2 25 MIDLONSEC VARCHAR2 2 No No Active Mid-point longitude seconds. (redacted) VARCHAR2 26 STOCK VARCHAR2 2 No No Active Stock area calculated from species and statarea, see support table MRSTOCKAREAS for descriptions. VARCHAR2 27 STATAREA VARCHAR2 3 No No Active Statistical area calculated from latitude and longitude, may override during data entry, note: stat area 551, 552 are in Canadian water. VARCHAR2 28 NEMAREA VARCHAR2 3 No No Active Inshore area calculated from latitude and longitude. VARCHAR2 29 WINDSPEED NUMBER 22 No No 4 1 Active Wind speed. NUMBER 30 WINDSPEEDUOM VARCHAR2 3 No No Active Unit of measure used for wind speed (KN, MPH). VARCHAR2 31 WINDDIR NUMBER 22 No No 4 1 Active Wind direction (degrees). NUMBER 32 DEPTH NUMBER 22 No No 4 0 Active Depth. NUMBER 33 DEPTHUOM VARCHAR2 3 No No Active Unit of measure used for depth (FM,FT,M). VARCHAR2 34 TOWSPEED NUMBER 22 No No 3 1 Active Tow speed. NUMBER 35 TOWSPEEDUOM VARCHAR2 3 No No Active Unit of measure used for towspeed (KN,MPH). VARCHAR2 36 WIREOUT NUMBER 22 No No 4 0 Active Wire out. NUMBER 37 WIREOUTUOM VARCHAR2 3 No No Active Unit of measure used for wireout (FM,FT,M). VARCHAR2 38 SURFTEMP NUMBER 22 No No 6 3 Active Surface water temperature . NUMBER 39 SURFTEMPUOM VARCHAR2 3 No No Active Unit of measure used for surface water temperature (F,C). VARCHAR2 40 BOTTEMP NUMBER 22 No No 6 3 Active Bottom water temperature. NUMBER 41 BOTTEMPUOM VARCHAR2 3 No No Active Unit of measure used for surface water temperature (F,C). VARCHAR2 42 HAULSITE VARCHAR2 2 No No Active Haul site code of publicity, see MRSITETYPES for descriptions (primarily used by black sea bass, scup). VARCHAR2 MRDBS.MRSITETYPES 43 GEAR VARCHAR2 2 No No Active Gear used, see support table MRGEARS for descriptions. VARCHAR2 44 HAULCOMMENT VARCHAR2 200 No No Active Haul comments. VARCHAR2 45 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). DATE 46 UOE VARCHAR2 12 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 47 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). DATE 48 UOC VARCHAR2 12 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 49 WEB_DOE DATE 7 No No Active Date when record was inserted into Oracle by the web application. Date format (DD-MON-YYYY HH24:MI:SS). DATE 50 WEB_UOE VARCHAR2 12 No No Active The username of the individual who entered the new record using the web application. VARCHAR2 51 WEB_DOC DATE 7 No No Active Date when the current record was updated or changed by the web application. Date format (DD-MON-YYYY HH:MI:SS). DATE 52 WEB_UOC VARCHAR2 12 No No Active The username of the individual who changed the current record using the web application. VARCHAR2 53 ENTSTATAREA VARCHAR2 3 No No Active Statistical area as entered from captain's log, note: stat area 551, 552 are in Canadian water. VARCHAR2 54 ENTSTOCK VARCHAR2 2 No No Active Stock area as entered from captain's log. VARCHAR2 33879 MRMVRELRECAP_01 Published / External Completed Release and Recapture Events for Yellowtail Fishery Loaded by batch 9110, 08-01-2016 12:11 Data Table Yes MRDBS Release and Recapture Events for Yellowtail Fishery 1 FISHERY VARCHAR2 2 No No Active Fishery Code, a two character fishery identification code. See support table MRFISHERY for codes and descriptions. VARCHAR2 2 ANIMALID VARCHAR2 14 No No Active Animal identification code, animal id will be a concatenation of fishery, original tag type, color, number, and suffix. VARCHAR2 3 TAG_TYPE VARCHAR2 2 No No Active Style of tag, see support table MRTAGTYPES for descriptions. (Note: For yellowtail, data storage tags were migrated to tag type 40 in MRDBS, before migration, they were tag type 03) VARCHAR2 4 TAG_COLOR VARCHAR2 2 No No Active Color of tag, see support table MRTAGCOLORS for descriptions. VARCHAR2 5 TAG_NUMBER VARCHAR2 6 No No Active Tag identification number. VARCHAR2 6 TAG_SUFFIX VARCHAR2 1 No No Active Tag suffix, for yellowtail, suffix A or B were used for transcription errors when recording tag or tag was removed from a poor condition fish and reused. VARCHAR2 7 REL_DATE VARCHAR2 10 No No Active Release date. VARCHAR2 8 REL_AREA VARCHAR2 3 No No Active Recapture statistical area calculated from latitude and longitude. VARCHAR2 9 REL_DECLAT VARCHAR2 9 No No Active Release latitude in decimal degrees. (redacted) VARCHAR2 10 REL_DECLON VARCHAR2 10 No No Active Release longitude in decimal degrees. (redacted) VARCHAR2 11 REL_TIME VARCHAR2 5 No No Active Time of release. VARCHAR2 12 REL_LENGTH_CM NUMBER 22 No No 6 2 Active Release length in centimeters. NUMBER 13 REL_SEX VARCHAR2 1 No No Active Release sex Sex ( 0 = male, 1 = female). VARCHAR2 14 REL_SCALES VARCHAR2 5 No No Active Scales taken at release. VARCHAR2 15 REL_OBSERVATIONS VARCHAR2 200 No No Active Release observations. VARCHAR2 16 TRIPID VARCHAR2 8 No No Active Trip identification code, for yellowtail tagging, trip id consists of YT[year]-[sequential number of trip within year]. VARCHAR2 17 HAULNUM VARCHAR2 4 No No Active Ordinal number of the haul within the trip, set number for shark cruises. VARCHAR2 18 RECAP_EVENT NUMBER 22 No No 3 0 Active Recapture event type, see support table MREVENTTYPES for descriptions. NUMBER 19 RECAP_DATE VARCHAR2 10 No No Active Recapture event date. VARCHAR2 20 RECAP_DATEQUAL VARCHAR2 2 No No Active Recapture event date quality, see support table MRDATE_QUALITY for descriptions. VARCHAR2 21 RECAP_NAME VARCHAR2 71 No No Active Recapture contact name. (redacted) VARCHAR2 22 RECAP_HULLNUM VARCHAR2 10 No No Active Recapture hull number. (redacted) VARCHAR2 23 RECAP_VESSEL VARCHAR2 40 No No Active Recapture vessel name. (redacted) VARCHAR2 24 RECAP_INDUSTRY VARCHAR2 2 No No Active Industry of contact at time of recapture. VARCHAR2 25 RECAP_GEAR VARCHAR2 2 No No Active Recapture gear code, see support table MRGEARS for descriptions. VARCHAR2 26 RECAP_REPORTED VARCHAR2 2 No No Active Recapture reported. VARCHAR2 27 RECAP_LENGTH_CM NUMBER 22 No No 6 2 Active Recapture length in centimeters. NUMBER 28 RECAP_LENQUAL VARCHAR2 2 No No Active Recapture length quality, see support table MRLENGTH_QUALITY for descriptions. VARCHAR2 29 RECAP_WEIGHT_KG NUMBER 22 No No 6 2 Active Recapture weight in kilograms. NUMBER 30 RECAP_WGTQUAL VARCHAR2 2 No No Active Recapture weight quality, see support table MRWEIGHT_QUALITY for descriptions. VARCHAR2 31 RECAP_DEPTH_FM NUMBER 22 No No 38 Active Depth in Fathoms. NUMBER 32 RECAP_DECLAT VARCHAR2 9 No No Active Recapture latitude in decimal degrees. (redacted) VARCHAR2 33 RECAP_DECLON VARCHAR2 10 No No Active Recapture event decimal longitude. (redacted) VARCHAR2 34 RECAP_LOCQUAL VARCHAR2 2 No No Active Recapture location quality, see MRLOC_QUALITY for descriptions. VARCHAR2 35 RECAP_AREA VARCHAR2 3 No No Active Recapture event statistical area. VARCHAR2 36 RECAP_DAYSFREE NUMBER 22 No No 5 0 Active Recapture event days free. NUMBER 37 RECAP_DISTTRAVEL NUMBER 22 No No 5 0 Active Recapture event distance traveled. NUMBER 33880 MRMVRELRECAP_AREAS01 Published / External Completed Release and Recapture Statistical Areas for Yellowtail Fishery Loaded by batch 9110, 08-01-2016 12:11 Data Table Yes MRDBS Release and Recapture Statistical Areas for Yellowtail Fishery 1 TAG_TYPE VARCHAR2 2 Yes No Active Style of tag, see support table MRTAGTYPES for descriptions. (Note: For yellowtail, data storage tags were migrated to tag type 40 in MRDBS, before migration, they were tag type 03) VARCHAR2 2 TAG_NUMBER VARCHAR2 6 Yes No Active Tag identification number. VARCHAR2 3 TAG_SUFFIX VARCHAR2 1 Yes No Active Tag suffix, for yellowtail, suffix A or B were used for transcription errors when recording tag or tag was removed from a poor condition fish and reused. VARCHAR2 4 ANIMALID VARCHAR2 14 Yes No Active Animal identification code, animal id will be a concatenation of fishery, original tag type, color, number, and suffix. VARCHAR2 5 REL_EVENTNUM NUMBER 22 Yes No 3 0 Active Release event number. NUMBER 6 TRIPID VARCHAR2 8 No No Active Trip identification code, for yellowtail tagging, trip id consists of YT[year]-[sequential number of trip within year]. VARCHAR2 7 HAULNUM VARCHAR2 4 No No Active Ordinal number of the haul within the trip, set number for shark cruises. VARCHAR2 8 REL_ENTSTATAREA VARCHAR2 3 No No Active Release statistical area as entered from captain's log. VARCHAR2 9 REL_CALCSTATAREA VARCHAR2 3 No No Active Release statistical area calculated from latitude and longitude. VARCHAR2 10 REC_EVENTNUM NUMBER 22 No No 3 0 Active Recapture event number. NUMBER 11 REC_STATAREA VARCHAR2 3 No No Active Recapture statistical area from latitude and longitude. VARCHAR2 33881 MRTRIP Published / External Completed Trip cruise information Loaded by batch 9110, 08-01-2016 12:11 Data Table Yes MRDBS Trip cruise information 1 FISHERY VARCHAR2 2 Yes Yes Active Fishery Code, a two character fishery identification code. See support table MRFISHERY for codes and descriptions. VARCHAR2 MRDBS.MRFISHERY 2 TRIPID VARCHAR2 8 Yes Yes Active Trip identification code, for yellowtail tagging, trip id consists of YT[year]-[sequential number of trip within year]. VARCHAR2 3 DATESAIL DATE 7 No No Active Date sailed. DATE 4 DATELAND DATE 7 No No Active Date landed. DATE 5 MRTRIP_CATEGORY VARCHAR2 3 No No Active Trip category code, see support table MRTRIPCATEGORY for descriptions. (unused for yellowtail) VARCHAR2 MRDBS.MRTRIP_CATEGORY 6 HULLNUM VARCHAR2 10 No No Active Hull number, USCG doc. or state registration number, see support table MRVESSELS for descriptions. (redacted) VARCHAR2 MRDBS.MRVESSELS 7 PORT VARCHAR2 6 No No Active Port (6-character code), see support table MRPORTS for descriptions. VARCHAR2 8 STATE VARCHAR2 2 No No Active State abbreviation code. VARCHAR2 9 CAPTAIN VARCHAR2 20 No No Active Name of captain. (redacted) VARCHAR2 10 VTRSERNO VARCHAR2 16 No No Active Vessel tracking report serial number. (redacted) VARCHAR2 11 FED_VESS_PERMIT VARCHAR2 18 No No Active Federally issued vessel permit number. (redacted) VARCHAR2 12 SHVESSEL VARCHAR2 2 No No Active Vessel (used by shark cruises), see support table MRSHVESSELS for descriptions. (unused for yellowtail) VARCHAR2 13 SHNATION VARCHAR2 2 No No Active Vessel nation (used by shark cruises), see support table MRNATIONS for descriptions. (unused for yellowtail) VARCHAR2 14 SHOCCUPATION VARCHAR2 2 No No Active Occupation (used by shark cruises), see support table MROCCUPATIONS for descriptions. (unused for yellowtail) VARCHAR2 15 TRIPCOMMENTS VARCHAR2 200 No No Active Trip comments VARCHAR2 16 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). DATE 17 UOE VARCHAR2 12 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 18 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). DATE 19 UOC VARCHAR2 12 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 20 WEB_DOE DATE 7 No No Active Date when record was inserted into Oracle by the web application. Date format (DD-MON-YYYY HH24:MI:SS). DATE 21 WEB_UOE VARCHAR2 12 No No Active The username of the individual who entered the new record using the web application. VARCHAR2 22 WEB_DOC DATE 7 No No Active Date when the current record was updated or changed by the web application. Date format (DD-MON-YYYY HH:MI:SS). DATE 23 WEB_UOC VARCHAR2 12 No No Active The username of the individual who changed the current record using the web application. VARCHAR2 33882 MRVEVENT Published / External Completed View of committed events without tag information (use to query animals) Loaded by batch 9110, 08-01-2016 12:11 Data View Yes MRDBS View of committed events without tag information (use to query animals) 1 FISHERY VARCHAR2 2 Yes No Active Fishery Code, a two character fishery identification code. See support table MRFISHERY for codes and descriptions. VARCHAR2 2 ANIMALID VARCHAR2 14 Yes No Active Animal identification code, animal id will be a concatenation of fishery, original tag type, color, number, and suffix. VARCHAR2 3 EVENTNUM NUMBER 22 Yes No 3 0 Active Event occurrence of animal (ie: initial release = 1, 1st recapture of animal = 2, 2nd recapture of animal = 3, 3rd recapture of animal = 4, etc.) NUMBER 4 EV_TYPE VARCHAR2 2 No No Active Event type, see support table MREVENTTYPES for descriptions. VARCHAR2 5 EV_MONTH VARCHAR2 2 No No Active Month of event. VARCHAR2 6 EV_DAY VARCHAR2 2 No No Active Day of event. VARCHAR2 7 EV_YEAR VARCHAR2 4 No No Active Year of event. VARCHAR2 8 EV_DATE VARCHAR2 10 No No Active Date of Event. VARCHAR2 9 EV_DATEQUAL VARCHAR2 2 No No Active Date quality, see support table MRDATE_QUALITY for descriptions. VARCHAR2 10 EV_COMMENTS VARCHAR2 200 No No Active Comments or remarks. VARCHAR2 11 EV_STATAREA VARCHAR2 3 No No Active Statistical area calculated from latitude and longitude, note: stat area 551, 552 are in Canadian water. VARCHAR2 12 EV_MILES NUMBER 22 No No 4 0 Active Miles from reported location (used for location calculation). NUMBER 13 EV_DIRECTION VARCHAR2 5 No No Active Direction from reported location (used for location calculation). VARCHAR2 14 EV_LATDEG VARCHAR2 2 No No Active Event latitude degrees. (redacted) VARCHAR2 15 EV_LATMIN VARCHAR2 2 No No Active Event latitude minutes. (redacted) VARCHAR2 16 EV_LATSEC VARCHAR2 2 No No Active Event latitude seconds. (redacted) VARCHAR2 17 EV_NOS VARCHAR2 1 No No Active North or south. (redacted) VARCHAR2 18 EV_DECLAT VARCHAR2 10 No No Active Latitude in decimal degrees. (redacted) VARCHAR2 19 EV_LONDEG VARCHAR2 3 No No Active Event longitude degrees. (redacted) VARCHAR2 20 EV_LONMIN VARCHAR2 2 No No Active Event longitude minutes. (redacted) VARCHAR2 21 EV_LONSEC VARCHAR2 2 No No Active Event longitude seconds. (redacted) VARCHAR2 22 EV_EOW VARCHAR2 1 No No Active East or west. (redacted) VARCHAR2 23 EV_DECLON VARCHAR2 11 No No Active Longitude in decimal degrees. (redacted) VARCHAR2 24 EV_LOCQUAL VARCHAR2 2 No No Active Data quality code for location, see MRLOC_QUALITY for descriptions. VARCHAR2 25 EV_LORANCHAIN VARCHAR2 4 No No Active Loran chain. (redacted) VARCHAR2 26 EV_LORAN1 NUMBER 22 No No 7 1 Active Loran x. (redacted) NUMBER 27 EV_LORAN2 NUMBER 22 No No 7 1 Active Loran y. (redacted) NUMBER 28 EV_DEPTH NUMBER 22 No No 4 0 Active Depth. NUMBER 29 EV_DEPTHUOM VARCHAR2 2 No No Active Unit of measure used for depth (FM, FT, M). VARCHAR2 30 EV_DEPTH_FM NUMBER 22 No No 38 Active Depth in Fathoms. NUMBER 31 EV_DAYSFREE NUMBER 22 No No 5 0 Active Days free for recapture only. NUMBER 32 EV_DISTTRAVEL NUMBER 22 No No 5 0 Active Distance traveled in nautical miles for recapture only, distance traveled is calculated with great circle formula. NUMBER 33 EV_DISTTRAVEL_CALC VARCHAR2 2 No No Active Calculation used for distance traveled, 00 = cannot calculate (points missing) 01 = did not cross around florida 02 = calculation uses way points around Florida 03 = distance traveled taken from legacy migrated data. (unused for yellowtail) VARCHAR2 34 EV_TRAVELDEG NUMBER 22 No No 4 1 Active Travel direction for recapture only, see MRDIRECTIONS for descriptions. NUMBER 35 EV_TRAVELDIR VARCHAR2 2 No No Active Calculated angle for direction traveled, rounded to 1 decimal position. For ytf, bsb, and scup, angle is calculated using magnetic north, shark angle is calculated using polar north.. VARCHAR2 36 EV_SPECIES_ITIS VARCHAR2 11 No No Active Itis species code, see support table MRSPECIES for descriptions, corresponding survey and shark species codes also in MRSPECIES. VARCHAR2 37 EV_SEX VARCHAR2 1 No No Active Sex ( 0 = male, 1 = female). VARCHAR2 38 EV_FISHFATE VARCHAR2 2 No No Active Fate of fish at event, see support table MRFISH_FATES for descriptions. VARCHAR2 39 EV_LIFESTAGE VARCHAR2 2 No No Active Lifestage of fish at event, see support table MRLIFESTAGES for descriptions. VARCHAR2 40 EV_FISHCOND VARCHAR2 2 No No Active Condition of fish at event, see support table MRFISH_CONDITIONS for descriptions. VARCHAR2 41 EV_LENGTH NUMBER 22 No No 6 2 Active Length, for sharks: fork length in centimeters . NUMBER 42 EV_LENUOM VARCHAR2 3 No No Active Unit of measure for length (CM, IN). VARCHAR2 43 EV_LENQUAL VARCHAR2 2 No No Active Data quality code for length, see support table MRLENGTH_QUALITY for descriptions. VARCHAR2 44 EV_LENTYPE VARCHAR2 2 No No Active Length type code, see support table MRLENGTH_TYPES for descriptions. VARCHAR2 45 EV_LENDET VARCHAR2 2 No No Active Length determination code, see support table MRLENGTH_DETERMINATION for descriptions. VARCHAR2 46 EV_RPTLENGTH NUMBER 22 No No 6 2 Active Reported length measurement. NUMBER 47 EV_RPTLENUOM VARCHAR2 3 No No Active Unit of measure for reported length (CM, IN). VARCHAR2 48 EV_RPTLENQUAL VARCHAR2 2 No No Active Data quality code for reported length, see support table MRLENGTH_QUALITY for descriptions. VARCHAR2 49 EV_RPTLENTYPE VARCHAR2 2 No No Active Reported length type code, see support table MRLENGTH_TYPES for descriptions. VARCHAR2 50 EV_OTHLENGTH NUMBER 22 No No 6 2 Active Other length measurement. NUMBER 51 EV_OTHLENUOM VARCHAR2 3 No No Active Unit of measure for other length (CM, IN). VARCHAR2 52 EV_OTHLENQUAL VARCHAR2 2 No No Active Data quality code for other length, see support table MRLENGTH_QUALITY for descriptions. VARCHAR2 53 EV_OTHLENTYPE VARCHAR2 2 No No Active Other length type code, see support table MRLENGTH_TYPES for descriptions. VARCHAR2 54 EV_WEIGHT NUMBER 22 No No 6 2 Active Weight, for sharks, whole weight in kg. NUMBER 55 EV_WGTUOM VARCHAR2 3 No No Active Unit of measure for weight (LB, KG). VARCHAR2 56 EV_WGTQUAL VARCHAR2 2 No No Active Weight quality code, see support table MRWEIGHT_QUALITY for descriptions. VARCHAR2 57 EV_WGTTYPE VARCHAR2 2 No No Active Weight type code, see support table MRWEIGHT_TYPES for descriptions. VARCHAR2 58 EV_WGTDET VARCHAR2 2 No No Active Weight determination code, see support table MRWEIGHT_DETERMINATION for descriptions. VARCHAR2 59 EV_RPTWEIGHT NUMBER 22 No No 6 2 Active Reported weight, for sharks, whole weight in kg. NUMBER 60 EV_RPTWGTUOM VARCHAR2 3 No No Active Unit of measure for reported weight (LB, KG). VARCHAR2 61 EV_RPTWGTQUAL VARCHAR2 2 No No Active Reported weight quality code, see support table MRWEIGHT_QUALITY for descriptions. VARCHAR2 62 EV_RPTWGTTYPE VARCHAR2 2 No No Active Reported weight type code, see support table MRWEIGHT_TYPES for descriptions. VARCHAR2 63 EV_CONTACTID NUMBER 22 No No 6 0 Active Contact id for event. NUMBER 64 EV_INDUSTRY VARCHAR2 2 No No Active Industry (category, sector) at time of event, see support table MRINDUSTRY for descriptions. VARCHAR2 65 EV_OCCUPATION VARCHAR2 2 No No Active Occupation at time of event, see support table MROCCUPATION for descriptions. VARCHAR2 66 EV_VESS_NATION VARCHAR2 2 No No Active Vessel nation at time of event, see support table MRNATIONS for descriptions. VARCHAR2 67 EV_SHVESSEL VARCHAR2 2 No No Active Vessel code used by the shark fishery, see support table MRSHVESSELS for descriptions. (unused for yellowtail) VARCHAR2 68 EV_GEAR VARCHAR2 2 No No Active Gear used, see support table MRGEARS for descriptions. VARCHAR2 33883 MRVTAGEVENT Published / External Completed View of committed events including tag information (use to query tags) Loaded by batch 9110, 08-01-2016 12:11 Data View Yes MRDBS View of committed events including tag information (use to query tags) 1 FISHERY VARCHAR2 2 Yes No Active Fishery Code, a two character fishery identification code. See support table MRFISHERY for codes and descriptions. VARCHAR2 2 TAG_TYPE VARCHAR2 2 Yes No Active Style of tag, see support table MRTAGTYPES for descriptions. (Note: For yellowtail, data storage tags were migrated to tag type 40 in MRDBS, before migration, they were tag type 03) VARCHAR2 3 TAG_COLOR VARCHAR2 2 Yes No Active Color of tag, see support table MRTAGCOLORS for descriptions. VARCHAR2 4 TAG_NUMBER VARCHAR2 6 Yes No Active Tag identification number. VARCHAR2 5 TAG_SUFFIX VARCHAR2 1 Yes No Active Tag suffix, for yellowtail, suffix A or B were used for transcription errors when recording tag or tag was removed from a poor condition fish and reused. VARCHAR2 6 TAG_REWARD VARCHAR2 2 No No Active Reward for tag release or recapture, see support table MRTAGREWARDS for descriptions. VARCHAR2 7 TAG_FATE VARCHAR2 2 No No Active Fate of tag, see support table MRTAGFATES for descriptions. VARCHAR2 8 TAG_CONDITION VARCHAR2 2 No No Active Condition of tag, see support table MRTAGCONDITIONS for descriptions. VARCHAR2 9 TAG_SITE VARCHAR2 2 No No Active Area of tag at recapture, see support table MRTAGSITE for descriptions. VARCHAR2 10 TAG_LOCONFISH VARCHAR2 2 No No Active Location on fish where tag is attached, see support table MRTAGLOCONFISH for descriptions. VARCHAR2 11 ANIMALID VARCHAR2 14 Yes No Active Animal identification code, animal id will be a concatenation of fishery, original tag type, color, number, and suffix. VARCHAR2 12 EVENTNUM NUMBER 22 Yes No 3 0 Active Event occurrence of animal (ie: initial release = 1, 1st recapture of animal = 2, 2nd recapture of animal = 3, 3rd recapture of animal = 4, etc.) NUMBER 13 EV_TYPE VARCHAR2 2 No No Active Event type, see support table MREVENTTYPES for descriptions. VARCHAR2 14 EV_MONTH VARCHAR2 2 No No Active Month of event. VARCHAR2 15 EV_DAY VARCHAR2 2 No No Active Day of event. VARCHAR2 16 EV_YEAR VARCHAR2 4 No No Active Year of event. VARCHAR2 17 EV_DATE VARCHAR2 10 No No Active Date of Event. VARCHAR2 18 EV_DATEQUAL VARCHAR2 2 No No Active Date quality, see support table MRDATE_QUALITY for descriptions. VARCHAR2 19 EV_COMMENTS VARCHAR2 200 No No Active Comments or remarks. VARCHAR2 20 EV_STATAREA VARCHAR2 3 No No Active Statistical area calculated from latitude and longitude, note: stat area 551, 552 are in Canadian water. VARCHAR2 21 EV_MILES NUMBER 22 No No 4 0 Active Miles from reported location (used for location calculation). NUMBER 22 EV_DIRECTION VARCHAR2 5 No No Active Direction from reported location (used for location calculation). VARCHAR2 23 EV_LATDEG VARCHAR2 2 No No Active Event latitude degrees. (redacted) VARCHAR2 24 EV_LATMIN VARCHAR2 2 No No Active Event latitude minutes. (redacted) VARCHAR2 25 EV_LATSEC VARCHAR2 2 No No Active Event latitude seconds. (redacted) VARCHAR2 26 EV_NOS VARCHAR2 1 No No Active North or south. (redacted) VARCHAR2 27 EV_DECLAT VARCHAR2 9 No No Active Latitude in decimal degrees. (redacted) VARCHAR2 28 EV_LONDEG VARCHAR2 3 No No Active Event longitude degrees. (redacted) VARCHAR2 29 EV_LONMIN VARCHAR2 2 No No Active Event longitude minutes. (redacted) VARCHAR2 30 EV_LONSEC VARCHAR2 2 No No Active Event longitude seconds. (redacted) VARCHAR2 31 EV_EOW VARCHAR2 1 No No Active East or west. (redacted) VARCHAR2 32 EV_DECLON VARCHAR2 10 No No Active Longitude in decimal degrees. (redacted) VARCHAR2 33 EV_LOCQUAL VARCHAR2 2 No No Active Data quality code for location, see MRLOC_QUALITY for descriptions. VARCHAR2 34 EV_DEPTH NUMBER 22 No No 4 0 Active Depth. NUMBER 35 EV_DEPTHUOM VARCHAR2 2 No No Active Unit of measure used for depth (FM, FT, M). VARCHAR2 36 EV_DEPTH_FM NUMBER 22 No No 38 Active Depth in Fathoms. NUMBER 37 EV_DAYSFREE NUMBER 22 No No 5 0 Active Days free for recapture only. NUMBER 38 EV_DISTTRAVEL NUMBER 22 No No 5 0 Active Distance traveled in nautical miles for recapture only, distance traveled is calculated with great circle formula. NUMBER 39 EV_TRAVELDEG NUMBER 22 No No 4 1 Active Travel direction for recapture only, see MRDIRECTIONS for descriptions. NUMBER 40 EV_TRAVELDIR VARCHAR2 2 No No Active Calculated angle for direction traveled, rounded to 1 decimal position. For ytf, bsb, and scup, angle is calculated using magnetic north, shark angle is calculated using polar north.. VARCHAR2 41 EV_SPECIES_ITIS VARCHAR2 11 No No Active Itis species code, see support table MRSPECIES for descriptions, corresponding survey and shark species codes also in MRSPECIES. VARCHAR2 42 EV_SEX VARCHAR2 1 No No Active Sex ( 0 = male, 1 = female). VARCHAR2 43 EV_LENGTH NUMBER 22 No No 6 2 Active Length, for sharks: fork length in centimeters . NUMBER 44 EV_LENUOM VARCHAR2 3 No No Active Unit of measure for length (CM, IN). VARCHAR2 45 EV_LENQUAL VARCHAR2 2 No No Active Data quality code for length, see support table MRLENGTH_QUALITY for descriptions. VARCHAR2 46 EV_LENTYPE VARCHAR2 2 No No Active Length type code, see support table MRLENGTH_TYPES for descriptions. VARCHAR2 47 EV_LENDET VARCHAR2 2 No No Active Length determination code, see support table MRLENGTH_DETERMINATION for descriptions. VARCHAR2 48 EV_RPTLENGTH NUMBER 22 No No 6 2 Active Reported length measurement. NUMBER 49 EV_RPTLENUOM VARCHAR2 3 No No Active Unit of measure for reported length (CM, IN). VARCHAR2 50 EV_RPTLENQUAL VARCHAR2 2 No No Active Data quality code for reported length, see support table MRLENGTH_QUALITY for descriptions. VARCHAR2 51 EV_RPTLENTYPE VARCHAR2 2 No No Active Reported length type code, see support table MRLENGTH_TYPES for descriptions. VARCHAR2 52 EV_OTHLENGTH NUMBER 22 No No 6 2 Active Other length measurement. NUMBER 53 EV_OTHLENUOM VARCHAR2 3 No No Active Unit of measure for other length (CM, IN). VARCHAR2 54 EV_OTHLENQUAL VARCHAR2 2 No No Active Data quality code for other length, see support table MRLENGTH_QUALITY for descriptions. VARCHAR2 55 EV_OTHLENTYPE VARCHAR2 2 No No Active Other length type code, see support table MRLENGTH_TYPES for descriptions. VARCHAR2 56 EV_WEIGHT NUMBER 22 No No 6 2 Active Weight, for sharks, whole weight in kg. NUMBER 57 EV_WGTUOM VARCHAR2 3 No No Active Unit of measure for weight (LB, KG). VARCHAR2 58 EV_WGTQUAL VARCHAR2 2 No No Active Weight quality code, see support table MRWEIGHT_QUALITY for descriptions. VARCHAR2 59 EV_WGTTYPE VARCHAR2 2 No No Active Weight type code, see support table MRWEIGHT_TYPES for descriptions. VARCHAR2 60 EV_WGTDET VARCHAR2 2 No No Active Weight determination code, see support table MRWEIGHT_DETERMINATION for descriptions. VARCHAR2 61 EV_RPTWEIGHT NUMBER 22 No No 6 2 Active Reported weight, for sharks, whole weight in kg. NUMBER 62 EV_RPTWGTUOM VARCHAR2 3 No No Active Unit of measure for reported weight (LB, KG). VARCHAR2 63 EV_RPTWGTQUAL VARCHAR2 2 No No Active Reported weight quality code, see support table MRWEIGHT_QUALITY for descriptions. VARCHAR2 64 EV_RPTWGTTYPE VARCHAR2 2 No No Active Reported weight type code, see support table MRWEIGHT_TYPES for descriptions. VARCHAR2 65 EV_CONTACTID NUMBER 22 No No 6 0 Active Contact id for event. NUMBER 66 EV_INDUSTRY VARCHAR2 2 No No Active Industry (category, sector) at time of event, see support table MRINDUSTRY for descriptions. VARCHAR2 67 EV_OCCUPATION VARCHAR2 2 No No Active Occupation at time of event, see support table MROCCUPATION for descriptions. VARCHAR2 68 EV_GEAR VARCHAR2 2 No No Active Gear used, see support table MRGEARS for descriptions. VARCHAR2 69 HOW_REPORTED VARCHAR2 2 No No Active How recapture was reported, see support table MRRECAP_REPORTED for descriptions. VARCHAR2 70 INFO_PENDING VARCHAR2 1 No No Active Additional information is pending about the recapture 0 = no, 1 = yes. VARCHAR2 71 DATE_ENTERED VARCHAR2 10 No No Active Date of Entry. VARCHAR2 72 DATE_LAST_UPDATED VARCHAR2 10 No No Active Date of Last Update VARCHAR2 33884 MRYTHAUL Published / External Completed Haul or Tow Information (yellowtail) Loaded by batch 9110, 08-01-2016 12:11 Data Table Yes MRDBS Haul or Tow Information (yellowtail) 1 FISHERY VARCHAR2 2 Yes Yes Active Fishery Code, a two character fishery identification code. See support table MRFISHERY for codes and descriptions. VARCHAR2 MRDBS.MRHAUL 2 TRIPID VARCHAR2 8 Yes Yes Active Trip identification code, for yellowtail tagging, trip id consists of YT[year]-[sequential number of trip within year]. VARCHAR2 MRDBS.MRHAUL 3 HAULNUM VARCHAR2 4 Yes Yes Active Ordinal number of the haul within the trip, set number for shark cruises. VARCHAR2 MRDBS.MRHAUL 4 ESTCATCHNUM NUMBER 22 No No 8 0 Active Number estimated total catch . NUMBER 5 ESTCATCHWGT NUMBER 22 No No 8 0 Active Weight estimated total catch . NUMBER 6 ESTCATCHWGTUOM VARCHAR2 3 No No Active Unit of measure for estimated catch weight. VARCHAR2 7 ESTYTNUM NUMBER 22 No No 8 0 Active Number estimated yellowtail catch. NUMBER 8 ESTYTWGT NUMBER 22 No No 8 0 Active Weight estimated yellowtail catch. NUMBER 9 ESTYTWGTUOM VARCHAR2 3 No No Active Unit of measure for estimated yellowtail weight. VARCHAR2 10 YTTAGGEDNUM NUMBER 22 No No 4 0 Active Number yellowtail tagged. NUMBER 11 DISCALIVE_SUBLGL NUMBER 22 No No 4 0 Active Number discarded alive (sub-legal). NUMBER 12 DISCALIVE_OTHER NUMBER 22 No No 4 0 Active Number discarded alive for poor condition or total number discarded because sub-legal not counted. NUMBER 13 DISCDEADNUM NUMBER 22 No No 4 0 Active Number discarded dead. NUMBER 14 DISCNOTPRNUM NUMBER 22 No No 4 0 Active Number discarded not processed. NUMBER 15 DISCALIVEWGT NUMBER 22 No No 9 3 Active Weight discarded alive. NUMBER 16 DISCALIVEUOM VARCHAR2 3 No No Active Unit of measure for weight discarded alive. VARCHAR2 17 DISCDEADWGT NUMBER 22 No No 9 3 Active Weight discarded dead. NUMBER 18 DISCDEADUOM VARCHAR2 3 No No Active Unit of measure for weight discarded dead. VARCHAR2 19 DISCNOTPRWGT NUMBER 22 No No 9 3 Active Weight discarded not processed. NUMBER 20 DISCNOTPRUOM VARCHAR2 3 No No Active Unit of measure for weight discarded not processes. VARCHAR2 21 TAGGERCOMMENTS VARCHAR2 200 No No Active Comments. VARCHAR2 22 LOGHAULNUM VARCHAR2 4 No No Active Original tow number used on paper logs (used for 2003, 2004 yt trips). VARCHAR2 23 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). DATE 24 UOE VARCHAR2 12 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 25 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). DATE 26 UOC VARCHAR2 12 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 27 WEB_DOE DATE 7 No No Active Date when record was inserted into Oracle by the web application. Date format (DD-MON-YYYY HH24:MI:SS). DATE 28 WEB_UOE VARCHAR2 12 No No Active The username of the individual who entered the new record using the web application. VARCHAR2 29 WEB_DOC DATE 7 No No Active Date when the current record was updated or changed by the web application. Date format (DD-MON-YYYY HH:MI:SS). DATE 30 WEB_UOC VARCHAR2 12 No No Active The username of the individual who changed the current record using the web application. VARCHAR2 33885 MRBIO_SAMPLES Published / External Completed Biological samples taken at release/recapture Loaded by batch 9111, 08-01-2016 12:11 Data Table Yes MRDBS Biological samples taken at release/recapture 1 BIOSAMPCD VARCHAR2 2 Yes Yes Active Biological sample code. VARCHAR2 2 BIOSAMPLE_DESC VARCHAR2 40 Yes No Active Biological sample description. VARCHAR2 3 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). DATE 4 UOE VARCHAR2 12 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 5 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). DATE 6 UOC VARCHAR2 12 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 7 FISHERY_STRING VARCHAR2 20 No No Active Fisheries to which species is affiliated (comma separated list of fishery codes). VARCHAR2 33888 MRDATE_QUALITY Published / External Completed Quality code used for date values Loaded by batch 9111, 08-01-2016 12:11 Data Table Yes MRDBS Quality code used for date values 1 DATEQUALCD VARCHAR2 2 Yes Yes Active Date quality code. VARCHAR2 2 DATEQUAL_DESC VARCHAR2 40 Yes No Active Date quality description. VARCHAR2 3 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). DATE 4 UOE VARCHAR2 12 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 5 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). DATE 6 UOC VARCHAR2 12 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 7 FISHERY_STRING VARCHAR2 20 No No Active Fisheries to which species is affiliated (comma separated list of fishery codes). VARCHAR2 33889 MRDIRECTIONS Published / External Completed Direction codes used for direction traveled Loaded by batch 9111, 08-01-2016 12:11 Data Table Yes MRDBS Direction codes used for direction traveled 1 DIRECTIONCD VARCHAR2 2 Yes Yes Active Direction code. VARCHAR2 2 DIRECTION_DESC VARCHAR2 40 Yes No Active Direction description. VARCHAR2 3 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). DATE 4 UOE VARCHAR2 12 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 5 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). DATE 6 UOC VARCHAR2 12 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 7 FISHERY_STRING VARCHAR2 20 No No Active Fisheries to which species is affiliated (comma separated list of fishery codes). VARCHAR2 33890 MREVENTSTATUS Published / External Completed Status of events that may be recorded for a release/recapture Loaded by batch 9111, 08-01-2016 12:11 Data Table Yes MRDBS Status of events that may be recorded for a release/recapture 1 EVENTSTATUSCD VARCHAR2 2 Yes Yes Active Event status code. VARCHAR2 2 EVENT_STATDESC VARCHAR2 80 Yes No Active Event status description. VARCHAR2 3 FISHERY_STRING VARCHAR2 20 No No Active Fisheries to which species is affiliated (comma separated list of fishery codes). VARCHAR2 4 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). DATE 5 UOE VARCHAR2 12 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 6 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). DATE 7 UOC VARCHAR2 12 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 33891 MREVENTTYPES Published / External Completed Types of events that may be recorded for a release/recapture Loaded by batch 9111, 08-01-2016 12:11 Data Table Yes MRDBS Types of events that may be recorded for a release/recapture 1 EVENTTYPECD VARCHAR2 2 Yes Yes Active Event type code. VARCHAR2 2 EVENT_DESC VARCHAR2 80 Yes No Active Event description. VARCHAR2 3 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). DATE 4 UOE VARCHAR2 12 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 5 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). DATE 6 UOC VARCHAR2 12 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 7 FISHERY_STRING VARCHAR2 20 No No Active Fisheries to which species is affiliated (comma separated list of fishery codes). VARCHAR2 33893 MRFISHERY Published / External Completed Fisheries in the Mark Recapture database Loaded by batch 9111, 08-01-2016 12:11 Data Table Yes MRDBS Fisheries in the Mark Recapture database 1 FISHERYCD VARCHAR2 2 Yes Yes Active Fishery code. VARCHAR2 2 FISHERY_ABBRV VARCHAR2 6 No No Active Fishery abbreviation. VARCHAR2 3 FISHERY_DESC VARCHAR2 40 No No Active Fishery description. VARCHAR2 4 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). DATE 5 UOE VARCHAR2 12 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 6 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). DATE 7 UOC VARCHAR2 12 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 33894 MRFISHFATES Published / External Completed Fate of fish at release/recapture Loaded by batch 9111, 08-01-2016 12:11 Data Table Yes MRDBS Fate of fish at release/recapture 1 FISHFATECD VARCHAR2 2 Yes Yes Active Fate of fish code. VARCHAR2 2 FATE_OF_FISH VARCHAR2 80 Yes No Active Fate of fish description. VARCHAR2 3 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). DATE 4 UOE VARCHAR2 12 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 5 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). DATE 6 UOC VARCHAR2 12 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 7 FISHERY_STRING VARCHAR2 20 No No Active Fisheries to which species is affiliated (comma separated list of fishery codes). VARCHAR2 33895 MRGEARS Published / External Completed Gear types in the Mark Recapture database Loaded by batch 9111, 08-01-2016 12:11 Data Table Yes MRDBS Gear types in the Mark Recapture database 1 GEARCD VARCHAR2 2 Yes Yes Active Gear code. VARCHAR2 2 GEAR_DESC VARCHAR2 40 Yes No Active Gear description. VARCHAR2 3 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). DATE 4 UOE VARCHAR2 12 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 5 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). DATE 6 UOC VARCHAR2 12 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 7 FISHERY_STRING VARCHAR2 20 No No Active Fisheries to which species is affiliated (comma separated list of fishery codes). VARCHAR2 8 MRSEQUENCE VARCHAR2 40 No No Active Sequencing for web application select list VARCHAR2 33896 MRINDUSTRY Published / External Completed Industry (sector or category) for contacts and events Loaded by batch 9111, 08-01-2016 12:11 Data Table Yes MRDBS Industry (sector or category) for contacts and events 1 INDUSTRYCD VARCHAR2 2 Yes Yes Active Industry code. VARCHAR2 2 INDUSTRY_DESC VARCHAR2 40 Yes No Active Industry description. VARCHAR2 3 FISHERY_STRING VARCHAR2 20 No No Active Fisheries to which species is affiliated (comma separated list of fishery codes). VARCHAR2 4 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). DATE 5 UOE VARCHAR2 12 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 6 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). DATE 7 UOC VARCHAR2 12 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 33897 MRLENGTHTYPES Published / External Completed Length type codes Loaded by batch 9111, 08-01-2016 12:11 Data Table Yes MRDBS Length type codes 1 LENTYPECD VARCHAR2 2 Yes Yes Active Length type code. VARCHAR2 2 LENTYPE_DESC VARCHAR2 40 Yes No Active Length type description. VARCHAR2 3 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). DATE 4 UOE VARCHAR2 12 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 5 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). DATE 6 UOC VARCHAR2 12 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 7 FISHERY_STRING VARCHAR2 20 No No Active Fisheries to which species is affiliated (comma separated list of fishery codes). VARCHAR2 33899 MRLENGTH_QUALITY Published / External Completed Quality code used for length values Loaded by batch 9111, 08-01-2016 12:11 Data Table Yes MRDBS Quality code used for length values 1 LENQUALCD VARCHAR2 2 Yes Yes Active Length quality code. VARCHAR2 2 LENQUAL_DESC VARCHAR2 40 Yes No Active Length quality description. VARCHAR2 3 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). DATE 4 UOE VARCHAR2 12 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 5 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). DATE 6 UOC VARCHAR2 12 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 7 FISHERY_STRING VARCHAR2 20 No No Active Fisheries to which species is affiliated (comma separated list of fishery codes). VARCHAR2 33901 MRLOCATION_QUALITY Published / External Completed Quality code used for length values Loaded by batch 9111, 08-01-2016 12:11 Data Table Yes MRDBS Quality code used for length values 1 LOCQUALCD VARCHAR2 2 Yes Yes Active Location quality code. VARCHAR2 2 LOCQUAL_DESC VARCHAR2 40 Yes No Active Location quality description. VARCHAR2 3 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). DATE 4 UOE VARCHAR2 12 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 5 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). DATE 6 UOC VARCHAR2 12 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 7 FISHERY_STRING VARCHAR2 20 No No Active Fisheries to which species is affiliated (comma separated list of fishery codes). VARCHAR2 33902 MRNATIONS Published / External Completed Nations used in recording an event and for formatting addresses Loaded by batch 9111, 08-01-2016 12:11 Data Table Yes MRDBS Nations used in recording an event and for formatting addresses 1 NATIONCD VARCHAR2 2 Yes Yes Active Nation code. VARCHAR2 2 NATION_DESC VARCHAR2 40 Yes No Active Nation description. VARCHAR2 3 ADDRESS_FORMAT VARCHAR2 1 No No Active Address format. 1= city state/province postal code; 2= postal code city state/province; 3= city state/province/county postal code;;4= city postal code state/province VARCHAR2 4 FISHERY_STRING VARCHAR2 20 No No Active Fisheries to which species is affiliated (comma separated list of fishery codes). VARCHAR2 5 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). DATE 6 UOE VARCHAR2 12 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 7 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). DATE 8 UOC VARCHAR2 12 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 9 MRSEQUENCE VARCHAR2 40 No No Active Sequencing for web application select list VARCHAR2 33903 MROCCUPATIONS Published / External Completed Occupation used for recording contacts and events Loaded by batch 9111, 08-01-2016 12:11 Data Table Yes MRDBS Occupation used for recording contacts and events 1 OCCUPCD VARCHAR2 2 Yes Yes Active Occupation code. VARCHAR2 2 OCCUP_DESC VARCHAR2 200 Yes No Active Occupation description. VARCHAR2 3 FISHERY_STRING VARCHAR2 20 No No Active Fisheries to which species is affiliated (comma separated list of fishery codes). VARCHAR2 4 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). DATE 5 UOE VARCHAR2 12 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 6 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). DATE 7 UOC VARCHAR2 12 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 33904 MRPORTS Published / External Completed no-comment Loaded by batch 9111, 08-01-2016 12:11 Data Table Yes MRDBS no-comment 1 PORT VARCHAR2 6 No No Active Port (6-character code), see support table MRPORTS for descriptions. VARCHAR2 2 STATECD VARCHAR2 8 No No Active State code (2-digit code). VARCHAR2 3 PORT2 VARCHAR2 8 No No Active Port (2-character code). VARCHAR2 4 COUNTYCD VARCHAR2 8 No No Active County code. VARCHAR2 5 PORTNM VARCHAR2 25 No No Active Port name. VARCHAR2 6 STATEABB VARCHAR2 2 No No Active State abbreviation (2-character code). VARCHAR2 7 COUNTY VARCHAR2 30 No No Active County. VARCHAR2 8 PSREGION VARCHAR2 1 No No Active Northeast sampling regions (see CFDBS.PORTS for complete description). VARCHAR2 9 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). DATE 33906 MRRECAP_REPORTED Published / External Completed How recapture was reported Loaded by batch 9111, 08-01-2016 12:11 Data Table Yes MRDBS How recapture was reported 1 REPORTEDCD VARCHAR2 2 Yes Yes Active Reported code. VARCHAR2 2 REPORTED_DESC VARCHAR2 40 Yes No Active Reported description. VARCHAR2 3 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). DATE 4 UOE VARCHAR2 12 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 5 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). DATE 6 UOC VARCHAR2 12 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 7 FISHERY_STRING VARCHAR2 20 No No Active Fisheries to which species is affiliated (comma separated list of fishery codes). VARCHAR2 33907 MRSEXCODES Published / External Completed Animal sex codes Loaded by batch 9111, 08-01-2016 12:11 Data Table Yes MRDBS Animal sex codes 1 SEXCD VARCHAR2 1 Yes Yes Active Sex code. VARCHAR2 2 SEX_DESC VARCHAR2 40 Yes No Active Sex description. VARCHAR2 3 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). DATE 4 UOE VARCHAR2 12 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 5 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). DATE 6 UOC VARCHAR2 12 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 7 FISHERY_STRING VARCHAR2 20 No No Active Fisheries to which species is affiliated (comma separated list of fishery codes). VARCHAR2 33909 MRSPECIAL_CONDITIONS Published / External Completed Special conditions reported for animal Loaded by batch 9111, 08-01-2016 12:11 Data Table Yes MRDBS Special conditions reported for animal 1 SPCONDCD VARCHAR2 2 Yes Yes Active Special condition code. VARCHAR2 2 SPCONDITION_DESC VARCHAR2 40 Yes No Active Special condition description. VARCHAR2 3 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). DATE 4 UOE VARCHAR2 12 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 5 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). DATE 6 UOC VARCHAR2 12 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 7 FISHERY_STRING VARCHAR2 20 No No Active Fisheries to which species is affiliated (comma separated list of fishery codes). VARCHAR2 33910 MRSPECIES Published / External Completed Species Information Loaded by batch 9111, 08-01-2016 12:11 Data Table Yes MRDBS Species Information 1 SPECIES_ITIS VARCHAR2 11 Yes Yes Active Itis species code, see support table MRSPECIES for descriptions. VARCHAR2 2 SV_SPCODE VARCHAR2 3 No No Active Species code in the NEFSC SBDVS survey database. VARCHAR2 3 SH_SPCODE VARCHAR2 3 No No Active Species code from the Apex Predators (Shark) data tables. VARCHAR2 4 SCIENTIFIC_NAME VARCHAR2 45 No No Active Scientific name. VARCHAR2 5 COMMON_NAME VARCHAR2 45 No No Active Common name. VARCHAR2 6 AFT VARCHAR2 25 No No Active used in shark length calculation. VARCHAR2 7 BFT VARCHAR2 25 No No Active used in shark length calculation. VARCHAR2 8 AFW VARCHAR2 25 No No Active used in shark weight calculation. VARCHAR2 9 BFW VARCHAR2 25 No No Active used in shark weight calculation. VARCHAR2 10 FISHERY_STRING VARCHAR2 20 No No Active Fisheries to which species is affiliated (comma separated list of fishery codes). VARCHAR2 11 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). DATE 12 UOE VARCHAR2 12 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 13 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). DATE 14 UOC VARCHAR2 12 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 15 MRSEQUENCE VARCHAR2 40 No No Active Sequencing for web application select list VARCHAR2 33911 MRSPECIES_QUALITY Published / External Completed Quality code used for species identification Loaded by batch 9111, 08-01-2016 12:11 Data Table Yes MRDBS Quality code used for species identification 1 SPQUALCD VARCHAR2 2 Yes Yes Active Species quality code. VARCHAR2 2 SPQUAL_DESC VARCHAR2 40 Yes No Active Species quality description. VARCHAR2 3 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). DATE 4 UOE VARCHAR2 12 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 5 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). DATE 6 UOC VARCHAR2 12 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 7 FISHERY_STRING VARCHAR2 20 No No Active Fisheries to which species is affiliated (comma separated list of fishery codes). VARCHAR2 33912 MRSTOCKAREAS Published / External Completed Stock areas Loaded by batch 9111, 08-01-2016 12:11 Data Table Yes MRDBS Stock areas 1 FISHERY VARCHAR2 2 Yes Yes Active Fishery Code, a two character fishery identification code. See support table MRFISHERY for codes and descriptions. VARCHAR2 2 STOCKCD VARCHAR2 2 Yes Yes Active Stock area code. VARCHAR2 3 STOCKID VARCHAR2 10 Yes No Active Abbreviated description of stock ares. VARCHAR2 4 SPECIES_ITIS VARCHAR2 11 Yes Yes Active Itis species code, see support table MRSPECIES for descriptions. VARCHAR2 5 STOCK_DESC VARCHAR2 40 Yes No Active Stock area description. VARCHAR2 6 STOCK_AREA_DEF VARCHAR2 60 No No Active List of statistical areas in stock area (comma delimited list). VARCHAR2 7 STOCK_AREA_QUERYSTR VARCHAR2 240 No No Active List of statistical areas in stock area (comma delimited list formatted for sql query). VARCHAR2 8 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). DATE 9 UOE VARCHAR2 12 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 10 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). DATE 11 UOC VARCHAR2 12 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 33913 MRTAGCOLORS Published / External Completed Tag colors Loaded by batch 9111, 08-01-2016 12:11 Data Table Yes MRDBS Tag colors 1 TAGCOLORCD VARCHAR2 2 Yes Yes Active Tag color code. VARCHAR2 2 TAGCOLOR_DESC VARCHAR2 40 Yes No Active Color. VARCHAR2 3 FISHERY_STRING VARCHAR2 20 No No Active Fisheries to which species is affiliated (comma separated list of fishery codes). VARCHAR2 4 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). DATE 5 UOE VARCHAR2 12 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 6 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). DATE 7 UOC VARCHAR2 12 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 33914 MRTAGCONDITIONS Published / External Completed Condition of tag at release/recapture Loaded by batch 9111, 08-01-2016 12:11 Data Table Yes MRDBS Condition of tag at release/recapture 1 TAGCONDCD VARCHAR2 2 Yes Yes Active Tag condition code. VARCHAR2 2 TAGCOND_DESC VARCHAR2 80 Yes No Active Description of tag condition. VARCHAR2 3 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). DATE 4 UOE VARCHAR2 12 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 5 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). DATE 6 UOC VARCHAR2 12 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 7 FISHERY_STRING VARCHAR2 20 No No Active Fisheries to which species is affiliated (comma separated list of fishery codes). VARCHAR2 33915 MRTAGFATES Published / External Completed Fate of tag at release/recapture Loaded by batch 9111, 08-01-2016 12:11 Data Table Yes MRDBS Fate of tag at release/recapture 1 TAGFATECD VARCHAR2 2 Yes Yes Active Fate of tag code. VARCHAR2 2 FATE_OF_TAG VARCHAR2 40 Yes No Active Description of fate of tag. VARCHAR2 3 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). DATE 4 UOE VARCHAR2 12 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 5 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). DATE 6 UOC VARCHAR2 12 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 7 FISHERY_STRING VARCHAR2 20 No No Active Fisheries to which species is affiliated (comma separated list of fishery codes). VARCHAR2 33916 MRTAGLOCONFISH Published / External Completed Location of tag on animal Loaded by batch 9111, 08-01-2016 12:11 Data Table Yes MRDBS Location of tag on animal 1 TAGLOCCD VARCHAR2 2 Yes Yes Active Tag location code. VARCHAR2 2 TAGLOC_DESC VARCHAR2 40 Yes No Active Description of area of animal where tag is located. VARCHAR2 3 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). DATE 4 UOE VARCHAR2 12 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 5 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). DATE 6 UOC VARCHAR2 12 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 7 FISHERY_STRING VARCHAR2 20 No No Active Fisheries to which species is affiliated (comma separated list of fishery codes). VARCHAR2 33917 MRTAGREWARDS Published / External Completed Tag rewards Loaded by batch 9111, 08-01-2016 12:11 Data Table Yes MRDBS Tag rewards 1 TAGREWARDCD VARCHAR2 2 Yes Yes Active Tag reward code. VARCHAR2 2 REWARD_DESC VARCHAR2 40 Yes No Active Description of reward awarded for tag release or recapture. VARCHAR2 3 FISHERY_STRING VARCHAR2 20 No No Active Fisheries to which species is affiliated (comma separated list of fishery codes). VARCHAR2 4 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). DATE 5 UOE VARCHAR2 12 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 6 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). DATE 7 UOC VARCHAR2 12 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 33918 MRTAGSITES Published / External Completed Condition of animal where tag is attached to animal Loaded by batch 9111, 08-01-2016 12:11 Data Table Yes MRDBS Condition of animal where tag is attached to animal 1 TAGSITECD VARCHAR2 2 Yes Yes Active Tag site code. VARCHAR2 2 TAGSITE_DESC VARCHAR2 40 Yes No Active Description of condition of animal where tag is attached to animal. VARCHAR2 3 FISHERY_STRING VARCHAR2 20 No No Active Fisheries to which species is affiliated (comma separated list of fishery codes). VARCHAR2 4 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). DATE 5 UOE VARCHAR2 12 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 6 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). DATE 7 UOC VARCHAR2 12 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 33919 MRTAGTYPES Published / External Completed Tag types Loaded by batch 9111, 08-01-2016 12:11 Data Table Yes MRDBS Tag types 1 TAGTYPECD VARCHAR2 3 Yes Yes Active Tag type code. VARCHAR2 2 TAG_ABBRV VARCHAR2 6 Yes No Active Abbreviated description of tag type. VARCHAR2 3 TAG_DESC VARCHAR2 40 Yes No Active Description of tag type. VARCHAR2 4 FISHERY_STRING VARCHAR2 20 No No Active Fisheries to which species is affiliated (comma separated list of fishery codes). VARCHAR2 5 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). DATE 6 UOE VARCHAR2 12 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 7 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). DATE 8 UOC VARCHAR2 12 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 33920 MRWEIGHTTYPES Published / External Completed Weight type codes Loaded by batch 9111, 08-01-2016 12:11 Data Table Yes MRDBS Weight type codes 1 WEIGHTCD VARCHAR2 2 Yes Yes Active Weight type code. VARCHAR2 2 WEIGHT_DESC VARCHAR2 40 Yes No Active Weight type description. VARCHAR2 3 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). DATE 4 UOE VARCHAR2 12 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 5 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). DATE 6 UOC VARCHAR2 12 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 7 FISHERY_STRING VARCHAR2 20 No No Active Fisheries to which species is affiliated (comma separated list of fishery codes). VARCHAR2 33922 MRWEIGHT_QUALITY Published / External Completed Quality code used for weight values Loaded by batch 9111, 08-01-2016 12:11 Data Table Yes MRDBS Quality code used for weight values 1 WGTQUALCD VARCHAR2 2 Yes Yes Active Weight quality code. VARCHAR2 2 WGTQUAL_DESC VARCHAR2 40 Yes No Active Weight quality description. VARCHAR2 3 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). DATE 4 UOE VARCHAR2 12 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 5 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). DATE 6 UOC VARCHAR2 12 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 7 FISHERY_STRING VARCHAR2 20 No No Active Fisheries to which species is affiliated (comma separated list of fishery codes). VARCHAR2 Data Steward 2008 Person Alade, Larry larry.alade@noaa.gov 166 Water Street Woods Hole MA 02543-1026 USA 508-495-2085 Distributor 2006 Organization Northeast Fisheries Science Center NEFSC https://ror.org/02nc0ck44 166 Water Street Woods Hole MA 02543-1026 USA (508)495-2000 https://www.fisheries.noaa.gov/about/northeast-fisheries-science-center NEFSC Home Page Online Resource 8:00 a.m. to 4:30 p.m. Monday - Friday Metadata Contact 2008 Person Alade, Larry larry.alade@noaa.gov 166 Water Street Woods Hole MA 02543-1026 USA 508-495-2085 Originator 2006 2008 Person Jones, Patricia L patti.jones@noaa.gov 166 Water Street Woods Hole MA 02543-1026 USA 508-495-2116 508-295-2258 Point of Contact 2008 Person Alade, Larry larry.alade@noaa.gov 166 Water Street Woods Hole MA 02543-1026 USA 508-495-2085 -73.90728 -65.29399 43.18633 37.78106 Eastern boundary - East GOM region; Western boundary - Off the coast of NJ; Northern Boundary - West GOM; Southern boundary - East Delaware Bay Continuing 2003 Restricted Send request to Larry.Alade@noaa.gov along with brief intent for data utility and applications. NEFSC Data Access Procedure: 1. Formal request in writing usually to the data owner/contact or Center Director; 2. Requester is contacted by data owner to review and verify the request content and details for data delivery options. 3. If data is confidential then owner will determine if the data may be released to the requester; 4. If data can be released, the data is downloaded and packaged for delivery electronically; or the requester may be directed to where the data is available online. Network access required NEFSC Data Access Constraint: If data is stored on an internal NEFSC network, the requester may not have direct access to query the data unless they are also authorized for network access. Data application should be conducted withinthe scope of the study objectives which are mainly to characterize/estimate movement, mortality and growth of yellowtail flounder in the New England region. https://storage.googleapis.com/nmfs_odp_nefsc/PARR/FMRD/NCRP/27387/27387_MRDBS_YTFData.zip 27387_MRDBS_YTFData.zip Compressed Zipped Folder: 27387_MRDBS_YTFData Oracle Database on Centralized Data Management System Few recaptures without geographical coordinates or date of recapture and Self reported length measurements Location, vessel, and PII data has been redacted. For recaptures without accurate geographical coordinates but with general knowledge of recapture area, a search algorithm is used to derive the center of recapture location to estimate a lat/long for the recapture location. Manual auditing and post processing of release and recapture data by internal personnel to check for keypunch errors and data outliers coupled with simple summary statistics to gauge the data quality against known biological parameters such as length, age, maturity status etc. Yes Unknown Yes No Dissemination of results were made with little to no delay upon request of documenting annual monitoring report on research progress; generate release and recapture maps as a communication tool with industry members and cooperators and at stock assessment meetings to address the appropriate terms of reference. To Be Determined To be determined Archival of source data preserving unaltered collected data, Scheduled backups, Remote storage backups, Password protection Release data was recorded from scheduled cooperative research cruises on commercial fishing vessels. Recapture information is received from commercial and recreational fishermen and entered into the MRDBS database using a web application with extensive audits. 33885 Entity 33877 Entity 33888 Entity 33889 Entity 33890 Entity 33891 Entity 33893 Entity 33894 Entity 33895 Entity 33878 Entity 33896 Entity 33897 Entity 33899 Entity 33901 Entity 33879 Entity 33880 Entity 33902 Entity 33903 Entity 33904 Entity 33906 Entity 33907 Entity 33909 Entity 33910 Entity 33911 Entity 33912 Entity 33913 Entity 33914 Entity 33915 Entity 33916 Entity 33917 Entity 33918 Entity 33919 Entity 33881 Entity 33920 Entity 33922 Entity 33884 Entity 33882 Entity 33883 Entity gov.noaa.nmfs.inport:27387 Patricia Jones 2015-09-23T10:46:50 SysAdmin InPortAdmin 2026-03-04T19:17:17 2017-02-24 Northeast Fisheries Science Center NEFSC 166 Water Street Woods Hole MA 02543-1026 USA (508)495-2000 https://www.nefsc.noaa.gov 8:00 a.m. to 4:30 p.m. Monday - Friday 1001 Public No No 2017-02-24 1 Year 2018-02-24