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_OFFLOAD

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:28423  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Keywords
Physical Location
Entity Info
Data Attributes
Support Roles
Catalog Details

Summary

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

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.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
T_TABLE
VARCHAR2 		Identifier of Source Table. Offload statistics are sourced directly offloads, but this is a convention of all the current tables.
OFFLOAD_JOIN
NUMBER 		Surrogate FK to offload if salmon record is so derived Composed of the concatenation of cruise, permit and offloadl_seq.
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.
CDQ_CODE
VARCHAR2 		Unique AlphaNumeric code representing a CDQ or research group
PGM_CODE
VARCHAR2 		Unique Identifier of a valid catcher vessel landing management program.
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.
OFFLOAD_SEQ
NUMBER 		Sequence generated unique identifier for an offload record
CRUISE
NUMBER 		Sequence generated by Norpac and supplied to the observer as an unique identifier for a processing plant observer cruise record
PERMIT
VARCHAR2 		Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
OFFLOAD_NUMBER
NUMBER 		Unique offload for an observer cruise entered by the observer. The number must be unique within a cruise/permit combination.
PLANT_SEQ
NUMBER 		Sequence generated unique identifier for a processing plant.
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.
PLANT_NAME
VARCHAR2 		Name of a processing plant - inherited from the NORPAC data set
GEAR_TYPE_CODE
NUMBER 		Numeric value from Norpac Domestic Gear that combined with the Form defines the unique identifier for a gear record
NMFS_AREA
VARCHAR 		NMFS Reporting Area
DELIVERED_WEIGHT_IN_KG
NUMBER 		Identifies the total weight of all species delivered recorded in kilograms.
TOTAL_POLLOCK_WEIGHT_IN_KG
NUMBER 		Identifies the total weight of pollock delivered recorded in kilograms.
DELIVERY_END_DATE
DATE 		Date the delivery was complete.
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.
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.
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.
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.

Child Items

No Child Items for this record.

Contact Information

Point of Contact
Julie A Blair
julie.blair@noaa.gov
206 526 4053

Metadata Contact
Renold E Narita
ren.narita@noaa.gov

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