View: MRVTAGEVENT
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33549 | Updated: August 9, 2022 | Published / External
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 9052, 07-27-2016 15:26 |
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
|
|
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: 333690
| 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: 333701
| 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: 333712
| 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: 333723
| 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: 333734
| 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: 333745
| 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: 333756
| 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: 333762
| 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: 333763
| 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: 333691
| 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: 333692
| 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: 333693
| 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: 333694
| 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: 333695
| 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: 333696
| 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: 333697
| 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: 333698
| 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: 333699
| 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: 333700
| 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: 333702
| 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: 333703
| 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: 333704
| 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: 333705
| Seq. Order: | 23 |
|---|---|
| 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: 333706
| 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: 333707
| 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: 333708
| 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: 333709
| 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: 333710
| 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: 333711
| 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: 333713
| 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: 333714
| 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: 333715
| 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: 333716
| 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: 333717
| 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: 333718
| 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: 333719
| 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: 333720
| 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: 333721
| 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: 333722
| 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: 333724
| 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: 333725
| 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: 333726
| 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: 333727
| 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: 333728
| 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: 333729
| Seq. Order: | 45 |
|---|---|
| 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: 333730
| 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: 333731
| 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: 333732
| 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: 333733
| 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: 333735
| 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: 333736
| 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: 333737
| 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: 333738
| 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: 333739
| Seq. Order: | 54 |
|---|---|
| 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: 333740
| 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: 333741
| 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: 333742
| 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: 333743
| Seq. Order: | 58 |
|---|---|
| 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: 333744
| 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: 333746
| 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: 333747
| 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: 333748
| 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: 333749
| 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: 333750
| 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: 333751
| 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: 333752
| 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: 333753
| Seq. Order: | 67 |
|---|---|
| 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: 333754
| 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: 333755
| 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: 333757
| 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: 333758
| 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: 333759
| 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: 333760
| 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: 333761
| 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: | 33549 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:33549 |
| Metadata Record Created By: | Patricia L Jones |
| Metadata Record Created: | 2016-07-27 15:26+0000 |
| Metadata Record Last Modified By: | SysAdmin InPortAdmin |
| Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
| Metadata Record Published: | 2016-07-27 |
| Owner Org: | NEFSC |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2016-07-27 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2017-07-27 |