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 > Lobster Tagging and Morphometric Form data coll... >

RI036AA2_CONF_V

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

Summary

Abstract

Lobster tagging and morphometric data collected during one cruise of a commercial fishey vessel.

Description

Lobster tagging and morphometric data collected during one cruise of a commercial fishey vessel.

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.
HAUL_YEAR
VARCHAR2 		Year that the string was hauled.
HAUL_MONTH
VARCHAR2 		Month that the string was hauled.
HAUL_DAY
VARCHAR2 		Day that the string was hauled.
STRING_NUMBER
VARCHAR2 		String number of traps.
STATION_NUMBER
VARCHAR2 		Station number of lobster operation.
NUMBER_TRAPS
VARCHAR2 		Number of traps.
START_DEPTH
VARCHAR2 		Start depth, in tenths of a fathom. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are fathoms. Measures are reported with a precision of 5.
END_DEPTH
VARCHAR2 		End depth, in tenths of a fathom. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are fathoms. Measures are reported with a precision of 5.
START_LATITUDE_DEGREES
VARCHAR2 		Start latitude degrees, in degrees. Units for values are degrees.
START_LATITUDE_MINUTES
VARCHAR2 		Start latitude minutes, in hundredths 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 4.
START_LATITUDE_DIRECTION
VARCHAR2 		Start latitude direction.
START_LATITUDE_DD
NUMBER 		Computed start 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.
START_LONGITUDE_DEGREES
VARCHAR2 		Start longitude degrees, in degrees. Units for values are degrees.
START_LONGITUDE_MINUTES
VARCHAR2 		Start longitude minutes, in hundredths 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 4.
START_LONGITUDE_DIRECTION
VARCHAR2 		Start longitude direction.
START_LONGITUDE_DD
NUMBER 		Computed start 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.
END_LATITUDE_DEGREES
VARCHAR2 		End latitude degrees, in degrees. Units for values are degrees.
END_LATITUDE_MINUTES
VARCHAR2 		End latitude minutes, in hundredths 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 4.
END_LATITUDE_DIRECTION
VARCHAR2 		End latitude direction.
END_LATITUDE_DD
NUMBER 		Computed end 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.
END_LONGITUDE_DEGREES
VARCHAR2 		End longitude degrees, in degrees. Units for values are degrees.
END_LONGITUDE_MINUTES
VARCHAR2 		End longitude minutes, in hundredths 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 4.
END_LONGITUDE_DIRECTION
VARCHAR2 		End longitude direction.
END_LONGITUDE_DD
NUMBER 		Computed end 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_LATITUDE_DEGREES
VARCHAR2 		Release latitude degrees, in degrees. Units for values are degrees.
RELEASE_LATITUDE_MINUTES
VARCHAR2 		Release latitude minutes, in hundredths 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 4.
RELEASE_LATITUDE_DIRECTION
VARCHAR2 		Release latitude direction.
RELEASE_LATITUDE_DD
NUMBER 		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, in degrees. Units for values are degrees.
RELEASE_LONGITUDE_MINUTES
VARCHAR2 		Release longitude minutes, in hundredths 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 4.
RELEASE_LONGITUDE_DIRECTION
VARCHAR2 		Release longitude direction.
RELEASE_LONGITUDE_DD
NUMBER 		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.
SAMPLE_NUMBER
VARCHAR2 		Unique consecutive number assigned to each catch on the data collection form. It starts at 001 for each string number.
SPECIES
VARCHAR2 		Species of lobster caught.
SEX_CODE
VARCHAR2 		Code for the sex of the lobster.
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.
TAIL_WIDTH
VARCHAR2 		Tail 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.
OVA_COLOR_CODE
VARCHAR2 		Code for the color of the ova.
TAG_NUMBER
VARCHAR2 		Unique tag number.
TAG_COLOR_CODE
VARCHAR2 		Code for the color of the tag.
TAG_CODE
VARCHAR2 		Code for TAG_NUMBER/TAG_COLOR_CODE.
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., D99002.
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: RI036AA2_CONF_V
Short Name: RI036AA2_CONF_V
Status: Completed
Abstract:

Lobster tagging and morphometric data collected during one cruise of a commercial fishey vessel.

Entity Information

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

Lobster tagging and morphometric data collected during one cruise of a commercial fishey vessel.

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
 HAUL_YEAR VARCHAR2 Year that the string was hauled.
100
 HAUL_MONTH VARCHAR2 Month that the string was hauled.
100
 HAUL_DAY VARCHAR2 Day that the string was hauled.
100
 STRING_NUMBER VARCHAR2 String number of traps.
100
 STATION_NUMBER VARCHAR2 Station number of lobster operation.
100
 NUMBER_TRAPS VARCHAR2 Number of traps.
100
 START_DEPTH VARCHAR2 Start depth, in tenths of a fathom. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are fathoms. Measures are reported with a precision of 5.
100
 END_DEPTH VARCHAR2 End depth, in tenths of a fathom. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are fathoms. Measures are reported with a precision of 5.
100
 START_LATITUDE_DEGREES VARCHAR2 Start latitude degrees, in degrees. Units for values are degrees.
100
 START_LATITUDE_MINUTES VARCHAR2 Start latitude minutes, in hundredths 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 4.
100
 START_LATITUDE_DIRECTION VARCHAR2 Start latitude direction.
100
 START_LATITUDE_DD NUMBER Computed start 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
 START_LONGITUDE_DEGREES VARCHAR2 Start longitude degrees, in degrees. Units for values are degrees.
100
 START_LONGITUDE_MINUTES VARCHAR2 Start longitude minutes, in hundredths 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 4.
100
 START_LONGITUDE_DIRECTION VARCHAR2 Start longitude direction.
100
 START_LONGITUDE_DD NUMBER Computed start 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
 END_LATITUDE_DEGREES VARCHAR2 End latitude degrees, in degrees. Units for values are degrees.
100
 END_LATITUDE_MINUTES VARCHAR2 End latitude minutes, in hundredths 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 4.
100
 END_LATITUDE_DIRECTION VARCHAR2 End latitude direction.
100
 END_LATITUDE_DD NUMBER Computed end 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
 END_LONGITUDE_DEGREES VARCHAR2 End longitude degrees, in degrees. Units for values are degrees.
100
 END_LONGITUDE_MINUTES VARCHAR2 End longitude minutes, in hundredths 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 4.
100
 END_LONGITUDE_DIRECTION VARCHAR2 End longitude direction.
100
 END_LONGITUDE_DD NUMBER Computed end 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_LATITUDE_DEGREES VARCHAR2 Release latitude degrees, in degrees. Units for values are degrees.
100
 RELEASE_LATITUDE_MINUTES VARCHAR2 Release latitude minutes, in hundredths 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 4.
100
 RELEASE_LATITUDE_DIRECTION VARCHAR2 Release latitude direction.
100
 RELEASE_LATITUDE_DD NUMBER 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, in degrees. Units for values are degrees.
100
 RELEASE_LONGITUDE_MINUTES VARCHAR2 Release longitude minutes, in hundredths 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 4.
100
 RELEASE_LONGITUDE_DIRECTION VARCHAR2 Release longitude direction.
100
 RELEASE_LONGITUDE_DD NUMBER 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
 SAMPLE_NUMBER VARCHAR2 Unique consecutive number assigned to each catch on the data collection form. It starts at 001 for each string number.
100
 SPECIES VARCHAR2 Species of lobster caught.
100
 SEX_CODE VARCHAR2 Code for the sex of the lobster.
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
 TAIL_WIDTH VARCHAR2 Tail 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
 OVA_COLOR_CODE VARCHAR2 Code for the color of the ova.
100
 TAG_NUMBER VARCHAR2 Unique tag number.
100
 TAG_COLOR_CODE VARCHAR2 Code for the color of the tag.
100
 TAG_CODE VARCHAR2 Code for TAG_NUMBER/TAG_COLOR_CODE.
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., D99002.
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: 1044517
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: 1044518
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: 1044519
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Code for the vessel.
General Data Type: VARCHAR2

CRUISE_NUMBER

CC ID: 1044520
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

HAUL_YEAR

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

Year that the string was hauled.
General Data Type: VARCHAR2

HAUL_MONTH

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

Month that the string was hauled.
General Data Type: VARCHAR2

HAUL_DAY

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

Day that the string was hauled.
General Data Type: VARCHAR2

STRING_NUMBER

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

String number of traps.
General Data Type: VARCHAR2

STATION_NUMBER

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

Station number of lobster operation.
General Data Type: VARCHAR2

NUMBER_TRAPS

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

Number of traps.
General Data Type: VARCHAR2

START_DEPTH

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

Start depth, in tenths of a fathom. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are fathoms. Measures are reported with a precision of 5.
General Data Type: VARCHAR2
Unit of Measure: fathoms

END_DEPTH

CC ID: 1044528
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

End depth, in tenths of a fathom. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are fathoms. Measures are reported with a precision of 5.
General Data Type: VARCHAR2
Unit of Measure: fathoms

START_LATITUDE_DEGREES

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

Start latitude degrees, in degrees. Units for values are degrees.
General Data Type: VARCHAR2
Unit of Measure: degrees

START_LATITUDE_MINUTES

CC ID: 1044530
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Scale: 2
Status: Active
Description:

Start latitude minutes, in hundredths 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 4.
General Data Type: VARCHAR2
Unit of Measure: minutes

START_LATITUDE_DIRECTION

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

Start latitude direction.
General Data Type: VARCHAR2

START_LATITUDE_DD

CC ID: 1044532
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 41
Required: No
Primary Key: No
Scale: 38
Status: Active
Description:

Computed start 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: NUMBER
Unit of Measure: degrees

START_LONGITUDE_DEGREES

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

Start longitude degrees, in degrees. Units for values are degrees.
General Data Type: VARCHAR2
Unit of Measure: degrees

START_LONGITUDE_MINUTES

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

Start longitude minutes, in hundredths 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 4.
General Data Type: VARCHAR2
Unit of Measure: minutes

START_LONGITUDE_DIRECTION

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

Start longitude direction.
General Data Type: VARCHAR2

START_LONGITUDE_DD

CC ID: 1044536
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 41
Required: No
Primary Key: No
Scale: 36
Status: Active
Description:

Computed start 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: NUMBER
Unit of Measure: degrees

END_LATITUDE_DEGREES

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

End latitude degrees, in degrees. Units for values are degrees.
General Data Type: VARCHAR2
Unit of Measure: degrees

END_LATITUDE_MINUTES

CC ID: 1044538
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Scale: 2
Status: Active
Description:

End latitude minutes, in hundredths 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 4.
General Data Type: VARCHAR2
Unit of Measure: minutes

END_LATITUDE_DIRECTION

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

End latitude direction.
General Data Type: VARCHAR2

END_LATITUDE_DD

CC ID: 1044540
Seq. Order: 24
Data Storage Type: NUMBER
Max Length: 41
Required: No
Primary Key: No
Scale: 38
Status: Active
Description:

Computed end 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: NUMBER
Unit of Measure: degrees

END_LONGITUDE_DEGREES

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

End longitude degrees, in degrees. Units for values are degrees.
General Data Type: VARCHAR2
Unit of Measure: degrees

END_LONGITUDE_MINUTES

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

End longitude minutes, in hundredths 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 4.
General Data Type: VARCHAR2
Unit of Measure: minutes

END_LONGITUDE_DIRECTION

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

End longitude direction.
General Data Type: VARCHAR2

END_LONGITUDE_DD

CC ID: 1044544
Seq. Order: 28
Data Storage Type: NUMBER
Max Length: 41
Required: No
Primary Key: No
Scale: 36
Status: Active
Description:

Computed end 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: NUMBER
Unit of Measure: degrees

RELEASE_LATITUDE_DEGREES

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

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

RELEASE_LATITUDE_MINUTES

CC ID: 1044546
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Scale: 2
Status: Active
Description:

Release latitude minutes, in hundredths 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 4.
General Data Type: VARCHAR2
Unit of Measure: minutes

RELEASE_LATITUDE_DIRECTION

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

Release latitude direction.
General Data Type: VARCHAR2

RELEASE_LATITUDE_DD

CC ID: 1044548
Seq. Order: 32
Data Storage Type: NUMBER
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: NUMBER
Unit of Measure: degrees

RELEASE_LONGITUDE_DEGREES

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

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

RELEASE_LONGITUDE_MINUTES

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

Release longitude minutes, in hundredths 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 4.
General Data Type: VARCHAR2
Unit of Measure: minutes

RELEASE_LONGITUDE_DIRECTION

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

Release longitude direction.
General Data Type: VARCHAR2

RELEASE_LONGITUDE_DD

CC ID: 1044552
Seq. Order: 36
Data Storage Type: NUMBER
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: NUMBER
Unit of Measure: degrees

SAMPLE_NUMBER

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

Unique consecutive number assigned to each catch on the data collection form. It starts at 001 for each string number.
General Data Type: VARCHAR2

SPECIES

CC ID: 1044554
Seq. Order: 38
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Species of lobster caught.
General Data Type: VARCHAR2

SEX_CODE

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

Code for the sex of the lobster.
General Data Type: VARCHAR2

CARAPACE_LENGTH

CC ID: 1044556
Seq. Order: 40
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

TAIL_WIDTH

CC ID: 1044557
Seq. Order: 41
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; 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

OVA_COLOR_CODE

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

Code for the color of the ova.
General Data Type: VARCHAR2

TAG_NUMBER

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

Unique tag number.
General Data Type: VARCHAR2

TAG_COLOR_CODE

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

Code for the color of the tag.
General Data Type: VARCHAR2

TAG_CODE

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

Code for TAG_NUMBER/TAG_COLOR_CODE.
General Data Type: VARCHAR2

JOB_NUMBER

CC ID: 1044562
Seq. Order: 46
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., D99002.
General Data Type: VARCHAR2

SEQUENCE_NUMBER

CC ID: 1044563
Seq. Order: 47
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: 1044564
Seq. Order: 48
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: 64309
GUID: gov.noaa.nmfs.inport:64309
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2021-02-23 03:49+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-03-02
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-03-02
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-03-02