Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
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_VIABILITY

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

Summary

Abstract

This table links viability data for Pacific halibut caught in the foreign and joint venture groundfish fishery with the length data from the same cruise, vessel, dt, year, and haul. Observers use a viability key developed by the International Pacific Halibut Commission (IPHC) to judge viability.

Description

This table links viability data for Pacific halibut caught in the foreign and joint venture groundfish fishery with the length data from the same cruise, vessel, dt, year, and haul. Observers use a viability key developed by the International Pacific Halibut Commission (IPHC) to judge viability.

Entity Information

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 vessell.
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 		Species code 101, the code for Pacific halibut.
NUMBER_EXCELLENT
NUMBER 		The number of Pacific halibut examined and determined to be in excellent condition.
NUMBER_POOR
NUMBER 		The number of Pacific halibut examined and determined to be in poor condition.
NUMBER_DEAD
NUMBER 		The number of Pacific halibut examined and determined to be dead or soon to be dead.
SEA_LION_PREDATION_CODE
NUMBER 		A one-digit numeric code associated with the amount of sea lion predation. NORPAC.FOREIGN_PREDATION_CODE provides a description of the codes.
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.
PK_FVIA
NUMBER 		For internal use only.

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_VIABILITY
Short Name: FOREIGN_VIABILITY
Status: Completed
Abstract:

This table links viability data for Pacific halibut caught in the foreign and joint venture groundfish fishery with the length data from the same cruise, vessel, dt, year, and haul. Observers use a viability key developed by the International Pacific Halibut Commission (IPHC) to judge viability.
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 links viability data for Pacific halibut caught in the foreign and joint venture groundfish fishery with the length data from the same cruise, vessel, dt, year, and haul. Observers use a viability key developed by the International Pacific Halibut Commission (IPHC) to judge viability.

Data Attributes

Attribute Summary

Rubric Score Primary Key? 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 vessell.
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 Species code 101, the code for Pacific halibut.
100
 NUMBER_EXCELLENT NUMBER The number of Pacific halibut examined and determined to be in excellent condition.
100
 NUMBER_POOR NUMBER The number of Pacific halibut examined and determined to be in poor condition.
100
 NUMBER_DEAD NUMBER The number of Pacific halibut examined and determined to be dead or soon to be dead.
100
 SEA_LION_PREDATION_CODE NUMBER A one-digit numeric code associated with the amount of sea lion predation. NORPAC.FOREIGN_PREDATION_CODE provides a description of the codes.
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.
100
 Primary Key PK_FVIA NUMBER For internal use only.

Attribute Details

CRUISE

CC ID: 37480
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 vessell.
General Data Type: NUMBER
Foreign Key Relations:

NORPAC.FOREIGN_FISHING_OPERATI

VESSEL

CC ID: 37491
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: 37481
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: 37492
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: 37483
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: 37490
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Species code 101, the code for Pacific halibut.
General Data Type: NUMBER
Foreign Key Relations:

NORPAC.DOMESTIC_SPECIES

NUMBER_EXCELLENT

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

The number of Pacific halibut examined and determined to be in excellent condition.
General Data Type: NUMBER

NUMBER_POOR

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

The number of Pacific halibut examined and determined to be in poor condition.
General Data Type: NUMBER

NUMBER_DEAD

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

The number of Pacific halibut examined and determined to be dead or soon to be dead.
General Data Type: NUMBER

SEA_LION_PREDATION_CODE

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

A one-digit numeric code associated with the amount of sea lion predation. NORPAC.FOREIGN_PREDATION_CODE provides a description of the codes.
General Data Type: NUMBER
Foreign Key Relations:

NORPAC.FOREIGN_PREDATION_CODE

FILENAME

CC ID: 37482
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: 37484
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
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

PK_FVIA

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

For internal use only.
General Data Type: NUMBER

Catalog Details

Catalog Item ID: 9594
GUID: gov.noaa.nmfs.inport:9594
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