27489 Cooperative Atlantic States Shark Pupping and Nursery (COASTSPAN) Data Set Published / External 23132 Apex Predators Program Project Completed Survey of inshore areas used by sharks for pupping and nurseries. Various locations have been surveyed, from the U.S. Virgin Islands to Massachusetts, most in partnership with state or academic institutions; the NEFSC only regularly surveys Delaware Bay. NEFSC Narragansett Lab Narragansett RI USA Data Set Oracle, MS Access, MS Excel Table (digital) not applicable not applicable Multiple gear types 34794 MRMVRELRECAP03 Published / External Completed no-comment Loaded by batch 9270, 09-13-2016 10:42 Data Table Yes MRDBS no-comment 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 REL_EVENTNUM NUMBER 22 Yes No 38 0 Active Release event number. NUMBER 4 REL_TAG_TYPE VARCHAR2 2 Yes No Active Release Style of tag, see support table MRTAGTYPES for descriptions. VARCHAR2 5 REL_TAG_COLOR VARCHAR2 2 Yes No Active Release Color of tag, see support table MRTAGCOLORS for descriptions. VARCHAR2 6 REL_TAG_NUMBER VARCHAR2 6 Yes No Active Release Tag identification number VARCHAR2 7 REL_TAG_SUFFIX VARCHAR2 1 Yes No Active Release Tag suffix. VARCHAR2 8 REL_TAG_REWARD VARCHAR2 2 No No Active Release Reward for tag Recapture or recapture, see support table MRTAGREWARDS for descriptions. VARCHAR2 9 REL_TAG_FATE VARCHAR2 2 No No Active Release Fate of tag, see support table MRTAGFATES for descriptions. VARCHAR2 10 REL_TAG_CONDITION VARCHAR2 2 No No Active Release Condition of tag, see support table MRTAGCONDITIONS for descriptions. VARCHAR2 11 REL_TAG_SITE VARCHAR2 2 No No Active Release Area of tag at recapture, see support table MRTAGSITE for descriptions. VARCHAR2 12 REL_TAG_LOCONFISH VARCHAR2 2 No No Active Release Location on fish where tag is attached, see support table MRTAGLOCONFISH for descriptions. VARCHAR2 13 REL_TRIPID VARCHAR2 8 No No Active Release Trip identification code. VARCHAR2 14 REL_HAULNUM VARCHAR2 4 No No Active Release Ordinal number of the haul within the trip, set number for shark cruises. VARCHAR2 15 REL_TYPE VARCHAR2 2 No No Active Release Event type, see support table MREVENTTYPES for descriptions. VARCHAR2 16 REL_MONTH VARCHAR2 2 No No Active Release Month of event. VARCHAR2 17 REL_DAY VARCHAR2 2 No No Active Release Day of event. VARCHAR2 18 REL_YEAR VARCHAR2 4 No No Active Release Year of event. VARCHAR2 19 REL_DATEQUAL VARCHAR2 2 No No Active Release Date quality, see support table MRDATE_QUALITY for descriptions. VARCHAR2 20 REL_COMMENTS VARCHAR2 200 No No Active Release Comments or remarks. VARCHAR2 21 REL_SPECIES_ITIS VARCHAR2 11 No No Active Release Itis species code, see support table MRSPECIES for descriptions, corresponding survey and shark species codes also in MRSPECIES. VARCHAR2 22 REL_SEX VARCHAR2 1 No No Active Release Sex ( 0 = male, 1 = female). VARCHAR2 23 REL_FISHCOND VARCHAR2 2 No No Active Release Condition of fish at event, see support table MRFISH_CONDITIONS for descriptions. VARCHAR2 24 REL_FISHFATE VARCHAR2 2 No No Active Release Fate of fish at event, see support table MRFISH_FATES for descriptions. VARCHAR2 25 REL_LIFESTAGE VARCHAR2 2 No No Active Release Lifestage of fish at event, see support table MRLIFESTAGES for descriptions. VARCHAR2 26 REL_LENGTH NUMBER 22 No No 6 2 Active Release Length, for sharks: fork length in centimeters . NUMBER 27 REL_LENUOM VARCHAR2 3 No No Active Release Unit of measure for length (CM, IN). VARCHAR2 28 REL_LENQUAL VARCHAR2 2 No No Active Release Data quality code for length, see support table MRLENGTH_QUALITY for descriptions. VARCHAR2 29 REL_LENTYPE VARCHAR2 2 No No Active Release Length type code, see support table MRLENGTH_TYPES for descriptions. VARCHAR2 30 REL_LENDET VARCHAR2 2 No No Active Release Length determination code, see support table MRLENGTH_DETERMINATION for descriptions. VARCHAR2 31 REL_RPTLENGTH NUMBER 22 No No 6 2 Active Release Reported length measurement. NUMBER 32 REL_RPTLENUOM VARCHAR2 3 No No Active Release Unit of measure for reported length (CM, IN). VARCHAR2 33 REL_RPTLENQUAL VARCHAR2 2 No No Active Release Data quality code for reported length, see support table MRLENGTH_QUALITY for descriptions. VARCHAR2 34 REL_RPTLENTYPE VARCHAR2 2 No No Active Release Reported length type code, see support table MRLENGTH_TYPES for descriptions. VARCHAR2 35 REL_OTHLENGTH NUMBER 22 No No 38 2 Active Release Other length measurement. NUMBER 36 REL_OTHLENUOM VARCHAR2 3 No No Active Release Unit of measure for other length (CM, IN). VARCHAR2 37 REL_OTHLENQUAL VARCHAR2 2 No No Active Release Data quality code for other length, see support table MRLENGTH_QUALITY for descriptions. VARCHAR2 38 REL_OTHLENTYPE VARCHAR2 2 No No Active Release Other length type code, see support table MRLENGTH_TYPES for descriptions. VARCHAR2 39 REL_WEIGHT NUMBER 22 No No 38 2 Active Release Weight, for sharks, whole weight in kg. NUMBER 40 REL_WGTUOM VARCHAR2 3 No No Active Release Unit of measure for weight (LB, KG). VARCHAR2 41 REL_WGTQUAL VARCHAR2 2 No No Active Release Weight quality code, see support table MRWEIGHT_QUALITY for descriptions. VARCHAR2 42 REL_WGTTYPE VARCHAR2 2 No No Active Release Weight type code, see support table MRWEIGHT_TYPES for descriptions. VARCHAR2 43 REL_WGTDET VARCHAR2 2 No No Active Release Weight determination code, see support table MRWEIGHT_DETERMINATION for descriptions. VARCHAR2 44 REL_RPTWEIGHT NUMBER 22 No No 6 2 Active Release Reported weight, for sharks, whole weight in kg. NUMBER 45 REL_RPTWGTUOM VARCHAR2 3 No No Active Release Unit of measure for reported weight (LB, KG). VARCHAR2 46 REL_RPTWGTQUAL VARCHAR2 2 No No Active Release Reported weight quality code, see support table MRWEIGHT_QUALITY for descriptions. VARCHAR2 47 REL_RPTWGTTYPE VARCHAR2 2 No No Active Release Reported weight type code, see support table MRWEIGHT_TYPES for descriptions. VARCHAR2 48 REL_SPCOND1 VARCHAR2 2 No No Active Release Special condition code, see support table MRSPECIAL_CONDITIONS for descriptions. VARCHAR2 49 REL_SPCOND2 VARCHAR2 2 No No Active Release Special condition code, see support table MRSPECIAL_CONDITIONS for descriptions.. VARCHAR2 50 REL_BIOSAMP1 VARCHAR2 2 No No Active Release Biological sample code, see support table MRBIO_SAMPLES for descriptions. VARCHAR2 51 REL_BIOSAMP2 VARCHAR2 2 No No Active Release Biological sample code, see support table MRBIO_SAMPLES for descriptions.. VARCHAR2 52 REL_LOCATION VARCHAR2 4 No No Active Release Reported location, see MRLOCATIONS for descriptions. (redacted) VARCHAR2 53 REL_MILES NUMBER 22 No No 4 0 Active Release Miles from reported location (used for location calculation). (redacted) NUMBER 54 REL_DIRECTION VARCHAR2 5 No No Active Release Direction from reported location (used for location calculation). (redacted) VARCHAR2 55 REL_LORANCHAIN VARCHAR2 4 No No Active Release Loran chain. (redacted) VARCHAR2 56 REL_LORAN1 NUMBER 22 No No 8 2 Active Release Loran x. (redacted) NUMBER 57 REL_LORAN2 NUMBER 22 No No 8 2 Active Release Loran y. (redacted) NUMBER 58 REL_LATDEG VARCHAR2 2 No No Active Release Event latitude degrees. (redacted) VARCHAR2 59 REL_LATMIN VARCHAR2 2 No No Active Release Event latitude minutes. (redacted) VARCHAR2 60 REL_LATSEC VARCHAR2 2 No No Active Release Event latitude seconds. (redacted) VARCHAR2 61 REL_NOS VARCHAR2 1 No No Active Release North or south. (redacted) VARCHAR2 62 REL_DECLAT VARCHAR2 10 No No Active Release latitude in decimal degrees. (redacted) VARCHAR2 63 REL_LONDEG VARCHAR2 3 No No Active Release Event longitude degrees. (redacted) VARCHAR2 64 REL_LONMIN VARCHAR2 2 No No Active Release Event longitude minutes. (redacted) VARCHAR2 65 REL_LONSEC VARCHAR2 2 No No Active Release Event longitude seconds. (redacted) VARCHAR2 66 REL_EOW VARCHAR2 1 No No Active Release East or west. (redacted) VARCHAR2 67 REL_DECLON VARCHAR2 11 No No Active Release longitude in decimal degrees. (redacted) VARCHAR2 68 REL_LOCQUAL VARCHAR2 2 No No Active Release Data quality code for location, see MRLOC_QUALITY for descriptions. VARCHAR2 69 REL_DAYSFREE NUMBER 22 No No 38 0 Active Release Days free for recapture only. NUMBER 70 REL_DISTTRAVEL NUMBER 22 No No 5 0 Active Release Distance traveled in nautical miles for recapture only, distance traveled is calculated with great circle formula. NUMBER 71 REL_TRAVELDEG NUMBER 22 No No 4 1 Active Release Travel direction for recapture only, see MRDIRECTIONS for descriptions. NUMBER 72 REL_TRAVELDIR VARCHAR2 2 No No Active Release 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 73 REL_DEPTH NUMBER 22 No No 38 0 Active Release Depth. NUMBER 74 REL_DEPTHUOM VARCHAR2 2 No No Active Release Unit of measure used for depth (FM, FT, M). VARCHAR2 75 REL_CONTACTID NUMBER 22 No No 38 0 Active Release Contact id for event. NUMBER 76 REL_INDUSTRY VARCHAR2 2 No No Active Release Industry (category, sector) at time of event, see support table MRINDUSTRY for descriptions. VARCHAR2 77 REL_OCCUPATION VARCHAR2 2 No No Active Release Occupation at time of event, see support table MROCCUPATION for descriptions. VARCHAR2 78 REL_GEAR VARCHAR2 2 No No Active Release Gear used, see support table MRGEARS for descriptions. VARCHAR2 79 REL_SHVESSEL VARCHAR2 2 No No Active Release Vessel code used by the shark fishery, see support table MRSHVESSELS for descriptions. VARCHAR2 80 REL_VESS_NATION VARCHAR2 2 No No Active Release Vessel nation at time of event, see support table MRNATIONS for descriptions. VARCHAR2 81 REL_WEB_DOE DATE 7 No No Active Release Date of Last Entry from Web Application. DATE 82 REL_WEB_UOE VARCHAR2 12 No No Active Release User of Last Entry from Web Application. VARCHAR2 83 REL_WEB_DOC DATE 7 No No Active Release Date of Last Change from Web Application. DATE 84 REL_WEB_UOC VARCHAR2 12 No No Active Release User of Last Change from Web Application. VARCHAR2 85 REC_EVENTNUM NUMBER 22 Yes No 38 0 Active Recapture event number. NUMBER 86 REC_TAG_TYPE VARCHAR2 2 Yes No Active Recapture Style of tag, see support table MRTAGTYPES for descriptions. VARCHAR2 87 REC_TAG_COLOR VARCHAR2 2 Yes No Active Recapture Color of tag, see support table MRTAGCOLORS for descriptions. VARCHAR2 88 REC_TAG_NUMBER VARCHAR2 6 Yes No Active Recapture Tag identification number. VARCHAR2 89 REC_TAG_SUFFIX VARCHAR2 1 Yes No Active Recapture Tag suffix. VARCHAR2 90 REC_TAG_REWARD VARCHAR2 2 No No Active Recapture Reward for tag Recapture or recapture, see support table MRTAGREWARDS for descriptions. VARCHAR2 91 REC_TAG_FATE VARCHAR2 2 No No Active Recapture Fate of tag, see support table MRTAGFATES for descriptions. VARCHAR2 92 REC_TAG_CONDITION VARCHAR2 2 No No Active Recapture Condition of tag, see support table MRTAGCONDITIONS for descriptions. VARCHAR2 93 REC_TAG_SITE VARCHAR2 2 No No Active Recapture Area of tag at recapture, see support table MRTAGSITE for descriptions. VARCHAR2 94 REC_TAG_LOCONFISH VARCHAR2 2 No No Active Recapture Location on fish where tag is attached, see support table MRTAGLOCONFISH for descriptions. VARCHAR2 95 REC_TRIPID VARCHAR2 8 No No Active Recapture Trip identification code. VARCHAR2 96 REC_HAULNUM VARCHAR2 4 No No Active Recapture Ordinal number of the haul within the trip, set number for shark cruises. VARCHAR2 97 REC_TYPE VARCHAR2 2 No No Active Recapture Event type, see support table MREVENTTYPES for descriptions. VARCHAR2 98 REC_MONTH VARCHAR2 2 No No Active Recapture Month of event. VARCHAR2 99 REC_DAY VARCHAR2 2 No No Active Recapture Day of event. VARCHAR2 100 REC_YEAR VARCHAR2 4 No No Active Recapture Year of event. VARCHAR2 101 REC_DATEQUAL VARCHAR2 2 No No Active Recapture Date quality, see support table MRDATE_QUALITY for descriptions. VARCHAR2 102 REC_COMMENTS VARCHAR2 200 No No Active Recapture Comments or remarks. VARCHAR2 103 REC_SPECIES_ITIS VARCHAR2 11 No No Active Recapture Itis species code, see support table MRSPECIES for descriptions, corresponding survey and shark species codes also in MRSPECIES. VARCHAR2 104 REC_SEX VARCHAR2 1 No No Active Recapture Sex ( 0 = male, 1 = female). VARCHAR2 105 REC_FISHCOND VARCHAR2 2 No No Active Recapture Condition of fish at event, see support table MRFISH_CONDITIONS for descriptions. VARCHAR2 106 REC_FISHFATE VARCHAR2 2 No No Active Recapture Fate of fish at event, see support table MRFISH_FATES for descriptions. VARCHAR2 107 REC_LIFESTAGE VARCHAR2 2 No No Active Recapture Lifestage of fish at event, see support table MRLIFESTAGES for descriptions. VARCHAR2 108 REC_LENGTH NUMBER 22 No No 6 2 Active Recapture Length, for sharks: fork length in centimeters . NUMBER 109 REC_LENUOM VARCHAR2 3 No No Active Recapture Unit of measure for length (CM, IN). VARCHAR2 110 REC_LENQUAL VARCHAR2 2 No No Active Recapture Data quality code for length, see support table MRLENGTH_QUALITY for descriptions. VARCHAR2 111 REC_LENTYPE VARCHAR2 2 No No Active Recapture Length type code, see support table MRLENGTH_TYPES for descriptions. VARCHAR2 112 REC_LENDET VARCHAR2 2 No No Active Recapture Length determination code, see support table MRLENGTH_DETERMINATION for descriptions. VARCHAR2 113 REC_RPTLENGTH NUMBER 22 No No 6 2 Active Recapture Reported length measurement. NUMBER 114 REC_RPTLENUOM VARCHAR2 3 No No Active Recapture Unit of measure for reported length (CM, IN). VARCHAR2 115 REC_RPTLENQUAL VARCHAR2 2 No No Active Recapture Data quality code for reported length, see support table MRLENGTH_QUALITY for descriptions. VARCHAR2 116 REC_RPTLENTYPE VARCHAR2 2 No No Active Recapture Reported length type code, see support table MRLENGTH_TYPES for descriptions. VARCHAR2 117 REC_OTHLENGTH NUMBER 22 No No 38 2 Active Recapture Other length measurement. NUMBER 118 REC_OTHLENUOM VARCHAR2 3 No No Active Recapture Unit of measure for other length (CM, IN). VARCHAR2 119 REC_OTHLENQUAL VARCHAR2 2 No No Active Recapture Data quality code for other length, see support table MRLENGTH_QUALITY for descriptions. VARCHAR2 120 REC_OTHLENTYPE VARCHAR2 2 No No Active Recapture Other length type code, see support table MRLENGTH_TYPES for descriptions. VARCHAR2 121 REC_WEIGHT NUMBER 22 No No 6 2 Active Recapture Weight, for sharks, whole weight in kg. NUMBER 122 REC_WGTUOM VARCHAR2 3 No No Active Recapture Unit of measure for weight (LB, KG). VARCHAR2 123 REC_WGTQUAL VARCHAR2 2 No No Active Recapture Weight quality code, see support table MRWEIGHT_QUALITY for descriptions. VARCHAR2 124 REC_WGTTYPE VARCHAR2 2 No No Active Recapture Weight type code, see support table MRWEIGHT_TYPES for descriptions. VARCHAR2 125 REC_WGTDET VARCHAR2 2 No No Active Recapture Weight determination code, see support table MRWEIGHT_DETERMINATION for descriptions. VARCHAR2 126 REC_RPTWEIGHT NUMBER 22 No No 6 2 Active Recapture Reported weight, for sharks, whole weight in kg. NUMBER 127 REC_RPTWGTUOM VARCHAR2 3 No No Active Recapture Unit of measure for reported weight (LB, KG). VARCHAR2 128 REC_RPTWGTQUAL VARCHAR2 2 No No Active Recapture Reported weight quality code, see support table MRWEIGHT_QUALITY for descriptions. VARCHAR2 129 REC_RPTWGTTYPE VARCHAR2 2 No No Active Recapture Reported weight type code, see support table MRWEIGHT_TYPES for descriptions. VARCHAR2 130 REC_SPCOND1 VARCHAR2 2 No No Active Recapture Special condition code, see support table MRSPECIAL_CONDITIONS for descriptions. VARCHAR2 131 REC_SPCOND2 VARCHAR2 2 No No Active Recapture Special condition code, see support table MRSPECIAL_CONDITIONS for descriptions.. VARCHAR2 132 REC_BIOSAMP1 VARCHAR2 2 No No Active Recapture Biological sample code, see support table MRBIO_SAMPLES for descriptions. VARCHAR2 133 REC_BIOSAMP2 VARCHAR2 2 No No Active Recapture Biological sample code, see support table MRBIO_SAMPLES for descriptions.. VARCHAR2 134 REC_LOCATION VARCHAR2 4 No No Active Recapture Reported location, see MRLOCATIONS for descriptions. (redacted) VARCHAR2 135 REC_MILES NUMBER 22 No No 4 0 Active Recapture Miles from reported location (used for location calculation). (redacted) NUMBER 136 REC_DIRECTION VARCHAR2 5 No No Active Recapture Direction from reported location (used for location calculation). (redacted) VARCHAR2 137 REC_LORANCHAIN VARCHAR2 4 No No Active Recapture Loran chain. (redacted) VARCHAR2 138 REC_LORAN1 NUMBER 22 No No 8 2 Active Recapture Loran x. (redacted) NUMBER 139 REC_LORAN2 NUMBER 22 No No 8 2 Active Recapture Loran y. (redacted) NUMBER 140 REC_LATDEG VARCHAR2 2 No No Active Recapture Event latitude degrees. (redacted) VARCHAR2 141 REC_LATMIN VARCHAR2 2 No No Active Recapture Event latitude minutes. (redacted) VARCHAR2 142 REC_LATSEC VARCHAR2 2 No No Active Recapture Event latitude seconds. (redacted) VARCHAR2 143 REC_NOS VARCHAR2 1 No No Active Recapture North or south. (redacted) VARCHAR2 144 REC_DECLAT VARCHAR2 10 No No Active Recapture Latitude in decimal degrees. (redacted) VARCHAR2 145 REC_LONDEG VARCHAR2 3 No No Active Recapture Event longitude degrees. (redacted) VARCHAR2 146 REC_LONMIN VARCHAR2 2 No No Active Recapture Event longitude minutes. (redacted) VARCHAR2 147 REC_LONSEC VARCHAR2 2 No No Active Recapture Event longitude seconds. (redacted) VARCHAR2 148 REC_EOW VARCHAR2 1 No No Active Recapture East or west. (redacted) VARCHAR2 149 REC_DECLON VARCHAR2 11 No No Active Recapture Longitude in decimal degrees. (redacted) VARCHAR2 150 REC_LOCQUAL VARCHAR2 2 No No Active Recapture Data quality code for location, see MRLOC_QUALITY for descriptions. VARCHAR2 151 REC_DAYSFREE NUMBER 22 No No 38 0 Active Recapture Days free for recapture only. NUMBER 152 REC_DISTTRAVEL NUMBER 22 No No 5 0 Active Recapture Distance traveled in nautical miles for recapture only, distance traveled is calculated with great circle formula. NUMBER 153 REC_TRAVELDEG NUMBER 22 No No 4 1 Active Recapture Travel direction for recapture only, see MRDIRECTIONS for descriptions. NUMBER 154 REC_TRAVELDIR VARCHAR2 2 No No Active Recapture 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 155 REC_DEPTH NUMBER 22 No No 38 0 Active Recapture Depth. NUMBER 156 REC_DEPTHUOM VARCHAR2 2 No No Active Recapture Unit of measure used for depth (FM, FT, M). VARCHAR2 157 REC_CONTACTID NUMBER 22 No No 38 0 Active Recapture Contact id for event. NUMBER 158 REC_INDUSTRY VARCHAR2 2 No No Active Recapture Industry (category, sector) at time of event, see support table MRINDUSTRY for descriptions. VARCHAR2 159 REC_OCCUPATION VARCHAR2 2 No No Active Recapture Occupation at time of event, see support table MROCCUPATION for descriptions. VARCHAR2 160 REC_GEAR VARCHAR2 2 No No Active Recapture Gear used, see support table MRGEARS for descriptions. VARCHAR2 161 REC_SHVESSEL VARCHAR2 2 No No Active Recapture Vessel code used by the shark fishery, see support table MRSHVESSELS for descriptions. VARCHAR2 162 REC_VESS_NATION VARCHAR2 2 No No Active Recapture Vessel nation at time of event, see support table MRNATIONS for descriptions. VARCHAR2 163 REC_WEB_DOE DATE 7 No No Active Recapture Date of Last Entry from Web Application. DATE 164 REC_WEB_UOE VARCHAR2 12 No No Active Recapture User of Last Entry from Web Application. VARCHAR2 165 REC_WEB_DOC DATE 7 No No Active Recapture Date of Last Change from Web Application. DATE 166 REC_WEB_UOC VARCHAR2 12 No No Active Recapture User of Last Change from Web Application. VARCHAR2 34795 MRVEVENT Published / External Completed View of committed events without tag information (use to query animals) Loaded by batch 9270, 09-13-2016 10:42 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 38 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_LOCATION VARCHAR2 4 No No Active Reported location, see MRLOCATIONS for descriptions. (redacted) VARCHAR2 13 EV_MILES NUMBER 22 No No 38 0 Active Miles from reported location (used for location calculation). (redacted) NUMBER 14 EV_DIRECTION VARCHAR2 5 No No Active Direction from reported location (used for location calculation). (redacted) VARCHAR2 15 EV_LATDEG VARCHAR2 2 No No Active Event latitude degrees. (redacted) VARCHAR2 16 EV_LATMIN VARCHAR2 2 No No Active Event latitude minutes. (redacted) VARCHAR2 17 EV_LATSEC VARCHAR2 2 No No Active Event latitude seconds. (redacted) VARCHAR2 18 EV_NOS VARCHAR2 1 No No Active North or south. (redacted) VARCHAR2 19 EV_DECLAT VARCHAR2 10 No No Active Latitude in decimal degrees. (redacted) VARCHAR2 20 EV_LONDEG VARCHAR2 3 No No Active Event longitude degrees. (redacted) VARCHAR2 21 EV_LONMIN VARCHAR2 2 No No Active Event longitude minutes. (redacted) VARCHAR2 22 EV_LONSEC VARCHAR2 2 No No Active Event longitude seconds. (redacted) VARCHAR2 23 EV_EOW VARCHAR2 1 No No Active East or west. (redacted) VARCHAR2 24 EV_DECLON VARCHAR2 11 No No Active Longitude in decimal degrees. (redacted) VARCHAR2 25 EV_LOCQUAL VARCHAR2 2 No No Active Data quality code for location, see MRLOC_QUALITY for descriptions. VARCHAR2 26 EV_LORANCHAIN VARCHAR2 4 No No Active Loran chain. (redacted) VARCHAR2 27 EV_LORAN1 NUMBER 22 No No 38 2 Active Loran x. (redacted) NUMBER 28 EV_LORAN2 NUMBER 22 No No 8 2 Active Loran y. (redacted) NUMBER 29 EV_DEPTH NUMBER 22 No No 4 0 Active Depth. NUMBER 30 EV_DEPTHUOM VARCHAR2 2 No No Active Unit of measure used for depth (FM, FT, M). VARCHAR2 31 EV_DEPTH_FM NUMBER 22 No No 38 Active Depth in Fathoms. NUMBER 32 EV_DAYSFREE NUMBER 22 No No 5 0 Active Days free for recapture only. NUMBER 33 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 34 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. VARCHAR2 35 EV_TRAVELDEG NUMBER 22 No No 38 1 Active Travel direction for recapture only, see MRDIRECTIONS for descriptions. NUMBER 36 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 37 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 38 EV_SEX VARCHAR2 1 No No Active Sex ( 0 = male, 1 = female). VARCHAR2 39 EV_FISHFATE VARCHAR2 2 No No Active Fate of fish at event, see support table MRFISH_FATES for descriptions. VARCHAR2 40 EV_LIFESTAGE VARCHAR2 2 No No Active Lifestage of fish at event, see support table MRLIFESTAGES for descriptions. VARCHAR2 41 EV_FISHCOND VARCHAR2 2 No No Active Condition of fish at event, see support table MRFISH_CONDITIONS for descriptions. VARCHAR2 42 EV_BIOSAMP1 VARCHAR2 2 No No Active Biological sample code, see support table MRBIO_SAMPLES for descriptions. VARCHAR2 43 EV_BIOSAMP2 VARCHAR2 2 No No Active Biological sample code, see support table MRBIO_SAMPLES for descriptions.. VARCHAR2 44 EV_BIOSAMP3 VARCHAR2 2 No No Active Biological sample code, see support table MRBIO_SAMPLES for descriptions.. VARCHAR2 45 EV_BIOSAMP4 VARCHAR2 2 No No Active Biological sample code, see support table MRBIO_SAMPLES for descriptions.. VARCHAR2 46 EV_BIOSAMP5 VARCHAR2 2 No No Active Biological sample code, see support table MRBIO_SAMPLES for descriptions.. VARCHAR2 47 EV_BIOSAMP6 VARCHAR2 2 No No Active Biological sample code, see support table MRBIO_SAMPLES for descriptions.. VARCHAR2 48 EV_BIOSAMP7 VARCHAR2 2 No No Active Biological sample code, see support table MRBIO_SAMPLES for descriptions.. VARCHAR2 49 EV_BIOSAMP8 VARCHAR2 2 No No Active Biological sample code, see support table MRBIO_SAMPLES for descriptions.. VARCHAR2 50 EV_BIOSAMP9 VARCHAR2 2 No No Active Biological sample code, see support table MRBIO_SAMPLES for descriptions.. VARCHAR2 51 EV_BIOSAMP10 VARCHAR2 2 No No Active Biological sample code, see support table MRBIO_SAMPLES for descriptions.. VARCHAR2 52 EV_LENGTH NUMBER 22 No No 6 2 Active Length, for sharks: fork length in centimeters . NUMBER 53 EV_LENUOM VARCHAR2 3 No No Active Unit of measure for length (CM, IN). VARCHAR2 54 EV_LENQUAL VARCHAR2 2 No No Active Data quality code for length, see support table MRLENGTH_QUALITY for descriptions. VARCHAR2 55 EV_LENTYPE VARCHAR2 2 No No Active Length type code, see support table MRLENGTH_TYPES for descriptions. VARCHAR2 56 EV_LENDET VARCHAR2 2 No No Active Length determination code, see support table MRLENGTH_DETERMINATION for descriptions. VARCHAR2 57 EV_RPTLENGTH NUMBER 22 No No 6 2 Active Reported length measurement. NUMBER 58 EV_RPTLENUOM VARCHAR2 3 No No Active Unit of measure for reported length (CM, IN). VARCHAR2 59 EV_RPTLENQUAL VARCHAR2 2 No No Active Data quality code for reported length, see support table MRLENGTH_QUALITY for descriptions. VARCHAR2 60 EV_RPTLENTYPE VARCHAR2 2 No No Active Reported length type code, see support table MRLENGTH_TYPES for descriptions. VARCHAR2 61 EV_OTHLENGTH NUMBER 22 No No 38 2 Active Other length measurement. NUMBER 62 EV_OTHLENUOM VARCHAR2 3 No No Active Unit of measure for other length (CM, IN). VARCHAR2 63 EV_OTHLENQUAL VARCHAR2 2 No No Active Data quality code for other length, see support table MRLENGTH_QUALITY for descriptions. VARCHAR2 64 EV_OTHLENTYPE VARCHAR2 2 No No Active Other length type code, see support table MRLENGTH_TYPES for descriptions. VARCHAR2 65 EV_WEIGHT NUMBER 22 No No 38 2 Active Weight, for sharks, whole weight in kg. NUMBER 66 EV_WGTUOM VARCHAR2 3 No No Active Unit of measure for weight (LB, KG). VARCHAR2 67 EV_WGTQUAL VARCHAR2 2 No No Active Weight quality code, see support table MRWEIGHT_QUALITY for descriptions. VARCHAR2 68 EV_WGTTYPE VARCHAR2 2 No No Active Weight type code, see support table MRWEIGHT_TYPES for descriptions. VARCHAR2 69 EV_WGTDET VARCHAR2 2 No No Active Weight determination code, see support table MRWEIGHT_DETERMINATION for descriptions. VARCHAR2 70 EV_RPTWEIGHT NUMBER 22 No No 6 2 Active Reported weight, for sharks, whole weight in kg. NUMBER 71 EV_RPTWGTUOM VARCHAR2 3 No No Active Unit of measure for reported weight (LB, KG). VARCHAR2 72 EV_RPTWGTQUAL VARCHAR2 2 No No Active Reported weight quality code, see support table MRWEIGHT_QUALITY for descriptions. VARCHAR2 73 EV_RPTWGTTYPE VARCHAR2 2 No No Active Reported weight type code, see support table MRWEIGHT_TYPES for descriptions. VARCHAR2 74 EV_CONTACTID NUMBER 22 No No 6 0 Active Contact id for event. NUMBER 75 EV_INDUSTRY VARCHAR2 2 No No Active Industry (category, sector) at time of event, see support table MRINDUSTRY for descriptions. VARCHAR2 76 EV_OCCUPATION VARCHAR2 2 No No Active Occupation at time of event, see support table MROCCUPATION for descriptions. VARCHAR2 77 EV_VESS_NATION VARCHAR2 2 No No Active Vessel nation at time of event, see support table MRNATIONS for descriptions. VARCHAR2 78 EV_SHVESSEL VARCHAR2 2 No No Active Vessel code used by the shark fishery, see support table MRSHVESSELS for descriptions. VARCHAR2 79 EV_GEAR VARCHAR2 2 No No Active Gear used, see support table MRGEARS for descriptions. VARCHAR2 34796 MRVTAGEVENT Published / External Completed View of committed events including tag information (use to query tags) Loaded by batch 9270, 09-13-2016 10:42 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 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 12 HAULNUM VARCHAR2 4 No No Active Ordinal number of the haul within the trip, set number for shark cruises. VARCHAR2 13 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 14 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 15 EV_TYPE VARCHAR2 2 No No Active Event type, see support table MREVENTTYPES for descriptions. VARCHAR2 16 EV_MONTH VARCHAR2 2 No No Active Month of event. VARCHAR2 17 EV_DAY VARCHAR2 2 No No Active Day of event. VARCHAR2 18 EV_YEAR VARCHAR2 4 No No Active Year of event. VARCHAR2 19 EV_DATE VARCHAR2 10 No No Active Date of Event. VARCHAR2 20 EV_DATEQUAL VARCHAR2 2 No No Active Date quality, see support table MRDATE_QUALITY for descriptions. VARCHAR2 21 EV_COMMENTS VARCHAR2 200 No No Active Comments or remarks. VARCHAR2 22 EV_STATAREA VARCHAR2 3 No No Active Statistical area calculated from latitude and longitude, note: stat area 551, 552 are in Canadian water. VARCHAR2 23 EV_MILES NUMBER 22 No No 38 0 Active Miles from reported location (used for location calculation). (redacted) NUMBER 24 EV_DIRECTION VARCHAR2 5 No No Active Direction from reported location (used for location calculation). (redacted) VARCHAR2 25 EV_LATDEG VARCHAR2 2 No No Active Event latitude degrees. (redacted) VARCHAR2 26 EV_LATMIN VARCHAR2 2 No No Active Event latitude minutes. (redacted) VARCHAR2 27 EV_LATSEC VARCHAR2 2 No No Active Event latitude seconds. (redacted) VARCHAR2 28 EV_NOS VARCHAR2 1 No No Active North or south. (redacted) VARCHAR2 29 EV_DECLAT VARCHAR2 9 No No Active Latitude in decimal degrees. (redacted) VARCHAR2 30 EV_LONDEG VARCHAR2 3 No No Active Event longitude degrees. (redacted) VARCHAR2 31 EV_LONMIN VARCHAR2 2 No No Active Event longitude minutes. (redacted) VARCHAR2 32 EV_LONSEC VARCHAR2 2 No No Active Event longitude seconds. (redacted) VARCHAR2 33 EV_EOW VARCHAR2 1 No No Active East or west. (redacted) VARCHAR2 34 EV_DECLON VARCHAR2 10 No No Active Longitude in decimal degrees. (redacted) VARCHAR2 35 EV_LOCQUAL VARCHAR2 2 No No Active Data quality code for location, see MRLOC_QUALITY for descriptions. VARCHAR2 36 EV_DEPTH NUMBER 22 No No 4 0 Active Depth. NUMBER 37 EV_DEPTHUOM VARCHAR2 2 No No Active Unit of measure used for depth (FM, FT, M). VARCHAR2 38 EV_DEPTH_FM NUMBER 22 No No 38 Active Depth in Fathoms. NUMBER 39 EV_DAYSFREE NUMBER 22 No No 5 0 Active Days free for recapture only. NUMBER 40 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 41 EV_TRAVELDEG NUMBER 22 No No 4 1 Active Travel direction for recapture only, see MRDIRECTIONS for descriptions. NUMBER 42 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 43 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 44 EV_SEX VARCHAR2 1 No No Active Sex ( 0 = male, 1 = female). VARCHAR2 45 EV_LENGTH NUMBER 22 No No 38 2 Active Length, for sharks: fork length in centimeters . NUMBER 46 EV_LENUOM VARCHAR2 3 No No Active Unit of measure for length (CM, IN). VARCHAR2 47 EV_LENQUAL VARCHAR2 2 No No Active Data quality code for length, see support table MRLENGTH_QUALITY for descriptions. VARCHAR2 48 EV_LENTYPE VARCHAR2 2 No No Active Length type code, see support table MRLENGTH_TYPES for descriptions. VARCHAR2 49 EV_LENDET VARCHAR2 2 No No Active Length determination code, see support table MRLENGTH_DETERMINATION for descriptions. VARCHAR2 50 EV_RPTLENGTH NUMBER 22 No No 6 2 Active Reported length measurement. NUMBER 51 EV_RPTLENUOM VARCHAR2 3 No No Active Unit of measure for reported length (CM, IN). VARCHAR2 52 EV_RPTLENQUAL VARCHAR2 2 No No Active Data quality code for reported length, see support table MRLENGTH_QUALITY for descriptions. VARCHAR2 53 EV_RPTLENTYPE VARCHAR2 2 No No Active Reported length type code, see support table MRLENGTH_TYPES for descriptions. VARCHAR2 54 EV_OTHLENGTH NUMBER 22 No No 38 2 Active Other length measurement. NUMBER 55 EV_OTHLENUOM VARCHAR2 3 No No Active Unit of measure for other length (CM, IN). VARCHAR2 56 EV_OTHLENQUAL VARCHAR2 2 No No Active Data quality code for other length, see support table MRLENGTH_QUALITY for descriptions. VARCHAR2 57 EV_OTHLENTYPE VARCHAR2 2 No No Active Other length type code, see support table MRLENGTH_TYPES for descriptions. VARCHAR2 58 EV_WEIGHT NUMBER 22 No No 38 2 Active Weight, for sharks, whole weight in kg. NUMBER 59 EV_WGTUOM VARCHAR2 3 No No Active Unit of measure for weight (LB, KG). VARCHAR2 60 EV_WGTQUAL VARCHAR2 2 No No Active Weight quality code, see support table MRWEIGHT_QUALITY for descriptions. VARCHAR2 61 EV_WGTTYPE VARCHAR2 2 No No Active Weight type code, see support table MRWEIGHT_TYPES for descriptions. VARCHAR2 62 EV_WGTDET VARCHAR2 2 No No Active Weight determination code, see support table MRWEIGHT_DETERMINATION for descriptions. VARCHAR2 63 EV_RPTWEIGHT NUMBER 22 No No 6 2 Active Reported weight, for sharks, whole weight in kg. NUMBER 64 EV_RPTWGTUOM VARCHAR2 3 No No Active Unit of measure for reported weight (LB, KG). VARCHAR2 65 EV_RPTWGTQUAL VARCHAR2 2 No No Active Reported weight quality code, see support table MRWEIGHT_QUALITY for descriptions. VARCHAR2 66 EV_RPTWGTTYPE VARCHAR2 2 No No Active Reported weight type code, see support table MRWEIGHT_TYPES for descriptions. VARCHAR2 67 EV_CONTACTID NUMBER 22 No No 38 0 Active Contact id for event. NUMBER 68 EV_INDUSTRY VARCHAR2 2 No No Active Industry (category, sector) at time of event, see support table MRINDUSTRY for descriptions. VARCHAR2 69 EV_OCCUPATION VARCHAR2 2 No No Active Occupation at time of event, see support table MROCCUPATION for descriptions. VARCHAR2 70 EV_GEAR VARCHAR2 2 No No Active Gear used, see support table MRGEARS for descriptions. VARCHAR2 71 HOW_REPORTED VARCHAR2 2 No No Active How recapture was reported, see support table MRRECAP_REPORTED for descriptions. VARCHAR2 72 INFO_PENDING VARCHAR2 1 No No Active Additional information is pending about the recapture 0 = no, 1 = yes. VARCHAR2 73 DATE_ENTERED VARCHAR2 10 No No Active Date of Entry. VARCHAR2 74 DATE_LAST_UPDATED VARCHAR2 10 No No Active Date of Last Update VARCHAR2 34797 MRBIO_SAMPLES Published / External Completed Biological samples taken at release/recapture Loaded by batch 9271, 09-13-2016 10:43 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 34798 MRCATEGORY Published / External Completed Categories of contacts in the Mark Recapture database Loaded by batch 9271, 09-13-2016 10:43 Data Table Yes MRDBS Categories of contacts in the Mark Recapture database 1 CATEGORYCD VARCHAR2 2 Yes Yes Active Category code. VARCHAR2 2 CATEGORY_DESC VARCHAR2 40 Yes No Active Category 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 34799 MRCOMPASS_CODES Published / External Completed Directions used for calculation of lat/lon from a reported location Loaded by batch 9271, 09-13-2016 10:43 Data Table Yes MRDBS Directions used for calculation of lat/lon from a reported location 1 COMPASSCD VARCHAR2 5 Yes Yes Active Compass code. VARCHAR2 2 DIR_DEGREES NUMBER 22 Yes No 38 1 Active Direction degrees. NUMBER 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 SEQ NUMBER 22 No No 38 0 Active Sequence number . NUMBER 34800 MRDATE_QUALITY Published / External Completed Quality code used for date values Loaded by batch 9271, 09-13-2016 10:43 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 34801 MRDIRECTIONS Published / External Completed Direction codes used for direction traveled Loaded by batch 9271, 09-13-2016 10:43 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 34802 MREVENTSTATUS Published / External Completed Status of events that may be recorded for a release/recapture Loaded by batch 9271, 09-13-2016 10:43 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 34803 MREVENTTYPES Published / External Completed Types of events that may be recorded for a release/recapture Loaded by batch 9271, 09-13-2016 10:43 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 34804 MRFISHCONDITIONS Published / External Completed Condition of animal at release/recapture Loaded by batch 9271, 09-13-2016 10:43 Data Table Yes MRDBS Condition of animal at release/recapture 1 FISHCONDCD VARCHAR2 2 Yes Yes Active Fish condition code. VARCHAR2 2 FISHCOND_DESC VARCHAR2 80 Yes No Active Fish 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 34805 MRFISHERY Published / External Completed Fisheries in the Mark Recapture database Loaded by batch 9271, 09-13-2016 10:43 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 34806 MRFISHFATES Published / External Completed Fate of fish at release/recapture Loaded by batch 9271, 09-13-2016 10:43 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 34807 MRGEARS Published / External Completed Gear types in the Mark Recapture database Loaded by batch 9271, 09-13-2016 10:43 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 34808 MRINDUSTRY Published / External Completed Industry (sector or category) for contacts and events Loaded by batch 9271, 09-13-2016 10:43 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 34809 MRLENGTHTYPES Published / External Completed Length type codes Loaded by batch 9271, 09-13-2016 10:43 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 34810 MRLENGTH_DETERMINATION Published / External Completed Support table for how length of animal was determined Loaded by batch 9271, 09-13-2016 10:43 Data Table Yes MRDBS Support table for how length of animal was determined 1 LENDETCD VARCHAR2 2 Yes Yes Active Length determination code. VARCHAR2 2 LENDET_DESC VARCHAR2 40 Yes No Active Length determination 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 34811 MRLENGTH_QUALITY Published / External Completed Quality code used for length values Loaded by batch 9271, 09-13-2016 10:43 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 34812 MRLIFESTAGES Published / External Completed Animal lifestages Loaded by batch 9271, 09-13-2016 10:43 Data Table Yes MRDBS Animal lifestages 1 LIFESTAGECD VARCHAR2 2 Yes Yes Active Life stage code. VARCHAR2 2 LIFESTAGE_DESC VARCHAR2 40 Yes No Active Life stage 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 34813 MRLOCATIONS Published / External Completed Location information used to calculate latitude and longitude from a reported location Loaded by batch 9271, 09-13-2016 10:43 Data Table Yes MRDBS Location information used to calculate latitude and longitude from a reported location 1 LOCCD VARCHAR2 4 Yes Yes Active Location code. VARCHAR2 2 LOC_DESC VARCHAR2 80 Yes No Active Location description. VARCHAR2 3 FISHERY_STRING VARCHAR2 20 No No Active Fisheries to which species is affiliated (comma separated list of fishery codes). VARCHAR2 4 ONLAND VARCHAR2 1 No No Active on land (not used). VARCHAR2 5 NOS VARCHAR2 1 No No Active North or south. VARCHAR2 6 EOW VARCHAR2 1 No No Active East or west. VARCHAR2 7 MAPCORRECT FLOAT 22 No No 126 Active Map correct. FLOAT 8 COUNTY VARCHAR2 25 No No Active County. VARCHAR2 9 COAST VARCHAR2 5 No No Active Coast. VARCHAR2 10 DOE DATE 7 No No Active Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). DATE 11 UOE VARCHAR2 12 No No Active The Oracle username of the individual who entered the new record. VARCHAR2 12 DOC DATE 7 No No Active Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). DATE 13 UOC VARCHAR2 12 No No Active The Oracle username of the individual who changed the current record. VARCHAR2 14 LAT_DEG VARCHAR2 2 No No Active Latitude degrees. (redacted) VARCHAR2 15 LAT_MIN VARCHAR2 2 No No Active Latitude minutes. (redacted) VARCHAR2 16 LAT_SEC VARCHAR2 2 No No Active Latitude seconds. (redacted) VARCHAR2 17 LON_DEG VARCHAR2 3 No No Active Longitude degrees. (redacted) VARCHAR2 18 LON_MIN VARCHAR2 2 No No Active Longitude minutes. (redacted) VARCHAR2 19 LON_SEC VARCHAR2 2 No No Active Longitude seconds. (redacted) VARCHAR2 20 MRSEQUENCE VARCHAR2 40 No No Active Sequencing for web application select list VARCHAR2 34814 MRLOCATION_QUALITY Published / External Completed Quality code used for length values Loaded by batch 9271, 09-13-2016 10:43 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 34815 MRLORAN_CHAINS Published / External Completed Loran chains Loaded by batch 9271, 09-13-2016 10:43 Data Table Yes MRDBS Loran chains 1 LORAN_CHAIN VARCHAR2 4 Yes Yes Active Loran chain. VARCHAR2 2 CHAIN_DESC VARCHAR2 40 Yes No Active Loran chain 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 8 SEQ NUMBER 22 No No 38 0 Active Sequence number . NUMBER 34816 MRNATIONS Published / External Completed Nations used in recording an event and for formatting addresses Loaded by batch 9271, 09-13-2016 10:43 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 34817 MROCCUPATIONS Published / External Completed Occupation used for recording contacts and events Loaded by batch 9271, 09-13-2016 10:43 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 34819 MRRECAP_REPORTED Published / External Completed How recapture was reported Loaded by batch 9271, 09-13-2016 10:43 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 34820 MRSEXCODES Published / External Completed Animal sex codes Loaded by batch 9271, 09-13-2016 10:43 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 34821 MRSHVESSELS Published / External Completed Vessels used by the shark fishery Loaded by batch 9271, 09-13-2016 10:43 Data Table Yes MRDBS Vessels used by the shark fishery 1 SHVESSELCD VARCHAR2 2 Yes Yes Active Shark vessel code. VARCHAR2 2 SHVESSEL_DESC VARCHAR2 80 Yes No Active Shark vessel description. VARCHAR2 3 SHVESSFILE VARCHAR2 10 No No Active Shark vessel file acronym. VARCHAR2 4 SKIPPER_OWNER VARCHAR2 40 No No Active Skipper or owner of vessel. VARCHAR2 5 SHVESS_COUNTY VARCHAR2 40 No No Active Shark vessel county. VARCHAR2 6 FISHERY_STRING VARCHAR2 20 No No Active Fisheries to which species is affiliated (comma separated list of fishery codes). 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 34823 MRSPECIAL_CONDITIONS Published / External Completed Special conditions reported for animal Loaded by batch 9271, 09-13-2016 10:43 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 34824 MRSPECIES Published / External Completed Species Information Loaded by batch 9271, 09-13-2016 10:43 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 34825 MRSPECIES_QUALITY Published / External Completed Quality code used for species identification Loaded by batch 9271, 09-13-2016 10:43 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 34827 MRTAGCOLORS Published / External Completed Tag colors Loaded by batch 9271, 09-13-2016 10:43 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 34828 MRTAGCONDITIONS Published / External Completed Condition of tag at release/recapture Loaded by batch 9271, 09-13-2016 10:43 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 34829 MRTAGFATES Published / External Completed Fate of tag at release/recapture Loaded by batch 9271, 09-13-2016 10:43 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 34830 MRTAGLOCONFISH Published / External Completed Location of tag on animal Loaded by batch 9271, 09-13-2016 10:43 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 34831 MRTAGREWARDS Published / External Completed Tag rewards Loaded by batch 9271, 09-13-2016 10:43 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 34832 MRTAGSITES Published / External Completed Condition of animal where tag is attached to animal Loaded by batch 9271, 09-13-2016 10:43 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 34833 MRTAGTYPES Published / External Completed Tag types Loaded by batch 9271, 09-13-2016 10:43 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 34834 MRTAGTYPE_COLORS Published / External Completed Support table used by data entry to assign color and reward based on tag type and number Loaded by batch 9271, 09-13-2016 10:43 Data Table Yes MRDBS Support table used by yellowtail data entry to assign color and reward based on tag type and number 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 TAGTYPECD VARCHAR2 2 Yes Yes Active Tag type code. VARCHAR2 3 BEGNUM NUMBER 22 Yes Yes 8 0 Active Beginning tag number for range of tags with color and reward. NUMBER 4 ENDNUM NUMBER 22 No No 8 0 Active Ending tag number for range of tags with color and reward. NUMBER 5 COLORCD VARCHAR2 2 No No Active Tag color code for range of tags. VARCHAR2 6 REWARDCD VARCHAR2 2 No No Active Tag reward code for range of tags. 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 34835 MRWEIGHTTYPES Published / External Completed Weight type codes Loaded by batch 9271, 09-13-2016 10:43 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 34836 MRWEIGHT_DETERMINATION Published / External Completed Suport table for how weight of animal was determined Loaded by batch 9271, 09-13-2016 10:43 Data Table Yes MRDBS Suport table for how weight of animal was determined 1 WGTDETCD VARCHAR2 2 Yes Yes Active Weight determination code. VARCHAR2 2 WGTDET_DESC VARCHAR2 40 Yes No Active Weight determination 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 34837 MRWEIGHT_QUALITY Published / External Completed Quality code used for weight values Loaded by batch 9271, 09-13-2016 10:43 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 1998 Person McCandless, Camilla T cami.mccandless@noaa.gov 28 Tarzwell Drive Narragansett RI 02882 USA 401-782-3272 401-782-3292 Distributor 2015-10 Person McCandless, Camilla T cami.mccandless@noaa.gov 28 Tarzwell Drive Narragansett RI 02882 USA 401-782-3272 401-782-3292 Metadata Contact 2015-10 Person McCandless, Camilla T cami.mccandless@noaa.gov 28 Tarzwell Drive Narragansett RI 02882 USA 401-782-3272 401-782-3292 Point of Contact 1998 Person McCandless, Camilla T cami.mccandless@noaa.gov 28 Tarzwell Drive Narragansett RI 02882 USA 401-782-3272 401-782-3292 Coastal and estuarine waters from Massachusetts to Florida Continuing 1998 Restricted NEFSC Data Access Procedure: 1. Formal request in writing usually to the data owner/contact; 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. NEFSC Data Access Constraint: Must get prior approval from Point of Contact for access. Mark-recapture data contains PII - must be redacted before giving access to data 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. MRDBS_DATATables.zip Compressed Zipped Folders: MRDBS_DataTables contains extracted data from three data tables: MRVEVENT MRVTAGEVENT MRMVRELRECAP03 These Data Tables contain data for three InPort Data Sets: 25121 Cooperative Shark Mark Recapture Database (MRDBS) 27490 Coastal Shark Bottom Longline Survey 27489 Cooperative Atlantic States Shark Pupping and Nursery (COASTSPAN) Contact the Data Set Point of Contact for access and details on how to identify the data from each data set (extracted data is current as of 8/8/2017) MRDBS_SupportTables.zip Compressed Zipped Folder MRDBS_Support Tables contains support table Entities for this data set Contact the Data Set Point of Contact for access and questions on content (extracted data is current as of 8/8/2017) Data validation during data collection, Data validation during data entry, Post audits Yes Unknown Yes No 2 years To Be Determined Unknown Remote storage backups field data sheets from COASTSPAN cooperators entered into database annually 34797 Entity 34798 Entity 34799 Entity 34800 Entity 34801 Entity 34802 Entity 34803 Entity 34804 Entity 34805 Entity 34806 Entity 34807 Entity 34808 Entity 34809 Entity 34810 Entity 34811 Entity 34812 Entity 34813 Entity 34814 Entity 34815 Entity 34794 Entity 34816 Entity 34817 Entity 34819 Entity 34820 Entity 34821 Entity 34823 Entity 34824 Entity 34825 Entity 34827 Entity 34828 Entity 34829 Entity 34830 Entity 34831 Entity 34832 Entity 34833 Entity 34834 Entity 34835 Entity 34836 Entity 34837 Entity 34795 Entity 34796 Entity 27490 Data Set Cross Reference Data is in MRDBS Mark Recapture Database 25121 Data Set Cross Reference Data is in MRDBS Mark Recapture Database gov.noaa.nmfs.inport:27489 Patricia Jones 2015-09-25T12:08:24 SysAdmin InPortAdmin 2022-08-09T17:10:59 2016-09-13 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 2016-09-13 1 Year 2017-09-13