AU Synthetic Data Set Validation

The Antimicrobial Use Synthetic Data Set (AU SDS) is test data that NHSN AU Option implementers can use to validate their AU data aggregation methods comply with the NHSN AU Option protocol’s requirements.

The AU SDS is intended for use in testing antimicrobial day numerator and days present denominator data aggregation, not conformance to AU CDA file structure.

Synthetic Data Set

To use the data set, the AU SDS should be loaded into the implementer’s database, processed just as they would their own real data, and uploaded to a CDC hosted web application for validation. The web application will return the validation results, which will consist of descriptive error feedback on incorrect rows.

The test data are provided in both CSV and MySQL formats.

Detailed instructions, the AU SDS, database schema, and other helpful documents are available in the zip file below.

Current version: AU SDS production version 4.4 released April 2021

Process for using the Synthetic Data Set

The SDS validation process is completed outside of NHSN. The vendor will download the AU synthetic data set and process it through their vendor system to appropriately aggregate the data. The results should be output to an Excel file. The vendor will then upload that file into the NHSN AU Data web service tool to validate the aggregated AU data against the answer key. The vendor should continue to upload and retest Excel files until no errors are present after submission to the web service. Once the vendor’s Excel file passes through the web service with no errors, the file can be sent to NHSN as outlined below.

NHSN Confirmation of Successful AU SDS Validation

Beginning in January 2020, vendors may send the NHSN Team the passing SDS Excel file in order to receive confirmation of successful AU SDS validation. Once ready for the NHSN Team to confirm that an AU Summary SDS Excel file has passed AU SDS Validation, send the following to

  • AU Summary SDS Excel file
  • Vendor (Application) OID (instructions for obtaining OID)
  • Vendor Name
  • Vendor Software Name
  • Vendor Software Version
  • Technical Point of Contact (one primary person but you may cc others on file submission)
  • SDS Validation Web Service URL used for testing
  • Vendor Website (optional)

If any of the information above is missing, the NHSN Team will not process your request.

Upon receipt of the above items, the NHSN Team will test the SDS Excel file to confirm it passes AU SDS Validation.

If the file passes, an email will be sent to the vendor containing the SDS Validation ID to be added by the vendor to the author section of their production AU CDA files. Additionally, the vendor name, software name and software version will be published to a public-facing NHSN webpage to highlight successful AU SDS validation. Further, if the Vendor Website is provided, it will be included as a hyperlink attached to the Vendor Name on the passing vendors table.

If the file fails, an email will be sent to the vendor indicating that the file failed and next steps will be provided.

AU CDA Author Section

A vendor that has passed AU SDS Validation will include vendor information in the author section of all production AU CDA files. Below is an example of the XML coding of the author field.

An example of the XML coding of the author field for AU CDA files

The ID root value must contain the Vendor (Application) OID. The extension value must contain the SDS Validation ID. Vendor name, vendor software name, software version and release are currently optional fields, but having this information will streamline the troubleshooting of issues.