7543
Table: OFFLOAD
OFFLOAD
Entity
Published / External
7283
AFSC/FMA/ATLAS Remote Client
Data Set
Completed
This entity represents an offload event at a processing plant or mothership.
Loaded by batch 2204, 03-28-2008 14:09
Data Table
Yes
TURNBULLD
This entity represents an offload event at a processing plant or mothership.
1
OFFLOAD_SEQ
NUMBER
22
Yes
Yes
9
0
Active
Sequence generated unique identifier for an offload record
NUMBER
2
OFFLOAD_NUMBER
NUMBER
22
Yes
No
38
Active
Unique offload for an observer cruise entered by the observer.
NUMBER
3
TRIP_SEQ
NUMBER
22
No
No
9
0
Active
Sequence generated unique identifier of a trip
NUMBER
TURNBULLD.FMA_TRIP
4
PLANT_SEQ
NUMBER
22
No
No
9
0
Active
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.
NUMBER
TURNBULLD.LOV_PLANT
5
CRUISE_PLANT_SEQ
NUMBER
22
No
No
9
0
Active
Sequence generated unique value for a cruise plant record.
NUMBER
TURNBULLD.CRUISE_PLANT
6
DELIVERY_VESSEL_ADFG
VARCHAR2
6
No
No
Active
ADFG number entered by the observer if the delivering vessel does not exist in the vessel lookup table.
VARCHAR2
7
GEAR_TYPE_CODE
NUMBER
22
No
No
38
Active
Numeric value from Norpac Domestic Gear that combined with the Form defines the unique identifier for a gear record
NUMBER
TURNBULLD.LOV_GEAR_TYPE
8
GEARTYPE_FORM
VARCHAR2
1
No
No
Active
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.
VARCHAR2
TURNBULLD.LOV_GEAR_TYPE
9
DELIVERY_END_DATE
DATE
7
No
No
Active
Date the delivery was complete.
DATE
10
NMFS_AREA
VARCHAR2
3
No
No
Active
NMFS Reporting Area
VARCHAR2
11
DELIVERED_WEIGHT
NUMBER
22
No
No
10
3
Active
Total weight of the delivery
NUMBER
12
TOTAL_POLLOCK_WEIGHT
NUMBER
22
No
No
10
3
Active
Identifies the total weight of pollock delivered
NUMBER
13
LB_MT
VARCHAR2
2
No
No
Active
Pounds (LB) or Metric Tons (MT) identifier of weight.
VARCHAR2
14
GROUNDFISH_WEIGHED_FLAG
VARCHAR2
1
No
No
Active
Identifies whether or not all the groundfish were weighed.
VARCHAR2
15
SORTED_AT_SEA_FLAG
VARCHAR2
1
Yes
No
Active
Identifies catch sorted by the catcher vessel at sea.
VARCHAR2
16
OFFLOAD_TO_TENDER_FLAG
VARCHAR2
1
No
No
Active
Identifies if a tender was used to make this delivery.
VARCHAR2
gov.noaa.nmfs.inport:7543
Doug Turnbull
2008-03-28T14:10:01
SysAdmin InPortAdmin
2022-08-09T17:11:01
2016-05-04
Alaska Fisheries Science Center
AFSC
7600 Sand Point Way N.E., Building 4
Seattle
WA
98115
USA
http://www.afsc.noaa.gov
0700-1700 Pacific Time
1001
Public
No
2016-05-04
1 Year
2017-05-04