RI020AA2_RSCH_V
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:53175 | Updated: August 9, 2022 | Published / External
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
![]() |
![]() |
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
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 |
Allowed Values: | 001 = NOAA R/V TOWNSEND CROMWELL |
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. 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
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. |
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. 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
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
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. |
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. 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
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
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 |
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 |
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. 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
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
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
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
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
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
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., D84233. |
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: | 53175 |
---|---|
GUID: | gov.noaa.nmfs.inport:53175 |
Metadata Record Created By: | Brent M Miyamoto |
Metadata Record Created: | 2018-08-01 18:53+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 |