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 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 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
SEQ_NUMBER
NUMBER
Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, increment by 1 and do not cycle.
CHANGED_BY
VARCHAR2
Oracle user who made a change to the transaction table record.
DATE_CHANGED
DATE
Timestamp of change to transaction record.
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
Cruise of sampling observer.

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_H
Short Name: ATL_SAMPLE_H
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.

Purpose:

Histories of all changes to data are maintained by trigger code on the parent table; allowing change control by user and datetime for all updates and delete events.

Notes:

Loaded by batch 2390, 06-30-2009 16:11

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: NORPAC
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

Rubric Score Primary Key? Name Type Description
100
Primary Key SEQ_NUMBER NUMBER Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, increment by 1 and do not cycle.
100
CHANGED_BY VARCHAR2 Oracle user who made a change to the transaction table record.
100
DATE_CHANGED DATE Timestamp of change to transaction record.
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 Cruise of sampling observer.

Attribute Details

SEQ_NUMBER

CC ID: 38961
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 10
Scale: 0
Status: Active
Description:

Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, increment by 1 and do not cycle.

General Data Type: NUMBER

CHANGED_BY

CC ID: 38946
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Oracle user who made a change to the transaction table record.

General Data Type: VARCHAR2

DATE_CHANGED

CC ID: 38949
Seq. Order: 3
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Timestamp of change to transaction record.

General Data Type: DATE

CRUISE

CC ID: 38948
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 22
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

SAMPLE_SEQ

CC ID: 38960
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 22
Scale: 0
Status: Active
Description:

Sequence generated unique identifier of a sample

General Data Type: NUMBER

PARENT_SAMPLE_SEQ

CC ID: 38953
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 22
Scale: 0
Status: Active
Description:

Sequence generated unique identifier of a sample

General Data Type: NUMBER

SAMPLE_NUMBER

CC ID: 38959
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 22
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

CC ID: 38952
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 22
Scale: 0
Status: Active
Description:

Sequence generated unique identifier for an offload record

General Data Type: NUMBER

HAUL_SEQ

CC ID: 38950
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 22
Scale: 0
Status: Active
Description:

Sequence generated unique identifier for a haul record

General Data Type: NUMBER

COMBINED_SAMPLE_FLAG

CC ID: 38947
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
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: 38955
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
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

CC ID: 38963
Seq. Order: 12
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

CC ID: 38958
Seq. Order: 13
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

CC ID: 38954
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
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

SPECIES_COMP_IN_SAMPLE

CC ID: 38962
Seq. Order: 15
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

CC ID: 38956
Seq. Order: 16
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

CC ID: 38951
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
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

CC ID: 38957
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
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

CC ID: 786649
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Cruise of sampling observer.

Catalog Details

Catalog Item ID: 9750
GUID: gov.noaa.nmfs.inport:9750
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2009-06-30 16:11+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