Item Identification

Title: RI020AA2_CONF_V
Short Name: RI020AA2_CONF_V
Status: Completed
Abstract:

Shrimp Morphometric Log data collected on a commercial fishery vessel - CONFIDENTIAL.

Entity Information

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

Shrimp Morphometric Log data collected on a commercial fishery vessel - CONFIDENTIAL.

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 and entered.
100
STATION_NUMBER_LAST VARCHAR2 Last station number.
100
LATITUDE_DEGREES VARCHAR2 Latitude degrees. Units for values are degrees. Data was collected but not entered.
100
LATITUDE_MINUTES VARCHAR2 Latitude minutes, in tenths of a minute. Units for values are minutes. Data was collected but not entered.
100
LATITUDE_DIRECTION VARCHAR2 Latitude direction. Data was collected but not entered.
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. Data was collected but not entered.
100
LONGITUDE_MINUTES VARCHAR2 Longitude minutes, in tenths of a minute. Units for values are minutes. Data was collected but not entered.
100
LONGITUDE_DIRECTION VARCHAR2 Longitude direction. Data was collected but not entered.
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. Units for values are millimeters.
100
TOTAL_LENGTH NUMERIC Total length, in hundredths of a millimeter. Units for values are millimeters.
100
WEIGHT VARCHAR2 Weight, in tenths of a gram. Units for values are grams.
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., D84371.
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: 1003576
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: 1003577
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: 1003578
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

CRUISE_NUMBER

CC ID: 1003579
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: 1003580
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: 1003581
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: 1003582
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: 1003583
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 and entered.

General Data Type: VARCHAR2

STATION_NUMBER_LAST

CC ID: 1003584
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: 1003585
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. Data was collected but not entered.

General Data Type: VARCHAR2
Unit of Measure: degrees

LATITUDE_MINUTES

CC ID: 1003586
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. Units for values are minutes. Data was collected but not entered.

General Data Type: VARCHAR2
Unit of Measure: minutes

LATITUDE_DIRECTION

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

Latitude direction. Data was collected but not entered.

General Data Type: VARCHAR2

LATITUDE_DD

CC ID: 1003588
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: 1003589
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. Data was collected but not entered.

General Data Type: VARCHAR2
Unit of Measure: degrees

LONGITUDE_MINUTES

CC ID: 1003590
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. Units for values are minutes. Data was collected but not entered.

General Data Type: VARCHAR2
Unit of Measure: minutes

LONGITUDE_DIRECTION

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

Longitude direction. Data was collected but not entered.

General Data Type: VARCHAR2

LONGITUDE_DD

CC ID: 1003592
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: 1003593
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
Allowed Values: 2020100 = GUAM

DEPTH_SET

CC ID: 1003594
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: 1003595
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: 1003596
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: 1003597
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: 1003598
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: 1003599
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
Allowed Values: 6483460301 = HETEROCARPUS ENSIFER; 6483460302 = HETEROCARPUS LAEVIGATUS; 6483460303 = HETEROCARPUS SIBOGAE; 6483460304 = HETEROCARPUS DORSALIS; 6483460305 = HETEROCARPUS LEPIDUS

STRING_NUMBER

CC ID: 1003600
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: 1003601
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: 1003602
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: 1003603
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: 1003604
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: 1003605
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. Units for values are millimeters.

General Data Type: VARCHAR2
Unit of Measure: millimeters

TOTAL_LENGTH

CC ID: 1003606
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. Units for values are millimeters.

General Data Type: NUMERIC
Unit of Measure: millimeters

WEIGHT

CC ID: 1003607
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. Units for values are grams.

General Data Type: VARCHAR2
Unit of Measure: grams

SEX_CODE

CC ID: 1003608
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; M = MALE

BERRIED_OVA_COLOR_CODE

CC ID: 1003609
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)

MALE_MATURITY_CODE

CC ID: 1003610
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

GILL_PARASITE_CODE

CC ID: 1003611
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: 1003612
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., D84371.

General Data Type: VARCHAR2

SEQUENCE_NUMBER

CC ID: 1003613
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: 1003614
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: 53177
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2018-08-01 18:55+0000
Metadata Record Last Modified By: Brent M Miyamoto
Metadata Record Last Modified: 2021-01-15 22:43+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