# View: test_rlr

**View Name:** test_rlr
**Table Source:** `Derived Table (Custom SQL)`
**File Path:** `views/test_rlr.view.lkml`

## Overview

- **File Size:** 2970 bytes
- **Lines of Code:** 68
- **Dimensions:** 7
- **Measures:** 0
- **Dimension Groups:** 1
- **Filters:** 0

## Comments & Notes

- Label name containing Dimensions and measure

## Dimensions

| Name | Type |
|------|------|
| `contributor_id` | string |
| `society_name` | string |
| `contribution_id` | string |
| `recording_id` | string |
| `society_ip` | string |
| `status` | string |
| `notes` | string |

## Dimension Groups

| Name | Type |
|------|------|
| `created_date` | time |

## SQL Comments

- SENA & AGATA --AND RECORD_NR_REG_HISTORY.CREATED_DATE >='01/01/2022' --AND RECORDING_CONTRIBUTORS.PARTY_ID IN ('IP589272', 'IP152334', 'IP323388', 'IP428131', 'IP589241', 'IP481654', 'IP550702') --AND RECORDING_CONTRIBUTORS.ID IN ('RC157663') --AND RECORDING_CONTRIBUTORS.RECORDING_ID IN ('WR3263829')

## Derived Table

```sql
sql:
    SELECT
      RECORDING_CONTRIBUTORS.PARTY_ID CONTRIBUTOR_ID ,
      RECORDING_CONTRIBUTORS.ID CONTRIBUTION_ID ,
      RECORDING_CONTRIBUTORS.RECORDING_ID ,
      INTERESTED_PARTIES.ID SOCIETY_IP ,
      INTERESTED_PARTIES.NAME SOCIETY_NAME ,
      RECORD_NR_REG_STATUSES.PARENT_DESCRIPTION || ' - ' || RECORD_NR_REG_STATUSES.DESCRIPTION STATUS,
      RECORD_NR_REG_HISTORY.NOTES ,
      RECORD_NR_REG_HISTORY.CREATED_DATE created_date

    FROM "AWAL_SAX"."SAX".INTERESTED_PARTIES, "AWAL_SAX"."SAX".AGREEMENTS, "AWAL_SAX"."SAX".RECORD_NR_REGISTRATIONS
    INNER JOIN "AWAL_SAX"."SAX".RECORD_NR_REG_HISTORY ON "AWAL_SAX"."SAX".RECORD_NR_REGISTRATIONS.LAST_HISTORY_ID = "AWAL_SAX"."SAX".RECORD_NR_REG_HISTORY.ID
    INNER JOIN "AWAL_SAX"."SAX".RECORD_NR_REG_STATUSES ON "AWAL_SAX"."SAX".RECORD_NR_REG_HISTORY.REGISTRATION_STATUS_ID = "AWAL_SAX"."SAX".RECORD_NR_REG_STATUSES.ID
    INNER JOIN "AWAL_SAX"."SAX".RECORDING_CONTRIBUTORS ON "AWAL_SAX"."SAX".RECORD_NR_REGISTRATIONS.RECORDING_CONTRIBUTOR_ID = "AWAL_SAX"."SAX".RECORDING_CONTRIBUTORS.ID

    WHERE RECORD_NR_REGISTRATIONS.AGREEMENT_ID = AGREEMENTS.ID
    AND AGREEMENTS.ACQUIRER_ID = INTERESTED_PARTIES.ID
    AND RECORD_NR_REGISTRATIONS.AGREEMENT_ID IN ('AGR227176', 'AGR232759', 'AGR227174', 'AGR227175', 'AGR227177', 'AGR437017', 'AGR225729', 'AGR443083', 'AGR484919', 'AGR227196', 'AGR352545', 'AGR443179', 'AGR227178', 'AGR443117', 'AGR312278', 'AGR227179', 'AGR227181', 'AGR227182', 'AGR227165', 'AGR227184', 'AGR308337', 'AGR330960', 'AGR227185', 'AGR283698', 'AGR264439', 'AGR349119', 'AGR227187', 'AGR307337', 'AGR223557', 'AGR346321', 'AGR226739', 'AGR254098', 'AGR225691', 'AGR225698', 'AGR443181', 'AGR225950', 'AGR227186', 'AGR264226', 'AGR224959', 'AGR250298', 'AGR543142', 'AGR443186')
    -- SENA & AGATA --AND RECORD_NR_REG_HISTORY.CREATED_DATE >='01/01/2022' --AND RECORDING_CONTRIBUTORS.PARTY_ID IN ('IP589272', 'IP152334', 'IP323388', 'IP428131', 'IP589241', 'IP481654', 'IP550702') --AND RECORDING_CONTRIBUTORS.ID IN ('RC157663') --AND RECORDING_CONTRIBUTORS.RECORDING_ID IN ('WR3263829')
```