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 > Coastal Shark Bottom Longline Survey >

View: MRVEVENT

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:36252  |  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 9650, 01-12-2017 16:31

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: 374170
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: 374181
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: 374192
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: 374203
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: 374214
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: 374225
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: 374236
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: 374247
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: 374248
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: 374171
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: 374172
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: 374173
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: 374174
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: 374175
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: 374176
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: 374177
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: 374178
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: 374179
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: 374180
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: 374182
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: 374183
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: 374184
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: 374185
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: 374186
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: 374187
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: 374188
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: 374189
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: 374190
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: 374191
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: 374193
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: 374194
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: 374195
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: 374196
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: 374197
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: 374198
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: 374199
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: 374200
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: 374201
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: 374202
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: 374204
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: 374205
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: 374206
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: 374207
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: 374208
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: 374209
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: 374210
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: 374211
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: 374212
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: 374213
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: 374215
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: 374216
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: 374217
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: 374218
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: 374219
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: 374220
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: 374221
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: 374222
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: 374223
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: 374224
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: 374226
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: 374227
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: 374228
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: 374229
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: 374230
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: 374231
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: 374232
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: 374233
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: 374234
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: 374235
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: 374237
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: 374238
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: 374239
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: 374240
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: 374241
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: 374242
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: 374243
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: 374244
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: 374245
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: 374246
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: 36252
GUID: gov.noaa.nmfs.inport:36252
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2017-01-12 16:31+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2017-01-12
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2017-01-12
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2018-01-12