Issuer Role Data Map Table

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

Element

Optional/ Required

Value Type

Star Tag

SP Parameter

SP TYPE

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

 

Element

Optional/ Required

Value Type

Star Tag

SP Parameter

SP TYPE

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

 

objectType

Optional

ObjectTypeEnum

 

 

 

not stored in DB

 

EagleML/referenceTransaction/issuerRole/objectType

 

objectId

Optional

ObjectId

 

 

 

not stored in DB

 

EagleML/referenceTransaction/issuerRole/objectId

 

objectDescription

Optional

FeedTypeEnum

 

 

 

not stored in DB

 

EagleML/referenceTransaction/issuerRole/objectDescription

 

updateTimestamp

Optional

dateTime

 

 

 

not stored in DB

 

EagleML/referenceTransaction/issuerRole/updateTimestamp

 

customElements

Not recommended

CustomElements

 

 

 

CustomElements - reserved for customizations

EagleML/referenceTransaction/issuerRole/customElements

 

sourceName

Optional

string

1102

in_short_desc

S

PACE_MASTERDBO

INTERFACES

SHORT_DESC

CHAR(15)

EagleML/referenceTransaction/issuerRole/sourceName

 

updateSource

Optional

string

944

in_ird_update_source

S

SECURITYDBO

ISSUER_ROLE_DETAILS

IRD_UPDATE_SOURCE

VARCHAR2(255)

EagleML/referenceTransaction/issuerRole/updateSource

 

effectiveDate

Optional

date

1109

in_effective_date

S

SECURITYDBO

ISSUER_ROLE_DETAILS_HIST

IRD_UPDATE_DATE

DATE

EagleML/referenceTransaction/issuerRole/effectiveDate

 

languageId

Optional

integer

 

 

 

not stored in DB

 

EagleML/referenceTransaction/issuerRole/languageId

 

tagNochangecase

Optional

string

4637

 

 

not stored in DB

 

EagleML/referenceTransaction/issuerRole/tagNochangecase

 

preserveNull

Optional

string

5284

 

 

not stored in DB

 

EagleML/referenceTransaction/issuerRole/preserveNull

 

noLoadValidationFlag

Optional

YesNoOptionEnum

 

 

 

not stored in DB, used to manage the download logic

 

EagleML/referenceTransaction/issuerRole/noLoadValidationFlag

 

accountingValidationFlag

Optional

YesNoOptionEnum

 

 

 

not stored in DB, used to manage the download logic

 

EagleML/referenceTransaction/issuerRole/accountingValidationFlag

 

Asset Identifiers Model

EagleML/referenceTransaction/issuerRole/

 

issuerId

Required

string

1144

 

 

SECURITYDBO

ISSUER_ORGANIZATION

ISSUER_ID

CHAR(20)

EagleML/referenceTransaction/issuerRole/issuerId

 

issuerName

Optional

string

1173

 

 

SECURITYDBO

ISSUER_ORGANIZATION

ISSUER_NAME

VARCHAR2(255)

EagleML/referenceTransaction/issuerRole/issuerName

 

issuerAlias

Optional

integer

1147

in_issuer_alias

N

SECURITYDBO

ISSUER_ROLE_DETAILS

ISSUER_ALIAS

NUMBER

EagleML/referenceTransaction/issuerRole/issuerAlias

 

issuerXrefIdentifiers

Optional

 IssuerXrefIdentifiers

 

 

 

IssuerXrefIdentifiers Model

EagleML/referenceTransaction/issuerRole/issuerXrefIdentifiers/

 

roleType

Required

string

3347

in_role_type

S

SECURITYDBO

ISSUER_ROLE_DETAILS

ROLE_TYPE

VARCHAR2(30)

EagleML/referenceTransaction/issuerRole/roleType

 

startDate

Required

date

71

in_start_date

S

SECURITYDBO

ISSUER_ROLE_DETAILS

START_DATE

DATE

EagleML/referenceTransaction/issuerRole/startDate

 

endDate

Optional

date

73

in_end_date

S

SECURITYDBO

ISSUER_ROLE_DETAILS

END_DATE

DATE

EagleML/referenceTransaction/issuerRole/endDate

 

percentOwned

Optional

decimal

3348

in_percent_owned

F

SECURITYDBO

ISSUER_ROLE_DETAILS

PERCENT_OWNED

NUMBER(28,12)

EagleML/referenceTransaction/issuerRole/percentOwned

 

irdUpdateDate

Optional

date

 

 

 

SECURITYDBO

ISSUER_ROLE_DETAILS

IRD_UPDATE_DATE

DATE

EagleML/referenceTransaction/issuerRole/irdUpdateDate

 

irdChar1

Optional

string

8286

in_ird_char1

S

SECURITYDBO

ISSUER_ROLE_DETAILS

IRD_CHAR1

VARCHAR2(30)

EagleML/referenceTransaction/issuerRole/irdChar1

 

irdChar2

Optional

string

8287

in_ird_char2

S

SECURITYDBO

ISSUER_ROLE_DETAILS

IRD_CHAR2

VARCHAR2(30)

EagleML/referenceTransaction/issuerRole/irdChar2

 

Â