MM_EXCEPTION
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:75168 | Updated: May 21, 2025 | Published / External
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
|
|
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 |