Issuer Entity Relationship Data Map Table

Element

Required Inbound Acct Validation

Value Type

Star Tag

SP Parameter

Eagle DB

DB Table

DB Field

DB Field Type

XPath

Element

Required Inbound Acct Validation

Value Type

Star Tag

SP Parameter

Eagle DB

DB Table

DB Field

DB Field Type

XPath

objectType

Required

ObjectTypeEnum

 

 

not stored in DB 

 

EagleML/referenceTransaction/issuerEntityRelationship/objectType

objectId

 

ObjectId

 

 

not stored in DB

 

EagleML/referenceTransaction/issuerEntityRelationship/objectId

objectDescription

 

FeedTypeEnum

 

 

not stored in DB

 

EagleML/referenceTransaction/issuerEntityRelationship/objectDescription

updateTimestamp

 

dateTime

 

 

SECURITYDBO

ISSUER_ENTITY_RELATION

UPDATE_DATE

DATE

EagleML/referenceTransaction/issuerEntityRelationship/updateTimestamp

customElements

Not recommended

CustomElements

 

 

reserved for customizations

EagleML/referenceTransaction/issuerEntityRelationship/customElements

sourceName

Required

string - used in resolution logic

1102

in_source

PACE_MASTERDBO

INTERFACES

SHORT_DESC

CHAR(15)

EagleML/referenceTransaction/issuerEntityRelationship/sourceName

updateSource

 

string

944

in_update_source

SECURITYDBO

ISSUER_ENTITY_RELATION

UPDATE_SOURCE

VARCHAR2(255)

EagleML/referenceTransaction/issuerEntityRelationship/updateSource

effectiveDate

Required

date

1109

in_effective_date

SECURITYDBO

ISSUER_ENTITY_RELATION

EFFECTIVE_DATE

DATE

EagleML/referenceTransaction/issuerEntityRelationship/effectiveDate

languageId

 

integer

 

 

not stored in DB

 

EagleML/referenceTransaction/issuerEntityRelationship/languageId

tagNochangecase

 

string

 

 

not stored in DB

 

EagleML/referenceTransaction/issuerEntityRelationship/tagNochangecase

preserveNull

 

string

 

 

not stored in DB

 

EagleML/referenceTransaction/issuerEntityRelationship/preserveNull

noLoadValidationFlag

 

YesNoOptionEnum

 

 

not stored in DB

 

EagleML/referenceTransaction/issuerEntityRelationship/noLoadValidationFlag

accountingValidationFlag

 

YesNoOptionEnum

 

 

not stored in DB

 

EagleML/referenceTransaction/issuerEntityRelationship/accountingValidationFlag

skipIfExistFlag

 

YesNoOptionEnum

 

 

not stored in DB

 

EagleML/referenceTransaction/issuerEntityRelationship/skipIfExistFlag

Issuer Identifiers Model

EagleML/referenceTransaction/issuerEntityRelationship/

Entity Common Id Model

EagleML/referenceTransaction/issuerEntityRelationship/

startDate

 

date

220

in_start_date

SECURITYDBO

ISSUER_ENTITY_RELATION

START_DATE

DATE

EagleML/referenceTransaction/issuerEntityRelationship/startDate

endDate

 

date

221

in_end_date

SECURITYDBO

ISSUER_ENTITY_RELATION

END_DATE

DATE

EagleML/referenceTransaction/issuerEntityRelationship/endDate

ownershipType

 

string

8292

in_ownership_type

SECURITYDBO

ISSUER_ENTITY_RELATION

RELATIONSHIP_TYPE

VARCHAR2(20)

EagleML/referenceTransaction/issuerEntityRelationship/ownershipType

percentOwned

 

decimal

8291

in_percent_owned

SECURITYDBO

ISSUER_ENTITY_RELATION

PERCENT_OWNED

NUMBER(38,12)

EagleML/referenceTransaction/issuerEntityRelationship/percentOwned

startComments

 

string

12075

in_start_comments

SECURITYDBO

ISSUER_ENTITY_RELATION

START_COMMENTS

VARCHAR2(2000)

EagleML/referenceTransaction/issuerEntityRelationship/startComments

endComments

 

string

2520

in_end_comments

SECURITYDBO

ISSUER_ENTITY_RELATION

END_COMMENTS

VARCHAR2(2000)

EagleML/referenceTransaction/issuerEntityRelationship/endComments

Â