Provider of Services File - Quality Improvement and Evaluation System
The Provider of Services File (POS) - Quality Improvement and Evaluation System (QIES) data provides provider demographic and associated certification…
Part of the CMS Data Feeds Dataset › Medicare
Dataplex delivers this CMS feed as the analysis-ready table DWV.PROVIDER_OF_SERVICES_FILE__QUALITY_IMPROVEMENT_AND_EVALUATION_SYSTEM on Snowflake and Databricks — coverage from 2011 to 2026 in a single aligned schema, refreshed automatically whenever CMS publishes a new file. Every row carries lineage back to the exact CMS source file that produced it.
Key facts
Snowflake
DWV.PROVIDER_OF_SERVICES_FILE__QUALITY_IMPROVEMENT_AND_EVALUATION_SYSTEM
Databricks
cms_dwv.provider_of_services_file__quality_improvement_and_evaluation_system
Coverage
Oct 2011 – Mar 2026
Rows
3,496,832 (total across all reporting periods)
Cadence
Quarterly
Update pattern
Time-partitioned — each file adds one reporting period
CMS published
2026-04-15
Loaded
2026-04-15
Columns
595 data + 6 lineage
Identifiers
FIPS codes · ZIP codes
File versions
37
License
CMS public data — U.S. Government work
Platforms
Snowflake Marketplace · Databricks Delta Sharing
Included in the CMS Data Feeds Dataset — start a free trial on Snowflake Marketplace.
Current — CMS last published this feed on 2026-04-15. Coverage runs through 2026-03-31. Next CMS release expected ~Jul 2026.
Time-partitioned feed — each file version covers one reporting period, so history is additive. Query the full table for all periods; filter on the reporting period columns for a single period. Do not filter to the latest file only — that would return just the 2026 reporting period.
Sample queries
About this feed
The Provider of Services File (POS) - Quality Improvement and Evaluation System (QIES) data provides provider demographic and associated certification information for hospital & non-hospital facilities along with the provider number (CMS Certification Number), name, address, and other characteristics of the participating providers.
— Source: CMS feed metadata
Keywords: Medicare, Original Medicare, Medicare Advantage, Hospitals & Facilities, Inpatient, Outpatient Facilities, Provider Enrollment Theme: Medicare
Coverage timeline
2011–2026 🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩 (🟩 covered · ⬜ no data)
16 of 16 years covered — no gaps.
Release history
2026-01-01 – 2026-03-31
2026-04-15
2026-04-15
✓
2025-10-01 – 2025-12-31
2026-01-12
2026-01-12
2025-07-01 – 2025-09-30
2025-12-10
2025-12-11
2025-04-01 – 2025-06-30
2025-08-07
2025-12-11
2025-01-01 – 2025-03-31
2025-04-25
2025-12-11
2024-10-01 – 2024-12-31
2025-01-31
2025-12-11
2024-07-01 – 2024-09-30
2024-10-15
2025-12-11
2024-04-01 – 2024-06-30
2024-07-18
2025-12-11
2024-01-01 – 2024-03-31
2024-04-11
2025-12-11
2023-10-01 – 2023-12-31
2024-02-27
2025-12-11
Show 27 earlier file versions
2023-07-01 – 2023-09-30
2023-10-17
2025-12-11
2023-04-01 – 2023-06-30
2023-07-26
2025-12-11
2023-01-01 – 2023-03-31
2023-05-11
2025-12-11
2022-10-01 – 2022-12-31
2023-03-07
2025-12-11
2022-07-01 – 2022-09-30
2022-10-25
2025-12-11
2022-04-01 – 2022-06-30
2022-09-19
2025-12-11
2022-01-01 – 2022-03-31
2022-04-14
2025-12-11
2021-10-01 – 2021-12-31
2022-01-10
2025-12-11
2021-07-01 – 2021-09-30
2021-10-29
2025-12-11
2021-04-01 – 2021-06-30
2021-07-23
2025-12-11
2021-01-01 – 2021-03-31
2021-07-20
2025-12-11
2020-10-01 – 2020-12-31
2021-05-20
2025-12-11
2020-07-01 – 2020-09-30
2021-05-20
2025-12-11
2020-04-01 – 2020-06-30
2020-12-21
2025-12-11
2020-01-01 – 2020-03-31
2020-12-21
2025-12-11
2019-10-01 – 2019-12-31
2021-01-11
2025-12-11
2019-07-01 – 2019-09-30
2022-01-04
2025-12-11
2019-04-01 – 2019-06-30
2021-01-11
2025-12-11
2019-01-01 – 2019-03-31
2021-01-11
2025-12-11
2018-10-01 – 2018-12-31
2021-01-11
2025-12-11
2017-10-01 – 2017-12-31
2021-01-11
2025-12-11
2016-10-01 – 2016-12-31
2021-05-20
2025-12-11
2015-10-01 – 2015-12-31
2021-05-20
2025-12-11
2014-10-01 – 2014-12-31
2021-05-20
2025-12-11
2013-10-01 – 2013-12-31
2021-05-20
2025-12-11
2012-10-01 – 2012-12-31
2021-05-20
2025-12-11
2011-10-01 – 2011-12-31
2021-05-20
2025-12-11
Data dictionary
📋 595 data columns + 6 lineage columns
Column-level definitions are maintained by CMS in the official Provider of Services File - Quality Improvement and Evaluation System data dictionary.
Data columns
PRVDR_CTGRY_SBTYP_CD
NUMBER
PRVDR_CTGRY_CD
NUMBER
CHOW_CNT
NUMBER
CHOW_DT
NUMBER
CITY_NAME
TEXT
ACPTBL_POC_SW
BOOLEAN
CMPLNC_STUS_CD
TEXT
SSA_CNTY_CD
NUMBER
CROSS_REF_PROVIDER_NUMBER
TEXT
CRTFCTN_DT
NUMBER
ELGBLTY_SW
BOOLEAN
FAC_NAME
TEXT
INTRMDRY_CARR_CD
NUMBER
MDCD_VNDR_NUM
TEXT
ORGNL_PRTCPTN_DT
NUMBER
CHOW_PRIOR_DT
NUMBER
INTRMDRY_CARR_PRIOR_CD
NUMBER
PRVDR_NUM
TEXT
RGN_CD
NUMBER
SKLTN_REC_SW
BOOLEAN
STATE_CD
TEXT
SSA_STATE_CD
NUMBER
STATE_RGN_CD
TEXT
ST_ADR
TEXT
PHNE_NUM
NUMBER
PGM_TRMNTN_CD
NUMBER
TRMNTN_EXPRTN_DT
NUMBER
CRTFCTN_ACTN_TYPE_CD
NUMBER
GNRL_CNTL_TYPE_CD
TEXT
ZIP_CD
TEXT
FIPS_STATE_CD
NUMBER
FIPS_CNTY_CD
NUMBER
CBSA_URBN_RRL_IND
TEXT
CBSA_CD
NUMBER
ACRDTN_EFCTV_DT
NUMBER
ACRDTN_EXPRTN_DT
NUMBER
ACRDTN_TYPE_CD
NUMBER
TOT_AFLTD_AMBLNC_SRVC_CNT
NUMBER
TOT_AFLTD_ASC_CNT
NUMBER
TOT_COLCTD_HOSP_CNT
NUMBER
TOT_AFLTD_ESRD_CNT
NUMBER
TOT_AFLTD_FQHC_CNT
NUMBER
TOT_AFLTD_HHA_CNT
NUMBER
TOT_AFLTD_HOSPC_CNT
NUMBER
TOT_AFLTD_OPO_CNT
NUMBER
TOT_AFLTD_PRTF_CNT
NUMBER
TOT_AFLTD_RHC_CNT
NUMBER
TOT_AFLTD_SNF_CNT
NUMBER
AFLTD_PRVDR_CNT
NUMBER
RSDNT_PGM_ALPTHC_SW
BOOLEAN
RSDNT_PGM_DNTL_SW
BOOLEAN
RSDNT_PGM_OSTPTHC_SW
BOOLEAN
RSDNT_PGM_OTHR_SW
BOOLEAN
RSDNT_PGM_PDTRC_SW
BOOLEAN
LAB_SRVC_CD
TEXT
PHRMCY_SRVC_CD
NUMBER
RDLGY_SRVC_CD
TEXT
ASC_BGN_SRVC_DT
TEXT
FREESTNDNG_ASC_SW
TEXT
OVRRD_BED_CNT_SW
BOOLEAN
CRTFD_BED_CNT
NUMBER
ICFIID_BED_CNT
TEXT
MDCD_NF_BED_CNT
TEXT
MDCR_SNF_BED_CNT
TEXT
MDCR_MDCD_SNF_BED_CNT
TEXT
AIDS_BED_CNT
TEXT
ALZHMR_BED_CNT
TEXT
DLYS_BED_CNT
TEXT
DSBL_CHLDRN_BED_CNT
TEXT
HEAD_TRMA_BED_CNT
TEXT
HOSPC_BED_CNT
TEXT
HNTGTN_DEASE_BED_CNT
TEXT
REHAB_BED_CNT
TEXT
VNTLTR_BED_CNT
TEXT
BED_CNT
NUMBER
BRNCH_CNT
TEXT
BRNCH_OPRTN_SW
BOOLEAN
CAH_PSYCH_DPU_SW
BOOLEAN
CAH_REHAB_DPU_SW
BOOLEAN
CAH_SB_SW
BOOLEAN
CRDC_CTHRTZTN_PRCDR_ROOMS_CNT
NUMBER
GNRL_FAC_TYPE_CD
NUMBER
CHOW_SW
BOOLEAN
CLIA_ID_NUMBER_1
TEXT
CLIA_ID_NUMBER_2
TEXT
CLIA_ID_NUMBER_3
TEXT
CLIA_ID_NUMBER_4
TEXT
CLIA_ID_NUMBER_5
TEXT
COLCTN_STUS_SW
BOOLEAN
RN_24_HR_WVR_SW
BOOLEAN
RN_7_DAY_WVR_SW
BOOLEAN
BED_PER_ROOM_WVR_SW
BOOLEAN
LSC_WVR_SW
BOOLEAN
ROOM_SIZE_WVR_SW
BOOLEAN
ENDSCPY_PRCDR_ROOMS_CNT
NUMBER
ESRD_NTWRK_NUM
TEXT
EXPRMT_RSRCH_CNDCTD_SW
BOOLEAN
FAX_PHNE_NUM
NUMBER
FY_END_MO_DAY_CD
NUMBER
FQHC_APPROVED_RHC_PROVIDER_NUM
NUMBER
FED_FUNDD_FQHC_SW
BOOLEAN
HHA_QLFYD_OPT_SPCH_SW
BOOLEAN
HH_AIDE_TRNG_PGM_CD
TEXT
HOME_TRNG_SPRT_ONLY_SRVC_SW
BOOLEAN
MDCR_HOSPC_SW
BOOLEAN
HOSP_BSD_SW
BOOLEAN
INCNTR_NCTRNL_SRVC_SW
BOOLEAN
LTC_CROSS_REF_PROVIDER_NUMBER
TEXT
MDCL_SCHL_AFLTN_CD
NUMBER
MEDICARE_HOSPICE_PROVIDER_NUM
TEXT
MDCD_MDCR_PRTCPTG_PRVDR_SW
BOOLEAN
MEDICARE_MEDICAID_PRVDR_NUMBER
TEXT
MLT_FAC_ORG_NAME
TEXT
MLT_OWND_FAC_ORG_SW
BOOLEAN
NCRY_PRVDR_DSGNTD_DT
TEXT
NCRY_PRVDR_DSGNTD_AS_SW
BOOLEAN
NCRY_PRVDR_LOST_DT
TEXT
MEET_1861_SW
BOOLEAN
NPP_TYPE_CD
TEXT
TOT_OFSITE_CNCR_HOSP_CNT
NUMBER
TOT_OFSITE_CHLDRN_HOSP_CNT
NUMBER
TOT_OFSITE_EMER_DEPT_CNT
NUMBER
TOT_OFSITE_INPTNT_LCTN_CNT
NUMBER
TOT_OFSITE_LTC_HOSP_CNT
NUMBER
TOT_OFSITE_OPTHLMC_SRGRY_CNT
NUMBER
TOT_OFSITE_OTHR_LCTN_CNT
NUMBER
TOT_OFSITE_PSYCH_HOSP_CNT
NUMBER
TOT_OFSITE_PSYCH_UNIT_CNT
NUMBER
TOT_OFSITE_REHAB_HOSP_CNT
NUMBER
TOT_OFSITE_REHAB_UNIT_CNT
NUMBER
TOT_OFSITE_URGNT_CARE_CNTR_CNT
NUMBER
OFSITE_LCTN_CNT
NUMBER
OPRTG_ROOM_CNT
TEXT
ORGNZ_FMLY_MBR_GRP_SW
BOOLEAN
ORGNZ_RSDNT_GRP_SW
BOOLEAN
PARENT_PROVIDER_NUMBER
NUMBER
FQHC_APRVD_RHC_SW
BOOLEAN
MDCR_PRTCPTN_OP_PT_SPCH_SW
BOOLEAN
PGM_PRTCPTN_CD
TEXT
PRVDR_BSD_FAC_SW
BOOLEAN
PRVNC_CD
TEXT
PSYCH_UNIT_BED_CNT
NUMBER
PSYCH_UNIT_EFCTV_DT
NUMBER
PSYCH_UNIT_SW
BOOLEAN
PSYCH_UNIT_TRMNTN_CD
NUMBER
PSYCH_UNIT_TRMNTN_DT
NUMBER
REHAB_UNIT_BED_CNT
NUMBER
REHAB_UNIT_EFCTV_DT
NUMBER
REHAB_UNIT_SW
BOOLEAN
REHAB_UNIT_TRMNTN_CD
NUMBER
REHAB_UNIT_TRMNTN_DT
NUMBER
RELATED_PROVIDER_NUMBER
NUMBER
ACUTE_RNL_DLYS_SRVC_CD
NUMBER
PSYCH_SRVC_CD
NUMBER
HH_AIDE_SRVC_CD
TEXT
ALCHL_DRUG_SRVC_CD
NUMBER
ANSTHSA_SRVC_CD
NUMBER
APLNC_EQUIP_SRVC_CD
TEXT
AUDLGY_SRVC_CD
NUMBER
BLOOD_SRVC_OFSITE_RSDNT_SW
BOOLEAN
BLOOD_SRVC_ONST_NRSDNT_SW
BOOLEAN
BLOOD_SRVC_ONST_RSDNT_SW
BOOLEAN
BURN_CARE_UNIT_SRVC_CD
NUMBER
CRDC_CTHRTZTN_LAB_SRVC_CD
NUMBER
OPEN_HRT_SRGRY_SRVC_CD
NUMBER
CARF_IP_REHAB_SRVC_CD
NUMBER
CHMTHRPY_SRVC_CD
NUMBER
CHRPRCTIC_SRVC_CD
NUMBER
CL_SRVC_OFSITE_RSDNT_SW
BOOLEAN
CL_SRVC_ONST_NRSDNT_SW
BOOLEAN
CL_SRVC_ONST_RSDNT_SW
BOOLEAN
CL_SRVC_CD
NUMBER
CRNRY_CARE_UNIT_SRVC_CD
NUMBER
CNSLNG_SRVC_CD
TEXT
CT_SCAN_SRVC_CD
NUMBER
DNTL_SRVC_CD
NUMBER
DNTL_SRVC_OFSITE_RSDNT_SW
BOOLEAN
DNTL_SRVC_ONST_NRSDNT_SW
BOOLEAN
DNTL_SRVC_ONST_RSDNT_SW
BOOLEAN
SHCK_TRMA_SRVC_CD
NUMBER
DGNSTC_RDLGY_SRVC_CD
NUMBER
DTRY_SRVC_CD
NUMBER
DTRY_OFSITE_RSDNT_SW
BOOLEAN
DTRY_ONST_NRSDNT_SW
BOOLEAN
DTRY_ONST_RSDNT_SW
BOOLEAN
DCTD_ER_SRVC_CD
NUMBER
EMER_PSYCH_SRVC_CD
NUMBER
XTRCRPRL_SHCK_LTHTRPTR_SRVC_CD
NUMBER
FRNSC_PSYCH_SRVC_CD
NUMBER
GRTRC_PSYCH_SRVC_CD
NUMBER
GRNTLGCL_SPCLTY_SRVC_CD
NUMBER
SP_HOME_TRNG_SPRT_HD_SW
BOOLEAN
HMDLYS_SRVC_SW
BOOLEAN
HMMKR_SRVC_CD
TEXT
HSEKPNG_SRVC_OFSITE_RSDNT_SW
BOOLEAN
HSEKPNG_SRVC_ONST_NRSDNT_SW
BOOLEAN
HSEKPNG_SRVC_ONST_RSDNT_SW
BOOLEAN
IP_SRGCL_SRVC_CD
NUMBER
INTRN_RSDNT_SRVC_CD
TEXT
MDCL_SCL_SRVC_CD
TEXT
MDCL_SUPLY_SRVC_CD
TEXT
ICU_SRVC_CD
NUMBER
MDCR_TRNSPLNT_CNTR_SRVC_CD
NUMBER
MENTL_HLTH_OFSITE_RSDNT_SW
BOOLEAN
MENTL_HLTH_ONST_NRSDNT_SW
BOOLEAN
MENTL_HLTH_ONST_RSDNT_SW
BOOLEAN
MGNTC_RSNC_IMG_SRVC_CD
NUMBER
NEONTL_ICU_SRVC_CD
NUMBER
NEONTL_NRSRY_SRVC_CD
NUMBER
NRSRGCL_SRVC_CD
NUMBER
ORGN_TRNSPLNT_SRVC_CD
NUMBER
NUCLR_MDCN_SRVC_CD
NUMBER
NRSNG_SRVC_EMPLEE_SW
BOOLEAN
NRSNG_SRVC_CNTRCTR_SW
BOOLEAN
NRSNG_SRVC_ARNGMT_SW
BOOLEAN
NRSNG_SRVC_CD
TEXT
NRSNG_SRVC_OFSITE_RSDNT_SW
BOOLEAN
NRSNG_SRVC_ONST_NRSDNT_SW
BOOLEAN
NRSNG_SRVC_ONST_RSDNT_SW
BOOLEAN
NTRTNL_GDNC_SRVC_CD
TEXT
OB_SRVC_CD
NUMBER
OPTHLMC_SRGY_SRVC_CD
NUMBER
OPTMTRC_SRVC_CD
NUMBER
OPRTG_ROOM_SRVC_CD
NUMBER
ORTHPDC_SRGY_SRVC_CD
NUMBER
ORTHTC_PRSTHTC_EMPLEE_SW
BOOLEAN
ORTHTC_PRSTHTC_CNTRCTR_SW
BOOLEAN
ORTHTC_PRSTHTC_ARNGMT_SW
BOOLEAN
OT_EMPLEE_SW
BOOLEAN
OT_CNTRCTR_SW
BOOLEAN
OT_ARNGMT_SW
BOOLEAN
OT_SRVC_CD
NUMBER
OT_SRVC_OFSITE_RSDNT_SW
BOOLEAN
OT_SRVC_ONST_NRSDNT_SW
BOOLEAN
OT_SRVC_ONST_RSDNT_SW
BOOLEAN
OTHR_SRVC_CD
TEXT
OP_SRVC_CD
NUMBER
OP_PSYCH_SRVC_CD
NUMBER
OP_REHAB_SRVC_CD
NUMBER
OP_SRGRY_UNIT_SRVC_CD
NUMBER
PED_SRVC_CD
NUMBER
PED_ICU_SRVC_CD
NUMBER
SP_HOME_TRNG_SPRT_PD_SW
BOOLEAN
PRTNL_DLYS_SRVC_SW
BOOLEAN
PET_SCAN_SRVC_CD
NUMBER
PHRMCY_SRVC_OFSITE_RSDNT_SW
BOOLEAN
PHRMCY_SRVC_ONST_NRSDNT_SW
BOOLEAN
PHRMCY_SRVC_ONST_RSDNT_SW
BOOLEAN
PHYSN_EMPLEE_SW
BOOLEAN
PHYSN_CNTRCTR_SW
BOOLEAN
PHYSN_ARNGMT_SW
BOOLEAN
PHYSN_SRVC_CD
TEXT
PHYSN_EXT_SRVC_OFSITE_RSDNT_SW
BOOLEAN
PHYSN_EXT_SRVC_ONST_NRSDNT_SW
BOOLEAN
PHYSN_EXT_SRVC_ONST_RSDNT_SW
BOOLEAN
PHYSN_SRVC_OFSITE_RSDNT_SW
BOOLEAN
PHYSN_SRVC_ONST_NRSDNT_SW
BOOLEAN
PHYSN_SRVC_ONST_RSDNT_SW
BOOLEAN
PDTRY_SRVC_OFSITE_RSDNT_SW
BOOLEAN
PDTRY_SRVC_ONST_NRSDNT_SW
BOOLEAN
PDTRY_SRVC_ONST_RSDNT_SW
BOOLEAN
PSTOPRTV_RCVRY_SRVC_CD
NUMBER
CHLD_ADLSCNT_PSYCH_SRVC_CD
NUMBER
PSYCHLGCL_EMPLEE_SW
BOOLEAN
PSYCHLGCL_CNTRCTR_SW
BOOLEAN
PSYCHLGCL_ARNGMT_SW
BOOLEAN
PT_EMPLEE_SW
BOOLEAN
PT_CNTRCTR_SW
BOOLEAN
PT_ARNGMT_SW
BOOLEAN
PT_SRVC_CD
NUMBER
PT_OFSITE_RSDNT_SW
BOOLEAN
PT_ONST_NRSDNT_SW
BOOLEAN
PT_ONST_RSDNT_SW
BOOLEAN
RCNSTRCTN_SRGY_SRVC_CD
NUMBER
RSPRTRY_CARE_EMPLEE_SW
BOOLEAN
RSPRTRY_CARE_CNTRCTR_SW
BOOLEAN
RSPRTRY_CARE_ARNGMT_SW
BOOLEAN
RSPRTRY_CARE_SRVC_CD
NUMBER
SHRT_TERM_IP_SRVC_CD
TEXT
SCL_EMPLEE_SW
BOOLEAN
SCL_CNTRCTR_SW
BOOLEAN
SCL_ARNGMT_SW
BOOLEAN
SCL_SRVC_CD
NUMBER
SCL_WORK_SRVC_OFSITE_RSDNT_SW
BOOLEAN
SCL_WORK_SRVC_ONST_NRSDNT_SW
BOOLEAN
SCL_WORK_SRVC_ONST_RSDNT_SW
BOOLEAN
SPCH_PTHLGY_EMPLEE_SW
BOOLEAN
SPCH_PTHLGY_CNTRCTR_SW
BOOLEAN
SPCH_PTHLGY_ARNGMT_SW
BOOLEAN
SPCH_PTHLGY_SRVC_CD
NUMBER
SPCH_PTHLGY_OFSITE_RSDNT_SW
BOOLEAN
SPCH_PTHLGY_ONST_NRSDNT_SW
BOOLEAN
SPCH_PTHLGY_ONST_RSDNT_SW
BOOLEAN
SPCH_THRPY_SRVC_CD
TEXT
SRGCL_ICU_SRVC_CD
NUMBER
ACTVTY_OTHR_OFSITE_RSDNT_SW
BOOLEAN
ACTVTY_OTHR_ONST_NRSDNT_SW
BOOLEAN
ACTVTY_OTHR_ONST_RSDNT_SW
BOOLEAN
SCL_SRVC_OTHR_OFSITE_RSDNT_SW
BOOLEAN
SCL_SRVC_OTHR_ONST_NRSDNT_SW
BOOLEAN
SCL_SRVC_OTHR_ONST_RSDNT_SW
BOOLEAN
ACTVTY_OFSITE_RSDNT_SW
BOOLEAN
ACTVTY_ONST_NRSDNT_SW
BOOLEAN
ACTVTY_ONST_RSDNT_SW
BOOLEAN
THRPTC_RDLGY_SRVC_CD
NUMBER
THRPTC_RCRTNL_OFSITE_RSDNT_SW
BOOLEAN
THRPTC_RCRTNL_ONST_NRSDNT_SW
BOOLEAN
THRPTC_RCRTNL_ONST_RSDNT_SW
BOOLEAN
URGNT_CARE_SRVC_CD
NUMBER
VCTNL_GDNC_SRVC_CD
TEXT
VCTNL_SRVC_OFSITE_RSDNT_SW
BOOLEAN
VCTNL_SRVC_ONST_NRSDNT_SW
BOOLEAN
VCTNL_SRVC_ONST_RSDNT_SW
BOOLEAN
DGNSTC_XRAY_OFSITE_RSDNT_SW
BOOLEAN
DGNSTC_XRAY_ONST_NRSDNT_SW
BOOLEAN
DGNSTC_XRAY_ONST_RSDNT_SW
BOOLEAN
ACUTE_RESP_CARE_CD
TEXT
OVRRD_STFG_SW
BOOLEAN
PROFNL_ADMIN_CNTRCT_CNT
TEXT
PROFNL_ADMIN_FLTM_CNT
TEXT
PROFNL_ADMIN_PRTM_CNT
TEXT
HH_AIDE_EMPLEE_CNT
TEXT
HH_AIDE_VLNTR_CNT
TEXT
PRSNEL_OTHR_CNT
NUMBER
NRS_AIDE_CNTRCT_CNT
TEXT
NRS_AIDE_FLTM_CNT
TEXT
NRS_AIDE_PRTM_CNT
TEXT
CNSLR_EMPLEE_CNT
TEXT
CNSLR_VLNTR_CNT
TEXT
CRNA_CNT
NUMBER
DNTST_CNTRCT_CNT
TEXT
DNTST_FLTM_CNT
TEXT
DNTST_PRTM_CNT
TEXT
DIETN_CNT
NUMBER
DIETN_CNTRCT_CNT
TEXT
DIETN_FLTM_CNT
TEXT
DIETN_PRTM_CNT
TEXT
DRCT_CARE_PRSNEL_CNT
TEXT
FOOD_SRVC_CNTRCT_CNT
TEXT
FOOD_SRVC_FLTM_CNT
TEXT
FOOD_SRVC_PRTM_CNT
TEXT
HH_AIDE_CNT
TEXT
HMMKR_EMPLEE_CNT
TEXT
HMMKR_VLNTR_CNT
TEXT
HSEKPNG_CNTRCT_CNT
TEXT
HSEKPNG_FLTM_CNT
TEXT
HSEKPNG_PRTM_CNT
TEXT
LAB_TCHNCN_CNT
NUMBER
LPN_CNT
TEXT
LPN_LVN_CNT
NUMBER
LPN_LVN_CNTRCT_CNT
TEXT
LPN_LVN_FLTM_CNT
TEXT
LPN_LVN_PRTM_CNT
TEXT
LPN_LVN_VLNTR_CNT
TEXT
MDCL_DRCTR_CNTRCT_CNT
TEXT
MDCL_DRCTR_FLTM_CNT
TEXT
MDCL_DRCTR_PRTM_CNT
TEXT
MDCL_SCL_WORKR_CNT
NUMBER
MDCL_SCL_WORKR_VLNTR_CNT
TEXT
MDCL_TCHNLGST_CNT
NUMBER
MDCTN_AIDE_CNTRCT_CNT
TEXT
MDCTN_AIDE_FLTM_CNT
TEXT
MDCTN_AIDE_PRTM_CNT
TEXT
MENTL_HLTH_SRVC_CNTRCT_CNT
TEXT
MENTL_HLTH_SRVC_FLTM_CNT
TEXT
MENTL_HLTH_SRVC_PRTM_CNT
TEXT
NUCLR_MDCN_TCHNCN_CNT
NUMBER
NAT_CNTRCT_CNT
TEXT
NAT_FLTM_CNT
TEXT
NAT_PRTM_CNT
TEXT
NRS_PRCTNR_CNT
NUMBER
NRS_ADMINV_CNTRCT_CNT
TEXT
NRS_ADMINV_FLTM_CNT
TEXT
NRS_ADMINV_PRTM_CNT
TEXT
OCPTNL_THRPST_CNT
NUMBER
OCPTNL_THRPST_CNTRCT_CNT
TEXT
OCPTNL_THRPST_FLTM_CNT
TEXT
OCPTNL_THRPST_PRTM_CNT
TEXT
OT_AIDE_CNTRCT_CNT
TEXT
OT_AIDE_FLTM_CNT
TEXT
OT_AIDE_PRTM_CNT
TEXT
OT_ASTNT_CNTRCT_CNT
TEXT
OT_ASTNT_FLTM_CNT
TEXT
OT_ASTNT_PRTM_CNT
TEXT
VLNTR_OTHR_CNT
TEXT
ACTVTY_STF_OTHR_CNTRCT_CNT
TEXT
ACTVTY_STF_OTHR_FLTM_CNT
TEXT
ACTVTY_STF_OTHR_PRTM_CNT
TEXT
PHYSN_OTHR_CNTRCT_CNT
TEXT
PHYSN_OTHR_FLTM_CNT
TEXT
PHYSN_OTHR_PRTM_CNT
TEXT
SCL_SRVC_OTHR_STF_CNTRCT_CNT
TEXT
SCL_SRVC_OTHR_STF_FLTM_CNT
TEXT
SCL_SRVC_OTHR_STF_PRTM_CNT
TEXT
STF_OTHR_CNTRCT_CNT
TEXT
STF_OTHR_FLTM_CNT
TEXT
STF_OTHR_PRTM_CNT
TEXT
PHRMCST_CNTRCT_CNT
TEXT
PHRMCST_FLTM_CNT
TEXT
PHRMCST_PRTM_CNT
TEXT
PHYS_THRPST_CNTRCT_CNT
TEXT
PHYS_THRPST_FLTM_CNT
TEXT
PHYS_THRPST_PRTM_CNT
TEXT
PHYSN_CNT
NUMBER
PHYSN_VLNTR_CNT
TEXT
PHYSN_ASTNT_CNT
NUMBER
PHYSN_EXT_CNTRCT_CNT
TEXT
PHYSN_EXT_FLTM_CNT
TEXT
PHYSN_EXT_PRTM_CNT
TEXT
RSDNT_PHYSN_CNT
NUMBER
PDTRST_CNTRCT_CNT
TEXT
PDTRST_FLTM_CNT
TEXT
PDTRST_PRTM_CNT
TEXT
PSYCHLGST_CNT
NUMBER
PHYS_THRPST_STF_CNT
TEXT
PHYS_THRPST_CNT
NUMBER
PHYS_THRPST_ARNGMT_CNT
TEXT
PT_AIDE_CNTRCT_CNT
TEXT
PT_AIDE_FLTM_CNT
TEXT
PT_AIDE_PRTM_CNT
TEXT
PT_ASTNT_CNTRCT_CNT
TEXT
PT_ASTNT_FLTM_CNT
TEXT
PT_ASTNT_PRTM_CNT
TEXT
ACTVTY_PROFNL_CNTRCT_CNT
TEXT
ACTVTY_PROFNL_FLTM_CNT
TEXT
ACTVTY_PROFNL_PRTM_CNT
TEXT
RDLGY_TCHNCN_CNT
NUMBER
REG_PHRMCST_CNT
NUMBER
INHLTN_THRPST_CNT
NUMBER
RN_CNT
NUMBER
RN_CNTRCT_CNT
TEXT
RN_FLTM_CNT
TEXT
RN_PRTM_CNT
TEXT
RN_VLNTR_CNT
TEXT
RN_DRCTR_CNTRCT_CNT
TEXT
RN_DRCTR_FLTM_CNT
TEXT
RN_DRCTR_PRTM_CNT
TEXT
SCL_WORKR_CNT
TEXT
SCL_WORKR_CNTRCT_CNT
TEXT
SCL_WORKR_FLTM_CNT
TEXT
SCL_WORKR_PRTM_CNT
TEXT
SPCH_PTHLGST_ARNGMT_CNT
TEXT
SPCH_PTHLGST_CNTRCT_CNT
TEXT
SPCH_PTHLGST_FLTM_CNT
TEXT
SPCH_PTHLGST_PRTM_CNT
TEXT
SPCH_PTHLGST_CNT
TEXT
SPCH_PTHLGST_AUDLGST_CNT
NUMBER
TCHNCL_STF_NUM
TEXT
TCHNCN_CNT
TEXT
THRPTC_RCRTNL_CNTRCT_CNT
TEXT
THRPTC_RCRTNL_FLTM_CNT
TEXT
THRPTC_RCRTNL_PRTM_CNT
TEXT
EMPLEE_CNT
TEXT
VLNTR_CNT
TEXT
SBUNIT_CNT
TEXT
SBUNIT_SW
BOOLEAN
SBUNIT_OPRTN_SW
BOOLEAN
DNTL_SRGRY_SW
TEXT
OTLRYNGLGY_SRGRY_SW
BOOLEAN
ENDSCPY_SRGRY_SW
TEXT
OB_GYN_SRGRY_SW
BOOLEAN
OPTHMLGY_SRGRY_SW
BOOLEAN
ORTHPDC_SRGRY_SW
BOOLEAN
OTHR_SRGRY_SW
TEXT
PAIN_SRGRY_SW
TEXT
PLSTC_SRGRY_SW
BOOLEAN
FT_SRGRY_SW
BOOLEAN
SB_SW
BOOLEAN
SB_SIZE_CD
NUMBER
TCHNLGST_2_YR_RDLGC_CNT
TEXT
TCHNLGST_ASCT_DGR_CNT
TEXT
TCHNLGST_BS_BA_DGR_CNT
TEXT
DLYS_STN_CNT
TEXT
REC_STUS_CD
TEXT
SRVY_PRPSE_CD
NUMBER
PHRMCY_SRVC_DESC
TEXT
ADMSN_SUSPNSN_DT
TEXT
ADMSN_SUSPNSN_PRIOR_DT
TEXT
HHA_TRNG_PGM_CD
TEXT
MR_BED_CNT
TEXT
MDCD_SNF_BED_CNT
TEXT
SCOPE_OF_SRVC_WVR_SW
BOOLEAN
TCHNCL_PRSNEL_WVR_SW
BOOLEAN
SRVY_EVER_ACRDTD_SW
BOOLEAN
SRVY_EVER_NACRDTD_SW
BOOLEAN
SRVY_EVER_SB_SW
BOOLEAN
DRCTR_QUALN_CD
TEXT
DRCTR_QUALN_DESC
TEXT
VLDTN_SRVY_DT
NUMBER
FED_PGM_SPRT_SW
BOOLEAN
OVRRD_NRS_BED_SW
BOOLEAN
AGRMT_BGN_DT
TEXT
AGRMT_END_DT
TEXT
AGRMT_EXTNSN_DT
TEXT
ACUTE_RNL_DLYS_SRVC_DESC
TEXT
PSYCH_SRVC_DESC
TEXT
ALCHL_DRUG_SRVC_DESC
TEXT
ANSTHSA_SRVC_DESC
TEXT
AUDLGY_SRVC_DESC
TEXT
BURN_CARE_UNIT_SRVC_DESC
TEXT
…and 95 more columns. Run DESCRIBE VIEW DWV.PROVIDER_OF_SERVICES_FILE__QUALITY_IMPROVEMENT_AND_EVALUATION_SYSTEM once the share is mounted for the complete column list.
Lineage columns (present on every feed table)
ROW_ID
TEXT
Unique row ID for this table (PK)
FILE_ID
TEXT
Source file — joins to FEEDS_FILES.ID (FK)
FILE_FEED_ID
TEXT
Parent feed — joins to FEEDS.ID (FK)
FILE_NAME
TEXT
Source file name as published by CMS
ROWNUM
NUMBER
Row number within the source file
CREATED_AT
TIMESTAMP_NTZ
Timestamp when the record was loaded
Row-level lineage
Every row in this table traces to the exact CMS source file that produced it. The FILE_ID column joins to the FEEDS_FILES catalog table, and FILE_FEED_ID joins to the FEEDS master table:
Trace any row back to its source file and reporting period:
Source & provenance
Published by the Centers for Medicare & Medicaid Services (bureau 009:38).
Frequently asked questions
How often is Provider of Services File - Quality Improvement and Evaluation System updated?
Quarterly. CMS last published this feed on 2026-04-15, and Dataplex loaded it to the warehouse the same day. New releases are added automatically when CMS publishes them.
What years does Provider of Services File - Quality Improvement and Evaluation System cover?
2011 through 2026.
How many records are in Provider of Services File - Quality Improvement and Evaluation System?
3,496,832 rows across all 37 reporting periods. Because this feed is time-partitioned, the full table total is the meaningful count — no deduplication needed.
How do I get Provider of Services File - Quality Improvement and Evaluation System data?
It's included in the CMS Data Feeds Dataset on the Snowflake Marketplace (free trial available) and via Databricks Delta Sharing. Once mounted, query DWV.PROVIDER_OF_SERVICES_FILE__QUALITY_IMPROVEMENT_AND_EVALUATION_SYSTEM directly — no pipeline setup required.
Related feeds
Provider of Services File - Hospital & Non-Hospital FacilitiesAmbulatory Surgical Centers and Independent Free Standing Emergency Departments Enrolled in Medicare As Hospital ProvidersHome Infusion Therapy ProvidersHospital Change of Ownership - Owner InformationProvider of Services File - Clinical LaboratoriesGet this feed
Start a free trial on Snowflake Marketplace or purchase via Databricks
Mount the share — the database and
DWVschema appear in your account immediatelyRun the sample query above — no ETL, no pipeline maintenance
Questions about this feed? Contact us at notifications@dataplex-consulting.com.
Part of the CMS Data Feeds Dataset — 280+ feeds · 245B+ records · updated daily. Back to the full catalog →
Last updated

