Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Current Observer Data Interface > AFSC/FMA/Current Observer Data Interface >

CURRENT_SALMON

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:28428  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Keywords
Physical Location
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
T_TABLE
VARCHAR2 		Identifier of Source Table
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
CRUISE
NUMGER 		Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
PERMIT
VARCHAR2 		Unique Code identifying a delivering vessel - inherited from the NORPAC data set and created by the RAM division in Juneau
OFFLOAD_SEQ
NUMBER 		Optional foreign key identifier from an offload record. Sequence generated unique identifier for an offload record
HAUL_SEQ
NUMBER 		Optional foreign key column from current_haul
SPECIES_CODE
NUMBER 		Unique identifier for a species imported from Norpac
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.
OFFLOAD_JOIN
NUMBER 		Surrogate FK to offload if salmon record is so derived Composed of concatenation of cruise, permit and offloadl_seq.
COUNT
NUMBER 		Number of Individual Salmon Observed and Recorded.
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.

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

Rubric Score Primary Key? Name Type Description
100
 T_TABLE VARCHAR2 Identifier of Source Table
100
 Primary Key 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

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

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

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

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

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

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

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

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

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

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

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