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 pelagic surface longline data coll... >

RP050AA3_V

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

Summary

Abstract

Pelagic surface longline data collected during a NOAA R/V Townsend Crowell cruise in 1990 at SE Hancock Seamount.

Description

Pelagic surface longline data collected during a NOAA R/V Townsend Crowell cruise in 1990 at 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., 9006.
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. Units not written, but assumed to be fathoms, since AA1 and AA2 depth units are fathoms. Units for values are fathoms.
SET_END_DEPTH
VARCHAR2 		Set end depth. Units not written, but assumed to be fathoms, since AA1 and AA2 depth units are 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. Units not written, but assumed to be fathoms, since the AA1 and AA2 depth units are fathoms. Units for values are fathoms.
HAUL_END_DEPTH
VARCHAR2 		Haul end depth. Units not written, but assumed to be fathoms, since AA1 and AA2 depth units are fathoms. Units for values are fathoms.
FLOATLINE
VARCHAR2 		Floatline, in fathoms. Units for values are fathoms.
DROPPER_LENGTH
VARCHAR2 		Dropper length, in meters. Units for values are meters.
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. Units for values are centimeters. 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. Units for values are kilograms. 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, 1 = checked.
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., D90327.
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: RP050AA3_V
Short Name: RP050AA3_V
Status: Completed
Abstract:

Pelagic surface longline data collected during a NOAA R/V Townsend Crowell cruise in 1990 at SE Hancock Seamount.

Entity Information

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

Pelagic surface longline data collected during a NOAA R/V Townsend Crowell cruise in 1990 at 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., 9006.
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. Units not written, but assumed to be fathoms, since AA1 and AA2 depth units are fathoms. Units for values are fathoms.
100
 SET_END_DEPTH VARCHAR2 Set end depth. Units not written, but assumed to be fathoms, since AA1 and AA2 depth units are 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. Units not written, but assumed to be fathoms, since the AA1 and AA2 depth units are fathoms. Units for values are fathoms.
100
 HAUL_END_DEPTH VARCHAR2 Haul end depth. Units not written, but assumed to be fathoms, since AA1 and AA2 depth units are fathoms. Units for values are fathoms.
100
 FLOATLINE VARCHAR2 Floatline, in fathoms. Units for values are fathoms.
100
 DROPPER_LENGTH VARCHAR2 Dropper length, in meters. Units for values are meters.
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. Units for values are centimeters. 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. Units for values are kilograms. 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, 1 = checked.
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., D90327.
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: 1087887
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: 1087888
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: 1087889
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: 1087890
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., 9006.
General Data Type: VARCHAR2

DATA_TYPE_CODE

CC ID: 1087891
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: 3 = PELAGIC SURFACE LONGLINE

STATION_NUMBER

CC ID: 1087892
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: 1087893
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: 1087894
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: 1087895
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: 1087896
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: 1087897
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: 1087898
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: 1087899
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: 1087900
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: 1087901
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: 1087902
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: 1087903
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: 1087904
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: 1087905
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: 1087906
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: 1087907
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: 1087908
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: 1087909
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: 1087910
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: 1087911
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: 1087912
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: 1087913
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: 1087914
Seq. Order: 28
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Set start depth. Units not written, but assumed to be fathoms, since AA1 and AA2 depth units are fathoms. Units for values are fathoms.
General Data Type: VARCHAR2
Unit of Measure: fathoms

SET_END_DEPTH

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

Set end depth. Units not written, but assumed to be fathoms, since AA1 and AA2 depth units are fathoms. Units for values are fathoms.
General Data Type: VARCHAR2
Unit of Measure: fathoms

HAUL_YEAR

CC ID: 1087916
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: 1087917
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: 1087918
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: 1087919
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: 1087920
Seq. Order: 34
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Haul start depth. Units not written, but assumed to be fathoms, since the AA1 and AA2 depth units are fathoms. Units for values are fathoms.
General Data Type: VARCHAR2
Unit of Measure: fathoms

HAUL_END_DEPTH

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

Haul end depth. Units not written, but assumed to be fathoms, since AA1 and AA2 depth units are fathoms. Units for values are fathoms.
General Data Type: VARCHAR2
Unit of Measure: fathoms

FLOATLINE

CC ID: 1087922
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: 1087923
Seq. Order: 37
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

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

DROPPER_SPACING

CC ID: 1087924
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: 1087925
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: 1087926
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: 1087927
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: 1087928
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: 1087929
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: 1087930
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: 04 = SQUID

TEMPERATURE_SURFACE

CC ID: 1087931
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: 1087932
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: 1087933
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: 1087934
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: 1087935
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: 1087936
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: 1087937
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; 8516080102 = ALOPIAS PELAGICUS; 8516120101 = PRIONACE GLAUCA; 8516120505 = CARCHARHINUS GALAPAGENSIS; 8516120506 = CARCHARHINUS MAOU (CZM LIST 10/78)(C. LONGIMANUS); 8555720201 = PROMETHICHTHYS PROMETHEUS; 8555740200 = SCOMBER SP.; 8555740703 = THUNNUS ALBACARES; 8555750101 = XIPHIAS GLADIUS; NULL = LOST GEAR

FORK_LENGTH

CC ID: 1087938
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. Units for values are centimeters. Measures are reported with a precision of 4.
General Data Type: VARCHAR2
Unit of Measure: centimeters

WEIGHT

CC ID: 1087939
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. Units for values are kilograms. Measures are reported with a precision of 4.
General Data Type: VARCHAR2
Unit of Measure: kilograms

SHARK_EATEN

CC ID: 1087940
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: 1087941
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: 1087942
Seq. Order: 56
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

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

TANGLE

CC ID: 1087943
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: 1087944
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., D90327.
General Data Type: VARCHAR2

SEQUENCE_NUMBER

CC ID: 1087945
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: 1087946
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: 65531
GUID: gov.noaa.nmfs.inport:65531
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2021-09-24 02:05+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-09-24
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-09-24
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-09-24