# View: awal_workstation_gcp_priorities

**View Name:** awal_workstation_gcp_priorities
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Artist_Info, Art_Relations_Prod_Art_Relations.Genre, Art_Relations_Prod_Art_Relations.Project, Art_Relations_Prod_Art_Relations.Release_Subgenre, Art_Relations_Prod_Art_Relations.Releases + 3 more`
**File Path:** `awal_workstation_gcp_priorities.view.lkml`

## Overview

- **File Size:** 6871 bytes
- **Lines of Code:** 226
- **Dimensions:** 16
- **Measures:** 0
- **Dimension Groups:** 4
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `Account_Name` | string |
| `Account_ID` | string |
| `Account_Service_Tier` | string |
| `SubAccount_Name` | string |
| `SubAccount_ID` | string |
| `review_queue_id` | string |
| `Product_Name` | string |
| `Product_Primary_Artist` | string |
| `Product_ID` | string |
| `upc` | string |
| `genre` | string |
| `subgenre` | string |
| `Release_Manager` | string |
| `Client_Manager` | string |
| `Actual_Reviewer` | string |
| `internal_note` | string |

## Dimension Groups

| Name | Type |
|------|------|
| `Sales_Start_Date` | time |
| `Original_Release_Date` | time |
| `submitted_time` | time |
| `approval_time` | time |

## Derived Table

```sql
sql:
    select
    v.name as Account_Name,
    v.vendor_id as Account_ID,
    st.name as Account_Service_Tier,
    s.subaccount_name as SubAccount_Name,
    s.subaccount_id as SubAccount_ID,
    completed_reviews.review_queue_id as review_queue_id,
    iff(releases.release_id is not NULL, releases.release_name, 'DELETED PRODUCT') as Product_Name,
    artist.name as Product_Primary_Artist,
    releases.release_id as Product_ID,
    releases.upc as upc,
    releases.sale_start_date as Sales_Start_Date,
    releases.release_date as Original_Release_Date,
    g.genre as genre,
    sg.name as subgenre,
    concat(o.f_name, ' ', o.l_name) as Release_Manager,
    concat(vo.f_name, ' ', vo.l_name) as Client_Manager,
    identity.name as Actual_Reviewer,
    completed_reviews.submitted_time as submitted_time,
    completed_reviews.completion_time  as Approval_Time,
    COALESCE(dmp.internal_note, '') AS internal_note


FROM (
    select
        rq.id as review_queue_id,
        rq.product_id,
        rq.created_datetime as submitted_time,
        '' as rejection_note,
        'approved' as resolution,
        a.created_datetime as completion_time,
        a.user_id as user_uuid
    FROM orchard_app_reporting_v2.prod_content_review_content_review.review_queue as rq
    LEFT JOIN orchard_app_reporting_v2.prod_content_review_content_review.approval as a ON rq.id = a.review_queue_id AND a._fivetran_deleted = false
    where rq.status = 'complete'
) as completed_reviews
LEFT JOIN facts.prod.identity as identity ON completed_reviews.user_uuid = identity.id
LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.releases releases ON completed_reviews.product_id = releases.release_id
LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.artist_info artist ON releases.artist_id = artist.artist_id
LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.genre g ON releases.genre_id = g.genre_id
LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.release_subgenre rsg ON releases.release_id = rsg.release_id
LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.subgenre sg ON rsg.subgenre_id = sg.orchard_id
LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.project p ON p.project_id = releases.project_id
LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.vendor v ON v.vendor_id = p.vendor_id
LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.subaccount s ON s.subaccount_id = releases.subaccount_id
LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.orchadmin_users o ON v.assigned_to = o.id
LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.orchadmin_users vo ON v.quarterback_label_manager = vo.id
LEFT JOIN orchard_app_reporting_v2.prod_sales_goals_sales_goals.digital_marketing_projections dmp ON releases.release_id = dmp.product_id
left outer join FACTS.prod.COMPANY_BRAND_HAS_LABEL_VENDOR cbv on cbv.vendor_id = v.vendor_id
left outer join FACTS.prod.COMPANY_BRAND cb on cbv.company_brand_uuid = cb.uuid
left outer join FACTS.prod.VENDOR_IN_SERVICE_TIER_SERVICE_TIER vst on vst.vendor_id = v.vendor_id
left outer join FACTS.prod.SERVICE_TIER st on st.uuid = vst.service_tier_uuid

WHERE Account_ID NOT IN (16160,35976, 16162)
AND completed_reviews.resolution = 'approved'
ORDER BY completed_reviews.completion_time DESC
    ;;
```