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