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

Sep 21, 2023 213 likes •271 views

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