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 > Crustacean Tagging and Morphometric Form data c... >

RI021AA1_V

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

Summary

Abstract

Crustacean Tagging and Morphometry data collected on NOAA R/V Townsend Cromwell cruises.

Description

Crustacean Tagging and Morphometry data collected on NOAA R/V Townsend Cromwell cruises.

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.
CAPTURE_STATION_NUMBER
VARCHAR2 		Capture station number.
CAPTURE_LATITUDE_DEGREES
VARCHAR2 		Capture latitude degrees. Units for values are degrees.
CAPTURE_LATITUDE_MINUTES
VARCHAR2 		Capture 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.
CAPTURE_LATITUDE_DIRECTION
VARCHAR2 		Capture latitude direction.
CAPTURE_LATITUDE_DD
NUMERIC 		Computed capture 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.
CAPTURE_LONGITUDE_DEGREES
VARCHAR2 		Capture longitude degrees. Units for values are degrees.
CAPTURE_LONGITUDE_MINUTES
VARCHAR2 		Capture 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.
CAPTURE_LONGITUDE_DIRECTION
VARCHAR2 		Capture longitude direction.
CAPTURE_LONGITUDE_DD
NUMERIC 		Computed capture 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.
RELEASE_STATION_NUMBER
VARCHAR2 		Release station number.
RELEASE_LATITUDE_DEGREES
VARCHAR2 		Release latitude degrees. Units for values are degrees.
RELEASE_LATITUDE_MINUTES
VARCHAR2 		Release 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.
RELEASE_LATITUDE_DIRECTION
VARCHAR2 		Release latitude direction.
RELEASE_LATITUDE_DD
VARCHAR2 		Computed release 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.
RELEASE_LONGITUDE_DEGREES
VARCHAR2 		Release longitude degrees. Units for values are degrees.
RELEASE_LONGITUDE_MINUTES
VARCHAR2 		Release 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.
RELEASE_LONGITUDE_DIRECTION
VARCHAR2 		Release longitude direction.
RELEASE_LONGITUDE_DD
VARCHAR2 		Computed release 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.
STRING_NUMBER
VARCHAR2 		The consecutive number of the string of traps. A string is an assembly of traps or pots attached to a mainline. If there is more than one string per station, each string should be numbered consecutively as they are retrieved.
TRAP_NUMBER
VARCHAR2 		The consecutive number assigned to gear (trap or pot) attached to a string.
GEAR_CODE
VARCHAR2 		Code for the type of gear used.
LINE_NUMBER
VARCHAR2 		A consecutive number for each entry on the collection form.
SPECIES_CODE
VARCHAR2 		Czm 10-digit species code.
TAG_NUMBER
VARCHAR2 		Tag number attached to the animal before release.
CARAPACE_LENGTH
VARCHAR2 		Carapace length, in hundredths of a millimeter. During data entry the decimal point was omitted; it has 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. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 5.
TAIL_LENGTH
VARCHAR2 		Tail length, in hundredths of a millimeter. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 5.
TAIL_WIDTH
VARCHAR2 		Tail width, in hundredths of a millimeter. During data entry the decimal point was omitted (00000 = 000.00). Units for values are millimeters. Measures are reported with a precision of 5.
TOTAL_LENGTH
VARCHAR2 		Total length, in hundredths of a millimeter. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 5.
WEIGHT
VARCHAR2 		Weight, in ten thousandths of a kilogram. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are kilograms. Measures are reported with a precision of 6.
SEX_CODE
VARCHAR2 		Code for the sex of the species.
BERRIED_OVA_COLOR_CODE
VARCHAR2 		Code for the color of the berried ova.
SPERM_PLATE_CODE
VARCHAR2 		Code for the condition of the sperm plate.
MISSING_LEFT_ANTENNA_CODE
VARCHAR2 		Code for missing appendage left antenna.
MISSING_LEFT_ANTENNULE_CODE
VARCHAR2 		Code for missing appendage left antennule.
MISSING_LEFT_LEG1_CODE
VARCHAR2 		Code for missing appendage left leg 1.
MISSING_LEFT_LEG2_CODE
VARCHAR2 		Code for missing appendage left leg 2.
MISSING_LEFT_LEG3_CODE
VARCHAR2 		Code for missing appendage left leg 3.
MISSING_LEFT_LEG4_CODE
VARCHAR2 		Code for missing appendage left leg 4.
MISSING_LEFT_LEG5_CODE
VARCHAR2 		Code for missing appendage left leg 5.
MISSING_RIGHT_ANTENNA_CODE
VARCHAR2 		Code for missing appendage right antenna.
MISSING_RIGHT_ANTENNULE_CODE
VARCHAR2 		Code for missing appendage right antennule.
MISSING_RIGHT_LEG1_CODE
VARCHAR2 		Code for missing appendage right leg 1.
MISSING_RIGHT_LEG2_CODE
VARCHAR2 		Code for missing appendage right leg 2.
MISSING_RIGHT_LEG3_CODE
VARCHAR2 		Code for missing appendage right leg 3.
MISSING_RIGHT_LEG4_CODE
VARCHAR2 		Code for missing appendage right leg 4.
MISSING_RIGHT_LEG5_CODE
VARCHAR2 		Code for missing appendage right leg 5.
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., D85013.
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: RI021AA1_V
Short Name: RI021AA1_V
Status: Completed
Abstract:

Crustacean Tagging and Morphometry data collected on NOAA R/V Townsend Cromwell cruises.

Entity Information

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

Crustacean Tagging and Morphometry data collected on NOAA R/V Townsend Cromwell cruises.

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
 CAPTURE_STATION_NUMBER VARCHAR2 Capture station number.
100
 CAPTURE_LATITUDE_DEGREES VARCHAR2 Capture latitude degrees. Units for values are degrees.
100
 CAPTURE_LATITUDE_MINUTES VARCHAR2 Capture 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
 CAPTURE_LATITUDE_DIRECTION VARCHAR2 Capture latitude direction.
100
 CAPTURE_LATITUDE_DD NUMERIC Computed capture 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
 CAPTURE_LONGITUDE_DEGREES VARCHAR2 Capture longitude degrees. Units for values are degrees.
100
 CAPTURE_LONGITUDE_MINUTES VARCHAR2 Capture 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
 CAPTURE_LONGITUDE_DIRECTION VARCHAR2 Capture longitude direction.
100
 CAPTURE_LONGITUDE_DD NUMERIC Computed capture 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
 RELEASE_STATION_NUMBER VARCHAR2 Release station number.
100
 RELEASE_LATITUDE_DEGREES VARCHAR2 Release latitude degrees. Units for values are degrees.
100
 RELEASE_LATITUDE_MINUTES VARCHAR2 Release 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
 RELEASE_LATITUDE_DIRECTION VARCHAR2 Release latitude direction.
100
 RELEASE_LATITUDE_DD VARCHAR2 Computed release 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
 RELEASE_LONGITUDE_DEGREES VARCHAR2 Release longitude degrees. Units for values are degrees.
100
 RELEASE_LONGITUDE_MINUTES VARCHAR2 Release 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
 RELEASE_LONGITUDE_DIRECTION VARCHAR2 Release longitude direction.
100
 RELEASE_LONGITUDE_DD VARCHAR2 Computed release 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
 STRING_NUMBER VARCHAR2 The consecutive number of the string of traps. A string is an assembly of traps or pots attached to a mainline. If there is more than one string per station, each string should be numbered consecutively as they are retrieved.
100
 TRAP_NUMBER VARCHAR2 The consecutive number assigned to gear (trap or pot) attached to a string.
100
 GEAR_CODE VARCHAR2 Code for the type of gear used.
100
 LINE_NUMBER VARCHAR2 A consecutive number for each entry on the collection form.
100
 SPECIES_CODE VARCHAR2 Czm 10-digit species code.
100
 TAG_NUMBER VARCHAR2 Tag number attached to the animal before release.
100
 CARAPACE_LENGTH VARCHAR2 Carapace length, in hundredths of a millimeter. During data entry the decimal point was omitted; it has 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 been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 5.
100
 TAIL_LENGTH VARCHAR2 Tail length, in hundredths of a millimeter. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 5.
100
 TAIL_WIDTH VARCHAR2 Tail width, in hundredths of a millimeter. During data entry the decimal point was omitted (00000 = 000.00). Units for values are millimeters. Measures are reported with a precision of 5.
100
 TOTAL_LENGTH VARCHAR2 Total length, in hundredths of a millimeter. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 5.
100
 WEIGHT VARCHAR2 Weight, in ten thousandths of a kilogram. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are kilograms. Measures are reported with a precision of 6.
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
 SPERM_PLATE_CODE VARCHAR2 Code for the condition of the sperm plate.
100
 MISSING_LEFT_ANTENNA_CODE VARCHAR2 Code for missing appendage left antenna.
100
 MISSING_LEFT_ANTENNULE_CODE VARCHAR2 Code for missing appendage left antennule.
100
 MISSING_LEFT_LEG1_CODE VARCHAR2 Code for missing appendage left leg 1.
100
 MISSING_LEFT_LEG2_CODE VARCHAR2 Code for missing appendage left leg 2.
100
 MISSING_LEFT_LEG3_CODE VARCHAR2 Code for missing appendage left leg 3.
100
 MISSING_LEFT_LEG4_CODE VARCHAR2 Code for missing appendage left leg 4.
100
 MISSING_LEFT_LEG5_CODE VARCHAR2 Code for missing appendage left leg 5.
100
 MISSING_RIGHT_ANTENNA_CODE VARCHAR2 Code for missing appendage right antenna.
100
 MISSING_RIGHT_ANTENNULE_CODE VARCHAR2 Code for missing appendage right antennule.
100
 MISSING_RIGHT_LEG1_CODE VARCHAR2 Code for missing appendage right leg 1.
100
 MISSING_RIGHT_LEG2_CODE VARCHAR2 Code for missing appendage right leg 2.
100
 MISSING_RIGHT_LEG3_CODE VARCHAR2 Code for missing appendage right leg 3.
100
 MISSING_RIGHT_LEG4_CODE VARCHAR2 Code for missing appendage right leg 4.
100
 MISSING_RIGHT_LEG5_CODE VARCHAR2 Code for missing appendage right leg 5.
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., D85013.
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: 1006622
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: 1006623
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: 1006624
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

CC ID: 1006625
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: 1006626
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: 1006627
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: 1006628
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

CAPTURE_STATION_NUMBER

CC ID: 1006629
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Capture station number.
General Data Type: VARCHAR2

CAPTURE_LATITUDE_DEGREES

CC ID: 1006630
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Capture latitude degrees. Units for values are degrees.
General Data Type: VARCHAR2
Unit of Measure: degrees

CAPTURE_LATITUDE_MINUTES

CC ID: 1006631
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Capture 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

CAPTURE_LATITUDE_DIRECTION

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

Capture latitude direction.
General Data Type: VARCHAR2
Allowed Values: N = NORTH

CAPTURE_LATITUDE_DD

CC ID: 1006633
Seq. Order: 12
Data Storage Type: NUMERIC
Max Length: 41
Required: No
Primary Key: No
Scale: 38
Status: Active
Description:

Computed capture 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

CAPTURE_LONGITUDE_DEGREES

CC ID: 1006634
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Capture longitude degrees. Units for values are degrees.
General Data Type: VARCHAR2
Unit of Measure: degrees

CAPTURE_LONGITUDE_MINUTES

CC ID: 1006635
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Capture 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

CAPTURE_LONGITUDE_DIRECTION

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

Capture longitude direction.
General Data Type: VARCHAR2
Allowed Values: E = EAST; W = WEST

CAPTURE_LONGITUDE_DD

CC ID: 1006637
Seq. Order: 16
Data Storage Type: NUMERIC
Max Length: 41
Required: No
Primary Key: No
Scale: 36
Status: Active
Description:

Computed capture 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

RELEASE_STATION_NUMBER

CC ID: 1006638
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Release station number.
General Data Type: VARCHAR2

RELEASE_LATITUDE_DEGREES

CC ID: 1006639
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Release latitude degrees. Units for values are degrees.
General Data Type: VARCHAR2
Unit of Measure: degrees

RELEASE_LATITUDE_MINUTES

CC ID: 1006640
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Release 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

RELEASE_LATITUDE_DIRECTION

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

Release latitude direction.
General Data Type: VARCHAR2
Allowed Values: N = NORTH

RELEASE_LATITUDE_DD

CC ID: 1006642
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 41
Required: No
Primary Key: No
Scale: 38
Status: Active
Description:

Computed release 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: VARCHAR2
Unit of Measure: degrees

RELEASE_LONGITUDE_DEGREES

CC ID: 1006643
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Release longitude degrees. Units for values are degrees.
General Data Type: VARCHAR2
Unit of Measure: degrees

RELEASE_LONGITUDE_MINUTES

CC ID: 1006644
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Release 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

RELEASE_LONGITUDE_DIRECTION

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

Release longitude direction.
General Data Type: VARCHAR2
Allowed Values: E = EAST; W = WEST

RELEASE_LONGITUDE_DD

CC ID: 1006646
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 41
Required: No
Primary Key: No
Scale: 36
Status: Active
Description:

Computed release 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: VARCHAR2
Unit of Measure: degrees

STRING_NUMBER

CC ID: 1006647
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

The consecutive number of the string of traps. A string is an assembly of traps or pots attached to a mainline. If there is more than one string per station, each string should be numbered consecutively as they are retrieved.
General Data Type: VARCHAR2

TRAP_NUMBER

CC ID: 1006648
Seq. Order: 27
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

The consecutive number assigned to gear (trap or pot) attached to a string.
General Data Type: VARCHAR2

GEAR_CODE

CC ID: 1006649
Seq. Order: 28
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
Allowed Values: 43 = "OCTOPUS POT - PLASTIC (PVC PIPE) TYPE, 5 IN DIAMETER PIPE, 3 IN MOUTH IN DIAMETER"; 45 = "PLASTIC LOBSTER POT, WITH 2 IN X 2 IN MESH (CONTROL)"; 46 = "PLASTIC LOBSTER POT (54 MM ESCAPE VENT) (BLACK)"; 47 = "PLASTIC LOBSTER POT (55 MM ESCAPE VENT) (RED)"; 48 = "PLASTIC LOBSTER POT (56 MM ESCAPE VENT) (BLUE)"; 61 = "VARIOUS CALIFORNIA LOBSTER POTS (GENERALLY 2 IN X 4 IN MESH) (FIRST USED ON TC 85-04, ALSO USED ON TC 86-05, PURCHASED FROM SPI)"; 64 = "2 CHAMBERED, 3 FUNNEL ENTRANCE WITH 4TH ENTRANCE TO INNER CHAMBER; 74 CM X 73 CM X 32 CM"

LINE_NUMBER

CC ID: 1006650
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

A consecutive number for each entry on the collection form.
General Data Type: VARCHAR2

SPECIES_CODE

CC ID: 1006651
Seq. Order: 30
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: 6483460302 = HETEROCARPUS LAEVIGATUS; 6486060101 = PANULIRUS JAPONICUS; 6486060101 = PANULIRUS MARGINATUS; 6486060102 = PANULIRUS PENICILLATUS; 6486070201 = SCYLLARIDES SQUAMMOSUS; 6486070202 = SCYLLARIDES HAANII; 6486070301 = PARRIBACUS ANTARCTICUS; 6487110401 = LITHODES NINTOKUAE; 6487110503 = PARALOMIS PACIFICA; 6488340301 = PROGERYON QUINOTAE; 6488340401 = NEOPILUMNOPLAX MAJOR

TAG_NUMBER

CC ID: 1006652
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

Tag number attached to the animal before release.
General Data Type: VARCHAR2

CARAPACE_LENGTH

CC ID: 1006653
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Scale: 2
Status: Active
Description:

Carapace length, in hundredths of a millimeter. During data entry the decimal point was omitted; it has 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: 1006654
Seq. Order: 33
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 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

TAIL_LENGTH

CC ID: 1006655
Seq. Order: 34
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Scale: 2
Status: Active
Description:

Tail length, in hundredths of a millimeter. During data entry the decimal point was omitted; it has 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

TAIL_WIDTH

CC ID: 1006656
Seq. Order: 35
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Scale: 2
Status: Active
Description:

Tail width, in hundredths of a millimeter. During data entry the decimal point was omitted (00000 = 000.00). Units for values are millimeters. Measures are reported with a precision of 5.
General Data Type: VARCHAR2
Unit of Measure: millimeters

TOTAL_LENGTH

CC ID: 1006657
Seq. Order: 36
Data Storage Type: VARCHAR2
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 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

WEIGHT

CC ID: 1006658
Seq. Order: 37
Data Storage Type: VARCHAR2
Max Length: 7
Required: No
Primary Key: No
Scale: 4
Status: Active
Description:

Weight, in ten thousandths of a kilogram. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are kilograms. Measures are reported with a precision of 6.
General Data Type: VARCHAR2
Unit of Measure: kilograms

SEX_CODE

CC ID: 1006659
Seq. Order: 38
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: 1006660
Seq. Order: 39
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 (SHRIMP ONLY); 5 = BERRIED (COLOR NOT RECORDED)

SPERM_PLATE_CODE

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

Code for the condition of the sperm plate.
General Data Type: VARCHAR2
Allowed Values: 1 = WHITISH BROWN (GRAY); 2 = BROWN SMOOTH; 3 = BROWN ROUGH; 4 = BLACK; 5 = SPERM PLATE PRESENT (CHECK, YES)

MISSING_LEFT_ANTENNA_CODE

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

Code for missing appendage left antenna.
General Data Type: VARCHAR2
Allowed Values: 0 = NO MISSING APPENDAGE; 1 = MISSING APPENDAGE

MISSING_LEFT_ANTENNULE_CODE

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

Code for missing appendage left antennule.
General Data Type: VARCHAR2
Allowed Values: 0 = NO MISSING APPENDAGE; 1 = MISSING APPENDAGE

MISSING_LEFT_LEG1_CODE

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

Code for missing appendage left leg 1.
General Data Type: VARCHAR2
Allowed Values: 0 = NO MISSING APPENDAGE; 1 = MISSING APPENDAGE

MISSING_LEFT_LEG2_CODE

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

Code for missing appendage left leg 2.
General Data Type: VARCHAR2
Allowed Values: 0 = NO MISSING APPENDAGE; 1 = MISSING APPENDAGE

MISSING_LEFT_LEG3_CODE

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

Code for missing appendage left leg 3.
General Data Type: VARCHAR2
Allowed Values: 0 = NO MISSING APPENDAGE; 1 = MISSING APPENDAGE

MISSING_LEFT_LEG4_CODE

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

Code for missing appendage left leg 4.
General Data Type: VARCHAR2
Allowed Values: 0 = NO MISSING APPENDAGE; 1 = MISSING APPENDAGE

MISSING_LEFT_LEG5_CODE

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

Code for missing appendage left leg 5.
General Data Type: VARCHAR2
Allowed Values: 0 = NO MISSING APPENDAGE; 1 = MISSING APPENDAGE

MISSING_RIGHT_ANTENNA_CODE

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

Code for missing appendage right antenna.
General Data Type: VARCHAR2
Allowed Values: 0 = NO MISSING APPENDAGE; 1 = MISSING APPENDAGE

MISSING_RIGHT_ANTENNULE_CODE

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

Code for missing appendage right antennule.
General Data Type: VARCHAR2
Allowed Values: 0 = NO MISSING APPENDAGE; 1 = MISSING APPENDAGE

MISSING_RIGHT_LEG1_CODE

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

Code for missing appendage right leg 1.
General Data Type: VARCHAR2
Allowed Values: 0 = NO MISSING APPENDAGE; 1 = MISSING APPENDAGE

MISSING_RIGHT_LEG2_CODE

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

Code for missing appendage right leg 2.
General Data Type: VARCHAR2
Allowed Values: 0 = NO MISSING APPENDAGE; 1 = MISSING APPENDAGE

MISSING_RIGHT_LEG3_CODE

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

Code for missing appendage right leg 3.
General Data Type: VARCHAR2
Allowed Values: 0 = NO MISSING APPENDAGE; 1 = MISSING APPENDAGE

MISSING_RIGHT_LEG4_CODE

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

Code for missing appendage right leg 4.
General Data Type: VARCHAR2
Allowed Values: 0 = NO MISSING APPENDAGE; 1 = MISSING APPENDAGE

MISSING_RIGHT_LEG5_CODE

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

Code for missing appendage right leg 5.
General Data Type: VARCHAR2
Allowed Values: 0 = NO MISSING APPENDAGE; 1 = MISSING APPENDAGE

JOB_NUMBER

CC ID: 1006676
Seq. Order: 55
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., D85013.
General Data Type: VARCHAR2

SEQUENCE_NUMBER

CC ID: 1006677
Seq. Order: 56
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: 1006679
Seq. Order: 57
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: 63444
GUID: gov.noaa.nmfs.inport:63444
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2021-01-15 23:58+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-01-22
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-01-22
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-01-22