Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
PIFSC Metadata Library > PIFSC Historical Datasets Metadata Portfolio > Historical Research Insular Metadata Portfolio > Shrimp Morphometric Log data collected by a com... >

RI020AA2_CONF_V

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:53177  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

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

Description

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

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.
VESSEL_CODE
VARCHAR2 		Code for the vessel.
CRUISE_NUMBER
VARCHAR2 		Last two digits of the year of the cruise and two-digit incremental number of the cruise for the year.
YEAR
VARCHAR2 		Year of capture.
MONTH
VARCHAR2 		Month of capture.
DAY
VARCHAR2 		Day of capture.
STATION_NUMBER_FIRST
VARCHAR2 		First station number. For AA1 format, there was only one capture station number collected and entered.
STATION_NUMBER_LAST
VARCHAR2 		Last station number.
LATITUDE_DEGREES
VARCHAR2 		Latitude degrees. Units for values are degrees. Data was collected but not entered.
LATITUDE_MINUTES
VARCHAR2 		Latitude minutes, in tenths of a minute. Units for values are minutes. Data was collected but not entered.
LATITUDE_DIRECTION
VARCHAR2 		Latitude direction. Data was collected but not entered.
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.
LONGITUDE_DEGREES
VARCHAR2 		Longitude degrees. Units for values are degrees. Data was collected but not entered.
LONGITUDE_MINUTES
VARCHAR2 		Longitude minutes, in tenths of a minute. Units for values are minutes. Data was collected but not entered.
LONGITUDE_DIRECTION
VARCHAR2 		Longitude direction. Data was collected but not entered.
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.
BANK_CODE
VARCHAR2 		Seven digit bank code.
DEPTH_SET
VARCHAR2 		Set depth, in fathoms. Units for values are fathoms.
DEPTH_HAUL
VARCHAR2 		Haul depth in fathoms. Units for values are fathoms.
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.
DEPTH_MAXIMUM
VARCHAR2 		Maximum depth, in fathoms. Units for values are fathoms.
LINE_NUMBER
NUMERIC 		A consecutive number for each entry on the collection form.
SPECIES_CODE
VARCHAR2 		CZM 10-digit species code.
STRING_NUMBER
VARCHAR2 		The consecutive number of the string of traps.
GEAR_CODE
VARCHAR2 		Code for the type of gear used.
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.
TRAP_NUMBER_LAST
VARCHAR2 		Last trap number.
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.
CARAPACE_WIDTH
VARCHAR2 		Carapace width, in hundredths of a millimeter. Units for values are millimeters.
TOTAL_LENGTH
NUMERIC 		Total length, in hundredths of a millimeter. Units for values are millimeters.
WEIGHT
VARCHAR2 		Weight, in tenths of a gram. Units for values are grams.
SEX_CODE
VARCHAR2 		Code for the sex of the species.
BERRIED_OVA_COLOR_CODE
VARCHAR2 		Code for the color of the berried ova.
MALE_MATURITY_CODE
VARCHAR2 		Code for the maturity of the male.
GILL_PARASITE_CODE
VARCHAR2 		Code for the presence of gill parasites.
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.
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: 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
GUID: gov.noaa.nmfs.inport:53177
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2018-08-01 18:55+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-01-14
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-01-14
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-01-14