Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
PIFSC Metadata Library > PIFSC Historical Datasets Metadata Portfolio > Historical Research Pelagics Metadata Portfolio > Experimental midwater horizontal longline and v... >

RP050AA4_V

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

Summary

Abstract

Experimental midwater horizontal longline and vertical longline data collected during a NOAA R/V Townsend Cromwell cruise in 1989 at the SE Hancock Seamount.

Description

Experimental midwater horizontal longline and vertical longline data collected during a NOAA R/V Townsend Cromwell cruise in 1989 at the SE Hancock Seamount.

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 digits incremental number of the cruise for the year, e.g., 8906.
DATA_TYPE_CODE
VARCHAR2 		Code for the type of longline operation.
STATION_NUMBER
VARCHAR2 		Station number of the longline operataion.
BANK_CODE
VARCHAR2 		Seven digit bank code.
SET_LATITUDE_DEGREES
VARCHAR2 		Set latitude degrees. Units for values are degrees.
SET_LATITUDE_MINUTES
VARCHAR2 		Set 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.
SET_LATITUDE_DIRECTION
VARCHAR2 		Set latitude direction.
SET_LATITUDE_DD
NUMBER 		Computed set latitude, in decimal degrees. Postive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40.
SET_LONGITUDE_DEGREES
VARCHAR2 		Set longitude degrees. Units for values are degrees.
SET_LONGITUDE_MINUTES
VARCHAR2 		Set 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.
SET_LONGITUDE_DIRECTION
VARCHAR2 		Set longitude direction.
SET_LONGITUDE_DD
NUMBER 		Computed set longitude, in decimal degrees. Postive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.
HAUL_LATITUDE_DEGREES
VARCHAR2 		Haul latitude degrees. Units for values are degrees.
HAUL_LATITUDE_MINUTES
VARCHAR2 		Haul 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.
HAUL_LATITUDE_DIRECTION
VARCHAR2 		Haul latitude direction.
HAUL_LATITUDE_DD
NUMBER 		Computed haul latitude, in decimal degrees. Postive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40.
HAUL_LONGITUDE_DEGREES
VARCHAR2 		Haul longitude degrees. Units for values are degrees.
HAUL_LONGITUDE_MINUTES
VARCHAR2 		Haul longitude minutes, in tenths of a minute. During data entry, the decimal was omitted; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3.
HAUL_LONGITUDE_DIRECTION
VARCHAR2 		Haul longitude direction.
HAUL_LONGITUDE_DD
NUMBER 		Computed haul longitude, in decimal degrees. Postive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.
SET_YEAR
VARCHAR2 		Set year.
SET_MONTH
VARCHAR2 		Set month.
SET_DAY
VARCHAR2 		Set day.
SET_TIME
VARCHAR2 		Set time.
SET_START_DEPTH
VARCHAR2 		Set start depth, in fathoms. Units for values are fathoms.
SET_END_DEPTH
VARCHAR2 		Set end depth, in fathoms. Units for values are fathoms.
HAUL_YEAR
VARCHAR2 		Haul year.
HAUL_MONTH
VARCHAR2 		Haul month.
HAUL_DAY
VARCHAR2 		Haul day.
HAUL_TIME
VARCHAR2 		Haul time.
HAUL_START_DEPTH
VARCHAR2 		Haul start depth, in fathoms. Units for values are fathoms.
HAUL_END_DEPTH
VARCHAR2 		Haul end depth, in fathoms. Units for values are fathoms.
FLOATLINE
VARCHAR2 		Floatline, in fathoms. Units for values are fathoms.
DROPPER_LENGTH
VARCHAR2 		Dropper length, in tenths of a meter. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are meters. Measures are reported with a precision of 2.
DROPPER_SPACING
VARCHAR2 		Dropper spacing, in fathoms. Units for values are fathoms.
TOTAL_HOOKS
VARCHAR2 		Total number of hooks.
HOOK_TYPE_1
VARCHAR2 		Hook Type 1.
HOOK_TYPE_2
VARCHAR2 		Hook Type 2.
HOOK_TYPE_3
VARCHAR2 		Hook Type 3.
HOOK_TYPE_4
VARCHAR2 		Hook Type 4.
BAIT_CODE
VARCHAR2 		Code for the bait used.
TEMPERATURE_SURFACE
VARCHAR2 		Surface temperature, in tenths of a degree Centigrade. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees Centigrade. Measures are reported with a precision of 3.
TEMPERATURE_BOTTOM
VARCHAR2 		Bottom temperature, in tenths of a degree Centigrade. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees Centigrade. Measures are reported with a precision of 3.
STRING_NUMBER
VARCHAR2 		String number.
HOOK_NUMBER
VARCHAR2 		Hook number.
HOOK_SIZE
VARCHAR2 		Hook size.
FISH_NUMBER
VARCHAR2 		Fish number.
SPECIES_CODE
VARCHAR2 		Ten digit CZM species code.
FORK_LENGTH
VARCHAR2 		Fork length, tenths of a centimeter. During data entry, the decimal point was omitted; it has been inserted into the data. Measures are reported with a precision of 4.
WEIGHT
VARCHAR2 		Weight, in hundredths of a kilogram. During data entry, the decimal point was omitted; it has been inserted into the data. Measures are reported with a precision of 4.
SHARK_EATEN
VARCHAR2 		Shark eaten, null = blank, 1 = checked.
HOOK_LOST
VARCHAR2 		Hook lost, null = blank, 1 = checked.
BAIT
VARCHAR2 		Bait, null = blank, null = checked, 1 = 1.
TANGLE
VARCHAR2 		Tangle, null = blank, 1 = checked.
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., D89474.
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: RP050AA4_V
Short Name: RP050AA4_V
Status: Completed
Abstract:

Experimental midwater horizontal longline and vertical longline data collected during a NOAA R/V Townsend Cromwell cruise in 1989 at the SE Hancock Seamount.

Entity Information

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

Experimental midwater horizontal longline and vertical longline data collected during a NOAA R/V Townsend Cromwell cruise in 1989 at the SE Hancock Seamount.

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 digits incremental number of the cruise for the year, e.g., 8906.
100
 DATA_TYPE_CODE VARCHAR2 Code for the type of longline operation.
100
 STATION_NUMBER VARCHAR2 Station number of the longline operataion.
100
 BANK_CODE VARCHAR2 Seven digit bank code.
100
 SET_LATITUDE_DEGREES VARCHAR2 Set latitude degrees. Units for values are degrees.
100
 SET_LATITUDE_MINUTES VARCHAR2 Set 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
 SET_LATITUDE_DIRECTION VARCHAR2 Set latitude direction.
100
 SET_LATITUDE_DD NUMBER Computed set latitude, in decimal degrees. Postive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40.
100
 SET_LONGITUDE_DEGREES VARCHAR2 Set longitude degrees. Units for values are degrees.
100
 SET_LONGITUDE_MINUTES VARCHAR2 Set 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
 SET_LONGITUDE_DIRECTION VARCHAR2 Set longitude direction.
100
 SET_LONGITUDE_DD NUMBER Computed set longitude, in decimal degrees. Postive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.
100
 HAUL_LATITUDE_DEGREES VARCHAR2 Haul latitude degrees. Units for values are degrees.
100
 HAUL_LATITUDE_MINUTES VARCHAR2 Haul 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
 HAUL_LATITUDE_DIRECTION VARCHAR2 Haul latitude direction.
100
 HAUL_LATITUDE_DD NUMBER Computed haul latitude, in decimal degrees. Postive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40.
100
 HAUL_LONGITUDE_DEGREES VARCHAR2 Haul longitude degrees. Units for values are degrees.
100
 HAUL_LONGITUDE_MINUTES VARCHAR2 Haul longitude minutes, in tenths of a minute. During data entry, the decimal was omitted; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3.
100
 HAUL_LONGITUDE_DIRECTION VARCHAR2 Haul longitude direction.
100
 HAUL_LONGITUDE_DD NUMBER Computed haul longitude, in decimal degrees. Postive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.
100
 SET_YEAR VARCHAR2 Set year.
100
 SET_MONTH VARCHAR2 Set month.
100
 SET_DAY VARCHAR2 Set day.
100
 SET_TIME VARCHAR2 Set time.
100
 SET_START_DEPTH VARCHAR2 Set start depth, in fathoms. Units for values are fathoms.
100
 SET_END_DEPTH VARCHAR2 Set end depth, in fathoms. Units for values are fathoms.
100
 HAUL_YEAR VARCHAR2 Haul year.
100
 HAUL_MONTH VARCHAR2 Haul month.
100
 HAUL_DAY VARCHAR2 Haul day.
100
 HAUL_TIME VARCHAR2 Haul time.
100
 HAUL_START_DEPTH VARCHAR2 Haul start depth, in fathoms. Units for values are fathoms.
100
 HAUL_END_DEPTH VARCHAR2 Haul end depth, in fathoms. Units for values are fathoms.
100
 FLOATLINE VARCHAR2 Floatline, in fathoms. Units for values are fathoms.
100
 DROPPER_LENGTH VARCHAR2 Dropper length, in tenths of a meter. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are meters. Measures are reported with a precision of 2.
100
 DROPPER_SPACING VARCHAR2 Dropper spacing, in fathoms. Units for values are fathoms.
100
 TOTAL_HOOKS VARCHAR2 Total number of hooks.
100
 HOOK_TYPE_1 VARCHAR2 Hook Type 1.
100
 HOOK_TYPE_2 VARCHAR2 Hook Type 2.
100
 HOOK_TYPE_3 VARCHAR2 Hook Type 3.
100
 HOOK_TYPE_4 VARCHAR2 Hook Type 4.
100
 BAIT_CODE VARCHAR2 Code for the bait used.
100
 TEMPERATURE_SURFACE VARCHAR2 Surface temperature, in tenths of a degree Centigrade. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees Centigrade. Measures are reported with a precision of 3.
100
 TEMPERATURE_BOTTOM VARCHAR2 Bottom temperature, in tenths of a degree Centigrade. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees Centigrade. Measures are reported with a precision of 3.
100
 STRING_NUMBER VARCHAR2 String number.
100
 HOOK_NUMBER VARCHAR2 Hook number.
100
 HOOK_SIZE VARCHAR2 Hook size.
100
 FISH_NUMBER VARCHAR2 Fish number.
100
 SPECIES_CODE VARCHAR2 Ten digit CZM species code.
100
 FORK_LENGTH VARCHAR2 Fork length, tenths of a centimeter. During data entry, the decimal point was omitted; it has been inserted into the data. Measures are reported with a precision of 4.
100
 WEIGHT VARCHAR2 Weight, in hundredths of a kilogram. During data entry, the decimal point was omitted; it has been inserted into the data. Measures are reported with a precision of 4.
100
 SHARK_EATEN VARCHAR2 Shark eaten, null = blank, 1 = checked.
100
 HOOK_LOST VARCHAR2 Hook lost, null = blank, 1 = checked.
100
 BAIT VARCHAR2 Bait, null = blank, null = checked, 1 = 1.
100
 TANGLE VARCHAR2 Tangle, null = blank, 1 = checked.
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., D89474.
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: 1088531
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: 1088532
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: 1088533
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: 1088534
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 digits incremental number of the cruise for the year, e.g., 8906.
General Data Type: VARCHAR2

DATA_TYPE_CODE

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

Code for the type of longline operation.
General Data Type: VARCHAR2
Allowed Values: 1 = MIDWATER HORIZONTAL LONGLINE; 2 - VERTICAL LONGLINE

STATION_NUMBER

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

Station number of the longline operataion.
General Data Type: VARCHAR2

BANK_CODE

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

Seven digit bank code.
General Data Type: VARCHAR2
Allowed Values: 1270100 = SE HANCOCK SEAMOUNT

SET_LATITUDE_DEGREES

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

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

SET_LATITUDE_MINUTES

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

Set 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

SET_LATITUDE_DIRECTION

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

Set latitude direction.
General Data Type: VARCHAR2
Allowed Values: N = NORTH; S = SOUTH

SET_LATITUDE_DD

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

Computed set latitude, in decimal degrees. Postive 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

SET_LONGITUDE_DEGREES

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

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

SET_LONGITUDE_MINUTES

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

Set 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

SET_LONGITUDE_DIRECTION

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

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

SET_LONGITUDE_DD

CC ID: 1088545
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 40
Required: No
Primary Key: No
Scale: 36
Status: Active
Description:

Computed set longitude, in decimal degrees. Postive 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

HAUL_LATITUDE_DEGREES

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

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

HAUL_LATITUDE_MINUTES

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

Haul 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

HAUL_LATITUDE_DIRECTION

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

Haul latitude direction.
General Data Type: VARCHAR2
Allowed Values: N = NORTH; S = SOUTH

HAUL_LATITUDE_DD

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

Computed haul latitude, in decimal degrees. Postive 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

HAUL_LONGITUDE_DEGREES

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

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

HAUL_LONGITUDE_MINUTES

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

Haul longitude minutes, in tenths of a minute. During data entry, the decimal 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

HAUL_LONGITUDE_DIRECTION

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

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

HAUL_LONGITUDE_DD

CC ID: 1088553
Seq. Order: 23
Data Storage Type: NUMBER
Max Length: 40
Required: No
Primary Key: No
Scale: 36
Status: Active
Description:

Computed haul longitude, in decimal degrees. Postive 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

SET_YEAR

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

Set year.
General Data Type: VARCHAR2

SET_MONTH

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

Set month.
General Data Type: VARCHAR2

SET_DAY

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

Set day.
General Data Type: VARCHAR2

SET_TIME

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

Set time.
General Data Type: VARCHAR2

SET_START_DEPTH

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

Set start depth, in fathoms. Units for values are fathoms.
General Data Type: VARCHAR2
Unit of Measure: fathoms

SET_END_DEPTH

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

Set end depth, in fathoms. Units for values are fathoms.
General Data Type: VARCHAR2
Unit of Measure: fathoms

HAUL_YEAR

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

Haul year.
General Data Type: VARCHAR2

HAUL_MONTH

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

Haul month.
General Data Type: VARCHAR2

HAUL_DAY

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

Haul day.
General Data Type: VARCHAR2

HAUL_TIME

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

Haul time.
General Data Type: VARCHAR2

HAUL_START_DEPTH

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

Haul start depth, in fathoms. Units for values are fathoms.
General Data Type: VARCHAR2
Unit of Measure: fathoms

HAUL_END_DEPTH

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

Haul end depth, in fathoms. Units for values are fathoms.
General Data Type: VARCHAR2
Unit of Measure: fathoms

FLOATLINE

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

Floatline, in fathoms. Units for values are fathoms.
General Data Type: VARCHAR2
Unit of Measure: fathoms

DROPPER_LENGTH

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

Dropper length, in tenths of a meter. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are meters. Measures are reported with a precision of 2.
General Data Type: VARCHAR2
Unit of Measure: meters

DROPPER_SPACING

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

Dropper spacing, in fathoms. Units for values are fathoms.
General Data Type: VARCHAR2
Unit of Measure: fathoms

TOTAL_HOOKS

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

Total number of hooks.
General Data Type: VARCHAR2

HOOK_TYPE_1

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

Hook Type 1.
General Data Type: VARCHAR2

HOOK_TYPE_2

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

Hook Type 2.
General Data Type: VARCHAR2

HOOK_TYPE_3

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

Hook Type 3.
General Data Type: VARCHAR2

HOOK_TYPE_4

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

Hook Type 4.
General Data Type: VARCHAR2

BAIT_CODE

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

Code for the bait used.
General Data Type: VARCHAR2
Allowed Values: 01 = MIXED (CUT SEAMOUNT FISH); 04 = SQUID

TEMPERATURE_SURFACE

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

Surface temperature, in tenths of a degree Centigrade. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees Centigrade. Measures are reported with a precision of 3.
General Data Type: VARCHAR2
Unit of Measure: degrees Centigrade

TEMPERATURE_BOTTOM

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

Bottom temperature, in tenths of a degree Centigrade. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees Centigrade. Measures are reported with a precision of 3.
General Data Type: VARCHAR2
Unit of Measure: degrees Centigrade

STRING_NUMBER

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

String number.
General Data Type: VARCHAR2

HOOK_NUMBER

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

Hook number.
General Data Type: VARCHAR2

HOOK_SIZE

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

Hook size.
General Data Type: VARCHAR2

FISH_NUMBER

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

Fish number.
General Data Type: VARCHAR2

SPECIES_CODE

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

Ten digit CZM species code.
General Data Type: VARCHAR2
Allowed Values: 0000000000 = NO CATCH; 8516160403 = SQUALUS MITSUKURII (CHEN, ET. AL. 1979)(SQUALUS BLAINVILLEI, S. FERNANDINUS); 8516160603 = ETMOPTERUS PUSILLUS; 8546150102 = BERYX SPLENDENS; 8554590201 = PENTACEROS RICHARDSONI; NULL = LOST GEAR

FORK_LENGTH

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

Fork length, tenths of a centimeter. During data entry, the decimal point was omitted; it has been inserted into the data. Measures are reported with a precision of 4.
General Data Type: VARCHAR2

WEIGHT

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

Weight, in hundredths of a kilogram. During data entry, the decimal point was omitted; it has been inserted into the data. Measures are reported with a precision of 4.
General Data Type: VARCHAR2

SHARK_EATEN

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

Shark eaten, null = blank, 1 = checked.
General Data Type: VARCHAR2
Allowed Values: NULL = SHARK EATEN CELL BLANK; 1 = SHARK EATEN CELL CHECKED ON DATA COLLECTION FORM

HOOK_LOST

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

Hook lost, null = blank, 1 = checked.
General Data Type: VARCHAR2
Allowed Values: NULL = HOOK LOST CELL BLANK; 1 = HOOK LOST CELL CHECKED ON DATA COLLECTION FORM

BAIT

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

Bait, null = blank, null = checked, 1 = 1.
General Data Type: VARCHAR2
Allowed Values: NULL = BAIT CELL BLANK OR CHECKED; 1 = 1 IN BAIT CELL ON DATA COLLECTION FORM

TANGLE

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

Tangle, null = blank, 1 = checked.
General Data Type: VARCHAR2
Allowed Values: NULL = TANGLE CELL BLANK; 1 = TANGLE CELL CHECKED ON DATA COLLECTION FORM

JOB_NUMBER

CC ID: 1088588
Seq. Order: 58
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., D89474.
General Data Type: VARCHAR2

SEQUENCE_NUMBER

CC ID: 1088589
Seq. Order: 59
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: 1088590
Seq. Order: 60
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: 65544
GUID: gov.noaa.nmfs.inport:65544
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2021-09-29 01:32+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-09-29
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-09-29
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-09-29