Medicare Advantage, Part D, Medicaid

CMS inpatient Provider Specific File effective records

medicare_silver.inpatient_psf_provider_record·live·silver

Rows

3,161,162

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Effective-dated inpatient Provider Specific File history across the accepted current PDS export and quarterly full-history snapshots, retaining the publisher providerCcn identifier, effective/export/termination dates, provider type, geographic and wage assignments, teaching ratios, operating/capital CCRs, case mix, DSH, VBP/HRRP/HAC/EHR factors, uncompensated care, low-volume adjustment, county, NPI, exact raw fields, and Bronze lineage.

Grain

Key	Grain
N/A	1One full-history inpatient PSF record per accepted snapshot, source-native publisher provider identifier, and effective date.

Columns (64)

Column	Type	Meaning
`corpus_snapshot_date`	date
`asset_id`	string
`snapshot_date`	date
`document_path`	string
`source_row_number`	bigint
`source_encoding`	string
`ccn`	string
`effective_date`	date
`fiscal_year_begin_date`	date
`export_date`	date
`termination_date`	date
`last_updated`	date
`provider_type`	string
`state_code`	string
`intermediary_number`	string
`actual_geographic_msa`	string
`wage_index_msa`	string
`actual_geographic_cbsa`	string
`wage_index_cbsa`	string
`standardized_amount_cbsa`	string
`county_code`	string
`national_provider_identifier`	string
`wage_index_reclassification_code`	string
`supplemental_wage_index`	double
`supplemental_wage_index_indicator`	string
`bed_size`	int
`case_mix_adjusted_cost_per_discharge`	double
`cost_of_living_adjustment`	double
`interns_to_beds_ratio`	double
`operating_cost_to_charge_ratio`	double
`capital_cost_to_charge_ratio`	double
`case_mix_index`	double
`supplemental_security_income_ratio`	double
`medicaid_ratio`	double
`operating_dsh`	double
`hospital_specific_capital_rate`	double
`capital_indirect_medical_education_ratio`	double
`vbp_adjustment`	double
`hrr_adjustment`	double
`uncompensated_care_amount`	double
`low_volume_adjustment_factor`	double
`hospital_quality_indicator`	string
`hac_reduction_indicator`	string
`ehr_reduction_indicator`	string
`raw_fields_json`	string
`semantic_row_sha256`	string
`is_current_snapshot`	boolean
`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

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

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

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