# View: tcat_data

**View Name:** tcat_data
**Table Source:** `Derived from: Art_Relations.Artist_Info, Art_Relations.Distribution_Format, Art_Relations.Mkt_Priority, Art_Relations.Orchadmin_Users, Art_Relations.Product_Physical + 3 more`
**File Path:** `tcat_data.view.lkml`

## Overview

- **File Size:** 4293 bytes
- **Lines of Code:** 164
- **Dimensions:** 12
- **Measures:** 1
- **Dimension Groups:** 0
- **Filters:** 7

## Dimensions

| Name | Type |
|------|------|
| `upc` | string |
| `sale_start_date` | date |
| `imprint` | string |
| `release_status` | string |
| `priority` | string |
| `product_physical_id` | number |
| `track_types` | string |
| `artist_name` | string |
| `release_name` | string |
| `master_label` | string |
| `label_owner` | string |
| `client_manager` | string |

## Measures

| Name | Type |
|------|------|
| `count` | count |

## Filters

- `release_status_filter`
- `sale_start_date_filter`
- `deletions_filter`
- `owner_filter`
- `context_type_filter`
- `distribution_format_id_filter`
- `product_type_id_filter`

## Derived Table

```sql
sql: SELECT r.display_upc                          AS upc,
         r.sale_start_date              AS sale_start_date,
         r.label                        AS 'Imprint',
         r.release_status               AS release_status,
         mp.priority                    AS priority,
         pp.id                          AS product_physical_id,
         Group_concat(distinct t.track_type)     AS track_types,
         ai.name                        AS 'artist_name',
         r.release_name                 AS 'release_name',
         v.company                      AS 'master_label',
         v.owner                        AS label_owner,
         Concat (ou.f_name, " ", l_name) AS client_manager
      FROM   art_relations.track t
             LEFT JOIN art_relations.releases r
                    ON t.upc = r.upc
             LEFT JOIN art_relations.mkt_priority mp
                    ON mp.release_id = r.release_id
             LEFT JOIN art_relations.product_physical pp
                    ON pp.release_id = r.release_id
             INNER JOIN art_relations.artist_info ai
                     ON ai.artist_id = r.artist_id
             INNER JOIN art_relations.vendor v
                     ON ai.vendor_id = v.vendor_id
             LEFT JOIN art_relations.orchadmin_users ou
                    ON ou.id = v.assigned_to
             LEFT JOIN art_relations.distribution_format df
                    ON r.distribution_format_id = df.distribution_format_id
      WHERE {% condition tcat_data.sale_start_date_filter %
```