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 > Longline Fishing Morphometric Log collected dur... >

RP037AA1_V

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

Summary

Abstract

Longline fishing morphometric log data collected during the 1981 cruise of the Hokusei Maru.

Description

Longline morphometric data collected during the 1981 cruise of the Hokusei Maru.

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.
STATION_NUMBER
VARCHAR2 		Station number of the longline operation.
YEAR
VARCHAR2 		Year of the longline operation.
MONTH
VARCHAR2 		Month of the longline operation.
DAY
VARCHAR2 		Day of the longline operation.
TIME_ZONE_CODE
VARCHAR2 		Code for the time zone of the longline operation.
NUMBER_BASKETS
VARCHAR2 		Number of baskets set.
TOTAL_NUMBER_HOOKS
VARCHAR2 		Total number of hooks retrieved.
BAIT_CODE
VARCHAR2 		Code for the bait used.
DIRECTION_SET
VARCHAR2 		Direction of set, in degrees. Units for values are degrees.
BEGIN_SET_TIME
VARCHAR2 		Begin set time.
BEGIN_SET_LATITUDE_DEGREES
VARCHAR2 		Begin set latitude degrees, in degrees. Units for values are degrees.
BEGIN_SET_LATITUDE_MINUTES
VARCHAR2 		Begin set latitude minutes, in minutes. Units for values are minutes.
BEGIN_SET_LATITUDE_DIRECTION
VARCHAR2 		Not entered during data entry; derived value using BEGIN_SET_OCTANT.
BEGIN_SET_LATITUDE_DD
NUMBER 		Computed 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.
BEGIN_SET_LONGITUDE_DEGREES
VARCHAR2 		Begin set longitude degrees, in degrees. Units for values are degrees.
BEGIN_SET_LONGITUDE_MINUTES
VARCHAR2 		Begin set longitude minutes, in minutes. Units for values are minutes.
BEGIN_SET_LONGITUDE_DIRECTION
VARCHAR2 		Not entered during data entry; derived value using BEGIN_SET_OCTANT.
BEGIN_SET_LONGITUDE_DD
NUMBER 		Computed 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.
BEGIN_SET_OCTANT
VARCHAR2 		Begin set octant.
END_SET_TIME
VARCHAR2 		End set time.
END_SET_LATITUDE_DEGREES
VARCHAR2 		End set latitude degrees, in degrees. Units for values are degrees.
END_SET_LATITUDE_MINUTES
VARCHAR2 		End set latitude minutes, in minutes. Units for values are minutes.
END_SET_LATITUDE_DIRECTION
VARCHAR2 		Not entered during data entry; derived value using END_SET_OCTANT.
END_SET_LATITUDE_DD
NUMBER 		Computed 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_SET_LONGITUDE_DEGREES
VARCHAR2 		End set longitude degrees, in degrees. Units for values are degrees.
END_SET_LONGITUDE_MINUTES
VARCHAR2 		End set longitude minutes, in minutes. Units for values are minutes.
END_SET_LONGITUDE_DIRECTION
VARCHAR2 		Not entered during data entry; derived value using END_SET_OCTANT.
END_SET_LONGITUDE_DD
NUMBER 		Computed 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_SET_OCTANT
VARCHAR2 		End set octant.
BEGIN_HAUL_TIME
VARCHAR2 		Begin haul time.
BEGIN_HAUL_LATITUDE_DEGREES
VARCHAR2 		Begin haul latitude degrees, in degrees. Units for values are degrees.
BEGIN_HAUL_LATITUDE_MINUTES
VARCHAR2 		Begin haul latitude minutes, in minutes. Units for values are minutes.
BEGIN_HAUL_LATITUDE_DIRECTION
VARCHAR2 		Not entered during data entry; derived value using BEGIN_HAUL_OCTANT.
BEGIN_HAUL_LATITUDE_DD
NUMBER 		Computed 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.
BEGIN_HAUL_LONGITUDE_DEGREES
VARCHAR2 		Begin haul longitude degrees, in degrees. Units for values are degrees.
BEGIN_HAUL_LONGITUDE_MINUTES
VARCHAR2 		Begin haul longitude minutes, in minutes. Units for values are minutes.
BEGIN_HAUL_LONGITUDE_DIRECTION
VARCHAR2 		Not entered during data entry; derived value using BEGIN_HAUL_OCTANT.
BEGIN_HAUL_LONGITUDE_DD
NUMBER 		Computed 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.
BEGIN_HAUL_OCTANT
VARCHAR2 		Begin haul octant.
END_HAUL_TIME
VARCHAR2 		End haul time.
END_HAUL_LATITUDE_DEGREES
VARCHAR2 		End haul latitude degrees, in degrees. Units for values are degrees.
END_HAUL_LATITUDE_MINUTES
VARCHAR2 		End haul latitude minutes, in minutes. Units for values are minutes.
END_HAUL_LATITUDE_DIRECTION
VARCHAR2 		Not entered during data entry; derived value using END_HAUL_OCTANT.
END_HAUL_LATITUDE_DD
NUMBER 		Computed 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_HAUL_LONGITUDE_DEGREES
VARCHAR2 		End haul longitude degrees, in degrees. Units for values are degrees.
END_HAUL_LONGITUDE_MINUTES
VARCHAR2 		End haul longitude minutes, in minutes. Units for values are minutes.
END_HAUL_LONGITUDE_DIRECTION
VARCHAR2 		Not entered during data entry; derived value using END_HAUL_OCTANT.
END_HAUL_LONGITUDE_DD
NUMBER 		Computed 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_HAUL_OCTANT
VARCHAR2 		End haul octant.
FISH_NUMBER
VARCHAR2 		A consecutive number for each fish recorded on the data collection form.
SPECIES_CODE
VARCHAR2 		Five-digit CZM species code.
LENGTH
VARCHAR2 		Length of fish, in tenths of a centimeter. During data entry the decimail point was omitted; it has been inserted into the data. Units for values are centimeters. Measures are reported with a precision of 1.
WEIGHT
VARCHAR2 		Weight of fish, in tenths 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 1.
CONDITION_CODE
VARCHAR2 		Code for the condition of the fish.
SEX_CODE
VARCHAR2 		Code for the sex of the fish.
FISH_RELEASED_CODE
VARCHAR2 		Code whether the fish was released.
BIOLOGICAL_SAMPLE_CODE
VARCHAR2 		Code whether a biological sample was collected.
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.
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: RP037AA1_V
Short Name: RP037AA1_V
Status: Completed
Abstract:

Longline fishing morphometric log data collected during the 1981 cruise of the Hokusei Maru.

Entity Information

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

Longline morphometric data collected during the 1981 cruise of the Hokusei Maru.

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
 STATION_NUMBER VARCHAR2 Station number of the longline operation.
100
 YEAR VARCHAR2 Year of the longline operation.
100
 MONTH VARCHAR2 Month of the longline operation.
100
 DAY VARCHAR2 Day of the longline operation.
100
 TIME_ZONE_CODE VARCHAR2 Code for the time zone of the longline operation.
100
 NUMBER_BASKETS VARCHAR2 Number of baskets set.
100
 TOTAL_NUMBER_HOOKS VARCHAR2 Total number of hooks retrieved.
100
 BAIT_CODE VARCHAR2 Code for the bait used.
100
 DIRECTION_SET VARCHAR2 Direction of set, in degrees. Units for values are degrees.
100
 BEGIN_SET_TIME VARCHAR2 Begin set time.
100
 BEGIN_SET_LATITUDE_DEGREES VARCHAR2 Begin set latitude degrees, in degrees. Units for values are degrees.
100
 BEGIN_SET_LATITUDE_MINUTES VARCHAR2 Begin set latitude minutes, in minutes. Units for values are minutes.
100
 BEGIN_SET_LATITUDE_DIRECTION VARCHAR2 Not entered during data entry; derived value using BEGIN_SET_OCTANT.
100
 BEGIN_SET_LATITUDE_DD NUMBER Computed 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
 BEGIN_SET_LONGITUDE_DEGREES VARCHAR2 Begin set longitude degrees, in degrees. Units for values are degrees.
100
 BEGIN_SET_LONGITUDE_MINUTES VARCHAR2 Begin set longitude minutes, in minutes. Units for values are minutes.
100
 BEGIN_SET_LONGITUDE_DIRECTION VARCHAR2 Not entered during data entry; derived value using BEGIN_SET_OCTANT.
100
 BEGIN_SET_LONGITUDE_DD NUMBER Computed 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
 BEGIN_SET_OCTANT VARCHAR2 Begin set octant.
100
 END_SET_TIME VARCHAR2 End set time.
100
 END_SET_LATITUDE_DEGREES VARCHAR2 End set latitude degrees, in degrees. Units for values are degrees.
100
 END_SET_LATITUDE_MINUTES VARCHAR2 End set latitude minutes, in minutes. Units for values are minutes.
100
 END_SET_LATITUDE_DIRECTION VARCHAR2 Not entered during data entry; derived value using END_SET_OCTANT.
100
 END_SET_LATITUDE_DD NUMBER Computed 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_SET_LONGITUDE_DEGREES VARCHAR2 End set longitude degrees, in degrees. Units for values are degrees.
100
 END_SET_LONGITUDE_MINUTES VARCHAR2 End set longitude minutes, in minutes. Units for values are minutes.
100
 END_SET_LONGITUDE_DIRECTION VARCHAR2 Not entered during data entry; derived value using END_SET_OCTANT.
100
 END_SET_LONGITUDE_DD NUMBER Computed 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_SET_OCTANT VARCHAR2 End set octant.
100
 BEGIN_HAUL_TIME VARCHAR2 Begin haul time.
100
 BEGIN_HAUL_LATITUDE_DEGREES VARCHAR2 Begin haul latitude degrees, in degrees. Units for values are degrees.
100
 BEGIN_HAUL_LATITUDE_MINUTES VARCHAR2 Begin haul latitude minutes, in minutes. Units for values are minutes.
100
 BEGIN_HAUL_LATITUDE_DIRECTION VARCHAR2 Not entered during data entry; derived value using BEGIN_HAUL_OCTANT.
100
 BEGIN_HAUL_LATITUDE_DD NUMBER Computed 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
 BEGIN_HAUL_LONGITUDE_DEGREES VARCHAR2 Begin haul longitude degrees, in degrees. Units for values are degrees.
100
 BEGIN_HAUL_LONGITUDE_MINUTES VARCHAR2 Begin haul longitude minutes, in minutes. Units for values are minutes.
100
 BEGIN_HAUL_LONGITUDE_DIRECTION VARCHAR2 Not entered during data entry; derived value using BEGIN_HAUL_OCTANT.
100
 BEGIN_HAUL_LONGITUDE_DD NUMBER Computed 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
 BEGIN_HAUL_OCTANT VARCHAR2 Begin haul octant.
100
 END_HAUL_TIME VARCHAR2 End haul time.
100
 END_HAUL_LATITUDE_DEGREES VARCHAR2 End haul latitude degrees, in degrees. Units for values are degrees.
100
 END_HAUL_LATITUDE_MINUTES VARCHAR2 End haul latitude minutes, in minutes. Units for values are minutes.
100
 END_HAUL_LATITUDE_DIRECTION VARCHAR2 Not entered during data entry; derived value using END_HAUL_OCTANT.
100
 END_HAUL_LATITUDE_DD NUMBER Computed 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_HAUL_LONGITUDE_DEGREES VARCHAR2 End haul longitude degrees, in degrees. Units for values are degrees.
100
 END_HAUL_LONGITUDE_MINUTES VARCHAR2 End haul longitude minutes, in minutes. Units for values are minutes.
100
 END_HAUL_LONGITUDE_DIRECTION VARCHAR2 Not entered during data entry; derived value using END_HAUL_OCTANT.
100
 END_HAUL_LONGITUDE_DD NUMBER Computed 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_HAUL_OCTANT VARCHAR2 End haul octant.
100
 FISH_NUMBER VARCHAR2 A consecutive number for each fish recorded on the data collection form.
100
 SPECIES_CODE VARCHAR2 Five-digit CZM species code.
100
 LENGTH VARCHAR2 Length of fish, in tenths of a centimeter. During data entry the decimail point was omitted; it has been inserted into the data. Units for values are centimeters. Measures are reported with a precision of 1.
100
 WEIGHT VARCHAR2 Weight of fish, in tenths 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 1.
100
 CONDITION_CODE VARCHAR2 Code for the condition of the fish.
100
 SEX_CODE VARCHAR2 Code for the sex of the fish.
100
 FISH_RELEASED_CODE VARCHAR2 Code whether the fish was released.
100
 BIOLOGICAL_SAMPLE_CODE VARCHAR2 Code whether a biological sample was collected.
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.
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: 1064653
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: 1064654
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: 1064655
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: 995 = HOKUSEI MARU

STATION_NUMBER

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

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

YEAR

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

Year of the longline operation.
General Data Type: VARCHAR2

MONTH

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

Month of the longline operation.
General Data Type: VARCHAR2

DAY

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

Day of the longline operation.
General Data Type: VARCHAR2

TIME_ZONE_CODE

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

Code for the time zone of the longline operation.
General Data Type: VARCHAR2
Allowed Values: X = + 11

NUMBER_BASKETS

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

Number of baskets set.
General Data Type: VARCHAR2

TOTAL_NUMBER_HOOKS

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

Total number of hooks retrieved.
General Data Type: VARCHAR2

BAIT_CODE

CC ID: 1064663
Seq. Order: 11
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: 10 = SAURY (SCOMBERESOCIDAE)

DIRECTION_SET

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

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

BEGIN_SET_TIME

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

Begin set time.
General Data Type: VARCHAR2

BEGIN_SET_LATITUDE_DEGREES

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

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

BEGIN_SET_LATITUDE_MINUTES

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

Begin set latitude minutes, in minutes. Units for values are minutes.
General Data Type: VARCHAR2
Unit of Measure: minutes

BEGIN_SET_LATITUDE_DIRECTION

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

Not entered during data entry; derived value using BEGIN_SET_OCTANT.
General Data Type: VARCHAR2
Allowed Values: N = NORTH

BEGIN_SET_LATITUDE_DD

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

Computed 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

BEGIN_SET_LONGITUDE_DEGREES

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

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

BEGIN_SET_LONGITUDE_MINUTES

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

Begin set longitude minutes, in minutes. Units for values are minutes.
General Data Type: VARCHAR2
Unit of Measure: minutes

BEGIN_SET_LONGITUDE_DIRECTION

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

Not entered during data entry; derived value using BEGIN_SET_OCTANT.
General Data Type: VARCHAR2
Allowed Values: W = WEST

BEGIN_SET_LONGITUDE_DD

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

Computed 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

BEGIN_SET_OCTANT

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

Begin set octant.
General Data Type: VARCHAR2
Allowed Values: 1 = NORTH LATITUDE; 90° WEST - 179° 59’ WEST LONGITUDE

END_SET_TIME

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

End set time.
General Data Type: VARCHAR2

END_SET_LATITUDE_DEGREES

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

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

END_SET_LATITUDE_MINUTES

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

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

END_SET_LATITUDE_DIRECTION

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

Not entered during data entry; derived value using END_SET_OCTANT.
General Data Type: VARCHAR2
Allowed Values: N = NORTH

END_SET_LATITUDE_DD

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

Computed 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_SET_LONGITUDE_DEGREES

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

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

END_SET_LONGITUDE_MINUTES

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

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

END_SET_LONGITUDE_DIRECTION

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

Not entered during data entry; derived value using END_SET_OCTANT.
General Data Type: VARCHAR2
Allowed Values: W = WEST

END_SET_LONGITUDE_DD

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

Computed 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_SET_OCTANT

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

End set octant.
General Data Type: VARCHAR2
Allowed Values: 1 = NORTH LATITUDE; 90° WEST - 179° 59’ WEST LONGITUDE

BEGIN_HAUL_TIME

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

Begin haul time.
General Data Type: VARCHAR2

BEGIN_HAUL_LATITUDE_DEGREES

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

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

BEGIN_HAUL_LATITUDE_MINUTES

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

Begin haul latitude minutes, in minutes. Units for values are minutes.
General Data Type: VARCHAR2
Unit of Measure: minutes

BEGIN_HAUL_LATITUDE_DIRECTION

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

Not entered during data entry; derived value using BEGIN_HAUL_OCTANT.
General Data Type: VARCHAR2
Allowed Values: N = NORTH

BEGIN_HAUL_LATITUDE_DD

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

Computed 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

BEGIN_HAUL_LONGITUDE_DEGREES

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

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

BEGIN_HAUL_LONGITUDE_MINUTES

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

Begin haul longitude minutes, in minutes. Units for values are minutes.
General Data Type: VARCHAR2
Unit of Measure: minutes

BEGIN_HAUL_LONGITUDE_DIRECTION

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

Not entered during data entry; derived value using BEGIN_HAUL_OCTANT.
General Data Type: VARCHAR2

BEGIN_HAUL_LONGITUDE_DD

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

Computed 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

BEGIN_HAUL_OCTANT

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

Begin haul octant.
General Data Type: VARCHAR2
Allowed Values: 1 = NORTH LATITUDE; 90° WEST - 179° 59’ WEST LONGITUDE

END_HAUL_TIME

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

End haul time.
General Data Type: VARCHAR2

END_HAUL_LATITUDE_DEGREES

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

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

END_HAUL_LATITUDE_MINUTES

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

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

END_HAUL_LATITUDE_DIRECTION

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

Not entered during data entry; derived value using END_HAUL_OCTANT.
General Data Type: VARCHAR2
Allowed Values: N = NORTH

END_HAUL_LATITUDE_DD

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

Computed 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_HAUL_LONGITUDE_DEGREES

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

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

END_HAUL_LONGITUDE_MINUTES

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

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

END_HAUL_LONGITUDE_DIRECTION

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

Not entered during data entry; derived value using END_HAUL_OCTANT.
General Data Type: VARCHAR2
Allowed Values: W = WEST

END_HAUL_LONGITUDE_DD

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

Computed 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_HAUL_OCTANT

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

End haul octant.
General Data Type: VARCHAR2
Allowed Values: 1 = NORTH LATITUDE; 90° WEST - 179° 59’ WEST LONGITUDE

FISH_NUMBER

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

A consecutive number for each fish recorded on the data collection form.
General Data Type: VARCHAR2

SPECIES_CODE

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

Five-digit CZM species code.
General Data Type: VARCHAR2
Allowed Values: 10110 = ALEPISAURUS SP.; 11611 = TARACTICHTHYS STEINDACHNERI(T.LONGIPINNIS,T.STEINDACHNERI); 11631 = EUMEGISTUS ILLUSTRIS; 14821 = LEPIDOCYBIUM FLAVOBRUNNEUM; 16047 = TETRAPTERUS ANGUSTIROSTRIS; 16051 = TETRAPTERUS AUDAX; 16501 = LAMPRIS REGIUS; 20332 = KATSUWONUS PELAMIS; 20334 = THUNNUS OBESUS; 20335 = THUNNUS ALBACARES; 20336 = THUNNUS ALALUNGA; 20344 = ACANTHOCYBIUM SOLANDRI; 22052 = XIPHIAS GLADIUS

LENGTH

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

Length of fish, in tenths of a centimeter. During data entry the decimail point was omitted; it has been inserted into the data. Units for values are centimeters. Measures are reported with a precision of 1.
General Data Type: VARCHAR2
Unit of Measure: centimeters
Format Mask: 5

WEIGHT

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

Weight of fish, in tenths 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 1.
General Data Type: VARCHAR2
Unit of Measure: kilograms
Format Mask: 4

CONDITION_CODE

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

Code for the condition of the fish.
General Data Type: VARCHAR2
Allowed Values: 1 = A (ALIVE); 2 = D (DEAD); 3 = SE (SHARK EATEN)

SEX_CODE

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

Code for the sex of the fish.
General Data Type: VARCHAR2
Allowed Values: F = FEMALE; M = MALE

FISH_RELEASED_CODE

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

Code whether the fish was released.
General Data Type: VARCHAR2
Allowed Values: 1 = YES, FISH RELEASED

BIOLOGICAL_SAMPLE_CODE

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

Code whether a biological sample was collected.
General Data Type: VARCHAR2
Allowed Values: 1 = YES, BIOLOGICAL SAMPLE KEPT

JOB_NUMBER

CC ID: 1064713
Seq. Order: 61
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.
General Data Type: VARCHAR2

SEQUENCE_NUMBER

CC ID: 1064714
Seq. Order: 62
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: 1064715
Seq. Order: 63
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: 64588
GUID: gov.noaa.nmfs.inport:64588
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2021-04-30 21:49+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-05-07
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-07
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-07