Master Summary (PSPS) File in Microsoft Access Erin Mann, ResDAC - PowerPoint PPT Presentation

Opening the Physician Supplier Master Summary (PSPS) File in Microsoft Access Erin Mann, ResDAC Technical Advisor

Opening the PSPS File – Background  See also: ResDAC’s knowledgebase article on opening the PSPS file available at: http://www.resdac.org/resconnect 2

Opening the PSPS File – Background  Microsoft Excel or TextPad cannot be used to open the PSPS file – the file is too large.  Compatible software programs: ˗ Microsoft Access ˗ Microsoft SQL or Oracle ˗ SAS and other statistical software programs 3

Contents of PSPS Disc  Compressed Files labeled PSPS## ˗ This is the data ˗ The files are organized by HCPCS/CPT (procedure) codes ˗ For example, PSPS01 contains data on HCPCS ranges 00100 – 01999  Pkreader – software to extract compressed files  PSPS record layout  PUF Tips Document  ResDAC PSPS Help File  Provider Specialty Values 4

Overview of the Process  Load the disc  Copy the contents of the disc to your computer  Unzip the data file(s) of interest  Rename the file as a text document  Import the files into Access ˗ Import Text Wizard ˗ Import Specification 5