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 Atlantic States Shark Pupping and N... >

Table: MRMVRELRECAP03

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

Summary

Abstract

no-comment

Description

no-comment

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:

no-comment
Notes:

Loaded by batch 9270, 09-13-2016 10:42

Entity Information

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

no-comment

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: 349214
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: 349292
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: 349303
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Release event number.
General Data Type: NUMBER

REL_TAG_TYPE

CC ID: 349314
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: 349325
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: 349336
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: 349347
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: 349358
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: 349369
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: 349215
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: 349226
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: 349237
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: 349248
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: 349259
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: 349270
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: 349281
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: 349289
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: 349290
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: 349291
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: 349293
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: 349294
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: 349295
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: 349296
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: 349297
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: 349298
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: 349299
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: 349300
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: 349301
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: 349302
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: 349304
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: 349305
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: 349306
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: 349307
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: 349308
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: 349309
Seq. Order: 35
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 2
Status: Active
Description:

Release Other length measurement.
General Data Type: NUMBER

REL_OTHLENUOM

CC ID: 349310
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: 349311
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: 349312
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: 349313
Seq. Order: 39
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 2
Status: Active
Description:

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

REL_WGTUOM

CC ID: 349315
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: 349316
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: 349317
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: 349318
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: 349319
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: 349320
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: 349321
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: 349322
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: 349323
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: 349324
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: 349326
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: 349327
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: 349328
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: 349329
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: 349330
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: 349331
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: 349332
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: 349333
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: 349334
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: 349335
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: 349337
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: 349338
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: 349339
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: 349340
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: 349341
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: 349342
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: 349343
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: 349344
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: 349345
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: 349346
Seq. Order: 69
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

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

REL_DISTTRAVEL

CC ID: 349348
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: 349349
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: 349350
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: 349351
Seq. Order: 73
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Release Depth.
General Data Type: NUMBER

REL_DEPTHUOM

CC ID: 349352
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: 349353
Seq. Order: 75
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Release Contact id for event.
General Data Type: NUMBER

REL_INDUSTRY

CC ID: 349354
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: 349355
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: 349356
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: 349357
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: 349359
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: 349360
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: 349361
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: 349362
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: 349363
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: 349364
Seq. Order: 85
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Recapture event number.
General Data Type: NUMBER

REC_TAG_TYPE

CC ID: 349365
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: 349366
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: 349367
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: 349368
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: 349370
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: 349371
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: 349372
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: 349373
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: 349374
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: 349375
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: 349376
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: 349377
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: 349378
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: 349379
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: 349216
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: 349217
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: 349218
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: 349219
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: 349220
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: 349221
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: 349222
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: 349223
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: 349224
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: 349225
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: 349227
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: 349228
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: 349229
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: 349230
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: 349231
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: 349232
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: 349233
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: 349234
Seq. Order: 117
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 2
Status: Active
Description:

Recapture Other length measurement.
General Data Type: NUMBER

REC_OTHLENUOM

CC ID: 349235
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: 349236
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: 349238
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: 349239
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: 349240
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: 349241
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: 349242
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: 349243
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: 349244
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: 349245
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: 349246
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: 349247
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: 349249
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: 349250
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: 349251
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: 349252
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: 349253
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: 349254
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: 349255
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: 349256
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: 349257
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: 349258
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: 349260
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: 349261
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: 349262
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: 349263
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: 349264
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: 349265
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: 349266
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: 349267
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: 349268
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: 349269
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: 349271
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: 349272
Seq. Order: 151
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

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

REC_DISTTRAVEL

CC ID: 349273
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: 349274
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: 349275
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: 349276
Seq. Order: 155
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Recapture Depth.
General Data Type: NUMBER

REC_DEPTHUOM

CC ID: 349277
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: 349278
Seq. Order: 157
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Recapture Contact id for event.
General Data Type: NUMBER

REC_INDUSTRY

CC ID: 349279
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: 349280
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: 349282
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: 349283
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: 349284
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: 349285
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: 349286
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: 349287
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: 349288
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: 34794
GUID: gov.noaa.nmfs.inport:34794
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-09-13 10:42+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-09-13
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-09-13
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-09-13