Error Definition Data Map Table

Element

Required/Optional

Value Type

Star Tag

SP Parameter

Eagle DB

DB Table

DB Field

DB Field Type

XPath

Element

Required/Optional

Value Type

Star Tag

SP Parameter

Eagle DB

DB Table

DB Field

DB Field Type

XPath

objectType

 

ObjectTypeEnum

 

 

not stored in DB

 

EagleML/referenceTransaction/errorDefinition/objectType

objectId

 

ObjectId

 

 

not stored in DB

 

EagleML/referenceTransaction/errorDefinition/objectId

objectDescription

 

FeedTypeEnum

 

 

not stored in DB

 

EagleML/referenceTransaction/errorDefinition/objectDescription

updateTimestamp

 

dateTime

 

 

PACE_MASTERDBO

EGL_ERROR

UPDATE_DATE

DATE

EagleML/referenceTransaction/errorDefinition/updateTimestamp

customElements

Not recommended

CustomElements

reserved for customization

EagleML/referenceTransaction/errorDefinition/customElements

sourceName

 

string

 

 

PACE_MASTERDBO

INTERFACES

SHORT_DESC

VARCHAR2(15)

EagleML/referenceTransaction/errorDefinition/sourceName

updateSource

 

string

 

 

PACE_MASTERDBO

EGL_ERROR

UPDATE_SOURCE

VARCHAR2(255)

EagleML/referenceTransaction/errorDefinition/updateSource

effectiveDate

 

date

 

 

not stored in DB

 

EagleML/referenceTransaction/errorDefinition/effectiveDate

languageId

 

integer

 

 

not stored in DB

 

EagleML/referenceTransaction/errorDefinition/languageId

tagNochangecase

 

string

 

 

not stored in DB

 

EagleML/referenceTransaction/errorDefinition/tagNochangecase

preserveNull

 

string

 

 

not stored in DB

 

EagleML/referenceTransaction/errorDefinition/preserveNull

noLoadValidationFlag

 

YesNoOptionEnum

 

 

not stored in DB

 

EagleML/referenceTransaction/errorDefinition/noLoadValidationFlag

accountingValidationFlag

 

YesNoOptionEnum

 

 

not stored in DB

 

EagleML/referenceTransaction/errorDefinition/accountingValidationFlag

errorCode

 

string

 

 

PACE_MASTERDBO

EGL_ERROR

ERROR_CODE

VARCHAR2(20)

EagleML/referenceTransaction/errorDefinition/errorCode

errorSeverity

 

integer

 

 

PACE_MASTERDBO

EGL_ERROR

ERROR_SEVERITY

NUMBER(38)

EagleML/referenceTransaction/errorDefinition/errorSeverity

errorSource

 

string

 

 

PACE_MASTERDBO

EGL_ERROR

ERROR_SOURCE

VARCHAR2(10)

EagleML/referenceTransaction/errorDefinition/errorSource

isCore

 

integer

 

 

PACE_MASTERDBO

EGL_ERROR

IS_CORE

NUMBER(38)

EagleML/referenceTransaction/errorDefinition/isCore

moduleId

 

integer

 

 

not stored in DB

 

EagleML/referenceTransaction/errorDefinition/moduleId

originInstance

 

integer

 

 

PACE_MASTERDBO

EGL_ERROR

ORIGIN_INSTANCE

NUMBER(38)

EagleML/referenceTransaction/errorDefinition/originInstance

centerCode

 

string

 

 

PACE_MASTERDBO

EGL_ERROR

CENTER_CODE

VARCHAR2(30)

EagleML/referenceTransaction/errorDefinition/centerCode

editFlag

 

integer

 

 

PACE_MASTERDBO

EGL_ERROR

EDIT_FLAG

NUMBER(38)

EagleML/referenceTransaction/errorDefinition/editFlag

wrapperContext

 

string

 

 

PACE_MASTERDBO

EGL_ERROR

WRAPPER_CONTEXT

NVARCHAR2(1000)

EagleML/referenceTransaction/errorDefinition/wrapperContext

bkupModuleId

 

integer

 

 

PACE_MASTERDBO

EGL_ERROR

BKUP_MODULE_ID

NUMBER(38)

EagleML/referenceTransaction/errorDefinition/bkupModuleId

languageDefinition

Required by the XSD

ErrorLanguageDefinition (see extra table below)

EagleML/referenceTransaction/errorDefinition/

ErrorLanguageDefinition Data Map Table

lId

 

integer

 

 

PACE_MASTERDBO

EGL_ERROR_ML

L_ID

NUMBER(38)

EagleML/referenceTransaction/errorDefinition/languageDefinition/lId

errorCode

 

string

 

 

PACE_MASTERDBO

EGL_ERROR_ML

ERROR_CODE

VARCHAR2(20)

EagleML/referenceTransaction/errorDefinition/languageDefinition/errorCode

errorDesc

 

string

 

 

PACE_MASTERDBO

EGL_ERROR_ML

ERROR_DESCRIPTION

NVARCHAR2(250)

EagleML/referenceTransaction/errorDefinition/languageDefinition/errorDesc

errorBusDesc

 

string

 

 

PACE_MASTERDBO

EGL_ERROR_ML

ERROR_BUS_DESC

NVARCHAR2(1000)

EagleML/referenceTransaction/errorDefinition/languageDefinition/errorBusDesc

errorResolution

 

string

 

 

PACE_MASTERDBO

EGL_ERROR_ML

ERROR_RESOLUTION

NVARCHAR2(1000)

EagleML/referenceTransaction/errorDefinition/languageDefinition/errorResolution

 

Â