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

master summary psps file in
SMART_READER_LITE
LIVE PREVIEW

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: ResDACs knowledgebase article on opening the PSPS file available at:


slide-1
SLIDE 1

Opening the Physician Supplier Master Summary (PSPS) File in Microsoft Access

Erin Mann, ResDAC Technical Advisor

slide-2
SLIDE 2

Opening the PSPS File – Background

  • See also: ResDAC’s knowledgebase article on
  • pening the PSPS file available at:

http://www.resdac.org/resconnect

2

slide-3
SLIDE 3

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

slide-4
SLIDE 4

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

slide-5
SLIDE 5

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