# View: active_contract_closer

**View Name:** active_contract_closer
**Table Source:** `Derived Table (Custom SQL)`
**File Path:** `active_contract_closer.view.lkml`

## Overview

- **File Size:** 1822 bytes
- **Lines of Code:** 66
- **Dimensions:** 4
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- dimension: lifetime_orders {
- description: "The total number of orders for each user"
- type: number

## Dimensions

| Name | Type |
|------|------|
| `id` | string |
| `vendor_id` | number |
| `active_contract_closer` | string |
| `orchrep_name` | number |

## Derived Table

```sql
sql:
        SELECT
          vc.vendor_id,
          vc.id,
          orchrep_name,
          (oau.f_name || ' ' || oau.l_name) as active_contract_closer
        FROM   "ROYALTY_ACCOUNTING_REPORTING"."PROD"."VW_DIM_ABACUS_AR_VENDOR_CONTRACT" vc
        LEFT JOIN   "ORCHARD_APP_REPORTING_V2"."ART_RELATIONS_PROD_ART_RELATIONS"."ORCHADMIN_USERS" oau
              ON vc.orchrep_name=cast(oau.id AS varchar ())
          INNER JOIN "INTELLIGENCE"."DBT_PROD"."ACTIVE_VENDOR_CONTRACTS" avc
          ON vc.id=avc.vendor_contract_id
          WHERE is_paythrough_contract=FALSE
          GROUP BY 1,2,3,4;;
```