Item Identification

Title: GUAM_BIOLOGICAL_DATA_TRIP
Short Name: GUAM_BIOLOGICAL_DATA_TRIP
Status: Completed
Abstract:

Trip information for Guam biological sampling for 2015.

Entity Information

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

Trip information for Guam biological sampling for 2015.

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: 894835
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: 894836
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: 894837
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: 894838
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: 894839
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: 894840
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: 894841
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: 894842
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: 894843
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: 894844
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: 894845
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: 894846
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: 894847
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: 894848
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: 894849
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: 894850
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: 894851
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: 894852
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: 894853
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: 894854
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: 58654
Metadata Record Created By: Brian J Langseth
Metadata Record Created: 2020-01-21 20:43+0000
Metadata Record Last Modified By: Brian J Langseth
Metadata Record Last Modified: 2020-01-30 19:57+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