Issuer Relationship Data Map Table
- Natalie Gesin (Deactivated)
- Dmitry Donosiyan (Unlicensed)
Element | Optional/Required | Value Type | Eagle DB | DB Table | DB Field | Star Tag | DB Field Type | SP Parameter | XPath |
|---|---|---|---|---|---|---|---|---|---|
objectType | Optional | ObjectTypeEnum | not stored in DB | Â | Â | Â | EagleML/referenceTransaction/issuerRelationship/objectType | ||
objectId | Optional | ObjectId | not stored in DB | Â | Â | Â | EagleML/referenceTransaction/issuerRelationship/objectId | ||
objectDescription | Optional | FeedTypeEnum | not stored in DB | Â | Â | Â | EagleML/referenceTransaction/issuerRelationship/objectDescription | ||
updateTimestamp | Optional | dateTime | SECURITYDBO | ISSUER_RELATIONSHIP | UPD_DATE | Â | DATE | Â | EagleML/referenceTransaction/issuerRelationship/updateTimestamp |
customElements | Not recommended | CustomElements | reserved for customizations | EagleML/referenceTransaction/issuerRelationship/customElements | |||||
sourceName | Optional | string - used in resolution logic | PACE_MASTERDBO | INTERFACES | SHORT_DESC | 1102 | CHAR(15) | in_source | EagleML/referenceTransaction/issuerRelationship/sourceName |
updateSource | Optional | string | SECURITYDBO | ISSUER_RELATIONSHIP | UPD_SOURCE | 944 | VARCHAR2(255) | in_update_source | EagleML/referenceTransaction/issuerRelationship/updateSource |
effectiveDate | Optional | date | SECURITYDBO | ISSUER_RELATIONSHIP | EFFECTIVE_DATE | 1109 | DATE | in_effective_date | EagleML/referenceTransaction/issuerRelationship/effectiveDate |
languageId | Optional | integer | not stored in DB | Â | Â | Â | EagleML/referenceTransaction/issuerRelationship/languageId | ||
tagNochangecase | Optional | string | not stored in DB | Â | Â | Â | EagleML/referenceTransaction/issuerRelationship/tagNochangecase | ||
preserveNull | Optional | string | not stored in DB | Â | Â | Â | EagleML/referenceTransaction/issuerRelationship/preserveNull | ||
noLoadValidationFlag | Optional | YesNoOptionEnum | not stored in DB | Â | Â | Â | EagleML/referenceTransaction/issuerRelationship/noLoadValidationFlag | ||
issuerId | Required | string | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_ID | Â | CHAR(20) | Â | EagleML/referenceTransaction/issuerRelationship/issuerId |
issuerName | Optional | string | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_NAME | Â | VARCHAR2(255) | Â | EagleML/referenceTransaction/issuerRelationship/issuerName |
issuerAlias | Optional | integer | SECURITYDBO | ISSUER_RELATIONSHIP | FROM_ISSUER_ALIAS | 8289 | NUMBER | in_from_issuer_alias | EagleML/referenceTransaction/issuerRelationship/issuerAlias |
issuerXrefIdentifiers | EagleML/referenceTransaction/issuerRelationship/issuerXrefIdentifiers/ | ||||||||
fromIssuer | EagleML/referenceTransaction/issuerRelationship/fromIssuer/ | ||||||||
toIssuer | EagleML/referenceTransaction/issuerRelationship/toIssuer/ | ||||||||
roleType | Required | string | SECURITYDBO | ISSUER_RELATIONSHIP | ROLE_TYPE | 8292 | VARCHAR2(30) | in_role_type | EagleML/referenceTransaction/issuerRelationship/roleType |
percentOwned | Optional | decimal | SECURITYDBO | ISSUER_RELATIONSHIP | PERCENT_OWNED | 8291 | NUMBER(28,12) | in_percent_owned | EagleML/referenceTransaction/issuerRelationship/percentOwned |