Generic SMF - Security Regulatory Model
- Alexey Chunikhin
- Kinga Huszno
Element | Optional/ Required | Value Type | Star Tag | SP Parameter | SP Type | Include File Name | Eagle DB | DB Table | DB Field | DB Field Type | Xpath |
|---|---|---|---|---|---|---|---|---|---|---|---|
sanctionReferenceCapital |
| string | 18353 |
|
|
| SECURITYDBO | SECURITY_REGULATORY | REF_CAPITAL | VARCHAR2(20) | EagleML/referenceTransaction/genericSMF/securityRegulatoryModel/isAdmittedToTradng |
sanctionActualCapital |
| string | 18354 |
|
|
| SECURITYDBO | SECURITY_REGULATORY | ACT_CAPITAL | VARCHAR2(20) | EagleML/referenceTransaction/genericSMF/securityRegulatoryModel/sanctionActualCapital |
confidenceLevel |
| integer | 18352 |
|
|
| SECURITYDBO | SECURITY_REGULATORY | CONFID_LVL | NUMBER(38) | EagleML/referenceTransaction/genericSMF/securityRegulatoryModel/confidenceLevel |
sanctionedIndicator |
| YesNoOptionEnum | 18351 |
|
|
| SECURITYDBO | SECURITY_REGULATORY | SANCTIONED | VARCHAR2(20) | EagleML/referenceTransaction/genericSMF/securityRegulatoryModel/sanctionedIndicator |
europeanSanctionDirective |
| string | 18355 |
|
|
| SECURITYDBO | SECURITY_REGULATORY | EU_SANC | VARCHAR2(2000) | EagleML/referenceTransaction/genericSMF/securityRegulatoryModel/europeanSanctionDirective |
unitedStatesSDNSanctionDirective |
| string | 18356 |
|
|
| SECURITYDBO | SECURITY_REGULATORY | US_SDN_SANC | VARCHAR2(2000) | EagleML/referenceTransaction/genericSMF/securityRegulatoryModel/unitedStatesSDNSanctionDirective |
unitedStatesNonSDNSanctionDirective |
| string | 18357 |
|
|
| SECURITYDBO | SECURITY_REGULATORY | US_NON_SDN_SANC | VARCHAR2(2000) | EagleML/referenceTransaction/genericSMF/securityRegulatoryModel/unitedStatesNonSDNSanctionDirective |
unitedNationsSanctionDirective |
| string | 18358 |
|
|
| SECURITYDBO | SECURITY_REGULATORY | UN_SANC | VARCHAR2(2000) | EagleML/referenceTransaction/genericSMF/securityRegulatoryModel/unitedNationsSanctionDirective |
hongKongSanctionDirective |
| string | 18359 |
|
|
| SECURITYDBO | SECURITY_REGULATORY | HK_SANC | VARCHAR2(2000) | EagleML/referenceTransaction/genericSMF/securityRegulatoryModel/hongKongSanctionDirective |
unitedKindomSanctionDirective |
| string | 18360 |
|
|
| SECURITYDBO | SECURITY_REGULATORY | UK_SANC | VARCHAR2(2000) | EagleML/referenceTransaction/genericSMF/securityRegulatoryModel/unitedKindomSanctionDirective |
chinaSanctionDirective |
| string | 18361 |
|
|
| SECURITYDBO | SECURITY_REGULATORY | CH_SANC | VARCHAR2(2000) | EagleML/referenceTransaction/genericSMF/securityRegulatoryModel/chinaSanctionDirective |
canadaSanctionDirective |
| string | 18362 |
|
|
| SECURITYDBO | SECURITY_REGULATORY | CA_SANC | VARCHAR2(2000) | EagleML/referenceTransaction/genericSMF/securityRegulatoryModel/canadaSanctionDirective |
australiaSanctionDirective |
| string | 18363 |
|
|
| SECURITYDBO | SECURITY_REGULATORY | AU_SANC | VARCHAR2(2000) | EagleML/referenceTransaction/genericSMF/securityRegulatoryModel/australiaSanctionDirective |
singaporeSanctionDirective |
| string | 18364 |
|
|
| SECURITYDBO | SECURITY_REGULATORY | SG_SANC | VARCHAR2(2000) | EagleML/referenceTransaction/genericSMF/securityRegulatoryModel/singaporeSanctionDirective |
sanctionTargetCountry |
| string | 18365 |
|
|
| SECURITYDBO | SECURITY_REGULATORY | TARGET_SANC | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/securityRegulatoryModel/sanctionTargetCountry |
instrumentStatus |
| string | 18366 |
|
|
| SECURITYDBO | SECURITY_REGULATORY | STATUS | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/securityRegulatoryModel/instrumentStatus |
sanctionChangeReasonMemo |
| string | 18367 |
|
|
| SECURITYDBO | SECURITY_REGULATORY | CHANGE_REASON | VARCHAR2(2000) | EagleML/referenceTransaction/genericSMF/securityRegulatoryModel/sanctionChangeReasonMemo |
sanctionRationaleMemo |
| string | 18368 |
|
|
| SECURITYDBO | SECURITY_REGULATORY | SANC_RATIONALE | VARCHAR2(2000) | EagleML/referenceTransaction/genericSMF/securityRegulatoryModel/sanctionRationaleMemo |