Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Population and Ecosystems Monitoring and Analys... > Population Biology Branch > Apex Predators Program > Cooperative Shark Mark Recapture Database (MRDB... >

View: MRVEVENT

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:33548  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

View of committed events without tag information (use to query animals)

Description

View 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 9052, 07-27-2016 15:26

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

Rubric Score Primary Key? Name Type Description
100
 FISHERY VARCHAR2 Fishery Code, a two character fishery identification code. See support table MRFISHERY for codes and descriptions.
100
 ANIMALID VARCHAR2 Animal identification code, animal id will be a concatenation of fishery, original tag type, color, number, and suffix.
100
 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

CC ID: 333611
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: 333622
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

CC ID: 333633
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 3
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

CC ID: 333644
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

CC ID: 333655
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

CC ID: 333666
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

CC ID: 333677
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

CC ID: 333688
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

CC ID: 333689
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

CC ID: 333612
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

CC ID: 333613
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

CC ID: 333614
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

CC ID: 333615
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Miles from reported location (used for location calculation). (redacted)
General Data Type: NUMBER

EV_DIRECTION

CC ID: 333616
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

CC ID: 333617
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

CC ID: 333618
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

CC ID: 333619
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

CC ID: 333620
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

CC ID: 333621
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

CC ID: 333623
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

CC ID: 333624
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

CC ID: 333625
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

CC ID: 333626
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

CC ID: 333627
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

CC ID: 333628
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

CC ID: 333629
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

CC ID: 333630
Seq. Order: 27
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 8
Scale: 2
Status: Active
Description:

Loran x. (redacted)
General Data Type: NUMBER

EV_LORAN2

CC ID: 333631
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

CC ID: 333632
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

CC ID: 333634
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

CC ID: 333635
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

CC ID: 333636
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

CC ID: 333637
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

CC ID: 333638
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

CC ID: 333639
Seq. Order: 35
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 1
Status: Active
Description:

Travel direction for recapture only, see MRDIRECTIONS for descriptions.
General Data Type: NUMBER

EV_TRAVELDIR

CC ID: 333640
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

CC ID: 333641
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

CC ID: 333642
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

CC ID: 333643
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

CC ID: 333645
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

CC ID: 333646
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

CC ID: 333647
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

CC ID: 333648
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

CC ID: 333649
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

CC ID: 333650
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

CC ID: 333651
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

CC ID: 333652
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

CC ID: 333653
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

CC ID: 333654
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

CC ID: 333656
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

CC ID: 333657
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

CC ID: 333658
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

CC ID: 333659
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

CC ID: 333660
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

CC ID: 333661
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

CC ID: 333662
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

CC ID: 333663
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

CC ID: 333664
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

CC ID: 333665
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

CC ID: 333667
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

CC ID: 333668
Seq. Order: 61
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

Other length measurement.
General Data Type: NUMBER

EV_OTHLENUOM

CC ID: 333669
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

CC ID: 333670
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

CC ID: 333671
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

CC ID: 333672
Seq. Order: 65
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

Weight, for sharks, whole weight in kg.
General Data Type: NUMBER

EV_WGTUOM

CC ID: 333673
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

CC ID: 333674
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

CC ID: 333675
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

CC ID: 333676
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

CC ID: 333678
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

CC ID: 333679
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

CC ID: 333680
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

CC ID: 333681
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

CC ID: 333682
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

CC ID: 333683
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

CC ID: 333684
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

CC ID: 333685
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

CC ID: 333686
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

CC ID: 333687
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: 33548
GUID: gov.noaa.nmfs.inport:33548
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-07-27 15:26+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-07-27
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-07-27
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-07-27