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_EXCEPTION

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

Summary

Description

This is a log of any occasion where errors were noted when constraints were violated

Entity Information

Data Attribute / Type Description
CREATOR
VARCHAR2(50 BYTE) 		The identity of the user at the time a marine mammal exception event occurred.
EXCEPTION_DATE
DATE 		Identifies when a marine mammal exception event occurred.
EXCEPTION_LOCATION
VARCHAR2(200 BYTE) 		The table name and unique identifier of the record which caused the exception event. The format is a comma delimited string as follows Table_Name,unique_record_id
EXCEPTION_STATUS_CODE
VARCHAR2(1 BYTE) 		The current status of an exception. 1-unverified, 2-research, 3-resolved
EXCEPTION_TEXT
VARCHAR2(200 BYTE) 		Text constructed by the function that raises the exception to indicate the specific conditions which caused the exception.
ID
NUMBER(6,0) 		Oracle Sequence
RESOLVED_BY
VARCHAR2(5 BYTE) 		The initials of the individual who resolved exception.
RESOLVED_DATE
DATE 		The date that a marine mammal exception was resolved.

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_EXCEPTION

Entity Information

Description:

This is a log of any occasion where errors were noted when constraints were violated

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 CREATOR VARCHAR2(50 BYTE) The identity of the user at the time a marine mammal exception event occurred.
100
 EXCEPTION_DATE DATE Identifies when a marine mammal exception event occurred.
100
 EXCEPTION_LOCATION VARCHAR2(200 BYTE) The table name and unique identifier of the record which caused the exception event. The format is a comma delimited string as follows Table_Name,unique_record_id
100
 EXCEPTION_STATUS_CODE VARCHAR2(1 BYTE) The current status of an exception. 1-unverified, 2-research, 3-resolved
100
 EXCEPTION_TEXT VARCHAR2(200 BYTE) Text constructed by the function that raises the exception to indicate the specific conditions which caused the exception.
100
 ID NUMBER(6,0) Oracle Sequence
100
 RESOLVED_BY VARCHAR2(5 BYTE) The initials of the individual who resolved exception.
100
 RESOLVED_DATE DATE The date that a marine mammal exception was resolved.

Attribute Details

CREATOR

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

The identity of the user at the time a marine mammal exception event occurred.

EXCEPTION_DATE

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

Identifies when a marine mammal exception event occurred.

EXCEPTION_LOCATION

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

The table name and unique identifier of the record which caused the exception event. The format is a comma delimited string as follows Table_Name,unique_record_id

EXCEPTION_STATUS_CODE

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

The current status of an exception. 1-unverified, 2-research, 3-resolved

EXCEPTION_TEXT

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

Text constructed by the function that raises the exception to indicate the specific conditions which caused the exception.

ID

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

Oracle Sequence

RESOLVED_BY

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

The initials of the individual who resolved exception.

RESOLVED_DATE

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

The date that a marine mammal exception was resolved.

Catalog Details

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