Skip to content

xpms.dim_staleness_policy

TableRow level security on

Staleness policy for price bands (Bible tab 14): degrade one step at 12 months, to MODELED at 24, expire at 36.

Primary key: age_months_gte

Columns of xpms.dim_staleness_policy
ColumnTypeNullableDescription
age_months_gteintegerNoBand age in whole months from which the action applies.
actionxpms.canon_codeNoAction: hold, degrade_one_step, degrade_to_modeled or expire.
detailxpms.canon_textYesCanon detail for the action.