Registry table of securities - Enriched

Cube ID

RGSTRY_TBL_SCRTS_E

Generated by transformation

T_RGSTRY_TBL_SCRTS_E

Cube Structure Items

Variable ID Role Subdomain
Security identifier SCRTY_ID Dimension String up to 60 characters limited to letters (capital and low cases), numbers, dash and underscore
Geografical location of the collateral CLLTRL_LCTN Observation ISO 3166-1 alpha-2 code of the country
Credit quality step CRDT_QLTY_STP Observation Credit quality step - full domain
Currency denomination of instruments CRRNCY_DNMNTN Observation Subdomain for domain ISO-4217 Currency Codes (ISO4217 Domain)
Issue date DT_ISS Observation All possible dates
Maturity date DT_MTRTY Observation All possible dates
Security status date DT_SCRTY_STTS Observation All possible dates
ECAI/ECA ECAI_ECA Observation ECAI/ECA - full domain
External credit assessment EXTRNL_CRDT_ASSSSMNT Observation Generic subdomain strings
Guarantor ID GRNTR_ID Observation String up to 60 characters limited to letters (capital and low cases), numbers, dash and underscore
Is covered bond IS_CVRD_BND Observation Pure boolean (true and false values)
Is listed IS_LSTD Observation Boolean including Not Applicable
Is particular high risk IS_PRTCLR_HGH_RSK Observation Pure boolean (true and false values)
Is short-term credit assessment IS_SHRT_TRM_CRDT_ASSSSMNT Observation Pure boolean (true and false values)
ISIN ISIN Observation String up to 60 characters limited to letters (capital and low cases), numbers, dash and underscore
Issuer identifier ISSR_ID Observation String up to 60 characters limited to letters (capital and low cases), numbers, dash and underscore
Classification of the instrument PRMRY_ASST_CLSSFCTN Observation Full list of the classification of the instruments
Security Guarantee level SCRTY_GRNT_LVL Observation Full list of the Security Guarantee level
Security level SCRTY_LVL Observation Full list of the security level
Security rank level SCRTY_RNK_LVL Observation Full list of the security rank level
Status of the security, whether the instrument is active and not active SCRTY_STTS Observation Full list of the security status
Type of asset provided as security TYP_ASST_SCRTSTN Observation Full list of type of asset
Type of instrument TYP_INSTRMNT Observation Instruments (securities) used in SHS
Number of units or aggregated nominal value UNT_MSR_NV Observation full subdomain

Legal references

  • No legal references provided