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 Atlantic States Shark Pupping and N... >

View: MRVTAGEVENT

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

Summary

Abstract

View of committed events including tag information (use to query tags)

Description

View of committed events including tag information (use to query tags)

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.
TAG_TYPE
VARCHAR2 		Style of tag, see support table MRTAGTYPES for descriptions. (Note: For yellowtail, data storage tags were migrated to tag type 40 in MRDBS, before migration, they were tag type 03)
TAG_COLOR
VARCHAR2 		Color of tag, see support table MRTAGCOLORS for descriptions.
TAG_NUMBER
VARCHAR2 		Tag identification number.
TAG_SUFFIX
VARCHAR2 		Tag suffix, for yellowtail, suffix A or B were used for transcription errors when recording tag or tag was removed from a poor condition fish and reused.
TAG_REWARD
VARCHAR2 		Reward for tag release or recapture, see support table MRTAGREWARDS for descriptions.
TAG_FATE
VARCHAR2 		Fate of tag, see support table MRTAGFATES for descriptions.
TAG_CONDITION
VARCHAR2 		Condition of tag, see support table MRTAGCONDITIONS for descriptions.
TAG_SITE
VARCHAR2 		Area of tag at recapture, see support table MRTAGSITE for descriptions.
TAG_LOCONFISH
VARCHAR2 		Location on fish where tag is attached, see support table MRTAGLOCONFISH for descriptions.
TRIPID
VARCHAR2 		Trip identification code, for yellowtail tagging, trip id consists of YT[year]-[sequential number of trip within year].
HAULNUM
VARCHAR2 		Ordinal number of the haul within the trip, set number for shark cruises.
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). (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_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_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_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_GEAR
VARCHAR2 		Gear used, see support table MRGEARS for descriptions.
HOW_REPORTED
VARCHAR2 		How recapture was reported, see support table MRRECAP_REPORTED for descriptions.
INFO_PENDING
VARCHAR2 		Additional information is pending about the recapture 0 = no, 1 = yes.
DATE_ENTERED
VARCHAR2 		Date of Entry.
DATE_LAST_UPDATED
VARCHAR2 		Date of Last Update

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: MRVTAGEVENT
Short Name: MRVTAGEVENT
Status: Completed
Abstract:

View of committed events including tag information (use to query tags)
Notes:

Loaded by batch 9270, 09-13-2016 10:42

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: MRDBS
Description:

View of committed events including tag information (use to query tags)

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
 TAG_TYPE VARCHAR2 Style of tag, see support table MRTAGTYPES for descriptions. (Note: For yellowtail, data storage tags were migrated to tag type 40 in MRDBS, before migration, they were tag type 03)
100
 TAG_COLOR VARCHAR2 Color of tag, see support table MRTAGCOLORS for descriptions.
100
 TAG_NUMBER VARCHAR2 Tag identification number.
100
 TAG_SUFFIX VARCHAR2 Tag suffix, for yellowtail, suffix A or B were used for transcription errors when recording tag or tag was removed from a poor condition fish and reused.
100
 TAG_REWARD VARCHAR2 Reward for tag release or recapture, see support table MRTAGREWARDS for descriptions.
100
 TAG_FATE VARCHAR2 Fate of tag, see support table MRTAGFATES for descriptions.
100
 TAG_CONDITION VARCHAR2 Condition of tag, see support table MRTAGCONDITIONS for descriptions.
100
 TAG_SITE VARCHAR2 Area of tag at recapture, see support table MRTAGSITE for descriptions.
100
 TAG_LOCONFISH VARCHAR2 Location on fish where tag is attached, see support table MRTAGLOCONFISH for descriptions.
100
 TRIPID VARCHAR2 Trip identification code, for yellowtail tagging, trip id consists of YT[year]-[sequential number of trip within year].
100
 HAULNUM VARCHAR2 Ordinal number of the haul within the trip, set number for shark cruises.
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). (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_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_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_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_GEAR VARCHAR2 Gear used, see support table MRGEARS for descriptions.
100
 HOW_REPORTED VARCHAR2 How recapture was reported, see support table MRRECAP_REPORTED for descriptions.
100
 INFO_PENDING VARCHAR2 Additional information is pending about the recapture 0 = no, 1 = yes.
100
 DATE_ENTERED VARCHAR2 Date of Entry.
100
 DATE_LAST_UPDATED VARCHAR2 Date of Last Update

Attribute Details

FISHERY

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

TAG_TYPE

CC ID: 349470
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 2
Required: Yes
Primary Key: No
Status: Active
Description:

Style of tag, see support table MRTAGTYPES for descriptions. (Note: For yellowtail, data storage tags were migrated to tag type 40 in MRDBS, before migration, they were tag type 03)
General Data Type: VARCHAR2

TAG_COLOR

CC ID: 349481
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 2
Required: Yes
Primary Key: No
Status: Active
Description:

Color of tag, see support table MRTAGCOLORS for descriptions.
General Data Type: VARCHAR2

TAG_NUMBER

CC ID: 349492
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 6
Required: Yes
Primary Key: No
Status: Active
Description:

Tag identification number.
General Data Type: VARCHAR2

TAG_SUFFIX

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

Tag suffix, for yellowtail, suffix A or B were used for transcription errors when recording tag or tag was removed from a poor condition fish and reused.
General Data Type: VARCHAR2

TAG_REWARD

CC ID: 349514
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Reward for tag release or recapture, see support table MRTAGREWARDS for descriptions.
General Data Type: VARCHAR2

TAG_FATE

CC ID: 349525
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Fate of tag, see support table MRTAGFATES for descriptions.
General Data Type: VARCHAR2

TAG_CONDITION

CC ID: 349531
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Condition of tag, see support table MRTAGCONDITIONS for descriptions.
General Data Type: VARCHAR2

TAG_SITE

CC ID: 349532
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Area of tag at recapture, see support table MRTAGSITE for descriptions.
General Data Type: VARCHAR2

TAG_LOCONFISH

CC ID: 349460
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Location on fish where tag is attached, see support table MRTAGLOCONFISH for descriptions.
General Data Type: VARCHAR2

TRIPID

CC ID: 349461
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Trip identification code, for yellowtail tagging, trip id consists of YT[year]-[sequential number of trip within year].
General Data Type: VARCHAR2

HAULNUM

CC ID: 349462
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Ordinal number of the haul within the trip, set number for shark cruises.
General Data Type: VARCHAR2

ANIMALID

CC ID: 349463
Seq. Order: 13
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: 349464
Seq. Order: 14
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: 349465
Seq. Order: 15
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: 349466
Seq. Order: 16
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: 349467
Seq. Order: 17
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: 349468
Seq. Order: 18
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: 349469
Seq. Order: 19
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: 349471
Seq. Order: 20
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: 349472
Seq. Order: 21
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: 349473
Seq. Order: 22
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: 349474
Seq. Order: 23
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Miles from reported location (used for location calculation). (redacted)

General Data Type: NUMBER

EV_DIRECTION

CC ID: 349475
Seq. Order: 24
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: 349476
Seq. Order: 25
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: 349477
Seq. Order: 26
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: 349478
Seq. Order: 27
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: 349479
Seq. Order: 28
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: 349480
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 9
Required: No
Primary Key: No
Status: Active
Description:

Latitude in decimal degrees. (redacted)

General Data Type: VARCHAR2

EV_LONDEG

CC ID: 349482
Seq. Order: 30
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: 349483
Seq. Order: 31
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: 349484
Seq. Order: 32
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: 349485
Seq. Order: 33
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: 349486
Seq. Order: 34
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Longitude in decimal degrees. (redacted)

General Data Type: VARCHAR2

EV_LOCQUAL

CC ID: 349487
Seq. Order: 35
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_DEPTH

CC ID: 349488
Seq. Order: 36
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: 349489
Seq. Order: 37
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: 349490
Seq. Order: 38
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: 349491
Seq. Order: 39
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: 349493
Seq. Order: 40
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_TRAVELDEG

CC ID: 349494
Seq. Order: 41
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: 349495
Seq. Order: 42
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: 349496
Seq. Order: 43
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: 349497
Seq. Order: 44
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_LENGTH

CC ID: 349498
Seq. Order: 45
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 2
Status: Active
Description:

Length, for sharks: fork length in centimeters .
General Data Type: NUMBER

EV_LENUOM

CC ID: 349499
Seq. Order: 46
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: 349500
Seq. Order: 47
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: 349501
Seq. Order: 48
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: 349502
Seq. Order: 49
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: 349504
Seq. Order: 50
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: 349505
Seq. Order: 51
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: 349506
Seq. Order: 52
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: 349507
Seq. Order: 53
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: 349508
Seq. Order: 54
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 2
Status: Active
Description:

Other length measurement.
General Data Type: NUMBER

EV_OTHLENUOM

CC ID: 349509
Seq. Order: 55
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: 349510
Seq. Order: 56
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: 349511
Seq. Order: 57
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: 349512
Seq. Order: 58
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 2
Status: Active
Description:

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

EV_WGTUOM

CC ID: 349513
Seq. Order: 59
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: 349515
Seq. Order: 60
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: 349516
Seq. Order: 61
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: 349517
Seq. Order: 62
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: 349518
Seq. Order: 63
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: 349519
Seq. Order: 64
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: 349520
Seq. Order: 65
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: 349521
Seq. Order: 66
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: 349522
Seq. Order: 67
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Contact id for event.
General Data Type: NUMBER

EV_INDUSTRY

CC ID: 349523
Seq. Order: 68
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: 349524
Seq. Order: 69
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_GEAR

CC ID: 349526
Seq. Order: 70
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

HOW_REPORTED

CC ID: 349527
Seq. Order: 71
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

How recapture was reported, see support table MRRECAP_REPORTED for descriptions.
General Data Type: VARCHAR2

INFO_PENDING

CC ID: 349528
Seq. Order: 72
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Additional information is pending about the recapture 0 = no, 1 = yes.
General Data Type: VARCHAR2

DATE_ENTERED

CC ID: 349529
Seq. Order: 73
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Date of Entry.
General Data Type: VARCHAR2

DATE_LAST_UPDATED

CC ID: 349530
Seq. Order: 74
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Date of Last Update
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 34796
GUID: gov.noaa.nmfs.inport:34796
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-09-13 10:42+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-09-13
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-09-13
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-09-13