Search Help Show/Hide Menu
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