GUAM_EXPLORATORY_SURVEY_CATCH
Pacific Islands Fisheries Science Center (PIFSC)Entity (ENT) | ID: 58649 | Published / External
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
|
|
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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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 |
