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

Summary

Abstract

North Pacific squid jig logbook trip data for 2001 and 2003.

Description

North Pacific squid jig logbook trip data for 2001 and 2003.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
DATASET_CODE
Character
Source ID Code assigned by the data entry staff.
VERSION_CODE
Character
Code for the format version assigned by the data entry staff.
TRIP_YEAR
Numeric
Year of trip extracted from the name of the worksheet.
VESSEL_NAME
Character
Vessel Name.
CAPTAIN_FIRST_NAME
Character
Captain's First Name.
CAPTAIN_LAST_NAME
Character
Captain's Last Name.
CAPTAIN_MIDDLE_INITIAL
Character
Captain's Middle Initial.
UNLOADING_PORT
Character
Name of unloading port.
UNLOADING_START_YEAR
Numeric
Unload start year.
UNLOADING_START_MONTH
Numeric
Unload start month.
UNLOADING_START_DAY
Numeric
Unload start day.
UNLOADING_END_YEAR
Numeric
Unload end year.
UNLOADING_END_MONTH
Numeric
Unload end month.
UNLOADING_END_DAY
Numeric
Unload end day.
UNLOADING_METHOD
Character
Unload method.
TARGET_SPECIES
Character
Target species.
TOTAL_LANDING_WEIGHT
Numeric
Total number of pounds landed. Units for values are pounds.
SUMMED_NUMBER_RETAINED
Numeric
Number retained, summed from data.
SUMMED_NUM_CASES_PACKED
Numeric
Number of cases retained, summed from data.
SUMMED_RETAINED_WEIGHT
Numeric
Number of retained pounds, summed from data. Units for values are pounds.
NUMBER_DAYS_FISHING
Numeric
Number of days of fishing.
NUMBER_JIG_STATIONS
Numeric
Number of jig stations.
NUMBER_HOOKS_PER_JIG
Numeric
Number of hooks per jig.
HOOKS_TOTAL
Numeric
Hooks total.
NOTES
Character
Notes about the record.
DATE_LOADED
Date
Date when the record was loaded into Oracle or updated.

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

North Pacific squid jig logbook trip data for 2001 and 2003.

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

Rubric Score Primary Key? 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: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2019-07-25
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