# View: orch_app_ar_product_video_approval

**View Name:** orch_app_ar_product_video_approval
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Orchadmin_Users, Art_Relations_Prod_Art_Relations.Product_Video_Approval, Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Art_Relations_Prod_Art_Relations`
**File Path:** `views/orch_app_ar_product_video_approval.view.lkml`

## Overview

- **File Size:** 1008 bytes
- **Lines of Code:** 49
- **Dimensions:** 3
- **Measures:** 0
- **Dimension Groups:** 1
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `release_id` | string |
| `rejection_reason` | string |
| `rejection_by_name` | string |

## Dimension Groups

| Name | Type |
|------|------|
| `rejection_at` | time |

## Derived Table

```sql
sql: select pva.*,
  concat(ou.f_name, ' ', ou.l_name) as rejection_by_name
  from  ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.PRODUCT_VIDEO_APPROVAL pva
  left join orchard_app_reporting_v2.art_relations_prod_art_relations.orchadmin_users ou
  on SPLIT_PART(pva.rejection_by , 'oa:', 2) = ou.id
  ;;
```