Search Help Show/Hide Menu
Metadata Rubric
83%
5 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > AMMOP > AMMOP Oracle database 1999 - 2013 >

AMMOP_HAUL

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:75080  |  Updated: May 21, 2025  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Description

This table contains a list of hauls that occurred during an observers sample.

Entity Information

Data Attribute / Type Description
AIR_TEMP
VARCHAR2(8 BYTE) 		Air temperature at the time of haul. Celsius
COMMENTS
VARCHAR2(2048 BYTE) 		Additional information.
DISTANCE_OBSV_NET_MAXIMUM
VARCHAR2(6 BYTE) 		Maximum distance between the observer vessel and the location of the fishing vessel where the net is hauled aboard for the duration of the haul, in whole meters.
DISTANCE_OBSV_NET_MINIMUM
VARCHAR2(6 BYTE) 		Minimum distance between the observer vessel and the location of the fishing vessel where the net is hauled aboard for the duration of the haul, in whole meters.
DISTANCE_SHORE_MAXIMUM
VARCHAR2(6 BYTE) 		Maximum net distance to shore in meters.
DISTANCE_SHORE_MINIMUM
VARCHAR2(6 BYTE) 		Minimum net distance to shore in meters.
EVIDENCE_OF_BLOW_THROUGH
VARCHAR2(1 BYTE) 		Any evidence of net blowthrough, Y=Yes, N=No.
GEAR_DAMAGE_CODE_ID
NUMBER(6,0) 		Gear condition at end of haul. references AMMOP_GEAR_DAMAGE_CODE(
GEAR_DAMAGE_LOCATION_HOR_ID
NUMBER(6,0) 		Horizontal location of gear damage after haul. references AMMOP_GEAR_DAMAGE_LH_CODE
GEAR_DAMAGE_LOCATION_VER_ID
NUMBER(6,0) 		Vertical location of gear damage after haul. references AMMOP_GEAR_DAMAGE_LV_CODE
GEAR_DAMAGE_OBSTRUCTION_ID
NUMBER(6,0) 		Gear obstructions at end of haul. references AMMOP_GEAR_DAMAGE_OBS_CODE
HAUL_BEGIN_DATE
DATE 		Date haul began.
HAUL_BEGIN_DEPTH
VARCHAR2(6 BYTE) 		Water depth, in whole fathoms, where haul began.
HAUL_BEGIN_DEPTH_FROM
VARCHAR2(1 BYTE) 		How depth obtained, O=Observer, P=Permit Holder, C=Marine Chart.
HAUL_BEGIN_LATITUDE
VARCHAR2(9 BYTE) 		Latitude location, in tenths of minutes (ddmm.m), where the haul began.
HAUL_BEGIN_LONGITUDE
VARCHAR2(9 BYTE) 		Longitude location, in tenths of minutes (ddmm.m), where the haul began.
HAUL_BEGIN_TIME
VARCHAR2(4 BYTE) 		Time haul began. Military time.
HAUL_END_DATE
DATE 		Date haul ended.
HAUL_END_DEPTH
VARCHAR2(6 BYTE) 		Water depth, in whole fathoms, where haul ended.
HAUL_END_DEPTH_FROM
VARCHAR2(1 BYTE) 		How depth obtained, O=Observer, P=Permit Holder, C=Marine Chart.
HAUL_END_LATITUDE
VARCHAR2(9 BYTE) 		Latitude location, in tenths of minutes (ddmm.m), where the haul ended.
HAUL_END_LONGITUDE
VARCHAR2(9 BYTE) 		Longitude location, in tenths of minutes (ddmm.m), where the haul ended.
HAUL_END_TIME
VARCHAR2(4 BYTE) 		Time haul ended. Military time.
HAUL_ID
NUMBER(6,0) 		Human assigned haul number.
HYDRAULIC_PUMP_USED
VARCHAR2(1 BYTE) 		Hydraulic pump used to clean net, Y=Yes,N=No.
ID
NUMBER(6,0) 		Unique table ID value. Populated by AMMOP_HAUL_SEQ
INCIDENTAL_TAKE_OBSERVED
VARCHAR2(1 BYTE) 		Incidental take observed, Y=Yes, N=No.
LAND_FEATURE_ID
NUMBER(6,0) 		Best description of nearest land feature. references AMMOP_LAND_FEATURE_CODE
MARINE_ZONE_ID
NUMBER(6,0) 		Best description of marine zone. references MM_FISHING_ZONE
NET_ID
NUMBER(6,0) 		Reference to gear used in haul.
NET_VIEW_DISTANCE
VARCHAR2(8 BYTE) 		Distance to net. meters
NET_VIEW_PERCENT_OBSTRUCTED
VARCHAR2(9 BYTE) 		Percent view obstructed.
NET_VIEW_PERCENT_UNDERWATER
VARCHAR2(9 BYTE) 		Percent net underwater when viewed.
NET_VIEW_RANK_CODE
VARCHAR2(6 BYTE) 		Net view rank code.
OBSERVED_HAUL
VARCHAR2(1 BYTE) 		Partially or Fully.
PERCENT_NET_HAULED
VARCHAR2(9 BYTE) 		Percentage of net that was actually pulled out of the water to any degree during this haul.
PERCENT_NET_OBSERVED
VARCHAR2(9 BYTE) 		Percentage of net that was actually observed being hauled during this haul.
PERCENT_TOTAL_NET_SET
VARCHAR2(9 BYTE) 		Percentage of net set prior to haul.
RIVER_HEIGHT
VARCHAR2(6 BYTE) 		River height of nearest large river.
SAMPLE_ID
VARCHAR2(10 BYTE) 		Reference to sample haul is a part of.
SET_BEGIN_DATE
DATE 		Date set began.
SET_BEGIN_DEPTH
VARCHAR2(6 BYTE) 		Water depth, in whole fathoms, where set began.
SET_BEGIN_DEPTH_FROM
VARCHAR2(1 BYTE) 		How depth obtained, O=Observer, P=Permit Holder, C=Marine Chart.
SET_BEGIN_LATITUDE
VARCHAR2(9 BYTE) 		Latitude location, in tenths of minutes (dddmm.m), where the set began.
SET_BEGIN_LONGITUDE
VARCHAR2(9 BYTE) 		Longitude location, in tenths of minutes (dddmm.m), where the set began.
SET_BEGIN_TIME
VARCHAR2(4 BYTE) 		Time set began. Military time
SET_END_DATE
DATE 		Date set ended.
SET_END_DEPTH
VARCHAR2(6 BYTE) 		Water depth, in whole fathoms, where set ended.
SET_END_DEPTH_FROM
VARCHAR2(1 BYTE) 		How depth obtained, O=Observer, P=Permit Holder, C=Marine Chart.
SET_END_LATITUDE
VARCHAR2(9 BYTE) 		Latitude location, in tenths of minutes (ddmm.m), where the set ended.
SET_END_LONGITUDE
VARCHAR2(9 BYTE) 		Longitude location, in tenths of minutes (ddmm.m), where the set ended.
SET_END_TIME
VARCHAR2(4 BYTE) 		Time set ended. Military time.
SET_OBSERVED
VARCHAR2(1 BYTE) 		Any part of set observed, Y=Yes, N=No.
SOAK_BEGIN_CORKLINE_SHAPE_ID
NUMBER(6,0) 		Corkline shape at the beginning of the soak. references AMMOP_CORKLINE_SHAPE_CODE
SOAK_BEGIN_NET_TENSION_ID
NUMBER(6,0) 		Net tension at the beginning of the soak. references AMMOP_NETEND_TENSION_CODE
SOAK_CORKLINE_SHAPE_CHANGES
VARCHAR2(6 BYTE) 		Number of cork line shape changes during soak.
SOAK_END_CORKLINE_SHAPE_ID
NUMBER(6,0) 		Corkline shape at the end of the soak. references AMMOP_CORKLINE_SHAPE_CODE
SOAK_TENSION_ADJUSTMENTS
VARCHAR2(6 BYTE) 		Number of corkline tension adjustments during soak.
SOAK_TIMES_NET_RUN
VARCHAR2(6 BYTE) 		Number of times vessel ran length of net.
TARGET_SPECIES_ID
NUMBER(6,0) 		Target species. references AGENCY_SPECIE
TIDE_ID
NUMBER(6,0) 		Tide cycle at beginning of haul. references AMMOP_TIDE_CODE
WATER_CLARITY
VARCHAR2(8 BYTE) 		Water clarity measurement in tenths of meters.
WATER_TEMP
VARCHAR2(8 BYTE) 		Water temperature at the time of haul. Celsius
SOAK_END_NET_TENSION_ID
NUMBER(6,0) 		Net tension at the end of the soak. references AMMOP_NETEND_TENSION_CODE

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

Title: AMMOP_HAUL

Entity Information

Description:

This table contains a list of hauls that occurred during an observers sample.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 AIR_TEMP VARCHAR2(8 BYTE) Air temperature at the time of haul. Celsius
100
 COMMENTS VARCHAR2(2048 BYTE) Additional information.
100
 DISTANCE_OBSV_NET_MAXIMUM VARCHAR2(6 BYTE) Maximum distance between the observer vessel and the location of the fishing vessel where the net is hauled aboard for the duration of the haul, in whole meters.
100
 DISTANCE_OBSV_NET_MINIMUM VARCHAR2(6 BYTE) Minimum distance between the observer vessel and the location of the fishing vessel where the net is hauled aboard for the duration of the haul, in whole meters.
100
 DISTANCE_SHORE_MAXIMUM VARCHAR2(6 BYTE) Maximum net distance to shore in meters.
100
 DISTANCE_SHORE_MINIMUM VARCHAR2(6 BYTE) Minimum net distance to shore in meters.
100
 EVIDENCE_OF_BLOW_THROUGH VARCHAR2(1 BYTE) Any evidence of net blowthrough, Y=Yes, N=No.
100
 GEAR_DAMAGE_CODE_ID NUMBER(6,0) Gear condition at end of haul. references AMMOP_GEAR_DAMAGE_CODE(
100
 GEAR_DAMAGE_LOCATION_HOR_ID NUMBER(6,0) Horizontal location of gear damage after haul. references AMMOP_GEAR_DAMAGE_LH_CODE
100
 GEAR_DAMAGE_LOCATION_VER_ID NUMBER(6,0) Vertical location of gear damage after haul. references AMMOP_GEAR_DAMAGE_LV_CODE
100
 GEAR_DAMAGE_OBSTRUCTION_ID NUMBER(6,0) Gear obstructions at end of haul. references AMMOP_GEAR_DAMAGE_OBS_CODE
100
 HAUL_BEGIN_DATE DATE Date haul began.
100
 HAUL_BEGIN_DEPTH VARCHAR2(6 BYTE) Water depth, in whole fathoms, where haul began.
100
 HAUL_BEGIN_DEPTH_FROM VARCHAR2(1 BYTE) How depth obtained, O=Observer, P=Permit Holder, C=Marine Chart.
100
 HAUL_BEGIN_LATITUDE VARCHAR2(9 BYTE) Latitude location, in tenths of minutes (ddmm.m), where the haul began.
100
 HAUL_BEGIN_LONGITUDE VARCHAR2(9 BYTE) Longitude location, in tenths of minutes (ddmm.m), where the haul began.
100
 HAUL_BEGIN_TIME VARCHAR2(4 BYTE) Time haul began. Military time.
100
 HAUL_END_DATE DATE Date haul ended.
100
 HAUL_END_DEPTH VARCHAR2(6 BYTE) Water depth, in whole fathoms, where haul ended.
100
 HAUL_END_DEPTH_FROM VARCHAR2(1 BYTE) How depth obtained, O=Observer, P=Permit Holder, C=Marine Chart.
100
 HAUL_END_LATITUDE VARCHAR2(9 BYTE) Latitude location, in tenths of minutes (ddmm.m), where the haul ended.
100
 HAUL_END_LONGITUDE VARCHAR2(9 BYTE) Longitude location, in tenths of minutes (ddmm.m), where the haul ended.
100
 HAUL_END_TIME VARCHAR2(4 BYTE) Time haul ended. Military time.
100
 HAUL_ID NUMBER(6,0) Human assigned haul number.
100
 HYDRAULIC_PUMP_USED VARCHAR2(1 BYTE) Hydraulic pump used to clean net, Y=Yes,N=No.
100
 ID NUMBER(6,0) Unique table ID value. Populated by AMMOP_HAUL_SEQ
100
 INCIDENTAL_TAKE_OBSERVED VARCHAR2(1 BYTE) Incidental take observed, Y=Yes, N=No.
100
 LAND_FEATURE_ID NUMBER(6,0) Best description of nearest land feature. references AMMOP_LAND_FEATURE_CODE
100
 MARINE_ZONE_ID NUMBER(6,0) Best description of marine zone. references MM_FISHING_ZONE
100
 NET_ID NUMBER(6,0) Reference to gear used in haul.
100
 NET_VIEW_DISTANCE VARCHAR2(8 BYTE) Distance to net. meters
100
 NET_VIEW_PERCENT_OBSTRUCTED VARCHAR2(9 BYTE) Percent view obstructed.
100
 NET_VIEW_PERCENT_UNDERWATER VARCHAR2(9 BYTE) Percent net underwater when viewed.
100
 NET_VIEW_RANK_CODE VARCHAR2(6 BYTE) Net view rank code.
100
 OBSERVED_HAUL VARCHAR2(1 BYTE) Partially or Fully.
100
 PERCENT_NET_HAULED VARCHAR2(9 BYTE) Percentage of net that was actually pulled out of the water to any degree during this haul.
100
 PERCENT_NET_OBSERVED VARCHAR2(9 BYTE) Percentage of net that was actually observed being hauled during this haul.
100
 PERCENT_TOTAL_NET_SET VARCHAR2(9 BYTE) Percentage of net set prior to haul.
100
 RIVER_HEIGHT VARCHAR2(6 BYTE) River height of nearest large river.
100
 SAMPLE_ID VARCHAR2(10 BYTE) Reference to sample haul is a part of.
100
 SET_BEGIN_DATE DATE Date set began.
100
 SET_BEGIN_DEPTH VARCHAR2(6 BYTE) Water depth, in whole fathoms, where set began.
100
 SET_BEGIN_DEPTH_FROM VARCHAR2(1 BYTE) How depth obtained, O=Observer, P=Permit Holder, C=Marine Chart.
100
 SET_BEGIN_LATITUDE VARCHAR2(9 BYTE) Latitude location, in tenths of minutes (dddmm.m), where the set began.
100
 SET_BEGIN_LONGITUDE VARCHAR2(9 BYTE) Longitude location, in tenths of minutes (dddmm.m), where the set began.
100
 SET_BEGIN_TIME VARCHAR2(4 BYTE) Time set began. Military time
100
 SET_END_DATE DATE Date set ended.
100
 SET_END_DEPTH VARCHAR2(6 BYTE) Water depth, in whole fathoms, where set ended.
100
 SET_END_DEPTH_FROM VARCHAR2(1 BYTE) How depth obtained, O=Observer, P=Permit Holder, C=Marine Chart.
100
 SET_END_LATITUDE VARCHAR2(9 BYTE) Latitude location, in tenths of minutes (ddmm.m), where the set ended.
100
 SET_END_LONGITUDE VARCHAR2(9 BYTE) Longitude location, in tenths of minutes (ddmm.m), where the set ended.
100
 SET_END_TIME VARCHAR2(4 BYTE) Time set ended. Military time.
100
 SET_OBSERVED VARCHAR2(1 BYTE) Any part of set observed, Y=Yes, N=No.
100
 SOAK_BEGIN_CORKLINE_SHAPE_ID NUMBER(6,0) Corkline shape at the beginning of the soak. references AMMOP_CORKLINE_SHAPE_CODE
100
 SOAK_BEGIN_NET_TENSION_ID NUMBER(6,0) Net tension at the beginning of the soak. references AMMOP_NETEND_TENSION_CODE
100
 SOAK_CORKLINE_SHAPE_CHANGES VARCHAR2(6 BYTE) Number of cork line shape changes during soak.
100
 SOAK_END_CORKLINE_SHAPE_ID NUMBER(6,0) Corkline shape at the end of the soak. references AMMOP_CORKLINE_SHAPE_CODE
100
 SOAK_TENSION_ADJUSTMENTS VARCHAR2(6 BYTE) Number of corkline tension adjustments during soak.
100
 SOAK_TIMES_NET_RUN VARCHAR2(6 BYTE) Number of times vessel ran length of net.
100
 TARGET_SPECIES_ID NUMBER(6,0) Target species. references AGENCY_SPECIE
100
 TIDE_ID NUMBER(6,0) Tide cycle at beginning of haul. references AMMOP_TIDE_CODE
100
 WATER_CLARITY VARCHAR2(8 BYTE) Water clarity measurement in tenths of meters.
100
 WATER_TEMP VARCHAR2(8 BYTE) Water temperature at the time of haul. Celsius
100
 SOAK_END_NET_TENSION_ID NUMBER(6,0) Net tension at the end of the soak. references AMMOP_NETEND_TENSION_CODE

Attribute Details

AIR_TEMP

CC ID: 1372867
Data Storage Type: VARCHAR2(8 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Air temperature at the time of haul. Celsius

COMMENTS

CC ID: 1372868
Data Storage Type: VARCHAR2(2048 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Additional information.

DISTANCE_OBSV_NET_MAXIMUM

CC ID: 1372869
Data Storage Type: VARCHAR2(6 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Maximum distance between the observer vessel and the location of the fishing vessel where the net is hauled aboard for the duration of the haul, in whole meters.

DISTANCE_OBSV_NET_MINIMUM

CC ID: 1372870
Data Storage Type: VARCHAR2(6 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Minimum distance between the observer vessel and the location of the fishing vessel where the net is hauled aboard for the duration of the haul, in whole meters.

DISTANCE_SHORE_MAXIMUM

CC ID: 1372871
Data Storage Type: VARCHAR2(6 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Maximum net distance to shore in meters.

DISTANCE_SHORE_MINIMUM

CC ID: 1372872
Data Storage Type: VARCHAR2(6 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Minimum net distance to shore in meters.

EVIDENCE_OF_BLOW_THROUGH

CC ID: 1372873
Data Storage Type: VARCHAR2(1 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Any evidence of net blowthrough, Y=Yes, N=No.

GEAR_DAMAGE_CODE_ID

CC ID: 1372874
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active
Description:

Gear condition at end of haul. references AMMOP_GEAR_DAMAGE_CODE(

GEAR_DAMAGE_LOCATION_HOR_ID

CC ID: 1372875
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active
Description:

Horizontal location of gear damage after haul. references AMMOP_GEAR_DAMAGE_LH_CODE

GEAR_DAMAGE_LOCATION_VER_ID

CC ID: 1372876
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active
Description:

Vertical location of gear damage after haul. references AMMOP_GEAR_DAMAGE_LV_CODE

GEAR_DAMAGE_OBSTRUCTION_ID

CC ID: 1372877
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active
Description:

Gear obstructions at end of haul. references AMMOP_GEAR_DAMAGE_OBS_CODE

HAUL_BEGIN_DATE

CC ID: 1372878
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Date haul began.

HAUL_BEGIN_DEPTH

CC ID: 1372879
Data Storage Type: VARCHAR2(6 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Water depth, in whole fathoms, where haul began.

HAUL_BEGIN_DEPTH_FROM

CC ID: 1372880
Data Storage Type: VARCHAR2(1 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

How depth obtained, O=Observer, P=Permit Holder, C=Marine Chart.

HAUL_BEGIN_LATITUDE

CC ID: 1372881
Data Storage Type: VARCHAR2(9 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Latitude location, in tenths of minutes (ddmm.m), where the haul began.

HAUL_BEGIN_LONGITUDE

CC ID: 1372882
Data Storage Type: VARCHAR2(9 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Longitude location, in tenths of minutes (ddmm.m), where the haul began.

HAUL_BEGIN_TIME

CC ID: 1372883
Data Storage Type: VARCHAR2(4 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Time haul began. Military time.

HAUL_END_DATE

CC ID: 1372884
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Date haul ended.

HAUL_END_DEPTH

CC ID: 1372885
Data Storage Type: VARCHAR2(6 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Water depth, in whole fathoms, where haul ended.

HAUL_END_DEPTH_FROM

CC ID: 1372886
Data Storage Type: VARCHAR2(1 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

How depth obtained, O=Observer, P=Permit Holder, C=Marine Chart.

HAUL_END_LATITUDE

CC ID: 1372887
Data Storage Type: VARCHAR2(9 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Latitude location, in tenths of minutes (ddmm.m), where the haul ended.

HAUL_END_LONGITUDE

CC ID: 1372888
Data Storage Type: VARCHAR2(9 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Longitude location, in tenths of minutes (ddmm.m), where the haul ended.

HAUL_END_TIME

CC ID: 1372889
Data Storage Type: VARCHAR2(4 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Time haul ended. Military time.

HAUL_ID

CC ID: 1372890
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active
Description:

Human assigned haul number.

HYDRAULIC_PUMP_USED

CC ID: 1372891
Data Storage Type: VARCHAR2(1 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Hydraulic pump used to clean net, Y=Yes,N=No.

ID

CC ID: 1372892
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active
Description:

Unique table ID value. Populated by AMMOP_HAUL_SEQ

INCIDENTAL_TAKE_OBSERVED

CC ID: 1372893
Data Storage Type: VARCHAR2(1 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Incidental take observed, Y=Yes, N=No.

LAND_FEATURE_ID

CC ID: 1372894
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active
Description:

Best description of nearest land feature. references AMMOP_LAND_FEATURE_CODE

MARINE_ZONE_ID

CC ID: 1372895
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active
Description:

Best description of marine zone. references MM_FISHING_ZONE

NET_ID

CC ID: 1372896
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active
Description:

Reference to gear used in haul.

NET_VIEW_DISTANCE

CC ID: 1372897
Data Storage Type: VARCHAR2(8 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Distance to net. meters

NET_VIEW_PERCENT_OBSTRUCTED

CC ID: 1372898
Data Storage Type: VARCHAR2(9 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Percent view obstructed.

NET_VIEW_PERCENT_UNDERWATER

CC ID: 1372899
Data Storage Type: VARCHAR2(9 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Percent net underwater when viewed.

NET_VIEW_RANK_CODE

CC ID: 1372900
Data Storage Type: VARCHAR2(6 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Net view rank code.

OBSERVED_HAUL

CC ID: 1372901
Data Storage Type: VARCHAR2(1 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Partially or Fully.

PERCENT_NET_HAULED

CC ID: 1372902
Data Storage Type: VARCHAR2(9 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Percentage of net that was actually pulled out of the water to any degree during this haul.

PERCENT_NET_OBSERVED

CC ID: 1372903
Data Storage Type: VARCHAR2(9 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Percentage of net that was actually observed being hauled during this haul.

PERCENT_TOTAL_NET_SET

CC ID: 1372904
Data Storage Type: VARCHAR2(9 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Percentage of net set prior to haul.

RIVER_HEIGHT

CC ID: 1372905
Data Storage Type: VARCHAR2(6 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

River height of nearest large river.

SAMPLE_ID

CC ID: 1372906
Data Storage Type: VARCHAR2(10 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Reference to sample haul is a part of.

SET_BEGIN_DATE

CC ID: 1372907
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Date set began.

SET_BEGIN_DEPTH

CC ID: 1372908
Data Storage Type: VARCHAR2(6 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Water depth, in whole fathoms, where set began.

SET_BEGIN_DEPTH_FROM

CC ID: 1372909
Data Storage Type: VARCHAR2(1 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

How depth obtained, O=Observer, P=Permit Holder, C=Marine Chart.

SET_BEGIN_LATITUDE

CC ID: 1372910
Data Storage Type: VARCHAR2(9 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Latitude location, in tenths of minutes (dddmm.m), where the set began.

SET_BEGIN_LONGITUDE

CC ID: 1372911
Data Storage Type: VARCHAR2(9 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Longitude location, in tenths of minutes (dddmm.m), where the set began.

SET_BEGIN_TIME

CC ID: 1372912
Data Storage Type: VARCHAR2(4 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Time set began. Military time

SET_END_DATE

CC ID: 1372913
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Date set ended.

SET_END_DEPTH

CC ID: 1372914
Data Storage Type: VARCHAR2(6 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Water depth, in whole fathoms, where set ended.

SET_END_DEPTH_FROM

CC ID: 1372915
Data Storage Type: VARCHAR2(1 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

How depth obtained, O=Observer, P=Permit Holder, C=Marine Chart.

SET_END_LATITUDE

CC ID: 1372916
Data Storage Type: VARCHAR2(9 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Latitude location, in tenths of minutes (ddmm.m), where the set ended.

SET_END_LONGITUDE

CC ID: 1372917
Data Storage Type: VARCHAR2(9 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Longitude location, in tenths of minutes (ddmm.m), where the set ended.

SET_END_TIME

CC ID: 1372918
Data Storage Type: VARCHAR2(4 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Time set ended. Military time.

SET_OBSERVED

CC ID: 1372919
Data Storage Type: VARCHAR2(1 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Any part of set observed, Y=Yes, N=No.

SOAK_BEGIN_CORKLINE_SHAPE_ID

CC ID: 1372920
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active
Description:

Corkline shape at the beginning of the soak. references AMMOP_CORKLINE_SHAPE_CODE

SOAK_BEGIN_NET_TENSION_ID

CC ID: 1372921
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active
Description:

Net tension at the beginning of the soak. references AMMOP_NETEND_TENSION_CODE

SOAK_CORKLINE_SHAPE_CHANGES

CC ID: 1372922
Data Storage Type: VARCHAR2(6 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Number of cork line shape changes during soak.

SOAK_END_CORKLINE_SHAPE_ID

CC ID: 1372923
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active
Description:

Corkline shape at the end of the soak. references AMMOP_CORKLINE_SHAPE_CODE

SOAK_TENSION_ADJUSTMENTS

CC ID: 1372924
Data Storage Type: VARCHAR2(6 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Number of corkline tension adjustments during soak.

SOAK_TIMES_NET_RUN

CC ID: 1372925
Data Storage Type: VARCHAR2(6 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Number of times vessel ran length of net.

TARGET_SPECIES_ID

CC ID: 1372926
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active
Description:

Target species. references AGENCY_SPECIE

TIDE_ID

CC ID: 1372927
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active
Description:

Tide cycle at beginning of haul. references AMMOP_TIDE_CODE

WATER_CLARITY

CC ID: 1372928
Data Storage Type: VARCHAR2(8 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Water clarity measurement in tenths of meters.

WATER_TEMP

CC ID: 1372929
Data Storage Type: VARCHAR2(8 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Water temperature at the time of haul. Celsius

SOAK_END_NET_TENSION_ID

CC ID: 1372930
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active
Description:

Net tension at the end of the soak. references AMMOP_NETEND_TENSION_CODE

Catalog Details

Catalog Item ID: 75080
GUID: gov.noaa.nmfs.inport:75080
Metadata Record Created By: Rachel Wuest
Metadata Record Created: 2025-03-05 17:46+0000
Metadata Record Last Modified By: Daniel Woodrich
Metadata Record Last Modified: 2025-05-21 19:12+0000
Metadata Record Published: 2025-05-21
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Review Frequency: 1 Year