# View: label_territory_carveout

**View Name:** label_territory_carveout
**Table Source:** `Derived from: Art_Relations, Art_Relations.Country, Art_Relations.Orchadmin_Users, Art_Relations.Soundscan_Codes, Art_Relations.Vendor + 3 more`
**File Path:** `label_territory_carveout.view.lkml`

## Overview

- **File Size:** 6942 bytes
- **Lines of Code:** 253
- **Dimensions:** 28
- **Measures:** 1
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- set: detail {
- label_identifier,
- cont_start,

## Dimensions

| Name | Type |
|------|------|
| `label_id` | number |
| `id` | number |
| `label_name` | string |
| `soundscan_code_us` | string |
| `soundscan_code_ca` | string |
| `label_country` | string |
| `label_status` | string |
| `label_priority` | number |
| `label_owner` | string |
| `closer` | string |
| `client_manager` | string |
| `is_owned` | string |
| `label_identifier` | string |
| `label_cont_start` | date |
| `label_cont_end` | date |
| `label_digital_split` | number |
| `label_physical_split` | number |
| `ringtone_publishing_type` | string |
| `physical_track_publishing_type` | string |
| `notice_required_in_days` | number |
| `rollover_length_in_months` | number |
| `sync_admin_commission` | number |
| `royalty_collection_commission` | number |
| `royalty_collection_territory` | string |
| `sx_royalty_collection_commission` | number |
| `soungexchange_split` | number |
| `performance_rights` | number |
| `label_territory_carveouts` | string |

## Measures

| Name | Type |
|------|------|
| `count_distinct_labels` | count_distinct |

## Derived Table

```sql
sql: select v.vendor_id, IF(v.company IS NULL OR v.company = '', v.name, v.company) AS vendor_name, c2.name, v.status, v.priority, v.owner, v.label_identifier, v.is_owned, vcc.id, vcc.cont_start,
      vcc.cont_end, vcc.digital_split, vcc.physical_split, vcc.notice_required_in_days, vcc.rollover_length_in_months, vcc.ringtone_publishing_type,
      vcc.physical_track_publishing_type,vcc. sync_admin_commission, vcc.royalty_collection_commission, vcc.sx_royalty_collection_commission,
      dmc.dms_master_split as soungexchange_split, dmc2.dms_master_split as performance_rights,
      max(case when sc.country_id=1 and sc.subaccount_id is null then sc.soundscan_code end) soundscan_code_us,
      max(case when sc.country_id=2 and sc.subaccount_id is null then sc.soundscan_code end)  soundscan_code_ca,
      concat(oau2.f_name, " ", oau2.l_name) as closer, concat(oau.f_name, " ", oau.l_name) as client_manager,
      group_concat(distinct c.name) as territory_carveouts, group_concat(distinct c3.name) as royalty_collection_territory
      from art_relations.vw_active_vendor_contract vw
      left join art_relations.vendor v on vw.vendor_id=v.vendor_id
      left join art_relations.soundscan_codes sc on v.vendor_id = sc.vendor_id
      left join art_relations.orchadmin_users oau ON v.assigned_to = oau.id
      left join art_relations.vendor_contract vcc on vw.vendor_contract_id=vcc.id
      left join art_relations.orchadmin_users oau2 ON   oau2.id = vcc.orchrep_name
      left join art_relations.vendor_dms_master_contract dmc on dmc.vendor_contract_id=vw.vendor_contract_id and dmc.dms_master_id = 549
      left join art_relations.vendor_dms_master_contract dmc2 on dmc2.vendor_contract_id=vw.vendor_contract_id and dmc2.dms_master_id = 682
      left join art_relations.country c on find_in_set(c.id, vcc.territory_carve_out)
      left join art_relations.country c2 on v.country=c2.id
      left join art_relations.country c3 on find_in_set(c3.id, vcc.royalty_collection_territory)
      group by 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21
       ;;
```