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
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2019-02-22 15:36+0000
Metadata Record Last Modified By: Brent M Miyamoto
Metadata Record Last Modified: 2019-07-25 23:01+0000
Metadata Record Published: 2019-07-25
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2020-07-25