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
Metadata Record Created By: Brian J Langseth
Metadata Record Created: 2020-01-30 16:35+0000
Metadata Record Last Modified By: Brian J Langseth
Metadata Record Last Modified: 2020-01-30 19:58+0000
Metadata Record Published: 2020-01-30
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2021-01-30