label: "ABACUS"
connection: "abacus-looker"

include: "/views/orch_app_prod_royalty_accounting_account_payee_kyc_notification.view.lkml"
include: "/views/royalty_accounting_prod_vw_dim_abacus_contract.view.lkml"
include: "/views/royalty_accounting_prod_vw_dim_abacus_account.view.lkml"
include: "/views/orch_app_ar_royalty_accounting_run_controller.view.lkml"
include: "/views/orch_app_qa_royalty_accounting_account_payee_kyc_notification.view.lkml"
include: "/views/dt_abacus_contract_lifecycle_prod.view.lkml"
include: "/views/dt_abacus_contract_lifecycle_qa.view.lkml"
include: "/views/royalty_accounting_qa_vw_dim_abacus_contract.view.lkml"
include: "/views/royalty_accounting_qa_vw_dim_abacus_account.view.lkml"

fiscal_month_offset: -9

explore: orch_app_prod_royalty_accounting_account_payee_kyc_notification {
  label: "TAP Active KYC Cases"
  view_label: "KYC Cases"
  case_sensitive: no
  hidden: yes

  join: royalty_accounting_prod_vw_dim_abacus_account {
    view_label: "ABACUS Account"
    relationship: many_to_one
    sql_on: ${orch_app_prod_royalty_accounting_account_payee_kyc_notification.account_payee_id}= ${royalty_accounting_prod_vw_dim_abacus_account.account_payee_id};;
  }

}

explore: orch_app_qa_royalty_accounting_account_payee_kyc_notification {
  label: "TAP Active KYC Cases QA"
  view_label: "KYC Cases"
  case_sensitive: no
  hidden: yes

  join: royalty_accounting_qa_vw_dim_abacus_account {
    view_label: "ABACUS Account"
    relationship: many_to_one
    sql_on: ${orch_app_qa_royalty_accounting_account_payee_kyc_notification.account_id}= ${royalty_accounting_qa_vw_dim_abacus_account.account_id};;
  }

}