Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
PIFSC Metadata Library > PIFSC Historical Datasets Metadata Portfolio > Historical Research Insular Metadata Portfolio > Experimental Vertical Longline Report data coll... >

RI028AA1_V

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

Summary

Abstract

Experimental veritical longline data collected on NOAA R/V Townsend Cromwell cruises.

Description

Experimental veritical longline data collected on NOAA R/V Townsend Cromwell cruises.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
DATASET_CODE
VARCHAR2 		Source ID Code assigned by the data entry staff.
VERSION_CODE
VARCHAR2 		Code for the format version assigned by the data entry staff.
VESSEL_CODE
VARCHAR2 		Code for the vessel.
CRUISE_NUMBER
VARCHAR2 		Last two digits of the year of the cruise and two-digit incremental number of the cruise for the year.
STATION_NUMBER
VARCHAR2 		Station number of longline operation.
BANK_CODE
VARCHAR2 		Seven-digit bank code.
START_LATITUDE_DEGREES
VARCHAR2 		Start latitude degrees, in degrees. Units for values are degrees.
START_LATITUDE_MINUTES
VARCHAR2 		Start 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.
START_LATITUDE_DIRECTION
VARCHAR2 		Start latitude direction.
START_LATITUDE_DD
NUMBER 		Computed start latitude, in decimal degrees. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40.
START_LONGITUDE_DEGREES
VARCHAR2 		Start longitude degrees, in degrees. Units for values are degrees.
START_LONGITUDE_MINUTES
VARCHAR2 		Start longitude minutes, in 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.
START_LONGITUDE_DIRECTION
VARCHAR2 		Start longitude direction.
START_LONGITUDE_DD
NUMBER 		Computed start longitude, in decimal degrees. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.
END_LATITUDE_DEGREES
VARCHAR2 		End latitude degrees, in degrees. Units for values are degrees.
END_LATITUDE_MINUTES
VARCHAR2 		End latitude minutes, in 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.
END_LATITUDE_DIRECTION
VARCHAR2 		End latitude direction.
END_LATITUDE_DD
NUMBER 		Computed end latitude, in decimal degrees. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40.
END_LONGITUDE_DEGREES
VARCHAR2 		End longitude degrees, in degrees. Units for values are degrees.
END_LONGITUDE_MINUTES
VARCHAR2 		End longitude minutes, in 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.
END_LONGITUDE_DIRECTION
VARCHAR2 		End longitude direction.
END_LONGITUDE_DD
NUMBER 		Computed end longitude, in decimal degrees. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.
SET_YEAR
VARCHAR2 		Set gear year.
SET_MONTH
VARCHAR2 		Set gear month.
SET_DAY
VARCHAR2 		Set gear day.
SET_TIME
VARCHAR2 		Set gear time.
SET_START_DEPTH
VARCHAR2 		Set gear start depth, in fathom. Units for values are fathoms.
SET_END_DEPTH
VARCHAR2 		Set gear end depth, in fathoms. Units for values are fathoms.
HAUL_YEAR
VARCHAR2 		Haul gear year.
HAUL_MONTH
VARCHAR2 		Haul gear month.
HAUL_DAY
VARCHAR2 		Haul gear day.
HAUL_TIME
VARCHAR2 		Haul gear time.
HAUL_START_DEPTH
VARCHAR2 		Haul gear start depth, in fathoms. Units for values are fathoms.
HAUL_END_DEPTH
VARCHAR2 		Haul gear end depth, in fathoms. Units for values are fathoms.
NUMBER_DROPPERS
VARCHAR2 		Number of dropper lines on the longline gear.
HOOKS_PER_DROPPER
VARCHAR2 		Number of hooks on a dropper line.
DROPPER_SPACING
VARCHAR2 		Distance between droppers, in fathoms. Units for values are fathoms.
TOTAL_HOOKS
VARCHAR2 		Total number of hooks.
HOOK_SIZE1
VARCHAR2 		Size of hook on the dropper.
HOOK_SIZE2
VARCHAR2 		Size of hook, if a second hook type used.
HOOK_SIZE3
VARCHAR2 		Size of hook, if a third hook type used.
HOOK_SIZE4
VARCHAR2 		Size of hook, if a fourth hook type used.
BAIT_CODE
VARCHAR2 		Code for the type of bait used.
SURFACE_TEMPERATURE
VARCHAR2 		Surface temperature, in tenths of a degree Celsius. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees Celsius. Measures are reported with a precision of 3.
BOTTOM_TEMPERATURE
VARCHAR2 		Bottom temperature, in tenths of a degree Celsius. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees Celsius. Measures are reported with a precision of 3.
DROPPER_NUMBER
VARCHAR2 		Dropper number on the longline gear.
HOOK_NUMBER
VARCHAR2 		Hook number on the dropper.
HOOK_SIZE
VARCHAR2 		Hook size of the hook number.
FISH_NUMBER
VARCHAR2 		Unique number assigned to each fish.
SPECIES_CODE
VARCHAR2 		CZM 10-digit species code.
FORK_LENGTH
VARCHAR2 		Fork length, in 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 5.
SHARK_EATEN_CODE
VARCHAR2 		Code for species was shark eaten.
HOOK_LOST_CODE
VARCHAR2 		Code if the hook was lost.
BAIT_MISSING_CODE
VARCHAR2 		Code if the bait was missing.
TANGLE_CODE
VARCHAR2 		Code if the line was tangled.
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., D85227.
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: RI028AA1_V
Short Name: RI028AA1_V
Status: Completed
Abstract:

Experimental veritical longline data collected on NOAA R/V Townsend Cromwell cruises.

Entity Information

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

Experimental veritical longline data collected on NOAA R/V Townsend Cromwell cruises.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 DATASET_CODE VARCHAR2 Source ID Code assigned by the data entry staff.
100
 VERSION_CODE VARCHAR2 Code for the format version assigned by the data entry staff.
100
 VESSEL_CODE VARCHAR2 Code for the vessel.
100
 CRUISE_NUMBER VARCHAR2 Last two digits of the year of the cruise and two-digit incremental number of the cruise for the year.
100
 STATION_NUMBER VARCHAR2 Station number of longline operation.
100
 BANK_CODE VARCHAR2 Seven-digit bank code.
100
 START_LATITUDE_DEGREES VARCHAR2 Start latitude degrees, in degrees. Units for values are degrees.
100
 START_LATITUDE_MINUTES VARCHAR2 Start 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
 START_LATITUDE_DIRECTION VARCHAR2 Start latitude direction.
100
 START_LATITUDE_DD NUMBER Computed start latitude, in decimal degrees. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40.
100
 START_LONGITUDE_DEGREES VARCHAR2 Start longitude degrees, in degrees. Units for values are degrees.
100
 START_LONGITUDE_MINUTES VARCHAR2 Start longitude minutes, in 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
 START_LONGITUDE_DIRECTION VARCHAR2 Start longitude direction.
100
 START_LONGITUDE_DD NUMBER Computed start longitude, in decimal degrees. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.
100
 END_LATITUDE_DEGREES VARCHAR2 End latitude degrees, in degrees. Units for values are degrees.
100
 END_LATITUDE_MINUTES VARCHAR2 End latitude minutes, in 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
 END_LATITUDE_DIRECTION VARCHAR2 End latitude direction.
100
 END_LATITUDE_DD NUMBER Computed end latitude, in decimal degrees. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40.
100
 END_LONGITUDE_DEGREES VARCHAR2 End longitude degrees, in degrees. Units for values are degrees.
100
 END_LONGITUDE_MINUTES VARCHAR2 End longitude minutes, in 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
 END_LONGITUDE_DIRECTION VARCHAR2 End longitude direction.
100
 END_LONGITUDE_DD NUMBER Computed end longitude, in decimal degrees. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.
100
 SET_YEAR VARCHAR2 Set gear year.
100
 SET_MONTH VARCHAR2 Set gear month.
100
 SET_DAY VARCHAR2 Set gear day.
100
 SET_TIME VARCHAR2 Set gear time.
100
 SET_START_DEPTH VARCHAR2 Set gear start depth, in fathom. Units for values are fathoms.
100
 SET_END_DEPTH VARCHAR2 Set gear end depth, in fathoms. Units for values are fathoms.
100
 HAUL_YEAR VARCHAR2 Haul gear year.
100
 HAUL_MONTH VARCHAR2 Haul gear month.
100
 HAUL_DAY VARCHAR2 Haul gear day.
100
 HAUL_TIME VARCHAR2 Haul gear time.
100
 HAUL_START_DEPTH VARCHAR2 Haul gear start depth, in fathoms. Units for values are fathoms.
100
 HAUL_END_DEPTH VARCHAR2 Haul gear end depth, in fathoms. Units for values are fathoms.
100
 NUMBER_DROPPERS VARCHAR2 Number of dropper lines on the longline gear.
100
 HOOKS_PER_DROPPER VARCHAR2 Number of hooks on a dropper line.
100
 DROPPER_SPACING VARCHAR2 Distance between droppers, in fathoms. Units for values are fathoms.
100
 TOTAL_HOOKS VARCHAR2 Total number of hooks.
100
 HOOK_SIZE1 VARCHAR2 Size of hook on the dropper.
100
 HOOK_SIZE2 VARCHAR2 Size of hook, if a second hook type used.
100
 HOOK_SIZE3 VARCHAR2 Size of hook, if a third hook type used.
100
 HOOK_SIZE4 VARCHAR2 Size of hook, if a fourth hook type used.
100
 BAIT_CODE VARCHAR2 Code for the type of bait used.
100
 SURFACE_TEMPERATURE VARCHAR2 Surface temperature, in tenths of a degree Celsius. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees Celsius. Measures are reported with a precision of 3.
100
 BOTTOM_TEMPERATURE VARCHAR2 Bottom temperature, in tenths of a degree Celsius. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees Celsius. Measures are reported with a precision of 3.
100
 DROPPER_NUMBER VARCHAR2 Dropper number on the longline gear.
100
 HOOK_NUMBER VARCHAR2 Hook number on the dropper.
100
 HOOK_SIZE VARCHAR2 Hook size of the hook number.
100
 FISH_NUMBER VARCHAR2 Unique number assigned to each fish.
100
 SPECIES_CODE VARCHAR2 CZM 10-digit species code.
100
 FORK_LENGTH VARCHAR2 Fork length, in 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 5.
100
 SHARK_EATEN_CODE VARCHAR2 Code for species was shark eaten.
100
 HOOK_LOST_CODE VARCHAR2 Code if the hook was lost.
100
 BAIT_MISSING_CODE VARCHAR2 Code if the bait was missing.
100
 TANGLE_CODE VARCHAR2 Code if the line was tangled.
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., D85227.
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: 1042208
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: 1042209
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: 1042210
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Code for the vessel.
General Data Type: VARCHAR2

CRUISE_NUMBER

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

Last two digits of the year of the cruise and two-digit incremental number of the cruise for the year.
General Data Type: VARCHAR2

STATION_NUMBER

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

Station number of longline operation.
General Data Type: VARCHAR2

BANK_CODE

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

Seven-digit bank code.
General Data Type: VARCHAR2

START_LATITUDE_DEGREES

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

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

START_LATITUDE_MINUTES

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

Start 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

START_LATITUDE_DIRECTION

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

Start latitude direction.
General Data Type: VARCHAR2

START_LATITUDE_DD

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

Computed start latitude, in decimal degrees. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40.
General Data Type: NUMBER
Unit of Measure: degrees

START_LONGITUDE_DEGREES

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

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

START_LONGITUDE_MINUTES

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

Start 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

START_LONGITUDE_DIRECTION

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

Start longitude direction.
General Data Type: VARCHAR2

START_LONGITUDE_DD

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

Computed start longitude, in decimal degrees. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.
General Data Type: NUMBER
Unit of Measure: degrees

END_LATITUDE_DEGREES

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

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

END_LATITUDE_MINUTES

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

End 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

END_LATITUDE_DIRECTION

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

End latitude direction.
General Data Type: VARCHAR2

END_LATITUDE_DD

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

Computed end latitude, in decimal degrees. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40.
General Data Type: NUMBER
Unit of Measure: degrees

END_LONGITUDE_DEGREES

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

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

END_LONGITUDE_MINUTES

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

End 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

END_LONGITUDE_DIRECTION

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

End longitude direction.
General Data Type: VARCHAR2

END_LONGITUDE_DD

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

Computed end longitude, in decimal degrees. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.
General Data Type: NUMBER
Unit of Measure: degrees

SET_YEAR

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

Set gear year.
General Data Type: VARCHAR2

SET_MONTH

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

Set gear month.
General Data Type: VARCHAR2

SET_DAY

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

Set gear day.
General Data Type: VARCHAR2

SET_TIME

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

Set gear time.
General Data Type: VARCHAR2

SET_START_DEPTH

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

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

SET_END_DEPTH

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

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

HAUL_YEAR

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

Haul gear year.
General Data Type: VARCHAR2

HAUL_MONTH

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

Haul gear month.
General Data Type: VARCHAR2

HAUL_DAY

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

Haul gear day.
General Data Type: VARCHAR2

HAUL_TIME

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

Haul gear time.
General Data Type: VARCHAR2

HAUL_START_DEPTH

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

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

HAUL_END_DEPTH

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

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

NUMBER_DROPPERS

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

Number of dropper lines on the longline gear.
General Data Type: VARCHAR2

HOOKS_PER_DROPPER

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

Number of hooks on a dropper line.
General Data Type: VARCHAR2

DROPPER_SPACING

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

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

TOTAL_HOOKS

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

Total number of hooks.
General Data Type: VARCHAR2

HOOK_SIZE1

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

Size of hook on the dropper.
General Data Type: VARCHAR2

HOOK_SIZE2

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

Size of hook, if a second hook type used.
General Data Type: VARCHAR2

HOOK_SIZE3

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

Size of hook, if a third hook type used.
General Data Type: VARCHAR2

HOOK_SIZE4

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

Size of hook, if a fourth hook type used.
General Data Type: VARCHAR2

BAIT_CODE

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

Code for the type of bait used.
General Data Type: VARCHAR2

SURFACE_TEMPERATURE

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

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

BOTTOM_TEMPERATURE

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

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

DROPPER_NUMBER

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

Dropper number on the longline gear.
General Data Type: VARCHAR2

HOOK_NUMBER

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

Hook number on the dropper.
General Data Type: VARCHAR2

HOOK_SIZE

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

Hook size of the hook number.
General Data Type: VARCHAR2

FISH_NUMBER

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

Unique number assigned to each fish.
General Data Type: VARCHAR2

SPECIES_CODE

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

CZM 10-digit species code.
General Data Type: VARCHAR2

FORK_LENGTH

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

Fork length, in 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: 1042259
Seq. Order: 52
Data Storage Type: VARCHAR2
Max Length: 6
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 5.
General Data Type: VARCHAR2
Unit of Measure: kilograms

SHARK_EATEN_CODE

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

Code for species was shark eaten.
General Data Type: VARCHAR2

HOOK_LOST_CODE

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

Code if the hook was lost.
General Data Type: VARCHAR2

BAIT_MISSING_CODE

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

Code if the bait was missing.
General Data Type: VARCHAR2

TANGLE_CODE

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

Code if the line was tangled.
General Data Type: VARCHAR2

JOB_NUMBER

CC ID: 1042264
Seq. Order: 57
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., D85227.
General Data Type: VARCHAR2

SEQUENCE_NUMBER

CC ID: 1042265
Seq. Order: 58
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: 1042266
Seq. Order: 59
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: 64203
GUID: gov.noaa.nmfs.inport:64203
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2021-01-26 05:25+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-02-12
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-02-12
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-02-12