Table: FOREIGN_DETAIL_SPCOMP
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:9569 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
This table contains the original (corrected) observer data for foreign trawlers, motherships, snail pot vessels, and joint venture operations. No data have been extrapolated in this database. These data are from all species (including prohibited species) that were found in the species composition samples.
DescriptionThis table contains the original (corrected) observer data for foreign trawlers, motherships, snail pot vessels, and joint venture operations. No data have been extrapolated in this database. These data are from all species (including prohibited species) that were found in the species composition samples.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
CRUISE
NUMBER |
Four-digit number to represent each occasion that an observer was aboard a different 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 haul began. |
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). |
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. |
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. |
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_FDSP
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_DETAIL_SPCOMP |
---|---|
Short Name: | FOREIGN_DETAIL_SPCOMP |
Status: | Completed |
Abstract: |
This table contains the original (corrected) observer data for foreign trawlers, motherships, snail pot vessels, and joint venture operations. No data have been extrapolated in this database. These data are from all species (including prohibited species) that were found in the species composition samples. |
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 trawlers, motherships, snail pot vessels, and joint venture operations. No data have been extrapolated in this database. These data are from all species (including prohibited species) that were found in the species composition samples. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
CRUISE | NUMBER | Four-digit number to represent each occasion that an observer was aboard a different 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 haul began. | |
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
|
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
|
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
|
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
|
PK_FDSP | NUMBER | For internal use only. |
Attribute Details
CRUISE
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Four-digit number to represent each occasion that an observer was aboard a different 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
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
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 haul began. |
General Data Type: | NUMBER |
DT
Seq. Order: | 4 |
---|---|
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 |
HAUL
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
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
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 |
SEX
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | Yes |
Primary Key: | No |
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
Seq. Order: | 9 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
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
Seq. Order: | 10 |
---|---|
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
Seq. Order: | 11 |
---|---|
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
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 pots in the set that were sampled for species composition. |
General Data Type: | NUMBER |
NUMBER_OF_SKATES_SAMPLED
Seq. Order: | 13 |
---|---|
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 |
HAUL_JOIN
Seq. Order: | 14 |
---|---|
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_FDSP
Seq. Order: | 15 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 7 |
Scale: | 0 |
Status: | Active |
Description: |
For internal use only. |
General Data Type: | NUMBER |
Catalog Details
Catalog Item ID: | 9569 |
---|---|
GUID: | gov.noaa.nmfs.inport:9569 |
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 |