View: MRVTAGEVENT
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34796 | 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 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |