Physician/Supplier Procedure Summary Master File

Data Alert: A number of users have questioned the values found in the Error Indicator column of the Physician Supplier Procedure Summary (PSPS) 2010 file.  It was discovered in the source system that this column was always populated with a “4” during a period of approximately 6 months in 2011, when 2010 claims were still being processed.

This anomaly caused an increased number of records in the 2010 PSPS file based on how the file is aggregated.  However, the data in this file matches source system data, and columns other than the Error Indicator column can be used for analysis.

The Error Code column in the source system is used as referential integrity check, essentially to mark when a value that was on the claim was not in a database reference table.  The Error Code column does not have any bearing on whether a claim was paid, denied, etc.  We are recommending that this column be dropped from future PSPS releases as it does not appear to have any value from a business or analytical perspective.

File Description:

This file is a 100% summary of all Part B Carrier and DMERC Claims processed through the Common Working File and stored in the National Claims History Repository. The file is arrayed by carrier, pricing locality, Healthcare Common Procedure Coding (HCPC), modifier 1, modifier 2, specialty, type of service and place of service. The summarized fields are total submitted services and charges, total allowed services and charges, total denied services and charges, and total payment amounts. This file is produced annually and is usually available in July. This file is one CD.

Data Format: Text

Approximate Size: 206 MB 

Compatible Software Programs:  Microsoft Access, Microsoft SQL/DB2/Oracle, SAS or other statistical software. (Note: Microsoft Excel or TextPad cannot be used to analyze the PSPS file)

Media:  CD ROM
File Cost:  $250.00 per year
Available:  New format - 1991 through 2011

Note: New Format - this file has been modified to accommodate PC users. It has been divided into the following 24 segments:

HCPCS RANGE 00100-01999
HCPCS RANGE 10040-14999
HCPCS RANGE 15000-19499
HCPCS RANGE 20000-24999
HCPCS RANGE 25000-29999
HCPCS RANGE 30000-32999
HCPCS RANGE 33010-37799
HCPCS RANGE 38100-38999
HCPCS RANGE 39000-39599
HCPCS RANGE 40490-49999
HCPCS RANGE 50010-53899
HCPCS RANGE 54000-55899
HCPCS RANGE 56405-58999
HCPCS RANGE 59000-59899
HCPCS RANGE 60000-64999
HCPCS RANGE 65091-68899
HCPCS RANGE 69000-69990
HCPCS RANGE 70010-74999
HCPCS RANGE 75000-79999
HCPCS RANGE 80048-89399
HCPCS RANGE 90281-99199
HCPCS RANGE 99201-99499
HCPCS RANGE A0000-H9999
HCPCS RANGE J0000-Z9999: