Search Help Show/Hide Menu
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.
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 9650, 01-12-2017 16:31

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.
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: 374004
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: 374082
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: 374093
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: 374104
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: 374115
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: 374126
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: 374137
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: 374148
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: 374159
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: 374005
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: 374016
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: 374027
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: 374038
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: 374049
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: 374060
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: 374071
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: 374079
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: 374080
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: 374081
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: 374083
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: 374084
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: 374085
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: 374086
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: 374087
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: 374088
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: 374089
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: 374090
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: 374091
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: 374092
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: 374094
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: 374095
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: 374096
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: 374097
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: 374098
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: 374099
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: 374100
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: 374101
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: 374102
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: 374103
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: 374105
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: 374106
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: 374107
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: 374108
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: 374109
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: 374110
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: 374111
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: 374112
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: 374113
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: 374114
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: 374116
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: 374117
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: 374118
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: 374119
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: 374120
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: 374121
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: 374122
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: 374123
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: 374124
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: 374125
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: 374127
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: 374128
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: 374129
Seq. Order: 62
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Release latitude in decimal degrees.

General Data Type: VARCHAR2

REL_LONDEG

CC ID: 374130
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: 374131
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: 374132
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: 374133
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: 374134
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: 374135
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: 374136
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: 374138
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: 374139
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: 374140
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: 374141
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: 374142
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: 374143
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: 374144
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: 374145
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: 374146
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: 374147
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: 374149
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: 374150
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: 374151
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: 374152
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: 374153
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: 374154
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: 374155
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: 374156
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: 374157
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: 374158
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: 374160
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: 374161
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: 374162
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: 374163
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: 374164
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: 374165
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: 374166
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: 374167
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: 374168
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: 374169
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: 374006
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: 374007
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: 374008
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: 374009
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: 374010
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: 374011
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: 374012
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: 374013
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: 374014
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: 374015
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: 374017
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: 374018
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: 374019
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: 374020
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: 374021
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: 374022
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: 374023
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: 374024
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: 374025
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: 374026
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: 374028
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: 374029
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: 374030
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: 374031
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: 374032
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: 374033
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: 374034
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: 374035
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: 374036
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: 374037
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: 374039
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: 374040
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: 374041
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: 374042
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: 374043
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: 374044
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: 374045
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: 374046
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: 374047
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: 374048
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: 374050
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: 374051
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: 374052
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: 374053
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: 374054
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: 374055
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: 374056
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: 374057
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: 374058
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: 374059
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: 374061
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: 374062
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: 374063
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: 374064
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: 374065
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: 374066
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: 374067
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: 374068
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: 374069
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: 374070
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: 374072
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: 374073
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: 374074
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: 374075
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: 374076
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: 374077
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: 374078
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: 36251
GUID: gov.noaa.nmfs.inport:36251
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2017-01-12 16:31+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2017-01-12
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2017-01-12
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2018-01-12