Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Armorhead otolith data from specimens collected during NOAA R/V Townsend Cromwell cruises in 1983 and 1984.

Description

Armorhead otolith data from specimens collected during NOAA R/V Townsend Cromwell cruises in 1983 and 1984.

Entity Information

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

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

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

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