xpms.v_element_economics
Vista
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.
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| element_id | xpms.canon_code | Sí | Element. |
| item | xpms.canon_text | Sí | Item name. |
| urid | xpms.canon_code | Sí | Category URID. |
| unit_basis | xpms.canon_text | Sí | Unit basis of the amount. |
| grade_code | xpms.canon_code | Sí | Price grade code. |
| grade | xpms.canon_text | Sí | Price grade label. |
| amount_minor | bigint | Sí | Amount in minor units; NULL means unpriced. |
| currency_code | xpms.currency_code | Sí | Currency of the amount. |
| assertion_word | xpms.canon_code | Sí | Stated economics assertion of the band. |
| valid_from | date | Sí | Date the band was sourced. |
| valid_to | date | Sí | Date the band stops applying. |
| effective_confidence | text | Sí | Confidence after staleness, or a refusal value. |
| is_unpriced | boolean | Sí | True when the element has no band at this grade. |