Item Identification

Title: RI016AA2_RSCH_V
Short Name: RI016AA2_RSCH_V
Status: Completed
Abstract:

Size frequency data collected during research cruises.

Entity Information

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

Size frequency data collected during research cruises.

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 Four-digit incremental number of the cruise for the vessel, e.g., 0054, or the last two digits of the year of the cruise and two-digit incremental number of the cruise for the year, e.g., 7504.
100
STATION_NUMBER VARCHAR2 Station number of the fishing operation.
100
YEAR VARCHAR2 Year of catch.
100
MONTH VARCHAR2 Month of catch.
100
DAY VARCHAR2 Day of catch.
100
LATITUDE_DEGREES VARCHAR2 Latitude degrees, in degrees. Units for values are degrees.
100
LATITUDE_MINUTES VARCHAR2 Latitude minutes, in minutes. Units for values are minutes.
100
LATITUDE_DIRECTION VARCHAR2 Latitude direction.
100
LATITUDE_DD NUMBER Computed latitude, in decimal degrees. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40.
100
LONGITUDE_DEGREES VARCHAR2 Longitude degrees, in degrees. Units for values are degrees.
100
LONGITUDE_MINUTES VARCHAR2 Longitude minutes, in minutes. Units for values are minutes.
100
LONGITUDE_DIRECTION VARCHAR2 Longitude direction.
100
LONGITUDE_DD NUMBER Computed longitude, in decimal degrees. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.
100
SPECIES_CODE VARCHAR2 Ten-digit CZM species code.
100
SPECIES_CODE_5 VARCHAR2 Five-digit CZM species code used in the earlier data was moved to a separate column and replaced by the ten-digit code in SPECIES_CODE.
100
RATIO_SAMPLED_CODE VARCHAR2 Code for the ratio of fish sampled.
100
REMAINDER VARCHAR2 The number of fish remaining after sampling the last 1/nth fish. For example, if your ratio was 1 out of 10 and you were measuring 99 fish, then your remainder is 9, i.e., after the 90th fish.
100
LINE_NUMBER VARCHAR2 Consecutive number on the collection form for each fish measured.
100
TOTAL_OR_FORK_LENGTH_MM VARCHAR2 Total or fork length, in tenths of a millimeter. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 5.
100
STANDARD_LENGTH_MM VARCHAR2 Standard length, in tenths of a millimeter. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 5.
100
WEIGHT_KG VARCHAR2 Weight of fish, in thousandths of a kilogram. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are kilograms. Measures are reported with a precision of 5.
100
TOTAL_OR_FORK_LENGTH_CM VARCHAR2 Total or fork length, in tenths of a centimeter. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are centimeters. Measures are reported with a precision of 5.
100
WEIGHT_LB VARCHAR2 Weight of fish, in thousandths of a pound. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are pounds. Measures are reported with a precision of 6.
100
SEX_CODE VARCHAR2 Code for the sex of the fish.
100
SIZE_CODE VARCHAR2 Code for the size of the fish, Pentaceros richardsoni (8554590201).
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., D84145.
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: 998300
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: 998301
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: 998302
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 007 = NOAA R/V CHARLES H. GILBERT

CRUISE_NUMBER

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

Four-digit incremental number of the cruise for the vessel, e.g., 0054, or the last two digits of the year of the cruise and two-digit incremental number of the cruise for the year, e.g., 7504.

General Data Type: VARCHAR2

STATION_NUMBER

CC ID: 998304
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: 998305
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Year of catch.

General Data Type: VARCHAR2

MONTH

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

Month of catch.

General Data Type: VARCHAR2

DAY

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

Day of catch.

General Data Type: VARCHAR2

LATITUDE_DEGREES

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

Latitude degrees, in degrees. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees

LATITUDE_MINUTES

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

Latitude minutes, in minutes. Units for values are minutes.

General Data Type: VARCHAR2
Unit of Measure: minutes

LATITUDE_DIRECTION

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

Latitude direction.

General Data Type: VARCHAR2

LATITUDE_DD

CC ID: 998311
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 42
Required: No
Primary Key: No
Scale: 38
Status: Active
Description:

Computed latitude, in decimal degrees. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40.

General Data Type: NUMBER
Unit of Measure: degrees

LONGITUDE_DEGREES

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

Longitude degrees, in degrees. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees
Allowed Values: N = NORTH S = SOUTH

LONGITUDE_MINUTES

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

Longitude minutes, in minutes. Units for values are minutes.

General Data Type: VARCHAR2
Unit of Measure: minutes

LONGITUDE_DIRECTION

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

Longitude direction.

General Data Type: VARCHAR2
Allowed Values: E = EAST W = WEST

LONGITUDE_DD

CC ID: 998315
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 41
Required: No
Primary Key: No
Scale: 36
Status: Active
Description:

Computed longitude, in decimal degrees. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.

General Data Type: NUMBER
Unit of Measure: degrees

SPECIES_CODE

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

Ten-digit CZM species code.

General Data Type: VARCHAR2

SPECIES_CODE_5

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

Five-digit CZM species code used in the earlier data was moved to a separate column and replaced by the ten-digit code in SPECIES_CODE.

General Data Type: VARCHAR2

RATIO_SAMPLED_CODE

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

Code for the ratio of fish sampled.

General Data Type: VARCHAR2

REMAINDER

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

The number of fish remaining after sampling the last 1/nth fish. For example, if your ratio was 1 out of 10 and you were measuring 99 fish, then your remainder is 9, i.e., after the 90th fish.

General Data Type: VARCHAR2

LINE_NUMBER

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

Consecutive number on the collection form for each fish measured.

General Data Type: VARCHAR2

TOTAL_OR_FORK_LENGTH_MM

CC ID: 998321
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Total or fork length, in tenths of a millimeter. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 5.

General Data Type: VARCHAR2
Unit of Measure: millimeters

STANDARD_LENGTH_MM

CC ID: 998322
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Standard length, in tenths of a millimeter. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 5.

General Data Type: VARCHAR2
Unit of Measure: millimeters

WEIGHT_KG

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

Weight of fish, in thousandths of a kilogram. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are kilograms. Measures are reported with a precision of 5.

General Data Type: VARCHAR2
Unit of Measure: kilograms

TOTAL_OR_FORK_LENGTH_CM

CC ID: 998324
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Total or fork length, in tenths of a centimeter. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are centimeters. Measures are reported with a precision of 5.

General Data Type: VARCHAR2
Unit of Measure: centimeters

WEIGHT_LB

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

Weight of fish, in thousandths of a pound. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are pounds. Measures are reported with a precision of 6.

General Data Type: VARCHAR2
Unit of Measure: pounds

SEX_CODE

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

Code for the sex of the fish.

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

SIZE_CODE

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

Code for the size of the fish, Pentaceros richardsoni (8554590201).

General Data Type: VARCHAR2
Allowed Values: 1 = LEAN 2 = INTERMEDIATE 3 = FAT

JOB_NUMBER

CC ID: 998328
Seq. Order: 29
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., D84145.

General Data Type: VARCHAR2

SEQUENCE_NUMBER

CC ID: 998329
Seq. Order: 30
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: 998330
Seq. Order: 31
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: 53629
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2018-09-10 15:25+0000
Metadata Record Last Modified By: Brent M Miyamoto
Metadata Record Last Modified: 2020-12-18 20:02+0000
Metadata Record Published: 2020-12-18
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2021-12-19