| 枚举字典 | 状态、渠道、支付方式、币种 |
|---|---|
| 范围 | 取值下限、取值上限、开闭区间 |
| 频率 | 每日例行稽核加上游变更后临时校验 |
| 输出 | 字典外取值清单与影响行数 |
字典外取值清单
字典外取值清单
SELECT status_name, COUNT(1) AS cnt
FROM dwd_trade_order_detail_di
WHERE dt = '2026-10-11'
AND status_name NOT IN ('created','paid','shipped','closed','refunded')
GROUP BY status_name;范围校验
范围校验
SELECT COUNT(1) AS out_of_range
FROM dwd_trade_discount_di
WHERE dt = '2026-10-11'
AND (discount_rate < 0 OR discount_rate > 1 OR discount_amt < 0);枚举字典与业务系统枚举表对齐，能自动同步可避免手工维护滞后。