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