Maintenance Notice: Tuesday May 21 @ 12pm-1:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.3.6. Downtime Schedule Tuesday, May 21, 2024 12:00pm - 1:30pm Eastern / 9:00am - 10:30am Pacific / 6:00am - 8:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: h...
View All
Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

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

Description

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

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
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.
SURFACE_TEMP
NUMBER
Surface temperature of the water. Applicable only to hauls.
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).
PERMIT
VARCHAR2
Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
NUMBER_CHUM
NUMBER
Number of Chum salmon tallied for this Haul or Offload. (Census of Salmon beginning 2011).
NUMBER_COHO
NUMBER
Number of Coho salmon tallied for this Haul or Offload. (Census of Salmon beginning 2011).
NUMBER_SOCKEYE
NUMBER
Number of Sockeye salmon tallied for this Haul or Offload. (Census of Salmon beginning 2011).
NUMBER_PINK
NUMBER
Number of Pink salmon tallied for this Haul or Offload. (Census of Salmon beginning 2011).

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

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 4574, 05-03-2013 17:18

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: NPRB_1017
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 CRUISE NUMBER Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
100
Primary Key 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
SURFACE_TEMP NUMBER Surface temperature of the water. Applicable only to hauls.
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
Primary Key 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: 112281
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:

NPRB_1017.ATL_HAUL

SALMON_SEQ

CC ID: 112292
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: 112285
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

General Data Type: NUMBER
Foreign Key Relations:

NPRB_1017.ATL_OFFLOAD

HAUL_SEQ

CC ID: 112283
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

General Data Type: NUMBER
Foreign Key Relations:

NPRB_1017.ATL_HAUL

RELIABILITY_CODE

CC ID: 112284
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
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
Foreign Key Relations:

NPRB_1017.ATL_LOV_SALMON_RELIA

SCALE

CC ID: 112293
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 or celsius.

General Data Type: VARCHAR2

SURFACE_TEMP

CC ID: 112294
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: 112295
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

General Data Type: NUMBER

NUMBER_CHINOOK

CC ID: 112296
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
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: 112286
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: 112287
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
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

PERMIT

CC ID: 112282
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
Foreign Key Relations:

NPRB_1017.ATL_HAUL

NUMBER_CHUM

CC ID: 112288
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: 112289
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: 112290
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: 112291
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: 19048
GUID: gov.noaa.nmfs.inport:19048
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2013-05-03 17:18+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-05-18
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-05-18
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-05-18