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 |
|