# View: societies_registrations

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

## Overview

- **File Size:** 3943 bytes
- **Lines of Code:** 117
- **Dimensions:** 14
- **Measures:** 0
- **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 |

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