> ## Documentation Index
> Fetch the complete documentation index at: https://docs.activeviam.com/llms.txt
> Use this file to discover all available pages before exploring further.

# SECURITY

The **SECURITY** table

| Column Name      | Type   | Not Null | Cube Field                                                         | Description                                                                                                                                                                                                                                                                                                                                                                                                                                                         |
| ---------------- | ------ | -------- | ------------------------------------------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| AS\_OF\_DATE     | DATE   | Y        |                                                                    | See field in joined table ([SASENSITIVITIES](./sasensitivities)) Timestamp (at close of business) for the data.                                                                                                                                                                                                                                                                                                                                                     |
| SECURITY         | STRING | Y        | [DRC Sec CTP Security](../cube/drc-sec-ctp-security)               | The underlying product of the trade that could be an obligor or a fully qualified tranche (with the series, attachment and detachment).                                                                                                                                                                                                                                                                                                                             |
| RISK\_CLASS      | STRING | Y        |                                                                    | Always "DRC Sec CTP"                                                                                                                                                                                                                                                                                                                                                                                                                                                |
| BUCKET           | STRING | Y        | [DRC Sec CTP Bucket](../cube/drc-sec-ctp-bucket)                   | Obligor or Index the underlying relies on (see BCBS 457, [MRA22.40](https://www.bis.org/basel_framework/chapter/MRA/22.htm?inforce=20230101\&published=20200327#paragraph_MRA_22_20230101_22_40)([https://www.bis.org/basel\_framework/chapter/MAR/22.htm?inforce=20230101\&published=20200327#paragraph\_MAR\_22\_20230101\_22\_40](https://www.bis.org/basel_framework/chapter/MAR/22.htm?inforce=20230101\&published=20200327#paragraph_MAR_22_20230101_22_40))) |
| SENIORITY        | STRING |          | [DRC Sec CTP Seniority](../cube/drc-sec-ctp-seniority)             | "Senior" or "Junior".                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| RATING           | STRING |          | [DRC Sec CTP Rating](../cube/drc-sec-ctp-rating)                   | From AAA to Default.                                                                                                                                                                                                                                                                                                                                                                                                                                                |
| TYPE             | STRING |          | [DRC Sec CTP Rating Type](../cube/drc-sec-ctp-rating-type)         | Rating type : STC or empty for non-STC.                                                                                                                                                                                                                                                                                                                                                                                                                             |
| ATTACHMENT       | DOUBLE |          | [DRC Sec CTP Attachment](../cube/drc-sec-ctp-attachment)           | The start of the tranche or empty if non-tranched product.                                                                                                                                                                                                                                                                                                                                                                                                          |
| DETACHMENT       | DOUBLE |          | [DRC Sec CTP Detachment](../cube/drc-sec-ctp-detachment)           | The end of the tranche or empty if non-tranched product.                                                                                                                                                                                                                                                                                                                                                                                                            |
| INSTRUMENT\_TYPE | STRING |          | [DRC Sec CTP Instrument Type](../cube/drc-sec-ctp-instrument-type) | Tranche or non-tranched, depending on the Attachment and Detachment fields.                                                                                                                                                                                                                                                                                                                                                                                         |
| RISK\_WEIGHT     | DOUBLE |          |                                                                    | Optional risk-weight, to override value.                                                                                                                                                                                                                                                                                                                                                                                                                            |

## Unique Key

| Columns      |
| ------------ |
| AS\_OF\_DATE |
| SECURITY     |
| RISK\_CLASS  |

## Incoming Joins

| Source Table                                           | Source Columns                                | Target Columns                              |
| ------------------------------------------------------ | --------------------------------------------- | ------------------------------------------- |
| [RISK\_FACTOR\_DESCRIPTION](./risk_factor_description) | AS\_OF\_DATE<br />UNDERLYING<br />RISK\_CLASS | AS\_OF\_DATE<br />SECURITY<br />RISK\_CLASS |