Table: ATL_SAMPLE
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:19049 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
This entity represents the individual samples of a type that may be collected from an observed haul. It is header information for species composition. If there are rare species present in sample and there exist multiple predominant species, a recursive subsample or subsamples may be created. The sum of the weights of the subsamples must be less than or equal to the parent sample.
DescriptionThis entity represents the individual samples of a type that may be collected from an observed haul. It is header information for species composition. If there are rare species present in sample and there exist multiple predominant species, a recursive subsample or subsamples may be created. The sum of the weights of the subsamples must be less than or equal to the parent sample.
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. |
SAMPLE_SEQ
NUMBER |
Sequence generated unique identifier of a sample |
PARENT_SAMPLE_SEQ
NUMBER |
Sequence generated unique identifier of a sample |
SAMPLE_NUMBER
NUMBER |
Sequence within either haul or offload parent. This value is auto-generated but not necessarily unique. |
OFFLOAD_SEQ
NUMBER |
Sequence generated unique identifier for an offload record |
HAUL_SEQ
NUMBER |
Sequence generated unique identifier for a haul record |
COMBINED_SAMPLE_FLAG
VARCHAR2 |
Identifies whether unique samples within a haul have been aggregated together. |
PRESORTED_FLAG
VARCHAR2 |
This flag indicates that child species composition records did not come from and unsorted catch. Generally if a single large animal was removed before sampling began and so was not available for inclusion in any random sample |
TOTAL_SAMPLE_WEIGHT
NUMBER |
Total weight in kg of this sample. |
SAMPLE_HOOKS_POTS
NUMBER |
Number of hooks or pots sampled. |
PERMIT
VARCHAR2 |
Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau |
SPECIES_COMP_IN_SAMPLE
VARCHAR2 |
This flag indicates that fish were found or were absent in this sample - in the latter case composition records are not permitted and the sample is ignored for extrapolations. |
SAMPLE_DESIGN_FLAG
VARCHAR2 |
Identifies this sample as complying (Y) or differing (N) from the protocol declared at the haul level. |
NUMBER_OF_SEGMENTS_SAMPLED
NUMBER |
The number of segments (skates, racks) of hooks which went into this sample. This number may be fractional. |
SAMPLE_HOOKS_OVERIDE_FLAG
VARCHAR2 |
This flag identifies an observer overide of the computed sample hooks - pots variable. The setting of the flag to Y will prohibit the automatic computation of sample hooks-pots from haul-hook-count * number-of-segments-sampled. |
SAMPLED_BY
NUMBER |
no-comment |
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_SAMPLE |
---|---|
Short Name: | ATL_SAMPLE |
Status: | Completed |
Abstract: |
This entity represents the individual samples of a type that may be collected from an observed haul. It is header information for species composition. If there are rare species present in sample and there exist multiple predominant species, a recursive subsample or subsamples may be created. The sum of the weights of the subsamples must be less than or equal to the parent sample. |
Notes: |
Loaded by batch 4574, 05-03-2013 17:18 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | NPRB_1017 |
Description: |
This entity represents the individual samples of a type that may be collected from an observed haul. It is header information for species composition. If there are rare species present in sample and there exist multiple predominant species, a recursive subsample or subsamples may be created. The sum of the weights of the subsamples must be less than or equal to the parent sample. |
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
|
SAMPLE_SEQ | NUMBER | Sequence generated unique identifier of a sample | |
100
|
PARENT_SAMPLE_SEQ | NUMBER | Sequence generated unique identifier of a sample | |
100
|
SAMPLE_NUMBER | NUMBER | Sequence within either haul or offload parent. This value is auto-generated but not necessarily unique. | |
100
|
OFFLOAD_SEQ | NUMBER | Sequence generated unique identifier for an offload record | |
100
|
HAUL_SEQ | NUMBER | Sequence generated unique identifier for a haul record | |
100
|
COMBINED_SAMPLE_FLAG | VARCHAR2 | Identifies whether unique samples within a haul have been aggregated together. | |
100
|
PRESORTED_FLAG | VARCHAR2 | This flag indicates that child species composition records did not come from and unsorted catch. Generally if a single large animal was removed before sampling began and so was not available for inclusion in any random sample | |
100
|
TOTAL_SAMPLE_WEIGHT | NUMBER | Total weight in kg of this sample. | |
100
|
SAMPLE_HOOKS_POTS | NUMBER | Number of hooks or pots sampled. | |
100
|
PERMIT | VARCHAR2 | Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau | |
100
|
SPECIES_COMP_IN_SAMPLE | VARCHAR2 | This flag indicates that fish were found or were absent in this sample - in the latter case composition records are not permitted and the sample is ignored for extrapolations. | |
100
|
SAMPLE_DESIGN_FLAG | VARCHAR2 | Identifies this sample as complying (Y) or differing (N) from the protocol declared at the haul level. | |
100
|
NUMBER_OF_SEGMENTS_SAMPLED | NUMBER | The number of segments (skates, racks) of hooks which went into this sample. This number may be fractional. | |
100
|
SAMPLE_HOOKS_OVERIDE_FLAG | VARCHAR2 | This flag identifies an observer overide of the computed sample hooks - pots variable. The setting of the flag to Y will prohibit the automatic computation of sample hooks-pots from haul-hook-count * number-of-segments-sampled. | |
100
|
SAMPLED_BY | NUMBER | no-comment |
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 |
Foreign Key Relations: |
NPRB_1017.ATL_HAUL |
SAMPLE_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 sample |
General Data Type: | NUMBER |
PARENT_SAMPLE_SEQ
Seq. Order: | 3 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
Sequence generated unique identifier of a sample |
General Data Type: | NUMBER |
Foreign Key Relations: |
NPRB_1017.ATL_SAMPLE |
SAMPLE_NUMBER
Seq. Order: | 4 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
Sequence within either haul or offload parent. This value is auto-generated but not necessarily unique. |
General Data Type: | NUMBER |
OFFLOAD_SEQ
Seq. Order: | 5 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
Sequence generated unique identifier for an offload record |
General Data Type: | NUMBER |
Foreign Key Relations: |
NPRB_1017.ATL_OFFLOAD |
HAUL_SEQ
Seq. Order: | 6 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
Sequence generated unique identifier for a haul record |
General Data Type: | NUMBER |
Foreign Key Relations: |
NPRB_1017.ATL_HAUL |
COMBINED_SAMPLE_FLAG
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Identifies whether unique samples within a haul have been aggregated together. |
General Data Type: | VARCHAR2 |
PRESORTED_FLAG
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
This flag indicates that child species composition records did not come from and unsorted catch. Generally if a single large animal was removed before sampling began and so was not available for inclusion in any random sample |
General Data Type: | VARCHAR2 |
TOTAL_SAMPLE_WEIGHT
Seq. Order: | 9 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 2 |
Status: | Active |
Description: |
Total weight in kg of this sample. |
General Data Type: | NUMBER |
SAMPLE_HOOKS_POTS
Seq. Order: | 10 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 0 |
Status: | Active |
Description: |
Number of hooks or pots sampled. |
General Data Type: | NUMBER |
PERMIT
Seq. Order: | 11 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | Yes |
Primary Key: | Yes |
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 |
Foreign Key Relations: |
NPRB_1017.ATL_HAUL |
SPECIES_COMP_IN_SAMPLE
Seq. Order: | 12 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
This flag indicates that fish were found or were absent in this sample - in the latter case composition records are not permitted and the sample is ignored for extrapolations. |
General Data Type: | VARCHAR2 |
SAMPLE_DESIGN_FLAG
Seq. Order: | 13 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Identifies this sample as complying (Y) or differing (N) from the protocol declared at the haul level. |
General Data Type: | VARCHAR2 |
NUMBER_OF_SEGMENTS_SAMPLED
Seq. Order: | 14 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Scale: | 2 |
Status: | Active |
Description: |
The number of segments (skates, racks) of hooks which went into this sample. This number may be fractional. |
General Data Type: | NUMBER |
SAMPLE_HOOKS_OVERIDE_FLAG
Seq. Order: | 15 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
This flag identifies an observer overide of the computed sample hooks - pots variable. The setting of the flag to Y will prohibit the automatic computation of sample hooks-pots from haul-hook-count * number-of-segments-sampled. |
General Data Type: | VARCHAR2 |
SAMPLED_BY
Seq. Order: | 16 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Scale: | 0 |
Status: | Active |
Description: |
no-comment |
General Data Type: | NUMBER |
Catalog Details
Catalog Item ID: | 19049 |
---|---|
GUID: | gov.noaa.nmfs.inport:19049 |
Metadata Record Created By: | Doug Turnbull |
Metadata Record Created: | 2013-05-03 17:18+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 |