Slide Menu
Jump to Section...
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 

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