Table: MRMVRELRECAP03
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34794 | Updated: August 9, 2022 | Published / External
Item Identification
| Title: | Table: MRMVRELRECAP03 |
|---|---|
| Short Name: | MRMVRELRECAP03 |
| Status: | Completed |
| Abstract: |
no-comment |
| Notes: |
Loaded by batch 9270, 09-13-2016 10:42 |
Entity Information
| Entity Type: | Data Table |
|---|---|
| Active Version?: | Yes |
| Schema Name: | MRDBS |
| Description: |
no-comment |
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
FISHERY | VARCHAR2 | Fishery Code, a two character fishery identification code. See support table MRFISHERY for codes and descriptions. | |
|
100
|
ANIMALID | VARCHAR2 | Animal identification code, animal id will be a concatenation of fishery, original tag type, color, number, and suffix. | |
|
100
|
REL_EVENTNUM | NUMBER | Release event number. | |
|
100
|
REL_TAG_TYPE | VARCHAR2 | Release Style of tag, see support table MRTAGTYPES for descriptions. | |
|
100
|
REL_TAG_COLOR | VARCHAR2 | Release Color of tag, see support table MRTAGCOLORS for descriptions. | |
|
100
|
REL_TAG_NUMBER | VARCHAR2 | Release Tag identification number | |
|
100
|
REL_TAG_SUFFIX | VARCHAR2 | Release Tag suffix. | |
|
100
|
REL_TAG_REWARD | VARCHAR2 | Release Reward for tag Recapture or recapture, see support table MRTAGREWARDS for descriptions. | |
|
100
|
REL_TAG_FATE | VARCHAR2 | Release Fate of tag, see support table MRTAGFATES for descriptions. | |
|
100
|
REL_TAG_CONDITION | VARCHAR2 | Release Condition of tag, see support table MRTAGCONDITIONS for descriptions. | |
|
100
|
REL_TAG_SITE | VARCHAR2 | Release Area of tag at recapture, see support table MRTAGSITE for descriptions. | |
|
100
|
REL_TAG_LOCONFISH | VARCHAR2 | Release Location on fish where tag is attached, see support table MRTAGLOCONFISH for descriptions. | |
|
100
|
REL_TRIPID | VARCHAR2 | Release Trip identification code. | |
|
100
|
REL_HAULNUM | VARCHAR2 | Release Ordinal number of the haul within the trip, set number for shark cruises. | |
|
100
|
REL_TYPE | VARCHAR2 | Release Event type, see support table MREVENTTYPES for descriptions. | |
|
100
|
REL_MONTH | VARCHAR2 | Release Month of event. | |
|
100
|
REL_DAY | VARCHAR2 | Release Day of event. | |
|
100
|
REL_YEAR | VARCHAR2 | Release Year of event. | |
|
100
|
REL_DATEQUAL | VARCHAR2 | Release Date quality, see support table MRDATE_QUALITY for descriptions. | |
|
100
|
REL_COMMENTS | VARCHAR2 | Release Comments or remarks. | |
|
100
|
REL_SPECIES_ITIS | VARCHAR2 | Release Itis species code, see support table MRSPECIES for descriptions, corresponding survey and shark species codes also in MRSPECIES. | |
|
100
|
REL_SEX | VARCHAR2 | Release Sex ( 0 = male, 1 = female). | |
|
100
|
REL_FISHCOND | VARCHAR2 | Release Condition of fish at event, see support table MRFISH_CONDITIONS for descriptions. | |
|
100
|
REL_FISHFATE | VARCHAR2 | Release Fate of fish at event, see support table MRFISH_FATES for descriptions. | |
|
100
|
REL_LIFESTAGE | VARCHAR2 | Release Lifestage of fish at event, see support table MRLIFESTAGES for descriptions. | |
|
100
|
REL_LENGTH | NUMBER | Release Length, for sharks: fork length in centimeters . | |
|
100
|
REL_LENUOM | VARCHAR2 | Release Unit of measure for length (CM, IN). | |
|
100
|
REL_LENQUAL | VARCHAR2 | Release Data quality code for length, see support table MRLENGTH_QUALITY for descriptions. | |
|
100
|
REL_LENTYPE | VARCHAR2 | Release Length type code, see support table MRLENGTH_TYPES for descriptions. | |
|
100
|
REL_LENDET | VARCHAR2 | Release Length determination code, see support table MRLENGTH_DETERMINATION for descriptions. | |
|
100
|
REL_RPTLENGTH | NUMBER | Release Reported length measurement. | |
|
100
|
REL_RPTLENUOM | VARCHAR2 | Release Unit of measure for reported length (CM, IN). | |
|
100
|
REL_RPTLENQUAL | VARCHAR2 | Release Data quality code for reported length, see support table MRLENGTH_QUALITY for descriptions. | |
|
100
|
REL_RPTLENTYPE | VARCHAR2 | Release Reported length type code, see support table MRLENGTH_TYPES for descriptions. | |
|
100
|
REL_OTHLENGTH | NUMBER | Release Other length measurement. | |
|
100
|
REL_OTHLENUOM | VARCHAR2 | Release Unit of measure for other length (CM, IN). | |
|
100
|
REL_OTHLENQUAL | VARCHAR2 | Release Data quality code for other length, see support table MRLENGTH_QUALITY for descriptions. | |
|
100
|
REL_OTHLENTYPE | VARCHAR2 | Release Other length type code, see support table MRLENGTH_TYPES for descriptions. | |
|
100
|
REL_WEIGHT | NUMBER | Release Weight, for sharks, whole weight in kg. | |
|
100
|
REL_WGTUOM | VARCHAR2 | Release Unit of measure for weight (LB, KG). | |
|
100
|
REL_WGTQUAL | VARCHAR2 | Release Weight quality code, see support table MRWEIGHT_QUALITY for descriptions. | |
|
100
|
REL_WGTTYPE | VARCHAR2 | Release Weight type code, see support table MRWEIGHT_TYPES for descriptions. | |
|
100
|
REL_WGTDET | VARCHAR2 | Release Weight determination code, see support table MRWEIGHT_DETERMINATION for descriptions. | |
|
100
|
REL_RPTWEIGHT | NUMBER | Release Reported weight, for sharks, whole weight in kg. | |
|
100
|
REL_RPTWGTUOM | VARCHAR2 | Release Unit of measure for reported weight (LB, KG). | |
|
100
|
REL_RPTWGTQUAL | VARCHAR2 | Release Reported weight quality code, see support table MRWEIGHT_QUALITY for descriptions. | |
|
100
|
REL_RPTWGTTYPE | VARCHAR2 | Release Reported weight type code, see support table MRWEIGHT_TYPES for descriptions. | |
|
100
|
REL_SPCOND1 | VARCHAR2 | Release Special condition code, see support table MRSPECIAL_CONDITIONS for descriptions. | |
|
100
|
REL_SPCOND2 | VARCHAR2 | Release Special condition code, see support table MRSPECIAL_CONDITIONS for descriptions.. | |
|
100
|
REL_BIOSAMP1 | VARCHAR2 | Release Biological sample code, see support table MRBIO_SAMPLES for descriptions. | |
|
100
|
REL_BIOSAMP2 | VARCHAR2 | Release Biological sample code, see support table MRBIO_SAMPLES for descriptions.. | |
|
100
|
REL_LOCATION | VARCHAR2 | Release Reported location, see MRLOCATIONS for descriptions. (redacted) | |
|
100
|
REL_MILES | NUMBER | Release Miles from reported location (used for location calculation). (redacted) | |
|
100
|
REL_DIRECTION | VARCHAR2 | Release Direction from reported location (used for location calculation). (redacted) | |
|
100
|
REL_LORANCHAIN | VARCHAR2 | Release Loran chain. (redacted) | |
|
100
|
REL_LORAN1 | NUMBER | Release Loran x. (redacted) | |
|
100
|
REL_LORAN2 | NUMBER | Release Loran y. (redacted) | |
|
100
|
REL_LATDEG | VARCHAR2 | Release Event latitude degrees. (redacted) | |
|
100
|
REL_LATMIN | VARCHAR2 | Release Event latitude minutes. (redacted) | |
|
100
|
REL_LATSEC | VARCHAR2 | Release Event latitude seconds. (redacted) | |
|
100
|
REL_NOS | VARCHAR2 | Release North or south. (redacted) | |
|
100
|
REL_DECLAT | VARCHAR2 | Release latitude in decimal degrees. (redacted) | |
|
100
|
REL_LONDEG | VARCHAR2 | Release Event longitude degrees. (redacted) | |
|
100
|
REL_LONMIN | VARCHAR2 | Release Event longitude minutes. (redacted) | |
|
100
|
REL_LONSEC | VARCHAR2 | Release Event longitude seconds. (redacted) | |
|
100
|
REL_EOW | VARCHAR2 | Release East or west. (redacted) | |
|
100
|
REL_DECLON | VARCHAR2 | Release longitude in decimal degrees. (redacted) | |
|
100
|
REL_LOCQUAL | VARCHAR2 | Release Data quality code for location, see MRLOC_QUALITY for descriptions. | |
|
100
|
REL_DAYSFREE | NUMBER | Release Days free for recapture only. | |
|
100
|
REL_DISTTRAVEL | NUMBER | Release Distance traveled in nautical miles for recapture only, distance traveled is calculated with great circle formula. | |
|
100
|
REL_TRAVELDEG | NUMBER | Release Travel direction for recapture only, see MRDIRECTIONS for descriptions. | |
|
100
|
REL_TRAVELDIR | VARCHAR2 | Release Calculated angle for direction traveled, rounded to 1 decimal position. For ytf, bsb, and scup, angle is calculated using magnetic north, shark angle is calculated using polar north.. | |
|
100
|
REL_DEPTH | NUMBER | Release Depth. | |
|
100
|
REL_DEPTHUOM | VARCHAR2 | Release Unit of measure used for depth (FM, FT, M). | |
|
100
|
REL_CONTACTID | NUMBER | Release Contact id for event. | |
|
100
|
REL_INDUSTRY | VARCHAR2 | Release Industry (category, sector) at time of event, see support table MRINDUSTRY for descriptions. | |
|
100
|
REL_OCCUPATION | VARCHAR2 | Release Occupation at time of event, see support table MROCCUPATION for descriptions. | |
|
100
|
REL_GEAR | VARCHAR2 | Release Gear used, see support table MRGEARS for descriptions. | |
|
100
|
REL_SHVESSEL | VARCHAR2 | Release Vessel code used by the shark fishery, see support table MRSHVESSELS for descriptions. | |
|
100
|
REL_VESS_NATION | VARCHAR2 | Release Vessel nation at time of event, see support table MRNATIONS for descriptions. | |
|
100
|
REL_WEB_DOE | DATE | Release Date of Last Entry from Web Application. | |
|
100
|
REL_WEB_UOE | VARCHAR2 | Release User of Last Entry from Web Application. | |
|
100
|
REL_WEB_DOC | DATE | Release Date of Last Change from Web Application. | |
|
100
|
REL_WEB_UOC | VARCHAR2 | Release User of Last Change from Web Application. | |
|
100
|
REC_EVENTNUM | NUMBER | Recapture event number. | |
|
100
|
REC_TAG_TYPE | VARCHAR2 | Recapture Style of tag, see support table MRTAGTYPES for descriptions. | |
|
100
|
REC_TAG_COLOR | VARCHAR2 | Recapture Color of tag, see support table MRTAGCOLORS for descriptions. | |
|
100
|
REC_TAG_NUMBER | VARCHAR2 | Recapture Tag identification number. | |
|
100
|
REC_TAG_SUFFIX | VARCHAR2 | Recapture Tag suffix. | |
|
100
|
REC_TAG_REWARD | VARCHAR2 | Recapture Reward for tag Recapture or recapture, see support table MRTAGREWARDS for descriptions. | |
|
100
|
REC_TAG_FATE | VARCHAR2 | Recapture Fate of tag, see support table MRTAGFATES for descriptions. | |
|
100
|
REC_TAG_CONDITION | VARCHAR2 | Recapture Condition of tag, see support table MRTAGCONDITIONS for descriptions. | |
|
100
|
REC_TAG_SITE | VARCHAR2 | Recapture Area of tag at recapture, see support table MRTAGSITE for descriptions. | |
|
100
|
REC_TAG_LOCONFISH | VARCHAR2 | Recapture Location on fish where tag is attached, see support table MRTAGLOCONFISH for descriptions. | |
|
100
|
REC_TRIPID | VARCHAR2 | Recapture Trip identification code. | |
|
100
|
REC_HAULNUM | VARCHAR2 | Recapture Ordinal number of the haul within the trip, set number for shark cruises. | |
|
100
|
REC_TYPE | VARCHAR2 | Recapture Event type, see support table MREVENTTYPES for descriptions. | |
|
100
|
REC_MONTH | VARCHAR2 | Recapture Month of event. | |
|
100
|
REC_DAY | VARCHAR2 | Recapture Day of event. | |
|
100
|
REC_YEAR | VARCHAR2 | Recapture Year of event. | |
|
100
|
REC_DATEQUAL | VARCHAR2 | Recapture Date quality, see support table MRDATE_QUALITY for descriptions. | |
|
100
|
REC_COMMENTS | VARCHAR2 | Recapture Comments or remarks. | |
|
100
|
REC_SPECIES_ITIS | VARCHAR2 | Recapture Itis species code, see support table MRSPECIES for descriptions, corresponding survey and shark species codes also in MRSPECIES. | |
|
100
|
REC_SEX | VARCHAR2 | Recapture Sex ( 0 = male, 1 = female). | |
|
100
|
REC_FISHCOND | VARCHAR2 | Recapture Condition of fish at event, see support table MRFISH_CONDITIONS for descriptions. | |
|
100
|
REC_FISHFATE | VARCHAR2 | Recapture Fate of fish at event, see support table MRFISH_FATES for descriptions. | |
|
100
|
REC_LIFESTAGE | VARCHAR2 | Recapture Lifestage of fish at event, see support table MRLIFESTAGES for descriptions. | |
|
100
|
REC_LENGTH | NUMBER | Recapture Length, for sharks: fork length in centimeters . | |
|
100
|
REC_LENUOM | VARCHAR2 | Recapture Unit of measure for length (CM, IN). | |
|
100
|
REC_LENQUAL | VARCHAR2 | Recapture Data quality code for length, see support table MRLENGTH_QUALITY for descriptions. | |
|
100
|
REC_LENTYPE | VARCHAR2 | Recapture Length type code, see support table MRLENGTH_TYPES for descriptions. | |
|
100
|
REC_LENDET | VARCHAR2 | Recapture Length determination code, see support table MRLENGTH_DETERMINATION for descriptions. | |
|
100
|
REC_RPTLENGTH | NUMBER | Recapture Reported length measurement. | |
|
100
|
REC_RPTLENUOM | VARCHAR2 | Recapture Unit of measure for reported length (CM, IN). | |
|
100
|
REC_RPTLENQUAL | VARCHAR2 | Recapture Data quality code for reported length, see support table MRLENGTH_QUALITY for descriptions. | |
|
100
|
REC_RPTLENTYPE | VARCHAR2 | Recapture Reported length type code, see support table MRLENGTH_TYPES for descriptions. | |
|
100
|
REC_OTHLENGTH | NUMBER | Recapture Other length measurement. | |
|
100
|
REC_OTHLENUOM | VARCHAR2 | Recapture Unit of measure for other length (CM, IN). | |
|
100
|
REC_OTHLENQUAL | VARCHAR2 | Recapture Data quality code for other length, see support table MRLENGTH_QUALITY for descriptions. | |
|
100
|
REC_OTHLENTYPE | VARCHAR2 | Recapture Other length type code, see support table MRLENGTH_TYPES for descriptions. | |
|
100
|
REC_WEIGHT | NUMBER | Recapture Weight, for sharks, whole weight in kg. | |
|
100
|
REC_WGTUOM | VARCHAR2 | Recapture Unit of measure for weight (LB, KG). | |
|
100
|
REC_WGTQUAL | VARCHAR2 | Recapture Weight quality code, see support table MRWEIGHT_QUALITY for descriptions. | |
|
100
|
REC_WGTTYPE | VARCHAR2 | Recapture Weight type code, see support table MRWEIGHT_TYPES for descriptions. | |
|
100
|
REC_WGTDET | VARCHAR2 | Recapture Weight determination code, see support table MRWEIGHT_DETERMINATION for descriptions. | |
|
100
|
REC_RPTWEIGHT | NUMBER | Recapture Reported weight, for sharks, whole weight in kg. | |
|
100
|
REC_RPTWGTUOM | VARCHAR2 | Recapture Unit of measure for reported weight (LB, KG). | |
|
100
|
REC_RPTWGTQUAL | VARCHAR2 | Recapture Reported weight quality code, see support table MRWEIGHT_QUALITY for descriptions. | |
|
100
|
REC_RPTWGTTYPE | VARCHAR2 | Recapture Reported weight type code, see support table MRWEIGHT_TYPES for descriptions. | |
|
100
|
REC_SPCOND1 | VARCHAR2 | Recapture Special condition code, see support table MRSPECIAL_CONDITIONS for descriptions. | |
|
100
|
REC_SPCOND2 | VARCHAR2 | Recapture Special condition code, see support table MRSPECIAL_CONDITIONS for descriptions.. | |
|
100
|
REC_BIOSAMP1 | VARCHAR2 | Recapture Biological sample code, see support table MRBIO_SAMPLES for descriptions. | |
|
100
|
REC_BIOSAMP2 | VARCHAR2 | Recapture Biological sample code, see support table MRBIO_SAMPLES for descriptions.. | |
|
100
|
REC_LOCATION | VARCHAR2 | Recapture Reported location, see MRLOCATIONS for descriptions. (redacted) | |
|
100
|
REC_MILES | NUMBER | Recapture Miles from reported location (used for location calculation). (redacted) | |
|
100
|
REC_DIRECTION | VARCHAR2 | Recapture Direction from reported location (used for location calculation). (redacted) | |
|
100
|
REC_LORANCHAIN | VARCHAR2 | Recapture Loran chain. (redacted) | |
|
100
|
REC_LORAN1 | NUMBER | Recapture Loran x. (redacted) | |
|
100
|
REC_LORAN2 | NUMBER | Recapture Loran y. (redacted) | |
|
100
|
REC_LATDEG | VARCHAR2 | Recapture Event latitude degrees. (redacted) | |
|
100
|
REC_LATMIN | VARCHAR2 | Recapture Event latitude minutes. (redacted) | |
|
100
|
REC_LATSEC | VARCHAR2 | Recapture Event latitude seconds. (redacted) | |
|
100
|
REC_NOS | VARCHAR2 | Recapture North or south. (redacted) | |
|
100
|
REC_DECLAT | VARCHAR2 | Recapture Latitude in decimal degrees. (redacted) | |
|
100
|
REC_LONDEG | VARCHAR2 | Recapture Event longitude degrees. (redacted) | |
|
100
|
REC_LONMIN | VARCHAR2 | Recapture Event longitude minutes. (redacted) | |
|
100
|
REC_LONSEC | VARCHAR2 | Recapture Event longitude seconds. (redacted) | |
|
100
|
REC_EOW | VARCHAR2 | Recapture East or west. (redacted) | |
|
100
|
REC_DECLON | VARCHAR2 | Recapture Longitude in decimal degrees. (redacted) | |
|
100
|
REC_LOCQUAL | VARCHAR2 | Recapture Data quality code for location, see MRLOC_QUALITY for descriptions. | |
|
100
|
REC_DAYSFREE | NUMBER | Recapture Days free for recapture only. | |
|
100
|
REC_DISTTRAVEL | NUMBER | Recapture Distance traveled in nautical miles for recapture only, distance traveled is calculated with great circle formula. | |
|
100
|
REC_TRAVELDEG | NUMBER | Recapture Travel direction for recapture only, see MRDIRECTIONS for descriptions. | |
|
100
|
REC_TRAVELDIR | VARCHAR2 | Recapture Calculated angle for direction traveled, rounded to 1 decimal position. For ytf, bsb, and scup, angle is calculated using magnetic north, shark angle is calculated using polar north.. | |
|
100
|
REC_DEPTH | NUMBER | Recapture Depth. | |
|
100
|
REC_DEPTHUOM | VARCHAR2 | Recapture Unit of measure used for depth (FM, FT, M). | |
|
100
|
REC_CONTACTID | NUMBER | Recapture Contact id for event. | |
|
100
|
REC_INDUSTRY | VARCHAR2 | Recapture Industry (category, sector) at time of event, see support table MRINDUSTRY for descriptions. | |
|
100
|
REC_OCCUPATION | VARCHAR2 | Recapture Occupation at time of event, see support table MROCCUPATION for descriptions. | |
|
100
|
REC_GEAR | VARCHAR2 | Recapture Gear used, see support table MRGEARS for descriptions. | |
|
100
|
REC_SHVESSEL | VARCHAR2 | Recapture Vessel code used by the shark fishery, see support table MRSHVESSELS for descriptions. | |
|
100
|
REC_VESS_NATION | VARCHAR2 | Recapture Vessel nation at time of event, see support table MRNATIONS for descriptions. | |
|
100
|
REC_WEB_DOE | DATE | Recapture Date of Last Entry from Web Application. | |
|
100
|
REC_WEB_UOE | VARCHAR2 | Recapture User of Last Entry from Web Application. | |
|
100
|
REC_WEB_DOC | DATE | Recapture Date of Last Change from Web Application. | |
|
100
|
REC_WEB_UOC | VARCHAR2 | Recapture User of Last Change from Web Application. |
Attribute Details
FISHERY
CC ID: 349214
| Seq. Order: | 1 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Fishery Code, a two character fishery identification code. See support table MRFISHERY for codes and descriptions. |
| General Data Type: | VARCHAR2 |
ANIMALID
CC ID: 349292
| Seq. Order: | 2 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 14 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Animal identification code, animal id will be a concatenation of fishery, original tag type, color, number, and suffix. |
| General Data Type: | VARCHAR2 |
REL_EVENTNUM
CC ID: 349303
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 38 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Release event number. |
| General Data Type: | NUMBER |
REL_TAG_TYPE
CC ID: 349314
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Style of tag, see support table MRTAGTYPES for descriptions. |
| General Data Type: | VARCHAR2 |
REL_TAG_COLOR
CC ID: 349325
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Color of tag, see support table MRTAGCOLORS for descriptions. |
| General Data Type: | VARCHAR2 |
REL_TAG_NUMBER
CC ID: 349336
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 6 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Tag identification number |
| General Data Type: | VARCHAR2 |
REL_TAG_SUFFIX
CC ID: 349347
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Tag suffix. |
| General Data Type: | VARCHAR2 |
REL_TAG_REWARD
CC ID: 349358
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Reward for tag Recapture or recapture, see support table MRTAGREWARDS for descriptions. |
| General Data Type: | VARCHAR2 |
REL_TAG_FATE
CC ID: 349369
| Seq. Order: | 9 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Fate of tag, see support table MRTAGFATES for descriptions. |
| General Data Type: | VARCHAR2 |
REL_TAG_CONDITION
CC ID: 349215
| Seq. Order: | 10 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Condition of tag, see support table MRTAGCONDITIONS for descriptions. |
| General Data Type: | VARCHAR2 |
REL_TAG_SITE
CC ID: 349226
| Seq. Order: | 11 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Area of tag at recapture, see support table MRTAGSITE for descriptions. |
| General Data Type: | VARCHAR2 |
REL_TAG_LOCONFISH
CC ID: 349237
| Seq. Order: | 12 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Location on fish where tag is attached, see support table MRTAGLOCONFISH for descriptions. |
| General Data Type: | VARCHAR2 |
REL_TRIPID
CC ID: 349248
| Seq. Order: | 13 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Trip identification code. |
| General Data Type: | VARCHAR2 |
REL_HAULNUM
CC ID: 349259
| Seq. Order: | 14 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Ordinal number of the haul within the trip, set number for shark cruises. |
| General Data Type: | VARCHAR2 |
REL_TYPE
CC ID: 349270
| Seq. Order: | 15 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Event type, see support table MREVENTTYPES for descriptions. |
| General Data Type: | VARCHAR2 |
REL_MONTH
CC ID: 349281
| Seq. Order: | 16 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Month of event. |
| General Data Type: | VARCHAR2 |
REL_DAY
CC ID: 349289
| Seq. Order: | 17 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Day of event. |
| General Data Type: | VARCHAR2 |
REL_YEAR
CC ID: 349290
| Seq. Order: | 18 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Year of event. |
| General Data Type: | VARCHAR2 |
REL_DATEQUAL
CC ID: 349291
| Seq. Order: | 19 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Date quality, see support table MRDATE_QUALITY for descriptions. |
| General Data Type: | VARCHAR2 |
REL_COMMENTS
CC ID: 349293
| Seq. Order: | 20 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 200 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Comments or remarks. |
| General Data Type: | VARCHAR2 |
REL_SPECIES_ITIS
CC ID: 349294
| Seq. Order: | 21 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 11 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Itis species code, see support table MRSPECIES for descriptions, corresponding survey and shark species codes also in MRSPECIES. |
| General Data Type: | VARCHAR2 |
REL_SEX
CC ID: 349295
| Seq. Order: | 22 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Sex ( 0 = male, 1 = female). |
| General Data Type: | VARCHAR2 |
REL_FISHCOND
CC ID: 349296
| Seq. Order: | 23 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Condition of fish at event, see support table MRFISH_CONDITIONS for descriptions. |
| General Data Type: | VARCHAR2 |
REL_FISHFATE
CC ID: 349297
| Seq. Order: | 24 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Fate of fish at event, see support table MRFISH_FATES for descriptions. |
| General Data Type: | VARCHAR2 |
REL_LIFESTAGE
CC ID: 349298
| Seq. Order: | 25 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Lifestage of fish at event, see support table MRLIFESTAGES for descriptions. |
| General Data Type: | VARCHAR2 |
REL_LENGTH
CC ID: 349299
| Seq. Order: | 26 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 2 |
| Status: | Active |
| Description: |
Release Length, for sharks: fork length in centimeters . |
| General Data Type: | NUMBER |
REL_LENUOM
CC ID: 349300
| Seq. Order: | 27 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Unit of measure for length (CM, IN). |
| General Data Type: | VARCHAR2 |
REL_LENQUAL
CC ID: 349301
| Seq. Order: | 28 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Data quality code for length, see support table MRLENGTH_QUALITY for descriptions. |
| General Data Type: | VARCHAR2 |
REL_LENTYPE
CC ID: 349302
| Seq. Order: | 29 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Length type code, see support table MRLENGTH_TYPES for descriptions. |
| General Data Type: | VARCHAR2 |
REL_LENDET
CC ID: 349304
| Seq. Order: | 30 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Length determination code, see support table MRLENGTH_DETERMINATION for descriptions. |
| General Data Type: | VARCHAR2 |
REL_RPTLENGTH
CC ID: 349305
| Seq. Order: | 31 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 2 |
| Status: | Active |
| Description: |
Release Reported length measurement. |
| General Data Type: | NUMBER |
REL_RPTLENUOM
CC ID: 349306
| Seq. Order: | 32 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Unit of measure for reported length (CM, IN). |
| General Data Type: | VARCHAR2 |
REL_RPTLENQUAL
CC ID: 349307
| Seq. Order: | 33 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Data quality code for reported length, see support table MRLENGTH_QUALITY for descriptions. |
| General Data Type: | VARCHAR2 |
REL_RPTLENTYPE
CC ID: 349308
| Seq. Order: | 34 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Reported length type code, see support table MRLENGTH_TYPES for descriptions. |
| General Data Type: | VARCHAR2 |
REL_OTHLENGTH
CC ID: 349309
| Seq. Order: | 35 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 38 |
| Scale: | 2 |
| Status: | Active |
| Description: |
Release Other length measurement. |
| General Data Type: | NUMBER |
REL_OTHLENUOM
CC ID: 349310
| Seq. Order: | 36 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Unit of measure for other length (CM, IN). |
| General Data Type: | VARCHAR2 |
REL_OTHLENQUAL
CC ID: 349311
| Seq. Order: | 37 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Data quality code for other length, see support table MRLENGTH_QUALITY for descriptions. |
| General Data Type: | VARCHAR2 |
REL_OTHLENTYPE
CC ID: 349312
| Seq. Order: | 38 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Other length type code, see support table MRLENGTH_TYPES for descriptions. |
| General Data Type: | VARCHAR2 |
REL_WEIGHT
CC ID: 349313
| Seq. Order: | 39 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 38 |
| Scale: | 2 |
| Status: | Active |
| Description: |
Release Weight, for sharks, whole weight in kg. |
| General Data Type: | NUMBER |
REL_WGTUOM
CC ID: 349315
| Seq. Order: | 40 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Unit of measure for weight (LB, KG). |
| General Data Type: | VARCHAR2 |
REL_WGTQUAL
CC ID: 349316
| Seq. Order: | 41 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Weight quality code, see support table MRWEIGHT_QUALITY for descriptions. |
| General Data Type: | VARCHAR2 |
REL_WGTTYPE
CC ID: 349317
| Seq. Order: | 42 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Weight type code, see support table MRWEIGHT_TYPES for descriptions. |
| General Data Type: | VARCHAR2 |
REL_WGTDET
CC ID: 349318
| Seq. Order: | 43 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Weight determination code, see support table MRWEIGHT_DETERMINATION for descriptions. |
| General Data Type: | VARCHAR2 |
REL_RPTWEIGHT
CC ID: 349319
| Seq. Order: | 44 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 2 |
| Status: | Active |
| Description: |
Release Reported weight, for sharks, whole weight in kg. |
| General Data Type: | NUMBER |
REL_RPTWGTUOM
CC ID: 349320
| Seq. Order: | 45 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Unit of measure for reported weight (LB, KG). |
| General Data Type: | VARCHAR2 |
REL_RPTWGTQUAL
CC ID: 349321
| Seq. Order: | 46 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Reported weight quality code, see support table MRWEIGHT_QUALITY for descriptions. |
| General Data Type: | VARCHAR2 |
REL_RPTWGTTYPE
CC ID: 349322
| Seq. Order: | 47 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Reported weight type code, see support table MRWEIGHT_TYPES for descriptions. |
| General Data Type: | VARCHAR2 |
REL_SPCOND1
CC ID: 349323
| Seq. Order: | 48 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Special condition code, see support table MRSPECIAL_CONDITIONS for descriptions. |
| General Data Type: | VARCHAR2 |
REL_SPCOND2
CC ID: 349324
| Seq. Order: | 49 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Special condition code, see support table MRSPECIAL_CONDITIONS for descriptions.. |
| General Data Type: | VARCHAR2 |
REL_BIOSAMP1
CC ID: 349326
| Seq. Order: | 50 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Biological sample code, see support table MRBIO_SAMPLES for descriptions. |
| General Data Type: | VARCHAR2 |
REL_BIOSAMP2
CC ID: 349327
| Seq. Order: | 51 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Biological sample code, see support table MRBIO_SAMPLES for descriptions.. |
| General Data Type: | VARCHAR2 |
REL_LOCATION
CC ID: 349328
| Seq. Order: | 52 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Reported location, see MRLOCATIONS for descriptions. (redacted) |
| General Data Type: | VARCHAR2 |
REL_MILES
CC ID: 349329
| Seq. Order: | 53 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Release Miles from reported location (used for location calculation). (redacted) |
| General Data Type: | NUMBER |
REL_DIRECTION
CC ID: 349330
| Seq. Order: | 54 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 5 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Direction from reported location (used for location calculation). (redacted) |
| General Data Type: | VARCHAR2 |
REL_LORANCHAIN
CC ID: 349331
| Seq. Order: | 55 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Loran chain. (redacted) |
| General Data Type: | VARCHAR2 |
REL_LORAN1
CC ID: 349332
| Seq. Order: | 56 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Scale: | 2 |
| Status: | Active |
| Description: |
Release Loran x. (redacted) |
| General Data Type: | NUMBER |
REL_LORAN2
CC ID: 349333
| Seq. Order: | 57 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Scale: | 2 |
| Status: | Active |
| Description: |
Release Loran y. (redacted) |
| General Data Type: | NUMBER |
REL_LATDEG
CC ID: 349334
| Seq. Order: | 58 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Event latitude degrees. (redacted) |
| General Data Type: | VARCHAR2 |
REL_LATMIN
CC ID: 349335
| Seq. Order: | 59 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Event latitude minutes. (redacted) |
| General Data Type: | VARCHAR2 |
REL_LATSEC
CC ID: 349337
| Seq. Order: | 60 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Event latitude seconds. (redacted) |
| General Data Type: | VARCHAR2 |
REL_NOS
CC ID: 349338
| Seq. Order: | 61 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release North or south. (redacted) |
| General Data Type: | VARCHAR2 |
REL_DECLAT
CC ID: 349339
| Seq. Order: | 62 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release latitude in decimal degrees. (redacted) |
| General Data Type: | VARCHAR2 |
REL_LONDEG
CC ID: 349340
| Seq. Order: | 63 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Event longitude degrees. (redacted) |
| General Data Type: | VARCHAR2 |
REL_LONMIN
CC ID: 349341
| Seq. Order: | 64 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Event longitude minutes. (redacted) |
| General Data Type: | VARCHAR2 |
REL_LONSEC
CC ID: 349342
| Seq. Order: | 65 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Event longitude seconds. (redacted) |
| General Data Type: | VARCHAR2 |
REL_EOW
CC ID: 349343
| Seq. Order: | 66 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release East or west. (redacted) |
| General Data Type: | VARCHAR2 |
REL_DECLON
CC ID: 349344
| Seq. Order: | 67 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 11 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release longitude in decimal degrees. (redacted) |
| General Data Type: | VARCHAR2 |
REL_LOCQUAL
CC ID: 349345
| Seq. Order: | 68 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Data quality code for location, see MRLOC_QUALITY for descriptions. |
| General Data Type: | VARCHAR2 |
REL_DAYSFREE
CC ID: 349346
| Seq. Order: | 69 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 38 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Release Days free for recapture only. |
| General Data Type: | NUMBER |
REL_DISTTRAVEL
CC ID: 349348
| Seq. Order: | 70 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 5 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Release Distance traveled in nautical miles for recapture only, distance traveled is calculated with great circle formula. |
| General Data Type: | NUMBER |
REL_TRAVELDEG
CC ID: 349349
| Seq. Order: | 71 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 1 |
| Status: | Active |
| Description: |
Release Travel direction for recapture only, see MRDIRECTIONS for descriptions. |
| General Data Type: | NUMBER |
REL_TRAVELDIR
CC ID: 349350
| Seq. Order: | 72 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Calculated angle for direction traveled, rounded to 1 decimal position. For ytf, bsb, and scup, angle is calculated using magnetic north, shark angle is calculated using polar north.. |
| General Data Type: | VARCHAR2 |
REL_DEPTH
CC ID: 349351
| Seq. Order: | 73 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 38 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Release Depth. |
| General Data Type: | NUMBER |
REL_DEPTHUOM
CC ID: 349352
| Seq. Order: | 74 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Unit of measure used for depth (FM, FT, M). |
| General Data Type: | VARCHAR2 |
REL_CONTACTID
CC ID: 349353
| Seq. Order: | 75 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 38 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Release Contact id for event. |
| General Data Type: | NUMBER |
REL_INDUSTRY
CC ID: 349354
| Seq. Order: | 76 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Industry (category, sector) at time of event, see support table MRINDUSTRY for descriptions. |
| General Data Type: | VARCHAR2 |
REL_OCCUPATION
CC ID: 349355
| Seq. Order: | 77 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Occupation at time of event, see support table MROCCUPATION for descriptions. |
| General Data Type: | VARCHAR2 |
REL_GEAR
CC ID: 349356
| Seq. Order: | 78 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Gear used, see support table MRGEARS for descriptions. |
| General Data Type: | VARCHAR2 |
REL_SHVESSEL
CC ID: 349357
| Seq. Order: | 79 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Vessel code used by the shark fishery, see support table MRSHVESSELS for descriptions. |
| General Data Type: | VARCHAR2 |
REL_VESS_NATION
CC ID: 349359
| Seq. Order: | 80 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Vessel nation at time of event, see support table MRNATIONS for descriptions. |
| General Data Type: | VARCHAR2 |
REL_WEB_DOE
CC ID: 349360
| Seq. Order: | 81 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Date of Last Entry from Web Application. |
| General Data Type: | DATE |
REL_WEB_UOE
CC ID: 349361
| Seq. Order: | 82 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release User of Last Entry from Web Application. |
| General Data Type: | VARCHAR2 |
REL_WEB_DOC
CC ID: 349362
| Seq. Order: | 83 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release Date of Last Change from Web Application. |
| General Data Type: | DATE |
REL_WEB_UOC
CC ID: 349363
| Seq. Order: | 84 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Release User of Last Change from Web Application. |
| General Data Type: | VARCHAR2 |
REC_EVENTNUM
CC ID: 349364
| Seq. Order: | 85 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 38 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Recapture event number. |
| General Data Type: | NUMBER |
REC_TAG_TYPE
CC ID: 349365
| Seq. Order: | 86 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Style of tag, see support table MRTAGTYPES for descriptions. |
| General Data Type: | VARCHAR2 |
REC_TAG_COLOR
CC ID: 349366
| Seq. Order: | 87 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Color of tag, see support table MRTAGCOLORS for descriptions. |
| General Data Type: | VARCHAR2 |
REC_TAG_NUMBER
CC ID: 349367
| Seq. Order: | 88 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 6 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Tag identification number. |
| General Data Type: | VARCHAR2 |
REC_TAG_SUFFIX
CC ID: 349368
| Seq. Order: | 89 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Tag suffix. |
| General Data Type: | VARCHAR2 |
REC_TAG_REWARD
CC ID: 349370
| Seq. Order: | 90 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Reward for tag Recapture or recapture, see support table MRTAGREWARDS for descriptions. |
| General Data Type: | VARCHAR2 |
REC_TAG_FATE
CC ID: 349371
| Seq. Order: | 91 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Fate of tag, see support table MRTAGFATES for descriptions. |
| General Data Type: | VARCHAR2 |
REC_TAG_CONDITION
CC ID: 349372
| Seq. Order: | 92 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Condition of tag, see support table MRTAGCONDITIONS for descriptions. |
| General Data Type: | VARCHAR2 |
REC_TAG_SITE
CC ID: 349373
| Seq. Order: | 93 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Area of tag at recapture, see support table MRTAGSITE for descriptions. |
| General Data Type: | VARCHAR2 |
REC_TAG_LOCONFISH
CC ID: 349374
| Seq. Order: | 94 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Location on fish where tag is attached, see support table MRTAGLOCONFISH for descriptions. |
| General Data Type: | VARCHAR2 |
REC_TRIPID
CC ID: 349375
| Seq. Order: | 95 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Trip identification code. |
| General Data Type: | VARCHAR2 |
REC_HAULNUM
CC ID: 349376
| Seq. Order: | 96 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Ordinal number of the haul within the trip, set number for shark cruises. |
| General Data Type: | VARCHAR2 |
REC_TYPE
CC ID: 349377
| Seq. Order: | 97 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Event type, see support table MREVENTTYPES for descriptions. |
| General Data Type: | VARCHAR2 |
REC_MONTH
CC ID: 349378
| Seq. Order: | 98 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Month of event. |
| General Data Type: | VARCHAR2 |
REC_DAY
CC ID: 349379
| Seq. Order: | 99 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Day of event. |
| General Data Type: | VARCHAR2 |
REC_YEAR
CC ID: 349216
| Seq. Order: | 100 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Year of event. |
| General Data Type: | VARCHAR2 |
REC_DATEQUAL
CC ID: 349217
| Seq. Order: | 101 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Date quality, see support table MRDATE_QUALITY for descriptions. |
| General Data Type: | VARCHAR2 |
REC_COMMENTS
CC ID: 349218
| Seq. Order: | 102 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 200 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Comments or remarks. |
| General Data Type: | VARCHAR2 |
REC_SPECIES_ITIS
CC ID: 349219
| Seq. Order: | 103 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 11 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Itis species code, see support table MRSPECIES for descriptions, corresponding survey and shark species codes also in MRSPECIES. |
| General Data Type: | VARCHAR2 |
REC_SEX
CC ID: 349220
| Seq. Order: | 104 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Sex ( 0 = male, 1 = female). |
| General Data Type: | VARCHAR2 |
REC_FISHCOND
CC ID: 349221
| Seq. Order: | 105 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Condition of fish at event, see support table MRFISH_CONDITIONS for descriptions. |
| General Data Type: | VARCHAR2 |
REC_FISHFATE
CC ID: 349222
| Seq. Order: | 106 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Fate of fish at event, see support table MRFISH_FATES for descriptions. |
| General Data Type: | VARCHAR2 |
REC_LIFESTAGE
CC ID: 349223
| Seq. Order: | 107 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Lifestage of fish at event, see support table MRLIFESTAGES for descriptions. |
| General Data Type: | VARCHAR2 |
REC_LENGTH
CC ID: 349224
| Seq. Order: | 108 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 2 |
| Status: | Active |
| Description: |
Recapture Length, for sharks: fork length in centimeters . |
| General Data Type: | NUMBER |
REC_LENUOM
CC ID: 349225
| Seq. Order: | 109 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Unit of measure for length (CM, IN). |
| General Data Type: | VARCHAR2 |
REC_LENQUAL
CC ID: 349227
| Seq. Order: | 110 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Data quality code for length, see support table MRLENGTH_QUALITY for descriptions. |
| General Data Type: | VARCHAR2 |
REC_LENTYPE
CC ID: 349228
| Seq. Order: | 111 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Length type code, see support table MRLENGTH_TYPES for descriptions. |
| General Data Type: | VARCHAR2 |
REC_LENDET
CC ID: 349229
| Seq. Order: | 112 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Length determination code, see support table MRLENGTH_DETERMINATION for descriptions. |
| General Data Type: | VARCHAR2 |
REC_RPTLENGTH
CC ID: 349230
| Seq. Order: | 113 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 2 |
| Status: | Active |
| Description: |
Recapture Reported length measurement. |
| General Data Type: | NUMBER |
REC_RPTLENUOM
CC ID: 349231
| Seq. Order: | 114 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Unit of measure for reported length (CM, IN). |
| General Data Type: | VARCHAR2 |
REC_RPTLENQUAL
CC ID: 349232
| Seq. Order: | 115 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Data quality code for reported length, see support table MRLENGTH_QUALITY for descriptions. |
| General Data Type: | VARCHAR2 |
REC_RPTLENTYPE
CC ID: 349233
| Seq. Order: | 116 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Reported length type code, see support table MRLENGTH_TYPES for descriptions. |
| General Data Type: | VARCHAR2 |
REC_OTHLENGTH
CC ID: 349234
| Seq. Order: | 117 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 38 |
| Scale: | 2 |
| Status: | Active |
| Description: |
Recapture Other length measurement. |
| General Data Type: | NUMBER |
REC_OTHLENUOM
CC ID: 349235
| Seq. Order: | 118 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Unit of measure for other length (CM, IN). |
| General Data Type: | VARCHAR2 |
REC_OTHLENQUAL
CC ID: 349236
| Seq. Order: | 119 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Data quality code for other length, see support table MRLENGTH_QUALITY for descriptions. |
| General Data Type: | VARCHAR2 |
REC_OTHLENTYPE
CC ID: 349238
| Seq. Order: | 120 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Other length type code, see support table MRLENGTH_TYPES for descriptions. |
| General Data Type: | VARCHAR2 |
REC_WEIGHT
CC ID: 349239
| Seq. Order: | 121 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 2 |
| Status: | Active |
| Description: |
Recapture Weight, for sharks, whole weight in kg. |
| General Data Type: | NUMBER |
REC_WGTUOM
CC ID: 349240
| Seq. Order: | 122 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Unit of measure for weight (LB, KG). |
| General Data Type: | VARCHAR2 |
REC_WGTQUAL
CC ID: 349241
| Seq. Order: | 123 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Weight quality code, see support table MRWEIGHT_QUALITY for descriptions. |
| General Data Type: | VARCHAR2 |
REC_WGTTYPE
CC ID: 349242
| Seq. Order: | 124 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Weight type code, see support table MRWEIGHT_TYPES for descriptions. |
| General Data Type: | VARCHAR2 |
REC_WGTDET
CC ID: 349243
| Seq. Order: | 125 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Weight determination code, see support table MRWEIGHT_DETERMINATION for descriptions. |
| General Data Type: | VARCHAR2 |
REC_RPTWEIGHT
CC ID: 349244
| Seq. Order: | 126 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 2 |
| Status: | Active |
| Description: |
Recapture Reported weight, for sharks, whole weight in kg. |
| General Data Type: | NUMBER |
REC_RPTWGTUOM
CC ID: 349245
| Seq. Order: | 127 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Unit of measure for reported weight (LB, KG). |
| General Data Type: | VARCHAR2 |
REC_RPTWGTQUAL
CC ID: 349246
| Seq. Order: | 128 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Reported weight quality code, see support table MRWEIGHT_QUALITY for descriptions. |
| General Data Type: | VARCHAR2 |
REC_RPTWGTTYPE
CC ID: 349247
| Seq. Order: | 129 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Reported weight type code, see support table MRWEIGHT_TYPES for descriptions. |
| General Data Type: | VARCHAR2 |
REC_SPCOND1
CC ID: 349249
| Seq. Order: | 130 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Special condition code, see support table MRSPECIAL_CONDITIONS for descriptions. |
| General Data Type: | VARCHAR2 |
REC_SPCOND2
CC ID: 349250
| Seq. Order: | 131 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Special condition code, see support table MRSPECIAL_CONDITIONS for descriptions.. |
| General Data Type: | VARCHAR2 |
REC_BIOSAMP1
CC ID: 349251
| Seq. Order: | 132 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Biological sample code, see support table MRBIO_SAMPLES for descriptions. |
| General Data Type: | VARCHAR2 |
REC_BIOSAMP2
CC ID: 349252
| Seq. Order: | 133 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Biological sample code, see support table MRBIO_SAMPLES for descriptions.. |
| General Data Type: | VARCHAR2 |
REC_LOCATION
CC ID: 349253
| Seq. Order: | 134 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Reported location, see MRLOCATIONS for descriptions. (redacted) |
| General Data Type: | VARCHAR2 |
REC_MILES
CC ID: 349254
| Seq. Order: | 135 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Recapture Miles from reported location (used for location calculation). (redacted) |
| General Data Type: | NUMBER |
REC_DIRECTION
CC ID: 349255
| Seq. Order: | 136 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 5 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Direction from reported location (used for location calculation). (redacted) |
| General Data Type: | VARCHAR2 |
REC_LORANCHAIN
CC ID: 349256
| Seq. Order: | 137 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Loran chain. (redacted) |
| General Data Type: | VARCHAR2 |
REC_LORAN1
CC ID: 349257
| Seq. Order: | 138 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Scale: | 2 |
| Status: | Active |
| Description: |
Recapture Loran x. (redacted) |
| General Data Type: | NUMBER |
REC_LORAN2
CC ID: 349258
| Seq. Order: | 139 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Scale: | 2 |
| Status: | Active |
| Description: |
Recapture Loran y. (redacted) |
| General Data Type: | NUMBER |
REC_LATDEG
CC ID: 349260
| Seq. Order: | 140 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Event latitude degrees. (redacted) |
| General Data Type: | VARCHAR2 |
REC_LATMIN
CC ID: 349261
| Seq. Order: | 141 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Event latitude minutes. (redacted) |
| General Data Type: | VARCHAR2 |
REC_LATSEC
CC ID: 349262
| Seq. Order: | 142 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Event latitude seconds. (redacted) |
| General Data Type: | VARCHAR2 |
REC_NOS
CC ID: 349263
| Seq. Order: | 143 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture North or south. (redacted) |
| General Data Type: | VARCHAR2 |
REC_DECLAT
CC ID: 349264
| Seq. Order: | 144 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Latitude in decimal degrees. (redacted) |
| General Data Type: | VARCHAR2 |
REC_LONDEG
CC ID: 349265
| Seq. Order: | 145 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Event longitude degrees. (redacted) |
| General Data Type: | VARCHAR2 |
REC_LONMIN
CC ID: 349266
| Seq. Order: | 146 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Event longitude minutes. (redacted) |
| General Data Type: | VARCHAR2 |
REC_LONSEC
CC ID: 349267
| Seq. Order: | 147 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Event longitude seconds. (redacted) |
| General Data Type: | VARCHAR2 |
REC_EOW
CC ID: 349268
| Seq. Order: | 148 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture East or west. (redacted) |
| General Data Type: | VARCHAR2 |
REC_DECLON
CC ID: 349269
| Seq. Order: | 149 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 11 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Longitude in decimal degrees. (redacted) |
| General Data Type: | VARCHAR2 |
REC_LOCQUAL
CC ID: 349271
| Seq. Order: | 150 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Data quality code for location, see MRLOC_QUALITY for descriptions. |
| General Data Type: | VARCHAR2 |
REC_DAYSFREE
CC ID: 349272
| Seq. Order: | 151 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 38 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Recapture Days free for recapture only. |
| General Data Type: | NUMBER |
REC_DISTTRAVEL
CC ID: 349273
| Seq. Order: | 152 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 5 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Recapture Distance traveled in nautical miles for recapture only, distance traveled is calculated with great circle formula. |
| General Data Type: | NUMBER |
REC_TRAVELDEG
CC ID: 349274
| Seq. Order: | 153 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 1 |
| Status: | Active |
| Description: |
Recapture Travel direction for recapture only, see MRDIRECTIONS for descriptions. |
| General Data Type: | NUMBER |
REC_TRAVELDIR
CC ID: 349275
| Seq. Order: | 154 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Calculated angle for direction traveled, rounded to 1 decimal position. For ytf, bsb, and scup, angle is calculated using magnetic north, shark angle is calculated using polar north.. |
| General Data Type: | VARCHAR2 |
REC_DEPTH
CC ID: 349276
| Seq. Order: | 155 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 38 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Recapture Depth. |
| General Data Type: | NUMBER |
REC_DEPTHUOM
CC ID: 349277
| Seq. Order: | 156 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Unit of measure used for depth (FM, FT, M). |
| General Data Type: | VARCHAR2 |
REC_CONTACTID
CC ID: 349278
| Seq. Order: | 157 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 38 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Recapture Contact id for event. |
| General Data Type: | NUMBER |
REC_INDUSTRY
CC ID: 349279
| Seq. Order: | 158 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Industry (category, sector) at time of event, see support table MRINDUSTRY for descriptions. |
| General Data Type: | VARCHAR2 |
REC_OCCUPATION
CC ID: 349280
| Seq. Order: | 159 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Occupation at time of event, see support table MROCCUPATION for descriptions. |
| General Data Type: | VARCHAR2 |
REC_GEAR
CC ID: 349282
| Seq. Order: | 160 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Gear used, see support table MRGEARS for descriptions. |
| General Data Type: | VARCHAR2 |
REC_SHVESSEL
CC ID: 349283
| Seq. Order: | 161 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Vessel code used by the shark fishery, see support table MRSHVESSELS for descriptions. |
| General Data Type: | VARCHAR2 |
REC_VESS_NATION
CC ID: 349284
| Seq. Order: | 162 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Vessel nation at time of event, see support table MRNATIONS for descriptions. |
| General Data Type: | VARCHAR2 |
REC_WEB_DOE
CC ID: 349285
| Seq. Order: | 163 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Date of Last Entry from Web Application. |
| General Data Type: | DATE |
REC_WEB_UOE
CC ID: 349286
| Seq. Order: | 164 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture User of Last Entry from Web Application. |
| General Data Type: | VARCHAR2 |
REC_WEB_DOC
CC ID: 349287
| Seq. Order: | 165 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture Date of Last Change from Web Application. |
| General Data Type: | DATE |
REC_WEB_UOC
CC ID: 349288
| Seq. Order: | 166 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Recapture User of Last Change from Web Application. |
| General Data Type: | VARCHAR2 |
Catalog Details
| Catalog Item ID: | 34794 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:34794 |
| Metadata Record Created By: | Patricia L Jones |
| Metadata Record Created: | 2016-09-13 10:42+0000 |
| Metadata Record Last Modified By: | SysAdmin InPortAdmin |
| Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
| Metadata Record Published: | 2016-09-13 |
| Owner Org: | NEFSC |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2016-09-13 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2017-09-13 |