Metadata Rubric

100%

6 / 6

Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > North Pacific (NORPAC) Groundfish and Halibut O... > AFSC/FMA/North Pacific Groundfish and Halibut O... >

Table: ATL_SAMPLE

Entity (ENT) | Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:9749 | Updated: August 9, 2022 | Published / External

Item Identification

Title:	Table: ATL_SAMPLE
Short Name:	ATL_SAMPLE
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.
Notes:	Loaded by batch 2390, 06-30-2009 16:11

Keywords

Theme Keywords

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

Thesaurus

Keyword

UNCONTROLLED

None

AFSC

None

ATL

None

ATLAS

None

BYCATCH

None

FMA

None

GROUNDFISH

None

NORPAC

None

OBSERVER

None

SAMPLING

Spatial Keywords

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

Thesaurus

Keyword

UNCONTROLLED

None

ALEUTIAN ISLANDS

None

BERING SEA

None

BSAI

None

GOA

None

GULF OF ALASKA

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 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	cruise1	NUMBER	Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise 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.

Name

Type

Description

100

cruise1

NUMBER

Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise 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.

Attribute Details

cruise1

CC ID: 38931

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	22
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
Foreign Key Relations:	Refers to more than one entity

CRUISE

CC ID: 38932

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	22
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
Foreign Key Relations:	Refers to more than one entity

SAMPLE_SEQ

CC ID: 38943

Seq. Order:	2
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

CC ID: 38936

Seq. Order:	3
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:	NORPAC.ATL_SAMPLE

SAMPLE_NUMBER

CC ID: 38942

Seq. Order:	4
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

CC ID: 38935

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 an offload record
General Data Type:	NUMBER
Foreign Key Relations:	NORPAC.ATL_OFFLOAD

HAUL_SEQ

CC ID: 38933

Seq. Order:	6
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:	NORPAC.ATL_HAUL

COMBINED_SAMPLE_FLAG

CC ID: 38930

Seq. Order:	7
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: 38938

Seq. Order:	8
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

CC ID: 38945

Seq. Order:	9
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: 38941

Seq. Order:	10
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: 38937

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	Yes
Primary Key:	Yes
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
Foreign Key Relations:	Refers to more than one entity

SPECIES_COMP_IN_SAMPLE

CC ID: 38944

Seq. Order:	12
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: 38939

Seq. Order:	13
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: 38934

Seq. Order:	14
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: 38940

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

Catalog Details

Catalog Item ID:	9749
GUID:	gov.noaa.nmfs.inport: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 Last Review Date:	2018-09-26
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2019-09-26