app.measurement_metrics
View
Figures a project measures against its gate 1 objectives (Section 4.10): sustainability, audience, earned media and sentiment, with the canon benchmark where canon states one.
| Column | Type | Nullable | Description |
|---|---|---|---|
| metric_code | text | Yes | Metric code. |
| family | text | Yes | Sustainability, Audience, Earned Media or Sentiment. |
| dimension | text | Yes | Dimension of the figure. |
| base_unit_code | text | Yes | Unit totals and comparisons are computed in. |
| aggregation | text | Yes | Sum or Latest. |
| is_derived | boolean | Yes | True when the figure is computed from coverage records rather than entered. |
| lower_bound | numeric | Yes | Lowest figure accepted, in the base unit. |
| upper_bound | numeric | Yes | Highest figure accepted, in the base unit. |
| canon_domain | xpms.canon_code | Yes | Domain of the benchmarking canon metric. |
| canon_item | xpms.canon_text | Yes | Item of the benchmarking canon metric. |
| canon_value_numeric | numeric | Yes | The canon benchmark as a number, when canon states one. |
| canon_value_text | xpms.canon_text | Yes | The canon benchmark in words, when canon states it so. |
| canon_qualifier | xpms.canon_text | Yes | Qualifier of the canon benchmark, such as MODELED event avg. |
| ordinal | integer | Yes | Display order. |