Metadata Rubric

100%

6 / 6

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

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

	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.

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