Table: SAMPLE
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:7550 | 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 |
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. |
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 2204, 03-28-2008 14:09 |
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
|
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. |
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 |
PARENT_SAMPLE_SEQ
Seq. Order: | 2 |
---|---|
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: |
TURNBULLD.SAMPLE |
SAMPLE_NUMBER
Seq. Order: | 3 |
---|---|
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: | 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: | 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: |
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 |
TOTAL_SAMPLE_WEIGHT
Seq. Order: | 8 |
---|---|
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: | 9 |
---|---|
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 |
Catalog Details
Catalog Item ID: | 7550 |
---|---|
GUID: | gov.noaa.nmfs.inport:7550 |
Metadata Record Created By: | Doug Turnbull |
Metadata Record Created: | 2008-03-28 14:10+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2016-05-04 |
Owner Org: | AFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2016-05-04 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2017-05-04 |