# View: KNR_Performer_Run_Prod_PreApproval

**View Name:** KNR_Performer_Run_Prod_PreApproval
**Table Source:** `Derived from: Prod.Accounting_Run_Results_Nr_Staging, Prod.Contract_Transaction_Nr_Staging, Prod.Dim_Transactiontype, Prod.Stmt_Db_Sales_Nr, Prod_Royalty_Accounting_Royalty_Accounting.Account + 3 more`
**File Path:** `views/KNR_Performer_Run_Prod_PreApproval.view.lkml`

## Overview

- **File Size:** 8445 bytes
- **Lines of Code:** 352
- **Dimensions:** 50
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `Run_Controller_ID` | string |
| `Accounting_Run_ID` | string |
| `Accounting_Run_Name` | string |
| `Account_ID` | string |
| `Account_Name` | string |
| `Contract_ID` | string |
| `Contract_Name` | string |
| `Contract_Term_ID` | string |
| `Contract_Term_Name` | string |
| `Contributor_ID` | string |
| `Contributor_Name` | string |
| `Source_Contributor_Name` | string |
| `Schedule_ID` | string |
| `Schedule_Name` | string |
| `Sound_Recording_ID` | string |
| `Main_Artist` | string |
| `Recording_Title` | string |
| `Recording_Version` | string |
| `ISRC` | string |
| `Contribution_ID` | string |
| `Contributor_Only` | string |
| `Society_ID` | string |
| `Society_Name` | string |
| `Country_ID` | string |
| `Country_Name` | string |
| `Trans_Type_Abbrev` | string |
| `Transaction_Type` | string |
| `Trans_Sub_Type_ID` | string |
| `Trans_Sub_Type` | string |
| `Usage_Start_Date` | date |
| `Usage_End_Date` | date |
| `TXN_ID` | string |
| `Quantity` | number |
| `Unit_Price_USD` | number |
| `Total_USD` | number |
| `Withholding_Tax_USD` | number |
| `Activity_Rate` | number |
| `Royalty_Rate` | number |
| `Sales_Currency` | string |
| `Unit_Price_Sales_Currency` | number |
| `Gross_Revenue_Sales_Currency` | number |
| `Withholding_Tax_Sales_Currency` | number |
| `Gross_Revenue_After_Withholding_Tax_Sales_Currency` | number |
| `Net_Share_Sales_Currency` | number |
| `Payee_Currency` | string |
| `UNIT_PRICE_PAYEE_CURRENCY` | number |
| `Gross_Revenue_Payee_Currency` | number |
| `Withholding_Tax_Payee_Currency` | number |
| `Gross_Revenue_After_Withholding_Tax_Payee_Currency` | number |
| `Net_Share_Payee_Currency` | number |

## SQL Comments

- slaughterhouse
- sale currency
- payee currency
- contract
- account

## Derived Table

```sql
sql:

 select
    rcc.run_controller_id,
    arr.accounting_run_id,
    arr.accounting_run_name,
    cts.account_id,
    a.account_name,
    cts.contract_id,
    c.contract_name,
    ct.contract_term_name,
    ct.contract_term_id,
    s.schedule_id,
    s.schedule_name,
    nc.name,
    txn.contributor_id,
    txn.contributor_name,
    txn.contribution_id,
    txn.contributor_only,
    txn.isrc,
    txn.country_id,
    cn.iso3166a3 country_name,
    txn.sound_recording_id,
    sr.recording_title,
    sr.version,
    sr.main_artist,
    txn.store_id,
    cmm.customer_name store,
    txn.transaction_type,
    t.transactiontypedesc,
    txn.TRANSACTION_SUBTYPE_ID,
    st.TRANSACTION_SUBTYPE_DESCRIPTION,
    txn.start_date,
    txn.end_date,
    --slaughterhouse
    arr.txn_id,
    txn.quantity,
    txn.UNIT_PRICE_USD,
    txn.TOTAL_USD,
    txn.WITHHOLDING_TAX_USD,
    txn.activity_rate,
    arr.royalty_rate,
    --sale currency
    txn.sale_currency_code,
    arr.UNIT_PRICE_SALE_CURRENCY,
    arr.GROSS_REVENUE_SALE_CURRENCY,
    arr.WITHHOLDING_TAX_SALE_CURRENCY,
    arr.GROSS_REVENUE_AFTER_WITHHOLDING_TAX_SALE_CURRENCY,
    arr.NET_SHARE_SALE_CURRENCY,
    --payee currency
    apt.currency_code,
    arr.unit_price_payee_currency,
    arr.GROSS_REVENUE_PAYEE_CURRENCY,
    arr.withholding_tax_payee_currency,
    arr.gross_revenue_after_withholding_tax_payee_currency,
    arr.NET_SHARE_PAYEE_CURRENCY

-- sales
from royalty_accounting.prod.accounting_run_results_nr_staging as arr
join royalty_accounting.prod.stmt_db_sales_nr as txn on arr.txn_id = txn.stmt_db_sales_nr_txn_id
-- contract
join royalty_accounting.prod.contract_transaction_nr_staging as cts on arr.txn_id = cts.txn_id and cts.accounting_run_id=arr.accounting_run_id
join orchard_app_reporting_v2.prod_royalty_accounting_royalty_accounting.contract as c on cts.contract_id = c.contract_id
join orchard_app_reporting_v2.prod_royalty_accounting_royalty_accounting.run_controller_contract rcc
    on rcc.contract_id=c.contract_id
-- account
join orchard_app_reporting_v2.prod_royalty_accounting_royalty_accounting.account as a on cts.account_id = a.account_id
join orchard_app_reporting_v2.prod_royalty_accounting_royalty_accounting.account_payment_term as apt on a.account_id = apt.account_id
-- contract conditions
join facts.prod.dim_transactiontype as t on txn.transaction_type = t.transactiontypeabbr
left join ROYALTY_ACCOUNTING.PROD.DIM_TRANSACTION_SUBTYPE as st on txn.TRANSACTION_SUBTYPE_ID = st.TRANSACTION_SUBTYPE_ID
left join orchard_app_reporting_v2.art_relations_prod_art_relations.customer_master_master cmm on cmm.customer_master_master_id=txn.store_id
left join orchard_app_reporting_v2.art_relations_prod_art_relations.country cn on cn.id=txn.country_id
join orchard_app_reporting_v2.prod_royalty_accounting_royalty_accounting.contract_term ct on ct.contract_term_id=cts.contract_term_id
-- contrbiutor
left join facts.prod.performance_nr_contributor nc on nc.id=txn.contributor_id
---- sound recordings
left join facts.prod.performance_nr_sound_recording sr on sr.id=txn.sound_recording_id
-- schedule
JOIN orchard_app_reporting_v2.prod_royalty_accounting_royalty_accounting.schedule s ON s.schedule_id=cts.schedule_id
-- predicates
where true
order by account_id,contract_id
;;
```