Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

This table contains much the same information as NORPAC.FOREIGN_HAUL but only for non-joint venture motherships. It contains only the fields that are pertinent to motherships. It contains an additional field, CATCHER_BOAT_GEAR, which is used to subdivide daily mothership data by gear type code. The NORPAC.FOREIGN_CATCHER_BOAT_GEAR table provides a description of the codes.

Description

This table contains much the same information as NORPAC.FOREIGN_HAUL but only for non-joint venture motherships. It contains only the fields that are pertinent to motherships. It contains an additional field, CATCHER_BOAT_GEAR, which is used to subdivide daily mothership data by gear type code. The NORPAC.FOREIGN_CATCHER_BOAT_GEAR table provides a description of the codes.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
CRUISE
NUMBER
A unique four-digit number assigned to the observer for the length of their contract period. This number alone identifies and groups a set of observer information.
VESSEL
VARCHAR2
A unique, four-digit, alpha-numeric code identifying each vessel that contracts for observer coverage. All vessel codes begin with the alpha code B, followed by a three-digit number.
DT
DATE
Similar to NORPAC.DOMESTIC_HAUL.HAUL_DATE, this is the date in Greenwich Mean Time. Format is stored in the database as DD-MON-YY format (i.e., 15-MAR-86), and displayed as MM/DD/YYYY HH:MI:SS (i.e., 3/15/86 00:00:00).
HAUL
NUMBER
A unique number which identifies a specific occurrence of net, pot, or longline fishing effort. This table does not include "no fishing" days.
CATCHER_BOAT_GEAR
NUMBER
A one-digit numeric code to identify the gear used by the catcher boat(s) delivering to a mothership.
LOCATION_ID
VARCHAR2
A one-digit alpha code that indicates what type of fishing activity occurred at the latitude and longitude recorded. R = the position of the vessel when the retrieval of the haul/set was begun, D = the position of the vessel when a delivery was completed to a mothership, N = the position of the vessel at noon (Greenwich Mean Time) on a day when no fishing took place and the vessel was not in port, S = the position of the vessel when gear began being set.
LATITUDE
NUMBER
A four-digit number recorded in degrees and minutes north. The geographical position associated with the LOCATION_ID.
E_W
VARCHAR2
Direction of longitude, E = east and W = west of the 180th meridian.
LONGITUDE
NUMBER
Five-digit longitude in degrees and minutes. A five-digit number recorded in degrees and minutes west of 0 degrees. Any position west of 180 degrees is stored as a value greater than 18000, e.g., 170 degrees east longitude = 19000. The geographical position associated with the LOCATION_ID.
FISHING_DEPTH
NUMBER
The average fishing depth at which fishing took place, in meters.
DURATION
NUMBER
Average duration (minutes) of the tows delivered.
NUMBER_OF_TOWS
NUMBER
Number of tows delivered during that day. Is null where individual hauls are identified separately.
OFFICIAL_TOTAL_CATCH
NUMBER
Final estimate of catch weight (MT) for the set or haul, made by vessel personnel, includes both retained and discarded species, and is recorded to the nearest one-hundredth of a metric ton. If original_ships_estimate is not null, official_total_catch is the original_ships_estimate adjusted by the observer to include prohibited species and non-allocated species. If NUMBER_OF_TOWS>0, then OFFICIAL_TOTAL_CATCH is the total catch for the day.
WEATHER
NUMBER
A one-digit numeric code identifying the weather conditions during the fishing operation. NORPAC.FOREIGN_WEATHER provides a description of the codes.
SEA
NUMBER
A one-digit numeric code identifying the sea conditions during the fishing operation. NORPAC.FOREIGN_SEA provides a description of the codes.
SURFACE_WATER_TEMP
NUMBER
The temperature of the surface water in degrees Celsius.
BOTTOM_WATER_TEMP
NUMBER
The temperature of the water at fishing depth in degrees Celsius.
FILENAME
VARCHAR2
The original filename on the Burroughs computer system from which this data record came.
YEAR
NUMBER
A four-digit number identifying the year in which the gear retrieval of the haul began.
HAUL_JOIN
NUMBER
An assigned, unique number (up to 6 digits) used to link records in this table back to a single haul record in the NORPAC.FOREIGN_HAUL table.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

Item Identification

Title: Table: FOREIGN_DETAIL_MOTHERSHIP
Short Name: FOREIGN_DETAIL_MOTHERSHIP
Status: Completed
Abstract:

This table contains much the same information as NORPAC.FOREIGN_HAUL but only for non-joint venture motherships. It contains only the fields that are pertinent to motherships. It contains an additional field, CATCHER_BOAT_GEAR, which is used to subdivide daily mothership data by gear type code. The NORPAC.FOREIGN_CATCHER_BOAT_GEAR table provides a description of the codes.

Notes:

Loaded by batch 2364, 06-29-2009 18:15

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: NORPAC
Description:

This table contains much the same information as NORPAC.FOREIGN_HAUL but only for non-joint venture motherships. It contains only the fields that are pertinent to motherships. It contains an additional field, CATCHER_BOAT_GEAR, which is used to subdivide daily mothership data by gear type code. The NORPAC.FOREIGN_CATCHER_BOAT_GEAR table provides a description of the codes.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
CRUISE NUMBER A unique four-digit number assigned to the observer for the length of their contract period. This number alone identifies and groups a set of observer information.
100
VESSEL VARCHAR2 A unique, four-digit, alpha-numeric code identifying each vessel that contracts for observer coverage. All vessel codes begin with the alpha code B, followed by a three-digit number.
100
DT DATE Similar to NORPAC.DOMESTIC_HAUL.HAUL_DATE, this is the date in Greenwich Mean Time. Format is stored in the database as DD-MON-YY format (i.e., 15-MAR-86), and displayed as MM/DD/YYYY HH:MI:SS (i.e., 3/15/86 00:00:00).
100
HAUL NUMBER A unique number which identifies a specific occurrence of net, pot, or longline fishing effort. This table does not include "no fishing" days.
100
Primary Key CATCHER_BOAT_GEAR NUMBER A one-digit numeric code to identify the gear used by the catcher boat(s) delivering to a mothership.
100
LOCATION_ID VARCHAR2 A one-digit alpha code that indicates what type of fishing activity occurred at the latitude and longitude recorded. R = the position of the vessel when the retrieval of the haul/set was begun, D = the position of the vessel when a delivery was completed to a mothership, N = the position of the vessel at noon (Greenwich Mean Time) on a day when no fishing took place and the vessel was not in port, S = the position of the vessel when gear began being set.
100
LATITUDE NUMBER A four-digit number recorded in degrees and minutes north. The geographical position associated with the LOCATION_ID.
100
E_W VARCHAR2 Direction of longitude, E = east and W = west of the 180th meridian.
100
LONGITUDE NUMBER Five-digit longitude in degrees and minutes. A five-digit number recorded in degrees and minutes west of 0 degrees. Any position west of 180 degrees is stored as a value greater than 18000, e.g., 170 degrees east longitude = 19000. The geographical position associated with the LOCATION_ID.
100
FISHING_DEPTH NUMBER The average fishing depth at which fishing took place, in meters.
100
DURATION NUMBER Average duration (minutes) of the tows delivered.
100
NUMBER_OF_TOWS NUMBER Number of tows delivered during that day. Is null where individual hauls are identified separately.
100
OFFICIAL_TOTAL_CATCH NUMBER Final estimate of catch weight (MT) for the set or haul, made by vessel personnel, includes both retained and discarded species, and is recorded to the nearest one-hundredth of a metric ton. If original_ships_estimate is not null, official_total_catch is the original_ships_estimate adjusted by the observer to include prohibited species and non-allocated species. If NUMBER_OF_TOWS>0, then OFFICIAL_TOTAL_CATCH is the total catch for the day.
100
WEATHER NUMBER A one-digit numeric code identifying the weather conditions during the fishing operation. NORPAC.FOREIGN_WEATHER provides a description of the codes.
100
SEA NUMBER A one-digit numeric code identifying the sea conditions during the fishing operation. NORPAC.FOREIGN_SEA provides a description of the codes.
100
SURFACE_WATER_TEMP NUMBER The temperature of the surface water in degrees Celsius.
100
BOTTOM_WATER_TEMP NUMBER The temperature of the water at fishing depth in degrees Celsius.
100
FILENAME VARCHAR2 The original filename on the Burroughs computer system from which this data record came.
100
YEAR NUMBER A four-digit number identifying the year in which the gear retrieval of the haul began.
100
Primary Key HAUL_JOIN NUMBER An assigned, unique number (up to 6 digits) used to link records in this table back to a single haul record in the NORPAC.FOREIGN_HAUL table.

Attribute Details

CRUISE

CC ID: 37183
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

A unique four-digit number assigned to the observer for the length of their contract period. This number alone identifies and groups a set of observer information.

General Data Type: NUMBER
Foreign Key Relations:

NORPAC.FOREIGN_FISHING_OPERATI

VESSEL

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

A unique, four-digit, alpha-numeric code identifying each vessel that contracts for observer coverage. All vessel codes begin with the alpha code B, followed by a three-digit number.

General Data Type: VARCHAR2
Foreign Key Relations:

Refers to more than one entity

DT

CC ID: 37184
Seq. Order: 3
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Similar to NORPAC.DOMESTIC_HAUL.HAUL_DATE, this is the date in Greenwich Mean Time. Format is stored in the database as DD-MON-YY format (i.e., 15-MAR-86), and displayed as MM/DD/YYYY HH:MI:SS (i.e., 3/15/86 00:00:00).

General Data Type: DATE

HAUL

CC ID: 37189
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

A unique number which identifies a specific occurrence of net, pot, or longline fishing effort. This table does not include "no fishing" days.

General Data Type: NUMBER

CATCHER_BOAT_GEAR

CC ID: 37182
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 1
Scale: 0
Status: Active
Description:

A one-digit numeric code to identify the gear used by the catcher boat(s) delivering to a mothership.

General Data Type: NUMBER
Foreign Key Relations:

NORPAC.FOREIGN_CATCHER_BOAT_GE

LOCATION_ID

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

A one-digit alpha code that indicates what type of fishing activity occurred at the latitude and longitude recorded. R = the position of the vessel when the retrieval of the haul/set was begun, D = the position of the vessel when a delivery was completed to a mothership, N = the position of the vessel at noon (Greenwich Mean Time) on a day when no fishing took place and the vessel was not in port, S = the position of the vessel when gear began being set.

General Data Type: VARCHAR2

LATITUDE

CC ID: 37191
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

A four-digit number recorded in degrees and minutes north. The geographical position associated with the LOCATION_ID.

General Data Type: NUMBER

E_W

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

Direction of longitude, E = east and W = west of the 180th meridian.

General Data Type: VARCHAR2

LONGITUDE

CC ID: 37193
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Five-digit longitude in degrees and minutes. A five-digit number recorded in degrees and minutes west of 0 degrees. Any position west of 180 degrees is stored as a value greater than 18000, e.g., 170 degrees east longitude = 19000. The geographical position associated with the LOCATION_ID.

General Data Type: NUMBER

FISHING_DEPTH

CC ID: 37188
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

The average fishing depth at which fishing took place, in meters.

General Data Type: NUMBER

DURATION

CC ID: 37185
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Average duration (minutes) of the tows delivered.

General Data Type: NUMBER

NUMBER_OF_TOWS

CC ID: 37194
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Number of tows delivered during that day. Is null where individual hauls are identified separately.

General Data Type: NUMBER

OFFICIAL_TOTAL_CATCH

CC ID: 37195
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

Final estimate of catch weight (MT) for the set or haul, made by vessel personnel, includes both retained and discarded species, and is recorded to the nearest one-hundredth of a metric ton. If original_ships_estimate is not null, official_total_catch is the original_ships_estimate adjusted by the observer to include prohibited species and non-allocated species. If NUMBER_OF_TOWS>0, then OFFICIAL_TOTAL_CATCH is the total catch for the day.

General Data Type: NUMBER

WEATHER

CC ID: 37199
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

A one-digit numeric code identifying the weather conditions during the fishing operation. NORPAC.FOREIGN_WEATHER provides a description of the codes.

General Data Type: NUMBER
Foreign Key Relations:

NORPAC.FOREIGN_WEATHER

SEA

CC ID: 37196
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

A one-digit numeric code identifying the sea conditions during the fishing operation. NORPAC.FOREIGN_SEA provides a description of the codes.

General Data Type: NUMBER
Foreign Key Relations:

NORPAC.FOREIGN_SEA

SURFACE_WATER_TEMP

CC ID: 37197
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 1
Status: Active
Description:

The temperature of the surface water in degrees Celsius.

General Data Type: NUMBER

BOTTOM_WATER_TEMP

CC ID: 37181
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 1
Status: Active
Description:

The temperature of the water at fishing depth in degrees Celsius.

General Data Type: NUMBER

FILENAME

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

The original filename on the Burroughs computer system from which this data record came.

General Data Type: VARCHAR2

YEAR

CC ID: 37200
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

A four-digit number identifying the year in which the gear retrieval of the haul began.

General Data Type: NUMBER

HAUL_JOIN

CC ID: 37190
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 6
Scale: 0
Status: Active
Description:

An assigned, unique number (up to 6 digits) used to link records in this table back to a single haul record in the NORPAC.FOREIGN_HAUL table.

General Data Type: NUMBER
Foreign Key Relations:

NORPAC.FOREIGN_HAUL

Catalog Details

Catalog Item ID: 9566
GUID: gov.noaa.nmfs.inport:9566
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2009-06-29 18:15+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-05-18
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-05-18
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-05-18