Table: MRMVRELRECAP03
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33547 | Updated: August 9, 2022 | Published / External
Item Identification
| Title: | Table: MRMVRELRECAP03 |
|---|---|
| Short Name: | MRMVRELRECAP03 |
| Status: | Completed |
| Abstract: |
Release and Recapture Events for Shark Fishery |
| Notes: |
Loaded by batch 9052, 07-27-2016 15:26 |
Entity Information
| Entity Type: | Data Table |
|---|---|
| Active Version?: | Yes |
| Schema Name: | MRDBS |
| Description: |
Release and Recapture Events for Shark Fishery |
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
FISHERY | VARCHAR2 | Fishery Code, a two character fishery identification code. See support table MRFISHERY for codes and descriptions. | |
|
100
|
ANIMALID | VARCHAR2 | Animal identification code, animal id will be a concatenation of fishery, original tag type, color, number, and suffix. | |
|
100
|
REL_EVENTNUM | NUMBER | Release event number. | |
|
100
|
REL_TAG_TYPE | VARCHAR2 | Release Style of tag, see support table MRTAGTYPES for descriptions. | |
|
100
|
REL_TAG_COLOR | VARCHAR2 | Release Color of tag, see support table MRTAGCOLORS for descriptions. | |
|
100
|
REL_TAG_NUMBER | VARCHAR2 | Release Tag identification number | |
|
100
|
REL_TAG_SUFFIX | VARCHAR2 | Release Tag suffix. | |
|
100
|
REL_TAG_REWARD | VARCHAR2 | Release Reward for tag Recapture or recapture, see support table MRTAGREWARDS for descriptions. | |
|
100
|
REL_TAG_FATE | VARCHAR2 | Release Fate of tag, see support table MRTAGFATES for descriptions. | |
|
100
|
REL_TAG_CONDITION | VARCHAR2 | Release Condition of tag, see support table MRTAGCONDITIONS for descriptions. | |
|
100
|
REL_TAG_SITE | VARCHAR2 | Release Area of tag at recapture, see support table MRTAGSITE for descriptions. | |
|
100
|
REL_TAG_LOCONFISH | VARCHAR2 | Release Location on fish where tag is attached, see support table MRTAGLOCONFISH for descriptions. | |
|
100
|
REL_TRIPID | VARCHAR2 | Release Trip identification code. | |
|
100
|
REL_HAULNUM | VARCHAR2 | Release Ordinal number of the haul within the trip, set number for shark cruises. | |
|
100
|
REL_TYPE | VARCHAR2 | Release Event type, see support table MREVENTTYPES for descriptions. | |
|
100
|
REL_MONTH | VARCHAR2 | Release Month of event. | |
|
100
|
REL_DAY | VARCHAR2 | Release Day of event. | |
|
100
|
REL_YEAR | VARCHAR2 | Release Year of event. | |
|
100
|
REL_DATEQUAL | VARCHAR2 | Release Date quality, see support table MRDATE_QUALITY for descriptions. | |
|
100
|
REL_COMMENTS | VARCHAR2 | Release Comments or remarks. | |
|
100
|
REL_SPECIES_ITIS | VARCHAR2 | Release Itis species code, see support table MRSPECIES for descriptions, corresponding survey and shark species codes also in MRSPECIES. | |
|
100
|
REL_SEX | VARCHAR2 | Release Sex ( 0 = male, 1 = female). | |
|
100
|
REL_FISHCOND | VARCHAR2 | Release Condition of fish at event, see support table MRFISH_CONDITIONS for descriptions. | |
|
100
|
REL_FISHFATE | VARCHAR2 | Release Fate of fish at event, see support table MRFISH_FATES for descriptions. | |
|
100
|
REL_LIFESTAGE | VARCHAR2 | Release Lifestage of fish at event, see support table MRLIFESTAGES for descriptions. | |
|
100
|
REL_LENGTH | NUMBER | Release Length, for sharks: fork length in centimeters . | |
|
100
|
REL_LENUOM | VARCHAR2 | Release Unit of measure for length (CM, IN). | |
|
100
|
REL_LENQUAL | VARCHAR2 | Release Data quality code for length, see support table MRLENGTH_QUALITY for descriptions. | |
|
100
|
REL_LENTYPE | VARCHAR2 | Release Length type code, see support table MRLENGTH_TYPES for descriptions. | |
|
100
|
REL_LENDET | VARCHAR2 | Release Length determination code, see support table MRLENGTH_DETERMINATION for descriptions. | |
|
100
|
REL_RPTLENGTH | NUMBER | Release Reported length measurement. | |
|
100
|
REL_RPTLENUOM | VARCHAR2 | Release Unit of measure for reported length (CM, IN). | |
|
100
|
REL_RPTLENQUAL | VARCHAR2 | Release Data quality code for reported length, see support table MRLENGTH_QUALITY for descriptions. | |
|
100
|
REL_RPTLENTYPE | VARCHAR2 | Release Reported length type code, see support table MRLENGTH_TYPES for descriptions. | |
|
100
|
REL_OTHLENGTH | NUMBER | Release Other length measurement. | |
|
100
|
REL_OTHLENUOM | VARCHAR2 | Release Unit of measure for other length (CM, IN). | |
|
100
|
REL_OTHLENQUAL | VARCHAR2 | Release Data quality code for other length, see support table MRLENGTH_QUALITY for descriptions. | |
|
100
|
REL_OTHLENTYPE | VARCHAR2 | Release Other length type code, see support table MRLENGTH_TYPES for descriptions. | |
|
100
|
REL_WEIGHT | NUMBER | Release Weight, for sharks, whole weight in kg. | |
|
100
|
REL_WGTUOM | VARCHAR2 | Release Unit of measure for weight (LB, KG). | |
|
100
|
REL_WGTQUAL | VARCHAR2 | Release Weight quality code, see support table MRWEIGHT_QUALITY for descriptions. | |
|
100
|
REL_WGTTYPE | VARCHAR2 | Release Weight type code, see support table MRWEIGHT_TYPES for descriptions. | |
|
100
|
REL_WGTDET | VARCHAR2 | Release Weight determination code, see support table MRWEIGHT_DETERMINATION for descriptions. | |
|
100
|
REL_RPTWEIGHT | NUMBER | Release Reported weight, for sharks, whole weight in kg. | |
|
100
|
REL_RPTWGTUOM | VARCHAR2 | Release Unit of measure for reported weight (LB, KG). | |
|
100
|
REL_RPTWGTQUAL | VARCHAR2 | Release Reported weight quality code, see support table MRWEIGHT_QUALITY for descriptions. | |
|
100
|
REL_RPTWGTTYPE | VARCHAR2 | Release Reported weight type code, see support table MRWEIGHT_TYPES for descriptions. | |
|
100
|
REL_SPCOND1 | VARCHAR2 | Release Special condition code, see support table MRSPECIAL_CONDITIONS for descriptions. | |
|
100
|
REL_SPCOND2 | VARCHAR2 | Release Special condition code, see support table MRSPECIAL_CONDITIONS for descriptions.. | |
|
100
|
REL_BIOSAMP1 | VARCHAR2 | Release Biological sample code, see support table MRBIO_SAMPLES for descriptions. | |
|
100
|
REL_BIOSAMP2 | VARCHAR2 | Release Biological sample code, see support table MRBIO_SAMPLES for descriptions.. | |
|
100
|
REL_LOCATION | VARCHAR2 | Release Reported location, see MRLOCATIONS for descriptions. (redacted) | |
|
100
|
REL_MILES | NUMBER | Release Miles from reported location (used for location calculation). (redacted) | |
|
100
|
REL_DIRECTION | VARCHAR2 | Release Direction from reported location (used for location calculation). (redacted) | |
|
100
|
REL_LORANCHAIN | VARCHAR2 | Release Loran chain. (redacted) | |
|
100
|
REL_LORAN1 | NUMBER | Release Loran x. (redacted) | |
|
100
|
REL_LORAN2 | NUMBER | Release Loran y. (redacted) | |
|
100
|
REL_LATDEG | VARCHAR2 | Release Event latitude degrees. (redacted) | |
|
100
|
REL_LATMIN | VARCHAR2 | Release Event latitude minutes. (redacted) | |
|
100
|
REL_LATSEC | VARCHAR2 | Release Event latitude seconds. (redacted) | |
|
100
|
REL_NOS | VARCHAR2 | Release North or south. (redacted) | |
|
100
|
REL_DECLAT | VARCHAR2 | Release latitude in decimal degrees. (redacted) | |
|
100
|
REL_LONDEG | VARCHAR2 | Release Event longitude degrees. (redacted) | |
|
100
|
REL_LONMIN | VARCHAR2 | Release Event longitude minutes. (redacted) | |
|
100
|
REL_LONSEC | VARCHAR2 | Release Event longitude seconds. (redacted) | |
|
100
|
REL_EOW | VARCHAR2 | Release East or west. (redacted) | |
|
100
|
REL_DECLON | VARCHAR2 | Release longitude in decimal degrees. (redacted) | |
|
100
|
REL_LOCQUAL | VARCHAR2 | Release Data quality code for location, see MRLOC_QUALITY for descriptions. | |
|
100
|
REL_DAYSFREE | NUMBER | Release Days free for recapture only. | |
|
100
|
REL_DISTTRAVEL | NUMBER | Release Distance traveled in nautical miles for recapture only, distance traveled is calculated with great circle formula. | |
|
100
|
REL_TRAVELDEG | NUMBER | Release Travel direction for recapture only, see MRDIRECTIONS for descriptions. | |
|
100
|
REL_TRAVELDIR | VARCHAR2 | Release Calculated angle for direction traveled, rounded to 1 decimal position. For ytf, bsb, and scup, angle is calculated using magnetic north, shark angle is calculated using polar north.. | |
|
100
|
REL_DEPTH | NUMBER | Release Depth. | |
|
100
|
REL_DEPTHUOM | VARCHAR2 | Release Unit of measure used for depth (FM, FT, M). | |
|
100
|
REL_CONTACTID | NUMBER | Release Contact id for event. | |
|
100
|
REL_INDUSTRY | VARCHAR2 | Release Industry (category, sector) at time of event, see support table MRINDUSTRY for descriptions. | |
|
100
|
REL_OCCUPATION | VARCHAR2 | Release Occupation at time of event, see support table MROCCUPATION for descriptions. | |
|
100
|
REL_GEAR | VARCHAR2 | Release Gear used, see support table MRGEARS for descriptions. | |
|
100
|
REL_SHVESSEL | VARCHAR2 | Release Vessel code used by the shark fishery, see support table MRSHVESSELS for descriptions. | |
|
100
|
REL_VESS_NATION | VARCHAR2 | Release Vessel nation at time of event, see support table MRNATIONS for descriptions. | |
|
100
|
REL_WEB_DOE | DATE | Release Date of Last Entry from Web Application. | |
|
100
|
REL_WEB_UOE | VARCHAR2 | Release User of Last Entry from Web Application. | |
|
100
|
REL_WEB_DOC | DATE | Release Date of Last Change from Web Application. | |
|
100
|
REL_WEB_UOC | VARCHAR2 | Release User of Last Change from Web Application. | |
|
100
|
REC_EVENTNUM | NUMBER | Recapture event number. | |
|
100
|
REC_TAG_TYPE | VARCHAR2 | Recapture Style of tag, see support table MRTAGTYPES for descriptions. | |
|
100
|
REC_TAG_COLOR | VARCHAR2 | Recapture Color of tag, see support table MRTAGCOLORS for descriptions. | |
|
100
|
REC_TAG_NUMBER | VARCHAR2 | Recapture Tag identification number. | |
|
100
|
REC_TAG_SUFFIX | VARCHAR2 | Recapture Tag suffix. | |
|
100
|
REC_TAG_REWARD | VARCHAR2 | Recapture Reward for tag Recapture or recapture, see support table MRTAGREWARDS for descriptions. | |
|
100
|
REC_TAG_FATE | VARCHAR2 | Recapture Fate of tag, see support table MRTAGFATES for descriptions. | |
|
100
|
REC_TAG_CONDITION | VARCHAR2 | Recapture Condition of tag, see support table MRTAGCONDITIONS for descriptions. | |
|
100
|
REC_TAG_SITE | VARCHAR2 | Recapture Area of tag at recapture, see support table MRTAGSITE for descriptions. | |
|
100
|
REC_TAG_LOCONFISH | VARCHAR2 | Recapture Location on fish where tag is attached, see support table MRTAGLOCONFISH for descriptions. | |
|
100
|
REC_TRIPID | VARCHAR2 | Recapture Trip identification code. | |
|
100
|
REC_HAULNUM | VARCHAR2 | Recapture Ordinal number of the haul within the trip, set number for shark cruises. | |
|
100
|
REC_TYPE | VARCHAR2 | Recapture Event type, see support table MREVENTTYPES for descriptions. | |
|
100
|
REC_MONTH | VARCHAR2 | Recapture Month of event. | |
|
100
|
REC_DAY | VARCHAR2 | Recapture Day of event. | |
|
100
|
REC_YEAR | VARCHAR2 | Recapture Year of event. | |
|
100
|
REC_DATEQUAL | VARCHAR2 | Recapture Date quality, see support table MRDATE_QUALITY for descriptions. | |
|
100
|
REC_COMMENTS | VARCHAR2 | Recapture Comments or remarks. | |
|
100
|
REC_SPECIES_ITIS | VARCHAR2 | Recapture Itis species code, see support table MRSPECIES for descriptions, corresponding survey and shark species codes also in MRSPECIES. | |
|
100
|
REC_SEX | VARCHAR2 | Recapture Sex ( 0 = male, 1 = female). | |
|
100
|
REC_FISHCOND | VARCHAR2 | Recapture Condition of fish at event, see support table MRFISH_CONDITIONS for descriptions. | |
|
100
|
REC_FISHFATE | VARCHAR2 | Recapture Fate of fish at event, see support table MRFISH_FATES for descriptions. | |
|
100
|
REC_LIFESTAGE | VARCHAR2 | Recapture Lifestage of fish at event, see support table MRLIFESTAGES for descriptions. | |
|
100
|
REC_LENGTH | NUMBER | Recapture Length, for sharks: fork length in centimeters . | |
|
100
|
REC_LENUOM | VARCHAR2 | Recapture Unit of measure for length (CM, IN). | |
|
100
|
REC_LENQUAL | VARCHAR2 | Recapture Data quality code for length, see support table MRLENGTH_QUALITY for descriptions. | |
|
100
|
REC_LENTYPE | VARCHAR2 | Recapture Length type code, see support table MRLENGTH_TYPES for descriptions. | |
|
100
|
REC_LENDET | VARCHAR2 | Recapture Length determination code, see support table MRLENGTH_DETERMINATION for descriptions. | |
|
100
|
REC_RPTLENGTH | NUMBER | Recapture Reported length measurement. | |
|
100
|
REC_RPTLENUOM | VARCHAR2 | Recapture Unit of measure for reported length (CM, IN). | |
|
100
|
REC_RPTLENQUAL | VARCHAR2 | Recapture Data quality code for reported length, see support table MRLENGTH_QUALITY for descriptions. | |
|
100
|
REC_RPTLENTYPE | VARCHAR2 | Recapture Reported length type code, see support table MRLENGTH_TYPES for descriptions. | |
|
100
|
REC_OTHLENGTH | NUMBER | Recapture Other length measurement. | |
|
100
|
REC_OTHLENUOM | VARCHAR2 | Recapture Unit of measure for other length (CM, IN). | |
|
100
|
REC_OTHLENQUAL | VARCHAR2 | Recapture Data quality code for other length, see support table MRLENGTH_QUALITY for descriptions. | |
|
100
|
REC_OTHLENTYPE | VARCHAR2 | Recapture Other length type code, see support table MRLENGTH_TYPES for descriptions. | |
|
100
|
REC_WEIGHT | NUMBER | Recapture Weight, for sharks, whole weight in kg. | |
|
100
|
REC_WGTUOM | VARCHAR2 | Recapture Unit of measure for weight (LB, KG). | |
|
100
|
REC_WGTQUAL | VARCHAR2 | Recapture Weight quality code, see support table MRWEIGHT_QUALITY for descriptions. | |
|
100
|
REC_WGTTYPE | VARCHAR2 | Recapture Weight type code, see support table MRWEIGHT_TYPES for descriptions. | |
|
100
|
REC_WGTDET | VARCHAR2 | Recapture Weight determination code, see support table MRWEIGHT_DETERMINATION for descriptions. | |
|
100
|
REC_RPTWEIGHT | NUMBER | Recapture Reported weight, for sharks, whole weight in kg. | |
|
100
|
REC_RPTWGTUOM | VARCHAR2 | Recapture Unit of measure for reported weight (LB, KG). | |
|
100
|
REC_RPTWGTQUAL | VARCHAR2 | Recapture Reported weight quality code, see support table MRWEIGHT_QUALITY for descriptions. | |
|
100
|
REC_RPTWGTTYPE | VARCHAR2 | Recapture Reported weight type code, see support table MRWEIGHT_TYPES for descriptions. | |
|
100
|
REC_SPCOND1 | VARCHAR2 | Recapture Special condition code, see support table MRSPECIAL_CONDITIONS for descriptions. | |
|
100
|
REC_SPCOND2 | VARCHAR2 | Recapture Special condition code, see support table MRSPECIAL_CONDITIONS for descriptions.. | |
|
100
|
REC_BIOSAMP1 | VARCHAR2 | Recapture Biological sample code, see support table MRBIO_SAMPLES for descriptions. | |
|
100
|
REC_BIOSAMP2 | VARCHAR2 | Recapture Biological sample code, see support table MRBIO_SAMPLES for descriptions.. | |
|
100
|
REC_LOCATION | VARCHAR2 | Recapture Reported location, see MRLOCATIONS for descriptions. (redacted) | |
|
100
|
REC_MILES | NUMBER | Recapture Miles from reported location (used for location calculation). (redacted) | |
|
100
|
REC_DIRECTION | VARCHAR2 | Recapture Direction from reported location (used for location calculation). (redacted) | |
|
100
|
REC_LORANCHAIN | VARCHAR2 | Recapture Loran chain. (redacted) | |
|
100
|
REC_LORAN1 | NUMBER | Recapture Loran x. (redacted) | |
|
100
|
REC_LORAN2 | NUMBER | Recapture Loran y. (redacted) | |
|
100
|
REC_LATDEG | VARCHAR2 | Recapture Event latitude degrees. (redacted) | |
|
100
|
REC_LATMIN | VARCHAR2 | Recapture Event latitude minutes. (redacted) | |
|
100
|
REC_LATSEC | VARCHAR2 | Recapture Event latitude seconds. (redacted) | |
|
100
|
REC_NOS | VARCHAR2 | Recapture North or south. (redacted) | |
|
100
|
REC_DECLAT | VARCHAR2 | Recapture Latitude in decimal degrees. (redacted) | |
|
100
|
REC_LONDEG | VARCHAR2 | Recapture Event longitude degrees. (redacted) | |
|
100
|
REC_LONMIN | VARCHAR2 | Recapture Event longitude minutes. (redacted) | |
|
100
|
REC_LONSEC | VARCHAR2 | Recapture Event longitude seconds. (redacted) | |
|
100
|
REC_EOW | VARCHAR2 | Recapture East or west. (redacted) | |
|
100
|
REC_DECLON | VARCHAR2 | Recapture Longitude in decimal degrees. (redacted) | |
|
100
|
REC_LOCQUAL | VARCHAR2 | Recapture Data quality code for location, see MRLOC_QUALITY for descriptions. | |
|
100
|
REC_DAYSFREE | NUMBER | Recapture Days free for recapture only. | |
|
100
|
REC_DISTTRAVEL | NUMBER | Recapture Distance traveled in nautical miles for recapture only, distance traveled is calculated with great circle formula. | |
|
100
|
REC_TRAVELDEG | NUMBER | Recapture Travel direction for recapture only, see MRDIRECTIONS for descriptions. | |
|
100
|
REC_TRAVELDIR | VARCHAR2 | Recapture Calculated angle for direction traveled, rounded to 1 decimal position. For ytf, bsb, and scup, angle is calculated using magnetic north, shark angle is calculated using polar north.. | |
|
100
|
REC_DEPTH | NUMBER | Recapture Depth. | |
|
100
|
REC_DEPTHUOM | VARCHAR2 | Recapture Unit of measure used for depth (FM, FT, M). | |
|
100
|
REC_CONTACTID | NUMBER | Recapture Contact id for event. | |
|
100
|
REC_INDUSTRY | VARCHAR2 | Recapture Industry (category, sector) at time of event, see support table MRINDUSTRY for descriptions. | |
|
100
|
REC_OCCUPATION | VARCHAR2 | Recapture Occupation at time of event, see support table MROCCUPATION for descriptions. | |
|
100
|
REC_GEAR | VARCHAR2 | Recapture Gear used, see support table MRGEARS for descriptions. | |
|
100
|
REC_SHVESSEL | VARCHAR2 | Recapture Vessel code used by the shark fishery, see support table MRSHVESSELS for descriptions. | |
|
100
|
REC_VESS_NATION | VARCHAR2 | Recapture Vessel nation at time of event, see support table MRNATIONS for descriptions. | |
|
100
|
REC_WEB_DOE | DATE | Recapture Date of Last Entry from Web Application. | |
|
100
|
REC_WEB_UOE | VARCHAR2 | Recapture User of Last Entry from Web Application. | |
|
100
|
REC_WEB_DOC | DATE | Recapture Date of Last Change from Web Application. | |
|
100
|
REC_WEB_UOC | VARCHAR2 | Recapture User of Last Change from Web Application. |
Attribute Details
FISHERY
CC ID: 333445
| Seq. Order: | 1 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Fishery Code, a two character fishery identification code. See support table MRFISHERY for codes and descriptions. |
| General Data Type: | VARCHAR2 |
ANIMALID
CC ID: 333523
| Seq. Order: | 2 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 14 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Animal identification code, animal id will be a concatenation of fishery, original tag type, color, number, and suffix. |
| General Data Type: | VARCHAR2 |
REL_EVENTNUM
CC ID: 333534
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 3 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Release event number. |
| General Data Type: | NUMBER |
REL_TAG_TYPE
CC ID: 333545
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Style of tag, see support table MRTAGTYPES for descriptions. |
| General Data Type: | VARCHAR2 |
REL_TAG_COLOR
CC ID: 333556
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Color of tag, see support table MRTAGCOLORS for descriptions. |
| General Data Type: | VARCHAR2 |
REL_TAG_NUMBER
CC ID: 333567
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 6 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Tag identification number |
| General Data Type: | VARCHAR2 |
REL_TAG_SUFFIX
CC ID: 333578
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Tag suffix. |
| General Data Type: | VARCHAR2 |
REL_TAG_REWARD
CC ID: 333589
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Reward for tag Recapture or recapture, see support table MRTAGREWARDS for descriptions. |
| General Data Type: | VARCHAR2 |
REL_TAG_FATE
CC ID: 333600
| Seq. Order: | 9 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Fate of tag, see support table MRTAGFATES for descriptions. |
| General Data Type: | VARCHAR2 |
REL_TAG_CONDITION
CC ID: 333446
| Seq. Order: | 10 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Condition of tag, see support table MRTAGCONDITIONS for descriptions. |
| General Data Type: | VARCHAR2 |
REL_TAG_SITE
CC ID: 333457
| Seq. Order: | 11 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Area of tag at recapture, see support table MRTAGSITE for descriptions. |
| General Data Type: | VARCHAR2 |
REL_TAG_LOCONFISH
CC ID: 333468
| Seq. Order: | 12 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Location on fish where tag is attached, see support table MRTAGLOCONFISH for descriptions. |
| General Data Type: | VARCHAR2 |
REL_TRIPID
CC ID: 333479
| Seq. Order: | 13 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Trip identification code. |
| General Data Type: | VARCHAR2 |
REL_HAULNUM
CC ID: 333490
| Seq. Order: | 14 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Ordinal number of the haul within the trip, set number for shark cruises. |
| General Data Type: | VARCHAR2 |
REL_TYPE
CC ID: 333501
| Seq. Order: | 15 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Event type, see support table MREVENTTYPES for descriptions. |
| General Data Type: | VARCHAR2 |
REL_MONTH
CC ID: 333512
| Seq. Order: | 16 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Month of event. |
| General Data Type: | VARCHAR2 |
REL_DAY
CC ID: 333520
| Seq. Order: | 17 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Day of event. |
| General Data Type: | VARCHAR2 |
REL_YEAR
CC ID: 333521
| Seq. Order: | 18 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Year of event. |
| General Data Type: | VARCHAR2 |
REL_DATEQUAL
CC ID: 333522
| Seq. Order: | 19 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Date quality, see support table MRDATE_QUALITY for descriptions. |
| General Data Type: | VARCHAR2 |
REL_COMMENTS
CC ID: 333524
| Seq. Order: | 20 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 200 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Comments or remarks. |
| General Data Type: | VARCHAR2 |
REL_SPECIES_ITIS
CC ID: 333525
| Seq. Order: | 21 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 11 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Itis species code, see support table MRSPECIES for descriptions, corresponding survey and shark species codes also in MRSPECIES. |
| General Data Type: | VARCHAR2 |
REL_SEX
CC ID: 333526
| Seq. Order: | 22 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Sex ( 0 = male, 1 = female). |
| General Data Type: | VARCHAR2 |
REL_FISHCOND
CC ID: 333527
| Seq. Order: | 23 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Condition of fish at event, see support table MRFISH_CONDITIONS for descriptions. |
| General Data Type: | VARCHAR2 |
REL_FISHFATE
CC ID: 333528
| Seq. Order: | 24 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Fate of fish at event, see support table MRFISH_FATES for descriptions. |
| General Data Type: | VARCHAR2 |
REL_LIFESTAGE
CC ID: 333529
| Seq. Order: | 25 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Lifestage of fish at event, see support table MRLIFESTAGES for descriptions. |
| General Data Type: | VARCHAR2 |
REL_LENGTH
CC ID: 333530
| Seq. Order: | 26 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 2 |
| Status: | Active |
| Description: |
Release Length, for sharks: fork length in centimeters . |
| General Data Type: | NUMBER |
REL_LENUOM
CC ID: 333531
| Seq. Order: | 27 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Unit of measure for length (CM, IN). |
| General Data Type: | VARCHAR2 |
REL_LENQUAL
CC ID: 333532
| Seq. Order: | 28 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Data quality code for length, see support table MRLENGTH_QUALITY for descriptions. |
| General Data Type: | VARCHAR2 |
REL_LENTYPE
CC ID: 333533
| Seq. Order: | 29 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Length type code, see support table MRLENGTH_TYPES for descriptions. |
| General Data Type: | VARCHAR2 |
REL_LENDET
CC ID: 333535
| Seq. Order: | 30 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Length determination code, see support table MRLENGTH_DETERMINATION for descriptions. |
| General Data Type: | VARCHAR2 |
REL_RPTLENGTH
CC ID: 333536
| Seq. Order: | 31 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 2 |
| Status: | Active |
| Description: |
Release Reported length measurement. |
| General Data Type: | NUMBER |
REL_RPTLENUOM
CC ID: 333537
| Seq. Order: | 32 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Unit of measure for reported length (CM, IN). |
| General Data Type: | VARCHAR2 |
REL_RPTLENQUAL
CC ID: 333538
| Seq. Order: | 33 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Data quality code for reported length, see support table MRLENGTH_QUALITY for descriptions. |
| General Data Type: | VARCHAR2 |
REL_RPTLENTYPE
CC ID: 333539
| Seq. Order: | 34 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Reported length type code, see support table MRLENGTH_TYPES for descriptions. |
| General Data Type: | VARCHAR2 |
REL_OTHLENGTH
CC ID: 333540
| Seq. Order: | 35 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 2 |
| Status: | Active |
| Description: |
Release Other length measurement. |
| General Data Type: | NUMBER |
REL_OTHLENUOM
CC ID: 333541
| Seq. Order: | 36 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Unit of measure for other length (CM, IN). |
| General Data Type: | VARCHAR2 |
REL_OTHLENQUAL
CC ID: 333542
| Seq. Order: | 37 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Data quality code for other length, see support table MRLENGTH_QUALITY for descriptions. |
| General Data Type: | VARCHAR2 |
REL_OTHLENTYPE
CC ID: 333543
| Seq. Order: | 38 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Other length type code, see support table MRLENGTH_TYPES for descriptions. |
| General Data Type: | VARCHAR2 |
REL_WEIGHT
CC ID: 333544
| Seq. Order: | 39 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 2 |
| Status: | Active |
| Description: |
Release Weight, for sharks, whole weight in kg. |
| General Data Type: | NUMBER |
REL_WGTUOM
CC ID: 333546
| Seq. Order: | 40 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Unit of measure for weight (LB, KG). |
| General Data Type: | VARCHAR2 |
REL_WGTQUAL
CC ID: 333547
| Seq. Order: | 41 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Weight quality code, see support table MRWEIGHT_QUALITY for descriptions. |
| General Data Type: | VARCHAR2 |
REL_WGTTYPE
CC ID: 333548
| Seq. Order: | 42 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Weight type code, see support table MRWEIGHT_TYPES for descriptions. |
| General Data Type: | VARCHAR2 |
REL_WGTDET
CC ID: 333549
| Seq. Order: | 43 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Weight determination code, see support table MRWEIGHT_DETERMINATION for descriptions. |
| General Data Type: | VARCHAR2 |
REL_RPTWEIGHT
CC ID: 333550
| Seq. Order: | 44 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 2 |
| Status: | Active |
| Description: |
Release Reported weight, for sharks, whole weight in kg. |
| General Data Type: | NUMBER |
REL_RPTWGTUOM
CC ID: 333551
| Seq. Order: | 45 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Unit of measure for reported weight (LB, KG). |
| General Data Type: | VARCHAR2 |
REL_RPTWGTQUAL
CC ID: 333552
| Seq. Order: | 46 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Reported weight quality code, see support table MRWEIGHT_QUALITY for descriptions. |
| General Data Type: | VARCHAR2 |
REL_RPTWGTTYPE
CC ID: 333553
| Seq. Order: | 47 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Reported weight type code, see support table MRWEIGHT_TYPES for descriptions. |
| General Data Type: | VARCHAR2 |
REL_SPCOND1
CC ID: 333554
| Seq. Order: | 48 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Special condition code, see support table MRSPECIAL_CONDITIONS for descriptions. |
| General Data Type: | VARCHAR2 |
REL_SPCOND2
CC ID: 333555
| Seq. Order: | 49 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Special condition code, see support table MRSPECIAL_CONDITIONS for descriptions.. |
| General Data Type: | VARCHAR2 |
REL_BIOSAMP1
CC ID: 333557
| Seq. Order: | 50 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Biological sample code, see support table MRBIO_SAMPLES for descriptions. |
| General Data Type: | VARCHAR2 |
REL_BIOSAMP2
CC ID: 333558
| Seq. Order: | 51 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Biological sample code, see support table MRBIO_SAMPLES for descriptions.. |
| General Data Type: | VARCHAR2 |
REL_LOCATION
CC ID: 333559
| Seq. Order: | 52 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Reported location, see MRLOCATIONS for descriptions. (redacted) |
| General Data Type: | VARCHAR2 |
REL_MILES
CC ID: 333560
| Seq. Order: | 53 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Release Miles from reported location (used for location calculation). (redacted) |
| General Data Type: | NUMBER |
REL_DIRECTION
CC ID: 333561
| Seq. Order: | 54 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 5 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Direction from reported location (used for location calculation). (redacted) |
| General Data Type: | VARCHAR2 |
REL_LORANCHAIN
CC ID: 333562
| Seq. Order: | 55 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Loran chain. (redacted) |
| General Data Type: | VARCHAR2 |
REL_LORAN1
CC ID: 333563
| Seq. Order: | 56 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Scale: | 2 |
| Status: | Active |
| Description: |
Release Loran x. (redacted) |
| General Data Type: | NUMBER |
REL_LORAN2
CC ID: 333564
| Seq. Order: | 57 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Scale: | 2 |
| Status: | Active |
| Description: |
Release Loran y. (redacted) |
| General Data Type: | NUMBER |
REL_LATDEG
CC ID: 333565
| Seq. Order: | 58 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Event latitude degrees. (redacted) |
| General Data Type: | VARCHAR2 |
REL_LATMIN
CC ID: 333566
| Seq. Order: | 59 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Event latitude minutes. (redacted) |
| General Data Type: | VARCHAR2 |
REL_LATSEC
CC ID: 333568
| Seq. Order: | 60 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Event latitude seconds. (redacted) |
| General Data Type: | VARCHAR2 |
REL_NOS
CC ID: 333569
| Seq. Order: | 61 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release North or south. (redacted) |
| General Data Type: | VARCHAR2 |
REL_DECLAT
CC ID: 333570
| Seq. Order: | 62 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release latitude in decimal degrees. (redacted) |
| General Data Type: | VARCHAR2 |
REL_LONDEG
CC ID: 333571
| Seq. Order: | 63 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Event longitude degrees. (redacted) |
| General Data Type: | VARCHAR2 |
REL_LONMIN
CC ID: 333572
| Seq. Order: | 64 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Event longitude minutes. (redacted) |
| General Data Type: | VARCHAR2 |
REL_LONSEC
CC ID: 333573
| Seq. Order: | 65 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Event longitude seconds. (redacted) |
| General Data Type: | VARCHAR2 |
REL_EOW
CC ID: 333574
| Seq. Order: | 66 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release East or west. (redacted) |
| General Data Type: | VARCHAR2 |
REL_DECLON
CC ID: 333575
| Seq. Order: | 67 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 11 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release longitude in decimal degrees. (redacted) |
| General Data Type: | VARCHAR2 |
REL_LOCQUAL
CC ID: 333576
| Seq. Order: | 68 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Data quality code for location, see MRLOC_QUALITY for descriptions. |
| General Data Type: | VARCHAR2 |
REL_DAYSFREE
CC ID: 333577
| Seq. Order: | 69 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 5 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Release Days free for recapture only. |
| General Data Type: | NUMBER |
REL_DISTTRAVEL
CC ID: 333579
| Seq. Order: | 70 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 5 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Release Distance traveled in nautical miles for recapture only, distance traveled is calculated with great circle formula. |
| General Data Type: | NUMBER |
REL_TRAVELDEG
CC ID: 333580
| Seq. Order: | 71 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 1 |
| Status: | Active |
| Description: |
Release Travel direction for recapture only, see MRDIRECTIONS for descriptions. |
| General Data Type: | NUMBER |
REL_TRAVELDIR
CC ID: 333581
| Seq. Order: | 72 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Calculated angle for direction traveled, rounded to 1 decimal position. For ytf, bsb, and scup, angle is calculated using magnetic north, shark angle is calculated using polar north.. |
| General Data Type: | VARCHAR2 |
REL_DEPTH
CC ID: 333582
| Seq. Order: | 73 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Release Depth. |
| General Data Type: | NUMBER |
REL_DEPTHUOM
CC ID: 333583
| Seq. Order: | 74 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Unit of measure used for depth (FM, FT, M). |
| General Data Type: | VARCHAR2 |
REL_CONTACTID
CC ID: 333584
| Seq. Order: | 75 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Release Contact id for event. |
| General Data Type: | NUMBER |
REL_INDUSTRY
CC ID: 333585
| Seq. Order: | 76 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Industry (category, sector) at time of event, see support table MRINDUSTRY for descriptions. |
| General Data Type: | VARCHAR2 |
REL_OCCUPATION
CC ID: 333586
| Seq. Order: | 77 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Occupation at time of event, see support table MROCCUPATION for descriptions. |
| General Data Type: | VARCHAR2 |
REL_GEAR
CC ID: 333587
| Seq. Order: | 78 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Gear used, see support table MRGEARS for descriptions. |
| General Data Type: | VARCHAR2 |
REL_SHVESSEL
CC ID: 333588
| Seq. Order: | 79 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Vessel code used by the shark fishery, see support table MRSHVESSELS for descriptions. |
| General Data Type: | VARCHAR2 |
REL_VESS_NATION
CC ID: 333590
| Seq. Order: | 80 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Vessel nation at time of event, see support table MRNATIONS for descriptions. |
| General Data Type: | VARCHAR2 |
REL_WEB_DOE
CC ID: 333591
| Seq. Order: | 81 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Date of Last Entry from Web Application. |
| General Data Type: | DATE |
REL_WEB_UOE
CC ID: 333592
| Seq. Order: | 82 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release User of Last Entry from Web Application. |
| General Data Type: | VARCHAR2 |
REL_WEB_DOC
CC ID: 333593
| Seq. Order: | 83 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Date of Last Change from Web Application. |
| General Data Type: | DATE |
REL_WEB_UOC
CC ID: 333594
| Seq. Order: | 84 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release User of Last Change from Web Application. |
| General Data Type: | VARCHAR2 |
REC_EVENTNUM
CC ID: 333595
| Seq. Order: | 85 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 3 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Recapture event number. |
| General Data Type: | NUMBER |
REC_TAG_TYPE
CC ID: 333596
| Seq. Order: | 86 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Style of tag, see support table MRTAGTYPES for descriptions. |
| General Data Type: | VARCHAR2 |
REC_TAG_COLOR
CC ID: 333597
| Seq. Order: | 87 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Color of tag, see support table MRTAGCOLORS for descriptions. |
| General Data Type: | VARCHAR2 |
REC_TAG_NUMBER
CC ID: 333598
| Seq. Order: | 88 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 6 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Tag identification number. |
| General Data Type: | VARCHAR2 |
REC_TAG_SUFFIX
CC ID: 333599
| Seq. Order: | 89 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Tag suffix. |
| General Data Type: | VARCHAR2 |
REC_TAG_REWARD
CC ID: 333601
| Seq. Order: | 90 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Reward for tag Recapture or recapture, see support table MRTAGREWARDS for descriptions. |
| General Data Type: | VARCHAR2 |
REC_TAG_FATE
CC ID: 333602
| Seq. Order: | 91 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Fate of tag, see support table MRTAGFATES for descriptions. |
| General Data Type: | VARCHAR2 |
REC_TAG_CONDITION
CC ID: 333603
| Seq. Order: | 92 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Condition of tag, see support table MRTAGCONDITIONS for descriptions. |
| General Data Type: | VARCHAR2 |
REC_TAG_SITE
CC ID: 333604
| Seq. Order: | 93 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Area of tag at recapture, see support table MRTAGSITE for descriptions. |
| General Data Type: | VARCHAR2 |
REC_TAG_LOCONFISH
CC ID: 333605
| Seq. Order: | 94 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Location on fish where tag is attached, see support table MRTAGLOCONFISH for descriptions. |
| General Data Type: | VARCHAR2 |
REC_TRIPID
CC ID: 333606
| Seq. Order: | 95 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Trip identification code. |
| General Data Type: | VARCHAR2 |
REC_HAULNUM
CC ID: 333607
| Seq. Order: | 96 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Ordinal number of the haul within the trip, set number for shark cruises. |
| General Data Type: | VARCHAR2 |
REC_TYPE
CC ID: 333608
| Seq. Order: | 97 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Event type, see support table MREVENTTYPES for descriptions. |
| General Data Type: | VARCHAR2 |
REC_MONTH
CC ID: 333609
| Seq. Order: | 98 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Month of event. |
| General Data Type: | VARCHAR2 |
REC_DAY
CC ID: 333610
| Seq. Order: | 99 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Day of event. |
| General Data Type: | VARCHAR2 |
REC_YEAR
CC ID: 333447
| Seq. Order: | 100 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Year of event. |
| General Data Type: | VARCHAR2 |
REC_DATEQUAL
CC ID: 333448
| Seq. Order: | 101 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Date quality, see support table MRDATE_QUALITY for descriptions. |
| General Data Type: | VARCHAR2 |
REC_COMMENTS
CC ID: 333449
| Seq. Order: | 102 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 200 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Comments or remarks. |
| General Data Type: | VARCHAR2 |
REC_SPECIES_ITIS
CC ID: 333450
| Seq. Order: | 103 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 11 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Itis species code, see support table MRSPECIES for descriptions, corresponding survey and shark species codes also in MRSPECIES. |
| General Data Type: | VARCHAR2 |
REC_SEX
CC ID: 333451
| Seq. Order: | 104 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Sex ( 0 = male, 1 = female). |
| General Data Type: | VARCHAR2 |
REC_FISHCOND
CC ID: 333452
| Seq. Order: | 105 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Condition of fish at event, see support table MRFISH_CONDITIONS for descriptions. |
| General Data Type: | VARCHAR2 |
REC_FISHFATE
CC ID: 333453
| Seq. Order: | 106 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Fate of fish at event, see support table MRFISH_FATES for descriptions. |
| General Data Type: | VARCHAR2 |
REC_LIFESTAGE
CC ID: 333454
| Seq. Order: | 107 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Lifestage of fish at event, see support table MRLIFESTAGES for descriptions. |
| General Data Type: | VARCHAR2 |
REC_LENGTH
CC ID: 333455
| Seq. Order: | 108 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 2 |
| Status: | Active |
| Description: |
Recapture Length, for sharks: fork length in centimeters . |
| General Data Type: | NUMBER |
REC_LENUOM
CC ID: 333456
| Seq. Order: | 109 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Unit of measure for length (CM, IN). |
| General Data Type: | VARCHAR2 |
REC_LENQUAL
CC ID: 333458
| Seq. Order: | 110 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Data quality code for length, see support table MRLENGTH_QUALITY for descriptions. |
| General Data Type: | VARCHAR2 |
REC_LENTYPE
CC ID: 333459
| Seq. Order: | 111 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Length type code, see support table MRLENGTH_TYPES for descriptions. |
| General Data Type: | VARCHAR2 |
REC_LENDET
CC ID: 333460
| Seq. Order: | 112 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Length determination code, see support table MRLENGTH_DETERMINATION for descriptions. |
| General Data Type: | VARCHAR2 |
REC_RPTLENGTH
CC ID: 333461
| Seq. Order: | 113 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 2 |
| Status: | Active |
| Description: |
Recapture Reported length measurement. |
| General Data Type: | NUMBER |
REC_RPTLENUOM
CC ID: 333462
| Seq. Order: | 114 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Unit of measure for reported length (CM, IN). |
| General Data Type: | VARCHAR2 |
REC_RPTLENQUAL
CC ID: 333463
| Seq. Order: | 115 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Data quality code for reported length, see support table MRLENGTH_QUALITY for descriptions. |
| General Data Type: | VARCHAR2 |
REC_RPTLENTYPE
CC ID: 333464
| Seq. Order: | 116 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Reported length type code, see support table MRLENGTH_TYPES for descriptions. |
| General Data Type: | VARCHAR2 |
REC_OTHLENGTH
CC ID: 333465
| Seq. Order: | 117 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 2 |
| Status: | Active |
| Description: |
Recapture Other length measurement. |
| General Data Type: | NUMBER |
REC_OTHLENUOM
CC ID: 333466
| Seq. Order: | 118 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Unit of measure for other length (CM, IN). |
| General Data Type: | VARCHAR2 |
REC_OTHLENQUAL
CC ID: 333467
| Seq. Order: | 119 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Data quality code for other length, see support table MRLENGTH_QUALITY for descriptions. |
| General Data Type: | VARCHAR2 |
REC_OTHLENTYPE
CC ID: 333469
| Seq. Order: | 120 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Other length type code, see support table MRLENGTH_TYPES for descriptions. |
| General Data Type: | VARCHAR2 |
REC_WEIGHT
CC ID: 333470
| Seq. Order: | 121 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 2 |
| Status: | Active |
| Description: |
Recapture Weight, for sharks, whole weight in kg. |
| General Data Type: | NUMBER |
REC_WGTUOM
CC ID: 333471
| Seq. Order: | 122 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Unit of measure for weight (LB, KG). |
| General Data Type: | VARCHAR2 |
REC_WGTQUAL
CC ID: 333472
| Seq. Order: | 123 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Weight quality code, see support table MRWEIGHT_QUALITY for descriptions. |
| General Data Type: | VARCHAR2 |
REC_WGTTYPE
CC ID: 333473
| Seq. Order: | 124 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Weight type code, see support table MRWEIGHT_TYPES for descriptions. |
| General Data Type: | VARCHAR2 |
REC_WGTDET
CC ID: 333474
| Seq. Order: | 125 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Weight determination code, see support table MRWEIGHT_DETERMINATION for descriptions. |
| General Data Type: | VARCHAR2 |
REC_RPTWEIGHT
CC ID: 333475
| Seq. Order: | 126 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 2 |
| Status: | Active |
| Description: |
Recapture Reported weight, for sharks, whole weight in kg. |
| General Data Type: | NUMBER |
REC_RPTWGTUOM
CC ID: 333476
| Seq. Order: | 127 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Unit of measure for reported weight (LB, KG). |
| General Data Type: | VARCHAR2 |
REC_RPTWGTQUAL
CC ID: 333477
| Seq. Order: | 128 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Reported weight quality code, see support table MRWEIGHT_QUALITY for descriptions. |
| General Data Type: | VARCHAR2 |
REC_RPTWGTTYPE
CC ID: 333478
| Seq. Order: | 129 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Reported weight type code, see support table MRWEIGHT_TYPES for descriptions. |
| General Data Type: | VARCHAR2 |
REC_SPCOND1
CC ID: 333480
| Seq. Order: | 130 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Special condition code, see support table MRSPECIAL_CONDITIONS for descriptions. |
| General Data Type: | VARCHAR2 |
REC_SPCOND2
CC ID: 333481
| Seq. Order: | 131 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Special condition code, see support table MRSPECIAL_CONDITIONS for descriptions.. |
| General Data Type: | VARCHAR2 |
REC_BIOSAMP1
CC ID: 333482
| Seq. Order: | 132 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Biological sample code, see support table MRBIO_SAMPLES for descriptions. |
| General Data Type: | VARCHAR2 |
REC_BIOSAMP2
CC ID: 333483
| Seq. Order: | 133 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Biological sample code, see support table MRBIO_SAMPLES for descriptions.. |
| General Data Type: | VARCHAR2 |
REC_LOCATION
CC ID: 333484
| Seq. Order: | 134 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Reported location, see MRLOCATIONS for descriptions. (redacted) |
| General Data Type: | VARCHAR2 |
REC_MILES
CC ID: 333485
| Seq. Order: | 135 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Recapture Miles from reported location (used for location calculation). (redacted) |
| General Data Type: | NUMBER |
REC_DIRECTION
CC ID: 333486
| Seq. Order: | 136 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 5 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Direction from reported location (used for location calculation). (redacted) |
| General Data Type: | VARCHAR2 |
REC_LORANCHAIN
CC ID: 333487
| Seq. Order: | 137 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Loran chain. (redacted) |
| General Data Type: | VARCHAR2 |
REC_LORAN1
CC ID: 333488
| Seq. Order: | 138 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Scale: | 2 |
| Status: | Active |
| Description: |
Recapture Loran x. (redacted) |
| General Data Type: | NUMBER |
REC_LORAN2
CC ID: 333489
| Seq. Order: | 139 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Scale: | 2 |
| Status: | Active |
| Description: |
Recapture Loran y. (redacted) |
| General Data Type: | NUMBER |
REC_LATDEG
CC ID: 333491
| Seq. Order: | 140 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Event latitude degrees. (redacted) |
| General Data Type: | VARCHAR2 |
REC_LATMIN
CC ID: 333492
| Seq. Order: | 141 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Event latitude minutes. (redacted) |
| General Data Type: | VARCHAR2 |
REC_LATSEC
CC ID: 333493
| Seq. Order: | 142 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Event latitude seconds. (redacted) |
| General Data Type: | VARCHAR2 |
REC_NOS
CC ID: 333494
| Seq. Order: | 143 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture North or south. (redacted) |
| General Data Type: | VARCHAR2 |
REC_DECLAT
CC ID: 333495
| Seq. Order: | 144 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Latitude in decimal degrees. (redacted) |
| General Data Type: | VARCHAR2 |
REC_LONDEG
CC ID: 333496
| Seq. Order: | 145 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Event longitude degrees. (redacted) |
| General Data Type: | VARCHAR2 |
REC_LONMIN
CC ID: 333497
| Seq. Order: | 146 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Event longitude minutes. (redacted) |
| General Data Type: | VARCHAR2 |
REC_LONSEC
CC ID: 333498
| Seq. Order: | 147 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Event longitude seconds. (redacted) |
| General Data Type: | VARCHAR2 |
REC_EOW
CC ID: 333499
| Seq. Order: | 148 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture East or west. (redacted) |
| General Data Type: | VARCHAR2 |
REC_DECLON
CC ID: 333500
| Seq. Order: | 149 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 11 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Longitude in decimal degrees. (redacted) |
| General Data Type: | VARCHAR2 |
REC_LOCQUAL
CC ID: 333502
| Seq. Order: | 150 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Data quality code for location, see MRLOC_QUALITY for descriptions. |
| General Data Type: | VARCHAR2 |
REC_DAYSFREE
CC ID: 333503
| Seq. Order: | 151 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 5 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Recapture Days free for recapture only. |
| General Data Type: | NUMBER |
REC_DISTTRAVEL
CC ID: 333504
| Seq. Order: | 152 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 5 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Recapture Distance traveled in nautical miles for recapture only, distance traveled is calculated with great circle formula. |
| General Data Type: | NUMBER |
REC_TRAVELDEG
CC ID: 333505
| Seq. Order: | 153 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 1 |
| Status: | Active |
| Description: |
Recapture Travel direction for recapture only, see MRDIRECTIONS for descriptions. |
| General Data Type: | NUMBER |
REC_TRAVELDIR
CC ID: 333506
| Seq. Order: | 154 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Calculated angle for direction traveled, rounded to 1 decimal position. For ytf, bsb, and scup, angle is calculated using magnetic north, shark angle is calculated using polar north.. |
| General Data Type: | VARCHAR2 |
REC_DEPTH
CC ID: 333507
| Seq. Order: | 155 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Recapture Depth. |
| General Data Type: | NUMBER |
REC_DEPTHUOM
CC ID: 333508
| Seq. Order: | 156 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Unit of measure used for depth (FM, FT, M). |
| General Data Type: | VARCHAR2 |
REC_CONTACTID
CC ID: 333509
| Seq. Order: | 157 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Recapture Contact id for event. |
| General Data Type: | NUMBER |
REC_INDUSTRY
CC ID: 333510
| Seq. Order: | 158 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Industry (category, sector) at time of event, see support table MRINDUSTRY for descriptions. |
| General Data Type: | VARCHAR2 |
REC_OCCUPATION
CC ID: 333511
| Seq. Order: | 159 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Occupation at time of event, see support table MROCCUPATION for descriptions. |
| General Data Type: | VARCHAR2 |
REC_GEAR
CC ID: 333513
| Seq. Order: | 160 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Gear used, see support table MRGEARS for descriptions. |
| General Data Type: | VARCHAR2 |
REC_SHVESSEL
CC ID: 333514
| Seq. Order: | 161 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Vessel code used by the shark fishery, see support table MRSHVESSELS for descriptions. |
| General Data Type: | VARCHAR2 |
REC_VESS_NATION
CC ID: 333515
| Seq. Order: | 162 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Vessel nation at time of event, see support table MRNATIONS for descriptions. |
| General Data Type: | VARCHAR2 |
REC_WEB_DOE
CC ID: 333516
| Seq. Order: | 163 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Date of Last Entry from Web Application. |
| General Data Type: | DATE |
REC_WEB_UOE
CC ID: 333517
| Seq. Order: | 164 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture User of Last Entry from Web Application. |
| General Data Type: | VARCHAR2 |
REC_WEB_DOC
CC ID: 333518
| Seq. Order: | 165 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Date of Last Change from Web Application. |
| General Data Type: | DATE |
REC_WEB_UOC
CC ID: 333519
| Seq. Order: | 166 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture User of Last Change from Web Application. |
| General Data Type: | VARCHAR2 |
Catalog Details
| Catalog Item ID: | 33547 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:33547 |
| Metadata Record Created By: | Patricia L Jones |
| Metadata Record Created: | 2016-07-27 15:26+0000 |
| Metadata Record Last Modified By: | SysAdmin InPortAdmin |
| Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
| Metadata Record Published: | 2016-08-01 |
| Owner Org: | NEFSC |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2016-08-01 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2017-08-01 |