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

Summary

Abstract

This table contains the original (corrected) observer data for foreign longliners from all species of king crab (species 2), Tanner crab (species 3), Pacific halibut (species 101), and Pacific salmon (species 220 and 226) that were found in the prohibited species samples. No data have been extrapolated in this database.

Description

This table contains the original (corrected) observer data for foreign longliners from all species of king crab (species 2), Tanner crab (species 3), Pacific halibut (species 101), and Pacific salmon (species 220 and 226) that were found in the prohibited species samples. No data have been extrapolated in this database.

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.
YEAR
NUMBER
A four-digit number identifying the year in which the gear retrieval of the set began.
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.
SAMPLE_NUMBER
NUMBER
In sampling a longline set or a day's mothership operation or a day's joint venture operation, each portion of the set or delivery that was sampled received a unique sample_number within the set (usually, a 1, 2, or 3).
SPECIES
NUMBER
A three-digit numeric code representing a marine species.
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_SKATES_SAMPLED
NUMBER
The number of hachi (skates) that were sampled for prohibited species.
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_FLPS
NUMBER
Foro 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_LONGLINE_PROHIB_SAMPLE
Short Name: FOREIGN_LONGLINE_PROHIB_SAMPLE
Status: Completed
Abstract:

This table contains the original (corrected) observer data for foreign longliners from all species of king crab (species 2), Tanner crab (species 3), Pacific halibut (species 101), and Pacific salmon (species 220 and 226) that were found in the prohibited species samples. No data have been extrapolated in this database.

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 the original (corrected) observer data for foreign longliners from all species of king crab (species 2), Tanner crab (species 3), Pacific halibut (species 101), and Pacific salmon (species 220 and 226) that were found in the prohibited species samples. No data have been extrapolated in this database.

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
YEAR NUMBER A four-digit number identifying the year in which the gear retrieval of the set began.
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
SAMPLE_NUMBER NUMBER In sampling a longline set or a day's mothership operation or a day's joint venture operation, each portion of the set or delivery that was sampled received a unique sample_number within the set (usually, a 1, 2, or 3).
100
SPECIES NUMBER A three-digit numeric code representing a marine species.
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_SKATES_SAMPLED NUMBER The number of hachi (skates) that were sampled for prohibited species.
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_FLPS NUMBER Foro internal use only.

Attribute Details

CRUISE

CC ID: 37297
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: 37306
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

YEAR

CC ID: 37309
Seq. Order: 3
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 set began.

General Data Type: NUMBER

DT

CC ID: 37298
Seq. Order: 4
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: 37299
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

SAMPLE_NUMBER

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

In sampling a longline set or a day's mothership operation or a day's joint venture operation, each portion of the set or delivery that was sampled received a unique sample_number within the set (usually, a 1, 2, or 3).

General Data Type: NUMBER

SPECIES

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

A three-digit numeric code representing a marine species.

General Data Type: NUMBER
Foreign Key Relations:

NORPAC.DOMESTIC_SPECIES

WEIGHT_SAMPLED

CC ID: 37308
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: 37301
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 6
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: 37307
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_SKATES_SAMPLED

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

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

General Data Type: NUMBER

HAUL_JOIN

CC ID: 37300
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
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_FLPS

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

Foro internal use only.

General Data Type: NUMBER

Catalog Details

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