Table: ATL_EXTRAWL_SPECIES_COMP
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:9665 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
This entity provides the repository for extrapolated trawl data.
DescriptionThis entity provides the repository for extrapolated trawl data.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
CRUISE
NUMBER |
Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. |
EXTRAWL_SPCOMP_SEQ
NUMBER |
Sequence Generated unique identifier of a species composition record |
HAUL_SEQ
NUMBER |
Sequence generated unique identifier for a haul record |
HAUL_NUMBER
NUMBER |
Number which is entered by the observer identifying a unique haul within a trip. Since records are not physically deleted, trigger code preserves uniqueness by allowing only a single active record to exist (delete_marker IS NOT NULL). |
SPECIES_CODE
NUMBER |
Unique identifier for a species imported from Norpac |
EXTRAPOLATED_WEIGHT
NUMBER |
Weight of each species in the sample in kg. Either the species number or the species weight may be null, but not both. |
EXTRAPOLATED_NUMBER
NUMBER |
Number of individual animals in the sample. Either the species number or the species weight may be null, but not both. |
SEX_CODE
VARCHAR2 |
Sex if so identified. |
PERMIT
VARCHAR2 |
Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau |
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: ATL_EXTRAWL_SPECIES_COMP |
---|---|
Short Name: | ATL_EXTRAWL_SPECIES_COMP |
Status: | Completed |
Abstract: |
This entity provides the repository for extrapolated trawl data. |
Notes: |
Loaded by batch 2390, 06-30-2009 16:11 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | NORPAC |
Description: |
This entity provides the repository for extrapolated trawl data. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
CRUISE | NUMBER | Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. | |
100
|
EXTRAWL_SPCOMP_SEQ | NUMBER | Sequence Generated unique identifier of a species composition record | |
100
|
HAUL_SEQ | NUMBER | Sequence generated unique identifier for a haul record | |
100
|
HAUL_NUMBER | NUMBER | Number which is entered by the observer identifying a unique haul within a trip. Since records are not physically deleted, trigger code preserves uniqueness by allowing only a single active record to exist (delete_marker IS NOT NULL). | |
100
|
SPECIES_CODE | NUMBER | Unique identifier for a species imported from Norpac | |
100
|
EXTRAPOLATED_WEIGHT | NUMBER | Weight of each species in the sample in kg. Either the species number or the species weight may be null, but not both. | |
100
|
EXTRAPOLATED_NUMBER | NUMBER | Number of individual animals in the sample. Either the species number or the species weight may be null, but not both. | |
100
|
SEX_CODE | VARCHAR2 | Sex if so identified. | |
100
|
PERMIT | VARCHAR2 | Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau |
Attribute Details
CRUISE
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 8 |
Scale: | 0 |
Status: | Active |
Description: |
Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. |
General Data Type: | NUMBER |
EXTRAWL_SPCOMP_SEQ
Seq. Order: | 2 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
Sequence Generated unique identifier of a species composition record |
General Data Type: | NUMBER |
HAUL_SEQ
Seq. Order: | 3 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
Sequence generated unique identifier for a haul record |
General Data Type: | NUMBER |
HAUL_NUMBER
Seq. Order: | 4 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 6 |
Scale: | 0 |
Status: | Active |
Description: |
Number which is entered by the observer identifying a unique haul within a trip. Since records are not physically deleted, trigger code preserves uniqueness by allowing only a single active record to exist (delete_marker IS NOT NULL). |
General Data Type: | NUMBER |
SPECIES_CODE
Seq. Order: | 5 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Unique identifier for a species imported from Norpac |
General Data Type: | NUMBER |
Foreign Key Relations: |
NORPAC.ATL_LOV_SPECIES_CODE |
EXTRAPOLATED_WEIGHT
Seq. Order: | 6 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 11 |
Scale: | 2 |
Status: | Active |
Description: |
Weight of each species in the sample in kg. Either the species number or the species weight may be null, but not both. |
General Data Type: | NUMBER |
EXTRAPOLATED_NUMBER
Seq. Order: | 7 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 7 |
Scale: | 0 |
Status: | Active |
Description: |
Number of individual animals in the sample. Either the species number or the species weight may be null, but not both. |
General Data Type: | NUMBER |
SEX_CODE
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Sex if so identified. |
General Data Type: | VARCHAR2 |
PERMIT
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 9665 |
---|---|
GUID: | gov.noaa.nmfs.inport:9665 |
Metadata Record Created By: | Doug Turnbull |
Metadata Record Created: | 2009-06-30 16:11+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2018-09-26 |
Owner Org: | AFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2018-09-26 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2019-09-26 |