# View: dt_film_tv_manual_adjustment

**View Name:** dt_film_tv_manual_adjustment
**Table Source:** `Derived from: Art_Relations.Currencies, Art_Relations.Manual_Adjustment, Art_Relations.Manual_Adjustment_Category, Art_Relations.Orchadmin_Users, Art_Relations.Period + 3 more`
**File Path:** `dt_film_tv_manual_adjustment.view.lkml`

## Overview

- **File Size:** 5740 bytes
- **Lines of Code:** 221
- **Dimensions:** 16
- **Measures:** 2
- **Dimension Groups:** 1
- **Filters:** 0

## Comments & Notes

- value_format_name: decimal_2
- value_format_name: decimal_2

## Dimensions

| Name | Type |
|------|------|
| `manual_adjustment_id` | number |
| `release_manual_adjustment_id` | number |
| `upc` | string |
| `release_name` | string |
| `parent_id` | number |
| `company` | string |
| `label_identifier` | string |
| `client_manager` | string |
| `iso_4217_code` | string |
| `apply_to_year` | number |
| `apply_to_month` | number |
| `release_manual_adj_category` | string |
| `manual_adj_category` | string |
| `comment` | string |
| `description` | string |
| `created_by` | string |

## Measures

| Name | Type |
|------|------|
| `manual_adjustment` | number |
| `sum_ma_amount` | sum |

## Dimension Groups

| Name | Type |
|------|------|
| `date_added` | time |

## Derived Table

```sql
sql: select
      ma.id as manual_adjustment_id,
      rma.id as release_manual_adjustment_id,
      r.upc,
      r.release_name,
      ma.parent_id,
      v.company,
      v.label_identifier,
      concat(oau2.f_name,' ',oau2.l_name) as client_manager,
      ma.date_added,
      c.ISO_4217_code,
      p.year AS apply_to_year,
      p.month AS apply_to_month,
      mac.category as release_manual_adj_category,
      mac2.category as manual_adj_category,
      case when SUM(rma.amount) is null then sum(ma.amount) else sum(rma.amount) end as manual_adjustment,
      sum(ma.amount),
      ma.comment,
      rma.description,
      CONCAT(oau.f_name," ",oau.l_name) AS created_by
      from art_relations.manual_adjustment ma
      LEFT JOIN art_relations.release_manual_adjustment rma ON rma.vendor_manual_adjustment_id=ma.id
      LEFT JOIN art_relations.manual_adjustment_category mac ON mac.category_id=rma.category_id
      LEFT JOIN art_relations.manual_adjustment_category mac2 ON mac2.category_id=ma.category_id
      LEFT JOIN art_relations.period p ON p.period_id=ma.apply_to_period_id
      LEFT JOIN art_relations.orchadmin_users oau ON oau.id=ma.created_by
      LEFT JOIN art_relations.vendor v ON v.vendor_id=ma.parent_id
      LEFT JOIN art_relations.orchadmin_users oau2 ON oau2.id=v.assigned_to
      LEFT JOIN art_relations.releases r ON r.release_id=rma.release_id
      LEFT JOIN art_relations.currencies c ON c.id=rma.currencies_id
      where

      (ma.parent_id in
                      (
                      select v.vendor_id
                      from art_relations.vendor v
                      where v.vendor_id not in
                              (
                              select ai.vendor_id
                              from art_relations.releases r2
                              inner join art_relations.artist_info ai on r2.artist_id=ai.artist_id
                              where r2.product_type_id in (2,3,4)
                              )
                      )
                      and ma.category_id in
                      (
                              30,
                              31,
                              58,
                              59,
                              60,
                              61,
                              62,
                              63,
                              64,
                              67,
                              68,
                              69
                      )
      )
      or
      (
              r.product_type_id in (2,3,4)
              and rma.category_id in
                      (
                              30,
                              31,
                              58,
                              59,
                              60,
                              61,
                              62,
                              63,
                              64,
                              67,
                              68,
                              69
                      )
      )
      GROUP BY
      ma.id,
      rma.id,
      r.upc,
      r.release_name,
      ma.parent_id,
      v.company,
      v.label_identifier,
      client_manager,
      ma.date_added,
      c.ISO_4217_code,
      p.year,
      p.month,
      mac.category,
      mac2.category,
      ma.comment,
      rma.description,
      ma.created_by
       ;;
```