Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Historical Datasets Metadata Portfolio > Historical Research Insular Metadata Portfolio > Size Frequency Log data collected on a NOAA R/V... >

RI016AA2_RSCH_V

Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:53629 | Updated: August 9, 2022 | Published / External

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

	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.

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
GUID:	gov.noaa.nmfs.inport:53629
Metadata Record Created By:	Brent M Miyamoto
Metadata Record Created:	2018-09-10 15:25+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2020-12-18
Owner Org:	PIFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2020-12-18
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2021-12-18