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

# TRANCHE

The **TRANCHE** table contains the description of a DRC Sec non-CTP tranche.

| Column Name  | Type   | Not Null | Cube Field                                                         | Description                                                                      |
| ------------ | ------ | -------- | ------------------------------------------------------------------ | -------------------------------------------------------------------------------- |
| AS\_OF\_DATE | DATE   | Y        | See field in joined table                                          | Timestamp (at close of business) for the data.                                   |
| TRANCHE      | STRING | Y        | [DRC Sec non-CTP Tranche](../cube/drc-sec-non-ctp-tranche)         | ID of the tranche.                                                               |
| RISK\_CLASS  | STRING | Y        |                                                                    | Set to "DRC Sec non-CTP".                                                        |
| BUCKET       | STRING | Y        | [DRC Sec non-CTP Bucket](../cube/drc-sec-non-ctp-bucket)           | The DRC bucket.                                                                  |
| SENIORITY    | STRING | Y        | [DRC Sec non-CTP Seniority](../cube/drc-sec-non-ctp-seniority)     | Seniority of the tranche.                                                        |
| RATING       | STRING |          | [DRC Sec non-CTP Rating](../cube/drc-sec-non-ctp-rating)           | The credit rating of the tranche.                                                |
| TYPE         | STRING |          | [DRC Sec non-CTP Rating Type](../cube/drc-sec-non-ctp-rating-type) | The rating type used alongside the rating to determine the SEC-ERBA risk-weight. |
| REGION       | STRING |          | [DRC Sec non-CTP Region](../cube/drc-sec-non-ctp-region)           | The region used to determine the Bucket.                                         |
| ASSET\_CLASS | STRING |          | [DRC Sec non-CTP Asset Class](../cube/drc-sec-non-ctp-asset-class) | The asset class used to determine the Bucket.                                    |
| ATTACHMENT   | DOUBLE |          | [DRC Sec non-CTP Attachment](../cube/drc-sec-non-ctp-attachment)   | Attachment point (Decimal values are expected).                                  |
| DETACHMENT   | DOUBLE |          | [DRC Sec non-CTP Detachment](../cube/drc-sec-non-ctp-detachment)   | Detachment point (Decimal values are expected).                                  |
| RISK\_WEIGHT | DOUBLE |          | DRC Sec non-CTP JTD Weightings Override measure                    | Optional override for the DRC Sec non-CTP Tranche risk-weight.                   |

## Unique Key

| Columns      |
| ------------ |
| AS\_OF\_DATE |
| TRANCHE      |
| 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 />TRANCHE<br />RISK\_CLASS |