GUAM_BIOLOGICAL_DATA_TRIP
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:58654 | Updated: August 9, 2022 | Published / External
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
|
|
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 |