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. |
Attribute Details
DATASET_CODE
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |