Issuer Relationship Data Map Table

Owned by Natalie Gesin (Deactivated)
Last updated: Oct 30, 2024 by Kinga Huszno
1 min read

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/issuerRelationship/objectType

objectId

Optional

ObjectId

not stored in DB

 

 

 

EagleML/referenceTransaction/issuerRelationship/objectId

objectDescription

Optional

FeedTypeEnum

not stored in DB

 

 

 

EagleML/referenceTransaction/issuerRelationship/objectDescription

updateTimestamp

Optional

dateTime

SECURITYDBO

ISSUER_RELATIONSHIP

UPD_DATE

 

DATE

 

EagleML/referenceTransaction/issuerRelationship/updateTimestamp

customElements

Not recommended

CustomElements

reserved for customizations

EagleML/referenceTransaction/issuerRelationship/customElements

sourceName

Optional

string - used in resolution logic

PACE_MASTERDBO

INTERFACES

SHORT_DESC

1102

CHAR(15)

in_source

EagleML/referenceTransaction/issuerRelationship/sourceName

updateSource

Optional

string

SECURITYDBO

ISSUER_RELATIONSHIP

UPD_SOURCE

944

VARCHAR2(255)

in_update_source

EagleML/referenceTransaction/issuerRelationship/updateSource

effectiveDate

Optional

date

SECURITYDBO

ISSUER_RELATIONSHIP

EFFECTIVE_DATE

1109

DATE

in_effective_date

EagleML/referenceTransaction/issuerRelationship/effectiveDate

languageId

Optional

integer

not stored in DB

 

 

 

EagleML/referenceTransaction/issuerRelationship/languageId

tagNochangecase

Optional

string

not stored in DB

 

 

 

EagleML/referenceTransaction/issuerRelationship/tagNochangecase

preserveNull

Optional

string

not stored in DB

 

 

 

EagleML/referenceTransaction/issuerRelationship/preserveNull

noLoadValidationFlag

Optional

YesNoOptionEnum

not stored in DB

 

 

 

EagleML/referenceTransaction/issuerRelationship/noLoadValidationFlag

issuerId

Required

string

SECURITYDBO

ISSUER_ORGANIZATION

ISSUER_ID

 

CHAR(20)

 

EagleML/referenceTransaction/issuerRelationship/issuerId

issuerName

Optional

string

SECURITYDBO

ISSUER_ORGANIZATION

ISSUER_NAME

 

VARCHAR2(255)

 

EagleML/referenceTransaction/issuerRelationship/issuerName

issuerAlias

Optional

integer

SECURITYDBO

ISSUER_RELATIONSHIP

FROM_ISSUER_ALIAS

8289

NUMBER

in_from_issuer_alias

EagleML/referenceTransaction/issuerRelationship/issuerAlias

issuerXrefIdentifiers

IssuerXrefIdentifiers - Complex type (see extra table)

EagleML/referenceTransaction/issuerRelationship/issuerXrefIdentifiers/

fromIssuer

IssuerIdentifiersDataModel - Complex type (see extra table)

EagleML/referenceTransaction/issuerRelationship/fromIssuer/

toIssuer

IssuerIdentifiersDataModel - Complex type (see extra table)

EagleML/referenceTransaction/issuerRelationship/toIssuer/

roleType

Required

string

SECURITYDBO

ISSUER_RELATIONSHIP

ROLE_TYPE

8292

VARCHAR2(30)

in_role_type

EagleML/referenceTransaction/issuerRelationship/roleType

percentOwned

Optional

decimal

SECURITYDBO

ISSUER_RELATIONSHIP

PERCENT_OWNED

8291

NUMBER(28,12)

in_percent_owned

EagleML/referenceTransaction/issuerRelationship/percentOwned

Â