Metadata Rubric

100%

6 / 6

Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > North Pacific (NORPAC) Groundfish and Halibut O... > AFSC/FMA/North Pacific Groundfish and Halibut O... >

Table: ATL_OFFLOAD_H

Entity (ENT) | Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:9742 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

This entity represents an offload event at a processing plant or mothership.

Description

This entity represents an offload event at a processing plant or mothership.

Entity Type
Data Table

Data Attribute / Type	Description
SEQ_NUMBER NUMBER	Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, increment by 1 and do not cycle.
CHANGED_BY VARCHAR2	Timestamp of change to transaction record.
DATE_CHANGED DATE	Oracle user who made a change to the transaction table record.
CRUISE NUMBER	Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
OFFLOAD_SEQ NUMBER	Sequence generated unique identifier for an offload record
OFFLOAD_NUMBER NUMBER	Identifier of an offload within an observer cruise entered by the observer. The value of this user defined column must be unique within a Cruise-Permit combination.
TRIP_SEQ NUMBER	Sequence generated unique identifier of a trip
PLANT_SEQ NUMBER	Optional FK to Plant. Part of arc involving catcher vessel, haul, and cruise plant. Code identifying a processing plant - inherited from the NORPAC data set. The plant seq is an autogenerated unique identifier.
CRUISE_PLANT_SEQ NUMBER	Sequence generated unique value for a cruise plant record.
DELIVERY_VESSEL_ADFG VARCHAR2	ADFG number entered by the observer if the delivering vessel does not exist in the vessel lookup table.
GEAR_TYPE_CODE NUMBER	Numeric value from Norpac Domestic Gear that combined with the Form defines the unique identifier for a gear record
GEARTYPE_FORM VARCHAR2	Form that the gear is valid for. For example the gear may be Unknown for a delivery but will always be determined for a haul.
DELIVERY_END_DATE DATE	Date the delivery was complete.
NMFS_AREA VARCHAR2	NMFS Reporting Area
DELIVERED_WEIGHT NUMBER	Total weight of the delivery recorded in kilograms or lbs.
TOTAL_POLLOCK_WEIGHT NUMBER	Identifies the total weight of pollock delivered recorded in kilograms or lbs.
LB_MT VARCHAR2	Pounds (Lb) or Kilogram (KG) identifier of weight.
GROUNDFISH_WEIGHED_FLAG VARCHAR2	Identifies whether or not all the groundfish were weighed.
SORTED_AT_SEA_FLAG VARCHAR2	Identifies catch sorted by the catcher vessel at sea.
OFFLOAD_TO_TENDER_FLAG VARCHAR2	Identifies if a tender was used to make this delivery.
PERMIT VARCHAR2	Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
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.
CDQ_CODE VARCHAR2	Unique Alphanumeric code representing a CDQ group
PGM_CODE NUMBER	Unique Identifier of a valid catcher vessel landing management program.

Data Attribute / Type

Description

SEQ_NUMBER
NUMBER

Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, increment by 1 and do not cycle.

CHANGED_BY
VARCHAR2

Timestamp of change to transaction record.

DATE_CHANGED
DATE

Oracle user who made a change to the transaction table record.

CRUISE
NUMBER

Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.

OFFLOAD_SEQ
NUMBER

Sequence generated unique identifier for an offload record

OFFLOAD_NUMBER
NUMBER

Identifier of an offload within an observer cruise entered by the observer. The value of this user defined column must be unique within a Cruise-Permit combination.

TRIP_SEQ
NUMBER

Sequence generated unique identifier of a trip

PLANT_SEQ
NUMBER

Optional FK to Plant. Part of arc involving catcher vessel, haul, and cruise plant. Code identifying a processing plant - inherited from the NORPAC data set. The plant seq is an autogenerated unique identifier.

CRUISE_PLANT_SEQ
NUMBER

Sequence generated unique value for a cruise plant record.

DELIVERY_VESSEL_ADFG
VARCHAR2

ADFG number entered by the observer if the delivering vessel does not exist in the vessel lookup table.

GEAR_TYPE_CODE
NUMBER

Numeric value from Norpac Domestic Gear that combined with the Form defines the unique identifier for a gear record

GEARTYPE_FORM
VARCHAR2

Form that the gear is valid for. For example the gear may be Unknown for a delivery but will always be determined for a haul.

DELIVERY_END_DATE
DATE

Date the delivery was complete.

NMFS_AREA
VARCHAR2

NMFS Reporting Area

DELIVERED_WEIGHT
NUMBER

Total weight of the delivery recorded in kilograms or lbs.

TOTAL_POLLOCK_WEIGHT
NUMBER

Identifies the total weight of pollock delivered recorded in kilograms or lbs.

LB_MT
VARCHAR2

Pounds (Lb) or Kilogram (KG) identifier of weight.

GROUNDFISH_WEIGHED_FLAG
VARCHAR2

Identifies whether or not all the groundfish were weighed.

SORTED_AT_SEA_FLAG
VARCHAR2

Identifies catch sorted by the catcher vessel at sea.

OFFLOAD_TO_TENDER_FLAG
VARCHAR2

Identifies if a tender was used to make this delivery.

PERMIT
VARCHAR2

Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau

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.

CDQ_CODE
VARCHAR2

Unique Alphanumeric code representing a CDQ group

PGM_CODE
NUMBER

Unique Identifier of a valid catcher vessel landing management program.

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

Title:	Table: ATL_OFFLOAD_H
Short Name:	ATL_OFFLOAD_H
Status:	Completed
Abstract:	This entity represents an offload event at a processing plant or mothership.
Purpose:	Histories of all changes to data are maintained by trigger code on the parent table; allowing change control by user and datetime for all updates and delete events.
Notes:	Loaded by batch 2390, 06-30-2009 16:11

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	NORPAC
Description:	This entity represents an offload event at a processing plant or mothership.

Attribute Summary

	Name	Type	Description
100	SEQ_NUMBER	NUMBER	Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, increment by 1 and do not cycle.
100	CHANGED_BY	VARCHAR2	Timestamp of change to transaction record.
100	DATE_CHANGED	DATE	Oracle user who made a change to the transaction table record.
100	CRUISE	NUMBER	Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
100	OFFLOAD_SEQ	NUMBER	Sequence generated unique identifier for an offload record
100	OFFLOAD_NUMBER	NUMBER	Identifier of an offload within an observer cruise entered by the observer. The value of this user defined column must be unique within a Cruise-Permit combination.
100	TRIP_SEQ	NUMBER	Sequence generated unique identifier of a trip
100	PLANT_SEQ	NUMBER	Optional FK to Plant. Part of arc involving catcher vessel, haul, and cruise plant. Code identifying a processing plant - inherited from the NORPAC data set. The plant seq is an autogenerated unique identifier.
100	CRUISE_PLANT_SEQ	NUMBER	Sequence generated unique value for a cruise plant record.
100	DELIVERY_VESSEL_ADFG	VARCHAR2	ADFG number entered by the observer if the delivering vessel does not exist in the vessel lookup table.
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	GEARTYPE_FORM	VARCHAR2	Form that the gear is valid for. For example the gear may be Unknown for a delivery but will always be determined for a haul.
100	DELIVERY_END_DATE	DATE	Date the delivery was complete.
100	NMFS_AREA	VARCHAR2	NMFS Reporting Area
100	DELIVERED_WEIGHT	NUMBER	Total weight of the delivery recorded in kilograms or lbs.
100	TOTAL_POLLOCK_WEIGHT	NUMBER	Identifies the total weight of pollock delivered recorded in kilograms or lbs.
100	LB_MT	VARCHAR2	Pounds (Lb) or Kilogram (KG) identifier of weight.
100	GROUNDFISH_WEIGHED_FLAG	VARCHAR2	Identifies whether or not all the groundfish were weighed.
100	SORTED_AT_SEA_FLAG	VARCHAR2	Identifies catch sorted by the catcher vessel at sea.
100	OFFLOAD_TO_TENDER_FLAG	VARCHAR2	Identifies if a tender was used to make this delivery.
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	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	CDQ_CODE	VARCHAR2	Unique Alphanumeric code representing a CDQ group
100	PGM_CODE	NUMBER	Unique Identifier of a valid catcher vessel landing management program.

Name

Type

Description

100

SEQ_NUMBER

NUMBER

Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, increment by 1 and do not cycle.

100

CHANGED_BY

VARCHAR2

Timestamp of change to transaction record.

100

DATE_CHANGED

DATE

Oracle user who made a change to the transaction table record.

100

CRUISE

NUMBER

Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.

100

OFFLOAD_SEQ

NUMBER

Sequence generated unique identifier for an offload record

100

OFFLOAD_NUMBER

NUMBER

Identifier of an offload within an observer cruise entered by the observer. The value of this user defined column must be unique within a Cruise-Permit combination.

100

TRIP_SEQ

NUMBER

Sequence generated unique identifier of a trip

100

PLANT_SEQ

NUMBER

100

CRUISE_PLANT_SEQ

NUMBER

Sequence generated unique value for a cruise plant record.

100

DELIVERY_VESSEL_ADFG

VARCHAR2

ADFG number entered by the observer if the delivering vessel does not exist in the vessel lookup table.

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

GEARTYPE_FORM

VARCHAR2

Form that the gear is valid for. For example the gear may be Unknown for a delivery but will always be determined for a haul.

100

DELIVERY_END_DATE

DATE

Date the delivery was complete.

100

NMFS_AREA

VARCHAR2

NMFS Reporting Area

100

DELIVERED_WEIGHT

NUMBER

Total weight of the delivery recorded in kilograms or lbs.

100

TOTAL_POLLOCK_WEIGHT

NUMBER

Identifies the total weight of pollock delivered recorded in kilograms or lbs.

100

LB_MT

VARCHAR2

Pounds (Lb) or Kilogram (KG) identifier of weight.

100

GROUNDFISH_WEIGHED_FLAG

VARCHAR2

Identifies whether or not all the groundfish were weighed.

100

SORTED_AT_SEA_FLAG

VARCHAR2

Identifies catch sorted by the catcher vessel at sea.

100

OFFLOAD_TO_TENDER_FLAG

VARCHAR2

Identifies if a tender was used to make this delivery.

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

LANDING_REPORT_ID

NUMBER

100

CDQ_CODE

VARCHAR2

Unique Alphanumeric code representing a CDQ group

100

PGM_CODE

NUMBER

Unique Identifier of a valid catcher vessel landing management program.

Attribute Details

SEQ_NUMBER

CC ID: 38853

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	Yes
Precision:	10
Scale:	0
Status:	Active
Description:	Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, increment by 1 and do not cycle.
General Data Type:	NUMBER

CHANGED_BY

CC ID: 38835

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	Timestamp of change to transaction record.
General Data Type:	VARCHAR2

DATE_CHANGED

CC ID: 38838

Seq. Order:	3
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Oracle user who made a change to the transaction table record.
General Data Type:	DATE

CRUISE

CC ID: 38836

Seq. Order:	4
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	22
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:	NUMBER

OFFLOAD_SEQ

CC ID: 38849

Seq. Order:	5
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	22
Scale:	0
Status:	Active
Description:	Sequence generated unique identifier for an offload record
General Data Type:	NUMBER

OFFLOAD_NUMBER

CC ID: 38848

Seq. Order:	6
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	22
Scale:	0
Status:	Active
Description:	Identifier of an offload within an observer cruise entered by the observer. The value of this user defined column must be unique within a Cruise-Permit combination.
General Data Type:	NUMBER

TRIP_SEQ

CC ID: 38856

Seq. Order:	7
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	22
Scale:	0
Status:	Active
Description:	Sequence generated unique identifier of a trip
General Data Type:	NUMBER

PLANT_SEQ

CC ID: 38852

Seq. Order:	8
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	22
Scale:	0
Status:	Active
Description:	Optional FK to Plant. Part of arc involving catcher vessel, haul, and cruise plant. Code identifying a processing plant - inherited from the NORPAC data set. The plant seq is an autogenerated unique identifier.
General Data Type:	NUMBER

CRUISE_PLANT_SEQ

CC ID: 38837

Seq. Order:	9
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	22
Scale:	0
Status:	Active
Description:	Sequence generated unique value for a cruise plant record.
General Data Type:	NUMBER

DELIVERY_VESSEL_ADFG

CC ID: 38841

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	ADFG number entered by the observer if the delivering vessel does not exist in the vessel lookup table.
General Data Type:	VARCHAR2

GEAR_TYPE_CODE

CC ID: 38843

Seq. Order:	11
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	22
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:	NUMBER

GEARTYPE_FORM

CC ID: 38842

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Form that the gear is valid for. For example the gear may be Unknown for a delivery but will always be determined for a haul.
General Data Type:	VARCHAR2

DELIVERY_END_DATE

CC ID: 38840

Seq. Order:	13
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date the delivery was complete.
General Data Type:	DATE

NMFS_AREA

CC ID: 38847

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	NMFS Reporting Area
General Data Type:	VARCHAR2

DELIVERED_WEIGHT

CC ID: 38839

Seq. Order:	15
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	22
Scale:	0
Status:	Active
Description:	Total weight of the delivery recorded in kilograms or lbs.
General Data Type:	NUMBER

TOTAL_POLLOCK_WEIGHT

CC ID: 38855

Seq. Order:	16
Data Storage Type:	NUMBER
Max Length:	22
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:	NUMBER

LB_MT

CC ID: 38846

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Pounds (Lb) or Kilogram (KG) identifier of weight.
General Data Type:	VARCHAR2

GROUNDFISH_WEIGHED_FLAG

CC ID: 38844

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Identifies whether or not all the groundfish were weighed.
General Data Type:	VARCHAR2

SORTED_AT_SEA_FLAG

CC ID: 38854

Seq. Order:	19
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Identifies catch sorted by the catcher vessel at sea.
General Data Type:	VARCHAR2

OFFLOAD_TO_TENDER_FLAG

CC ID: 38850

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Identifies if a tender was used to make this delivery.
General Data Type:	VARCHAR2

PERMIT

CC ID: 38851

Seq. Order:	21
Data Storage Type:	VARCHAR2
Max Length:	6
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:	VARCHAR2

LANDING_REPORT_ID

CC ID: 38845

Seq. Order:	22
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
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:	NUMBER

CDQ_CODE

CC ID: 786824

Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique Alphanumeric code representing a CDQ group

PGM_CODE

CC ID: 786848

Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique Identifier of a valid catcher vessel landing management program.

Catalog Item ID:	9742
GUID:	gov.noaa.nmfs.inport:9742
Metadata Record Created By:	Doug Turnbull
Metadata Record Created:	2009-06-30 16:11+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2018-09-26
Owner Org:	AFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2018-09-26
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2019-09-26

Table: ATL_OFFLOAD_H

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

SEQ_NUMBER

CHANGED_BY

DATE_CHANGED

CRUISE

OFFLOAD_SEQ

OFFLOAD_NUMBER

TRIP_SEQ

PLANT_SEQ

CRUISE_PLANT_SEQ

DELIVERY_VESSEL_ADFG

GEAR_TYPE_CODE

GEARTYPE_FORM

DELIVERY_END_DATE

NMFS_AREA

DELIVERED_WEIGHT

TOTAL_POLLOCK_WEIGHT

LB_MT

GROUNDFISH_WEIGHED_FLAG

SORTED_AT_SEA_FLAG

OFFLOAD_TO_TENDER_FLAG

PERMIT

LANDING_REPORT_ID

CDQ_CODE

PGM_CODE

Catalog Details