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