CURRENT_SALMON
Alaska Fisheries Science Center
Entity
(ENT)
| ID: 28428
| Published / External
Created: 2015-10-30
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 28125
ID: 28428
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | CURRENT_SALMON |
---|---|
Short Name | CURRENT_SALMON |
* Status | In Work |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
This entity records the number of prohibited pacific salmon recorded as bycatch, by species, for an offload or a haul. |
* Purpose | |
Notes | |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
None | 2008 AND FORWARD |
* Spatial Keywords
Thesaurus | Keyword |
---|---|
None | BS, AI, BSAI, GOA |
Stratum Keywords
Thesaurus | Keyword |
---|---|
None | BYCATCH |
None | OBSERVER, CURRENT DATA, FISHERY STATISTICS |
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
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? | Y |
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. |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | Yes | No | T_TABLE | VARCHAR2 | Identifier of Source Table |
100 | No | Yes | 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 | No | No | CRUISE | NUMGER | Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. |
100 | No | No | PERMIT | VARCHAR2 | Unique Code identifying a delivering vessel - inherited from the NORPAC data set and created by the RAM division in Juneau |
100 | No | No | OFFLOAD_SEQ | NUMBER | Optional foreign key identifier from an offload record. Sequence generated unique identifier for an offload record |
100 | No | No | HAUL_SEQ | NUMBER | Optional foreign key column from current_haul |
100 | No | No | SPECIES_CODE | NUMBER | Unique identifier for a species imported from Norpac |
100 | No | No | 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 | No | No | OFFLOAD_JOIN | NUMBER | Surrogate FK to offload if salmon record is so derived Composed of concatenation of cruise, permit and offloadl_seq. |
100 | Yes | No | COUNT | NUMBER | Number of Individual Salmon Observed and Recorded. |
100 | No | No | 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
Attribute Name | T_TABLE |
---|---|
Seq. Order | 10 |
Data Storage Type | VARCHAR2 |
Max Length | 32 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Identifier of Source Table |
General Data Type | CHARACTER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SALMON_SEQ |
---|---|
Seq. Order | 15 |
Data Storage Type | NUMBER |
Max Length | 9 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CRUISE |
---|---|
Seq. Order | 20 |
Data Storage Type | NUMGER |
Max Length | 9 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PERMIT |
---|---|
Seq. Order | 25 |
Data Storage Type | VARCHAR2 |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OFFLOAD_SEQ |
---|---|
Seq. Order | 30 |
Data Storage Type | NUMBER |
Max Length | 9 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | HAUL_SEQ |
---|---|
Seq. Order | 35 |
Data Storage Type | NUMBER |
Max Length | 9 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 9 |
Scale | 0 |
Status | Active |
Description |
Optional foreign key column from current_haul |
General Data Type | INTEGER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SPECIES_CODE |
---|---|
Seq. Order | 40 |
Data Storage Type | NUMBER |
Max Length | 4 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | HAUL_JOIN |
---|---|
Seq. Order | 45 |
Data Storage Type | NUMBER |
Max Length | 20 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OFFLOAD_JOIN |
---|---|
Seq. Order | 50 |
Data Storage Type | NUMBER |
Max Length | 20 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | COUNT |
---|---|
Seq. Order | 55 |
Data Storage Type | NUMBER |
Max Length | 4 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | 4 |
Scale | 0 |
Status | Active |
Description |
Number of Individual Salmon Observed and Recorded. |
General Data Type | INTEGER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LAST_MODIFIED_DATE |
---|---|
Seq. Order | 60 |
Data Storage Type | DATE |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Child Items
Rubric scores updated every 15m
Score | Type | Title |
---|---|---|
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 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 Workflow State | Published / External |
Metadata Last Review Date | 2016-05-04 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2017-05-04 |
Tags |
---|