xpms.v_phase_coverage
View
Catalog coverage per gated phase. A phase without an Active element carries a declared gap the owner ratified (Section 3.4, xpms.declared_gap).
| Column | Type | Nullable | Description |
|---|---|---|---|
| phase_code | xpms.canon_code | Yes | Gated phase. |
| gate | integer | Yes | Gate ordinal. |
| phase | xpms.canon_text | Yes | Phase label. |
| element_count | integer | Yes | Elements participating in the phase. |
| active_element_count | integer | Yes | Participating elements in the Active state. |
| category_count | integer | Yes | Distinct categories among participating elements. |
| has_active_element | boolean | Yes | True when at least one participating element is Active. |
| declared_gap | boolean | Yes | True when the phase carries a declared gap. |
| declared_gap_reason | xpms.canon_text | Yes | Why the phase has no Active element, as the declared gap states it; NULL without one. |