Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Northeast Cooperative Research Program (NCRP) > Yellowtail Tagging Data (MRDBS) >

View: MRVEVENT

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:33882  |  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_MILES
NUMBER 		Miles from reported location (used for location calculation).
EV_DIRECTION
VARCHAR2 		Direction from reported location (used for location calculation).
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. (unused for yellowtail)
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_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. (unused for yellowtail)
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 9110, 08-01-2016 12:11

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_MILES NUMBER Miles from reported location (used for location calculation).
100
 EV_DIRECTION VARCHAR2 Direction from reported location (used for location calculation).
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. (unused for yellowtail)
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_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. (unused for yellowtail)
100
 EV_GEAR VARCHAR2 Gear used, see support table MRGEARS for descriptions.

Attribute Details

FISHERY

CC ID: 341001
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: 341012
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: 341023
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: 341034
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: 341045
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: 341056
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: 341066
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: 341067
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: 341068
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: 341002
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: 341003
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_MILES

CC ID: 341004
Seq. Order: 12
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).
General Data Type: NUMBER

EV_DIRECTION

CC ID: 341005
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Direction from reported location (used for location calculation).
General Data Type: VARCHAR2

EV_LATDEG

CC ID: 341006
Seq. Order: 14
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: 341007
Seq. Order: 15
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: 341008
Seq. Order: 16
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: 341009
Seq. Order: 17
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: 341010
Seq. Order: 18
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: 341011
Seq. Order: 19
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: 341013
Seq. Order: 20
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: 341014
Seq. Order: 21
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: 341015
Seq. Order: 22
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: 341016
Seq. Order: 23
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: 341017
Seq. Order: 24
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: 341018
Seq. Order: 25
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: 341019
Seq. Order: 26
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 7
Scale: 1
Status: Active
Description:

Loran x. (redacted)
General Data Type: NUMBER

EV_LORAN2

CC ID: 341020
Seq. Order: 27
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 7
Scale: 1
Status: Active
Description:

Loran y. (redacted)
General Data Type: NUMBER

EV_DEPTH

CC ID: 341021
Seq. Order: 28
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: 341022
Seq. Order: 29
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: 341024
Seq. Order: 30
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: 341025
Seq. Order: 31
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: 341026
Seq. Order: 32
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: 341027
Seq. Order: 33
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. (unused for yellowtail)
General Data Type: VARCHAR2

EV_TRAVELDEG

CC ID: 341028
Seq. Order: 34
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: 341029
Seq. Order: 35
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: 341030
Seq. Order: 36
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: 341031
Seq. Order: 37
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: 341032
Seq. Order: 38
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: 341033
Seq. Order: 39
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: 341035
Seq. Order: 40
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_LENGTH

CC ID: 341036
Seq. Order: 41
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: 341037
Seq. Order: 42
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: 341038
Seq. Order: 43
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: 341039
Seq. Order: 44
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: 341040
Seq. Order: 45
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: 341041
Seq. Order: 46
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: 341042
Seq. Order: 47
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: 341043
Seq. Order: 48
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: 341044
Seq. Order: 49
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: 341046
Seq. Order: 50
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: 341047
Seq. Order: 51
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: 341048
Seq. Order: 52
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: 341049
Seq. Order: 53
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: 341050
Seq. Order: 54
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: 341051
Seq. Order: 55
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: 341052
Seq. Order: 56
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: 341053
Seq. Order: 57
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: 341054
Seq. Order: 58
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: 341055
Seq. Order: 59
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: 341057
Seq. Order: 60
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: 341058
Seq. Order: 61
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: 341059
Seq. Order: 62
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: 341060
Seq. Order: 63
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: 341061
Seq. Order: 64
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: 341062
Seq. Order: 65
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: 341063
Seq. Order: 66
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: 341064
Seq. Order: 67
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. (unused for yellowtail)
General Data Type: VARCHAR2

EV_GEAR

CC ID: 341065
Seq. Order: 68
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: 33882
GUID: gov.noaa.nmfs.inport:33882
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-08-01 12:11+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2017-02-24
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2017-02-24
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2018-02-24