Metadata Rubric

100%

6 / 6

View Report

PIFSC Metadata Library > PIFSC Fisheries Research and Monitoring Divisio... > Stock Assessment Program > Biological Sampling of Bottomfish in Guam 2015 > Guam Biological Sampling Data >

GUAM_BIOLOGICAL_DATA_TRIP

Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:58654 | Updated: August 9, 2022 | Published / External

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

	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.

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
GUID:	gov.noaa.nmfs.inport:58654
Metadata Record Created By:	Brian J Langseth
Metadata Record Created:	2020-01-21 20:43+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

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

DATASET_CODE

VERSION_CODE

CAPTAINNAME

OBSERVERNAME

VESSELNAME

PORTDEPART

MONTHTRIPSTART

DAYTRIPSTART

YEARTRIPSTART

MONTHTRIPEND

DAYTRIPEND

YEARTRIPEND

TIMETRIPSTART

TIMETRIPEND

SPECIESTARGET

PURPOSETRIP

BANK_AREA

BOXLETTERNAME

NOTESTRIP

JOB_NUMBER

Catalog Details