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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Size frequency data collected during research cruises.

Description

Size frequency data collected during research cruises.

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	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.
STATION_NUMBER VARCHAR2	Station number of the fishing operation.
YEAR VARCHAR2	Year of catch.
MONTH VARCHAR2	Month of catch.
DAY VARCHAR2	Day of catch.
LATITUDE_DEGREES VARCHAR2	Latitude degrees, in degrees. Units for values are degrees.
LATITUDE_MINUTES VARCHAR2	Latitude minutes, in minutes. Units for values are minutes.
LATITUDE_DIRECTION VARCHAR2	Latitude direction.
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.
LONGITUDE_DEGREES VARCHAR2	Longitude degrees, in degrees. Units for values are degrees.
LONGITUDE_MINUTES VARCHAR2	Longitude minutes, in minutes. Units for values are minutes.
LONGITUDE_DIRECTION VARCHAR2	Longitude direction.
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.
SPECIES_CODE VARCHAR2	Ten-digit CZM species code.
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.
RATIO_SAMPLED_CODE VARCHAR2	Code for the ratio of fish sampled.
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.
LINE_NUMBER VARCHAR2	Consecutive number on the collection form for each fish measured.
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.
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.
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.
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.
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.
SEX_CODE VARCHAR2	Code for the sex of the fish.
SIZE_CODE VARCHAR2	Code for the size of the fish, Pentaceros richardsoni (8554590201).
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.
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.

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

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.

STATION_NUMBER
VARCHAR2

Station number of the fishing operation.

YEAR
VARCHAR2

Year of catch.

MONTH
VARCHAR2

Month of catch.

DAY
VARCHAR2

Day of catch.

LATITUDE_DEGREES
VARCHAR2

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

LATITUDE_MINUTES
VARCHAR2

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

LATITUDE_DIRECTION
VARCHAR2

Latitude direction.

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.

LONGITUDE_DEGREES
VARCHAR2

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

LONGITUDE_MINUTES
VARCHAR2

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

LONGITUDE_DIRECTION
VARCHAR2

Longitude direction.

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.

SPECIES_CODE
VARCHAR2

Ten-digit CZM species code.

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.

RATIO_SAMPLED_CODE
VARCHAR2

Code for the ratio of fish sampled.

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.

LINE_NUMBER
VARCHAR2

Consecutive number on the collection form for each fish measured.

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.

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.

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.

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.

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.

SEX_CODE
VARCHAR2

Code for the sex of the fish.

SIZE_CODE
VARCHAR2

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

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.

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.

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (PIFSC) for inquiries on this record.

Title:	RI016AA2_RSCH_V
Short Name:	RI016AA2_RSCH_V
Status:	Completed
Abstract:	Size frequency data collected during research cruises.

Entity Type:	Data Table
Active Version?:	Yes
Description:	Size frequency data collected during research cruises.

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

100

STANDARD_LENGTH_MM

VARCHAR2

100

WEIGHT_KG

VARCHAR2

100

TOTAL_OR_FORK_LENGTH_CM

VARCHAR2

100

WEIGHT_LB

VARCHAR2

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

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 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

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

DATASET_CODE

VERSION_CODE

VESSEL_CODE

CRUISE_NUMBER

STATION_NUMBER

YEAR

MONTH

DAY

LATITUDE_DEGREES

LATITUDE_MINUTES

LATITUDE_DIRECTION

LATITUDE_DD

LONGITUDE_DEGREES

LONGITUDE_MINUTES

LONGITUDE_DIRECTION

LONGITUDE_DD

SPECIES_CODE

SPECIES_CODE_5

RATIO_SAMPLED_CODE

REMAINDER

LINE_NUMBER

TOTAL_OR_FORK_LENGTH_MM

STANDARD_LENGTH_MM

WEIGHT_KG

TOTAL_OR_FORK_LENGTH_CM

WEIGHT_LB

SEX_CODE

SIZE_CODE

JOB_NUMBER

SEQUENCE_NUMBER

DATE_LOADED

Catalog Details