Table: ATL_SAMPLE

Alaska Fisheries Science Center
Entity (ENT) | ID: 9749 | Published / External
Created: 2009-06-30   |   Last Modified: 2022-08-09

Parent: AFSC/FMA/North Pacific Groundfish and Halibut Observer Program, Post 2008 Fishery Statistics.
Data Set (DS) | ID: 7284

ID: 9749
Entity (ENT)

* Discovery
• First Pass
» Metadata Rubric

Item Identification

* » Title Table: ATL_SAMPLE
Short Name ATL_SAMPLE
* Status Completed
Creation Date  
Revision Date  
• Publication Date  
* » 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
Notes

Loaded by batch 2390, 06-30-2009 16:11
Other Citation Details
• Supplemental Information
DOI (Digital Object Identifier)  
DOI Registration Authority  
DOI Issue Date  

Keywords

Theme Keywords

Thesaurus Keyword
None AFSC
None ATL
None ATLAS
None BYCATCH
None FMA
None GROUNDFISH
None NORPAC
None OBSERVER
None SAMPLING
   
   
   

Temporal Keywords

Thesaurus Keyword
   
   
   

* Spatial Keywords

Thesaurus Keyword
None AI
None ALEUTIAN ISLANDS
None BERING SEA
None BS
None BSAI
None GOA
None GULF OF ALASKA
   
   
   

Stratum Keywords

Thesaurus Keyword
   
   
   

Instrument Keywords

Thesaurus Keyword
   
   
   

Platform Keywords

Thesaurus Keyword
   
   
   

Physical Location

• » Organization  
• » City  
• » State/Province  
• Country  
• » Location Description

Entity Information

Entity Type Data Table
Active Version? Y
Alias  
Schema Name NORPAC
» 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.
Change Summary

Data Attributes

Attribute Summary

Score Req'd? PKey? » Name Data Storage Type Description
100 No No cruise1 NUMBER Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
100 Yes Yes CRUISE NUMBER Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
100 Yes Yes SAMPLE_SEQ NUMBER Sequence generated unique identifier of a sample
100 No No PARENT_SAMPLE_SEQ NUMBER Sequence generated unique identifier of a sample
100 Yes No SAMPLE_NUMBER NUMBER Sequence within either haul or offload parent. This value is auto-generated but not necessarily unique.
100 No No OFFLOAD_SEQ NUMBER Sequence generated unique identifier for an offload record
100 No No HAUL_SEQ NUMBER Sequence generated unique identifier for a haul record
100 Yes No COMBINED_SAMPLE_FLAG VARCHAR2 Identifies whether unique samples within a haul have been aggregated together.
100 Yes No 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 No No TOTAL_SAMPLE_WEIGHT NUMBER Total weight in kg of this sample.
100 No No SAMPLE_HOOKS_POTS NUMBER Number of hooks or pots sampled.
100 Yes Yes PERMIT VARCHAR2 Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
100 No No 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 Yes No SAMPLE_DESIGN_FLAG VARCHAR2 Identifies this sample as complying (Y) or differing (N) from the protocol declared at the haul level.
100 No No NUMBER_OF_SEGMENTS_SAMPLED NUMBER The number of segments (skates, racks) of hooks which went into this sample. This number may be fractional.
100 Yes No 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.

Attribute Details

Attribute Name cruise1
Seq. Order 1
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations

Refers to more than one entity
Derivation
Validation Rules
Attribute Name CRUISE
Seq. Order 1
Data Storage Type NUMBER
Max Length 22
Min Length  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations

Refers to more than one entity
Derivation
Validation Rules
Attribute Name SAMPLE_SEQ
Seq. Order 2
Data Storage Type NUMBER
Max Length 22
Min Length  
Required Yes
Primary Key Yes
Precision 9
Scale 0
Status Active
Description

Sequence generated unique identifier of a sample
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PARENT_SAMPLE_SEQ
Seq. Order 3
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 9
Scale 0
Status Active
Description

Sequence generated unique identifier of a sample
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations

NORPAC.ATL_SAMPLE
Derivation
Validation Rules
Attribute Name SAMPLE_NUMBER
Seq. Order 4
Data Storage Type NUMBER
Max Length 22
Min Length  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OFFLOAD_SEQ
Seq. Order 5
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 9
Scale 0
Status Active
Description

Sequence generated unique identifier for an offload record
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations

NORPAC.ATL_OFFLOAD
Derivation
Validation Rules
Attribute Name HAUL_SEQ
Seq. Order 6
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 9
Scale 0
Status Active
Description

Sequence generated unique identifier for a haul record
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations

NORPAC.ATL_HAUL
Derivation
Validation Rules
Attribute Name COMBINED_SAMPLE_FLAG
Seq. Order 7
Data Storage Type VARCHAR2
Max Length 1
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

Identifies whether unique samples within a haul have been aggregated together.
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PRESORTED_FLAG
Seq. Order 8
Data Storage Type VARCHAR2
Max Length 1
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TOTAL_SAMPLE_WEIGHT
Seq. Order 9
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 10
Scale 2
Status Active
Description

Total weight in kg of this sample.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SAMPLE_HOOKS_POTS
Seq. Order 10
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 6
Scale 0
Status Active
Description

Number of hooks or pots sampled.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PERMIT
Seq. Order 11
Data Storage Type VARCHAR2
Max Length 6
Min Length  
Required Yes
Primary Key Yes
Precision  
Scale  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations

Refers to more than one entity
Derivation
Validation Rules
Attribute Name SPECIES_COMP_IN_SAMPLE
Seq. Order 12
Data Storage Type VARCHAR2
Max Length 1
Min Length  
Required No
Primary Key No
Precision  
Scale  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SAMPLE_DESIGN_FLAG
Seq. Order 13
Data Storage Type VARCHAR2
Max Length 1
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

Identifies this sample as complying (Y) or differing (N) from the protocol declared at the haul level.
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NUMBER_OF_SEGMENTS_SAMPLED
Seq. Order 14
Data Storage Type NUMBER
Max Length 22
Min Length  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SAMPLE_HOOKS_OVERIDE_FLAG
Seq. Order 15
Data Storage Type VARCHAR2
Max Length 1
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
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
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Support Roles

» At least one Distributor Org, one Metadata Contact, one Point of Contact, and one Data Steward should be listed.
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions

Extents

Currentness Reference  

Extent Group 1

Extent Description

Extent Group 1 / Geographic Area

* » W° Bound
* » E° Bound
* » N° Bound
* » S° Bound
* » Description

Extent Group 1 / Vertical Extent

EPSG Code
Vertical Minimum
Vertical Maximum

Extent Group 1 / Time Frame

* » Time Frame Type
* » Start
End
Alternate Start as of Info
Alternate End as of Info
Description

Access Information

* » Security Class  
* Security Classification System  
 
Security Handling Description  
 
• Data Access Policy  
 
» Data Access Procedure  
 
• » Data Access Constraints  
 
• Data Use Constraints  
 
Metadata Access Constraints  
 
Metadata Use Constraints  
 

Distribution Information

Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status
Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status
Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status

Activity Log

Activity Time
Activity Type
Responsible Party
Description
Activity Time
Activity Type
Responsible Party
Description
Activity Time
Activity Type
Responsible Party
Description

Issues

Issue Date
Author
Issue
Issue Date
Author
Issue
Issue Date
Author
Issue

FAQs

Date
Author
Question
Answer

Child Items

Rubric scores updated every 15m

Score Type Title
     
     
     

Related Items

Item Type Relationship Type Title
     
     
     

Catalog Details

Catalog Item ID 9749
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 Workflow State Published / External
Metadata Last Review Date 2018-09-26
Metadata Review Frequency 1 Year
Metadata Next Review Date 2019-09-26
Tags