# View: dt_proper_carveouts

**View Name:** dt_proper_carveouts
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Customer_Master_Master, Art_Relations_Prod_Art_Relations.Release_Dms_Master_Restriction, Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Art_Relations_Prod_Art_Relations`
**File Path:** `dt_proper_carveouts.view.lkml`

## Overview

- **File Size:** 1108 bytes
- **Lines of Code:** 41
- **Dimensions:** 5
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `release_id` | number |
| `upc` | number |
| `carved_into_proper_user` | number |
| `carved_into_proper_date` | date |
| `customer_name` | yesno |

## Derived Table

```sql
sql: select r.release_id, r.upc, r.updated_by as carved_into_proper_user, to_date(r.last_updated) as carved_into_proper_date, customer_name
from orchard_app_reporting_v2.art_relations_prod_art_relations.release_dms_master_restriction r
inner join ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.CUSTOMER_MASTER_MASTER c on c.customer_master_master_id = r.customer_master_master_id
where r.customer_master_master_id = (696)
group by 1,2,3,4,5
order by 1,2,3,4,5;;
```