Table: MRMVRELRECAP03
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:36251 | Updated: August 9, 2022 | Published / External
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
|
|
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 |