# AHRQ Quality Indicator public SAS value-set rules

`medicare_silver.ahrq_qi_value_set` · Medicare Advantage, Part D, Medicaid · status live · 10,020,218 rows

Normalized public IQI, PDI, PQI, and PSI SAS VALUE rules across the recoverable publisher history, preserving clinical system, code or range, output, comments, OTHER branches, compact row assignment, and exact Bronze/member/line lineage.

**Grain.** One row per observed release, SAS source member, format definition line, and rule ordinal.

| column | type | meaning |
|---|---|---|
| release_version | string |  |
| schema_era | string |  |
| module | string |  |
| code_system | string |  |
| format_name | string |  |
| format_description | string |  |
| rule_ordinal | bigint |  |
| code_start | string |  |
| code_end | string |  |
| output_value | string |  |
| rule_description | string |  |
| is_other_rule | boolean |  |
| source_asset_id | string |  |
| source_member | string |  |
| source_line_number | bigint |  |
| raw_rule_text | string |  |
| quality_flags | string |  |
| is_analytics_eligible | boolean |  |
| observed_period | date |  |
| asserted_at | date |  |
| effective_period_start | date |  |
| effective_period_end | date |  |
| cms_vintage_sequence | int |  |
| parse_revision | int |  |
| parser_artifact_hash | string |  |
| source_url | string |  |
| sha256_content_hash | string |  |
| source_id | string |  |
| is_current | boolean |  |
| bronze_object_key | string |  |
| s3_version_id | string |  |
| vintage_tag | string |  |
| drug_source_version_id | string |  |

Query it: `query_substrate` with `SELECT ... FROM medicare_silver.ahrq_qi_value_set WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.ahrq_qi_value_set")` first.