Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Data for cooperative research tagging studies in MHI and Guam.

Description

Data for cooperative research tagging studies in MHI and Guam.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
DATASET_CODE
VARCHAR2
Source ID Code assigned by the data entry staff (FC076).
VERSION_CODE
VARCHAR2
Code for the format version assigned by the data entry staff.
ISLAND
VARCHAR2
Island where fishing took place.
VESSEL_NAME
VARCHAR2
Vessel name.
CAPTAIN_FIRST_NAME
VARCHAR2
First name of captain.
CAPTAIN_LAST_NAME
VARCHAR2
Last name of captain.
TRIP_START_MONTH
VARCHAR2
The month the trip started in.
TRIP_START_DAY
VARCHAR2
The day the trip started on.
TRIP_START_YEAR
VARCHAR2
The year the trip started in.
TRIP_END_MONTH
VARCHAR2
The month the trip ended in.
TRIP_END_DAY
VARCHAR2
The day the trip ended on.
TRIP_END_YEAR
VARCHAR2
The year the trip ended in.
FISHING_LOCATION
VARCHAR2
Location where fishing occurred, if written in.
TAG_NUMBER_1
VARCHAR2
Tag number.
FORK_LENGTH_INCHES
VARCHAR2
Fork length in inches. Units for values are inches.
FORK_LENGTH_CENTIMETERS
VARCHAR2
Fork length in centimeters. Units for values are centimeters.
PURGE
VARCHAR2
Was a tool used to treat barotrauma (Y=yes, Blank=no).
DROP_SHOT
VARCHAR2
Was a weighted recompression device used to treat baratrauma (Y=yes, Blank=no).
RECAPTURED
VARCHAR2
Was the fish a recapture (Y=yes, Blank=no).
RECAPTURED_AND_RELEASED
VARCHAR2
If the fish was a recapture, was it released (Y=yes, Blank=no).
TAG_NUMBER_2
VARCHAR2
Additional tag number.
SPECIES
VARCHAR2
Species of fish caught.
DATE_CAPTURED_MONTH
VARCHAR2
Month fish was caught.
DATE_CAPTURED_DAY
VARCHAR2
Day fish was caught.
DATE_CAPTURED_YEAR
VARCHAR2
Year fish was caught.
LATITUDE_DEGREES
VARCHAR2
Degrees latitutde where fish was caught. Units for values are degrees.
LATITUDE_MINUTES
VARCHAR2
Minutes latitutde where fish was caught. Units for values are minutes.
LATITUDE_DIRECTION
VARCHAR2
Latitude direction (N/S) where fish was caught.
LONGITUDE_DEGREES
VARCHAR2
Degrees longitude where fish was caught. Units for values are degrees.
LONGITUDE_MINUTES
VARCHAR2
Minutes longitude where fish was caught. Units for values are minutes.
LONGITUDE_DIRECTION
VARCHAR2
Longitude direction (E/W) where fish was caught.
STATE_CHART_AREA_CODE
VARCHAR2
State of Hawaii area code, if in Hawaii.
DEPTH_FATHOMS
VARCHAR2
Depth in fathoms where fish was caught. Units for values are fathoms.
DEPTH_METERS
VARCHAR2
Depth in meters where fish was caught. Units for values are meters.
NOTES_LINE_1
VARCHAR2
First line of comments from fisher.
NOTES_LINE_2
VARCHAR2
Second line of comments from fisher.
NOTES_LINE_3
VARCHAR2
Third line of comments from fisher.
JOB_NUMBER
VARCHAR2
A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D12045.
FROM_FILE
VARCHAR2
Name of the flat ASCII file that was the source of the data.
DATE_LOADED
DATE
Date when the record was loaded into Oracle or updated.
TAGGER
VARCHAR2
Name of individual tagging the fish.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (PIFSC) for inquiries on this record.

Item Identification

Title: PIFG_TAGGING
Short Name: PIFG_TAGGING
Status: Completed
Abstract:

Data for cooperative research tagging studies in MHI and Guam.

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

Data for cooperative research tagging studies in MHI and Guam.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
DATASET_CODE VARCHAR2 Source ID Code assigned by the data entry staff (FC076).
100
VERSION_CODE VARCHAR2 Code for the format version assigned by the data entry staff.
100
ISLAND VARCHAR2 Island where fishing took place.
100
VESSEL_NAME VARCHAR2 Vessel name.
100
CAPTAIN_FIRST_NAME VARCHAR2 First name of captain.
100
CAPTAIN_LAST_NAME VARCHAR2 Last name of captain.
100
TRIP_START_MONTH VARCHAR2 The month the trip started in.
100
TRIP_START_DAY VARCHAR2 The day the trip started on.
100
TRIP_START_YEAR VARCHAR2 The year the trip started in.
100
TRIP_END_MONTH VARCHAR2 The month the trip ended in.
100
TRIP_END_DAY VARCHAR2 The day the trip ended on.
100
TRIP_END_YEAR VARCHAR2 The year the trip ended in.
100
FISHING_LOCATION VARCHAR2 Location where fishing occurred, if written in.
100
TAG_NUMBER_1 VARCHAR2 Tag number.
100
FORK_LENGTH_INCHES VARCHAR2 Fork length in inches. Units for values are inches.
100
FORK_LENGTH_CENTIMETERS VARCHAR2 Fork length in centimeters. Units for values are centimeters.
100
PURGE VARCHAR2 Was a tool used to treat barotrauma (Y=yes, Blank=no).
100
DROP_SHOT VARCHAR2 Was a weighted recompression device used to treat baratrauma (Y=yes, Blank=no).
100
RECAPTURED VARCHAR2 Was the fish a recapture (Y=yes, Blank=no).
100
RECAPTURED_AND_RELEASED VARCHAR2 If the fish was a recapture, was it released (Y=yes, Blank=no).
100
TAG_NUMBER_2 VARCHAR2 Additional tag number.
100
SPECIES VARCHAR2 Species of fish caught.
100
DATE_CAPTURED_MONTH VARCHAR2 Month fish was caught.
100
DATE_CAPTURED_DAY VARCHAR2 Day fish was caught.
100
DATE_CAPTURED_YEAR VARCHAR2 Year fish was caught.
100
LATITUDE_DEGREES VARCHAR2 Degrees latitutde where fish was caught. Units for values are degrees.
100
LATITUDE_MINUTES VARCHAR2 Minutes latitutde where fish was caught. Units for values are minutes.
100
LATITUDE_DIRECTION VARCHAR2 Latitude direction (N/S) where fish was caught.
100
LONGITUDE_DEGREES VARCHAR2 Degrees longitude where fish was caught. Units for values are degrees.
100
LONGITUDE_MINUTES VARCHAR2 Minutes longitude where fish was caught. Units for values are minutes.
100
LONGITUDE_DIRECTION VARCHAR2 Longitude direction (E/W) where fish was caught.
100
STATE_CHART_AREA_CODE VARCHAR2 State of Hawaii area code, if in Hawaii.
100
DEPTH_FATHOMS VARCHAR2 Depth in fathoms where fish was caught. Units for values are fathoms.
100
DEPTH_METERS VARCHAR2 Depth in meters where fish was caught. Units for values are meters.
100
NOTES_LINE_1 VARCHAR2 First line of comments from fisher.
100
NOTES_LINE_2 VARCHAR2 Second line of comments from fisher.
100
NOTES_LINE_3 VARCHAR2 Third line of comments from fisher.
100
JOB_NUMBER VARCHAR2 A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D12045.
100
FROM_FILE VARCHAR2 Name of the flat ASCII file that was the source of the data.
100
DATE_LOADED DATE Date when the record was loaded into Oracle or updated.
100
TAGGER VARCHAR2 Name of individual tagging the fish.

Attribute Details

DATASET_CODE

CC ID: 895991
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Source ID Code assigned by the data entry staff (FC076).

General Data Type: VARCHAR2

VERSION_CODE

CC ID: 895992
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Code for the format version assigned by the data entry staff.

General Data Type: VARCHAR2

ISLAND

CC ID: 895993
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Island where fishing took place.

General Data Type: VARCHAR2

VESSEL_NAME

CC ID: 895994
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Vessel name.

General Data Type: VARCHAR2

CAPTAIN_FIRST_NAME

CC ID: 895995
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

First name of captain.

General Data Type: VARCHAR2

CAPTAIN_LAST_NAME

CC ID: 895996
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Last name of captain.

General Data Type: VARCHAR2

TRIP_START_MONTH

CC ID: 895997
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

The month the trip started in.

General Data Type: VARCHAR2

TRIP_START_DAY

CC ID: 895998
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

The day the trip started on.

General Data Type: VARCHAR2

TRIP_START_YEAR

CC ID: 895999
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

The year the trip started in.

General Data Type: VARCHAR2

TRIP_END_MONTH

CC ID: 896000
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

The month the trip ended in.

General Data Type: VARCHAR2

TRIP_END_DAY

CC ID: 896001
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

The day the trip ended on.

General Data Type: VARCHAR2

TRIP_END_YEAR

CC ID: 896002
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

The year the trip ended in.

General Data Type: VARCHAR2

FISHING_LOCATION

CC ID: 896003
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 60
Required: No
Primary Key: No
Status: Active
Description:

Location where fishing occurred, if written in.

General Data Type: VARCHAR2

TAG_NUMBER_1

CC ID: 896004
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Tag number.

General Data Type: VARCHAR2

FORK_LENGTH_INCHES

CC ID: 896005
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

Fork length in inches. Units for values are inches.

General Data Type: VARCHAR2
Unit of Measure: inches

FORK_LENGTH_CENTIMETERS

CC ID: 896006
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

Fork length in centimeters. Units for values are centimeters.

General Data Type: VARCHAR2
Unit of Measure: centimeters

PURGE

CC ID: 896007
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Was a tool used to treat barotrauma (Y=yes, Blank=no).

General Data Type: VARCHAR2

DROP_SHOT

CC ID: 896008
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Was a weighted recompression device used to treat baratrauma (Y=yes, Blank=no).

General Data Type: VARCHAR2

RECAPTURED

CC ID: 896009
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Was the fish a recapture (Y=yes, Blank=no).

General Data Type: VARCHAR2

RECAPTURED_AND_RELEASED

CC ID: 896010
Seq. Order: 20
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

If the fish was a recapture, was it released (Y=yes, Blank=no).

General Data Type: VARCHAR2

TAG_NUMBER_2

CC ID: 896011
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Additional tag number.

General Data Type: VARCHAR2

SPECIES

CC ID: 896012
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Species of fish caught.

General Data Type: VARCHAR2

DATE_CAPTURED_MONTH

CC ID: 896013
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Month fish was caught.

General Data Type: VARCHAR2

DATE_CAPTURED_DAY

CC ID: 896014
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Day fish was caught.

General Data Type: VARCHAR2

DATE_CAPTURED_YEAR

CC ID: 896015
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Year fish was caught.

General Data Type: VARCHAR2

LATITUDE_DEGREES

CC ID: 896016
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Degrees latitutde where fish was caught. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees

LATITUDE_MINUTES

CC ID: 896017
Seq. Order: 27
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

Minutes latitutde where fish was caught. Units for values are minutes.

General Data Type: VARCHAR2
Unit of Measure: minutes

LATITUDE_DIRECTION

CC ID: 896018
Seq. Order: 28
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Latitude direction (N/S) where fish was caught.

General Data Type: VARCHAR2

LONGITUDE_DEGREES

CC ID: 896019
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Degrees longitude where fish was caught. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees

LONGITUDE_MINUTES

CC ID: 896020
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

Minutes longitude where fish was caught. Units for values are minutes.

General Data Type: VARCHAR2
Unit of Measure: minutes

LONGITUDE_DIRECTION

CC ID: 896021
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Longitude direction (E/W) where fish was caught.

General Data Type: VARCHAR2

STATE_CHART_AREA_CODE

CC ID: 896022
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

State of Hawaii area code, if in Hawaii.

General Data Type: VARCHAR2

DEPTH_FATHOMS

CC ID: 896023
Seq. Order: 33
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Depth in fathoms where fish was caught. Units for values are fathoms.

General Data Type: VARCHAR2
Unit of Measure: fathoms

DEPTH_METERS

CC ID: 896024
Seq. Order: 34
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Depth in meters where fish was caught. Units for values are meters.

General Data Type: VARCHAR2
Unit of Measure: meters

NOTES_LINE_1

CC ID: 896025
Seq. Order: 35
Data Storage Type: VARCHAR2
Max Length: 80
Required: No
Primary Key: No
Status: Active
Description:

First line of comments from fisher.

General Data Type: VARCHAR2

NOTES_LINE_2

CC ID: 896026
Seq. Order: 36
Data Storage Type: VARCHAR2
Max Length: 80
Required: No
Primary Key: No
Status: Active
Description:

Second line of comments from fisher.

General Data Type: VARCHAR2

NOTES_LINE_3

CC ID: 896027
Seq. Order: 37
Data Storage Type: VARCHAR2
Max Length: 80
Required: No
Primary Key: No
Status: Active
Description:

Third line of comments from fisher.

General Data Type: VARCHAR2

JOB_NUMBER

CC ID: 896028
Seq. Order: 38
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D12045.

General Data Type: VARCHAR2

FROM_FILE

CC ID: 896029
Seq. Order: 39
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Name of the flat ASCII file that was the source of the data.

General Data Type: VARCHAR2

DATE_LOADED

CC ID: 896030
Seq. Order: 40
Data Storage Type: DATE
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Date when the record was loaded into Oracle or updated.

General Data Type: DATE

TAGGER

CC ID: 896031
Seq. Order: 41
Data Storage Type: VARCHAR2
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Name of individual tagging the fish.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 58731
GUID: gov.noaa.nmfs.inport:58731
Metadata Record Created By: Brian J Langseth
Metadata Record Created: 2020-01-30 16:35+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2020-01-30
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2020-01-30
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2021-01-30