Slide Menu
Search Help Show/Hide Menu

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