• Home
• Customer Service
• FAQs
• Site Index
• Visit DPDB

• ABOUT THE DATA BANKS

  • NPDB
  • HIPDB
  • What's New
  • FAQs

• GENERAL INFORMATION

  • Registering
  • Billing and Fees
  • Disputing Reports
  • Querying & Reporting
  • Reporting Codes
  • Section 1921
  • Data Bank Outreach

• QUERYING & REPORTING

  • IQRS Features
  • Using the PDS Prototype
  • Using the QRXS
  • Using the ITP Interface
  • Sample Response Files
  • IQRS Subject Database
  • IQRS User Review Panel

• PUBLICATIONS

  • NPDB Guidebook
  • HIPDB Guidebook
  • Fact Sheets & Brochures
  • Newsletters

• LEGISLATION & POLICIES

  • Federal Register Notices
  • Legislation & Regulations
  • Privacy Policy

• STATISTICAL INFORMATION

  • Annual Reports
  • Public Use Data File
  • Data by Profession & State
• 

Integrated Querying and Reporting Service (IQRS) Subject Database Import Formats

Importing subjects into your IQRS subject database is an alternative to manually adding and maintaining subject database information. This feature provides users with an electronic interface within the IQRS to import large amounts of subject information from their corporate systems into their IQRS subject database for querying and reporting.

Subject information must be formatted in an American Standard Code for Information Interchange (ASCII) file which can then be imported into the IQRS. Subject information must be formatted in either the Extensible Markup Language (XML) Import Format or the Fixed-Width Import Format. XML is an industry standard for electronic data exchange. XML Import Format specifications and Fixed-Width Import Format specifications are provided below.

The Fixed-Width Import Format is the IQRS legacy import format used to add individual subjects to an IQRS subject database. The XML Import Format provides powerful and flexible features to import and maintain subject information in an IQRS subject database. The XML Import Format will enable users to automatically add, update, and delete both individual and organization subjects. The XML Import Format also provides a Subject ID data element which enables users to more easily track subjects during the import process.

Feature	XML Import Format	Fixed-Width Input Format
Add New Subjects	Yes	Yes
Update Existing Subjects	Yes	No
Delete Existing Subjects	Yes	No
Subject ID Support	Yes	No
Individual Subjects	Yes	Yes
Organization Subjects	Yes	No

New users are encouraged to contact the Customer Service Center if they have questions about using these specifications. Test import files may be e-mailed to the Customer Service Center for validation. The Data Banks will process your test file and return a result via e-mail.

XML Import Format Specifications

The XML Import Format Specifications are available through the File Specifications Access page. Users must first set up an account and log in with their given Vendor ID.

The XML Import Format is updated periodically by the Data Banks. It is strongly recommended that users join the IQRS Subject Database XML Import Mailing List to receive notice of updates. The Data Banks make an effort to notify users at least one month in advance of an update to code lists. Users should expect code lists to be updated quarterly. Additional updates to the XML Import Format are required periodically. Users will be notified six months in advance of updates to the XML Import Format.

Fixed-Width Import Format Specifications

The Fixed-Width Import Format Specifications are available through the File Specifications Access page. Users must first set up an account and log in with their given Vendor ID.

---