Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

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.

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.

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

Rubric Score Primary Key? Name Type Description
100
Primary Key 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

CC ID: 29496
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

CC ID: 29495
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

CC ID: 29493
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

CC ID: 29492
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

CC ID: 29489
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

CC ID: 29488
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

CC ID: 29494
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

CC ID: 29497
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

CC ID: 29490
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

CC ID: 29491
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