Metadata Rubric

100%

6 / 6

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

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

	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.

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