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_SPAWN

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

This table provides information on the percentage of pollock spawners encountered for selected cruises in 1984-88.

Description

This table provides information on the percentage of pollock spawners encountered for selected cruises in 1984-88.

Entity Type
Data Table

Data Attribute / Type	Description
CRUISE NUMBER	A unique four-digit number to represent each occasion that an observer was aboard a different fishing vessel during deployment. Cruise number is associated with all of the data collected by the observer aboard the vessel.
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).
YEAR NUMBER	A four-digit number identifying the year in which the gear retrieval of the haul began.
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.
SPECIES NUMBER	A three-digit numeric code representing a marine species. This code is associated with species name in NORPAC.DOMESTIC_SPECIES (using the column name SPECIES_NO in place of SPECIES).
LENGTH_TAKEN VARCHAR2	A one-digit numeric code. 1 - Yes, lengths were taken. 2 - No, lengths were not taken. (Other responses in this field are 3, 4, and null. The meaning of these responses are unknown and are likely erroneous.)
PERCENT_SPAWN_FEMALES NUMBER	The percentage of female pollock observed that were spawners.
AGE_STRUCTURE_TAKEN VARCHAR2	A one-digit numeric code. 1 - Yes, age structures were taken. 2 - No, age structures were not taken. (The other response in this field was a null value. Likely, the observer neglected to fill in this field.)
FEEDING_OBSERVED VARCHAR2	A one-digit numeric code. 1 - Yes, feeding was observed. 2 - No, feeding was not observed. (The other responses are 3 and null. The meaning of these responses are unknown and are likely erroneous.)
FILENAME VARCHAR2	The original filename on the Burroughs computer system from which this data record came.
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 to represent each occasion that an observer was aboard a different fishing vessel during deployment. Cruise number is associated with all of the data collected by the observer aboard the vessel.

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

YEAR
NUMBER

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

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.

SPECIES
NUMBER

A three-digit numeric code representing a marine species. This code is associated with species name in NORPAC.DOMESTIC_SPECIES (using the column name SPECIES_NO in place of SPECIES).

LENGTH_TAKEN
VARCHAR2

A one-digit numeric code. 1 - Yes, lengths were taken. 2 - No, lengths were not taken. (Other responses in this field are 3, 4, and null. The meaning of these responses are unknown and are likely erroneous.)

PERCENT_SPAWN_FEMALES
NUMBER

The percentage of female pollock observed that were spawners.

AGE_STRUCTURE_TAKEN
VARCHAR2

A one-digit numeric code. 1 - Yes, age structures were taken. 2 - No, age structures were not taken. (The other response in this field was a null value. Likely, the observer neglected to fill in this field.)

FEEDING_OBSERVED
VARCHAR2

A one-digit numeric code. 1 - Yes, feeding was observed. 2 - No, feeding was not observed. (The other responses are 3 and null. The meaning of these responses are unknown and are likely erroneous.)

FILENAME
VARCHAR2

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

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_SPAWN
Short Name:	FOREIGN_SPAWN
Status:	Completed
Abstract:	This table provides information on the percentage of pollock spawners encountered for selected cruises in 1984-88.
Notes:	Loaded by batch 2364, 06-29-2009 18:15

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	NORPAC
Description:	This table provides information on the percentage of pollock spawners encountered for selected cruises in 1984-88.

Attribute Summary

	Name	Type	Description
100	CRUISE	NUMBER	A unique four-digit number to represent each occasion that an observer was aboard a different fishing vessel during deployment. Cruise number is associated with all of the data collected by the observer aboard the vessel.
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	YEAR	NUMBER	A four-digit number identifying the year in which the gear retrieval of the haul began.
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	SPECIES	NUMBER	A three-digit numeric code representing a marine species. This code is associated with species name in NORPAC.DOMESTIC_SPECIES (using the column name SPECIES_NO in place of SPECIES).
100	LENGTH_TAKEN	VARCHAR2	A one-digit numeric code. 1 - Yes, lengths were taken. 2 - No, lengths were not taken. (Other responses in this field are 3, 4, and null. The meaning of these responses are unknown and are likely erroneous.)
100	PERCENT_SPAWN_FEMALES	NUMBER	The percentage of female pollock observed that were spawners.
100	AGE_STRUCTURE_TAKEN	VARCHAR2	A one-digit numeric code. 1 - Yes, age structures were taken. 2 - No, age structures were not taken. (The other response in this field was a null value. Likely, the observer neglected to fill in this field.)
100	FEEDING_OBSERVED	VARCHAR2	A one-digit numeric code. 1 - Yes, feeding was observed. 2 - No, feeding was not observed. (The other responses are 3 and null. The meaning of these responses are unknown and are likely erroneous.)
100	FILENAME	VARCHAR2	The original filename on the Burroughs computer system from which this data record came.
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

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

YEAR

NUMBER

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

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

SPECIES

NUMBER

A three-digit numeric code representing a marine species. This code is associated with species name in NORPAC.DOMESTIC_SPECIES (using the column name SPECIES_NO in place of SPECIES).

100

LENGTH_TAKEN

VARCHAR2

100

PERCENT_SPAWN_FEMALES

NUMBER

The percentage of female pollock observed that were spawners.

100

AGE_STRUCTURE_TAKEN

VARCHAR2

100

FEEDING_OBSERVED

VARCHAR2

A one-digit numeric code. 1 - Yes, feeding was observed. 2 - No, feeding was not observed. (The other responses are 3 and null. The meaning of these responses are unknown and are likely erroneous.)

100

FILENAME

VARCHAR2

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

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

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 to represent each occasion that an observer was aboard a different fishing vessel during deployment. Cruise number is associated with all of the data collected by the observer aboard the vessel.
General Data Type:	NUMBER
Foreign Key Relations:	NORPAC.FOREIGN_FISHING_OPERATI

VESSEL

CC ID: 37451

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

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

YEAR

CC ID: 37452

Seq. Order:	4
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

CC ID: 37446

Seq. Order:	5
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

SPECIES

CC ID: 37450

Seq. Order:	6
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	Yes
Precision:	3
Scale:	0
Status:	Active
Description:	A three-digit numeric code representing a marine species. This code is associated with species name in NORPAC.DOMESTIC_SPECIES (using the column name SPECIES_NO in place of SPECIES).
General Data Type:	NUMBER
Foreign Key Relations:	NORPAC.DOMESTIC_SPECIES

LENGTH_TAKEN

CC ID: 37448

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	A one-digit numeric code. 1 - Yes, lengths were taken. 2 - No, lengths were not taken. (Other responses in this field are 3, 4, and null. The meaning of these responses are unknown and are likely erroneous.)
General Data Type:	VARCHAR2

PERCENT_SPAWN_FEMALES

CC ID: 37449

Seq. Order:	8
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	The percentage of female pollock observed that were spawners.
General Data Type:	NUMBER

AGE_STRUCTURE_TAKEN

CC ID: 37441

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	A one-digit numeric code. 1 - Yes, age structures were taken. 2 - No, age structures were not taken. (The other response in this field was a null value. Likely, the observer neglected to fill in this field.)
General Data Type:	VARCHAR2

FEEDING_OBSERVED

CC ID: 37444

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	A one-digit numeric code. 1 - Yes, feeding was observed. 2 - No, feeding was not observed. (The other responses are 3 and null. The meaning of these responses are unknown and are likely erroneous.)
General Data Type:	VARCHAR2

FILENAME

CC ID: 37445

Seq. Order:	11
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

HAUL_JOIN

CC ID: 37447

Seq. Order:	12
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:	9589
GUID:	gov.noaa.nmfs.inport:9589
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_SPAWN

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

CRUISE

VESSEL

DT

YEAR

HAUL

SPECIES

LENGTH_TAKEN

PERCENT_SPAWN_FEMALES

AGE_STRUCTURE_TAKEN

FEEDING_OBSERVED

FILENAME

HAUL_JOIN

Catalog Details