Table: ATL_SALMON_H
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:9748 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
This entity records the number of prohibited pacific salmon recorded as bycatch ,by species, for an offload or a haul.
DescriptionThis 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 |
|---|---|
|
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. |
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_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
|
|
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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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 |