Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Population and Ecosystems Monitoring and Analys... > Population Biology Branch > Apex Predators Program > Cooperative Shark Mark Recapture Database (MRDB... >

Table: MRMVRELRECAP03

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:33547  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Release and Recapture Events for Shark Fishery

Description

Release and Recapture Events for Shark Fishery

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
FISHERY
VARCHAR2 		Fishery Code, a two character fishery identification code. See support table MRFISHERY for codes and descriptions.
ANIMALID
VARCHAR2 		Animal identification code, animal id will be a concatenation of fishery, original tag type, color, number, and suffix.
REL_EVENTNUM
NUMBER 		Release event number.
REL_TAG_TYPE
VARCHAR2 		Release Style of tag, see support table MRTAGTYPES for descriptions.
REL_TAG_COLOR
VARCHAR2 		Release Color of tag, see support table MRTAGCOLORS for descriptions.
REL_TAG_NUMBER
VARCHAR2 		Release Tag identification number
REL_TAG_SUFFIX
VARCHAR2 		Release Tag suffix.
REL_TAG_REWARD
VARCHAR2 		Release Reward for tag Recapture or recapture, see support table MRTAGREWARDS for descriptions.
REL_TAG_FATE
VARCHAR2 		Release Fate of tag, see support table MRTAGFATES for descriptions.
REL_TAG_CONDITION
VARCHAR2 		Release Condition of tag, see support table MRTAGCONDITIONS for descriptions.
REL_TAG_SITE
VARCHAR2 		Release Area of tag at recapture, see support table MRTAGSITE for descriptions.
REL_TAG_LOCONFISH
VARCHAR2 		Release Location on fish where tag is attached, see support table MRTAGLOCONFISH for descriptions.
REL_TRIPID
VARCHAR2 		Release Trip identification code.
REL_HAULNUM
VARCHAR2 		Release Ordinal number of the haul within the trip, set number for shark cruises.
REL_TYPE
VARCHAR2 		Release Event type, see support table MREVENTTYPES for descriptions.
REL_MONTH
VARCHAR2 		Release Month of event.
REL_DAY
VARCHAR2 		Release Day of event.
REL_YEAR
VARCHAR2 		Release Year of event.
REL_DATEQUAL
VARCHAR2 		Release Date quality, see support table MRDATE_QUALITY for descriptions.
REL_COMMENTS
VARCHAR2 		Release Comments or remarks.
REL_SPECIES_ITIS
VARCHAR2 		Release Itis species code, see support table MRSPECIES for descriptions, corresponding survey and shark species codes also in MRSPECIES.
REL_SEX
VARCHAR2 		Release Sex ( 0 = male, 1 = female).
REL_FISHCOND
VARCHAR2 		Release Condition of fish at event, see support table MRFISH_CONDITIONS for descriptions.
REL_FISHFATE
VARCHAR2 		Release Fate of fish at event, see support table MRFISH_FATES for descriptions.
REL_LIFESTAGE
VARCHAR2 		Release Lifestage of fish at event, see support table MRLIFESTAGES for descriptions.
REL_LENGTH
NUMBER 		Release Length, for sharks: fork length in centimeters .
REL_LENUOM
VARCHAR2 		Release Unit of measure for length (CM, IN).
REL_LENQUAL
VARCHAR2 		Release Data quality code for length, see support table MRLENGTH_QUALITY for descriptions.
REL_LENTYPE
VARCHAR2 		Release Length type code, see support table MRLENGTH_TYPES for descriptions.
REL_LENDET
VARCHAR2 		Release Length determination code, see support table MRLENGTH_DETERMINATION for descriptions.
REL_RPTLENGTH
NUMBER 		Release Reported length measurement.
REL_RPTLENUOM
VARCHAR2 		Release Unit of measure for reported length (CM, IN).
REL_RPTLENQUAL
VARCHAR2 		Release Data quality code for reported length, see support table MRLENGTH_QUALITY for descriptions.
REL_RPTLENTYPE
VARCHAR2 		Release Reported length type code, see support table MRLENGTH_TYPES for descriptions.
REL_OTHLENGTH
NUMBER 		Release Other length measurement.
REL_OTHLENUOM
VARCHAR2 		Release Unit of measure for other length (CM, IN).
REL_OTHLENQUAL
VARCHAR2 		Release Data quality code for other length, see support table MRLENGTH_QUALITY for descriptions.
REL_OTHLENTYPE
VARCHAR2 		Release Other length type code, see support table MRLENGTH_TYPES for descriptions.
REL_WEIGHT
NUMBER 		Release Weight, for sharks, whole weight in kg.
REL_WGTUOM
VARCHAR2 		Release Unit of measure for weight (LB, KG).
REL_WGTQUAL
VARCHAR2 		Release Weight quality code, see support table MRWEIGHT_QUALITY for descriptions.
REL_WGTTYPE
VARCHAR2 		Release Weight type code, see support table MRWEIGHT_TYPES for descriptions.
REL_WGTDET
VARCHAR2 		Release Weight determination code, see support table MRWEIGHT_DETERMINATION for descriptions.
REL_RPTWEIGHT
NUMBER 		Release Reported weight, for sharks, whole weight in kg.
REL_RPTWGTUOM
VARCHAR2 		Release Unit of measure for reported weight (LB, KG).
REL_RPTWGTQUAL
VARCHAR2 		Release Reported weight quality code, see support table MRWEIGHT_QUALITY for descriptions.
REL_RPTWGTTYPE
VARCHAR2 		Release Reported weight type code, see support table MRWEIGHT_TYPES for descriptions.
REL_SPCOND1
VARCHAR2 		Release Special condition code, see support table MRSPECIAL_CONDITIONS for descriptions.
REL_SPCOND2
VARCHAR2 		Release Special condition code, see support table MRSPECIAL_CONDITIONS for descriptions..
REL_BIOSAMP1
VARCHAR2 		Release Biological sample code, see support table MRBIO_SAMPLES for descriptions.
REL_BIOSAMP2
VARCHAR2 		Release Biological sample code, see support table MRBIO_SAMPLES for descriptions..
REL_LOCATION
VARCHAR2 		Release Reported location, see MRLOCATIONS for descriptions. (redacted)
REL_MILES
NUMBER 		Release Miles from reported location (used for location calculation). (redacted)
REL_DIRECTION
VARCHAR2 		Release Direction from reported location (used for location calculation). (redacted)
REL_LORANCHAIN
VARCHAR2 		Release Loran chain. (redacted)
REL_LORAN1
NUMBER 		Release Loran x. (redacted)
REL_LORAN2
NUMBER 		Release Loran y. (redacted)
REL_LATDEG
VARCHAR2 		Release Event latitude degrees. (redacted)
REL_LATMIN
VARCHAR2 		Release Event latitude minutes. (redacted)
REL_LATSEC
VARCHAR2 		Release Event latitude seconds. (redacted)
REL_NOS
VARCHAR2 		Release North or south. (redacted)
REL_DECLAT
VARCHAR2 		Release latitude in decimal degrees. (redacted)
REL_LONDEG
VARCHAR2 		Release Event longitude degrees. (redacted)
REL_LONMIN
VARCHAR2 		Release Event longitude minutes. (redacted)
REL_LONSEC
VARCHAR2 		Release Event longitude seconds. (redacted)
REL_EOW
VARCHAR2 		Release East or west. (redacted)
REL_DECLON
VARCHAR2 		Release longitude in decimal degrees. (redacted)
REL_LOCQUAL
VARCHAR2 		Release Data quality code for location, see MRLOC_QUALITY for descriptions.
REL_DAYSFREE
NUMBER 		Release Days free for recapture only.
REL_DISTTRAVEL
NUMBER 		Release Distance traveled in nautical miles for recapture only, distance traveled is calculated with great circle formula.
REL_TRAVELDEG
NUMBER 		Release Travel direction for recapture only, see MRDIRECTIONS for descriptions.
REL_TRAVELDIR
VARCHAR2 		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..
REL_DEPTH
NUMBER 		Release Depth.
REL_DEPTHUOM
VARCHAR2 		Release Unit of measure used for depth (FM, FT, M).
REL_CONTACTID
NUMBER 		Release Contact id for event.
REL_INDUSTRY
VARCHAR2 		Release Industry (category, sector) at time of event, see support table MRINDUSTRY for descriptions.
REL_OCCUPATION
VARCHAR2 		Release Occupation at time of event, see support table MROCCUPATION for descriptions.
REL_GEAR
VARCHAR2 		Release Gear used, see support table MRGEARS for descriptions.
REL_SHVESSEL
VARCHAR2 		Release Vessel code used by the shark fishery, see support table MRSHVESSELS for descriptions.
REL_VESS_NATION
VARCHAR2 		Release Vessel nation at time of event, see support table MRNATIONS for descriptions.
REL_WEB_DOE
DATE 		Release Date of Last Entry from Web Application.
REL_WEB_UOE
VARCHAR2 		Release User of Last Entry from Web Application.
REL_WEB_DOC
DATE 		Release Date of Last Change from Web Application.
REL_WEB_UOC
VARCHAR2 		Release User of Last Change from Web Application.
REC_EVENTNUM
NUMBER 		Recapture event number.
REC_TAG_TYPE
VARCHAR2 		Recapture Style of tag, see support table MRTAGTYPES for descriptions.
REC_TAG_COLOR
VARCHAR2 		Recapture Color of tag, see support table MRTAGCOLORS for descriptions.
REC_TAG_NUMBER
VARCHAR2 		Recapture Tag identification number.
REC_TAG_SUFFIX
VARCHAR2 		Recapture Tag suffix.
REC_TAG_REWARD
VARCHAR2 		Recapture Reward for tag Recapture or recapture, see support table MRTAGREWARDS for descriptions.
REC_TAG_FATE
VARCHAR2 		Recapture Fate of tag, see support table MRTAGFATES for descriptions.
REC_TAG_CONDITION
VARCHAR2 		Recapture Condition of tag, see support table MRTAGCONDITIONS for descriptions.
REC_TAG_SITE
VARCHAR2 		Recapture Area of tag at recapture, see support table MRTAGSITE for descriptions.
REC_TAG_LOCONFISH
VARCHAR2 		Recapture Location on fish where tag is attached, see support table MRTAGLOCONFISH for descriptions.
REC_TRIPID
VARCHAR2 		Recapture Trip identification code.
REC_HAULNUM
VARCHAR2 		Recapture Ordinal number of the haul within the trip, set number for shark cruises.
REC_TYPE
VARCHAR2 		Recapture Event type, see support table MREVENTTYPES for descriptions.
REC_MONTH
VARCHAR2 		Recapture Month of event.
REC_DAY
VARCHAR2 		Recapture Day of event.
REC_YEAR
VARCHAR2 		Recapture Year of event.
REC_DATEQUAL
VARCHAR2 		Recapture Date quality, see support table MRDATE_QUALITY for descriptions.
REC_COMMENTS
VARCHAR2 		Recapture Comments or remarks.
REC_SPECIES_ITIS
VARCHAR2 		Recapture Itis species code, see support table MRSPECIES for descriptions, corresponding survey and shark species codes also in MRSPECIES.
REC_SEX
VARCHAR2 		Recapture Sex ( 0 = male, 1 = female).
REC_FISHCOND
VARCHAR2 		Recapture Condition of fish at event, see support table MRFISH_CONDITIONS for descriptions.
REC_FISHFATE
VARCHAR2 		Recapture Fate of fish at event, see support table MRFISH_FATES for descriptions.
REC_LIFESTAGE
VARCHAR2 		Recapture Lifestage of fish at event, see support table MRLIFESTAGES for descriptions.
REC_LENGTH
NUMBER 		Recapture Length, for sharks: fork length in centimeters .
REC_LENUOM
VARCHAR2 		Recapture Unit of measure for length (CM, IN).
REC_LENQUAL
VARCHAR2 		Recapture Data quality code for length, see support table MRLENGTH_QUALITY for descriptions.
REC_LENTYPE
VARCHAR2 		Recapture Length type code, see support table MRLENGTH_TYPES for descriptions.
REC_LENDET
VARCHAR2 		Recapture Length determination code, see support table MRLENGTH_DETERMINATION for descriptions.
REC_RPTLENGTH
NUMBER 		Recapture Reported length measurement.
REC_RPTLENUOM
VARCHAR2 		Recapture Unit of measure for reported length (CM, IN).
REC_RPTLENQUAL
VARCHAR2 		Recapture Data quality code for reported length, see support table MRLENGTH_QUALITY for descriptions.
REC_RPTLENTYPE
VARCHAR2 		Recapture Reported length type code, see support table MRLENGTH_TYPES for descriptions.
REC_OTHLENGTH
NUMBER 		Recapture Other length measurement.
REC_OTHLENUOM
VARCHAR2 		Recapture Unit of measure for other length (CM, IN).
REC_OTHLENQUAL
VARCHAR2 		Recapture Data quality code for other length, see support table MRLENGTH_QUALITY for descriptions.
REC_OTHLENTYPE
VARCHAR2 		Recapture Other length type code, see support table MRLENGTH_TYPES for descriptions.
REC_WEIGHT
NUMBER 		Recapture Weight, for sharks, whole weight in kg.
REC_WGTUOM
VARCHAR2 		Recapture Unit of measure for weight (LB, KG).
REC_WGTQUAL
VARCHAR2 		Recapture Weight quality code, see support table MRWEIGHT_QUALITY for descriptions.
REC_WGTTYPE
VARCHAR2 		Recapture Weight type code, see support table MRWEIGHT_TYPES for descriptions.
REC_WGTDET
VARCHAR2 		Recapture Weight determination code, see support table MRWEIGHT_DETERMINATION for descriptions.
REC_RPTWEIGHT
NUMBER 		Recapture Reported weight, for sharks, whole weight in kg.
REC_RPTWGTUOM
VARCHAR2 		Recapture Unit of measure for reported weight (LB, KG).
REC_RPTWGTQUAL
VARCHAR2 		Recapture Reported weight quality code, see support table MRWEIGHT_QUALITY for descriptions.
REC_RPTWGTTYPE
VARCHAR2 		Recapture Reported weight type code, see support table MRWEIGHT_TYPES for descriptions.
REC_SPCOND1
VARCHAR2 		Recapture Special condition code, see support table MRSPECIAL_CONDITIONS for descriptions.
REC_SPCOND2
VARCHAR2 		Recapture Special condition code, see support table MRSPECIAL_CONDITIONS for descriptions..
REC_BIOSAMP1
VARCHAR2 		Recapture Biological sample code, see support table MRBIO_SAMPLES for descriptions.
REC_BIOSAMP2
VARCHAR2 		Recapture Biological sample code, see support table MRBIO_SAMPLES for descriptions..
REC_LOCATION
VARCHAR2 		Recapture Reported location, see MRLOCATIONS for descriptions. (redacted)
REC_MILES
NUMBER 		Recapture Miles from reported location (used for location calculation). (redacted)
REC_DIRECTION
VARCHAR2 		Recapture Direction from reported location (used for location calculation). (redacted)
REC_LORANCHAIN
VARCHAR2 		Recapture Loran chain. (redacted)
REC_LORAN1
NUMBER 		Recapture Loran x. (redacted)
REC_LORAN2
NUMBER 		Recapture Loran y. (redacted)
REC_LATDEG
VARCHAR2 		Recapture Event latitude degrees. (redacted)
REC_LATMIN
VARCHAR2 		Recapture Event latitude minutes. (redacted)
REC_LATSEC
VARCHAR2 		Recapture Event latitude seconds. (redacted)
REC_NOS
VARCHAR2 		Recapture North or south. (redacted)
REC_DECLAT
VARCHAR2 		Recapture Latitude in decimal degrees. (redacted)
REC_LONDEG
VARCHAR2 		Recapture Event longitude degrees. (redacted)
REC_LONMIN
VARCHAR2 		Recapture Event longitude minutes. (redacted)
REC_LONSEC
VARCHAR2 		Recapture Event longitude seconds. (redacted)
REC_EOW
VARCHAR2 		Recapture East or west. (redacted)
REC_DECLON
VARCHAR2 		Recapture Longitude in decimal degrees. (redacted)
REC_LOCQUAL
VARCHAR2 		Recapture Data quality code for location, see MRLOC_QUALITY for descriptions.
REC_DAYSFREE
NUMBER 		Recapture Days free for recapture only.
REC_DISTTRAVEL
NUMBER 		Recapture Distance traveled in nautical miles for recapture only, distance traveled is calculated with great circle formula.
REC_TRAVELDEG
NUMBER 		Recapture Travel direction for recapture only, see MRDIRECTIONS for descriptions.
REC_TRAVELDIR
VARCHAR2 		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..
REC_DEPTH
NUMBER 		Recapture Depth.
REC_DEPTHUOM
VARCHAR2 		Recapture Unit of measure used for depth (FM, FT, M).
REC_CONTACTID
NUMBER 		Recapture Contact id for event.
REC_INDUSTRY
VARCHAR2 		Recapture Industry (category, sector) at time of event, see support table MRINDUSTRY for descriptions.
REC_OCCUPATION
VARCHAR2 		Recapture Occupation at time of event, see support table MROCCUPATION for descriptions.
REC_GEAR
VARCHAR2 		Recapture Gear used, see support table MRGEARS for descriptions.
REC_SHVESSEL
VARCHAR2 		Recapture Vessel code used by the shark fishery, see support table MRSHVESSELS for descriptions.
REC_VESS_NATION
VARCHAR2 		Recapture Vessel nation at time of event, see support table MRNATIONS for descriptions.
REC_WEB_DOE
DATE 		Recapture Date of Last Entry from Web Application.
REC_WEB_UOE
VARCHAR2 		Recapture User of Last Entry from Web Application.
REC_WEB_DOC
DATE 		Recapture Date of Last Change from Web Application.
REC_WEB_UOC
VARCHAR2 		Recapture User of Last Change from Web Application.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (NEFSC) for inquiries on this record.

Item Identification

Title: Table: MRMVRELRECAP03
Short Name: MRMVRELRECAP03
Status: Completed
Abstract:

Release and Recapture Events for Shark Fishery
Notes:

Loaded by batch 9052, 07-27-2016 15:26

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: MRDBS
Description:

Release and Recapture Events for Shark Fishery

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 FISHERY VARCHAR2 Fishery Code, a two character fishery identification code. See support table MRFISHERY for codes and descriptions.
100
 ANIMALID VARCHAR2 Animal identification code, animal id will be a concatenation of fishery, original tag type, color, number, and suffix.
100
 REL_EVENTNUM NUMBER Release event number.
100
 REL_TAG_TYPE VARCHAR2 Release Style of tag, see support table MRTAGTYPES for descriptions.
100
 REL_TAG_COLOR VARCHAR2 Release Color of tag, see support table MRTAGCOLORS for descriptions.
100
 REL_TAG_NUMBER VARCHAR2 Release Tag identification number
100
 REL_TAG_SUFFIX VARCHAR2 Release Tag suffix.
100
 REL_TAG_REWARD VARCHAR2 Release Reward for tag Recapture or recapture, see support table MRTAGREWARDS for descriptions.
100
 REL_TAG_FATE VARCHAR2 Release Fate of tag, see support table MRTAGFATES for descriptions.
100
 REL_TAG_CONDITION VARCHAR2 Release Condition of tag, see support table MRTAGCONDITIONS for descriptions.
100
 REL_TAG_SITE VARCHAR2 Release Area of tag at recapture, see support table MRTAGSITE for descriptions.
100
 REL_TAG_LOCONFISH VARCHAR2 Release Location on fish where tag is attached, see support table MRTAGLOCONFISH for descriptions.
100
 REL_TRIPID VARCHAR2 Release Trip identification code.
100
 REL_HAULNUM VARCHAR2 Release Ordinal number of the haul within the trip, set number for shark cruises.
100
 REL_TYPE VARCHAR2 Release Event type, see support table MREVENTTYPES for descriptions.
100
 REL_MONTH VARCHAR2 Release Month of event.
100
 REL_DAY VARCHAR2 Release Day of event.
100
 REL_YEAR VARCHAR2 Release Year of event.
100
 REL_DATEQUAL VARCHAR2 Release Date quality, see support table MRDATE_QUALITY for descriptions.
100
 REL_COMMENTS VARCHAR2 Release Comments or remarks.
100
 REL_SPECIES_ITIS VARCHAR2 Release Itis species code, see support table MRSPECIES for descriptions, corresponding survey and shark species codes also in MRSPECIES.
100
 REL_SEX VARCHAR2 Release Sex ( 0 = male, 1 = female).
100
 REL_FISHCOND VARCHAR2 Release Condition of fish at event, see support table MRFISH_CONDITIONS for descriptions.
100
 REL_FISHFATE VARCHAR2 Release Fate of fish at event, see support table MRFISH_FATES for descriptions.
100
 REL_LIFESTAGE VARCHAR2 Release Lifestage of fish at event, see support table MRLIFESTAGES for descriptions.
100
 REL_LENGTH NUMBER Release Length, for sharks: fork length in centimeters .
100
 REL_LENUOM VARCHAR2 Release Unit of measure for length (CM, IN).
100
 REL_LENQUAL VARCHAR2 Release Data quality code for length, see support table MRLENGTH_QUALITY for descriptions.
100
 REL_LENTYPE VARCHAR2 Release Length type code, see support table MRLENGTH_TYPES for descriptions.
100
 REL_LENDET VARCHAR2 Release Length determination code, see support table MRLENGTH_DETERMINATION for descriptions.
100
 REL_RPTLENGTH NUMBER Release Reported length measurement.
100
 REL_RPTLENUOM VARCHAR2 Release Unit of measure for reported length (CM, IN).
100
 REL_RPTLENQUAL VARCHAR2 Release Data quality code for reported length, see support table MRLENGTH_QUALITY for descriptions.
100
 REL_RPTLENTYPE VARCHAR2 Release Reported length type code, see support table MRLENGTH_TYPES for descriptions.
100
 REL_OTHLENGTH NUMBER Release Other length measurement.
100
 REL_OTHLENUOM VARCHAR2 Release Unit of measure for other length (CM, IN).
100
 REL_OTHLENQUAL VARCHAR2 Release Data quality code for other length, see support table MRLENGTH_QUALITY for descriptions.
100
 REL_OTHLENTYPE VARCHAR2 Release Other length type code, see support table MRLENGTH_TYPES for descriptions.
100
 REL_WEIGHT NUMBER Release Weight, for sharks, whole weight in kg.
100
 REL_WGTUOM VARCHAR2 Release Unit of measure for weight (LB, KG).
100
 REL_WGTQUAL VARCHAR2 Release Weight quality code, see support table MRWEIGHT_QUALITY for descriptions.
100
 REL_WGTTYPE VARCHAR2 Release Weight type code, see support table MRWEIGHT_TYPES for descriptions.
100
 REL_WGTDET VARCHAR2 Release Weight determination code, see support table MRWEIGHT_DETERMINATION for descriptions.
100
 REL_RPTWEIGHT NUMBER Release Reported weight, for sharks, whole weight in kg.
100
 REL_RPTWGTUOM VARCHAR2 Release Unit of measure for reported weight (LB, KG).
100
 REL_RPTWGTQUAL VARCHAR2 Release Reported weight quality code, see support table MRWEIGHT_QUALITY for descriptions.
100
 REL_RPTWGTTYPE VARCHAR2 Release Reported weight type code, see support table MRWEIGHT_TYPES for descriptions.
100
 REL_SPCOND1 VARCHAR2 Release Special condition code, see support table MRSPECIAL_CONDITIONS for descriptions.
100
 REL_SPCOND2 VARCHAR2 Release Special condition code, see support table MRSPECIAL_CONDITIONS for descriptions..
100
 REL_BIOSAMP1 VARCHAR2 Release Biological sample code, see support table MRBIO_SAMPLES for descriptions.
100
 REL_BIOSAMP2 VARCHAR2 Release Biological sample code, see support table MRBIO_SAMPLES for descriptions..
100
 REL_LOCATION VARCHAR2 Release Reported location, see MRLOCATIONS for descriptions. (redacted)
100
 REL_MILES NUMBER Release Miles from reported location (used for location calculation). (redacted)
100
 REL_DIRECTION VARCHAR2 Release Direction from reported location (used for location calculation). (redacted)
100
 REL_LORANCHAIN VARCHAR2 Release Loran chain. (redacted)
100
 REL_LORAN1 NUMBER Release Loran x. (redacted)
100
 REL_LORAN2 NUMBER Release Loran y. (redacted)
100
 REL_LATDEG VARCHAR2 Release Event latitude degrees. (redacted)
100
 REL_LATMIN VARCHAR2 Release Event latitude minutes. (redacted)
100
 REL_LATSEC VARCHAR2 Release Event latitude seconds. (redacted)
100
 REL_NOS VARCHAR2 Release North or south. (redacted)
100
 REL_DECLAT VARCHAR2 Release latitude in decimal degrees. (redacted)
100
 REL_LONDEG VARCHAR2 Release Event longitude degrees. (redacted)
100
 REL_LONMIN VARCHAR2 Release Event longitude minutes. (redacted)
100
 REL_LONSEC VARCHAR2 Release Event longitude seconds. (redacted)
100
 REL_EOW VARCHAR2 Release East or west. (redacted)
100
 REL_DECLON VARCHAR2 Release longitude in decimal degrees. (redacted)
100
 REL_LOCQUAL VARCHAR2 Release Data quality code for location, see MRLOC_QUALITY for descriptions.
100
 REL_DAYSFREE NUMBER Release Days free for recapture only.
100
 REL_DISTTRAVEL NUMBER Release Distance traveled in nautical miles for recapture only, distance traveled is calculated with great circle formula.
100
 REL_TRAVELDEG NUMBER Release Travel direction for recapture only, see MRDIRECTIONS for descriptions.
100
 REL_TRAVELDIR VARCHAR2 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..
100
 REL_DEPTH NUMBER Release Depth.
100
 REL_DEPTHUOM VARCHAR2 Release Unit of measure used for depth (FM, FT, M).
100
 REL_CONTACTID NUMBER Release Contact id for event.
100
 REL_INDUSTRY VARCHAR2 Release Industry (category, sector) at time of event, see support table MRINDUSTRY for descriptions.
100
 REL_OCCUPATION VARCHAR2 Release Occupation at time of event, see support table MROCCUPATION for descriptions.
100
 REL_GEAR VARCHAR2 Release Gear used, see support table MRGEARS for descriptions.
100
 REL_SHVESSEL VARCHAR2 Release Vessel code used by the shark fishery, see support table MRSHVESSELS for descriptions.
100
 REL_VESS_NATION VARCHAR2 Release Vessel nation at time of event, see support table MRNATIONS for descriptions.
100
 REL_WEB_DOE DATE Release Date of Last Entry from Web Application.
100
 REL_WEB_UOE VARCHAR2 Release User of Last Entry from Web Application.
100
 REL_WEB_DOC DATE Release Date of Last Change from Web Application.
100
 REL_WEB_UOC VARCHAR2 Release User of Last Change from Web Application.
100
 REC_EVENTNUM NUMBER Recapture event number.
100
 REC_TAG_TYPE VARCHAR2 Recapture Style of tag, see support table MRTAGTYPES for descriptions.
100
 REC_TAG_COLOR VARCHAR2 Recapture Color of tag, see support table MRTAGCOLORS for descriptions.
100
 REC_TAG_NUMBER VARCHAR2 Recapture Tag identification number.
100
 REC_TAG_SUFFIX VARCHAR2 Recapture Tag suffix.
100
 REC_TAG_REWARD VARCHAR2 Recapture Reward for tag Recapture or recapture, see support table MRTAGREWARDS for descriptions.
100
 REC_TAG_FATE VARCHAR2 Recapture Fate of tag, see support table MRTAGFATES for descriptions.
100
 REC_TAG_CONDITION VARCHAR2 Recapture Condition of tag, see support table MRTAGCONDITIONS for descriptions.
100
 REC_TAG_SITE VARCHAR2 Recapture Area of tag at recapture, see support table MRTAGSITE for descriptions.
100
 REC_TAG_LOCONFISH VARCHAR2 Recapture Location on fish where tag is attached, see support table MRTAGLOCONFISH for descriptions.
100
 REC_TRIPID VARCHAR2 Recapture Trip identification code.
100
 REC_HAULNUM VARCHAR2 Recapture Ordinal number of the haul within the trip, set number for shark cruises.
100
 REC_TYPE VARCHAR2 Recapture Event type, see support table MREVENTTYPES for descriptions.
100
 REC_MONTH VARCHAR2 Recapture Month of event.
100
 REC_DAY VARCHAR2 Recapture Day of event.
100
 REC_YEAR VARCHAR2 Recapture Year of event.
100
 REC_DATEQUAL VARCHAR2 Recapture Date quality, see support table MRDATE_QUALITY for descriptions.
100
 REC_COMMENTS VARCHAR2 Recapture Comments or remarks.
100
 REC_SPECIES_ITIS VARCHAR2 Recapture Itis species code, see support table MRSPECIES for descriptions, corresponding survey and shark species codes also in MRSPECIES.
100
 REC_SEX VARCHAR2 Recapture Sex ( 0 = male, 1 = female).
100
 REC_FISHCOND VARCHAR2 Recapture Condition of fish at event, see support table MRFISH_CONDITIONS for descriptions.
100
 REC_FISHFATE VARCHAR2 Recapture Fate of fish at event, see support table MRFISH_FATES for descriptions.
100
 REC_LIFESTAGE VARCHAR2 Recapture Lifestage of fish at event, see support table MRLIFESTAGES for descriptions.
100
 REC_LENGTH NUMBER Recapture Length, for sharks: fork length in centimeters .
100
 REC_LENUOM VARCHAR2 Recapture Unit of measure for length (CM, IN).
100
 REC_LENQUAL VARCHAR2 Recapture Data quality code for length, see support table MRLENGTH_QUALITY for descriptions.
100
 REC_LENTYPE VARCHAR2 Recapture Length type code, see support table MRLENGTH_TYPES for descriptions.
100
 REC_LENDET VARCHAR2 Recapture Length determination code, see support table MRLENGTH_DETERMINATION for descriptions.
100
 REC_RPTLENGTH NUMBER Recapture Reported length measurement.
100
 REC_RPTLENUOM VARCHAR2 Recapture Unit of measure for reported length (CM, IN).
100
 REC_RPTLENQUAL VARCHAR2 Recapture Data quality code for reported length, see support table MRLENGTH_QUALITY for descriptions.
100
 REC_RPTLENTYPE VARCHAR2 Recapture Reported length type code, see support table MRLENGTH_TYPES for descriptions.
100
 REC_OTHLENGTH NUMBER Recapture Other length measurement.
100
 REC_OTHLENUOM VARCHAR2 Recapture Unit of measure for other length (CM, IN).
100
 REC_OTHLENQUAL VARCHAR2 Recapture Data quality code for other length, see support table MRLENGTH_QUALITY for descriptions.
100
 REC_OTHLENTYPE VARCHAR2 Recapture Other length type code, see support table MRLENGTH_TYPES for descriptions.
100
 REC_WEIGHT NUMBER Recapture Weight, for sharks, whole weight in kg.
100
 REC_WGTUOM VARCHAR2 Recapture Unit of measure for weight (LB, KG).
100
 REC_WGTQUAL VARCHAR2 Recapture Weight quality code, see support table MRWEIGHT_QUALITY for descriptions.
100
 REC_WGTTYPE VARCHAR2 Recapture Weight type code, see support table MRWEIGHT_TYPES for descriptions.
100
 REC_WGTDET VARCHAR2 Recapture Weight determination code, see support table MRWEIGHT_DETERMINATION for descriptions.
100
 REC_RPTWEIGHT NUMBER Recapture Reported weight, for sharks, whole weight in kg.
100
 REC_RPTWGTUOM VARCHAR2 Recapture Unit of measure for reported weight (LB, KG).
100
 REC_RPTWGTQUAL VARCHAR2 Recapture Reported weight quality code, see support table MRWEIGHT_QUALITY for descriptions.
100
 REC_RPTWGTTYPE VARCHAR2 Recapture Reported weight type code, see support table MRWEIGHT_TYPES for descriptions.
100
 REC_SPCOND1 VARCHAR2 Recapture Special condition code, see support table MRSPECIAL_CONDITIONS for descriptions.
100
 REC_SPCOND2 VARCHAR2 Recapture Special condition code, see support table MRSPECIAL_CONDITIONS for descriptions..
100
 REC_BIOSAMP1 VARCHAR2 Recapture Biological sample code, see support table MRBIO_SAMPLES for descriptions.
100
 REC_BIOSAMP2 VARCHAR2 Recapture Biological sample code, see support table MRBIO_SAMPLES for descriptions..
100
 REC_LOCATION VARCHAR2 Recapture Reported location, see MRLOCATIONS for descriptions. (redacted)
100
 REC_MILES NUMBER Recapture Miles from reported location (used for location calculation). (redacted)
100
 REC_DIRECTION VARCHAR2 Recapture Direction from reported location (used for location calculation). (redacted)
100
 REC_LORANCHAIN VARCHAR2 Recapture Loran chain. (redacted)
100
 REC_LORAN1 NUMBER Recapture Loran x. (redacted)
100
 REC_LORAN2 NUMBER Recapture Loran y. (redacted)
100
 REC_LATDEG VARCHAR2 Recapture Event latitude degrees. (redacted)
100
 REC_LATMIN VARCHAR2 Recapture Event latitude minutes. (redacted)
100
 REC_LATSEC VARCHAR2 Recapture Event latitude seconds. (redacted)
100
 REC_NOS VARCHAR2 Recapture North or south. (redacted)
100
 REC_DECLAT VARCHAR2 Recapture Latitude in decimal degrees. (redacted)
100
 REC_LONDEG VARCHAR2 Recapture Event longitude degrees. (redacted)
100
 REC_LONMIN VARCHAR2 Recapture Event longitude minutes. (redacted)
100
 REC_LONSEC VARCHAR2 Recapture Event longitude seconds. (redacted)
100
 REC_EOW VARCHAR2 Recapture East or west. (redacted)
100
 REC_DECLON VARCHAR2 Recapture Longitude in decimal degrees. (redacted)
100
 REC_LOCQUAL VARCHAR2 Recapture Data quality code for location, see MRLOC_QUALITY for descriptions.
100
 REC_DAYSFREE NUMBER Recapture Days free for recapture only.
100
 REC_DISTTRAVEL NUMBER Recapture Distance traveled in nautical miles for recapture only, distance traveled is calculated with great circle formula.
100
 REC_TRAVELDEG NUMBER Recapture Travel direction for recapture only, see MRDIRECTIONS for descriptions.
100
 REC_TRAVELDIR VARCHAR2 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..
100
 REC_DEPTH NUMBER Recapture Depth.
100
 REC_DEPTHUOM VARCHAR2 Recapture Unit of measure used for depth (FM, FT, M).
100
 REC_CONTACTID NUMBER Recapture Contact id for event.
100
 REC_INDUSTRY VARCHAR2 Recapture Industry (category, sector) at time of event, see support table MRINDUSTRY for descriptions.
100
 REC_OCCUPATION VARCHAR2 Recapture Occupation at time of event, see support table MROCCUPATION for descriptions.
100
 REC_GEAR VARCHAR2 Recapture Gear used, see support table MRGEARS for descriptions.
100
 REC_SHVESSEL VARCHAR2 Recapture Vessel code used by the shark fishery, see support table MRSHVESSELS for descriptions.
100
 REC_VESS_NATION VARCHAR2 Recapture Vessel nation at time of event, see support table MRNATIONS for descriptions.
100
 REC_WEB_DOE DATE Recapture Date of Last Entry from Web Application.
100
 REC_WEB_UOE VARCHAR2 Recapture User of Last Entry from Web Application.
100
 REC_WEB_DOC DATE Recapture Date of Last Change from Web Application.
100
 REC_WEB_UOC VARCHAR2 Recapture User of Last Change from Web Application.

Attribute Details

FISHERY

CC ID: 333445
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 2
Required: Yes
Primary Key: No
Status: Active
Description:

Fishery Code, a two character fishery identification code. See support table MRFISHERY for codes and descriptions.
General Data Type: VARCHAR2

ANIMALID

CC ID: 333523
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 14
Required: Yes
Primary Key: No
Status: Active
Description:

Animal identification code, animal id will be a concatenation of fishery, original tag type, color, number, and suffix.
General Data Type: VARCHAR2

REL_EVENTNUM

CC ID: 333534
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Release event number.
General Data Type: NUMBER

REL_TAG_TYPE

CC ID: 333545
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 2
Required: Yes
Primary Key: No
Status: Active
Description:

Release Style of tag, see support table MRTAGTYPES for descriptions.
General Data Type: VARCHAR2

REL_TAG_COLOR

CC ID: 333556
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 2
Required: Yes
Primary Key: No
Status: Active
Description:

Release Color of tag, see support table MRTAGCOLORS for descriptions.
General Data Type: VARCHAR2

REL_TAG_NUMBER

CC ID: 333567
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 6
Required: Yes
Primary Key: No
Status: Active
Description:

Release Tag identification number
General Data Type: VARCHAR2

REL_TAG_SUFFIX

CC ID: 333578
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Release Tag suffix.
General Data Type: VARCHAR2

REL_TAG_REWARD

CC ID: 333589
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Reward for tag Recapture or recapture, see support table MRTAGREWARDS for descriptions.
General Data Type: VARCHAR2

REL_TAG_FATE

CC ID: 333600
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Fate of tag, see support table MRTAGFATES for descriptions.
General Data Type: VARCHAR2

REL_TAG_CONDITION

CC ID: 333446
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Condition of tag, see support table MRTAGCONDITIONS for descriptions.
General Data Type: VARCHAR2

REL_TAG_SITE

CC ID: 333457
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Area of tag at recapture, see support table MRTAGSITE for descriptions.
General Data Type: VARCHAR2

REL_TAG_LOCONFISH

CC ID: 333468
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Location on fish where tag is attached, see support table MRTAGLOCONFISH for descriptions.
General Data Type: VARCHAR2

REL_TRIPID

CC ID: 333479
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Release Trip identification code.
General Data Type: VARCHAR2

REL_HAULNUM

CC ID: 333490
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Release Ordinal number of the haul within the trip, set number for shark cruises.
General Data Type: VARCHAR2

REL_TYPE

CC ID: 333501
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Event type, see support table MREVENTTYPES for descriptions.
General Data Type: VARCHAR2

REL_MONTH

CC ID: 333512
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Month of event.
General Data Type: VARCHAR2

REL_DAY

CC ID: 333520
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Day of event.
General Data Type: VARCHAR2

REL_YEAR

CC ID: 333521
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Release Year of event.
General Data Type: VARCHAR2

REL_DATEQUAL

CC ID: 333522
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Date quality, see support table MRDATE_QUALITY for descriptions.
General Data Type: VARCHAR2

REL_COMMENTS

CC ID: 333524
Seq. Order: 20
Data Storage Type: VARCHAR2
Max Length: 200
Required: No
Primary Key: No
Status: Active
Description:

Release Comments or remarks.
General Data Type: VARCHAR2

REL_SPECIES_ITIS

CC ID: 333525
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 11
Required: No
Primary Key: No
Status: Active
Description:

Release Itis species code, see support table MRSPECIES for descriptions, corresponding survey and shark species codes also in MRSPECIES.
General Data Type: VARCHAR2

REL_SEX

CC ID: 333526
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Release Sex ( 0 = male, 1 = female).
General Data Type: VARCHAR2

REL_FISHCOND

CC ID: 333527
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Condition of fish at event, see support table MRFISH_CONDITIONS for descriptions.
General Data Type: VARCHAR2

REL_FISHFATE

CC ID: 333528
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Fate of fish at event, see support table MRFISH_FATES for descriptions.
General Data Type: VARCHAR2

REL_LIFESTAGE

CC ID: 333529
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Lifestage of fish at event, see support table MRLIFESTAGES for descriptions.
General Data Type: VARCHAR2

REL_LENGTH

CC ID: 333530
Seq. Order: 26
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

Release Length, for sharks: fork length in centimeters .
General Data Type: NUMBER

REL_LENUOM

CC ID: 333531
Seq. Order: 27
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Release Unit of measure for length (CM, IN).
General Data Type: VARCHAR2

REL_LENQUAL

CC ID: 333532
Seq. Order: 28
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Data quality code for length, see support table MRLENGTH_QUALITY for descriptions.
General Data Type: VARCHAR2

REL_LENTYPE

CC ID: 333533
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Length type code, see support table MRLENGTH_TYPES for descriptions.
General Data Type: VARCHAR2

REL_LENDET

CC ID: 333535
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Length determination code, see support table MRLENGTH_DETERMINATION for descriptions.
General Data Type: VARCHAR2

REL_RPTLENGTH

CC ID: 333536
Seq. Order: 31
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

Release Reported length measurement.
General Data Type: NUMBER

REL_RPTLENUOM

CC ID: 333537
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Release Unit of measure for reported length (CM, IN).
General Data Type: VARCHAR2

REL_RPTLENQUAL

CC ID: 333538
Seq. Order: 33
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Data quality code for reported length, see support table MRLENGTH_QUALITY for descriptions.
General Data Type: VARCHAR2

REL_RPTLENTYPE

CC ID: 333539
Seq. Order: 34
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Reported length type code, see support table MRLENGTH_TYPES for descriptions.
General Data Type: VARCHAR2

REL_OTHLENGTH

CC ID: 333540
Seq. Order: 35
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

Release Other length measurement.
General Data Type: NUMBER

REL_OTHLENUOM

CC ID: 333541
Seq. Order: 36
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Release Unit of measure for other length (CM, IN).
General Data Type: VARCHAR2

REL_OTHLENQUAL

CC ID: 333542
Seq. Order: 37
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Data quality code for other length, see support table MRLENGTH_QUALITY for descriptions.
General Data Type: VARCHAR2

REL_OTHLENTYPE

CC ID: 333543
Seq. Order: 38
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Other length type code, see support table MRLENGTH_TYPES for descriptions.
General Data Type: VARCHAR2

REL_WEIGHT

CC ID: 333544
Seq. Order: 39
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

Release Weight, for sharks, whole weight in kg.
General Data Type: NUMBER

REL_WGTUOM

CC ID: 333546
Seq. Order: 40
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Release Unit of measure for weight (LB, KG).
General Data Type: VARCHAR2

REL_WGTQUAL

CC ID: 333547
Seq. Order: 41
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Weight quality code, see support table MRWEIGHT_QUALITY for descriptions.
General Data Type: VARCHAR2

REL_WGTTYPE

CC ID: 333548
Seq. Order: 42
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Weight type code, see support table MRWEIGHT_TYPES for descriptions.
General Data Type: VARCHAR2

REL_WGTDET

CC ID: 333549
Seq. Order: 43
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Weight determination code, see support table MRWEIGHT_DETERMINATION for descriptions.
General Data Type: VARCHAR2

REL_RPTWEIGHT

CC ID: 333550
Seq. Order: 44
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

Release Reported weight, for sharks, whole weight in kg.
General Data Type: NUMBER

REL_RPTWGTUOM

CC ID: 333551
Seq. Order: 45
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Release Unit of measure for reported weight (LB, KG).
General Data Type: VARCHAR2

REL_RPTWGTQUAL

CC ID: 333552
Seq. Order: 46
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Reported weight quality code, see support table MRWEIGHT_QUALITY for descriptions.
General Data Type: VARCHAR2

REL_RPTWGTTYPE

CC ID: 333553
Seq. Order: 47
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Reported weight type code, see support table MRWEIGHT_TYPES for descriptions.
General Data Type: VARCHAR2

REL_SPCOND1

CC ID: 333554
Seq. Order: 48
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Special condition code, see support table MRSPECIAL_CONDITIONS for descriptions.
General Data Type: VARCHAR2

REL_SPCOND2

CC ID: 333555
Seq. Order: 49
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Special condition code, see support table MRSPECIAL_CONDITIONS for descriptions..
General Data Type: VARCHAR2

REL_BIOSAMP1

CC ID: 333557
Seq. Order: 50
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Biological sample code, see support table MRBIO_SAMPLES for descriptions.
General Data Type: VARCHAR2

REL_BIOSAMP2

CC ID: 333558
Seq. Order: 51
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Biological sample code, see support table MRBIO_SAMPLES for descriptions..
General Data Type: VARCHAR2

REL_LOCATION

CC ID: 333559
Seq. Order: 52
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Release Reported location, see MRLOCATIONS for descriptions. (redacted)
General Data Type: VARCHAR2

REL_MILES

CC ID: 333560
Seq. Order: 53
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Release Miles from reported location (used for location calculation). (redacted)
General Data Type: NUMBER

REL_DIRECTION

CC ID: 333561
Seq. Order: 54
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Release Direction from reported location (used for location calculation). (redacted)
General Data Type: VARCHAR2

REL_LORANCHAIN

CC ID: 333562
Seq. Order: 55
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Release Loran chain. (redacted)
General Data Type: VARCHAR2

REL_LORAN1

CC ID: 333563
Seq. Order: 56
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 8
Scale: 2
Status: Active
Description:

Release Loran x. (redacted)
General Data Type: NUMBER

REL_LORAN2

CC ID: 333564
Seq. Order: 57
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 8
Scale: 2
Status: Active
Description:

Release Loran y. (redacted)
General Data Type: NUMBER

REL_LATDEG

CC ID: 333565
Seq. Order: 58
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Event latitude degrees. (redacted)
General Data Type: VARCHAR2

REL_LATMIN

CC ID: 333566
Seq. Order: 59
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Event latitude minutes. (redacted)
General Data Type: VARCHAR2

REL_LATSEC

CC ID: 333568
Seq. Order: 60
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Event latitude seconds. (redacted)
General Data Type: VARCHAR2

REL_NOS

CC ID: 333569
Seq. Order: 61
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Release North or south. (redacted)
General Data Type: VARCHAR2

REL_DECLAT

CC ID: 333570
Seq. Order: 62
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Release latitude in decimal degrees. (redacted)
General Data Type: VARCHAR2

REL_LONDEG

CC ID: 333571
Seq. Order: 63
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Release Event longitude degrees. (redacted)
General Data Type: VARCHAR2

REL_LONMIN

CC ID: 333572
Seq. Order: 64
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Event longitude minutes. (redacted)
General Data Type: VARCHAR2

REL_LONSEC

CC ID: 333573
Seq. Order: 65
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Event longitude seconds. (redacted)
General Data Type: VARCHAR2

REL_EOW

CC ID: 333574
Seq. Order: 66
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Release East or west. (redacted)
General Data Type: VARCHAR2

REL_DECLON

CC ID: 333575
Seq. Order: 67
Data Storage Type: VARCHAR2
Max Length: 11
Required: No
Primary Key: No
Status: Active
Description:

Release longitude in decimal degrees. (redacted)
General Data Type: VARCHAR2

REL_LOCQUAL

CC ID: 333576
Seq. Order: 68
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Data quality code for location, see MRLOC_QUALITY for descriptions.
General Data Type: VARCHAR2

REL_DAYSFREE

CC ID: 333577
Seq. Order: 69
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Release Days free for recapture only.
General Data Type: NUMBER

REL_DISTTRAVEL

CC ID: 333579
Seq. Order: 70
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Release Distance traveled in nautical miles for recapture only, distance traveled is calculated with great circle formula.
General Data Type: NUMBER

REL_TRAVELDEG

CC ID: 333580
Seq. Order: 71
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 1
Status: Active
Description:

Release Travel direction for recapture only, see MRDIRECTIONS for descriptions.
General Data Type: NUMBER

REL_TRAVELDIR

CC ID: 333581
Seq. Order: 72
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

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..
General Data Type: VARCHAR2

REL_DEPTH

CC ID: 333582
Seq. Order: 73
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Release Depth.
General Data Type: NUMBER

REL_DEPTHUOM

CC ID: 333583
Seq. Order: 74
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Unit of measure used for depth (FM, FT, M).
General Data Type: VARCHAR2

REL_CONTACTID

CC ID: 333584
Seq. Order: 75
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

Release Contact id for event.
General Data Type: NUMBER

REL_INDUSTRY

CC ID: 333585
Seq. Order: 76
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Industry (category, sector) at time of event, see support table MRINDUSTRY for descriptions.
General Data Type: VARCHAR2

REL_OCCUPATION

CC ID: 333586
Seq. Order: 77
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Occupation at time of event, see support table MROCCUPATION for descriptions.
General Data Type: VARCHAR2

REL_GEAR

CC ID: 333587
Seq. Order: 78
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Gear used, see support table MRGEARS for descriptions.
General Data Type: VARCHAR2

REL_SHVESSEL

CC ID: 333588
Seq. Order: 79
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Vessel code used by the shark fishery, see support table MRSHVESSELS for descriptions.
General Data Type: VARCHAR2

REL_VESS_NATION

CC ID: 333590
Seq. Order: 80
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release Vessel nation at time of event, see support table MRNATIONS for descriptions.
General Data Type: VARCHAR2

REL_WEB_DOE

CC ID: 333591
Seq. Order: 81
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Release Date of Last Entry from Web Application.
General Data Type: DATE

REL_WEB_UOE

CC ID: 333592
Seq. Order: 82
Data Storage Type: VARCHAR2
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

Release User of Last Entry from Web Application.
General Data Type: VARCHAR2

REL_WEB_DOC

CC ID: 333593
Seq. Order: 83
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Release Date of Last Change from Web Application.
General Data Type: DATE

REL_WEB_UOC

CC ID: 333594
Seq. Order: 84
Data Storage Type: VARCHAR2
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

Release User of Last Change from Web Application.
General Data Type: VARCHAR2

REC_EVENTNUM

CC ID: 333595
Seq. Order: 85
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Recapture event number.
General Data Type: NUMBER

REC_TAG_TYPE

CC ID: 333596
Seq. Order: 86
Data Storage Type: VARCHAR2
Max Length: 2
Required: Yes
Primary Key: No
Status: Active
Description:

Recapture Style of tag, see support table MRTAGTYPES for descriptions.
General Data Type: VARCHAR2

REC_TAG_COLOR

CC ID: 333597
Seq. Order: 87
Data Storage Type: VARCHAR2
Max Length: 2
Required: Yes
Primary Key: No
Status: Active
Description:

Recapture Color of tag, see support table MRTAGCOLORS for descriptions.
General Data Type: VARCHAR2

REC_TAG_NUMBER

CC ID: 333598
Seq. Order: 88
Data Storage Type: VARCHAR2
Max Length: 6
Required: Yes
Primary Key: No
Status: Active
Description:

Recapture Tag identification number.
General Data Type: VARCHAR2

REC_TAG_SUFFIX

CC ID: 333599
Seq. Order: 89
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Recapture Tag suffix.
General Data Type: VARCHAR2

REC_TAG_REWARD

CC ID: 333601
Seq. Order: 90
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Reward for tag Recapture or recapture, see support table MRTAGREWARDS for descriptions.
General Data Type: VARCHAR2

REC_TAG_FATE

CC ID: 333602
Seq. Order: 91
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Fate of tag, see support table MRTAGFATES for descriptions.
General Data Type: VARCHAR2

REC_TAG_CONDITION

CC ID: 333603
Seq. Order: 92
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Condition of tag, see support table MRTAGCONDITIONS for descriptions.
General Data Type: VARCHAR2

REC_TAG_SITE

CC ID: 333604
Seq. Order: 93
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Area of tag at recapture, see support table MRTAGSITE for descriptions.
General Data Type: VARCHAR2

REC_TAG_LOCONFISH

CC ID: 333605
Seq. Order: 94
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Location on fish where tag is attached, see support table MRTAGLOCONFISH for descriptions.
General Data Type: VARCHAR2

REC_TRIPID

CC ID: 333606
Seq. Order: 95
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Recapture Trip identification code.
General Data Type: VARCHAR2

REC_HAULNUM

CC ID: 333607
Seq. Order: 96
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Recapture Ordinal number of the haul within the trip, set number for shark cruises.
General Data Type: VARCHAR2

REC_TYPE

CC ID: 333608
Seq. Order: 97
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Event type, see support table MREVENTTYPES for descriptions.
General Data Type: VARCHAR2

REC_MONTH

CC ID: 333609
Seq. Order: 98
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Month of event.
General Data Type: VARCHAR2

REC_DAY

CC ID: 333610
Seq. Order: 99
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Day of event.
General Data Type: VARCHAR2

REC_YEAR

CC ID: 333447
Seq. Order: 100
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Recapture Year of event.
General Data Type: VARCHAR2

REC_DATEQUAL

CC ID: 333448
Seq. Order: 101
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Date quality, see support table MRDATE_QUALITY for descriptions.
General Data Type: VARCHAR2

REC_COMMENTS

CC ID: 333449
Seq. Order: 102
Data Storage Type: VARCHAR2
Max Length: 200
Required: No
Primary Key: No
Status: Active
Description:

Recapture Comments or remarks.
General Data Type: VARCHAR2

REC_SPECIES_ITIS

CC ID: 333450
Seq. Order: 103
Data Storage Type: VARCHAR2
Max Length: 11
Required: No
Primary Key: No
Status: Active
Description:

Recapture Itis species code, see support table MRSPECIES for descriptions, corresponding survey and shark species codes also in MRSPECIES.
General Data Type: VARCHAR2

REC_SEX

CC ID: 333451
Seq. Order: 104
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Recapture Sex ( 0 = male, 1 = female).
General Data Type: VARCHAR2

REC_FISHCOND

CC ID: 333452
Seq. Order: 105
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Condition of fish at event, see support table MRFISH_CONDITIONS for descriptions.
General Data Type: VARCHAR2

REC_FISHFATE

CC ID: 333453
Seq. Order: 106
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Fate of fish at event, see support table MRFISH_FATES for descriptions.
General Data Type: VARCHAR2

REC_LIFESTAGE

CC ID: 333454
Seq. Order: 107
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Lifestage of fish at event, see support table MRLIFESTAGES for descriptions.
General Data Type: VARCHAR2

REC_LENGTH

CC ID: 333455
Seq. Order: 108
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

Recapture Length, for sharks: fork length in centimeters .
General Data Type: NUMBER

REC_LENUOM

CC ID: 333456
Seq. Order: 109
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Recapture Unit of measure for length (CM, IN).
General Data Type: VARCHAR2

REC_LENQUAL

CC ID: 333458
Seq. Order: 110
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Data quality code for length, see support table MRLENGTH_QUALITY for descriptions.
General Data Type: VARCHAR2

REC_LENTYPE

CC ID: 333459
Seq. Order: 111
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Length type code, see support table MRLENGTH_TYPES for descriptions.
General Data Type: VARCHAR2

REC_LENDET

CC ID: 333460
Seq. Order: 112
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Length determination code, see support table MRLENGTH_DETERMINATION for descriptions.
General Data Type: VARCHAR2

REC_RPTLENGTH

CC ID: 333461
Seq. Order: 113
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

Recapture Reported length measurement.
General Data Type: NUMBER

REC_RPTLENUOM

CC ID: 333462
Seq. Order: 114
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Recapture Unit of measure for reported length (CM, IN).
General Data Type: VARCHAR2

REC_RPTLENQUAL

CC ID: 333463
Seq. Order: 115
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Data quality code for reported length, see support table MRLENGTH_QUALITY for descriptions.
General Data Type: VARCHAR2

REC_RPTLENTYPE

CC ID: 333464
Seq. Order: 116
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Reported length type code, see support table MRLENGTH_TYPES for descriptions.
General Data Type: VARCHAR2

REC_OTHLENGTH

CC ID: 333465
Seq. Order: 117
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

Recapture Other length measurement.
General Data Type: NUMBER

REC_OTHLENUOM

CC ID: 333466
Seq. Order: 118
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Recapture Unit of measure for other length (CM, IN).
General Data Type: VARCHAR2

REC_OTHLENQUAL

CC ID: 333467
Seq. Order: 119
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Data quality code for other length, see support table MRLENGTH_QUALITY for descriptions.
General Data Type: VARCHAR2

REC_OTHLENTYPE

CC ID: 333469
Seq. Order: 120
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Other length type code, see support table MRLENGTH_TYPES for descriptions.
General Data Type: VARCHAR2

REC_WEIGHT

CC ID: 333470
Seq. Order: 121
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

Recapture Weight, for sharks, whole weight in kg.
General Data Type: NUMBER

REC_WGTUOM

CC ID: 333471
Seq. Order: 122
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Recapture Unit of measure for weight (LB, KG).
General Data Type: VARCHAR2

REC_WGTQUAL

CC ID: 333472
Seq. Order: 123
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Weight quality code, see support table MRWEIGHT_QUALITY for descriptions.
General Data Type: VARCHAR2

REC_WGTTYPE

CC ID: 333473
Seq. Order: 124
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Weight type code, see support table MRWEIGHT_TYPES for descriptions.
General Data Type: VARCHAR2

REC_WGTDET

CC ID: 333474
Seq. Order: 125
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Weight determination code, see support table MRWEIGHT_DETERMINATION for descriptions.
General Data Type: VARCHAR2

REC_RPTWEIGHT

CC ID: 333475
Seq. Order: 126
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

Recapture Reported weight, for sharks, whole weight in kg.
General Data Type: NUMBER

REC_RPTWGTUOM

CC ID: 333476
Seq. Order: 127
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Recapture Unit of measure for reported weight (LB, KG).
General Data Type: VARCHAR2

REC_RPTWGTQUAL

CC ID: 333477
Seq. Order: 128
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Reported weight quality code, see support table MRWEIGHT_QUALITY for descriptions.
General Data Type: VARCHAR2

REC_RPTWGTTYPE

CC ID: 333478
Seq. Order: 129
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Reported weight type code, see support table MRWEIGHT_TYPES for descriptions.
General Data Type: VARCHAR2

REC_SPCOND1

CC ID: 333480
Seq. Order: 130
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Special condition code, see support table MRSPECIAL_CONDITIONS for descriptions.
General Data Type: VARCHAR2

REC_SPCOND2

CC ID: 333481
Seq. Order: 131
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Special condition code, see support table MRSPECIAL_CONDITIONS for descriptions..
General Data Type: VARCHAR2

REC_BIOSAMP1

CC ID: 333482
Seq. Order: 132
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Biological sample code, see support table MRBIO_SAMPLES for descriptions.
General Data Type: VARCHAR2

REC_BIOSAMP2

CC ID: 333483
Seq. Order: 133
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Biological sample code, see support table MRBIO_SAMPLES for descriptions..
General Data Type: VARCHAR2

REC_LOCATION

CC ID: 333484
Seq. Order: 134
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Recapture Reported location, see MRLOCATIONS for descriptions. (redacted)
General Data Type: VARCHAR2

REC_MILES

CC ID: 333485
Seq. Order: 135
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Recapture Miles from reported location (used for location calculation). (redacted)
General Data Type: NUMBER

REC_DIRECTION

CC ID: 333486
Seq. Order: 136
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Recapture Direction from reported location (used for location calculation). (redacted)
General Data Type: VARCHAR2

REC_LORANCHAIN

CC ID: 333487
Seq. Order: 137
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Recapture Loran chain. (redacted)
General Data Type: VARCHAR2

REC_LORAN1

CC ID: 333488
Seq. Order: 138
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 8
Scale: 2
Status: Active
Description:

Recapture Loran x. (redacted)
General Data Type: NUMBER

REC_LORAN2

CC ID: 333489
Seq. Order: 139
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 8
Scale: 2
Status: Active
Description:

Recapture Loran y. (redacted)
General Data Type: NUMBER

REC_LATDEG

CC ID: 333491
Seq. Order: 140
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Event latitude degrees. (redacted)
General Data Type: VARCHAR2

REC_LATMIN

CC ID: 333492
Seq. Order: 141
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Event latitude minutes. (redacted)
General Data Type: VARCHAR2

REC_LATSEC

CC ID: 333493
Seq. Order: 142
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Event latitude seconds. (redacted)
General Data Type: VARCHAR2

REC_NOS

CC ID: 333494
Seq. Order: 143
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Recapture North or south. (redacted)
General Data Type: VARCHAR2

REC_DECLAT

CC ID: 333495
Seq. Order: 144
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Recapture Latitude in decimal degrees. (redacted)
General Data Type: VARCHAR2

REC_LONDEG

CC ID: 333496
Seq. Order: 145
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Recapture Event longitude degrees. (redacted)
General Data Type: VARCHAR2

REC_LONMIN

CC ID: 333497
Seq. Order: 146
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Event longitude minutes. (redacted)
General Data Type: VARCHAR2

REC_LONSEC

CC ID: 333498
Seq. Order: 147
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Event longitude seconds. (redacted)
General Data Type: VARCHAR2

REC_EOW

CC ID: 333499
Seq. Order: 148
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Recapture East or west. (redacted)
General Data Type: VARCHAR2

REC_DECLON

CC ID: 333500
Seq. Order: 149
Data Storage Type: VARCHAR2
Max Length: 11
Required: No
Primary Key: No
Status: Active
Description:

Recapture Longitude in decimal degrees. (redacted)
General Data Type: VARCHAR2

REC_LOCQUAL

CC ID: 333502
Seq. Order: 150
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Data quality code for location, see MRLOC_QUALITY for descriptions.
General Data Type: VARCHAR2

REC_DAYSFREE

CC ID: 333503
Seq. Order: 151
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Recapture Days free for recapture only.
General Data Type: NUMBER

REC_DISTTRAVEL

CC ID: 333504
Seq. Order: 152
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Recapture Distance traveled in nautical miles for recapture only, distance traveled is calculated with great circle formula.
General Data Type: NUMBER

REC_TRAVELDEG

CC ID: 333505
Seq. Order: 153
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 1
Status: Active
Description:

Recapture Travel direction for recapture only, see MRDIRECTIONS for descriptions.
General Data Type: NUMBER

REC_TRAVELDIR

CC ID: 333506
Seq. Order: 154
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

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..
General Data Type: VARCHAR2

REC_DEPTH

CC ID: 333507
Seq. Order: 155
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Recapture Depth.
General Data Type: NUMBER

REC_DEPTHUOM

CC ID: 333508
Seq. Order: 156
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Unit of measure used for depth (FM, FT, M).
General Data Type: VARCHAR2

REC_CONTACTID

CC ID: 333509
Seq. Order: 157
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

Recapture Contact id for event.
General Data Type: NUMBER

REC_INDUSTRY

CC ID: 333510
Seq. Order: 158
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Industry (category, sector) at time of event, see support table MRINDUSTRY for descriptions.
General Data Type: VARCHAR2

REC_OCCUPATION

CC ID: 333511
Seq. Order: 159
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Occupation at time of event, see support table MROCCUPATION for descriptions.
General Data Type: VARCHAR2

REC_GEAR

CC ID: 333513
Seq. Order: 160
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Gear used, see support table MRGEARS for descriptions.
General Data Type: VARCHAR2

REC_SHVESSEL

CC ID: 333514
Seq. Order: 161
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Vessel code used by the shark fishery, see support table MRSHVESSELS for descriptions.
General Data Type: VARCHAR2

REC_VESS_NATION

CC ID: 333515
Seq. Order: 162
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Recapture Vessel nation at time of event, see support table MRNATIONS for descriptions.
General Data Type: VARCHAR2

REC_WEB_DOE

CC ID: 333516
Seq. Order: 163
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Recapture Date of Last Entry from Web Application.
General Data Type: DATE

REC_WEB_UOE

CC ID: 333517
Seq. Order: 164
Data Storage Type: VARCHAR2
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

Recapture User of Last Entry from Web Application.
General Data Type: VARCHAR2

REC_WEB_DOC

CC ID: 333518
Seq. Order: 165
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Recapture Date of Last Change from Web Application.
General Data Type: DATE

REC_WEB_UOC

CC ID: 333519
Seq. Order: 166
Data Storage Type: VARCHAR2
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

Recapture User of Last Change from Web Application.
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 33547
GUID: gov.noaa.nmfs.inport:33547
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-07-27 15:26+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-08-01
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-08-01
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-08-01