Medicare Advantage, Part D, Medicaid

CMS CSSC public EDPS, RAPS, and FERAS operational edits

medicare_silver.cssc_operational_edit·live·silver

Rows

679

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Public CMS-authored CSSC operational edit rows for EDPS institutional, professional, DME, and dental submissions plus RAPS and FERAS, retaining system, data type, edit code, disposition, effective history, resolution text, physical source row, and raw JSON.

Grain

Key	Grain
N/A	1One row per public lookup asset and physical JSON source row.

Columns (35)

Column	Type	Meaning
`corpus_snapshot_date`	date
`system`	string
`data_type`	string
`edit_code`	string
`category`	string
`disposition`	string
`applies_to`	string
`description`	string
`resolution_or_suggestion`	string
`effective_date`	date
`termination_date`	date
`effective_date_raw`	string
`termination_date_raw`	string
`source_asset_id`	string
`source_member`	string
`source_row_number`	bigint
`raw_row_json`	string
`quality_flags`	string
`is_current_release`	boolean
`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

describe_data_source(source_fqn="medicare_silver.cssc_operational_edit")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.cssc_operational_edit WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`observed_period,source_asset_id,source_row_number`
Join	`how_to_join(source_fqn="medicare_silver.cssc_operational_edit")`
Raw door	Athena (read-only via query_substrate): medicare_silver.cssc_operational_edit

This page as markdown: /docs-md/data/medicare_silver_cssc_operational_edit.md · every page in one file: /llms-full.txt