Slide Menu
Search Help Show/Hide Menu

Item Identification

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 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.

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
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 Details

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