FC085AA1_TRIP_V
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:55590 | Updated: February 20, 2025 | Published / External
Entity Information
| Entity Type: | Data Table |
|---|---|
| Active Version?: | Yes |
| Description: |
North Pacific squid jig logbook trip data for 2001 and 2003. |
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
DATASET_CODE | Character | Source ID Code assigned by the data entry staff. | |
|
100
|
VERSION_CODE | Character | Code for the format version assigned by the data entry staff. | |
|
100
|
TRIP_YEAR | Numeric | Year of trip extracted from the name of the worksheet. | |
|
100
|
VESSEL_NAME | Character | Vessel Name. | |
|
100
|
CAPTAIN_FIRST_NAME | Character | Captain's First Name. | |
|
100
|
CAPTAIN_LAST_NAME | Character | Captain's Last Name. | |
|
100
|
CAPTAIN_MIDDLE_INITIAL | Character | Captain's Middle Initial. | |
|
100
|
UNLOADING_PORT | Character | Name of unloading port. | |
|
100
|
UNLOADING_START_YEAR | Numeric | Unload start year. | |
|
100
|
UNLOADING_START_MONTH | Numeric | Unload start month. | |
|
100
|
UNLOADING_START_DAY | Numeric | Unload start day. | |
|
100
|
UNLOADING_END_YEAR | Numeric | Unload end year. | |
|
100
|
UNLOADING_END_MONTH | Numeric | Unload end month. | |
|
100
|
UNLOADING_END_DAY | Numeric | Unload end day. | |
|
100
|
UNLOADING_METHOD | Character | Unload method. | |
|
100
|
TARGET_SPECIES | Character | Target species. | |
|
100
|
TOTAL_LANDING_WEIGHT | Numeric | Total number of pounds landed. Units for values are pounds. | |
|
100
|
SUMMED_NUMBER_RETAINED | Numeric | Number retained, summed from data. | |
|
100
|
SUMMED_NUM_CASES_PACKED | Numeric | Number of cases retained, summed from data. | |
|
100
|
SUMMED_RETAINED_WEIGHT | Numeric | Number of retained pounds, summed from data. Units for values are pounds. | |
|
100
|
NUMBER_DAYS_FISHING | Numeric | Number of days of fishing. | |
|
100
|
NUMBER_JIG_STATIONS | Numeric | Number of jig stations. | |
|
100
|
NUMBER_HOOKS_PER_JIG | Numeric | Number of hooks per jig. | |
|
100
|
HOOKS_TOTAL | Numeric | Hooks total. | |
|
100
|
NOTES | Character | Notes about the record. | |
|
100
|
DATE_LOADED | Date | Date when the record was loaded into Oracle or updated. |
Attribute Details
DATASET_CODE
CC ID: 824216
| Seq. Order: | 1 |
|---|---|
| Data Storage Type: | Character |
| Max Length: | 5 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Source ID Code assigned by the data entry staff. |
| General Data Type: | Character |
VERSION_CODE
CC ID: 824217
| Seq. Order: | 2 |
|---|---|
| Data Storage Type: | Character |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code for the format version assigned by the data entry staff. |
| General Data Type: | Character |
TRIP_YEAR
CC ID: 824218
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | Numeric |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Year of trip extracted from the name of the worksheet. |
| General Data Type: | Numeric |
VESSEL_NAME
CC ID: 824219
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | Character |
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Vessel Name. |
| General Data Type: | Character |
CAPTAIN_FIRST_NAME
CC ID: 824220
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | Character |
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Captain's First Name. |
| General Data Type: | Character |
CAPTAIN_LAST_NAME
CC ID: 824221
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | Character |
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Captain's Last Name. |
| General Data Type: | Character |
CAPTAIN_MIDDLE_INITIAL
CC ID: 824222
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | Character |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Captain's Middle Initial. |
| General Data Type: | Character |
UNLOADING_PORT
CC ID: 824223
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | Character |
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Name of unloading port. |
| General Data Type: | Character |
UNLOADING_START_YEAR
CC ID: 824224
| Seq. Order: | 9 |
|---|---|
| Data Storage Type: | Numeric |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unload start year. |
| General Data Type: | Numeric |
UNLOADING_START_MONTH
CC ID: 824225
| Seq. Order: | 10 |
|---|---|
| Data Storage Type: | Numeric |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unload start month. |
| General Data Type: | Numeric |
UNLOADING_START_DAY
CC ID: 824226
| Seq. Order: | 11 |
|---|---|
| Data Storage Type: | Numeric |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unload start day. |
| General Data Type: | Numeric |
UNLOADING_END_YEAR
CC ID: 824227
| Seq. Order: | 12 |
|---|---|
| Data Storage Type: | Numeric |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unload end year. |
| General Data Type: | Numeric |
UNLOADING_END_MONTH
CC ID: 824228
| Seq. Order: | 13 |
|---|---|
| Data Storage Type: | Numeric |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unload end month. |
| General Data Type: | Numeric |
UNLOADING_END_DAY
CC ID: 824229
| Seq. Order: | 14 |
|---|---|
| Data Storage Type: | Numeric |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unload end day. |
| General Data Type: | Numeric |
UNLOADING_METHOD
CC ID: 824230
| Seq. Order: | 15 |
|---|---|
| Data Storage Type: | Character |
| Max Length: | 70 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unload method. |
| General Data Type: | Character |
TARGET_SPECIES
CC ID: 824231
| Seq. Order: | 16 |
|---|---|
| Data Storage Type: | Character |
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Target species. |
| General Data Type: | Character |
TOTAL_LANDING_WEIGHT
CC ID: 824232
| Seq. Order: | 17 |
|---|---|
| Data Storage Type: | Numeric |
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Total number of pounds landed. Units for values are pounds. |
| General Data Type: | Numeric |
| Unit of Measure: | pounds |
SUMMED_NUMBER_RETAINED
CC ID: 824233
| Seq. Order: | 18 |
|---|---|
| Data Storage Type: | Numeric |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number retained, summed from data. |
| General Data Type: | Numeric |
SUMMED_NUM_CASES_PACKED
CC ID: 824234
| Seq. Order: | 19 |
|---|---|
| Data Storage Type: | Numeric |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of cases retained, summed from data. |
| General Data Type: | Numeric |
SUMMED_RETAINED_WEIGHT
CC ID: 824235
| Seq. Order: | 20 |
|---|---|
| Data Storage Type: | Numeric |
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of retained pounds, summed from data. Units for values are pounds. |
| General Data Type: | Numeric |
| Unit of Measure: | pounds |
NUMBER_DAYS_FISHING
CC ID: 824236
| Seq. Order: | 21 |
|---|---|
| Data Storage Type: | Numeric |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of days of fishing. |
| General Data Type: | Numeric |
NUMBER_JIG_STATIONS
CC ID: 824237
| Seq. Order: | 22 |
|---|---|
| Data Storage Type: | Numeric |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of jig stations. |
| General Data Type: | Numeric |
NUMBER_HOOKS_PER_JIG
CC ID: 824238
| Seq. Order: | 23 |
|---|---|
| Data Storage Type: | Numeric |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of hooks per jig. |
| General Data Type: | Numeric |
HOOKS_TOTAL
CC ID: 824239
| Seq. Order: | 24 |
|---|---|
| Data Storage Type: | Numeric |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Hooks total. |
| General Data Type: | Numeric |
NOTES
CC ID: 824240
| Seq. Order: | 25 |
|---|---|
| Data Storage Type: | Character |
| Max Length: | 4000 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Notes about the record. |
| General Data Type: | Character |
DATE_LOADED
CC ID: 824241
| Seq. Order: | 26 |
|---|---|
| Data Storage Type: | Date |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Date when the record was loaded into Oracle or updated. |
| General Data Type: | Date |
Catalog Details
| Catalog Item ID: | 55590 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:55590 |
| Metadata Record Created By: | Brent M Miyamoto |
| Metadata Record Created: | 2019-02-22 15:36+0000 |
| Metadata Record Last Modified By: | Bradley M Gough |
| Metadata Record Last Modified: | 2025-02-20 00:34+0000 |
| Metadata Record Published: | 2025-02-20 |
| Owner Org: | PIFSC |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2019-07-25 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2020-07-25 |