View: MRVEVENT
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34795 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
View of committed events without tag information (use to query animals)
DescriptionView of committed events without tag information (use to query animals)
Entity Information
Entity Type
Data View
Data Attribute / Type | Description |
---|---|
FISHERY
VARCHAR2 |
Fishery Code, a two character fishery identification code. See support table MRFISHERY for codes and descriptions. |
ANIMALID
VARCHAR2 |
Animal identification code, animal id will be a concatenation of fishery, original tag type, color, number, and suffix. |
EVENTNUM
NUMBER |
Event occurrence of animal (ie: initial release = 1, 1st recapture of animal = 2, 2nd recapture of animal = 3, 3rd recapture of animal = 4, etc.) |
EV_TYPE
VARCHAR2 |
Event type, see support table MREVENTTYPES for descriptions. |
EV_MONTH
VARCHAR2 |
Month of event. |
EV_DAY
VARCHAR2 |
Day of event. |
EV_YEAR
VARCHAR2 |
Year of event. |
EV_DATE
VARCHAR2 |
Date of Event. |
EV_DATEQUAL
VARCHAR2 |
Date quality, see support table MRDATE_QUALITY for descriptions. |
EV_COMMENTS
VARCHAR2 |
Comments or remarks. |
EV_STATAREA
VARCHAR2 |
Statistical area calculated from latitude and longitude, note: stat area 551, 552 are in Canadian water. |
EV_LOCATION
VARCHAR2 |
Reported location, see MRLOCATIONS for descriptions. (redacted) |
EV_MILES
NUMBER |
Miles from reported location (used for location calculation). (redacted) |
EV_DIRECTION
VARCHAR2 |
Direction from reported location (used for location calculation). (redacted) |
EV_LATDEG
VARCHAR2 |
Event latitude degrees. (redacted) |
EV_LATMIN
VARCHAR2 |
Event latitude minutes. (redacted) |
EV_LATSEC
VARCHAR2 |
Event latitude seconds. (redacted) |
EV_NOS
VARCHAR2 |
North or south. (redacted) |
EV_DECLAT
VARCHAR2 |
Latitude in decimal degrees. (redacted) |
EV_LONDEG
VARCHAR2 |
Event longitude degrees. (redacted) |
EV_LONMIN
VARCHAR2 |
Event longitude minutes. (redacted) |
EV_LONSEC
VARCHAR2 |
Event longitude seconds. (redacted) |
EV_EOW
VARCHAR2 |
East or west. (redacted) |
EV_DECLON
VARCHAR2 |
Longitude in decimal degrees. (redacted) |
EV_LOCQUAL
VARCHAR2 |
Data quality code for location, see MRLOC_QUALITY for descriptions. |
EV_LORANCHAIN
VARCHAR2 |
Loran chain. (redacted) |
EV_LORAN1
NUMBER |
Loran x. (redacted) |
EV_LORAN2
NUMBER |
Loran y. (redacted) |
EV_DEPTH
NUMBER |
Depth. |
EV_DEPTHUOM
VARCHAR2 |
Unit of measure used for depth (FM, FT, M). |
EV_DEPTH_FM
NUMBER |
Depth in Fathoms. |
EV_DAYSFREE
NUMBER |
Days free for recapture only. |
EV_DISTTRAVEL
NUMBER |
Distance traveled in nautical miles for recapture only, distance traveled is calculated with great circle formula. |
EV_DISTTRAVEL_CALC
VARCHAR2 |
Calculation used for distance traveled, 00 = cannot calculate (points missing) 01 = did not cross around florida 02 = calculation uses way points around Florida 03 = distance traveled taken from legacy migrated data. |
EV_TRAVELDEG
NUMBER |
Travel direction for recapture only, see MRDIRECTIONS for descriptions. |
EV_TRAVELDIR
VARCHAR2 |
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.. |
EV_SPECIES_ITIS
VARCHAR2 |
Itis species code, see support table MRSPECIES for descriptions, corresponding survey and shark species codes also in MRSPECIES. |
EV_SEX
VARCHAR2 |
Sex ( 0 = male, 1 = female). |
EV_FISHFATE
VARCHAR2 |
Fate of fish at event, see support table MRFISH_FATES for descriptions. |
EV_LIFESTAGE
VARCHAR2 |
Lifestage of fish at event, see support table MRLIFESTAGES for descriptions. |
EV_FISHCOND
VARCHAR2 |
Condition of fish at event, see support table MRFISH_CONDITIONS for descriptions. |
EV_BIOSAMP1
VARCHAR2 |
Biological sample code, see support table MRBIO_SAMPLES for descriptions. |
EV_BIOSAMP2
VARCHAR2 |
Biological sample code, see support table MRBIO_SAMPLES for descriptions.. |
EV_BIOSAMP3
VARCHAR2 |
Biological sample code, see support table MRBIO_SAMPLES for descriptions.. |
EV_BIOSAMP4
VARCHAR2 |
Biological sample code, see support table MRBIO_SAMPLES for descriptions.. |
EV_BIOSAMP5
VARCHAR2 |
Biological sample code, see support table MRBIO_SAMPLES for descriptions.. |
EV_BIOSAMP6
VARCHAR2 |
Biological sample code, see support table MRBIO_SAMPLES for descriptions.. |
EV_BIOSAMP7
VARCHAR2 |
Biological sample code, see support table MRBIO_SAMPLES for descriptions.. |
EV_BIOSAMP8
VARCHAR2 |
Biological sample code, see support table MRBIO_SAMPLES for descriptions.. |
EV_BIOSAMP9
VARCHAR2 |
Biological sample code, see support table MRBIO_SAMPLES for descriptions.. |
EV_BIOSAMP10
VARCHAR2 |
Biological sample code, see support table MRBIO_SAMPLES for descriptions.. |
EV_LENGTH
NUMBER |
Length, for sharks: fork length in centimeters . |
EV_LENUOM
VARCHAR2 |
Unit of measure for length (CM, IN). |
EV_LENQUAL
VARCHAR2 |
Data quality code for length, see support table MRLENGTH_QUALITY for descriptions. |
EV_LENTYPE
VARCHAR2 |
Length type code, see support table MRLENGTH_TYPES for descriptions. |
EV_LENDET
VARCHAR2 |
Length determination code, see support table MRLENGTH_DETERMINATION for descriptions. |
EV_RPTLENGTH
NUMBER |
Reported length measurement. |
EV_RPTLENUOM
VARCHAR2 |
Unit of measure for reported length (CM, IN). |
EV_RPTLENQUAL
VARCHAR2 |
Data quality code for reported length, see support table MRLENGTH_QUALITY for descriptions. |
EV_RPTLENTYPE
VARCHAR2 |
Reported length type code, see support table MRLENGTH_TYPES for descriptions. |
EV_OTHLENGTH
NUMBER |
Other length measurement. |
EV_OTHLENUOM
VARCHAR2 |
Unit of measure for other length (CM, IN). |
EV_OTHLENQUAL
VARCHAR2 |
Data quality code for other length, see support table MRLENGTH_QUALITY for descriptions. |
EV_OTHLENTYPE
VARCHAR2 |
Other length type code, see support table MRLENGTH_TYPES for descriptions. |
EV_WEIGHT
NUMBER |
Weight, for sharks, whole weight in kg. |
EV_WGTUOM
VARCHAR2 |
Unit of measure for weight (LB, KG). |
EV_WGTQUAL
VARCHAR2 |
Weight quality code, see support table MRWEIGHT_QUALITY for descriptions. |
EV_WGTTYPE
VARCHAR2 |
Weight type code, see support table MRWEIGHT_TYPES for descriptions. |
EV_WGTDET
VARCHAR2 |
Weight determination code, see support table MRWEIGHT_DETERMINATION for descriptions. |
EV_RPTWEIGHT
NUMBER |
Reported weight, for sharks, whole weight in kg. |
EV_RPTWGTUOM
VARCHAR2 |
Unit of measure for reported weight (LB, KG). |
EV_RPTWGTQUAL
VARCHAR2 |
Reported weight quality code, see support table MRWEIGHT_QUALITY for descriptions. |
EV_RPTWGTTYPE
VARCHAR2 |
Reported weight type code, see support table MRWEIGHT_TYPES for descriptions. |
EV_CONTACTID
NUMBER |
Contact id for event. |
EV_INDUSTRY
VARCHAR2 |
Industry (category, sector) at time of event, see support table MRINDUSTRY for descriptions. |
EV_OCCUPATION
VARCHAR2 |
Occupation at time of event, see support table MROCCUPATION for descriptions. |
EV_VESS_NATION
VARCHAR2 |
Vessel nation at time of event, see support table MRNATIONS for descriptions. |
EV_SHVESSEL
VARCHAR2 |
Vessel code used by the shark fishery, see support table MRSHVESSELS for descriptions. |
EV_GEAR
VARCHAR2 |
Gear used, see support table MRGEARS for descriptions. |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (NEFSC) for inquiries on this record.
Item Identification
Title: | View: MRVEVENT |
---|---|
Short Name: | MRVEVENT |
Status: | Completed |
Abstract: |
View of committed events without tag information (use to query animals) |
Notes: |
Loaded by batch 9270, 09-13-2016 10:42 |
Entity Information
Entity Type: | Data View |
---|---|
Active Version?: | Yes |
Schema Name: | MRDBS |
Description: |
View of committed events without tag information (use to query animals) |
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
|
EVENTNUM | NUMBER | Event occurrence of animal (ie: initial release = 1, 1st recapture of animal = 2, 2nd recapture of animal = 3, 3rd recapture of animal = 4, etc.) | |
100
|
EV_TYPE | VARCHAR2 | Event type, see support table MREVENTTYPES for descriptions. | |
100
|
EV_MONTH | VARCHAR2 | Month of event. | |
100
|
EV_DAY | VARCHAR2 | Day of event. | |
100
|
EV_YEAR | VARCHAR2 | Year of event. | |
100
|
EV_DATE | VARCHAR2 | Date of Event. | |
100
|
EV_DATEQUAL | VARCHAR2 | Date quality, see support table MRDATE_QUALITY for descriptions. | |
100
|
EV_COMMENTS | VARCHAR2 | Comments or remarks. | |
100
|
EV_STATAREA | VARCHAR2 | Statistical area calculated from latitude and longitude, note: stat area 551, 552 are in Canadian water. | |
100
|
EV_LOCATION | VARCHAR2 | Reported location, see MRLOCATIONS for descriptions. (redacted) | |
100
|
EV_MILES | NUMBER | Miles from reported location (used for location calculation). (redacted) | |
100
|
EV_DIRECTION | VARCHAR2 | Direction from reported location (used for location calculation). (redacted) | |
100
|
EV_LATDEG | VARCHAR2 | Event latitude degrees. (redacted) | |
100
|
EV_LATMIN | VARCHAR2 | Event latitude minutes. (redacted) | |
100
|
EV_LATSEC | VARCHAR2 | Event latitude seconds. (redacted) | |
100
|
EV_NOS | VARCHAR2 | North or south. (redacted) | |
100
|
EV_DECLAT | VARCHAR2 | Latitude in decimal degrees. (redacted) | |
100
|
EV_LONDEG | VARCHAR2 | Event longitude degrees. (redacted) | |
100
|
EV_LONMIN | VARCHAR2 | Event longitude minutes. (redacted) | |
100
|
EV_LONSEC | VARCHAR2 | Event longitude seconds. (redacted) | |
100
|
EV_EOW | VARCHAR2 | East or west. (redacted) | |
100
|
EV_DECLON | VARCHAR2 | Longitude in decimal degrees. (redacted) | |
100
|
EV_LOCQUAL | VARCHAR2 | Data quality code for location, see MRLOC_QUALITY for descriptions. | |
100
|
EV_LORANCHAIN | VARCHAR2 | Loran chain. (redacted) | |
100
|
EV_LORAN1 | NUMBER | Loran x. (redacted) | |
100
|
EV_LORAN2 | NUMBER | Loran y. (redacted) | |
100
|
EV_DEPTH | NUMBER | Depth. | |
100
|
EV_DEPTHUOM | VARCHAR2 | Unit of measure used for depth (FM, FT, M). | |
100
|
EV_DEPTH_FM | NUMBER | Depth in Fathoms. | |
100
|
EV_DAYSFREE | NUMBER | Days free for recapture only. | |
100
|
EV_DISTTRAVEL | NUMBER | Distance traveled in nautical miles for recapture only, distance traveled is calculated with great circle formula. | |
100
|
EV_DISTTRAVEL_CALC | VARCHAR2 | Calculation used for distance traveled, 00 = cannot calculate (points missing) 01 = did not cross around florida 02 = calculation uses way points around Florida 03 = distance traveled taken from legacy migrated data. | |
100
|
EV_TRAVELDEG | NUMBER | Travel direction for recapture only, see MRDIRECTIONS for descriptions. | |
100
|
EV_TRAVELDIR | VARCHAR2 | 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
|
EV_SPECIES_ITIS | VARCHAR2 | Itis species code, see support table MRSPECIES for descriptions, corresponding survey and shark species codes also in MRSPECIES. | |
100
|
EV_SEX | VARCHAR2 | Sex ( 0 = male, 1 = female). | |
100
|
EV_FISHFATE | VARCHAR2 | Fate of fish at event, see support table MRFISH_FATES for descriptions. | |
100
|
EV_LIFESTAGE | VARCHAR2 | Lifestage of fish at event, see support table MRLIFESTAGES for descriptions. | |
100
|
EV_FISHCOND | VARCHAR2 | Condition of fish at event, see support table MRFISH_CONDITIONS for descriptions. | |
100
|
EV_BIOSAMP1 | VARCHAR2 | Biological sample code, see support table MRBIO_SAMPLES for descriptions. | |
100
|
EV_BIOSAMP2 | VARCHAR2 | Biological sample code, see support table MRBIO_SAMPLES for descriptions.. | |
100
|
EV_BIOSAMP3 | VARCHAR2 | Biological sample code, see support table MRBIO_SAMPLES for descriptions.. | |
100
|
EV_BIOSAMP4 | VARCHAR2 | Biological sample code, see support table MRBIO_SAMPLES for descriptions.. | |
100
|
EV_BIOSAMP5 | VARCHAR2 | Biological sample code, see support table MRBIO_SAMPLES for descriptions.. | |
100
|
EV_BIOSAMP6 | VARCHAR2 | Biological sample code, see support table MRBIO_SAMPLES for descriptions.. | |
100
|
EV_BIOSAMP7 | VARCHAR2 | Biological sample code, see support table MRBIO_SAMPLES for descriptions.. | |
100
|
EV_BIOSAMP8 | VARCHAR2 | Biological sample code, see support table MRBIO_SAMPLES for descriptions.. | |
100
|
EV_BIOSAMP9 | VARCHAR2 | Biological sample code, see support table MRBIO_SAMPLES for descriptions.. | |
100
|
EV_BIOSAMP10 | VARCHAR2 | Biological sample code, see support table MRBIO_SAMPLES for descriptions.. | |
100
|
EV_LENGTH | NUMBER | Length, for sharks: fork length in centimeters . | |
100
|
EV_LENUOM | VARCHAR2 | Unit of measure for length (CM, IN). | |
100
|
EV_LENQUAL | VARCHAR2 | Data quality code for length, see support table MRLENGTH_QUALITY for descriptions. | |
100
|
EV_LENTYPE | VARCHAR2 | Length type code, see support table MRLENGTH_TYPES for descriptions. | |
100
|
EV_LENDET | VARCHAR2 | Length determination code, see support table MRLENGTH_DETERMINATION for descriptions. | |
100
|
EV_RPTLENGTH | NUMBER | Reported length measurement. | |
100
|
EV_RPTLENUOM | VARCHAR2 | Unit of measure for reported length (CM, IN). | |
100
|
EV_RPTLENQUAL | VARCHAR2 | Data quality code for reported length, see support table MRLENGTH_QUALITY for descriptions. | |
100
|
EV_RPTLENTYPE | VARCHAR2 | Reported length type code, see support table MRLENGTH_TYPES for descriptions. | |
100
|
EV_OTHLENGTH | NUMBER | Other length measurement. | |
100
|
EV_OTHLENUOM | VARCHAR2 | Unit of measure for other length (CM, IN). | |
100
|
EV_OTHLENQUAL | VARCHAR2 | Data quality code for other length, see support table MRLENGTH_QUALITY for descriptions. | |
100
|
EV_OTHLENTYPE | VARCHAR2 | Other length type code, see support table MRLENGTH_TYPES for descriptions. | |
100
|
EV_WEIGHT | NUMBER | Weight, for sharks, whole weight in kg. | |
100
|
EV_WGTUOM | VARCHAR2 | Unit of measure for weight (LB, KG). | |
100
|
EV_WGTQUAL | VARCHAR2 | Weight quality code, see support table MRWEIGHT_QUALITY for descriptions. | |
100
|
EV_WGTTYPE | VARCHAR2 | Weight type code, see support table MRWEIGHT_TYPES for descriptions. | |
100
|
EV_WGTDET | VARCHAR2 | Weight determination code, see support table MRWEIGHT_DETERMINATION for descriptions. | |
100
|
EV_RPTWEIGHT | NUMBER | Reported weight, for sharks, whole weight in kg. | |
100
|
EV_RPTWGTUOM | VARCHAR2 | Unit of measure for reported weight (LB, KG). | |
100
|
EV_RPTWGTQUAL | VARCHAR2 | Reported weight quality code, see support table MRWEIGHT_QUALITY for descriptions. | |
100
|
EV_RPTWGTTYPE | VARCHAR2 | Reported weight type code, see support table MRWEIGHT_TYPES for descriptions. | |
100
|
EV_CONTACTID | NUMBER | Contact id for event. | |
100
|
EV_INDUSTRY | VARCHAR2 | Industry (category, sector) at time of event, see support table MRINDUSTRY for descriptions. | |
100
|
EV_OCCUPATION | VARCHAR2 | Occupation at time of event, see support table MROCCUPATION for descriptions. | |
100
|
EV_VESS_NATION | VARCHAR2 | Vessel nation at time of event, see support table MRNATIONS for descriptions. | |
100
|
EV_SHVESSEL | VARCHAR2 | Vessel code used by the shark fishery, see support table MRSHVESSELS for descriptions. | |
100
|
EV_GEAR | VARCHAR2 | Gear used, see support table MRGEARS for descriptions. |
Attribute Details
FISHERY
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
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 |
EVENTNUM
Seq. Order: | 3 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Scale: | 0 |
Status: | Active |
Description: |
Event occurrence of animal (ie: initial release = 1, 1st recapture of animal = 2, 2nd recapture of animal = 3, 3rd recapture of animal = 4, etc.) |
General Data Type: | NUMBER |
EV_TYPE
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Event type, see support table MREVENTTYPES for descriptions. |
General Data Type: | VARCHAR2 |
EV_MONTH
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Month of event. |
General Data Type: | VARCHAR2 |
EV_DAY
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Day of event. |
General Data Type: | VARCHAR2 |
EV_YEAR
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Year of event. |
General Data Type: | VARCHAR2 |
EV_DATE
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date of Event. |
General Data Type: | VARCHAR2 |
EV_DATEQUAL
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date quality, see support table MRDATE_QUALITY for descriptions. |
General Data Type: | VARCHAR2 |
EV_COMMENTS
Seq. Order: | 10 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 200 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Comments or remarks. |
General Data Type: | VARCHAR2 |
EV_STATAREA
Seq. Order: | 11 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Statistical area calculated from latitude and longitude, note: stat area 551, 552 are in Canadian water. |
General Data Type: | VARCHAR2 |
EV_LOCATION
Seq. Order: | 12 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Reported location, see MRLOCATIONS for descriptions. (redacted) |
General Data Type: | VARCHAR2 |
EV_MILES
Seq. Order: | 13 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Scale: | 0 |
Status: | Active |
Description: |
Miles from reported location (used for location calculation). (redacted) |
General Data Type: | NUMBER |
EV_DIRECTION
Seq. Order: | 14 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Direction from reported location (used for location calculation). (redacted) |
General Data Type: | VARCHAR2 |
EV_LATDEG
Seq. Order: | 15 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Event latitude degrees. (redacted) |
General Data Type: | VARCHAR2 |
EV_LATMIN
Seq. Order: | 16 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Event latitude minutes. (redacted) |
General Data Type: | VARCHAR2 |
EV_LATSEC
Seq. Order: | 17 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Event latitude seconds. (redacted) |
General Data Type: | VARCHAR2 |
EV_NOS
Seq. Order: | 18 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
North or south. (redacted) |
General Data Type: | VARCHAR2 |
EV_DECLAT
Seq. Order: | 19 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude in decimal degrees. (redacted) |
General Data Type: | VARCHAR2 |
EV_LONDEG
Seq. Order: | 20 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Event longitude degrees. (redacted) |
General Data Type: | VARCHAR2 |
EV_LONMIN
Seq. Order: | 21 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Event longitude minutes. (redacted) |
General Data Type: | VARCHAR2 |
EV_LONSEC
Seq. Order: | 22 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Event longitude seconds. (redacted) |
General Data Type: | VARCHAR2 |
EV_EOW
Seq. Order: | 23 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
East or west. (redacted) |
General Data Type: | VARCHAR2 |
EV_DECLON
Seq. Order: | 24 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 11 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude in decimal degrees. (redacted) |
General Data Type: | VARCHAR2 |
EV_LOCQUAL
Seq. Order: | 25 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Data quality code for location, see MRLOC_QUALITY for descriptions. |
General Data Type: | VARCHAR2 |
EV_LORANCHAIN
Seq. Order: | 26 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Loran chain. (redacted) |
General Data Type: | VARCHAR2 |
EV_LORAN1
Seq. Order: | 27 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Scale: | 2 |
Status: | Active |
Description: |
Loran x. (redacted) |
General Data Type: | NUMBER |
EV_LORAN2
Seq. Order: | 28 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 2 |
Status: | Active |
Description: |
Loran y. (redacted) |
General Data Type: | NUMBER |
EV_DEPTH
Seq. Order: | 29 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Depth. |
General Data Type: | NUMBER |
EV_DEPTHUOM
Seq. Order: | 30 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unit of measure used for depth (FM, FT, M). |
General Data Type: | VARCHAR2 |
EV_DEPTH_FM
Seq. Order: | 31 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Depth in Fathoms. |
General Data Type: | NUMBER |
EV_DAYSFREE
Seq. Order: | 32 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
Days free for recapture only. |
General Data Type: | NUMBER |
EV_DISTTRAVEL
Seq. Order: | 33 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
Distance traveled in nautical miles for recapture only, distance traveled is calculated with great circle formula. |
General Data Type: | NUMBER |
EV_DISTTRAVEL_CALC
Seq. Order: | 34 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Calculation used for distance traveled, 00 = cannot calculate (points missing) 01 = did not cross around florida 02 = calculation uses way points around Florida 03 = distance traveled taken from legacy migrated data. |
General Data Type: | VARCHAR2 |
EV_TRAVELDEG
Seq. Order: | 35 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Scale: | 1 |
Status: | Active |
Description: |
Travel direction for recapture only, see MRDIRECTIONS for descriptions. |
General Data Type: | NUMBER |
EV_TRAVELDIR
Seq. Order: | 36 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
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 |
EV_SPECIES_ITIS
Seq. Order: | 37 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 11 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Itis species code, see support table MRSPECIES for descriptions, corresponding survey and shark species codes also in MRSPECIES. |
General Data Type: | VARCHAR2 |
EV_SEX
Seq. Order: | 38 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Sex ( 0 = male, 1 = female). |
General Data Type: | VARCHAR2 |
EV_FISHFATE
Seq. Order: | 39 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Fate of fish at event, see support table MRFISH_FATES for descriptions. |
General Data Type: | VARCHAR2 |
EV_LIFESTAGE
Seq. Order: | 40 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Lifestage of fish at event, see support table MRLIFESTAGES for descriptions. |
General Data Type: | VARCHAR2 |
EV_FISHCOND
Seq. Order: | 41 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Condition of fish at event, see support table MRFISH_CONDITIONS for descriptions. |
General Data Type: | VARCHAR2 |
EV_BIOSAMP1
Seq. Order: | 42 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Biological sample code, see support table MRBIO_SAMPLES for descriptions. |
General Data Type: | VARCHAR2 |
EV_BIOSAMP2
Seq. Order: | 43 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Biological sample code, see support table MRBIO_SAMPLES for descriptions.. |
General Data Type: | VARCHAR2 |
EV_BIOSAMP3
Seq. Order: | 44 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Biological sample code, see support table MRBIO_SAMPLES for descriptions.. |
General Data Type: | VARCHAR2 |
EV_BIOSAMP4
Seq. Order: | 45 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Biological sample code, see support table MRBIO_SAMPLES for descriptions.. |
General Data Type: | VARCHAR2 |
EV_BIOSAMP5
Seq. Order: | 46 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Biological sample code, see support table MRBIO_SAMPLES for descriptions.. |
General Data Type: | VARCHAR2 |
EV_BIOSAMP6
Seq. Order: | 47 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Biological sample code, see support table MRBIO_SAMPLES for descriptions.. |
General Data Type: | VARCHAR2 |
EV_BIOSAMP7
Seq. Order: | 48 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Biological sample code, see support table MRBIO_SAMPLES for descriptions.. |
General Data Type: | VARCHAR2 |
EV_BIOSAMP8
Seq. Order: | 49 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Biological sample code, see support table MRBIO_SAMPLES for descriptions.. |
General Data Type: | VARCHAR2 |
EV_BIOSAMP9
Seq. Order: | 50 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Biological sample code, see support table MRBIO_SAMPLES for descriptions.. |
General Data Type: | VARCHAR2 |
EV_BIOSAMP10
Seq. Order: | 51 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Biological sample code, see support table MRBIO_SAMPLES for descriptions.. |
General Data Type: | VARCHAR2 |
EV_LENGTH
Seq. Order: | 52 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 2 |
Status: | Active |
Description: |
Length, for sharks: fork length in centimeters . |
General Data Type: | NUMBER |
EV_LENUOM
Seq. Order: | 53 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unit of measure for length (CM, IN). |
General Data Type: | VARCHAR2 |
EV_LENQUAL
Seq. Order: | 54 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Data quality code for length, see support table MRLENGTH_QUALITY for descriptions. |
General Data Type: | VARCHAR2 |
EV_LENTYPE
Seq. Order: | 55 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Length type code, see support table MRLENGTH_TYPES for descriptions. |
General Data Type: | VARCHAR2 |
EV_LENDET
Seq. Order: | 56 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Length determination code, see support table MRLENGTH_DETERMINATION for descriptions. |
General Data Type: | VARCHAR2 |
EV_RPTLENGTH
Seq. Order: | 57 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 2 |
Status: | Active |
Description: |
Reported length measurement. |
General Data Type: | NUMBER |
EV_RPTLENUOM
Seq. Order: | 58 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unit of measure for reported length (CM, IN). |
General Data Type: | VARCHAR2 |
EV_RPTLENQUAL
Seq. Order: | 59 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Data quality code for reported length, see support table MRLENGTH_QUALITY for descriptions. |
General Data Type: | VARCHAR2 |
EV_RPTLENTYPE
Seq. Order: | 60 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Reported length type code, see support table MRLENGTH_TYPES for descriptions. |
General Data Type: | VARCHAR2 |
EV_OTHLENGTH
Seq. Order: | 61 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Scale: | 2 |
Status: | Active |
Description: |
Other length measurement. |
General Data Type: | NUMBER |
EV_OTHLENUOM
Seq. Order: | 62 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unit of measure for other length (CM, IN). |
General Data Type: | VARCHAR2 |
EV_OTHLENQUAL
Seq. Order: | 63 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Data quality code for other length, see support table MRLENGTH_QUALITY for descriptions. |
General Data Type: | VARCHAR2 |
EV_OTHLENTYPE
Seq. Order: | 64 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Other length type code, see support table MRLENGTH_TYPES for descriptions. |
General Data Type: | VARCHAR2 |
EV_WEIGHT
Seq. Order: | 65 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Scale: | 2 |
Status: | Active |
Description: |
Weight, for sharks, whole weight in kg. |
General Data Type: | NUMBER |
EV_WGTUOM
Seq. Order: | 66 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unit of measure for weight (LB, KG). |
General Data Type: | VARCHAR2 |
EV_WGTQUAL
Seq. Order: | 67 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Weight quality code, see support table MRWEIGHT_QUALITY for descriptions. |
General Data Type: | VARCHAR2 |
EV_WGTTYPE
Seq. Order: | 68 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Weight type code, see support table MRWEIGHT_TYPES for descriptions. |
General Data Type: | VARCHAR2 |
EV_WGTDET
Seq. Order: | 69 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Weight determination code, see support table MRWEIGHT_DETERMINATION for descriptions. |
General Data Type: | VARCHAR2 |
EV_RPTWEIGHT
Seq. Order: | 70 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 2 |
Status: | Active |
Description: |
Reported weight, for sharks, whole weight in kg. |
General Data Type: | NUMBER |
EV_RPTWGTUOM
Seq. Order: | 71 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unit of measure for reported weight (LB, KG). |
General Data Type: | VARCHAR2 |
EV_RPTWGTQUAL
Seq. Order: | 72 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Reported weight quality code, see support table MRWEIGHT_QUALITY for descriptions. |
General Data Type: | VARCHAR2 |
EV_RPTWGTTYPE
Seq. Order: | 73 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Reported weight type code, see support table MRWEIGHT_TYPES for descriptions. |
General Data Type: | VARCHAR2 |
EV_CONTACTID
Seq. Order: | 74 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 0 |
Status: | Active |
Description: |
Contact id for event. |
General Data Type: | NUMBER |
EV_INDUSTRY
Seq. Order: | 75 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Industry (category, sector) at time of event, see support table MRINDUSTRY for descriptions. |
General Data Type: | VARCHAR2 |
EV_OCCUPATION
Seq. Order: | 76 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Occupation at time of event, see support table MROCCUPATION for descriptions. |
General Data Type: | VARCHAR2 |
EV_VESS_NATION
Seq. Order: | 77 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Vessel nation at time of event, see support table MRNATIONS for descriptions. |
General Data Type: | VARCHAR2 |
EV_SHVESSEL
Seq. Order: | 78 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Vessel code used by the shark fishery, see support table MRSHVESSELS for descriptions. |
General Data Type: | VARCHAR2 |
EV_GEAR
Seq. Order: | 79 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Gear used, see support table MRGEARS for descriptions. |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 34795 |
---|---|
GUID: | gov.noaa.nmfs.inport:34795 |
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 |