Table: MRMVRELRECAP_AREAS01
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33880 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Release and Recapture Statistical Areas for Yellowtail Fishery
DescriptionRelease and Recapture Statistical Areas for Yellowtail Fishery
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
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) |
TAG_NUMBER
VARCHAR2 |
Tag identification number. |
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. |
ANIMALID
VARCHAR2 |
Animal identification code, animal id will be a concatenation of fishery, original tag type, color, number, and suffix. |
REL_EVENTNUM
NUMBER |
Release event number. |
TRIPID
VARCHAR2 |
Trip identification code, for yellowtail tagging, trip id consists of YT[year]-[sequential number of trip within year]. |
HAULNUM
VARCHAR2 |
Ordinal number of the haul within the trip, set number for shark cruises. |
REL_ENTSTATAREA
VARCHAR2 |
Release statistical area as entered from captain's log. |
REL_CALCSTATAREA
VARCHAR2 |
Release statistical area calculated from latitude and longitude. |
REC_EVENTNUM
NUMBER |
Recapture event number. |
REC_STATAREA
VARCHAR2 |
Recapture statistical area from latitude and longitude. |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (NEFSC) for inquiries on this record.
Item Identification
Title: | Table: MRMVRELRECAP_AREAS01 |
---|---|
Short Name: | MRMVRELRECAP_AREAS01 |
Status: | Completed |
Abstract: |
Release and Recapture Statistical Areas for Yellowtail Fishery |
Notes: |
Loaded by batch 9110, 08-01-2016 12:11 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | MRDBS |
Description: |
Release and Recapture Statistical Areas for Yellowtail Fishery |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
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_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
|
ANIMALID | VARCHAR2 | Animal identification code, animal id will be a concatenation of fishery, original tag type, color, number, and suffix. | |
100
|
REL_EVENTNUM | NUMBER | Release event number. | |
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
|
REL_ENTSTATAREA | VARCHAR2 | Release statistical area as entered from captain's log. | |
100
|
REL_CALCSTATAREA | VARCHAR2 | Release statistical area calculated from latitude and longitude. | |
100
|
REC_EVENTNUM | NUMBER | Recapture event number. | |
100
|
REC_STATAREA | VARCHAR2 | Recapture statistical area from latitude and longitude. |
Attribute Details
TAG_TYPE
Seq. Order: | 1 |
---|---|
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_NUMBER
Seq. Order: | 2 |
---|---|
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: | 3 |
---|---|
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 |
ANIMALID
Seq. Order: | 4 |
---|---|
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 |
REL_EVENTNUM
Seq. Order: | 5 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Release event number. |
General Data Type: | NUMBER |
TRIPID
Seq. Order: | 6 |
---|---|
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: | 7 |
---|---|
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 |
REL_ENTSTATAREA
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Release statistical area as entered from captain's log. |
General Data Type: | VARCHAR2 |
REL_CALCSTATAREA
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Release statistical area calculated from latitude and longitude. |
General Data Type: | VARCHAR2 |
REC_EVENTNUM
Seq. Order: | 10 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Recapture event number. |
General Data Type: | NUMBER |
REC_STATAREA
Seq. Order: | 11 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Recapture statistical area from latitude and longitude. |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 33880 |
---|---|
GUID: | gov.noaa.nmfs.inport:33880 |
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 |