Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Historical Datasets Metadata Portfolio > Historical Research Seamounts Metadata Portfoli... > Armorhead Otolith data collected during NOAA R/... >

RS003AA1_RSCH_V

Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:70829 | Updated: September 13, 2023 | Published / External

Item Identification

Title:	RS003AA1_RSCH_V
Short Name:	RS003AA1_RSCH_V
Status:	Completed
Abstract:	Armorhead otolith data from specimens collected during NOAA R/V Townsend Cromwell cruises in 1983 and 1984.

Entity Information

Entity Type:	Data Table
Active Version?:	Yes
Description:	Armorhead otolith data from specimens collected during NOAA R/V Townsend Cromwell cruises in 1983 and 1984.

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	CRUISE_NUMBER	VARCHAR2	Vessel code and the last two digits of the year of the cruise and two digits incremental number of the cruise, e.g., TC8302.
100	ID_NUMBER	VARCHAR2	Unique identification number assigned to each specimen.
100	SEX_CODE	VARCHAR2	Sex code.
100	AREA_CODE	VARCHAR2	Code for the area of capture.
100	WEIGHT	VARCHAR2	Weight, in grams. Units for values are grams.
100	TOTAL_FORK_LENGTH	VARCHAR2	Total or fork length, in millimeters. Units for values are millimeters.
100	STANDARD_LENGTH	VARCHAR2	Standard length, in millimeters. Units for values are millimeters.
100	TYPE_CODE	VARCHAR2	Body type code. Units for values are millimeters.
100	RADIUS_LENGTH	VARCHAR2	Radius length, in hundredths of a millimeter. Units for values are millimeters. Measures are reported with a precision of 4.
100	YEAR_1	VARCHAR2	Year_1, in hundredths of a millimeter. Units for values are millimeters. Measures are reported with a precision of 3.
100	YEAR_2	VARCHAR2	Year_2, in hundredths of a millimeter. Units for values are millimeters. Measures are reported with a precision of 3.
100	YEAR_3	VARCHAR2	Year_3, in hundredths of a millimeter. Units for values are millimeters. Measures are reported with a precision of 3.
100	YEAR_4	VARCHAR2	Year_4, in hundredths of a millimeter. Units for values are millimeters. Measures are reported with a precision of 3.
100	YEAR_5	VARCHAR2	Year_5, in hundredths of a millimeter. Units for values are millimeters. Measures are reported with a precision of 3.
100	YEAR_6	VARCHAR2	Year_6, in hundredths of a millimeter. Units for values are millimeters. Measures are reported with a precision of 3.
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., D85194.
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

CRUISE_NUMBER

VARCHAR2

Vessel code and the last two digits of the year of the cruise and two digits incremental number of the cruise, e.g., TC8302.

100

ID_NUMBER

VARCHAR2

Unique identification number assigned to each specimen.

100

SEX_CODE

VARCHAR2

Sex code.

100

AREA_CODE

VARCHAR2

Code for the area of capture.

100

WEIGHT

VARCHAR2

Weight, in grams. Units for values are grams.

100

TOTAL_FORK_LENGTH

VARCHAR2

Total or fork length, in millimeters. Units for values are millimeters.

100

STANDARD_LENGTH

VARCHAR2

Standard length, in millimeters. Units for values are millimeters.

100

TYPE_CODE

VARCHAR2

Body type code. Units for values are millimeters.

100

RADIUS_LENGTH

VARCHAR2

Radius length, in hundredths of a millimeter. Units for values are millimeters. Measures are reported with a precision of 4.

100

YEAR_1

VARCHAR2

Year_1, in hundredths of a millimeter. Units for values are millimeters. Measures are reported with a precision of 3.

100

YEAR_2

VARCHAR2

Year_2, in hundredths of a millimeter. Units for values are millimeters. Measures are reported with a precision of 3.

100

YEAR_3

VARCHAR2

Year_3, in hundredths of a millimeter. Units for values are millimeters. Measures are reported with a precision of 3.

100

YEAR_4

VARCHAR2

Year_4, in hundredths of a millimeter. Units for values are millimeters. Measures are reported with a precision of 3.

100

YEAR_5

VARCHAR2

Year_5, in hundredths of a millimeter. Units for values are millimeters. Measures are reported with a precision of 3.

100

YEAR_6

VARCHAR2

Year_6, in hundredths of a millimeter. Units for values are millimeters. Measures are reported with a precision of 3.

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., D85194.

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

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

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

CRUISE_NUMBER

CC ID: 1272138

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Vessel code and the last two digits of the year of the cruise and two digits incremental number of the cruise, e.g., TC8302.
General Data Type:	VARCHAR2

ID_NUMBER

CC ID: 1272139

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique identification number assigned to each specimen.
General Data Type:	VARCHAR2

SEX_CODE

CC ID: 1272140

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Sex code.
General Data Type:	VARCHAR2
Allowed Values:	F = FEMALE; M = MALE

AREA_CODE

CC ID: 1272141

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for the area of capture.
General Data Type:	VARCHAR2
Allowed Values:	NW = NORTHWEST HANCOCK; SE = SOUTHEST HANCOCK

WEIGHT

CC ID: 1272142

Seq. Order:	7
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

TOTAL_FORK_LENGTH

CC ID: 1272143

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Total or fork length, in millimeters. Units for values are millimeters.
General Data Type:	VARCHAR2
Unit of Measure:	millimeters

STANDARD_LENGTH

CC ID: 1272144

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Standard length, in millimeters. Units for values are millimeters.
General Data Type:	VARCHAR2
Unit of Measure:	millimeters

TYPE_CODE

CC ID: 1272145

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Body type code. Units for values are millimeters.
General Data Type:	VARCHAR2
Unit of Measure:	millimeters
Allowed Values:	F = FAT; I = INTERMEDIATE; L = LEAN

RADIUS_LENGTH

CC ID: 1272146

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Scale:	2
Status:	Active
Description:	Radius length, in hundredths of a millimeter. Units for values are millimeters. Measures are reported with a precision of 4.
General Data Type:	VARCHAR2
Unit of Measure:	millimeters

YEAR_1

CC ID: 1272147

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Scale:	2
Status:	Active
Description:	Year_1, in hundredths of a millimeter. Units for values are millimeters. Measures are reported with a precision of 3.
General Data Type:	VARCHAR2
Unit of Measure:	millimeters

YEAR_2

CC ID: 1272148

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Scale:	2
Status:	Active
Description:	Year_2, in hundredths of a millimeter. Units for values are millimeters. Measures are reported with a precision of 3.
General Data Type:	VARCHAR2
Unit of Measure:	millimeters

YEAR_3

CC ID: 1272149

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Scale:	2
Status:	Active
Description:	Year_3, in hundredths of a millimeter. Units for values are millimeters. Measures are reported with a precision of 3.
General Data Type:	VARCHAR2
Unit of Measure:	millimeters

YEAR_4

CC ID: 1272150

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Scale:	2
Status:	Active
Description:	Year_4, in hundredths of a millimeter. Units for values are millimeters. Measures are reported with a precision of 3.
General Data Type:	VARCHAR2
Unit of Measure:	millimeters

YEAR_5

CC ID: 1272151

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Scale:	2
Status:	Active
Description:	Year_5, in hundredths of a millimeter. Units for values are millimeters. Measures are reported with a precision of 3.
General Data Type:	VARCHAR2
Unit of Measure:	millimeters

YEAR_6

CC ID: 1272152

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Scale:	2
Status:	Active
Description:	Year_6, in hundredths of a millimeter. Units for values are millimeters. Measures are reported with a precision of 3.
General Data Type:	VARCHAR2
Unit of Measure:	millimeters

JOB_NUMBER

CC ID: 1272153

Seq. Order:	18
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., D85194.
General Data Type:	VARCHAR2

SEQUENCE_NUMBER

CC ID: 1272154

Seq. Order:	19
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: 1272155

Seq. Order:	20
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:	70829
GUID:	gov.noaa.nmfs.inport:70829
Metadata Record Created By:	Brent M Miyamoto
Metadata Record Created:	2023-09-12 22:44+0000
Metadata Record Last Modified By:	Brent M Miyamoto
Metadata Record Last Modified:	2023-09-13 18:30+0000
Metadata Record Published:	2023-09-13
Owner Org:	PIFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2023-09-13
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2024-09-13