# View: societies_registrations_graph

**View Name:** societies_registrations_graph
**Table Source:** `Derived from: Awal_Sax, Awal_Sax.Sax`
**File Path:** `views/societies_registrations_graph.view.lkml`

## Overview

- **File Size:** 4503 bytes
- **Lines of Code:** 142
- **Dimensions:** 17
- **Measures:** 2
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `Society` | string |
| `Society_Performer_ID` | string |
| `Agreement_ID` | string |
| `AGR_Reg_Created_Date` | date |
| `Disc_Reg_Created_Date` | date |
| `AGR_Reg_Status` | string |
| `AGR_Reg_Notes` | string |
| `Disc_Reg_Status` | string |
| `Disc_Reg_Notes` | string |
| `Client_Name` | string |
| `Client_ID` | string |
| `AGR_Signed_Date` | date |
| `AGR_Created_Date` | date |
| `Kobalt_Entity` | string |
| `Year` | date_year |
| `Month` | date_month |
| `Month_Num` | date_month_num |

## Measures

| Name | Type |
|------|------|
| `Count` | count |
| `Statuses` | count_distinct |

## Derived Table

```sql
sql:
    SELECT
       TARGET.NAME Society,
       AGR_NR_REGISTRATIONS.AGREEMENT_NUMBER Society_Performer_ID,
       AGREEMENTS.ID Agreement_ID,
       TO_CHAR(AGR_NR_REG_HISTORY.CREATED_DATE, 'YYYY-MM-DD') AGR_Reg_Created_Date,
        TO_CHAR(AGR_NR_REG_DISCOG_HISTORY.CREATED_DATE, 'YYYY-MM-DD') Disc_Reg_Created_Date,
       CONCAT(AGR_NR_REG_STATUSES.PARENT_DESCRIPTION,' - ', AGR_NR_REG_STATUSES.DEFINITION) AGR_Reg_Status,
       AGR_NR_REG_HISTORY.NOTES AGR_Reg_Notes,
       CONCAT(AGR_NR_REG_DISCOG_STATUSES.PARENT_DESCRIPTION,' - ', AGR_NR_REG_DISCOG_STATUSES.DEFINITION) Disc_Reg_Status,
       AGR_NR_REG_DISCOG_HISTORY.NOTES Disc_Reg_Notes,
       CLIENTS.NAME Client_Name,
       CLIENTS.ID Client_ID,
       AGREEMENTS.AGREEMENT_SIGNED_DATE AGR_Signed_Date,
       AGREEMENTS.CREATED_DATE AGR_Created_Date,
       ENTITY.NAME Kobalt_Entity

      FROM
      awal_sax.sax.AGREEMENTS,
      awal_sax.sax.INTERESTED_PARTIES CLIENTS,
      awal_sax.sax.INTERESTED_PARTIES ENTITY,
      awal_sax.sax.INTERESTED_PARTIES TARGET,
      awal_sax.sax.AGR_NR_REGISTRATIONS,
      awal_sax.sax.AGR_NR_REG_STATUSES,
      awal_sax.sax.AGR_NR_REG_HISTORY,
      awal_sax.sax.AGR_NR_REG_DISCOG_STATUSES,
      awal_sax.sax.AGR_NR_REG_DISCOG_HISTORY

      WHERE  awal_sax.sax.AGR_NR_REGISTRATIONS.AGREEMENT_ID = AGREEMENTS.ID
      AND    awal_sax.sax.AGREEMENTS.ASSIGNOR_ID = CLIENTS.ID
      AND    awal_sax.sax.AGREEMENTS.ACQUIRER_ID = ENTITY.ID
      AND    awal_sax.sax.AGREEMENTS.CLIENT_RIGHTS = 'Neighbouring Rights'
      AND    awal_sax.sax.AGR_NR_REGISTRATIONS.PARTY_ID IN('IP256648','IP585278','IP132274','IP240374','IP253820','IP256640','IP584667','IP254413','IP584672','IP584673','IP617668','IP256642','IP585279','IP460988','IP584680','IP256643',
      'IP584676','IP377557','IP253818','IP253845','IP254482','IP253819','IP256644','IP276373','IP420793','IP256645','IP490081','IP327242','IP301695','IP458529','IP256647','IP358049','IP86793','IP453863','IP253821','IP285814','IP253823',
      'IP408940','IP79396','IP466716','IP584681','IP60806','IP584687','IP256646','IP301349','IP253255','IP280616','IP487826','IP740331','IP934885','IP639870','IP948931','IP668839','IP584695')
      AND    awal_sax.sax.AGR_NR_REGISTRATIONS.PARTY_ID = TARGET.ID
      AND    awal_sax.sax.AGREEMENTS.AGREEMENT_OUTGOING_TYPE_ID = 'AOT2'
      AND    awal_sax.sax.AGR_NR_REG_HISTORY.REGISTRATION_STATUS_ID = AGR_NR_REG_STATUSES.ID
      AND    awal_sax.sax.AGR_NR_REG_HISTORY.AGREEMENT_REGISTRATION_ID = AGR_NR_REGISTRATIONS.ID
      AND    awal_sax.sax.AGR_NR_REG_DISCOG_HISTORY.REGISTRATION_STATUS_ID = AGR_NR_REG_DISCOG_STATUSES.ID
      AND    awal_sax.sax.AGR_NR_REG_DISCOG_HISTORY.AGREEMENT_REGISTRATION_ID = AGR_NR_REGISTRATIONS.ID
      ORDER BY
      Kobalt_Entity,
      Client_ID;;
```