Table: ATLW_SPECIES_COMPOSITION
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:7361 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | Table: ATLW_SPECIES_COMPOSITION |
---|---|
Short Name: | ATLW_SPECIES_COMPOSITION |
Status: | Completed |
Abstract: |
This entity maps to the old Norpac Species_Comp_Detail Table. It contains records of each species which is identified within an observer sampling frame. The count of animals must be positive, zero count records are not permitted. Species composition records always come from a sample. |
Purpose: |
Working Tables accept the raw data from field transmissions or data entry. They are unconstrained, Relational integrity data validation is performed when data are loaded into NORPAC transaction tables. Error checking is performed by batch processes on production data. |
Notes: |
Loaded by batch 2164, 03-27-2008 10:42 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | NORPAC |
Description: |
This entity maps to the Norpac Species_Comp_Detail Table. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
RECORD_SET_STATUS_SEQ | NUMBER | Sequence generated unique identifier of a record set header | |
100
|
CRUISE | NUMBER | Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. | |
100
|
SPECIES_COMPOSITION_SEQ | NUMBER | Sequence Generated unique identifier of a species composition record | |
100
|
SAMPLE_SEQ | NUMBER | Sequence generated unique identifier of a sample | |
100
|
SPECIES_CODE | NUMBER | Unique identifier for a species imported from Norpac | |
100
|
SPECIES_WEIGHT | NUMBER | Weight of each species in the sample. Either the species number or the species weight may be null, but not both. | |
100
|
SPECIES_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. |
Attribute Details
RECORD_SET_STATUS_SEQ
Seq. Order: | 1 |
---|---|
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 record set header |
General Data Type: | NUMBER |
CRUISE
Seq. Order: | 2 |
---|---|
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 |
SPECIES_COMPOSITION_SEQ
Seq. Order: | 3 |
---|---|
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 |
SAMPLE_SEQ
Seq. Order: | 4 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
Sequence generated unique identifier of a sample |
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 |
SPECIES_WEIGHT
Seq. Order: | 6 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 11 |
Scale: | 2 |
Status: | Active |
Description: |
Weight of each species in the sample. Either the species number or the species weight may be null, but not both. |
General Data Type: | NUMBER |
SPECIES_NUMBER
Seq. Order: | 7 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
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 |
Catalog Details
Catalog Item ID: | 7361 |
---|---|
GUID: | gov.noaa.nmfs.inport:7361 |
Metadata Record Created By: | Doug Turnbull |
Metadata Record Created: | 2008-03-27 10:42+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 |