Table: SAMPLE
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:7481 | 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 does not currently map to any Norpac table, but 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 does not currently map to any Norpac table, but 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 |
---|---|
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. |
PARENT_SAMPLE_SEQ
NUMBER |
Sequence generated unique identifier of a sample |
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 |
SKATE_NUMBER
NUMBER |
Unique number within a sample of a skate |
HOOK_SAMPLE_CODE
VARCHAR2 |
The sampling method used to collect data: 'N' indicates stnadard NPGOP sampling methods; 'H' indicates study-specific methods that document the catch of each individual hook were used. |
NUMBER_OF_HOOKS
NUMBER |
Number of hooks on the skate |
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: SAMPLE |
---|---|
Short Name: | SAMPLE |
Status: | Completed |
Abstract: |
This entity represents the individual samples of a type that may be collected from an observed haul. It does not currently map to any Norpac table, but 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 2183, 03-27-2008 11:52 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | TURNBULLD |
Description: |
This entity represents the individual samples of a type that may be collected from an observed haul. It does not currently map to any Norpac table, but 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
|
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
|
PARENT_SAMPLE_SEQ | NUMBER | Sequence generated unique identifier of a sample | |
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
|
SKATE_NUMBER | NUMBER | Unique number within a sample of a skate | |
100
|
HOOK_SAMPLE_CODE | VARCHAR2 | The sampling method used to collect data: 'N' indicates stnadard NPGOP sampling methods; 'H' indicates study-specific methods that document the catch of each individual hook were used. | |
100
|
NUMBER_OF_HOOKS | NUMBER | Number of hooks on the skate |
Attribute Details
SAMPLE_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 sample |
General Data Type: | NUMBER |
SAMPLE_NUMBER
Seq. Order: | 2 |
---|---|
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 |
PARENT_SAMPLE_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 of a sample |
General Data Type: | NUMBER |
Foreign Key Relations: |
TURNBULLD.SAMPLE |
OFFLOAD_SEQ
Seq. Order: | 4 |
---|---|
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: |
TURNBULLD.OFFLOAD |
HAUL_SEQ
Seq. Order: | 5 |
---|---|
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 |
Foreign Key Relations: |
TURNBULLD.HAUL |
COMBINED_SAMPLE_FLAG
Seq. Order: | 6 |
---|---|
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: | 7 |
---|---|
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 |
SKATE_NUMBER
Seq. Order: | 8 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Unique number within a sample of a skate |
General Data Type: | NUMBER |
HOOK_SAMPLE_CODE
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
The sampling method used to collect data: 'N' indicates stnadard NPGOP sampling methods; 'H' indicates study-specific methods that document the catch of each individual hook were used. |
General Data Type: | VARCHAR2 |
NUMBER_OF_HOOKS
Seq. Order: | 10 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Number of hooks on the skate |
General Data Type: | NUMBER |
Catalog Details
Catalog Item ID: | 7481 |
---|---|
GUID: | gov.noaa.nmfs.inport:7481 |
Metadata Record Created By: | Doug Turnbull |
Metadata Record Created: | 2008-03-27 11:52+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 |