CURRENT_SALMON
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:28428 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | CURRENT_SALMON |
---|---|
Short Name: | CURRENT_SALMON |
Status: | In Work |
Abstract: |
This entity records the number of prohibited pacific salmon recorded as bycatch, by species, for an offload or a haul. |
Keywords
Temporal Keywords
Thesaurus | Keyword |
---|---|
UNCONTROLLED | |
None | 2008 AND FORWARD |
Spatial Keywords
Thesaurus | Keyword |
---|---|
UNCONTROLLED | |
None | BS, AI, BSAI, GOA |
Stratum Keywords
Thesaurus | Keyword |
---|---|
UNCONTROLLED | |
None | BYCATCH |
None | OBSERVER, CURRENT DATA, FISHERY STATISTICS |
Physical Location
Organization: | Fisheries Monitoring and Analysis |
---|---|
City: | Seattle |
State/Province: | WA |
Country: | USA |
Location Description: |
Alaska Fisheries Science Center |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Alias: | This entity records the number of prohibited pacif |
Schema Name: | OBSING |
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
|
T_TABLE | VARCHAR2 | Identifier of Source Table | |
100
|
SALMON_SEQ | NUMBER | Sequence generated unique identifier of a salmon record generated by the. Because salmon species are summed for this construct, this value is generated locally and not inherited | |
100
|
CRUISE | NUMGER | Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. | |
100
|
PERMIT | VARCHAR2 | Unique Code identifying a delivering vessel - inherited from the NORPAC data set and created by the RAM division in Juneau | |
100
|
OFFLOAD_SEQ | NUMBER | Optional foreign key identifier from an offload record. Sequence generated unique identifier for an offload record | |
100
|
HAUL_SEQ | NUMBER | Optional foreign key column from current_haul | |
100
|
SPECIES_CODE | NUMBER | Unique identifier for a species imported from Norpac | |
100
|
HAUL_JOIN | NUMBER | Surrogate FK to haul if salmon record is so derived Composed of concatenation of cruise, permit and haul_seq. For domestic table records this is a sequence generated unique identifier for a haul. | |
100
|
OFFLOAD_JOIN | NUMBER | Surrogate FK to offload if salmon record is so derived Composed of concatenation of cruise, permit and offloadl_seq. | |
100
|
COUNT | NUMBER | Number of Individual Salmon Observed and Recorded. | |
100
|
LAST_MODIFIED_DATE | DATE | Everytime an offload-salmon or haul-salmon record from the production schema is processed the the obsint.load_current_salmon the processing datetime is recorded here. This does not necessarily mean the current offload-haul-salmon record was modified as the program processes every record within a cruise permit when initiated. |
Attribute Details
T_TABLE
Seq. Order: | 10 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 32 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Identifier of Source Table |
General Data Type: | CHARACTER |
SALMON_SEQ
Seq. Order: | 15 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 9 |
Required: | No |
Primary Key: | Yes |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
Sequence generated unique identifier of a salmon record generated by the. Because salmon species are summed for this construct, this value is generated locally and not inherited |
General Data Type: | INTEGER |
CRUISE
Seq. Order: | 20 |
---|---|
Data Storage Type: | NUMGER |
Max Length: | 9 |
Required: | No |
Primary Key: | No |
Precision: | 9 |
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: | INTEGER |
PERMIT
Seq. Order: | 25 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unique Code identifying a delivering vessel - inherited from the NORPAC data set and created by the RAM division in Juneau |
General Data Type: | CHARACTER |
OFFLOAD_SEQ
Seq. Order: | 30 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 9 |
Required: | No |
Primary Key: | No |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
Optional foreign key identifier from an offload record. Sequence generated unique identifier for an offload record |
General Data Type: | INTEGER |
HAUL_SEQ
Seq. Order: | 35 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 9 |
Required: | No |
Primary Key: | No |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
Optional foreign key column from current_haul |
General Data Type: | INTEGER |
SPECIES_CODE
Seq. Order: | 40 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | In Development |
Description: |
Unique identifier for a species imported from Norpac |
General Data Type: | INTEGER |
HAUL_JOIN
Seq. Order: | 45 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Precision: | 20 |
Scale: | 0 |
Status: | Active |
Description: |
Surrogate FK to haul if salmon record is so derived Composed of concatenation of cruise, permit and haul_seq. For domestic table records this is a sequence generated unique identifier for a haul. |
General Data Type: | INTEGER |
OFFLOAD_JOIN
Seq. Order: | 50 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Precision: | 20 |
Scale: | 0 |
Status: | Active |
Description: |
Surrogate FK to offload if salmon record is so derived Composed of concatenation of cruise, permit and offloadl_seq. |
General Data Type: | INTEGER |
COUNT
Seq. Order: | 55 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 4 |
Required: | Yes |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Number of Individual Salmon Observed and Recorded. |
General Data Type: | INTEGER |
LAST_MODIFIED_DATE
Seq. Order: | 60 |
---|---|
Data Storage Type: | DATE |
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Everytime an offload-salmon or haul-salmon record from the production schema is processed the the obsint.load_current_salmon the processing datetime is recorded here. This does not necessarily mean the current offload-haul-salmon record was modified as the program processes every record within a cruise permit when initiated. |
General Data Type: | DATE |
Catalog Details
Catalog Item ID: | 28428 |
---|---|
GUID: | gov.noaa.nmfs.inport:28428 |
Metadata Record Created By: | Julie A Blair |
Metadata Record Created: | 2015-10-30 18:02+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2016-05-04 |
Owner Org: | AFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2016-05-04 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2017-05-04 |