Issuer Role Data Map Table
- Natalie Gesin (Deactivated)
- Kinga Huszno
- Dmitry Donosiyan (Unlicensed)
- Anna Krapivina
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 | Ā | ||
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 | Ā | Ā | Ā | 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 | Ā |
Ā