{
  "resourceType": "https://sql-on-fhir.org/ig/StructureDefinition/ViewDefinition",
  "url": "https://icr.healthcampaigns.org/ViewDefinition/IcrCoverageStrata",
  "title": "ICR coverage strata",
  "description": "One row per stratum of each result group of a coverage report: the\ndisaggregations (sex, age band, delivery strategy, disposition, geography)\ndeclared by the ICR coverage Measures. Counts are in the Measure's unit\n(people, households for `icr-household-coverage`, implementation units). Join\nto `IcrCoverage` on `report_id` and, null-safely, `group_code`\n(`c.group_code IS NOT DISTINCT FROM s.group_code`): it is empty for a\nsingle-group Measure, so plain `=` would drop those rows.",
  "name": "IcrCoverageStrata",
  "status": "draft",
  "fhirVersion": [
    "4.0.1"
  ],
  "resource": "MeasureReport",
  "where": [
    {
      "path": "extension('https://icr.healthcampaigns.org/StructureDefinition/coverage-source').exists()"
    }
  ],
  "select": [
    {
      "column": [
        {
          "name": "report_id",
          "path": "getResourceKey()",
          "type": "id"
        },
        {
          "name": "campaign_id",
          "path": "extension('https://icr.healthcampaigns.org/StructureDefinition/campaign').value.ofType(Reference).getReferenceKey(CarePlan)",
          "type": "string"
        }
      ]
    },
    {
      "forEach": "group",
      "column": [
        {
          "name": "group_code",
          "path": "code.coding.where(system = 'https://icr.healthcampaigns.org/CodeSystem/icr-coverage-group-cs').first().code",
          "type": "code",
          "description": "The result group the stratum belongs to (ICRCoverageGroupCS: distribution | registration); empty for a single-group Measure. Join to IcrCoverage on report_id and group_code with a null-safe comparison (IS NOT DISTINCT FROM)"
        }
      ],
      "select": [
        {
          "forEach": "stratifier",
          "column": [
            {
              "name": "stratifier",
              "path": "code.coding.first().code",
              "type": "code",
              "description": "sex | age-band | delivery-strategy | disposition | geography | dose-history"
            }
          ],
          "select": [
            {
              "forEach": "stratum",
              "column": [
                {
                  "name": "stratum",
                  "path": "value.text",
                  "type": "string"
                },
                {
                  "name": "numerator",
                  "path": "population.where(code.coding.code = 'numerator').first().count",
                  "type": "integer"
                },
                {
                  "name": "denominator",
                  "path": "population.where(code.coding.code = 'denominator').first().count",
                  "type": "integer"
                },
                {
                  "name": "score",
                  "path": "measureScore.value",
                  "type": "decimal"
                }
              ]
            }
          ]
        }
      ]
    }
  ]
}