Donor Org Grants

view: donor_org_grants {
  sql_table_name: public.donor_org_grants ;;

  dimension: id {
    type: int
    primary_key: yes
    sql: ${TABLE}.id ;;
  }

  dimension: amount_awarded {
    type: number
    sql: ${TABLE}.amount_awarded ;;
  }

  dimension: amount_requested {
    type: number
    sql: ${TABLE}.amount_requested ;;
  }

  dimension: batch_name {
    sql: ${TABLE}.batch_name ;;
  }

  dimension: completed {
    type: int
    sql: ${TABLE}.completed ;;
  }

  dimension: cost_per_project {
    type: int
    sql: ${TABLE}.cost_per_project ;;
  }

  dimension: country_id {
    type: int
    sql: ${TABLE}.country_id ;;
  }

  dimension: cw_direct_beneficiaries {
    type: int
    sql: ${TABLE}.cw_direct_beneficiaries ;;
  }

  dimension: d2p_batch_id {
    type: int
    sql: ${TABLE}.d2p_batch_id ;;
  }

  dimension: delayed {
    type: int
    sql: ${TABLE}.delayed ;;
  }

  dimension: deployment_code {
    sql: ${TABLE}.deployment_code ;;
  }

  dimension: direct_beneficiaries {
    type: int
    sql: ${TABLE}.direct_beneficiaries ;;
  }

  dimension: donors {
    type: int
    sql: ${TABLE}.donors ;;
  }

  dimension: financial_quarter_id {
    type: int
    sql: ${TABLE}.financial_quarter_id ;;
  }

  dimension: erp_id {
    type: int
    sql: ${TABLE}.erp_id ;;
  }

  dimension: erp_report_id {
    type: int
    sql: ${TABLE}.erp_report_id ;;
  }

  dimension: grant_type {
    sql: ${TABLE}.grant_type ;;
  }

  dimension: interval_name {
    sql: ${TABLE}.interval_name ;;
  }

  dimension: is_d2p {
    type: int
    sql: ${TABLE}.is_d2p ;;
  }

  dimension: is_ready_to_fund {
    type: int
    sql: ${TABLE}.is_ready_to_fund ;;
  }

  dimension: partner_id {
    type: int
    sql: ${TABLE}.partner_id ;;
  }

  dimension: partner_program_id {
    type: int
    sql: ${TABLE}.partner_program_id ;;
  }

  dimension: projects_per_proposal {
    type: int
    sql: ${TABLE}.projects_per_proposal ;;
  }

  dimension: published_num_projects {
    type: int
    sql: ${TABLE}.published_num_projects ;;
  }

  dimension: is_reported {
    type: yesno
    sql: ${reporting_date} IS NOT NULL ;;
  }

  dimension: is_overdue {
    type: yesno
    sql: NOT ${cost_database.is_active} AND NOT ${is_reported} ;;
  }

  dimension: reservation_priority {
    sql: ${TABLE}.reservation_priority ;;
  }

  dimension: state {
    sql: ${TABLE}.state ;;
  }

  dimension: title {
    sql: ${TABLE}.title ;;
  }

  dimension: water_programs_officer {
    sql: ${TABLE}.water_programs_officer ;;
  }

  dimension_group: end {
    type: time
    timeframes: [date, week, month]
    convert_tz: no
    sql: ${TABLE}.end_date ;;
  }

  dimension_group: reporting {
    type: time
    timeframes: [date, week, month]
    convert_tz: no
    sql: ${TABLE}.reporting_date ;;
  }

  measure: count {
    type: count
    drill_fields: [detail*]
  }
}

- view: donor_org_grants
  sql_table_name: public.donor_org_grants
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: amount_awarded
    type: number
    sql: ${TABLE}.amount_awarded
  - dimension: amount_requested
    type: number
    sql: ${TABLE}.amount_requested
  - dimension: batch_name
    sql: ${TABLE}.batch_name
  - dimension: completed
    type: int
    sql: ${TABLE}.completed
  - dimension: cost_per_project
    type: int
    sql: ${TABLE}.cost_per_project
  - dimension: country_id
    type: int
    sql: ${TABLE}.country_id
  - dimension: cw_direct_beneficiaries
    type: int
    sql: ${TABLE}.cw_direct_beneficiaries
  - dimension: d2p_batch_id
    type: int
    sql: ${TABLE}.d2p_batch_id
  - dimension: delayed
    type: int
    sql: ${TABLE}.delayed
  - dimension: deployment_code
    sql: ${TABLE}.deployment_code
  - dimension: direct_beneficiaries
    type: int
    sql: ${TABLE}.direct_beneficiaries
  - dimension: donors
    type: int
    sql: ${TABLE}.donors
  - dimension: financial_quarter_id
    type: int
    sql: ${TABLE}.financial_quarter_id
  - dimension: erp_id
    type: int
    sql: ${TABLE}.erp_id
  - dimension: erp_report_id
    type: int
    sql: ${TABLE}.erp_report_id
  - dimension: grant_type
    sql: ${TABLE}.grant_type
  - dimension: interval_name
    sql: ${TABLE}.interval_name
  - dimension: is_d2p
    type: int
    sql: ${TABLE}.is_d2p
  - dimension: is_ready_to_fund
    type: int
    sql: ${TABLE}.is_ready_to_fund
  - dimension: partner_id
    type: int
    sql: ${TABLE}.partner_id
  - dimension: partner_program_id
    type: int
    sql: ${TABLE}.partner_program_id
  - dimension: projects_per_proposal
    type: int
    sql: ${TABLE}.projects_per_proposal
  - dimension: published_num_projects
    type: int
    sql: ${TABLE}.published_num_projects
  - dimension: is_reported
    type: yesno
    sql: ${reporting_date} IS NOT NULL
  - dimension: is_overdue
    type: yesno
    sql: NOT ${cost_database.is_active} AND NOT ${is_reported}
  - dimension: reservation_priority
    sql: ${TABLE}.reservation_priority
  - dimension: state
    sql: ${TABLE}.state
  - dimension: title
    sql: ${TABLE}.title
  - dimension: water_programs_officer
    sql: ${TABLE}.water_programs_officer
  - dimension_group: end
    type: time
    timeframes:
    - date
    - week
    - month
    convert_tz: false
    sql: ${TABLE}.end_date
  - dimension_group: reporting
    type: time
    timeframes:
    - date
    - week
    - month
    convert_tz: false
    sql: ${TABLE}.reporting_date
  - measure: count
    type: count
    drill_fields:
    - detail*