Item Identification

Title: GUAM_EXPLORATORY_SURVEY_CATCH
Short Name: GUAM_EXPLORATORY_SURVEY_CATCH
Status: Completed
Abstract:

Catch information for Guam fishery independent data collection for 2012 and 2014.

Entity Information

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

Catch information for Guam fishery independent data collection for 2012 and 2014.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
DATASET_CODE VARCHAR2 Source ID Code assigned by the data entry staff (FC084).
100
VERSION_CODE VARCHAR2 Code for the format version assigned by the data entry staff (AA1 - CATCH; AA2 - EFFORT).
100
MONTHEFFORT VARCHAR2 Month of fishing.
100
DAYEFFORT VARCHAR2 Day of fishing.
100
YEAREFFORT VARCHAR2 Year of fishing.
100
VESSELNAME VARCHAR2 Name of vessel.
100
DRIFTNUMBER VARCHAR2 Identifies the drift the data occurred on. This value is a sequential identifier to differentiate multiple fishing events (drifts) occurring in the same fishing area (Left justified).
100
AREA VARCHAR2 Locational information on where fishing occurred (map is available as is excel spreadsheet showing lat-long of areas).
100
REELNUMBER VARCHAR2 The number of the reel the catch occurred on, to distinguish individual rods from one another.
100
SPECIESCAUGHT VARCHAR2 Species of fish caught.
100
LENGTH VARCHAR2 Length of fish caught.
100
UNITS VARCHAR2 The units of measurement for the field LENGTH.
100
KEPTRELEASED VARCHAR2 Indicator for whether the fish was kept of released (K/R).
100
TAGNUMBER VARCHAR2 If fish was released with a tag, then the number of tag.
100
HEAD_YN VARCHAR2 Whether the head was collected for hard-part analysis.
100
GONADS_YN VARCHAR2 Whether gonads were collected for reproductive studies.
100
NOTES VARCHAR2 Notes from the 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., D15215.

Attribute Details

DATASET_CODE

CC ID: 894679
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 (FC084).

General Data Type: VARCHAR2

VERSION_CODE

CC ID: 894680
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 (AA1 - CATCH; AA2 - EFFORT).

General Data Type: VARCHAR2

MONTHEFFORT

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

Month of fishing.

General Data Type: VARCHAR2

DAYEFFORT

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

Day of fishing.

General Data Type: VARCHAR2

YEAREFFORT

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

Year of fishing.

General Data Type: VARCHAR2

VESSELNAME

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

Name of vessel.

General Data Type: VARCHAR2

DRIFTNUMBER

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

Identifies the drift the data occurred on. This value is a sequential identifier to differentiate multiple fishing events (drifts) occurring in the same fishing area (Left justified).

General Data Type: VARCHAR2

AREA

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

Locational information on where fishing occurred (map is available as is excel spreadsheet showing lat-long of areas).

General Data Type: VARCHAR2

REELNUMBER

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

The number of the reel the catch occurred on, to distinguish individual rods from one another.

General Data Type: VARCHAR2

SPECIESCAUGHT

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

Species of fish caught.

General Data Type: VARCHAR2

LENGTH

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

Length of fish caught.

General Data Type: VARCHAR2

UNITS

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

The units of measurement for the field LENGTH.

General Data Type: VARCHAR2

KEPTRELEASED

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

Indicator for whether the fish was kept of released (K/R).

General Data Type: VARCHAR2

TAGNUMBER

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

If fish was released with a tag, then the number of tag.

General Data Type: VARCHAR2

HEAD_YN

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

Whether the head was collected for hard-part analysis.

General Data Type: VARCHAR2

GONADS_YN

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

Whether gonads were collected for reproductive studies.

General Data Type: VARCHAR2

NOTES

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

Notes from the fisher.

General Data Type: VARCHAR2

JOB_NUMBER

CC ID: 894696
Seq. Order: 18
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., D15215.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 58649
Metadata Record Created By: Brian J Langseth
Metadata Record Created: 2020-01-21 20:41+0000
Metadata Record Last Modified By: Brian J Langseth
Metadata Record Last Modified: 2020-01-30 19:59+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