View: MRVTAGEVENT
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33883 | 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 9110, 08-01-2016 12:11 |
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
|
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). | |
|
100
|
EV_DIRECTION | VARCHAR2 | Direction from reported location (used for location calculation). | |
|
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: 341069
| 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: 341080
| 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: 341091
| 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: 341102
| 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: 341113
| 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: 341124
| 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: 341135
| 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: 341139
| 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: 341140
| 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: 341070
| 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 |
ANIMALID
CC ID: 341071
| Seq. Order: | 11 |
|---|---|
| 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: 341072
| Seq. Order: | 12 |
|---|---|
| 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: 341073
| Seq. Order: | 13 |
|---|---|
| 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: 341074
| Seq. Order: | 14 |
|---|---|
| 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: 341075
| Seq. Order: | 15 |
|---|---|
| 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: 341076
| Seq. Order: | 16 |
|---|---|
| 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: 341077
| Seq. Order: | 17 |
|---|---|
| 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: 341078
| Seq. Order: | 18 |
|---|---|
| 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: 341079
| Seq. Order: | 19 |
|---|---|
| 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: 341081
| Seq. Order: | 20 |
|---|---|
| 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: 341082
| Seq. Order: | 21 |
|---|---|
| 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). |
| General Data Type: | NUMBER |
EV_DIRECTION
CC ID: 341083
| Seq. Order: | 22 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 5 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Direction from reported location (used for location calculation). |
| General Data Type: | VARCHAR2 |
EV_LATDEG
CC ID: 341084
| Seq. Order: | 23 |
|---|---|
| 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: 341085
| Seq. Order: | 24 |
|---|---|
| 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: 341086
| Seq. Order: | 25 |
|---|---|
| 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: 341087
| Seq. Order: | 26 |
|---|---|
| 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: 341088
| Seq. Order: | 27 |
|---|---|
| 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: 341089
| Seq. Order: | 28 |
|---|---|
| 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: 341090
| Seq. Order: | 29 |
|---|---|
| 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: 341092
| Seq. Order: | 30 |
|---|---|
| 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: 341093
| Seq. Order: | 31 |
|---|---|
| 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: 341094
| Seq. Order: | 32 |
|---|---|
| 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: 341095
| Seq. Order: | 33 |
|---|---|
| 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: 341096
| Seq. Order: | 34 |
|---|---|
| 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: 341097
| Seq. Order: | 35 |
|---|---|
| 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: 341098
| Seq. Order: | 36 |
|---|---|
| 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: 341099
| Seq. Order: | 37 |
|---|---|
| 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: 341100
| Seq. Order: | 38 |
|---|---|
| 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: 341101
| Seq. Order: | 39 |
|---|---|
| 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: 341103
| Seq. Order: | 40 |
|---|---|
| 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: 341104
| Seq. Order: | 41 |
|---|---|
| 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: 341105
| Seq. Order: | 42 |
|---|---|
| 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: 341106
| Seq. Order: | 43 |
|---|---|
| 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: 341107
| Seq. Order: | 44 |
|---|---|
| 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: 341108
| Seq. Order: | 45 |
|---|---|
| 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: 341109
| Seq. Order: | 46 |
|---|---|
| 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: 341110
| Seq. Order: | 47 |
|---|---|
| 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: 341111
| Seq. Order: | 48 |
|---|---|
| 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: 341112
| Seq. Order: | 49 |
|---|---|
| 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: 341114
| Seq. Order: | 50 |
|---|---|
| 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: 341115
| Seq. Order: | 51 |
|---|---|
| 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: 341116
| Seq. Order: | 52 |
|---|---|
| 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: 341117
| Seq. Order: | 53 |
|---|---|
| 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: 341118
| Seq. Order: | 54 |
|---|---|
| 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: 341119
| Seq. Order: | 55 |
|---|---|
| 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: 341120
| Seq. Order: | 56 |
|---|---|
| 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: 341121
| Seq. Order: | 57 |
|---|---|
| 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: 341122
| Seq. Order: | 58 |
|---|---|
| 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: 341123
| Seq. Order: | 59 |
|---|---|
| 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: 341125
| Seq. Order: | 60 |
|---|---|
| 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: 341126
| Seq. Order: | 61 |
|---|---|
| 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: 341127
| Seq. Order: | 62 |
|---|---|
| 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: 341128
| Seq. Order: | 63 |
|---|---|
| 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: 341129
| Seq. Order: | 64 |
|---|---|
| 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: 341130
| Seq. Order: | 65 |
|---|---|
| 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: 341131
| Seq. Order: | 66 |
|---|---|
| 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: 341132
| Seq. Order: | 67 |
|---|---|
| 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: 341133
| Seq. Order: | 68 |
|---|---|
| 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: 341134
| Seq. Order: | 69 |
|---|---|
| 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: 341136
| Seq. Order: | 70 |
|---|---|
| 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: 341137
| Seq. Order: | 71 |
|---|---|
| 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: 341138
| Seq. Order: | 72 |
|---|---|
| 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: | 33883 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:33883 |
| Metadata Record Created By: | Patricia L Jones |
| Metadata Record Created: | 2016-08-01 12:11+0000 |
| Metadata Record Last Modified By: | SysAdmin InPortAdmin |
| Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
| Metadata Record Published: | 2017-02-24 |
| Owner Org: | NEFSC |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2017-02-24 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2018-02-24 |