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

Summary

Abstract

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

Description

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

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
DATASET_CODE
VARCHAR2
Source ID Code assigned by the data entry staff (FC082).
VERSION_CODE
VARCHAR2
Code for the format version assigned by the data entry staff; AA2-GUAM.
CAPTAINNAME
VARCHAR2
Name of vessel captain.
OBSERVERNAME
VARCHAR2
Name of observer.
VESSELNAME
VARCHAR2
Name of vessel.
PORTDEPART
VARCHAR2
Port vessel departed from.
MONTHTRIPSTART
VARCHAR2
The month the trip started in.
DAYTRIPSTART
VARCHAR2
The day the trip started on.
YEARTRIPSTART
VARCHAR2
The year the trip started in.
MONTHTRIPEND
VARCHAR2
The month the trip ended in.
DAYTRIPEND
VARCHAR2
The day the trip ended on.
YEARTRIPEND
VARCHAR2
The year the trip ended in.
TIMETRIPSTART
VARCHAR2
The time the trip started (24 hr clock).
TIMETRIPEND
VARCHAR2
The time the trip ended (24 hr clock).
SPECIESTARGET
VARCHAR2
The species targeted.
PURPOSETRIP
VARCHAR2
The purpose of the trip.
BANK_AREA
VARCHAR2
The area fishing occurred (map is available as is excel spreadsheet showing lat-long of areas).
BOXLETTERNAME
VARCHAR2
Subcategory indicating where in area fishing occurred (map is available as is excel spreadsheet showing lat-long of areas).
NOTESTRIP
VARCHAR2
Any notes from trip written by fisher (Y/N).
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., D15199.

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: GUAM_EXPLORATORY_SURVEY_TRIP
Short Name: GUAM_EXPLORATORY_SURVEY_TRIP
Status: Completed
Abstract:

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

Entity Information

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

Trip 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 (FC082).
100
VERSION_CODE VARCHAR2 Code for the format version assigned by the data entry staff; AA2-GUAM.
100
CAPTAINNAME VARCHAR2 Name of vessel captain.
100
OBSERVERNAME VARCHAR2 Name of observer.
100
VESSELNAME VARCHAR2 Name of vessel.
100
PORTDEPART VARCHAR2 Port vessel departed from.
100
MONTHTRIPSTART VARCHAR2 The month the trip started in.
100
DAYTRIPSTART VARCHAR2 The day the trip started on.
100
YEARTRIPSTART VARCHAR2 The year the trip started in.
100
MONTHTRIPEND VARCHAR2 The month the trip ended in.
100
DAYTRIPEND VARCHAR2 The day the trip ended on.
100
YEARTRIPEND VARCHAR2 The year the trip ended in.
100
TIMETRIPSTART VARCHAR2 The time the trip started (24 hr clock).
100
TIMETRIPEND VARCHAR2 The time the trip ended (24 hr clock).
100
SPECIESTARGET VARCHAR2 The species targeted.
100
PURPOSETRIP VARCHAR2 The purpose of the trip.
100
BANK_AREA VARCHAR2 The area fishing occurred (map is available as is excel spreadsheet showing lat-long of areas).
100
BOXLETTERNAME VARCHAR2 Subcategory indicating where in area fishing occurred (map is available as is excel spreadsheet showing lat-long of areas).
100
NOTESTRIP VARCHAR2 Any notes from trip written by fisher (Y/N).
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., D15199.

Attribute Details

DATASET_CODE

CC ID: 894747
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 (FC082).

General Data Type: VARCHAR2

VERSION_CODE

CC ID: 894748
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; AA2-GUAM.

General Data Type: VARCHAR2

CAPTAINNAME

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

Name of vessel captain.

General Data Type: VARCHAR2

OBSERVERNAME

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

Name of observer.

General Data Type: VARCHAR2

VESSELNAME

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

Name of vessel.

General Data Type: VARCHAR2

PORTDEPART

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

Port vessel departed from.

General Data Type: VARCHAR2

MONTHTRIPSTART

CC ID: 894753
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

DAYTRIPSTART

CC ID: 894754
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

YEARTRIPSTART

CC ID: 894755
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

MONTHTRIPEND

CC ID: 894756
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

DAYTRIPEND

CC ID: 894757
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

YEARTRIPEND

CC ID: 894758
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

TIMETRIPSTART

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

The time the trip started (24 hr clock).

General Data Type: VARCHAR2

TIMETRIPEND

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

The time the trip ended (24 hr clock).

General Data Type: VARCHAR2

SPECIESTARGET

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

The species targeted.

General Data Type: VARCHAR2

PURPOSETRIP

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

The purpose of the trip.

General Data Type: VARCHAR2

BANK_AREA

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

The area fishing occurred (map is available as is excel spreadsheet showing lat-long of areas).

General Data Type: VARCHAR2

BOXLETTERNAME

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

Subcategory indicating where in area fishing occurred (map is available as is excel spreadsheet showing lat-long of areas).

General Data Type: VARCHAR2

NOTESTRIP

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

Any notes from trip written by fisher (Y/N).

General Data Type: VARCHAR2

JOB_NUMBER

CC ID: 894766
Seq. Order: 20
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., D15199.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 58651
GUID: gov.noaa.nmfs.inport:58651
Metadata Record Created By: Brian J Langseth
Metadata Record Created: 2020-01-21 20:42+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