# View: statements

**View Name:** statements
**Table Source:** `Derived from: Awal_Sax, Awal_Sax.Sax, Sax.Interested_Parties, Sax.Ip_Statements`
**File Path:** `DOSC/Client_Admin/statements/views/statements.view.lkml`

## Overview

- **File Size:** 2400 bytes
- **Lines of Code:** 108
- **Dimensions:** 8
- **Measures:** 0
- **Dimension Groups:** 3
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `id` | string |
| `statement_description` | string |
| `client_id` | string |
| `client_name` | string |
| `recipient_id` | string |
| `recipient_name` | string |
| `rights` | string |
| `sub_client_pdf_live` | string |

## Dimension Groups

| Name | Type |
|------|------|
| `send_date` | time |
| `start_date` | time |
| `end_date` | time |

## Derived Table

```sql
sql:
      select
        ip_statements.id
        ,ip_statements.statement_send_date
        ,statements.description as statement_description
        ,ip_statements.statement_period_start_date
        ,ip_statements.statement_period_end_date
        ,ip_statements.client_id
        ,clients.name as client_name
        ,ip_statements.recipient_id
        ,recipients.name as recipient_name
        ,ip_statements.rights
        ,ip_statements.sub_client_pdf_live
      from
        awal_sax.sax.ip_statements
        inner join awal_sax.sax.statements on  statements.id = ip_statements.statement_id
        inner join awal_sax.sax.interested_parties clients on clients.id = ip_statements.client_id
        left join awal_sax.sax.interested_parties recipients on recipients.id = ip_statements.client_id
      order by ip_statements.statement_period_end_date desc;;
```