Maintenance Notice: Tuesday May 21 @ 12pm-1:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.3.6. Downtime Schedule Tuesday, May 21, 2024 12:00pm - 1:30pm Eastern / 9:00am - 10:30am Pacific / 6:00am - 8:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: h...
View All
Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

This table contains species composition sampling data from catch made in the foreign and joint venture groundfish fishery.

Description

This table contains species composition sampling data from catch made in the foreign and joint venture groundfish fishery.

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 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_SPCOMP.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
Code used by the NMFS Observer Program to identify an organism or material. This code is associated with species name in the domestic_species table (using the column name species_no in place of species).
SEX
VARCHAR2
A one-digit alpha code indicating the sex of the organism. F = female, M = male, U = unknown.
WEIGHT_SAMPLED
NUMBER
The total weight in kilograms of all of the sampled species in the sample.
NUMBER_IN_SAMPLE
NUMBER
The number (count) of the specified species which occurred within the sample.
WEIGHT_IN_SAMPLE
NUMBER
The total weight in kilograms of the specified species which occurred within the sample.
NUMBER_OF_POTS_SAMPLED
NUMBER
The number of pots in the set that were sampled for species composition.
NUMBER_OF_SKATES_SAMPLED
NUMBER
The number of (hachi) skates that were sampled for species composition.
SPECIES_HAUL_NUMBER
NUMBER
The estimated number of the specified species in the entire haul extrapolated from the sample.
SPECIES_HAUL_WEIGHT
NUMBER
The estimated weight in kilograms of the specified species in the entire haul extrapolated from the sample.
EXTRAPOLATION_TYPE
NUMBER
A one-digit code associated with the procedure used to extrapolate the NUMBER_IN_SAMPLE and WEIGHT_IN_SAMPLE to SPECIES_HAUL_NUMBER and SPECIES_HAUL_WEIGHT. NORPAC.FOREIGN_EXTRAPOLATION provides a description of the codes.
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_SPCOMP
Short Name: FOREIGN_SPCOMP
Status: Completed
Abstract:

This table contains species composition sampling data from catch made in the foreign and joint venture groundfish fishery.

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 species composition sampling data from catch made in the foreign and joint venture groundfish fishery.

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 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_SPCOMP.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
Primary Key SPECIES NUMBER Code used by the NMFS Observer Program to identify an organism or material. This code is associated with species name in the domestic_species table (using the column name species_no in place of species).
100
Primary Key SEX VARCHAR2 A one-digit alpha code indicating the sex of the organism. F = female, M = male, U = unknown.
100
WEIGHT_SAMPLED NUMBER The total weight in kilograms of all of the sampled species in the sample.
100
NUMBER_IN_SAMPLE NUMBER The number (count) of the specified species which occurred within the sample.
100
WEIGHT_IN_SAMPLE NUMBER The total weight in kilograms of the specified species which occurred within the sample.
100
NUMBER_OF_POTS_SAMPLED NUMBER The number of pots in the set that were sampled for species composition.
100
NUMBER_OF_SKATES_SAMPLED NUMBER The number of (hachi) skates that were sampled for species composition.
100
SPECIES_HAUL_NUMBER NUMBER The estimated number of the specified species in the entire haul extrapolated from the sample.
100
SPECIES_HAUL_WEIGHT NUMBER The estimated weight in kilograms of the specified species in the entire haul extrapolated from the sample.
100
EXTRAPOLATION_TYPE NUMBER A one-digit code associated with the procedure used to extrapolate the NUMBER_IN_SAMPLE and WEIGHT_IN_SAMPLE to SPECIES_HAUL_NUMBER and SPECIES_HAUL_WEIGHT. NORPAC.FOREIGN_EXTRAPOLATION provides a description of the codes.
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: 37453
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: 37465
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: 37454
Seq. Order: 3
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Similar to NORPAC.DOMESTIC_SPCOMP.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: 37468
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: 37456
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: 37462
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 3
Scale: 0
Status: Active
Description:

Code used by the NMFS Observer Program to identify an organism or material. This code is associated with species name in the domestic_species table (using the column name species_no in place of species).

General Data Type: NUMBER
Foreign Key Relations:

NORPAC.DOMESTIC_SPECIES

SEX

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

A one-digit alpha code indicating the sex of the organism. F = female, M = male, U = unknown.

General Data Type: VARCHAR2

WEIGHT_SAMPLED

CC ID: 37467
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 10
Scale: 2
Status: Active
Description:

The total weight in kilograms of all of the sampled species in the sample.

General Data Type: NUMBER

NUMBER_IN_SAMPLE

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

The number (count) of the specified species which occurred within the sample.

General Data Type: NUMBER

WEIGHT_IN_SAMPLE

CC ID: 37466
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 10
Scale: 2
Status: Active
Description:

The total weight in kilograms of the specified species which occurred within the sample.

General Data Type: NUMBER

NUMBER_OF_POTS_SAMPLED

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

The number of pots in the set that were sampled for species composition.

General Data Type: NUMBER

NUMBER_OF_SKATES_SAMPLED

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

The number of (hachi) skates that were sampled for species composition.

General Data Type: NUMBER

SPECIES_HAUL_NUMBER

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

The estimated number of the specified species in the entire haul extrapolated from the sample.

General Data Type: NUMBER

SPECIES_HAUL_WEIGHT

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

The estimated weight in kilograms of the specified species in the entire haul extrapolated from the sample.

General Data Type: NUMBER

EXTRAPOLATION_TYPE

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

A one-digit code associated with the procedure used to extrapolate the NUMBER_IN_SAMPLE and WEIGHT_IN_SAMPLE to SPECIES_HAUL_NUMBER and SPECIES_HAUL_WEIGHT. NORPAC.FOREIGN_EXTRAPOLATION provides a description of the codes.

General Data Type: NUMBER
Foreign Key Relations:

NORPAC.FOREIGN_EXTRAPOLATION

HAUL_JOIN

CC ID: 37457
Seq. Order: 16
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: 9590
GUID: gov.noaa.nmfs.inport:9590
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