Metadata Rubric

100%

6 / 6

Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Foreign Fishing Observer Data Dictionary > AFSC/FMA/North Pacific Observer Foreign Fishing >

Table: FOREIGN_DETAIL_MOTHERSHIP

Entity (ENT) | Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:9566 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

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

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.

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.

No Child Items for this record.

No contact information is available for this record.

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

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 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.

Attribute Summary

	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	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	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.

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

DATE

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

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

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

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

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

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

Table: FOREIGN_DETAIL_MOTHERSHIP

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

CRUISE

VESSEL

DT

HAUL

CATCHER_BOAT_GEAR

LOCATION_ID

LATITUDE

E_W

LONGITUDE

FISHING_DEPTH

DURATION

NUMBER_OF_TOWS

OFFICIAL_TOTAL_CATCH

WEATHER

SEA

SURFACE_WATER_TEMP

BOTTOM_WATER_TEMP

FILENAME

YEAR

HAUL_JOIN

Catalog Details