# View: all_schedules

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

## Overview

- **File Size:** 2572 bytes
- **Lines of Code:** 96
- **Dimensions:** 12
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `AGR_ID` | string |
| `ASSIGNOR_ID` | string |
| `ASSIGNOR_NAME` | string |
| `AGR_DESCRIPTION` | string |
| `CONTR_ID` | string |
| `CONTR_NAME` | string |
| `RECORDING_ID` | string |
| `MAIN_ARTIST` | string |
| `RECORDING_TITLE` | string |
| `RECORDING_VERSIONS` | string |
| `SCHEDULE_ID` | string |
| `SCHEDULE_DESCRIPTION` | string |

## Derived Table

```sql
sql:
SELECT AGREEMENTS.ID AGR_ID,
       CLIENT.ID ASSIGNOR_ID,
       CLIENT.NAME ASSIGNOR_NAME,
       AGREEMENTS.DESCRIPTION_OF_RIGHTS AGR_DESCRIPTION,
       CONTRIBUTOR.ID CONTR_ID,
       CONTRIBUTOR.NAME CONTR_NAME,
       RECORDINGS.ID RECORDING_ID,
       RECORDING_ARTISTS.NAME MAIN_ARTIST,
       RECORDINGS.TITLE RECORDING_TITLE,
       CONCAT(RECORDINGS.SUB_TITLE,' - ',RECORDINGS.SUB_TITLE_2,' - ',RECORDINGS.SUB_TITLE_3) RECORDING_VERSIONS,
       SCH_REC_CONTRIBUTORS.NR_SCHEDULE_ID SCHEDULE_ID,
       NR_SCHEDULES.DESCRIPTION SCHEDULE_DESCRIPTION
FROM   AWAL_SAX.SAX.AGREEMENTS,
       AWAL_SAX.SAX.INTERESTED_PARTIES CLIENT,
       AWAL_SAX.SAX.INTERESTED_PARTIES ACQUIRER,
       AWAL_SAX.SAX.INTERESTED_PARTIES CONTRIBUTOR,
       AWAL_SAX.SAX.SCH_REC_CONTRIBUTORS,
       AWAL_SAX.SAX.RECORDING_CONTRIBUTORS,
       AWAL_SAX.SAX.NR_SCHEDULES,
       AWAL_SAX.SAX.RECORDINGS,
       AWAL_SAX.SAX.RECORDING_ARTISTS
WHERE  SCH_REC_CONTRIBUTORS.RECORDING_CONTRIBUTOR_ID = RECORDING_CONTRIBUTORS.ID
AND    SCH_REC_CONTRIBUTORS.NR_SCHEDULE_ID = NR_SCHEDULES.ID
AND    RECORDING_CONTRIBUTORS.RECORDING_ID = RECORDINGS.ID
AND    NR_SCHEDULES.AGREEMENT_ID = AGREEMENTS.ID
AND    AGREEMENTS.ASSIGNOR_ID = CLIENT.ID
AND    AGREEMENTS.ACQUIRER_ID = ACQUIRER.ID
AND    RECORDINGS.RECORDING_ARTIST_ID = RECORDING_ARTISTS.ID
AND    RECORDING_CONTRIBUTORS.PARTY_ID = CONTRIBUTOR.ID
AND    AGREEMENTS.CLIENT_RIGHTS = 'Neighbouring Rights'
AND    AGREEMENTS.AGREEMENT_OUTGOING_TYPE_ID = 'AOT2';;
```