Slide Menu
Maintenance Notice: Tuesday May 21 @ 12pm-1:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.3.6. Downtime Schedule Tuesday, May 21, 2024 12:00pm - 1:30pm Eastern / 9:00am - 10:30am Pacific / 6:00am - 8:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: h...
View All
Search Help Show/Hide Menu

Item Identification

Title: CURRENT_OFFLOAD
Short Name: CURRENT_OFFLOAD
Status: In Work
Abstract:

This entity represent the offload of a vessel which is observed by the observer assigned to the processing plant. The data comes from ATL_Offload

Purpose:

Provide a view of production Observer offloads for inseason fishery management with identifies changed data values with a computed hash.

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 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: CURRENT_OFFLOAD
Schema Name: OBSINT
Description:

This entity represent 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.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
T_TABLE VARCHAR2 Identifier of Source Table. Offload statistics are sourced directly offloads, but this is a convention of all the current tables.
100
OFFLOAD_JOIN NUMBER Surrogate FK to offload if salmon record is so derived Composed of the concatenation of cruise, permit and offloadl_seq.
100
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
CDQ_CODE VARCHAR2 Unique AlphaNumeric code representing a CDQ or research group
100
PGM_CODE VARCHAR2 Unique Identifier of a valid catcher vessel landing management program.
100
LANDING_REPORT_ID NUMBER The Alaska Regional Office 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
OFFLOAD_SEQ NUMBER Sequence generated unique identifier for an offload record
100
CRUISE NUMBER Sequence generated by Norpac and supplied to the observer as an unique identifier for a processing plant observer cruise record
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
OFFLOAD_NUMBER NUMBER Unique offload for an observer cruise entered by the observer. The number must be unique within a cruise/permit combination.
100
PLANT_SEQ NUMBER Sequence generated unique identifier for a processing plant.
100
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.
100
PLANT_NAME VARCHAR2 Name of a processing plant - inherited from the NORPAC data set
100
GEAR_TYPE_CODE NUMBER Numeric value from Norpac Domestic Gear that combined with the Form defines the unique identifier for a gear record
100
NMFS_AREA VARCHAR NMFS Reporting Area
100
DELIVERED_WEIGHT_IN_KG NUMBER Identifies the total weight of all species delivered recorded in kilograms.
100
TOTAL_POLLOCK_WEIGHT_IN_KG NUMBER Identifies the total weight of pollock delivered recorded in kilograms.
100
DELIVERY_END_DATE DATE Date the delivery was complete.
100
LAST_MODIFIED_DATE DATE Everytime an offload record from the production schema is processed the the obsint.load_current_offload the processing datetime is recorded here. This does not necessarily mean the current offload record was modified as the program processes every offload within a cruise permit when initiated.
100
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
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
SALMON_HASH 32 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

T_TABLE

CC ID: 241741
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 32
Required: No
Primary Key: No
Status: Active
Description:

Identifier of Source Table. Offload statistics are sourced directly offloads, but this is a convention of all the current tables.

General Data Type: Character
Case Restriction: Upper

OFFLOAD_JOIN

CC ID: 241742
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 20
Required: Yes
Primary Key: No
Precision: 20
Scale: 0
Status: Active
Description:

Surrogate FK to offload if salmon record is so derived Composed of the concatenation of cruise, permit and offloadl_seq.

General Data Type: INTEGER

DELIVERY_VESSEL_ADFG

CC ID: 241743
Seq. Order: 20
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
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: CHARACTER

CDQ_CODE

CC ID: 241744
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Unique AlphaNumeric code representing a CDQ or research group

General Data Type: CHARACTER

PGM_CODE

CC ID: 241745
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Unique Identifier of a valid catcher vessel landing management program.

General Data Type: CHARACTER

LANDING_REPORT_ID

CC ID: 241747
Seq. Order: 35
Data Storage Type: NUMBER
Max Length: 10
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

The Alaska Regional Office 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: INTEGER

OFFLOAD_SEQ

CC ID: 241748
Seq. Order: 40
Data Storage Type: NUMBER
Max Length: 9
Required: No
Primary Key: No
Precision: 9
Scale: 0
Status: Active
Description:

Sequence generated unique identifier for an offload record

General Data Type: INTEGER

CRUISE

CC ID: 241763
Seq. Order: 45
Data Storage Type: NUMBER
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 a processing plant observer cruise record

General Data Type: INTEGER

PERMIT

CC ID: 241769
Seq. Order: 50
Data Storage Type: VARCHAR2
Max Length: 7
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: CHARACTER

OFFLOAD_NUMBER

CC ID: 241770
Seq. Order: 55
Data Storage Type: NUMBER
Max Length: 5
Required: No
Primary Key: No
Precision: 5
Scale: 0
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: INTEGER

PLANT_SEQ

CC ID: 241772
Seq. Order: 60
Data Storage Type: NUMBER
Max Length: 9
Required: Yes
Primary Key: No
Precision: 9
Scale: 0
Status: Active
Description:

Sequence generated unique identifier for a processing plant.

General Data Type: INTEGER

PLANT_CODE

CC ID: 241775
Seq. Order: 65
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
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: CHARACTER

PLANT_NAME

CC ID: 241776
Seq. Order: 70
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Name of a processing plant - inherited from the NORPAC data set

General Data Type: CHARACTER

GEAR_TYPE_CODE

CC ID: 241777
Seq. Order: 75
Data Storage Type: NUMBER
Max Length: 3
Required: No
Primary Key: No
Precision: 3
Scale: 0
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: INTEGER

NMFS_AREA

CC ID: 241779
Seq. Order: 80
Data Storage Type: VARCHAR
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

NMFS Reporting Area

General Data Type: CHARACTER

DELIVERED_WEIGHT_IN_KG

CC ID: 241781
Seq. Order: 85
Data Storage Type: NUMBER
Max Length: 10
Required: No
Primary Key: No
Precision: 10
Scale: 3
Status: Active
Description:

Identifies the total weight of all species delivered recorded in kilograms.

General Data Type: NUMBER

TOTAL_POLLOCK_WEIGHT_IN_KG

CC ID: 241782
Seq. Order: 90
Data Storage Type: NUMBER
Max Length: 10
Required: No
Primary Key: No
Precision: 10
Scale: 3
Status: Active
Description:

Identifies the total weight of pollock delivered recorded in kilograms.

General Data Type: NUMBER

DELIVERY_END_DATE

CC ID: 241783
Seq. Order: 95
Data Storage Type: DATE
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

Date the delivery was complete.

General Data Type: DATE

LAST_MODIFIED_DATE

CC ID: 241784
Seq. Order: 100
Data Storage Type: DATE
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

Everytime an offload record from the production schema is processed the the obsint.load_current_offload the processing datetime is recorded here. This does not necessarily mean the current offload record was modified as the program processes every offload within a cruise permit when initiated.

General Data Type: DATE

FISHING_START_DATE

CC ID: 241785
Seq. Order: 105
Data Storage Type: DATE
Max Length: 12
Required: No
Primary Key: No
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: DATE

OFFLOAD_HASH

CC ID: 241786
Seq. Order: 110
Data Storage Type: VARCHAR2
Max Length: 32
Required: No
Primary Key: No
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: CHARACTER

SALMON_HASH

CC ID: 241787
Seq. Order: 115
Data Storage Type: 32
Max Length: 32
Required: No
Primary Key: No
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: CHARACTER

Support Roles

Data Steward

CC ID: 241655
Date Effective From: 2008
Date Effective To:
Contact (Person): Narita, Renold E
Email Address: ren.narita@noaa.gov
Contact Instructions:

Email

Data Steward

CC ID: 241659
Date Effective From: 2008
Date Effective To:
Contact (Person): Blair, Julie A
Address: 7600 Sandpoint Way NE
Seattle, WA 98115
USA
Email Address: julie.blair@noaa.gov
Phone: 206 526 4053
Fax: (206)526-4066
Business Hours: 0700-1630
Contact Instructions:

Email

Distributor

CC ID: 241657
Date Effective From: 2008
Date Effective To:
Contact (Person): Blair, Julie A
Address: 7600 Sandpoint Way NE
Seattle, WA 98115
USA
Email Address: julie.blair@noaa.gov
Phone: 206 526 4053
Fax: (206)526-4066
Business Hours: 0700-1630
Contact Instructions:

Email

Metadata Contact

CC ID: 241658
Date Effective From: 2008
Date Effective To:
Contact (Person): Narita, Renold E
Email Address: ren.narita@noaa.gov
Contact Instructions:

Email

Point of Contact

CC ID: 241656
Date Effective From: 2008
Date Effective To:
Contact (Person): Blair, Julie A
Address: 7600 Sandpoint Way NE
Seattle, WA 98115
USA
Email Address: julie.blair@noaa.gov
Phone: 206 526 4053
Fax: (206)526-4066
Business Hours: 0700-1630
Contact Instructions:

Email

Catalog Details

Catalog Item ID: 28423
GUID: gov.noaa.nmfs.inport:28423
Metadata Record Created By: Julie A Blair
Metadata Record Created: 2015-10-30 14:25+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