Downtime Notice: Thursday, May 29 @ 2:00pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 6.0.2. Downtime Schedule May 29, 2025 2:00pm - 3:00pm Eastern / 11:00am - 12:00pm Pacific / 8:00am - 9:00am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: https://www.fisheri...
View All
Search Help Show/Hide Menu
Metadata Rubric
83%
4.97 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > AMMOP > AMMOP Oracle database 1999 - 2013 >

AMMOP_EVENT

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

Summary

Description

This table contains a list of sample events and marine mammal sightings.

Entity Information

Data Attribute / Type Description
ANIMAL_BEHAVIOR_ID
NUMBER(6,0) 		Initial behavior of the animal when first seen. references MM_SPECIES_BEHAVIOR
ANIMAL_CONDITION_ID
NUMBER(6,0) 		Animal condition when sighted. references AMMOP_SPECIES_CONDITION_CODE
ANIMAL_DISTANCE_TO_NET_CLOSEST
VARCHAR2(6 BYTE)
ANIMAL_DISTANCE_TO_NET_INITIAL
VARCHAR2(6 BYTE) 		Distance between the animal to the net at the initial sighting in meters.
ANIMAL_DISTANCE_TO_VESSEL
VARCHAR2(6 BYTE) 		Distance from the animal to the fishing vessel at the initial sighting in meters.
ANIMAL_INTERACTION_WITH_NET
VARCHAR2(2 BYTE) 		Animal interacts with net, Y=Yes, N=No
ANIMAL_LOCATION_ALONG_NET
VARCHAR2(4 BYTE) 		Horizontal quarter along the net if the animal or group of animals is within 100 meters of the net.
BEAUFORT_SEA_STATE
VARCHAR2(4 BYTE) 		Sea state when event observed. Use Beaufort sea scale.
CLOUD_COVER_ID
NUMBER(6,0) 		Cloud conditions when the event was observed. references AMMOP_CLOUD_CODE
COMMENTS
VARCHAR2(2048 BYTE) 		Additional information
CORK_LINE_SHAPE_CAUSE
CHAR(2 BYTE) 		Cause of cork line shape during soak watch, F=Caused by Fishing, D=Caused by Drift, U=Unknown Cause
CORK_LINE_SHAPE_ID
NUMBER(6,0) 		Cork line shape during soak watch. references AMMOP_CORKLINE_SHAPE_CODE
EVENT_DATE
DATE 		Date event observed
EVENT_NUMBER
NUMBER(6,0) 		Observer assigned event number
EVENT_TIME
NUMBER(4,0) 		Time event observed. Military time.
EVENT_TYPE_ID
NUMBER(6,0) 		Type of event observed. references MM_SIGHTING_EVENT_TYPE
FISHERMAN_RESP_TO_ANIMAL_ID
NUMBER(6,0) 		Fishermans response to marine mammals in the vicinity (within 500 meters). references AMMOP_FISHERMAN_RESPONSE_CODE
ID
NUMBER(6,0) 		Unique table ID value. AMMOP_EVENT_SEQ
LATITUDE
VARCHAR2(9 BYTE) 		Latitude of where event observed. tenths of minutes (ddmm.m),
LONGITUDE
VARCHAR2(9 BYTE) 		Longitude of where event observed. tenths of minutes (ddmm.m),
NET_END_TENSION_CAUSE
CHAR(2 BYTE) 		Cause of net end tension during soak watch, F=Caused by Fishing, D=Caused by Drift, U=Unknown Cause
NET_END_TENSION_ID
NUMBER(6,0) 		Net end tension during soak watch. references AMMOP_NETEND_TENSION_CODE
NUMBER_OF_INDIVIDUALS
VARCHAR2(8 BYTE) 		Number of individuals sighted during event
OBSERVER_ID
NUMBER(6,0) 		Observer of event. references MM_OBSERVER
PERCENT_NET_RUN
VARCHAR2(9 BYTE) 		Percent of net run during soak watch
PRECIPITATION_ID
NUMBER(6,0) 		Precipitation when event observed. references AMMOP_PRECIPITATION_CODE
SAMPLE_ID
VARCHAR2(10 BYTE) 		Sample in which event occurred
SPECIES_ID
NUMBER(6,0) 		Species sighted during event. references AGENCY_SPECIE
SPECIES_NAME
VARCHAR2(256 BYTE) 		Species name sighted during event
WAVE_HEIGHT
VARCHAR2(9 BYTE) 		Wave height when event observed

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_EVENT

Entity Information

Description:

This table contains a list of sample events and marine mammal sightings.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 ANIMAL_BEHAVIOR_ID NUMBER(6,0) Initial behavior of the animal when first seen. references MM_SPECIES_BEHAVIOR
100
 ANIMAL_CONDITION_ID NUMBER(6,0) Animal condition when sighted. references AMMOP_SPECIES_CONDITION_CODE
67
 ANIMAL_DISTANCE_TO_NET_CLOSEST VARCHAR2(6 BYTE)
100
 ANIMAL_DISTANCE_TO_NET_INITIAL VARCHAR2(6 BYTE) Distance between the animal to the net at the initial sighting in meters.
100
 ANIMAL_DISTANCE_TO_VESSEL VARCHAR2(6 BYTE) Distance from the animal to the fishing vessel at the initial sighting in meters.
100
 ANIMAL_INTERACTION_WITH_NET VARCHAR2(2 BYTE) Animal interacts with net, Y=Yes, N=No
100
 ANIMAL_LOCATION_ALONG_NET VARCHAR2(4 BYTE) Horizontal quarter along the net if the animal or group of animals is within 100 meters of the net.
100
 BEAUFORT_SEA_STATE VARCHAR2(4 BYTE) Sea state when event observed. Use Beaufort sea scale.
100
 CLOUD_COVER_ID NUMBER(6,0) Cloud conditions when the event was observed. references AMMOP_CLOUD_CODE
100
 COMMENTS VARCHAR2(2048 BYTE) Additional information
100
 CORK_LINE_SHAPE_CAUSE CHAR(2 BYTE) Cause of cork line shape during soak watch, F=Caused by Fishing, D=Caused by Drift, U=Unknown Cause
100
 CORK_LINE_SHAPE_ID NUMBER(6,0) Cork line shape during soak watch. references AMMOP_CORKLINE_SHAPE_CODE
100
 EVENT_DATE DATE Date event observed
100
 EVENT_NUMBER NUMBER(6,0) Observer assigned event number
100
 EVENT_TIME NUMBER(4,0) Time event observed. Military time.
100
 EVENT_TYPE_ID NUMBER(6,0) Type of event observed. references MM_SIGHTING_EVENT_TYPE
100
 FISHERMAN_RESP_TO_ANIMAL_ID NUMBER(6,0) Fishermans response to marine mammals in the vicinity (within 500 meters). references AMMOP_FISHERMAN_RESPONSE_CODE
100
 ID NUMBER(6,0) Unique table ID value. AMMOP_EVENT_SEQ
100
 LATITUDE VARCHAR2(9 BYTE) Latitude of where event observed. tenths of minutes (ddmm.m),
100
 LONGITUDE VARCHAR2(9 BYTE) Longitude of where event observed. tenths of minutes (ddmm.m),
100
 NET_END_TENSION_CAUSE CHAR(2 BYTE) Cause of net end tension during soak watch, F=Caused by Fishing, D=Caused by Drift, U=Unknown Cause
100
 NET_END_TENSION_ID NUMBER(6,0) Net end tension during soak watch. references AMMOP_NETEND_TENSION_CODE
100
 NUMBER_OF_INDIVIDUALS VARCHAR2(8 BYTE) Number of individuals sighted during event
100
 OBSERVER_ID NUMBER(6,0) Observer of event. references MM_OBSERVER
100
 PERCENT_NET_RUN VARCHAR2(9 BYTE) Percent of net run during soak watch
100
 PRECIPITATION_ID NUMBER(6,0) Precipitation when event observed. references AMMOP_PRECIPITATION_CODE
100
 SAMPLE_ID VARCHAR2(10 BYTE) Sample in which event occurred
100
 SPECIES_ID NUMBER(6,0) Species sighted during event. references AGENCY_SPECIE
100
 SPECIES_NAME VARCHAR2(256 BYTE) Species name sighted during event
100
 WAVE_HEIGHT VARCHAR2(9 BYTE) Wave height when event observed

Attribute Details

ANIMAL_BEHAVIOR_ID

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

Initial behavior of the animal when first seen. references MM_SPECIES_BEHAVIOR

ANIMAL_CONDITION_ID

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

Animal condition when sighted. references AMMOP_SPECIES_CONDITION_CODE

ANIMAL_DISTANCE_TO_NET_CLOSEST

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

ANIMAL_DISTANCE_TO_NET_INITIAL

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

Distance between the animal to the net at the initial sighting in meters.

ANIMAL_DISTANCE_TO_VESSEL

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

Distance from the animal to the fishing vessel at the initial sighting in meters.

ANIMAL_INTERACTION_WITH_NET

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

Animal interacts with net, Y=Yes, N=No

ANIMAL_LOCATION_ALONG_NET

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

Horizontal quarter along the net if the animal or group of animals is within 100 meters of the net.

BEAUFORT_SEA_STATE

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

Sea state when event observed. Use Beaufort sea scale.

CLOUD_COVER_ID

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

Cloud conditions when the event was observed. references AMMOP_CLOUD_CODE

COMMENTS

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

Additional information

CORK_LINE_SHAPE_CAUSE

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

Cause of cork line shape during soak watch, F=Caused by Fishing, D=Caused by Drift, U=Unknown Cause

CORK_LINE_SHAPE_ID

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

Cork line shape during soak watch. references AMMOP_CORKLINE_SHAPE_CODE

EVENT_DATE

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

Date event observed

EVENT_NUMBER

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

Observer assigned event number

EVENT_TIME

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

Time event observed. Military time.

EVENT_TYPE_ID

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

Type of event observed. references MM_SIGHTING_EVENT_TYPE

FISHERMAN_RESP_TO_ANIMAL_ID

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

Fishermans response to marine mammals in the vicinity (within 500 meters). references AMMOP_FISHERMAN_RESPONSE_CODE

ID

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

Unique table ID value. AMMOP_EVENT_SEQ

LATITUDE

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

Latitude of where event observed. tenths of minutes (ddmm.m),

LONGITUDE

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

Longitude of where event observed. tenths of minutes (ddmm.m),

NET_END_TENSION_CAUSE

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

Cause of net end tension during soak watch, F=Caused by Fishing, D=Caused by Drift, U=Unknown Cause

NET_END_TENSION_ID

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

Net end tension during soak watch. references AMMOP_NETEND_TENSION_CODE

NUMBER_OF_INDIVIDUALS

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

Number of individuals sighted during event

OBSERVER_ID

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

Observer of event. references MM_OBSERVER

PERCENT_NET_RUN

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

Percent of net run during soak watch

PRECIPITATION_ID

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

Precipitation when event observed. references AMMOP_PRECIPITATION_CODE

SAMPLE_ID

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

Sample in which event occurred

SPECIES_ID

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

Species sighted during event. references AGENCY_SPECIE

SPECIES_NAME

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

Species name sighted during event

WAVE_HEIGHT

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

Wave height when event observed

Catalog Details

Catalog Item ID: 75070
GUID: gov.noaa.nmfs.inport:75070
Metadata Record Created By: Rachel Wuest
Metadata Record Created: 2025-03-05 17:18+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