DEBRIEFED OFFLOAD
Alaska Fisheries Science Center
Entity
(ENT)
| ID: 22441
| Published / External
Created: 2014-11-05
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 10657
ID: 22441
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | DEBRIEFED OFFLOAD |
---|---|
Short Name | DEBRIEFED_OFFLOAD |
* Status | In Work |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
This entity represents the offload of a vessel which is observed by the observer assigned to the processing plant. The data comes from ATL_Offload, and does not include offloads recorded by vessel observers. |
* Purpose |
Provides a flattened and denormalized view of debriefed offload observer data for use by status of stocks authors and other researchers. |
Notes | |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
None | AFSC |
None | DEBRIEFED |
None | DOMESTIC |
None | FMA |
None | GROUNDFISH |
None | HAKE |
None | NORPAC |
None | OBSERVER |
None | OBSINT |
None | POLLOCK |
Temporal Keywords
Thesaurus | Keyword |
---|---|
None | CONTINUOUS |
* Spatial Keywords
Thesaurus | Keyword |
---|---|
None | AI |
None | ALASKA |
None | BS |
None | BSAI |
None | GOA |
None | NORTH PACIFIC |
Stratum Keywords
Thesaurus | Keyword |
---|---|
None | DEMERSAL |
None | FIXED |
None | MOBILE |
None | OCEANIC |
None | PELEGIC |
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | Alaska Fisheries Science Center |
---|---|
• » City | Seattle |
• » State/Province | WA |
• Country | USA |
• » Location Description |
Entity Information
Entity Type | Data Table |
---|---|
Active Version? | |
Alias | debriefed_haul |
Schema Name | obsint |
» Description |
This entity represents the offload of a vessel which is observed by the observer assigned to the processing plant. The data comes from ATL_Offload, and does not include offloads recorded by vessel observers. |
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 | Yes | No | OFFLOAD_JOIN | number | Surrogate FK to offload if salmon record is so derived Composed of concatenation of cruise, permit and offloadl_seq. |
100 | No | No | DELIVERY_VESSEL_ADFG | varchar2 | ADFG number which may be entered by the plant observer without validation, this value is not internally validated at the time of entry. |
100 | No | No | CDQ_CODE | varchar2 | Unique AlphaNumeric code representing a CDQ or research group |
100 | No | No | PGM_CODE | varchar2 | Unique Identifier of a valid catcher vessel landing management program. |
100 | No | No | LANDING_REPORT_ID | number | The region uses the landing report id off the electronic fish ticket as a join column for the catch accounting system. The value is printed on the lower quadrant of every ER fish ticket. Landing_Report_ID is unique to an offload. |
100 | No | No | OFFLOAD_SEQ | number | Sequence generated unique identifier for an offload record |
100 | No | No | CRUISE | number | Sequence generated by Norpac and supplied to the observer as an unique identifier for a processing plant observer cruise record |
100 | No | No | PERMIT | VARCHAR2 | Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau |
100 | No | No | OFFLOAD_NUMBER | NUMBER | Unique offload for an observer cruise entered by the observer. The number must be unique within a cruise/permit combination. |
100 | No | No | PLANT_SEQ | NUMBER | Sequence generated unique identifier for a processing plant. |
100 | No | No | PLANT_CODE | VARCHAR2 | VessPlnt code from old NORPAC system plus new plants recorded in ATL_LOV_Plant. This code may ultimately be retired, but is essential to the transitional ETL from Atlas to Inseason and Domestic. |
67 | No | No | PLANT_NAME | VARCHAR2 | |
100 | No | No | GEAR_TYPE_CODE | NUMBER | Numeric value from Norpac Domestic Gear that combined with the Form defines the unique identifier for a gear record |
100 | No | No | NMFS_AREA | VARCHAR2 | NMFS Reporting Area |
100 | No | No | DELIVERED_WEIGHT_IN_KG | NUMBER | Identifies the total weight of all species delivered recorded in kilograms or lbs. |
100 | No | No | TOTAL_POLLOCK_WEIGHT_IN_KG | NUMBER | Identifies the total weight of pollock delivered recorded in kilograms or lbs. |
100 | No | No | DELIVERY_END_DATE | DATE | Date the delivery was complete. |
100 | No | No | LAST_MODIFIED_DATE | DATE | Everytime an offload record from the production schema is processed the the obsint.load_DEBRIEFED_offload the processing datetime is recorded here. This does not necessarily mean the DEBRIEFED offload record was modified as the program processes every offload within a cruise permit when initiated. |
100 | No | No | FISHING_START_DATE | DATE | Fishing start date is defined as the first haul deployment of a trip. If the deployment date is null due to unverifiable observer data then the trip start date is used; if null the default is a mandatory value haul retrieval date. |
100 | No | No | OFFLOAD_HASH | VARCHAR2 | The offload hash is utilized by AKRO to identify changes to an offload record. The hash is created every time that a record is created or updated. Only critical data columns are referenced and change is denoted by a change in the hash value. |
100 | No | No | SALMON_HASH | VARCHAR2 | The salmon hash is utilized by AKRO to identify changes to a salmon retention record. The hash is created every time that a record is created or updated. Only critical data columns are referenced and change is denoted by a change in the hash value. |
Attribute Details
Attribute Name | T_TABLE |
---|---|
Seq. Order | 1 |
Data Storage Type | varchar2 |
Max Length | 20 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Identifier of Source Table |
General Data Type | |
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 | 2 |
Data Storage Type | number |
Max Length | 20 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
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 | |
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 | DELIVERY_VESSEL_ADFG |
---|---|
Seq. Order | 3 |
Data Storage Type | varchar2 |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
ADFG number which may be entered by the plant observer without validation, this value is not internally validated at the time of entry. |
General Data Type | |
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 | CDQ_CODE |
---|---|
Seq. Order | 4 |
Data Storage Type | varchar2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique AlphaNumeric code representing a CDQ or research group |
General Data Type | |
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 | PGM_CODE |
---|---|
Seq. Order | 5 |
Data Storage Type | varchar2 |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique Identifier of a valid catcher vessel landing management program. |
General Data Type | |
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 | LANDING_REPORT_ID |
---|---|
Seq. Order | 6 |
Data Storage Type | number |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The region uses the landing report id off the electronic fish ticket as a join column for the catch accounting system. The value is printed on the lower quadrant of every ER fish ticket. Landing_Report_ID is unique to an offload. |
General Data Type | |
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 | 7 |
Data Storage Type | number |
Max Length | 9 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Sequence generated unique identifier for an offload record |
General Data Type | |
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 | 8 |
Data Storage Type | number |
Max Length | 9 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Sequence generated by Norpac and supplied to the observer as an unique identifier for a processing plant observer cruise record |
General Data Type | |
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 | 9 |
Data Storage Type | VARCHAR2 |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 | |
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_NUMBER |
---|---|
Seq. Order | 10 |
Data Storage Type | NUMBER |
Max Length | 9 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique offload for an observer cruise entered by the observer. The number must be unique within a cruise/permit combination. |
General Data Type | |
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 | PLANT_SEQ |
---|---|
Seq. Order | 11 |
Data Storage Type | NUMBER |
Max Length | 9 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Sequence generated unique identifier for a processing plant. |
General Data Type | |
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 | PLANT_CODE |
---|---|
Seq. Order | 12 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
VessPlnt code from old NORPAC system plus new plants recorded in ATL_LOV_Plant. This code may ultimately be retired, but is essential to the transitional ETL from Atlas to Inseason and Domestic. |
General Data Type | |
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 | PLANT_NAME |
---|---|
Seq. Order | 13 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description | |
General Data Type | |
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 | GEAR_TYPE_CODE |
---|---|
Seq. Order | 14 |
Data Storage Type | NUMBER |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Numeric value from Norpac Domestic Gear that combined with the Form defines the unique identifier for a gear record |
General Data Type | |
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 | NMFS_AREA |
---|---|
Seq. Order | 15 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
NMFS Reporting Area |
General Data Type | |
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 | DELIVERED_WEIGHT_IN_KG |
---|---|
Seq. Order | 16 |
Data Storage Type | NUMBER |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 3 |
Status | Active |
Description |
Identifies the total weight of all species delivered recorded in kilograms or lbs. |
General Data Type | |
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 | TOTAL_POLLOCK_WEIGHT_IN_KG |
---|---|
Seq. Order | 17 |
Data Storage Type | NUMBER |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 3 |
Status | Active |
Description |
Identifies the total weight of pollock delivered recorded in kilograms or lbs. |
General Data Type | |
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 | DELIVERY_END_DATE |
---|---|
Seq. Order | 18 |
Data Storage Type | DATE |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date the delivery was complete. |
General Data Type | |
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 | 19 |
Data Storage Type | DATE |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Everytime an offload record from the production schema is processed the the obsint.load_DEBRIEFED_offload the processing datetime is recorded here. This does not necessarily mean the DEBRIEFED offload record was modified as the program processes every offload within a cruise permit when initiated. |
General Data Type | |
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 | FISHING_START_DATE |
---|---|
Seq. Order | 20 |
Data Storage Type | DATE |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Fishing start date is defined as the first haul deployment of a trip. If the deployment date is null due to unverifiable observer data then the trip start date is used; if null the default is a mandatory value haul retrieval date. |
General Data Type | |
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_HASH |
---|---|
Seq. Order | 21 |
Data Storage Type | VARCHAR2 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The offload hash is utilized by AKRO to identify changes to an offload record. The hash is created every time that a record is created or updated. Only critical data columns are referenced and change is denoted by a change in the hash value. |
General Data Type | |
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_HASH |
---|---|
Seq. Order | 22 |
Data Storage Type | VARCHAR2 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The salmon hash is utilized by AKRO to identify changes to a salmon retention record. The hash is created every time that a record is created or updated. Only critical data columns are referenced and change is denoted by a change in the hash value. |
General Data Type | |
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 | 22441 |
---|---|
Metadata Record Created By | Doug Turnbull |
Metadata Record Created | 2014-11-05 13:36+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 Workflow State | Published / External |
Metadata Last Review Date | 2016-05-18 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2017-05-18 |
Tags |
---|