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_EVENT_TYPE

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

Summary

Description

This table stores the pick list options for sighting event types.

Entity Information

Data Attribute / Type Description
BEGIN_DATE
DATE 		Start of useage
CODE
VARCHAR2(2 BYTE) 		AMMOP code for Event Type from hard copy Sighting Form
DESCRIPTION
VARCHAR2(50 BYTE) 		Event Type
END_DATE
DATE 		End of useage
ID
NUMBER(6,0) 		Unique database identifier for Event Type from hard copy Sighting Form
WATCH_FLAG
VARCHAR2(1 BYTE) 		Is the useage of this Event Type limited to AMMOP sighting watches?

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_EVENT_TYPE

Entity Information

Description:

This table stores the pick list options for sighting event types.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 BEGIN_DATE DATE Start of useage
100
 CODE VARCHAR2(2 BYTE) AMMOP code for Event Type from hard copy Sighting Form
100
 DESCRIPTION VARCHAR2(50 BYTE) Event Type
100
 END_DATE DATE End of useage
100
 ID NUMBER(6,0) Unique database identifier for Event Type from hard copy Sighting Form
100
 WATCH_FLAG VARCHAR2(1 BYTE) Is the useage of this Event Type limited to AMMOP sighting watches?

Attribute Details

BEGIN_DATE

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

Start of useage

CODE

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

AMMOP code for Event Type from hard copy Sighting Form

DESCRIPTION

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

Event Type

END_DATE

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

End of useage

ID

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

Unique database identifier for Event Type from hard copy Sighting Form

WATCH_FLAG

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

Is the useage of this Event Type limited to AMMOP sighting watches?

Catalog Details

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