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

MM_SIGHTING

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

Summary

Description

In 2002, this table captured all sighting form data. From 2005 on, this table captures the header portion of the hard copy sighting form. MM_SIGHTING is parent to both mm_sighting_watch and mm_sighting_off_watch.

Entity Information

Data Attribute / Type Description
BEAUFORT_CODE
VARCHAR2(1 BYTE) 		Sea State on the Beaufort Scale
BEHAVIOR_CODE
VARCHAR2(2 BYTE) 		AMMOP code for behavior observed
BEHAVIOR_ID
NUMBER(6,0) 		Unqiue database identifier for behavior observed
COMMENTS
VARCHAR2(2000 BYTE) 		Comments from hard copy form
DISTANCE_TO_GEAR
VARCHAR2(10 BYTE) 		Distance from observer to net in whole meters.
DISTANCE_TO_VESSEL
NUMBER(4,0) 		Distance from observer to animal sighted, in whole meters.
ID
NUMBER(6,0) 		Unique database record for identifier for sighting record, one of which represents a given row of data data on the hard copy Sighting Forms
LATITUDE
NUMBER(7,1) 		Latitude of initial observation
LONGITUDE
NUMBER(7,1) 		Longitude of initial observation
MONTH
NUMBER(2,0) 		Month
NUMBER_OF_INDIVIDUALS
NUMBER(4,0) 		Number of individual animals sighted.
OBSERVER_CODE
VARCHAR2(3 BYTE) 		AMMOP code for observer making observation
OBSERVER_ID
NUMBER(6,0) 		Unqiue database identifier for observer making observation
PLATFORM_CODE
VARCHAR2(1 BYTE) 		Platform from which observer made the sighting.
SEQUENCE_NUMBER
NUMBER(3,0) 		Sequence within parent identifier for a unique sighting, also including: observer, sighting_date, type_code
SIGHTING_DATE
DATE 		Date that sighting was made
SIGHTING_OBJECT_CODE
VARCHAR2(5 BYTE) 		AMMOP code for species or item observed; in 2005 on, only species are recorded
SIGHTING_OBJECT_ID
NUMBER(6,0) 		Unqiue database identifier for species or item observed; in 2005 on, only species are recorded
SIGHTING_TIME
NUMBER(5,0) 		Time (24 hour clock) of initial observation
TRIP_CODE
VARCHAR2(6 BYTE) 		AMMOP code for trip
TRIP_ID
NUMBER(6,0) 		Unqiue database identifier for trip to which sighting record is associated with, if it is associated with a trip
TYPE_CODE
VARCHAR2(2 BYTE) 		AMMOP code for Event Type from hard copy Sighting Form
TYPE_ID
NUMBER(10,0) 		Unique database identifier for Event Type from hard copy Sighting Form
WAVE_HEIGHT
NUMBER(3,1) 		Estimated wave height in meters to one decimal place.
WEATHER_CODE
VARCHAR2(1 BYTE) 		Weather at time of sighting event.
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_SIGHTING

Entity Information

Description:

In 2002, this table captured all sighting form data. From 2005 on, this table captures the header portion of the hard copy sighting form. MM_SIGHTING is parent to both mm_sighting_watch and mm_sighting_off_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) AMMOP code for behavior observed
100
 BEHAVIOR_ID NUMBER(6,0) Unqiue database identifier for behavior observed
100
 COMMENTS VARCHAR2(2000 BYTE) Comments from hard copy form
100
 DISTANCE_TO_GEAR VARCHAR2(10 BYTE) 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
 ID NUMBER(6,0) Unique database record for identifier for sighting record, one of which represents a given row of data data on the hard copy Sighting Forms
100
 LATITUDE NUMBER(7,1) Latitude of initial observation
100
 LONGITUDE NUMBER(7,1) Longitude of initial observation
100
 MONTH NUMBER(2,0) Month
100
 NUMBER_OF_INDIVIDUALS NUMBER(4,0) Number of individual animals sighted.
100
 OBSERVER_CODE VARCHAR2(3 BYTE) AMMOP code for observer making observation
100
 OBSERVER_ID NUMBER(6,0) Unqiue database identifier for observer making observation
100
 PLATFORM_CODE VARCHAR2(1 BYTE) Platform from which observer made the sighting.
100
 SEQUENCE_NUMBER NUMBER(3,0) Sequence within parent identifier for a unique sighting, also including: observer, sighting_date, type_code
100
 SIGHTING_DATE DATE Date that sighting was made
100
 SIGHTING_OBJECT_CODE VARCHAR2(5 BYTE) AMMOP code for species or item observed; in 2005 on, only species are recorded
100
 SIGHTING_OBJECT_ID NUMBER(6,0) Unqiue database identifier for species or item observed; in 2005 on, only species are recorded
100
 SIGHTING_TIME NUMBER(5,0) Time (24 hour clock) of initial observation
100
 TRIP_CODE VARCHAR2(6 BYTE) AMMOP code for trip
100
 TRIP_ID NUMBER(6,0) Unqiue database identifier for trip to which sighting record is associated with, if it is associated with a trip
100
 TYPE_CODE VARCHAR2(2 BYTE) AMMOP code for Event Type from hard copy Sighting Form
100
 TYPE_ID NUMBER(10,0) Unique database identifier for Event Type from hard copy Sighting Form
100
 WAVE_HEIGHT NUMBER(3,1) Estimated wave height in meters to one decimal place.
100
 WEATHER_CODE VARCHAR2(1 BYTE) Weather at time of sighting event.
100
 YEAR NUMBER(4,0) Year

Attribute Details

BEAUFORT_CODE

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

Sea State on the Beaufort Scale

BEHAVIOR_CODE

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

AMMOP code for behavior observed

BEHAVIOR_ID

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

Unqiue database identifier for behavior observed

COMMENTS

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

Comments from hard copy form

DISTANCE_TO_GEAR

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

Distance from observer to net in whole meters.

DISTANCE_TO_VESSEL

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

Distance from observer to animal sighted, in whole meters.

ID

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

Unique database record for identifier for sighting record, one of which represents a given row of data data on the hard copy Sighting Forms

LATITUDE

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

Latitude of initial observation

LONGITUDE

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

Longitude of initial observation

MONTH

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

Month

NUMBER_OF_INDIVIDUALS

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

Number of individual animals sighted.

OBSERVER_CODE

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

AMMOP code for observer making observation

OBSERVER_ID

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

Unqiue database identifier for observer making observation

PLATFORM_CODE

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

Platform from which observer made the sighting.

SEQUENCE_NUMBER

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

Sequence within parent identifier for a unique sighting, also including: observer, sighting_date, type_code

SIGHTING_DATE

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

Date that sighting was made

SIGHTING_OBJECT_CODE

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

AMMOP code for species or item observed; in 2005 on, only species are recorded

SIGHTING_OBJECT_ID

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

Unqiue database identifier for species or item observed; in 2005 on, only species are recorded

SIGHTING_TIME

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

Time (24 hour clock) of initial observation

TRIP_CODE

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

AMMOP code for trip

TRIP_ID

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

Unqiue database identifier for trip to which sighting record is associated with, if it is associated with a trip

TYPE_CODE

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

AMMOP code for Event Type from hard copy Sighting Form

TYPE_ID

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

Unique database identifier for Event Type from hard copy Sighting Form

WAVE_HEIGHT

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

Estimated wave height in meters to one decimal place.

WEATHER_CODE

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

Weather at time of sighting event.

YEAR

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

Year

Catalog Details

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