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_SALMON

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

Item Identification

Title:	Table: ATL_SALMON
Short Name:	ATL_SALMON
Status:	Completed
Abstract:	This entity records the number of prohibited pacific salmon recorded as bycatch ,by species, for an offload or a haul.
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	PROHIBITED SPECIES
None	SAMPLING

Thesaurus

Keyword

UNCONTROLLED

None

AFSC

None

ATL

None

ATLAS

None

BYCATCH

None

FMA

None

GROUNDFISH

None

NORPAC

None

OBSERVER

None

PROHIBITED SPECIES

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 records the number of prohibited pacific salmon recorded as bycatch ,by species, for an offload or a haul. Retrofitted from table SALMON_TABLE.

Data Attributes

Attribute Summary

	Name	Type	Description
100	CRUISE	NUMBER	Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
100	SALMON_SEQ	NUMBER	Sequence generated unique identifier of a salmon record
100	OFFLOAD_SEQ	NUMBER	Sequence generated unique identifier for an offload record. This is the optional FK identifier from an offload.
100	HAUL_SEQ	NUMBER	Sequence generated unique identifier for a haul record. This is the optional FK identifier from a haul.
100	RELIABILITY_CODE	NUMBER	Unique Numeric Value recording who (industry and or observer) recorded the salmon census. FK from lov_salmon_reliability. FK from atl_lov_salmon_reliability.
100	SCALE	VARCHAR2	Whether the temperature was recorded in degrees farenheit(F), celsius(C) or nebulous(N).
100	SURFACE_TEMP	NUMBER	Surface temperature of the water. Applicable only to hauls.
100	FISHING_TEMP	NUMBER	Temperature recorded at fishing depth. Applicable only to hauls.
100	NUMBER_CHINOOK	NUMBER	Number of Chinook recorded for this Haul or Offload. (Census of Salmon beginning 2011).
100	NUMBER_OTHER	NUMBER	Number of Other salmon species recorded for this Haul or Offload. (Census of Salmon beginning 2011).
100	NUMBER_UNIDENTIFIED	NUMBER	Number of Salmon which could not be identified by species.
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	NUMBER_CHUM	NUMBER	Number of Chum salmon tallied for this Haul or Offload. (Census of Salmon beginning 2011).
100	NUMBER_COHO	NUMBER	Number of Coho salmon tallied for this Haul or Offload. (Census of Salmon beginning 2011).
100	NUMBER_SOCKEYE	NUMBER	Number of Sockeye salmon tallied for this Haul or Offload. (Census of Salmon beginning 2011).
100	NUMBER_PINK	NUMBER	Number of Pink salmon tallied for this Haul or Offload. (Census of Salmon beginning 2011).

Name

Type

Description

100

CRUISE

NUMBER

Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.

100

SALMON_SEQ

NUMBER

Sequence generated unique identifier of a salmon record

100

OFFLOAD_SEQ

NUMBER

Sequence generated unique identifier for an offload record. This is the optional FK identifier from an offload.

100

HAUL_SEQ

NUMBER

Sequence generated unique identifier for a haul record. This is the optional FK identifier from a haul.

100

RELIABILITY_CODE

NUMBER

Unique Numeric Value recording who (industry and or observer) recorded the salmon census. FK from lov_salmon_reliability. FK from atl_lov_salmon_reliability.

100

SCALE

VARCHAR2

Whether the temperature was recorded in degrees farenheit(F), celsius(C) or nebulous(N).

100

SURFACE_TEMP

NUMBER

Surface temperature of the water. Applicable only to hauls.

100

FISHING_TEMP

NUMBER

Temperature recorded at fishing depth. Applicable only to hauls.

100

NUMBER_CHINOOK

NUMBER

Number of Chinook recorded for this Haul or Offload. (Census of Salmon beginning 2011).

100

NUMBER_OTHER

NUMBER

Number of Other salmon species recorded for this Haul or Offload. (Census of Salmon beginning 2011).

100

NUMBER_UNIDENTIFIED

NUMBER

Number of Salmon which could not be identified by species.

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

NUMBER_CHUM

NUMBER

Number of Chum salmon tallied for this Haul or Offload. (Census of Salmon beginning 2011).

100

NUMBER_COHO

NUMBER

Number of Coho salmon tallied for this Haul or Offload. (Census of Salmon beginning 2011).

100

NUMBER_SOCKEYE

NUMBER

Number of Sockeye salmon tallied for this Haul or Offload. (Census of Salmon beginning 2011).

100

NUMBER_PINK

NUMBER

Number of Pink salmon tallied for this Haul or Offload. (Census of Salmon beginning 2011).

Attribute Details

CRUISE

CC ID: 38896

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

SALMON_SEQ

CC ID: 38909

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 salmon record
General Data Type:	NUMBER

OFFLOAD_SEQ

CC ID: 38906

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 for an offload record. This is the optional FK identifier from an offload.
General Data Type:	NUMBER
Foreign Key Relations:	NORPAC.ATL_OFFLOAD

HAUL_SEQ

CC ID: 38898

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 a haul record. This is the optional FK identifier from a haul.
General Data Type:	NUMBER
Foreign Key Relations:	NORPAC.ATL_HAUL

RELIABILITY_CODE

CC ID: 38908

Seq. Order:	5
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Unique Numeric Value recording who (industry and or observer) recorded the salmon census. FK from lov_salmon_reliability. FK from atl_lov_salmon_reliability.
General Data Type:	NUMBER
Foreign Key Relations:	NORPAC.ATL_LOV_SALMON_RELIABIL

SCALE

CC ID: 38910

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Whether the temperature was recorded in degrees farenheit(F), celsius(C) or nebulous(N).
General Data Type:	VARCHAR2
Allowed Values:	F, C, N

SURFACE_TEMP

CC ID: 38911

Seq. Order:	7
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	1
Status:	Active
Description:	Surface temperature of the water. Applicable only to hauls.
General Data Type:	NUMBER

FISHING_TEMP

CC ID: 38897

Seq. Order:	8
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	1
Status:	Active
Description:	Temperature recorded at fishing depth. Applicable only to hauls.
General Data Type:	NUMBER

NUMBER_CHINOOK

CC ID: 38899

Seq. Order:	9
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Number of Chinook recorded for this Haul or Offload. (Census of Salmon beginning 2011).
General Data Type:	NUMBER

NUMBER_OTHER

CC ID: 38902

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Number of Other salmon species recorded for this Haul or Offload. (Census of Salmon beginning 2011).
General Data Type:	NUMBER

NUMBER_UNIDENTIFIED

CC ID: 38905

Seq. Order:	11
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Number of Salmon which could not be identified by species.
General Data Type:	NUMBER

PERMIT

CC ID: 38907

Seq. Order:	12
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
Case Restriction:	Upper
Foreign Key Relations:	Refers to more than one entity

NUMBER_CHUM

CC ID: 38900

Seq. Order:	13
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	5
Scale:	0
Status:	Active
Description:	Number of Chum salmon tallied for this Haul or Offload. (Census of Salmon beginning 2011).
General Data Type:	NUMBER

NUMBER_COHO

CC ID: 38901

Seq. Order:	14
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	5
Scale:	0
Status:	Active
Description:	Number of Coho salmon tallied for this Haul or Offload. (Census of Salmon beginning 2011).
General Data Type:	NUMBER

NUMBER_SOCKEYE

CC ID: 38904

Seq. Order:	15
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	5
Scale:	0
Status:	Active
Description:	Number of Sockeye salmon tallied for this Haul or Offload. (Census of Salmon beginning 2011).
General Data Type:	NUMBER

NUMBER_PINK

CC ID: 38903

Seq. Order:	16
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	5
Scale:	0
Status:	Active
Description:	Number of Pink salmon tallied for this Haul or Offload. (Census of Salmon beginning 2011).
General Data Type:	NUMBER

Catalog Details

Catalog Item ID:	9747
GUID:	gov.noaa.nmfs.inport:9747
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