Metadata Rubric

100%

6 / 6

View Report

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

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 Information

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

Data Attributes

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

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.

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 Details

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

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