Item Identification

Title: RI020AA2_RSCH_V
Short Name: RI020AA2_RSCH_V
Status: Completed
Abstract:

Shrimp Morphometric Log data collected on NOAA R/V Townsend Cromwell cruises.

Entity Information

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

Shrimp Morphometric Log data collected on NOAA R/V Townsend Cromwell 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 Last two digits of the year of the cruise and two-digit incremental number of the cruise for the year.
100
YEAR VARCHAR2 Year of capture.
100
MONTH VARCHAR2 Month of capture.
100
DAY VARCHAR2 Day of capture.
100
STATION_NUMBER_FIRST VARCHAR2 First station number. For AA1 format, there was only one capture station number collected. For AA2 format, if only one station number was collected, the same number was entered into STATION_NUMBER_FIRST and STATION_NUMBER_LAST.
100
STATION_NUMBER_LAST VARCHAR2 Last station number.
100
LATITUDE_DEGREES VARCHAR2 Latitude degrees. Units for values are degrees.
100
LATITUDE_MINUTES VARCHAR2 Latitude minutes, in tenths of a minute. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3.
100
LATITUDE_DIRECTION VARCHAR2 Latitude direction.
100
LATITUDE_DD NUMERIC 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. Units for values are degrees.
100
LONGITUDE_MINUTES VARCHAR2 Longitude minutes, in tenths of a minute. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3.
100
LONGITUDE_DIRECTION VARCHAR2 Longitude direction.
100
LONGITUDE_DD NUMERIC 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
BANK_CODE VARCHAR2 Seven digit bank code.
100
DEPTH_SET VARCHAR2 Set depth, in fathoms. Units for values are fathoms.
100
DEPTH_HAUL VARCHAR2 Haul depth in fathoms. Units for values are fathoms.
100
DEPTH_MINIMUM VARCHAR2 Minimum depth, in fathoms. For AA1 format, if only one depth, the same number was entered into DEPTH_MINIMUM and DEPTH_MAXIMUM. Units for values are fathoms.
100
DEPTH_MAXIMUM VARCHAR2 Maximum depth, in fathoms. Units for values are fathoms.
100
LINE_NUMBER NUMERIC A consecutive number for each entry on the collection form.
100
SPECIES_CODE VARCHAR2 Czm 10-digit species code.
100
STRING_NUMBER VARCHAR2 The consecutive number of the string of traps.
100
GEAR_CODE VARCHAR2 Code for the type of gear used.
100
TRAP_NUMBER_FIRST VARCHAR2 First trap number. For AA2 format if only one trap number, the same number was entered into TRAP_NUMBER_FIRST AND TRAP_NUMBER_LAST.
100
TRAP_NUMBER_LAST VARCHAR2 Last trap number.
100
CARAPACE_LENGTH VARCHAR2 Carapace length, in hundredths of a millimeter. For AA1 format, data was collected in tens of millimeter and reformated to hundreds of millimeter. During data entry the decimal point was omitted; it has have been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 5.
100
CARAPACE_WIDTH VARCHAR2 Carapace width, in hundredths of a millimeter. During data entry the decimal point was omitted; it has have been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 5.
100
TOTAL_LENGTH NUMERIC Total length, in hundredths of a millimeter. During data entry the decimal point was omitted; it has have been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 5.
100
WEIGHT VARCHAR2 Weight, in tenths of a gram. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are grams. Measures are reported with a precision of 3.
100
SEX_CODE VARCHAR2 Code for the sex of the species.
100
BERRIED_OVA_COLOR_CODE VARCHAR2 Code for the color of the berried ova.
100
MALE_MATURITY_CODE VARCHAR2 Code for the maturity of the male.
100
GILL_PARASITE_CODE VARCHAR2 Code for the presence of gill parasites.
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., D84233.
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: 1003495
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: 1003496
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: 1003497
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

CRUISE_NUMBER

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

Last two digits of the year of the cruise and two-digit incremental number of the cruise for the year.

General Data Type: VARCHAR2

YEAR

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

Year of capture.

General Data Type: VARCHAR2

MONTH

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

Month of capture.

General Data Type: VARCHAR2

DAY

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

Day of capture.

General Data Type: VARCHAR2

STATION_NUMBER_FIRST

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

First station number. For AA1 format, there was only one capture station number collected. For AA2 format, if only one station number was collected, the same number was entered into STATION_NUMBER_FIRST and STATION_NUMBER_LAST.

General Data Type: VARCHAR2

STATION_NUMBER_LAST

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

Last station number.

General Data Type: VARCHAR2

LATITUDE_DEGREES

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

Latitude degrees. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees

LATITUDE_MINUTES

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

Latitude minutes, in tenths of a minute. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3.

General Data Type: VARCHAR2
Unit of Measure: minutes

LATITUDE_DIRECTION

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

Latitude direction.

General Data Type: VARCHAR2
Allowed Values: N = NORTH; S= SOUTH

LATITUDE_DD

CC ID: 1003507
Seq. Order: 13
Data Storage Type: NUMERIC
Max Length: 41
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: NUMERIC
Unit of Measure: degrees

LONGITUDE_DEGREES

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

Longitude degrees. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees

LONGITUDE_MINUTES

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

Longitude minutes, in tenths of a minute. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3.

General Data Type: VARCHAR2
Unit of Measure: minutes

LONGITUDE_DIRECTION

CC ID: 1003510
Seq. Order: 16
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: 1003511
Seq. Order: 17
Data Storage Type: NUMERIC
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: NUMERIC
Unit of Measure: degrees

BANK_CODE

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

Seven digit bank code.

General Data Type: VARCHAR2

DEPTH_SET

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

Set depth, in fathoms. Units for values are fathoms.

General Data Type: VARCHAR2
Unit of Measure: fathoms

DEPTH_HAUL

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

Haul depth in fathoms. Units for values are fathoms.

General Data Type: VARCHAR2
Unit of Measure: fathoms

DEPTH_MINIMUM

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

Minimum depth, in fathoms. For AA1 format, if only one depth, the same number was entered into DEPTH_MINIMUM and DEPTH_MAXIMUM. Units for values are fathoms.

General Data Type: VARCHAR2
Unit of Measure: fathoms

DEPTH_MAXIMUM

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

Maximum depth, in fathoms. Units for values are fathoms.

General Data Type: VARCHAR2
Unit of Measure: fathoms

LINE_NUMBER

CC ID: 1003517
Seq. Order: 23
Data Storage Type: NUMERIC
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

A consecutive number for each entry on the collection form.

General Data Type: NUMERIC

SPECIES_CODE

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

Czm 10-digit species code.

General Data Type: VARCHAR2

STRING_NUMBER

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

The consecutive number of the string of traps.

General Data Type: VARCHAR2

GEAR_CODE

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

Code for the type of gear used.

General Data Type: VARCHAR2

TRAP_NUMBER_FIRST

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

First trap number. For AA2 format if only one trap number, the same number was entered into TRAP_NUMBER_FIRST AND TRAP_NUMBER_LAST.

General Data Type: VARCHAR2

TRAP_NUMBER_LAST

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

Last trap number.

General Data Type: VARCHAR2

CARAPACE_LENGTH

CC ID: 1003523
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Scale: 2
Status: Active
Description:

Carapace length, in hundredths of a millimeter. For AA1 format, data was collected in tens of millimeter and reformated to hundreds of millimeter. During data entry the decimal point was omitted; it has have 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

CARAPACE_WIDTH

CC ID: 1003524
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Scale: 2
Status: Active
Description:

Carapace width, in hundredths of a millimeter. During data entry the decimal point was omitted; it has have 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

TOTAL_LENGTH

CC ID: 1003525
Seq. Order: 31
Data Storage Type: NUMERIC
Max Length: 6
Required: No
Primary Key: No
Scale: 2
Status: Active
Description:

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

General Data Type: NUMERIC
Unit of Measure: millimeters

WEIGHT

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

Weight, in tenths of a gram. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are grams. Measures are reported with a precision of 3.

General Data Type: VARCHAR2
Unit of Measure: grams

SEX_CODE

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

Code for the sex of the species.

General Data Type: VARCHAR2
Allowed Values: F = FEMALE; I = IMMATURE; M = MALE; U = UNKNOWN, UNDETERMINED

BERRIED_OVA_COLOR_CODE

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

Code for the color of the berried ova.

General Data Type: VARCHAR2
Allowed Values: 1 = ORANGE; 2 = BROWN; 3 = WHITE; 4 = BLUE; 5 = BERRIED (COLOR NOT RECORDED); } = UNKNOWN CODE

MALE_MATURITY_CODE

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

Code for the maturity of the male.

General Data Type: VARCHAR2
Allowed Values: 0 = BLANK OR -; 3 = I, IMMATURE; 5 = IU, BETWEEN IMMATURE/UNDERDEVELOPED; 7 = U, UNDEVELOPED 9 = CU, COMPLETELY UNDEVELOPED; } = UNKNOWN CODE

GILL_PARASITE_CODE

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

Code for the presence of gill parasites.

General Data Type: VARCHAR2
Allowed Values: 1 = GILL PARASITE PRESENT

JOB_NUMBER

CC ID: 1003531
Seq. Order: 37
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., D84233.

General Data Type: VARCHAR2

SEQUENCE_NUMBER

CC ID: 1003532
Seq. Order: 38
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: 1003533
Seq. Order: 39
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: 53175
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2018-08-01 18:53+0000
Metadata Record Last Modified By: Brent M Miyamoto
Metadata Record Last Modified: 2021-01-15 22:40+0000
Metadata Record Published: 2021-01-14
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-01-15