Slide Menu
Jump to Section...
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 

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