Account Creation Issues: We have received reports of issues with creating new user accounts and linking accounts to CAM, and are currently investigating the root cause. In the meantime: - If you're experiencing errors creating new users, please use the "Quick Add" feature instead (click the "Quick Add" button on the Manage Users page). - If you're experiencing errors linking CAM accoun...
View All
Search Help Show/Hide Menu
Metadata Rubric
79%
4.73 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > AMMOP > AMMOP Oracle database 1999 - 2013 >

MM_OBS_HAUL

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

Summary

Description

Captures non-catch data from hard copy Set Gillnet Haul Form.

Entity Information

Data Attribute / Type Description
AIR_TEMPERATURE
NUMBER(3,1) 		The air temperature (C)
BEGIN_HAUL_DATE
DATE 		The begin date of the haul
BEGIN_HAUL_DEPTH
NUMBER(4,0) 		The begin depth of the haul
BEGIN_HAUL_LATITUDE
NUMBER(6,1) 		The begin latitude of the haul
BEGIN_HAUL_LONGITUDE
NUMBER(7,1) 		The begin longitude of the haul
BEGIN_HAUL_TIME
NUMBER(4,0) 		The begin time of the haul
COMMENTS
VARCHAR2(2000 BYTE)
COMMENT_ON_MULTIPLE_PICKS_FLAG
VARCHAR2(1 BYTE) 		Flag indicating the presence of comments about multiple picks occurring during the 'haul' duration noted on the 'haul' form.
END_HAUL_DATE
DATE 		The end date of the haul
END_HAUL_DEPTH
NUMBER(4,0) 		The end depth of the haul
END_HAUL_LATITUDE
NUMBER(7,1) 		The end latitude of the haul
END_HAUL_LONGITUDE
NUMBER(7,1) 		The end longitude of the haul
END_HAUL_TIME
NUMBER(4,0) 		The end time of the haul
FISHING_DURATION
NUMBER(5,0) 		The duration the net had been in the water since opener
FISHING_DURATION_IN_MINUTES
NUMBER(6,0)
FISHING_ZONE_CODE
VARCHAR2(2 BYTE) 		AMMOP code for the fishing zone
FISHING_ZONE_DESCRIPTION
VARCHAR2(50 BYTE) 		Description of the fishing zone.
FISHING_ZONE_ID
NUMBER(10,0) 		Unique database identifier for fishing zone
GEAR_DAMAGE_CODE
VARCHAR2(2 BYTE) 		Damage incurred by gear while fishing.
GEAR_ID
NUMBER(6,0) 		Unique database identifier for net used on this haul
GEAR_OBSTRUCTION_CODE
VARCHAR2(2 BYTE) 		The type and level of gillnet obstructions.
HAUL_NUMBER
NUMBER(4,0) 		Haul number assigned to haul by observer
HYDRAULIC_PUMP_USED_CODE
VARCHAR2(1 BYTE) 		Presence or absence of a pressure net cleaning system.
INCIDENTAL_TAKE_CODE
VARCHAR2(1 BYTE) 		Did an incidental take occur during this haul?
LAND_CODE
VARCHAR2(2 BYTE) 		A description of the topography adjacent to the fishing site.
MAXIMUM_DISTANCE_TO_SHORE
NUMBER(4,0)
MINIMUM_DISTANCE_TO_SHORE
NUMBER(4,0)
MONTH
NUMBER(2,0) 		Month
NET_VIEW_RANKING
VARCHAR2(2 BYTE) 		A ranking that represents the assessment of the observer's view of the net.
NUMBER_OF_CREW
NUMBER(2,0)
NUMBER_OF_SKIFFS
NUMBER(3,0)
OBSERVATION_QUALITY_CODE
VARCHAR2(2 BYTE)
PERCENT_OF_GEAR_PULLED
NUMBER(3,0)
PERCENT_OF_GEAR_RAN
NUMBER(3,0)
PERCENT_OF_NET_OBSERVED
NUMBER(3,0)
PRIMARY_SPECIES_CODE
VARCHAR2(5 BYTE) 		AMMOP code for animals
PRIMARY_SPECIES_ID
NUMBER(6,0) 		The unique identifier of the Specie Group.
SEQUENCE_NUMBER
NUMBER(4,0) 		Unqiue database identifier for haul within trip
SKIFF_SIZE
VARCHAR2(20 BYTE)
SOAK_DURATION
NUMBER(5,0) 		The duration the net had been in the water since last haul
SOAK_DURATION_IN_MINUTES
NUMBER(6,0)
STATE_STAT_AREA_CODE
VARCHAR2(6 BYTE) 		The ADFG code for the for state statistical are
STATE_STAT_AREA_ID
NUMBER(6,0) 		The unique identifier of the state statistical Management Area.
TIDE_CODE
VARCHAR2(1 BYTE)
TRIP_CODE
VARCHAR2(6 BYTE) 		AMMOP identifier for trip
TRIP_ID
NUMBER(6,0) 		Unique database identifier for trip
WATER_TEMPERATURE
NUMBER(3,1) 		The water temperature (C)
WATER_TURBIDITY
NUMBER(3,1) 		The secchi disk result (m).
YEAR
NUMBER(4,0) 		Year

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: MM_OBS_HAUL

Entity Information

Description:

Captures non-catch data from hard copy Set Gillnet Haul Form.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 AIR_TEMPERATURE NUMBER(3,1) The air temperature (C)
100
 BEGIN_HAUL_DATE DATE The begin date of the haul
100
 BEGIN_HAUL_DEPTH NUMBER(4,0) The begin depth of the haul
100
 BEGIN_HAUL_LATITUDE NUMBER(6,1) The begin latitude of the haul
100
 BEGIN_HAUL_LONGITUDE NUMBER(7,1) The begin longitude of the haul
100
 BEGIN_HAUL_TIME NUMBER(4,0) The begin time of the haul
67
 COMMENTS VARCHAR2(2000 BYTE)
100
 COMMENT_ON_MULTIPLE_PICKS_FLAG VARCHAR2(1 BYTE) Flag indicating the presence of comments about multiple picks occurring during the 'haul' duration noted on the 'haul' form.
100
 END_HAUL_DATE DATE The end date of the haul
100
 END_HAUL_DEPTH NUMBER(4,0) The end depth of the haul
100
 END_HAUL_LATITUDE NUMBER(7,1) The end latitude of the haul
100
 END_HAUL_LONGITUDE NUMBER(7,1) The end longitude of the haul
100
 END_HAUL_TIME NUMBER(4,0) The end time of the haul
100
 FISHING_DURATION NUMBER(5,0) The duration the net had been in the water since opener
67
 FISHING_DURATION_IN_MINUTES NUMBER(6,0)
100
 FISHING_ZONE_CODE VARCHAR2(2 BYTE) AMMOP code for the fishing zone
100
 FISHING_ZONE_DESCRIPTION VARCHAR2(50 BYTE) Description of the fishing zone.
100
 FISHING_ZONE_ID NUMBER(10,0) Unique database identifier for fishing zone
100
 GEAR_DAMAGE_CODE VARCHAR2(2 BYTE) Damage incurred by gear while fishing.
100
 GEAR_ID NUMBER(6,0) Unique database identifier for net used on this haul
100
 GEAR_OBSTRUCTION_CODE VARCHAR2(2 BYTE) The type and level of gillnet obstructions.
100
 HAUL_NUMBER NUMBER(4,0) Haul number assigned to haul by observer
100
 HYDRAULIC_PUMP_USED_CODE VARCHAR2(1 BYTE) Presence or absence of a pressure net cleaning system.
100
 INCIDENTAL_TAKE_CODE VARCHAR2(1 BYTE) Did an incidental take occur during this haul?
100
 LAND_CODE VARCHAR2(2 BYTE) A description of the topography adjacent to the fishing site.
67
 MAXIMUM_DISTANCE_TO_SHORE NUMBER(4,0)
67
 MINIMUM_DISTANCE_TO_SHORE NUMBER(4,0)
100
 MONTH NUMBER(2,0) Month
100
 NET_VIEW_RANKING VARCHAR2(2 BYTE) A ranking that represents the assessment of the observer's view of the net.
67
 NUMBER_OF_CREW NUMBER(2,0)
67
 NUMBER_OF_SKIFFS NUMBER(3,0)
67
 OBSERVATION_QUALITY_CODE VARCHAR2(2 BYTE)
67
 PERCENT_OF_GEAR_PULLED NUMBER(3,0)
67
 PERCENT_OF_GEAR_RAN NUMBER(3,0)
67
 PERCENT_OF_NET_OBSERVED NUMBER(3,0)
100
 PRIMARY_SPECIES_CODE VARCHAR2(5 BYTE) AMMOP code for animals
100
 PRIMARY_SPECIES_ID NUMBER(6,0) The unique identifier of the Specie Group.
100
 SEQUENCE_NUMBER NUMBER(4,0) Unqiue database identifier for haul within trip
67
 SKIFF_SIZE VARCHAR2(20 BYTE)
100
 SOAK_DURATION NUMBER(5,0) The duration the net had been in the water since last haul
67
 SOAK_DURATION_IN_MINUTES NUMBER(6,0)
100
 STATE_STAT_AREA_CODE VARCHAR2(6 BYTE) The ADFG code for the for state statistical are
100
 STATE_STAT_AREA_ID NUMBER(6,0) The unique identifier of the state statistical Management Area.
67
 TIDE_CODE VARCHAR2(1 BYTE)
100
 TRIP_CODE VARCHAR2(6 BYTE) AMMOP identifier for trip
100
 TRIP_ID NUMBER(6,0) Unique database identifier for trip
100
 WATER_TEMPERATURE NUMBER(3,1) The water temperature (C)
100
 WATER_TURBIDITY NUMBER(3,1) The secchi disk result (m).
100
 YEAR NUMBER(4,0) Year

Attribute Details

AIR_TEMPERATURE

CC ID: 1374541
Data Storage Type: NUMBER(3,1)
Required: No
Primary Key: No
Status: Active
Description:

The air temperature (C)

BEGIN_HAUL_DATE

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

The begin date of the haul

BEGIN_HAUL_DEPTH

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

The begin depth of the haul

BEGIN_HAUL_LATITUDE

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

The begin latitude of the haul

BEGIN_HAUL_LONGITUDE

CC ID: 1374545
Data Storage Type: NUMBER(7,1)
Required: No
Primary Key: No
Status: Active
Description:

The begin longitude of the haul

BEGIN_HAUL_TIME

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

The begin time of the haul

COMMENTS

CC ID: 1374547
Data Storage Type: VARCHAR2(2000 BYTE)
Required: No
Primary Key: No
Status: Active

COMMENT_ON_MULTIPLE_PICKS_FLAG

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

Flag indicating the presence of comments about multiple picks occurring during the 'haul' duration noted on the 'haul' form.

END_HAUL_DATE

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

The end date of the haul

END_HAUL_DEPTH

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

The end depth of the haul

END_HAUL_LATITUDE

CC ID: 1374551
Data Storage Type: NUMBER(7,1)
Required: No
Primary Key: No
Status: Active
Description:

The end latitude of the haul

END_HAUL_LONGITUDE

CC ID: 1374552
Data Storage Type: NUMBER(7,1)
Required: No
Primary Key: No
Status: Active
Description:

The end longitude of the haul

END_HAUL_TIME

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

The end time of the haul

FISHING_DURATION

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

The duration the net had been in the water since opener

FISHING_DURATION_IN_MINUTES

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

FISHING_ZONE_CODE

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

AMMOP code for the fishing zone

FISHING_ZONE_DESCRIPTION

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

Description of the fishing zone.

FISHING_ZONE_ID

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

Unique database identifier for fishing zone

GEAR_DAMAGE_CODE

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

Damage incurred by gear while fishing.

GEAR_ID

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

Unique database identifier for net used on this haul

GEAR_OBSTRUCTION_CODE

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

The type and level of gillnet obstructions.

HAUL_NUMBER

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

Haul number assigned to haul by observer

HYDRAULIC_PUMP_USED_CODE

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

Presence or absence of a pressure net cleaning system.

INCIDENTAL_TAKE_CODE

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

Did an incidental take occur during this haul?

LAND_CODE

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

A description of the topography adjacent to the fishing site.

MAXIMUM_DISTANCE_TO_SHORE

CC ID: 1374566
Data Storage Type: NUMBER(4,0)
Required: No
Primary Key: No
Status: Active

MINIMUM_DISTANCE_TO_SHORE

CC ID: 1374567
Data Storage Type: NUMBER(4,0)
Required: No
Primary Key: No
Status: Active

MONTH

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

Month

NET_VIEW_RANKING

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

A ranking that represents the assessment of the observer's view of the net.

NUMBER_OF_CREW

CC ID: 1374570
Data Storage Type: NUMBER(2,0)
Required: No
Primary Key: No
Status: Active

NUMBER_OF_SKIFFS

CC ID: 1374571
Data Storage Type: NUMBER(3,0)
Required: No
Primary Key: No
Status: Active

OBSERVATION_QUALITY_CODE

CC ID: 1374572
Data Storage Type: VARCHAR2(2 BYTE)
Required: No
Primary Key: No
Status: Active

PERCENT_OF_GEAR_PULLED

CC ID: 1374573
Data Storage Type: NUMBER(3,0)
Required: No
Primary Key: No
Status: Active

PERCENT_OF_GEAR_RAN

CC ID: 1374574
Data Storage Type: NUMBER(3,0)
Required: No
Primary Key: No
Status: Active

PERCENT_OF_NET_OBSERVED

CC ID: 1374575
Data Storage Type: NUMBER(3,0)
Required: No
Primary Key: No
Status: Active

PRIMARY_SPECIES_CODE

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

AMMOP code for animals

PRIMARY_SPECIES_ID

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

The unique identifier of the Specie Group.

SEQUENCE_NUMBER

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

Unqiue database identifier for haul within trip

SKIFF_SIZE

CC ID: 1374579
Data Storage Type: VARCHAR2(20 BYTE)
Required: No
Primary Key: No
Status: Active

SOAK_DURATION

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

The duration the net had been in the water since last haul

SOAK_DURATION_IN_MINUTES

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

STATE_STAT_AREA_CODE

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

The ADFG code for the for state statistical are

STATE_STAT_AREA_ID

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

The unique identifier of the state statistical Management Area.

TIDE_CODE

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

TRIP_CODE

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

AMMOP identifier for trip

TRIP_ID

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

Unique database identifier for trip

WATER_TEMPERATURE

CC ID: 1374587
Data Storage Type: NUMBER(3,1)
Required: No
Primary Key: No
Status: Active
Description:

The water temperature (C)

WATER_TURBIDITY

CC ID: 1374588
Data Storage Type: NUMBER(3,1)
Required: No
Primary Key: No
Status: Active
Description:

The secchi disk result (m).

YEAR

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

Year

Catalog Details

Catalog Item ID: 75186
GUID: gov.noaa.nmfs.inport:75186
Metadata Record Created By: Rachel Wuest
Metadata Record Created: 2025-03-06 22:31+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