18986
Table: ATL_HAUL
ATL_HAUL
Entity
Published / External
18964
AFSC/FMA/NPRB Alternative Catch Monitoring Table and Column Definitions
Data Set
Completed
Hauls are unique fishing events of gear deployment and retrieval and may also contain information unique to a day where no fishing occured.
Loaded by batch 4574, 05-03-2013 17:18
Data Table
Yes
NPRB_1017
Hauls are unique fishing events of gear deployment and retrieval and may also contain information unique to a day where no fishing occured.
1
CRUISE
NUMBER
22
Yes
Yes
9
0
Active
Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
NUMBER
NPRB_1017.ATL_FMA_TRIP
2
HAUL_SEQ
NUMBER
22
Yes
Yes
9
0
Active
Sequence generated unique identifier for a haul record
NUMBER
3
HAUL_NUMBER
NUMBER
22
Yes
No
6
0
Active
Number which is entered by the observer identifying a unique haul within a trip.
NUMBER
4
HAUL_PURPOSE_CODE
VARCHAR2
3
Yes
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.
VARCHAR2
NPRB_1017.ATL_LOV_HAUL_PURPOSE
5
CDQ_CODE
VARCHAR2
3
No
No
Active
Unique AlphaNumeric code representing a CDQ or research group
VARCHAR2
NPRB_1017.ATL_LOV_CDQ
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
TRIP_SEQ
NUMBER
22
Yes
No
38
0
Active
Sequence generated unique identifier of a trip
NUMBER
NPRB_1017.ATL_FMA_TRIP
8
VESSEL_TYPE
NUMBER
22
Yes
No
Active
Unique identifier of a vessel type
NUMBER
NPRB_1017.ATL_LOV_VESSEL_TYPE
9
GEAR_PERFORMANCE_CODE
NUMBER
22
Yes
No
38
Active
Unique performance code for a gear type.
NUMBER
NPRB_1017.ATL_LOV_GEAR_PERFORM
10
GEARTYPE_FORM
VARCHAR2
1
Yes
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
NPRB_1017.ATL_LOV_GEAR_TYPE
11
GEAR_TYPE_CODE
NUMBER
22
Yes
No
38
Active
Numeric value from Norpac Domestic Gear that combined with the Form defines the unique identifier for a gear record
NUMBER
NPRB_1017.ATL_LOV_GEAR_TYPE
12
RBT_CODE
VARCHAR2
1
No
No
Active
Random Break Table identifier Currently limted to Y (es) or N(o)
VARCHAR2
NPRB_1017.ATL_LOV_RBT_CODE
13
RST_CODE
VARCHAR2
1
No
No
Active
Random Sample Reference Table code reference.
VARCHAR2
NPRB_1017.ATL_LOV_RST_CODE
14
DETERRENCE_CODE
VARCHAR2
2
No
No
Active
Deterrence code from NORPAC bird or mammal deterance tables
VARCHAR2
NPRB_1017.ATL_LOV_DETERRENCE
15
ANIMAL_TYPE_CODE
VARCHAR2
1
No
No
Active
Optional FK from LOV_Deterrence. Class of animal mammal (M), bird (B) for which the deterrence (if it exists) was utilized
VARCHAR2
NPRB_1017.ATL_LOV_DETERRENCE
16
LOCATION_CODE
VARCHAR2
1
Yes
No
Active
Identifies whether the information in a haul is based on retrieval or delivery (as in a mother ship)
VARCHAR2
17
RETRV_DATE_TIME
DATE
7
Yes
No
Active
Date recorded by the observer from the vessel log.
DATE
18
RETRV_LATITUDE_DEGREES
NUMBER
22
Yes
No
2
0
Active
Location of gear retrieval.
NUMBER
19
RETRV_LATITUDE_MINUTES
NUMBER
22
Yes
No
2
0
Active
Location of gear retrieval.
NUMBER
20
RETRV_LATITUDE_SECONDS
NUMBER
22
No
No
2
0
Active
Location of gear retrieval.
NUMBER
21
RETRV_EW
VARCHAR2
1
Yes
No
Active
Location of gear retrieval.
VARCHAR2
22
RETRV_LONGITUDE_DEGREES
NUMBER
22
Yes
No
38
0
Active
Location of gear retrieval.
NUMBER
23
RETRV_LONGITUDE_MINUTES
NUMBER
22
Yes
No
2
0
Active
Location of gear retrieval.
NUMBER
24
RETRV_LONGITUDE_SECONDS
NUMBER
22
No
No
2
0
Active
Location of gear retrieval.
NUMBER
25
NMFS_AREA
NUMBER
22
No
No
3
0
Active
This is a calculated value from retrieval lat-long. It is stored for the convenience of the user community.
NUMBER
26
DEPLOY_DATE_TIME
DATE
7
No
No
Active
Date and time recorded by the observer from the vessel log.
DATE
27
DEPLOY_LATITUDE_DEGREES
NUMBER
22
No
No
38
0
Active
Location of gear deployment.
NUMBER
28
DEPLOY_LATITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
Location of gear deployment.
NUMBER
29
DEPLOY_LATITUDE_SECONDS
NUMBER
22
No
No
2
0
Active
Location of gear deployment.
NUMBER
30
DEPLOY_EW
VARCHAR2
1
No
No
Active
Location of gear deployment.
VARCHAR2
31
DEPLOY_LONGITUDE_DEGREES
NUMBER
22
No
No
38
0
Active
Location of gear deployment.
NUMBER
32
DEPLOY_LONGITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
Location of gear deployment.
NUMBER
33
DEPLOY_LONGITUDE_SECONDS
NUMBER
22
No
No
2
0
Active
Location of gear deployment.
NUMBER
34
BOTTOM_DEPTH
NUMBER
22
No
No
5
0
Active
Average bottom depth recorded by the observer from the vessel log.
NUMBER
35
FISHING_DEPTH
NUMBER
22
No
No
5
0
Active
Average fishing depth recorded by the observer from the vessel log.
NUMBER
36
DEPTH_METER_FATHOM
VARCHAR2
1
No
No
Active
Identifies whether depth is recorded in meters or fathoms.
VARCHAR2
37
VESSEL_EST_CATCH
NUMBER
22
No
No
38
2
Active
Total catch weight in metric tons as recorded in the vessel log.
NUMBER
38
OBSVR_EST_CATCH
NUMBER
22
No
No
10
2
Active
Total catch weight as estimated by the observer in kgs.
NUMBER
39
OBSVR_EST_METHOD
VARCHAR2
1
No
No
Active
Method used to determine the observer estimated catch
VARCHAR2
40
OBSVR_EST_DISCARDS
NUMBER
22
No
No
38
2
Active
Observer estimate of total discards in kgs.
NUMBER
41
DENSITY
NUMBER
22
No
No
6
2
Active
Density used by the observer to determine the total catch weights. Recorded in kgs per m3.
NUMBER
42
INDIV_FISHING_QUOTA_FLAG
VARCHAR2
1
Yes
No
Active
Identifies whether fishing is on an IFQ quota with the subsequent application of IFQ rules.
VARCHAR2
43
SAMPLED_BY
NUMBER
22
Yes
No
38
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.
NUMBER
44
NUMBER_OF_SKATES
NUMBER
22
No
No
7
2
Active
Number of skates for longline fishing.
NUMBER
45
NUMBER_OF_HOOKS_PER_SKATE
NUMBER
22
No
No
4
0
Active
Number of hooks per skate for longline fishing.
NUMBER
46
TOTAL_HOOKS
NUMBER
22
No
No
6
0
Active
Total number of hooks deployed for this haul
NUMBER
47
TOTAL_POTS
NUMBER
22
No
No
6
0
Active
Total number of pots deployed for this haul.
NUMBER
48
MMAMMAL_MONITR_PCT
NUMBER
22
No
No
3
0
Active
Percentage of time for this haul where marine mammal monitoring occured. For fixed gear deployments the valid values are anywhere in the range. For mobile gear deployments the values may be either 0 or 100.
NUMBER
49
PERMIT
VARCHAR2
6
Yes
Yes
Active
Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
VARCHAR2
NPRB_1017.ATL_FMA_TRIP
50
VOLUME
NUMBER
22
No
No
38
2
Active
Estimate of volume of catch
NUMBER
51
DATE_OF_ENTRY
DATE
7
No
No
Active
When a haul record is inserted or updated the system date is recorded here. This value is not used for catch or quota purposes, but is useful for identifying errors or ommissions at the haul level by both the Alaska Region and Inseason Advising.
DATE
52
SAMPLE_SYSTEM_CODE
NUMBER
22
No
No
38
Active
Unique numeric identifier of a sample coding system.
NUMBER
NPRB_1017.ATL_LOV_SAMPLE_SYSTE
53
SAMPLE_UNIT_CODE
NUMBER
22
No
No
6
0
Active
Unique code identifying the unit of measure for a sampling design. Sample Design and units are mandatory at the haul level and optional at the sample level.
NUMBER
NPRB_1017.ATL_LOV_SAMPLE_UNIT
54
TOTAL_HOOKS_OVERIDE_FLAG
VARCHAR2
1
No
No
Active
If an observer believes that the calculated value of total hooks is not correct. It is allowed that the value is overridden. If that is the case then this flag will be set to Y by trigger code, and total-hooks will be protected from automatic recalculateion.
VARCHAR2
55
BIRD_HAULBACK_CODE
VARCHAR2
10
No
No
Active
Portion of the haulback that was monitored by the observer for bird interactions.
VARCHAR2
NPRB_1017.ATL_LOV_BIRD_HAULBAC
56
BIRD_SHORTWIRED_FLAG
VARCHAR2
1
No
No
Active
Denoting whether the net was shortwired during the haulback. Do not record a Y when the net is shortwired during the tow but then returned to fishing depth. The purpose of this flag differs from the gear performance code in that interactions between birds and the warps or third wire transducer cable may occur during periods where the cod end is being towed while fish on deck are possessed or in other instances outside of shortwiring for turns or known obstacles.
VARCHAR2
57
UNITS
VARCHAR2
4
No
No
Active
no-comment
VARCHAR2
58
POPULATION_SIZE
NUMBER
22
No
No
16
6
Active
no-comment
NUMBER
59
UNIT_SIZE
NUMBER
22
No
No
16
6
Active
no-comment
NUMBER
60
NUMBER_OF_UNITS_SAMPLED
NUMBER
22
No
No
10
6
Active
no-comment
NUMBER
61
UNITS_IN_POPULATION
NUMBER
22
No
No
10
6
Active
no-comment
NUMBER
gov.noaa.nmfs.inport:18986
Doug Turnbull
2013-05-03T17:18:46
SysAdmin InPortAdmin
2022-08-09T17:11:09
2016-05-18
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-18
1 Year
2017-05-18