Metadata Rubric

100%

6 / 6

View Report

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_H

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

This entity records the number of prohibited pacific salmon recorded as bycatch ,by species, for an offload or a haul.

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.

Description

This entity records the number of prohibited pacific salmon recorded as bycatch ,by species, for an offload or a haul.

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.
SALMON_SEQ NUMBER	Sequence generated unique identifier of a salmon record
OFFLOAD_SEQ NUMBER	Sequence generated unique identifier for an offload record
HAUL_SEQ NUMBER	Sequence generated unique identifier for a haul record
RELIABILITY_CODE NUMBER	Unique Numeric Value recording who (industry and or observer) recorded the salmon census. FK from lov_salmon_reliability.
SCALE VARCHAR2	Whether the temperature was recorded in degrees farenheit or celsius.
FISHING_TEMP NUMBER	Temperature recorded at fishing depth
NUMBER_CHINOOK NUMBER	Number of Chinook recorded for this Haul or Offload. (Census of Salmon beginning 2011).
NUMBER_OTHER NUMBER	Number of Other salmon species recorded for this Haul or Offload. (Census of Salmon beginning 2011).
NUMBER_UNIDENTIFIED NUMBER	Number of Salmon which could not be identified by species for this Haul or Offload. (Census of Salmon beginning 2011).
SURFACE_TEMP NUMBER	Surface temperature of the water. Applicable only to hauls.
PERMIT VARCHAR2	Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
NUMBER_PINK NUMBER	Number of Pink salmon tallied for this offload.
NUMBER_SOCKEYE NUMBER	Number of Sockeye salmon tallied for this offload.
NUMBER_COHO NUMBER	Number of Coho salmon tallied for this offload.

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.

SALMON_SEQ
NUMBER

Sequence generated unique identifier of a salmon record

OFFLOAD_SEQ
NUMBER

Sequence generated unique identifier for an offload record

HAUL_SEQ
NUMBER

Sequence generated unique identifier for a haul record

RELIABILITY_CODE
NUMBER

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

SCALE
VARCHAR2

Whether the temperature was recorded in degrees farenheit or celsius.

FISHING_TEMP
NUMBER

Temperature recorded at fishing depth

NUMBER_CHINOOK
NUMBER

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

NUMBER_OTHER
NUMBER

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

NUMBER_UNIDENTIFIED
NUMBER

Number of Salmon which could not be identified by species for this Haul or Offload. (Census of Salmon beginning 2011).

SURFACE_TEMP
NUMBER

Surface temperature of the water. Applicable only to hauls.

PERMIT
VARCHAR2

Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau

NUMBER_PINK
NUMBER

Number of Pink salmon tallied for this offload.

NUMBER_SOCKEYE
NUMBER

Number of Sockeye salmon tallied for this offload.

NUMBER_COHO
NUMBER

Number of Coho salmon tallied for this offload.

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

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

Attribute Summary

	Name	Type	Description
100	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	SALMON_SEQ	NUMBER	Sequence generated unique identifier of a salmon record
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	RELIABILITY_CODE	NUMBER	Unique Numeric Value recording who (industry and or observer) recorded the salmon census. FK from lov_salmon_reliability.
100	SCALE	VARCHAR2	Whether the temperature was recorded in degrees farenheit or celsius.
100	FISHING_TEMP	NUMBER	Temperature recorded at fishing depth
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 for this Haul or Offload. (Census of Salmon beginning 2011).
100	SURFACE_TEMP	NUMBER	Surface temperature of the water. Applicable only to hauls.
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_PINK	NUMBER	Number of Pink salmon tallied for this offload.
100	NUMBER_SOCKEYE	NUMBER	Number of Sockeye salmon tallied for this offload.
100	NUMBER_COHO	NUMBER	Number of Coho salmon tallied for this offload.

Name

Type

Description

100

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

SALMON_SEQ

NUMBER

Sequence generated unique identifier of a salmon record

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

RELIABILITY_CODE

NUMBER

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

100

SCALE

VARCHAR2

Whether the temperature was recorded in degrees farenheit or celsius.

100

FISHING_TEMP

NUMBER

Temperature recorded at fishing depth

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 for this Haul or Offload. (Census of Salmon beginning 2011).

100

SURFACE_TEMP

NUMBER

Surface temperature of the water. Applicable only to hauls.

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_PINK

NUMBER

Number of Pink salmon tallied for this offload.

100

NUMBER_SOCKEYE

NUMBER

Number of Sockeye salmon tallied for this offload.

100

NUMBER_COHO

NUMBER

Number of Coho salmon tallied for this offload.

Attribute Details

SEQ_NUMBER

CC ID: 38928

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: 38912

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: 38914

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: 38913

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

SALMON_SEQ

CC ID: 38926

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

OFFLOAD_SEQ

CC ID: 38923

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 for an offload record
General Data Type:	NUMBER

HAUL_SEQ

CC ID: 38916

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

RELIABILITY_CODE

CC ID: 38925

Seq. Order:	8
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	22
Scale:	0
Status:	Active
Description:	Unique Numeric Value recording who (industry and or observer) recorded the salmon census. FK from lov_salmon_reliability.
General Data Type:	NUMBER

SCALE

CC ID: 38927

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Whether the temperature was recorded in degrees farenheit or celsius.
General Data Type:	VARCHAR2

FISHING_TEMP

CC ID: 38915

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	22
Scale:	0
Status:	Active
Description:	Temperature recorded at fishing depth
General Data Type:	NUMBER

NUMBER_CHINOOK

CC ID: 38917

Seq. Order:	11
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	22
Scale:	0
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: 38919

Seq. Order:	12
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	22
Scale:	0
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: 38922

Seq. Order:	13
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	22
Scale:	0
Status:	Active
Description:	Number of Salmon which could not be identified by species for this Haul or Offload. (Census of Salmon beginning 2011).
General Data Type:	NUMBER

SURFACE_TEMP

CC ID: 38929

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

PERMIT

CC ID: 38924

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

NUMBER_PINK

CC ID: 38920

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 offload.
General Data Type:	NUMBER

NUMBER_SOCKEYE

CC ID: 38921

Seq. Order:	17
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 offload.
General Data Type:	NUMBER

NUMBER_COHO

CC ID: 38918

Seq. Order:	18
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 offload.
General Data Type:	NUMBER

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

Table: ATL_SALMON_H

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

SEQ_NUMBER

CHANGED_BY

DATE_CHANGED

CRUISE

SALMON_SEQ

OFFLOAD_SEQ

HAUL_SEQ

RELIABILITY_CODE

SCALE

FISHING_TEMP

NUMBER_CHINOOK

NUMBER_OTHER

NUMBER_UNIDENTIFIED

SURFACE_TEMP

PERMIT

NUMBER_PINK

NUMBER_SOCKEYE

NUMBER_COHO

Catalog Details