Security Overrides Data Map Table

Element

Optional/Required

Value Type

Eagle DB

DB Table

DB Field

Star Tag

DB Field Type

SP Parameter

Xpath

Element

Optional/Required

Value Type

Eagle DB

DB Table

DB Field

Star Tag

DB Field Type

SP Parameter

Xpath

objectType

Optional

ObjectTypeEnum

not stored in DB

 

 

 

EagleML/referenceTransaction/securityOverrides/objectType

objectId

Optional

ObjectId

not stored in DB

 

 

 

EagleML/referenceTransaction/securityOverrides/objectId

objectDescription

Optional

FeedTypeEnum

not stored in DB

 

 

 

EagleML/referenceTransaction/securityOverrides/objectDescription

updateTimestamp

Optional

dateTime

SECURITYDBO

SECURITY_OVERRIDES

UPDATE_DATE

 

DATE

 

EagleML/referenceTransaction/securityOverrides/updateTimestamp

customElements

Not recommended

CustomElements - Complex type

reserved for customizations

 

 

 

EagleML/referenceTransaction/securityOverrides/customElements

sourceName

Optional

string - used for resolution logics

PACE_MASTERDBO

INTERFACES

SHORT_DESC

1102

CHAR(15)

in_short_desc

EagleML/referenceTransaction/securityOverrides/sourceName

updateSource

Optional

string

SECURITYDBO

SECURITY_OVERRIDES

UPDATE_SOURCE

944

VARCHAR2(255)

in_update_user

EagleML/referenceTransaction/securityOverrides/updateSource

effectiveDate

Optional

date

SECURITYDBO

SECURITY_OVERRIDES

UPDATE_DATE

1109

DATE

 

EagleML/referenceTransaction/securityOverrides/effectiveDate

languageId

Optional

integer

not stored in DB

 

 

 

EagleML/referenceTransaction/securityOverrides/languageId

tagNochangecase

Optional

string

not stored in DB

 

 

 

EagleML/referenceTransaction/securityOverrides/tagNochangecase

preserveNull

Optional

string

not stored in DB

 

 

 

EagleML/referenceTransaction/securityOverrides/preserveNull

noLoadValidationFlag

Optional

YesNoOptionEnum

not stored in DB

 

 

 

EagleML/referenceTransaction/securityOverrides/noLoadValidationFlag

accountingValidationFlag

Optional

YesNoOptionEnum

not stored in DB

 

 

 

EagleML/referenceTransaction/securityOverrides/accountingValidationFlag

Asset Identifiers Model

 

EagleML/referenceTransaction/securityOverrides/

tableName

Optional

string

PACE_MASTERDBO

PACE_INV_TABLES

TABLE_NAME

1768

CHAR(50)

 

EagleML/referenceTransaction/securityOverrides/tableName

fieldName

Optional

string

PACE_MASTERDBO

PACE_INV_FIELDS

FIELD_NAME

1769

CHAR(100)

 

EagleML/referenceTransaction/securityOverrides/fieldName

fieldId

Optional

integer

SECURITYDBO

SECURITY_OVERRIDES

FIELD_ID

4870

NUMBER

in_field_id

EagleML/referenceTransaction/securityOverrides/fieldId

starTag

Optional

integer

PACE_MASTERDBO

PACE_INV_FIELDS

STAR_TAG

3251

VARCHAR2(25)

in_tag

EagleML/referenceTransaction/securityOverrides/starTag

valueChar

Optional

string

SECURITYDBO

SECURITY_OVERRIDES

VALUE_CHAR

1771

VARCHAR2(255)

in_value_char

EagleML/referenceTransaction/securityOverrides/valueChar

startDate

Optional

date

SECURITYDBO

SECURITY_OVERRIDES

BEGIN_DATE

71

DATE

in_begin_date

EagleML/referenceTransaction/securityOverrides/startDate

endDate

Optional

date

SECURITYDBO

SECURITY_OVERRIDES

END_DATE

73

DATE

in_end_date

EagleML/referenceTransaction/securityOverrides/endDate

comments

Optional

string

SECURITYDBO

SECURITY_OVERRIDES

COMMENTS

10498

VARCHAR2(500)

in_comments

EagleML/referenceTransaction/securityOverrides/comments

reasonCode

Optional

string

SECURITYDBO

SECURITY_OVERRIDES

REASON_CODE

10497

VARCHAR2(20)

in_reason_code

EagleML/referenceTransaction/securityOverrides/reasonCode

tempOverlay

Optional

YesNoOptionEnum

SECURITYDBO

SECURITY_OVERRIDES

TEMP_OVERLAY

5865

VARCHAR2(2)

in_temp_overlay

EagleML/referenceTransaction/securityOverrides/tempOverlay

originalValue

Optional

string

SECURITYDBO

SECURITY_OVERRIDES

ORIG_VALUE

 

VARCHAR2(255)

 

EagleML/referenceTransaction/securityOverrides/originalValue

sourceSrcIntfcName

Optional

string

PACE_MASTERDBO

INTERFACES

SHORT_DESC

 

CHAR(15)

 

EagleML/referenceTransaction/securityOverrides/sourceSrcIntfcName

sourceSrcIntfcInst

Optional

string

SECURITYDBO

SECURITY_OVERRIDES

SOURCE_SRC_INTFC_INST

 

NUMBER(38)

 

EagleML/referenceTransaction/securityOverrides/sourceSrcIntfcInst

instance

Optional

integer

SECURITYDBO

SECURITY_OVERRIDES

INSTANCE

 

NUMBER

 

EagleML/referenceTransaction/securityOverrides/instance

Â