28148
CURRENT_HAUL
CURRENT HAUL
Entity
Published / External
28125
AFSC/FMA/Current Observer Data Interface
Data Set
In Work
This table contains the transformed haul data for presentation to the AKRO catch accounting. The table is populated and maintained through a combination of NORPAC trigger code and OBSINT procedural code. The chain of events is as follows: INSERT, UPDATE - The ATL_HAUL_OBSINT_AIUDR_T adds haul primary key records to the temp_haul table. A periodic process calls the procedure execute_load_current_haul which controls the extraction and transformation of norpac.atl_haul records for insert or update into current haul. On Delete from ATL_HAUL the trigger performs a cross schema cascade delete to temp_haul and current haul.
Present haul data that have been loaded into production to fishery managers and vessel owners prior the the finalization of those data by debriefing
Temporal
2008 AND FORWARD
Spatial
BS, AI, BSAI, GOA
Stratum
OBSERVER, CURRENT DATA, FISHERY STATISTICS
Fisheries Monitoring and Analysis
Seattle
WA
USA
Alaska Fisheries Science Center
Data Table
Yes
Haul
Obsint
This table contains the transformed haul data for presentation to the AKRO catch accounting. The table is populated and maintained through a combination of NORPAC trigger code and OBSINT procedural code. The chain of events is as follows: INSERT, UPDATE - The ATL_HAUL_OBSINT_AIUDR_T adds haul primary key records to the temp_haul table. A periodic process calls the procedure execute_load_current_haul which controls the extraction and transformation of norpac.atl_haul records for insert or update into current haul. On Delete from ATL_HAUL the trigger perfoms a cross schema cascade delete to temp_haul and current haul.
LANDING_REPORT_ID_HASH
VARCHAR2
No
No
Active
The landing report id hash is utilized by AKRO to identify changes to the list of eLanding report ids associated with a haul. 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.
1
T_TABLE
VARCHAR2
3
No
No
Active
Identifier of Source Table
5
Cruise
NUMBER
8
Yes
No
8
0
Active
Sequence generated by Norpac and supplied to the observer as an unique identifier for a processing plant observer cruise record
Integer
10
Permit
VARCHAR2
6
Yes
No
Active
Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
Character
Upper
15
VESSEL
VARCHAR2
6
No
No
Active
VessPlnt code from old NORPAC system plus new vessels recorded in ATL_LOV_Vessel. This code may ultimately be retired, but is essential to the transitional ETL from Atlas to Inseason and Domestic.
Character
Upper
20
HAUL_SEQ
Number
8
No
No
8
0
Active
Sequence generated unique identifier for a haul record
Integer
25
TRIP_SEQ
Number
8
No
No
8
0
Active
Sequence generated unique identifier for a trip as defined in ATL_fma_trip.
Integer
30
HAUL_DATE
DATE
8
No
No
Active
Date of haul retrieval.
Date
35
HAUL
Number
6
No
No
6
0
Active
Number which is entered by the observer identifying a unique haul within a trip.
Integer
40
HAUL_PURPOSE_CODE
VARCHAR2
3
No
No
Active
Haul data may be utilized for catch accounting, stock assessment, or for various special projects. This field is entered by the observer and not validated by ATLAS. Validation is performed when loaded into the production NORPAC data set.
Character
45
GEAR_TYPE
Number
2
2
No
No
2
0
Active
Integer
50
PERFORMANCE
NUMBER
2
No
No
2
0
Active
Unique performance code for a gear type. see ATL_LOV_gear_perfomrance.
Integer
55
VESSEL_TYPE
Number
2
No
No
2
0
Active
Unique identifier of a vessel type, see ATL_LOV_vessel_type
Integer
60
DEPLOYMENT_DATE
DATE
12
No
No
Active
Date and time of gear deployment
Date
65
DEPLOYMENT_LATITUDE
Number
4
No
No
4
0
Active
Gear deployment position. In Degrees and Minutes
Integer
70
DEPLOYMENT_LONGITUDE_CONVERTED
Number
32
No
No
Active
The conversion of longitude is required of values to the east of the 180th meridian. The configuration within Oracle Spatial uses a 360 degree globe - 179 E must therefore be submitted as 181. The calling program must, as in the conversion to decimal degrees submit latitude to the east of the 180th meridian as a negative number.
Number
75
DEPLOYMENT_E_W
VARCHAR2
1
No
No
Active
Gear deployment position.
Character
Upper
80
FISHING_DEPTH_FATHOMS
Number
32
No
No
Active
Average fishing depth recorded by the observer from the vessel log.
Integer
85
BOTTOM_DEPTH_FATHOMS
Number
32
No
No
Active
Average bottom depth recorded by the observer from the vessel log.
90
RETRIEVAL_DATE
DATE
12
No
No
Active
Date and time of gear retrieval.
95
LOCATION
VARCHAR2
1
No
No
Active
Identifies whether the information in a haul is based on retrieval or delivery (as in a mother ship).
Character
100
LATITUDE
Number
4
No
No
4
0
Active
Retrieval location in Degrees and Minutes
Integer
105
LONGITUDE
Number
5
No
No
5
0
Active
Retrieval location. In Degrees and Minutes
Integer
110
LONGITUDE_CONVERTED
Number
7
No
No
7
0
Active
Retrieval location. The conversion of longitude is required of values to the east of the 180th meridian. The configuration within Oracle Spatial uses a 360 degree globe - 179 E must therefore be submitted as 181. The calling program must, as in the conversion to decimal degrees submit latitude to the east of the 180th meridian as a negative number.
115
E_W
VARCHAR2
1
No
No
Active
Retrieval location.
Character
120
NMFS_AREA
Number
3
No
No
3
0
Active
This attribute is computed using the MDSYS.SDO_GEOMETRY package and an ESRI shape file.
Integer
125
COBLZ_AREA
VARCHAR2
1
No
No
Active
This attribute is computed using the MDSYS.SDO_GEOMETRY package and an ESRI shape file.
Character
Upper
Y, N, NULL
130
VESSEL_ESTIMATE
Number
6
No
No
6
2
Active
Total catch weight in metric tons as recorded in the vessel log.
135
OFFICIAL_TOTAL_CATCH
Number
10
No
No
10
2
Active
Total catch weight as computed from the sum of the extrapolate species composition records. For trawl fisheries in the GOA, prohibited species census data may be back apportioned to hauls which constitute an offload if one exists. OTC will then be computed as the sum of the extrapolated species plus the sum of the back apportioned species.
140
OBSERVER_ESTIMATE
Number
10
No
No
10
2
Active
Total catch weight as estimated by the observer in kgs and converted to MT for this presentation.
145
OBSERVER_ESTIMATE_METHOD
VARCHAR2
1
No
No
Active
Method used to determine the observer estimated catch.
150
DENSITY
Number
10
No
No
10
2
Active
Density used by the observer to determine the total catch weights. Recorded in kgs per m3.
155
CATCHER_BOAT_ADFGv
Number
32
No
No
Active
If this haul was delivered to a mothership or catcher processor, this attibute records the ADFG registration number of that vessel.
160
IFQ
VARCHAR2
1
No
No
Active
Flag which identifies whether fishing is on an IFQ quota with the subsequent application of IFQ rules.
Y, N, NULL
Unknown
165
CDQ_CODE
VARCHAR2
3
No
No
Active
Unique AlphaNumeric code representing a CDQ or research group.
170
SKATES_IN_SET
Number
6
No
No
6
2
Active
Number of skates deployed for longline fishing operations
175
HOOKS_PER_SKATE
NUMBER
6
No
No
6
2
Active
Number of hooks per skate for longline fishing usually calculated as the average number of hooks per segment from the atl_haul_hook_count table.
180
TOTAL_HOOKS_POTS
NUMBER
6
No
No
6
2
Active
Total number of hooks deployed for this haul, usually calculated as the average number of hooks per segment from the atl_haul_hook_count table * the number of skates in set. Or in the case of a pot fishery the total number of pots deployed in a haul.
185
HAUL_SAMPLED_BY
NUMBER
8
No
No
8
0
Active
Identifies where a haul is sampled by an observer and in some cases by which observer. The observer of a haul is not necessarily the primary observer recorded for a cruise.
INTEGER
190
RANDOM_SAMPLE_TABLE
VARCHAR2
1
No
No
Active
Random Sample Reference Table code reference.
195
RANDOM_BREAK_TABLE
VARCHAR2
1
No
No
Active
Random Break Table identifier Currently limted to Y (es) or N(o).
Character
Upper
Y, N, NULL
200
MM_PERCENT_MONITORED
NUMBER
3
No
No
3
0
Active
Percentage of time for this haul where marine mammal monitoring occurred. For fixed gear deployments the valid values are anywhere in the range. For mobile gear deployments the values may be either 0 or 100.
INTEGER
205
BIRD_DETERRENCE
V
2
No
No
Active
Deterrence code from NORPAC bird or mammal deterance tables.
210
PROCESSOR
VARCHAR2
6
No
No
Active
Processor is computed by atl_utilities, and returns the shore plant processor code for catcher vessels who have an offload, and the processor permit for catcher processors and motherships.
Character
215
FISHING_START_DATE
DATE
8
No
No
Active
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.
Date
220
HAUL_JOIN
NUMBER
26
No
No
26
0
Active
Surrogate FK to atl_haul. Composed of concatenation of cruise, permit and haul_seq.
Integer
225
DATE_OF_ENTRY
DATE
8
No
No
Active
Date of entry is now (2010) recorded when a haul is loaded into the Norpac data set. In the case that that value is null then it is computed from the latest load date recorded in atl_record_status.';
Date
230
YEAR
NUMBER
4
4
No
No
4
0
Active
Year is extracted from the haul rettrv_date_time field.
Integer
235
LATDD_END
NUMBER
7
No
No
7
5
Active
Latitude decimal degrees is computed from the retrieval latitude.
Number
240
LONDD_END
NUMBER
8
No
No
8
5
Active
Longitude decimal degrees is computed from the retrieval longitude.
Number
245
LATDD_START
NUMBER
7
No
No
7
5
Active
Latitude decimal degrees is computed from the deployment latitude.
Number
250
LONDD_START
NUMBER
8
No
No
8
5
Active
Longitude decimal degrees is computed from the deployment longitude.
255
RETRV_LONGITUDE_SECONDS
N
2
No
No
2
0
Active
Gear retrieval position.
Integer
260
RETRV_LATITUDE_SECONDS
NUMBER
2
No
No
2
0
Active
Gear retrieval position.
Integer
265
DEPLOY_LATITUDE_SECONDS
NUMBER
2
No
No
2
0
Active
Gear retrieval position.
Integer
270
ATLAS_VERSION
NUMBER
3
No
No
3
2
Active
If this haul data was transmitted from the field. This attribute records the version of the software used.
Number
275
DEPLOYMENT_LONGITUDE
NUMBER
23
No
No
Active
Location of start of haul
Number
280
HAUL_HASH
VARCHAR2
32
No
No
Active
The haul hash is utilized by AKRO to identify changes to a haul 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.
Character
285
SPECIES_HASH
VARCHAR2
32
No
No
Active
The species hash is utilized by AKRO to identify changes to a species composition 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.
Character
290
SALMON_HASH
VARCHAR2
32
No
No
Active
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.
Character
295
FLOW_SCALE_WEIGHT
N
10
No
No
10
3
Active
Actual weight from the flow scale reading for a haul.
Number
296
PRESORT_SAMPLE_HASH
Varchar2
32
No
No
Active
The presort hash is utilized by AKRO to identify changes to presort records. 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.
Upper
EE3CACFD295AAB8A5DD7D975B358F620
null set
gov.noaa.nmfs.inport:28148
Julie Blair
2015-10-23T17:39:27
SysAdmin InPortAdmin
2022-08-09T17:11:13
2016-08-23
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-08-23
1 Year
2017-08-23