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

Summary

Abstract

Squid Sampling and Size Frequency Log collected between 1981 and 1983 and in 1989.

Description

Squid Sampling and Size Frequency Log collected between 1981 and 1989.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
DATASET_CODE
VARCHAR2
Source ID Code assigned by the data entry staff.
VERSION_CODE
VARCHAR2
Code for the format version assigned by the data entry staff.
VESSEL_CODE
VARCHAR2
Code for the vessel.
CRUISE_NUMBER
VARCHAR2
Last two digits of the year of the cruise and two digits incremental number of the cruise for the year, e.g., 8101.
STATION_NUMBER
VARCHAR2
Station number of the fishing operation.
YEAR
VARCHAR2
Year of fishing.
MONTH
VARCHAR2
Month of fishing.
DAY
VARCHAR2
Day of fishing.
TIME_STARTED
VARCHAR2
Time fishing started.
TIME_ENDED
VARCHAR2
Time fishing ended.
WIND_DIRECTION
VARCHAR2
Wind direction (0-360) in degrees. Units for values are degrees.
WIND_SPEED
VARCHAR2
Wind speed in tenths of a meter/second. During data entry the decimal point was omitted. It has been inserted into the data. Units for values are meters/second. Measures are reported with a precision of 3.
SEA_CONDITION_CODE
VARCHAR2
Code for the sea condition.
CLOUD_COVER
VARCHAR2
Cloud cover in tenths.
MOON_PHASE
VARCHAR2
Moon phase in eights.
MOON_HEIGHT
VARCHAR2
Moon height in degrees. Units for values are degrees.
NUMBER_MACHINES
VARCHAR2
Number of machines used.
MINIMUM_DEPTH_FISHED
VARCHAR2
Minimum depth fished in meters. Units for values are meters.
MAXIMUM_DEPTH_FISHED
VARCHAR2
Maximum depth fished in meters. Units for values are meters.
BREAK_TIME
VARCHAR2
Break time in minutes. Units for values are minutes.
NUMBER_CAUGHT_MACHINE
VARCHAR2
Number caught by machine.
NUMBER_SAMPLED_MACHINE
VARCHAR2
Number sampled that were caught by machine.
NUMBER_CAUGHT_POLE_LINE
VARCHAR2
Number caught by pole and line.
NUMBER_SAMPLED_POLE_LINE
VARCHAR2
Number sampled that were caught by pole and line.
SPECIES_CODE
VARCHAR2
Ten-digt CZM species code.
SPECIES_LINE_NUMBER
VARCHAR2
A consecutive number assigned to each data record of a given species.
LENGTH
VARCHAR2
Length in millimeters. Units for values are millimeters.
WEIGHT
VARCHAR2
Weight in grams. Units for values are grams.
SEX_CODE
VARCHAR2
Sex code of species.
GEAR_CODE
VARCHAR2
Code for gear used for fishing.
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., D83017.
SEQUENCE_NUMBER
VARCHAR2
A consecutive number assigned to each record for a block of data.
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: RP003AA1_V
Short Name: RP003AA1_V
Status: Completed
Abstract:

Squid Sampling and Size Frequency Log collected between 1981 and 1983 and in 1989.

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

Squid Sampling and Size Frequency Log collected between 1981 and 1989.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
DATASET_CODE VARCHAR2 Source ID Code assigned by the data entry staff.
100
VERSION_CODE VARCHAR2 Code for the format version assigned by the data entry staff.
100
VESSEL_CODE VARCHAR2 Code for the vessel.
100
CRUISE_NUMBER VARCHAR2 Last two digits of the year of the cruise and two digits incremental number of the cruise for the year, e.g., 8101.
100
STATION_NUMBER VARCHAR2 Station number of the fishing operation.
100
YEAR VARCHAR2 Year of fishing.
100
MONTH VARCHAR2 Month of fishing.
100
DAY VARCHAR2 Day of fishing.
100
TIME_STARTED VARCHAR2 Time fishing started.
100
TIME_ENDED VARCHAR2 Time fishing ended.
100
WIND_DIRECTION VARCHAR2 Wind direction (0-360) in degrees. Units for values are degrees.
100
WIND_SPEED VARCHAR2 Wind speed in tenths of a meter/second. During data entry the decimal point was omitted. It has been inserted into the data. Units for values are meters/second. Measures are reported with a precision of 3.
100
SEA_CONDITION_CODE VARCHAR2 Code for the sea condition.
100
CLOUD_COVER VARCHAR2 Cloud cover in tenths.
100
MOON_PHASE VARCHAR2 Moon phase in eights.
100
MOON_HEIGHT VARCHAR2 Moon height in degrees. Units for values are degrees.
100
NUMBER_MACHINES VARCHAR2 Number of machines used.
100
MINIMUM_DEPTH_FISHED VARCHAR2 Minimum depth fished in meters. Units for values are meters.
100
MAXIMUM_DEPTH_FISHED VARCHAR2 Maximum depth fished in meters. Units for values are meters.
100
BREAK_TIME VARCHAR2 Break time in minutes. Units for values are minutes.
100
NUMBER_CAUGHT_MACHINE VARCHAR2 Number caught by machine.
100
NUMBER_SAMPLED_MACHINE VARCHAR2 Number sampled that were caught by machine.
100
NUMBER_CAUGHT_POLE_LINE VARCHAR2 Number caught by pole and line.
100
NUMBER_SAMPLED_POLE_LINE VARCHAR2 Number sampled that were caught by pole and line.
100
SPECIES_CODE VARCHAR2 Ten-digt CZM species code.
100
SPECIES_LINE_NUMBER VARCHAR2 A consecutive number assigned to each data record of a given species.
100
LENGTH VARCHAR2 Length in millimeters. Units for values are millimeters.
100
WEIGHT VARCHAR2 Weight in grams. Units for values are grams.
100
SEX_CODE VARCHAR2 Sex code of species.
100
GEAR_CODE VARCHAR2 Code for gear used for fishing.
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., D83017.
100
SEQUENCE_NUMBER VARCHAR2 A consecutive number assigned to each record for a block of data.
100
DATE_LOADED DATE Date when the record was loaded into Oracle or updated.

Attribute Details

DATASET_CODE

CC ID: 1056089
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.

General Data Type: VARCHAR2

VERSION_CODE

CC ID: 1056090
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.

General Data Type: VARCHAR2

VESSEL_CODE

CC ID: 1056091
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Code for the vessel.

General Data Type: VARCHAR2
Allowed Values: 001 = NOAA R/V TOWNSEND CROMWELL; 995 = HOKUSEI MARU

CRUISE_NUMBER

CC ID: 1056092
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Last two digits of the year of the cruise and two digits incremental number of the cruise for the year, e.g., 8101.

General Data Type: VARCHAR2

STATION_NUMBER

CC ID: 1056093
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Station number of the fishing operation.

General Data Type: VARCHAR2

YEAR

CC ID: 1056094
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Year of fishing.

General Data Type: VARCHAR2

MONTH

CC ID: 1056095
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Month of fishing.

General Data Type: VARCHAR2

DAY

CC ID: 1056096
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Day of fishing.

General Data Type: VARCHAR2

TIME_STARTED

CC ID: 1056097
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Time fishing started.

General Data Type: VARCHAR2

TIME_ENDED

CC ID: 1056098
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Time fishing ended.

General Data Type: VARCHAR2

WIND_DIRECTION

CC ID: 1056099
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Wind direction (0-360) in degrees. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees

WIND_SPEED

CC ID: 1056100
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Wind speed in tenths of a meter/second. During data entry the decimal point was omitted. It has been inserted into the data. Units for values are meters/second. Measures are reported with a precision of 3.

General Data Type: VARCHAR2
Unit of Measure: meters/second

SEA_CONDITION_CODE

CC ID: 1056101
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Code for the sea condition.

General Data Type: VARCHAR2
Allowed Values: 00 = CALM; 01 = SLIGHT; 02 = MODERATE; C = CALM; S = SLIGHT; M = MODERATE; R = ROUGH

CLOUD_COVER

CC ID: 1056102
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Cloud cover in tenths.

General Data Type: VARCHAR2

MOON_PHASE

CC ID: 1056103
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Moon phase in eights.

General Data Type: VARCHAR2

MOON_HEIGHT

CC ID: 1056104
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Moon height in degrees. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees

NUMBER_MACHINES

CC ID: 1056105
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Number of machines used.

General Data Type: VARCHAR2

MINIMUM_DEPTH_FISHED

CC ID: 1056106
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Minimum depth fished in meters. Units for values are meters.

General Data Type: VARCHAR2
Unit of Measure: meters

MAXIMUM_DEPTH_FISHED

CC ID: 1056107
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Maximum depth fished in meters. Units for values are meters.

General Data Type: VARCHAR2
Unit of Measure: meters

BREAK_TIME

CC ID: 1056108
Seq. Order: 20
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Break time in minutes. Units for values are minutes.

General Data Type: VARCHAR2
Unit of Measure: minutes

NUMBER_CAUGHT_MACHINE

CC ID: 1056109
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Number caught by machine.

General Data Type: VARCHAR2

NUMBER_SAMPLED_MACHINE

CC ID: 1056110
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Number sampled that were caught by machine.

General Data Type: VARCHAR2

NUMBER_CAUGHT_POLE_LINE

CC ID: 1056111
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Number caught by pole and line.

General Data Type: VARCHAR2

NUMBER_SAMPLED_POLE_LINE

CC ID: 1056112
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Number sampled that were caught by pole and line.

General Data Type: VARCHAR2

SPECIES_CODE

CC ID: 1056113
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Ten-digt CZM species code.

General Data Type: VARCHAR2
Allowed Values: 7073090100 = ONYCHOTEUTHIS SP.; 7073090101 = ONYCHOTEUTHIS COMPACTA; 7073090103 = ONYCHOTEUTHIS BANKSII; 7073300701 = OMMASTREPHES BARTRAMI; 7073301001 = SYMPLECTOTEUTHIS OUALANIENSIS; 7073301002 = SYMPLECTOTEUTHIS LUMINOSA

SPECIES_LINE_NUMBER

CC ID: 1056114
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

A consecutive number assigned to each data record of a given species.

General Data Type: VARCHAR2

LENGTH

CC ID: 1056115
Seq. Order: 27
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Length in millimeters. Units for values are millimeters.

General Data Type: VARCHAR2
Unit of Measure: millimeters

WEIGHT

CC ID: 1056116
Seq. Order: 28
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Weight in grams. Units for values are grams.

General Data Type: VARCHAR2
Unit of Measure: grams

SEX_CODE

CC ID: 1056117
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Sex code of species.

General Data Type: VARCHAR2
Allowed Values: F = FEMALE; I = ; M = MALE

GEAR_CODE

CC ID: 1056118
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Code for gear used for fishing.

General Data Type: VARCHAR2
Allowed Values: 01 = POLE AND LINE; 08 = ROD AND REEL; 92 = SQUID JIGGING MACHINE (AUTOMATIC); 95 = DIP NET

JOB_NUMBER

CC ID: 1056119
Seq. Order: 31
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., D83017.

General Data Type: VARCHAR2

SEQUENCE_NUMBER

CC ID: 1056120
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

A consecutive number assigned to each record for a block of data.

General Data Type: VARCHAR2

DATE_LOADED

CC ID: 1056121
Seq. Order: 33
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: 64446
GUID: gov.noaa.nmfs.inport:64446
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2021-03-26 00:38+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-04-05
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-04-05
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-04-05