Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
OPR Meta Data Library > Permits and Conservation Division (F/PR1) > Public Display of Marine Mammals > National Inventory of Marine Mammals (NIMM) >

Table: ERROR_CODES

Entity (ENT)  |  NMFS Office Of Protected Resources (OPR)
GUID: gov.noaa.nmfs.inport:26992  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

This table captures different errors/exceptions used in the system.

Description

This table captures different errors/exceptions used in the system.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ERROR_CODE_ID
NUMBER 		System generated unique identifier for an error type
ERRC_TYPE
VARCHAR2 		Indicates if this is a Database error, Java application error, Apex error, etc.
ERRC_DISPLAY_CODE
VARCHAR2 		Unique short name or abbreviation code for an error.
ERRC_DEFAULT_MESSAGE
VARCHAR2 		Default error message associated with this error code. If caller doesn't provide a custom error message, this default message will be used when raising an exception.
ERRC_SEVERITY_LEVEL
NUMBER 		Indicate the severity of this error. 1 = Info, 2 = Warning, 3 = Error, 4 = Fatal.
DATE_CREATED
DATE 		Date this record was inserted
CREATED_BY
VARCHAR2 		The user who inserted this record
DATE_MODIFIED
DATE 		Date of the most recent modification to the record
MODIFIED_BY
VARCHAR2 		The last user who modified this record

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (OPR) for inquiries on this record.

Item Identification

Title: Table: ERROR_CODES
Short Name: ERROR_CODES
Status: Completed
Abstract:

This table captures different errors/exceptions used in the system.
Notes:

Loaded by batch 7077, 09-17-2015 08:15

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: NIMM_APPS
Description:

This table captures different errors/exceptions used in the system.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key ERROR_CODE_ID NUMBER System generated unique identifier for an error type
100
 ERRC_TYPE VARCHAR2 Indicates if this is a Database error, Java application error, Apex error, etc.
100
 ERRC_DISPLAY_CODE VARCHAR2 Unique short name or abbreviation code for an error.
100
 ERRC_DEFAULT_MESSAGE VARCHAR2 Default error message associated with this error code. If caller doesn't provide a custom error message, this default message will be used when raising an exception.
100
 ERRC_SEVERITY_LEVEL NUMBER Indicate the severity of this error. 1 = Info, 2 = Warning, 3 = Error, 4 = Fatal.
100
 DATE_CREATED DATE Date this record was inserted
100
 CREATED_BY VARCHAR2 The user who inserted this record
100
 DATE_MODIFIED DATE Date of the most recent modification to the record
100
 MODIFIED_BY VARCHAR2 The last user who modified this record

Attribute Details

ERROR_CODE_ID

CC ID: 219110
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 10
Scale: 0
Status: Active
Description:

System generated unique identifier for an error type
General Data Type: NUMBER

ERRC_TYPE

CC ID: 219111
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 50
Required: Yes
Primary Key: No
Status: Active
Description:

Indicates if this is a Database error, Java application error, Apex error, etc.
General Data Type: VARCHAR2

ERRC_DISPLAY_CODE

CC ID: 219112
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 50
Required: Yes
Primary Key: No
Status: Active
Description:

Unique short name or abbreviation code for an error.
General Data Type: VARCHAR2

ERRC_DEFAULT_MESSAGE

CC ID: 219113
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Default error message associated with this error code. If caller doesn't provide a custom error message, this default message will be used when raising an exception.
General Data Type: VARCHAR2

ERRC_SEVERITY_LEVEL

CC ID: 219114
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Indicate the severity of this error. 1 = Info, 2 = Warning, 3 = Error, 4 = Fatal.
General Data Type: NUMBER

DATE_CREATED

CC ID: 219115
Seq. Order: 6
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Date this record was inserted
General Data Type: DATE

CREATED_BY

CC ID: 219116
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 200
Required: Yes
Primary Key: No
Status: Active
Description:

The user who inserted this record
General Data Type: VARCHAR2

DATE_MODIFIED

CC ID: 219117
Seq. Order: 8
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date of the most recent modification to the record
General Data Type: DATE

MODIFIED_BY

CC ID: 219118
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 200
Required: No
Primary Key: No
Status: Active
Description:

The last user who modified this record
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 26992
GUID: gov.noaa.nmfs.inport:26992
Metadata Record Created By: Nathan Wilson
Metadata Record Created: 2015-09-17 08:15+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2018-05-16
Owner Org: OPR
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-05-16
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-05-16