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%
5 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > AMMOP > AMMOP Oracle database 1999 - 2013 >

MM_SIGHTING_OFF_WATCH

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

Summary

Description

Table holding information about sightings that occurred while the observer was not on watch.

Entity Information

Data Attribute / Type Description
BEAUFORT_CODE
VARCHAR2(1 BYTE) 		Sea state on the Beaufort Scale.
BEHAVIOR_CODE
VARCHAR2(2 BYTE) 		Code representing the behavior of the animals sighted.
BEHAVIOR_ID
NUMBER(6,0) 		Unique identifier of the behavior of the animals sighted.
COMMENTS
VARCHAR2(2000 BYTE) 		User-entered descriptive notes.
DISTANCE_TO_GEAR
NUMBER(4,0) 		Distance from observer to net in whole meters.
DISTANCE_TO_VESSEL
NUMBER(4,0) 		Distance from observer to animal sighted in whole meters.
LATITUDE
NUMBER(7,1) 		Sighting event latitude in tenths of minutes.
LONGITUDE
NUMBER(7,1) 		Sighting event longitude in tenths of minutes.
NUMBER_OF_INDIVIDUALS
NUMBER(4,0) 		Number of individual animals sighted.
OBSERVATION_PLATFORM_CODE
VARCHAR2(1 BYTE) 		Platform from which observer made the sighting.
OBSERVER_CODE
VARCHAR2(3 BYTE) 		Code associated with the observer within the Marine Mammal Observer Program.
OBSERVER_ID
NUMBER(6,0) 		Unique identifier of the observer within the Marine Mammal Observer Program.
SEQUENCE_NUMBER
NUMBER(3,0) 		Sequence number within the parent sighting record.
SIGHTING_ID
NUMBER(6,0) 		Unique identifier of the parent sighting record.
SIGHTING_OBJECT_CODE
VARCHAR2(5 BYTE) 		Agency species code or code representing the object that was sighted.
SIGHTING_OBJECT_ID
NUMBER(6,0) 		Unique identifier of the agency species or sighting object.
SIGHTING_TIME
NUMBER(5,0) 		The time on a 24-hour clock that an off-watch event was recorded.
TYPE_CODE
VARCHAR2(2 BYTE) 		Code for the type of sighting event recorded.
TYPE_ID
NUMBER(6,0) 		Unique identifier of the type of sighting event recorded.
WAVE_HEIGHT
NUMBER(3,1) 		Estimated wave height in meters.
WEATHER_CODE
VARCHAR2(1 BYTE) 		Weather at time of sighting event.

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_SIGHTING_OFF_WATCH

Entity Information

Description:

Table holding information about sightings that occurred while the observer was not on watch.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 BEAUFORT_CODE VARCHAR2(1 BYTE) Sea state on the Beaufort Scale.
100
 BEHAVIOR_CODE VARCHAR2(2 BYTE) Code representing the behavior of the animals sighted.
100
 BEHAVIOR_ID NUMBER(6,0) Unique identifier of the behavior of the animals sighted.
100
 COMMENTS VARCHAR2(2000 BYTE) User-entered descriptive notes.
100
 DISTANCE_TO_GEAR NUMBER(4,0) Distance from observer to net in whole meters.
100
 DISTANCE_TO_VESSEL NUMBER(4,0) Distance from observer to animal sighted in whole meters.
100
 LATITUDE NUMBER(7,1) Sighting event latitude in tenths of minutes.
100
 LONGITUDE NUMBER(7,1) Sighting event longitude in tenths of minutes.
100
 NUMBER_OF_INDIVIDUALS NUMBER(4,0) Number of individual animals sighted.
100
 OBSERVATION_PLATFORM_CODE VARCHAR2(1 BYTE) Platform from which observer made the sighting.
100
 OBSERVER_CODE VARCHAR2(3 BYTE) Code associated with the observer within the Marine Mammal Observer Program.
100
 OBSERVER_ID NUMBER(6,0) Unique identifier of the observer within the Marine Mammal Observer Program.
100
 SEQUENCE_NUMBER NUMBER(3,0) Sequence number within the parent sighting record.
100
 SIGHTING_ID NUMBER(6,0) Unique identifier of the parent sighting record.
100
 SIGHTING_OBJECT_CODE VARCHAR2(5 BYTE) Agency species code or code representing the object that was sighted.
100
 SIGHTING_OBJECT_ID NUMBER(6,0) Unique identifier of the agency species or sighting object.
100
 SIGHTING_TIME NUMBER(5,0) The time on a 24-hour clock that an off-watch event was recorded.
100
 TYPE_CODE VARCHAR2(2 BYTE) Code for the type of sighting event recorded.
100
 TYPE_ID NUMBER(6,0) Unique identifier of the type of sighting event recorded.
100
 WAVE_HEIGHT NUMBER(3,1) Estimated wave height in meters.
100
 WEATHER_CODE VARCHAR2(1 BYTE) Weather at time of sighting event.

Attribute Details

BEAUFORT_CODE

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

Sea state on the Beaufort Scale.

BEHAVIOR_CODE

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

Code representing the behavior of the animals sighted.

BEHAVIOR_ID

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

Unique identifier of the behavior of the animals sighted.

COMMENTS

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

User-entered descriptive notes.

DISTANCE_TO_GEAR

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

Distance from observer to net in whole meters.

DISTANCE_TO_VESSEL

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

Distance from observer to animal sighted in whole meters.

LATITUDE

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

Sighting event latitude in tenths of minutes.

LONGITUDE

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

Sighting event longitude in tenths of minutes.

NUMBER_OF_INDIVIDUALS

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

Number of individual animals sighted.

OBSERVATION_PLATFORM_CODE

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

Platform from which observer made the sighting.

OBSERVER_CODE

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

Code associated with the observer within the Marine Mammal Observer Program.

OBSERVER_ID

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

Unique identifier of the observer within the Marine Mammal Observer Program.

SEQUENCE_NUMBER

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

Sequence number within the parent sighting record.

SIGHTING_ID

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

Unique identifier of the parent sighting record.

SIGHTING_OBJECT_CODE

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

Agency species code or code representing the object that was sighted.

SIGHTING_OBJECT_ID

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

Unique identifier of the agency species or sighting object.

SIGHTING_TIME

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

The time on a 24-hour clock that an off-watch event was recorded.

TYPE_CODE

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

Code for the type of sighting event recorded.

TYPE_ID

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

Unique identifier of the type of sighting event recorded.

WAVE_HEIGHT

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

Estimated wave height in meters.

WEATHER_CODE

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

Weather at time of sighting event.

Catalog Details

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