xpms.dim_metric
TableRow level security on
Code-derived and modeled metrics (Bible tab 16). A code-derived metric is bound to its jurisdiction.
Primary key: domain, item
| Column | Type | Nullable | Description |
|---|---|---|---|
| domain | xpms.canon_code | No | Metric domain. |
| item | xpms.canon_text | No | What is measured. |
| ordinal | integer | No | Position of the metric in its Bible tab; the canonical display order where the code is not numeric. |
| value_numeric | numeric | Yes | Numeric value, when canon states a number. |
| value_text | xpms.canon_text | Yes | Value as text, when canon states it in words. |
| qualifier | xpms.canon_text | Yes | Qualifier of the value. |
| source | xpms.canon_text | Yes | Code section or basis of the value. |
| is_code_derived | boolean | No | True when the value derives from an adopted code. |
| jurisdiction_id | xpms.canon_code | Yes | Jurisdiction a code-derived value binds to.References xpms.jurisdiction.jurisdiction_id |
| is_jurisdiction_neutral | boolean | No | True when the value holds in any jurisdiction. |
| provenance | xpms.canon_code | No | Provenance of the metric.References xpms.dim_provenance.provenance |