xpms.v_element_economics
View
Every element at every price grade. A missing band is unpriced (amount NULL, never 0); effective confidence is computed at read time from the staleness policy.
| Column | Type | Nullable | Description |
|---|---|---|---|
| element_id | xpms.canon_code | Yes | Element. |
| item | xpms.canon_text | Yes | Item name. |
| urid | xpms.canon_code | Yes | Category URID. |
| unit_basis | xpms.canon_text | Yes | Unit basis of the amount. |
| grade_code | xpms.canon_code | Yes | Price grade code. |
| grade | xpms.canon_text | Yes | Price grade label. |
| amount_minor | bigint | Yes | Amount in minor units; NULL means unpriced. |
| currency_code | xpms.currency_code | Yes | Currency of the amount. |
| assertion_word | xpms.canon_code | Yes | Stated economics assertion of the band. |
| valid_from | date | Yes | Date the band was sourced. |
| valid_to | date | Yes | Date the band stops applying. |
| effective_confidence | text | Yes | Confidence after staleness, or a refusal value. |
| is_unpriced | boolean | Yes | True when the element has no band at this grade. |