# View: Delivery_App_Jobs_Status

**View Name:** Delivery_App_Jobs_Status
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Customer_Master_Master, Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Art_Relations_Prod_Art_Relations, Orchard_App_Reporting_V2.Prod_Performance_Nr_Delivery_Neighbouring_Rights_Delivery, Prod.Nr_Contributor + 2 more`
**File Path:** `views/Delivery_App_Jobs_Status.view.lkml`

## Overview

- **File Size:** 1125 bytes
- **Lines of Code:** 47
- **Dimensions:** 6
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `Order_ID` | string |
| `Customer_Name` | string |
| `Claim_ID` | string |
| `Status` | string |
| `Contributor_UUID` | string |
| `Name` | string |

## Derived Table

```sql
sql:
    select
cj.ORDER_ID,
cmm.customer_name,
cj.ID as claim_id,
cj.STATUS,
cj.CONTRIBUTOR_UUID,
cont.name
from ORCHARD_APP_REPORTING_V2.PROD_PERFORMANCE_NR_DELIVERY_NEIGHBOURING_RIGHTS_DELIVERY.claiming_job cj
left join ORCHARD_APP_REPORTING_V2.PROD_PERFORMANCE_NR_DELIVERY_NEIGHBOURING_RIGHTS_DELIVERY.claiming_order co on cj.order_id = co.id
LEFT JOIN ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.CUSTOMER_MASTER_MASTER AS cmm ON cmm.CUSTOMER_MASTER_MASTER_ID=co.customer_master_master_id
Left join FACTS.PROD.NR_CONTRIBUTOR as cont on  cj.CONTRIBUTOR_UUID = cont.id
;;
```