Exporting US compliance data

AD
DM

Use the US Compliance target subscription to export the raw data from various sources to use in federal and state transparency reporting.

This subscription gives you access to raw NPI, SLN, and DEA data elements. For example, you can use the subscription to report the NPI taxonomy codes (specialty codes) and the name, address and telephone attributes of an entity as tracked by NPI and required by the Sunshine Act. After the subscription runs and exports the data to your data warehouse, aggregate spend, or other data processing platform, you can match the raw data to the transactional data for reporting.

You can export the following compliance data using the US Compliance Target Subscription:

  • Health Care Professionals - NPI, DEA, Massachussetts (MA) CRI, and SLN data
  • Health Care Organizations - NPI, DEA, and CMS Teaching Hospital data

Compliance data can be viewed on US record profiles in the Transparency Reporting preview box. For details, see Viewing compliance data.

About the data

Veeva OpenData prepares the raw data files. Compliance data is stored on a separate server because of the high volume of raw data. Because it is not available in customer or OpenData master instances, the data is not accessible for Network search, reporting, or regular target subscriptions.

When you run a US Compliance subscription job, the US data in your Network instance is matched against the raw data. Files are generated for each source that you defined in the subscription settings.

There are two types of files created for each source:

  • Found files - Contains records that matched data in the raw source (for example, SLN_hcp_found.csv).

    Use this file for transparency reporting. Most of the column names are from the raw source file. Any columns that are not from the raw source will have column names that end in __v.

  • Not found files - Contains records where no data was found in the raw source (for example, SLN_hcp_not_found.csv).

    This file cannot be used for transparency reporting because it contains records that are missing compliance data. Records might be incomplete or incorrect so they're missing the fields that are used for matching the data.

Update frequency

Compliance data is updated weekly by Veeva OpenData.

Run a compliance subscription

The target subscription is preconfigured, so no setup is required. It will access the server containing the source data and will try to match it to the US data in your Network instance. Click Start Job to immediately run the subscription to export all source data, or choose specific source data to export for HCPs and HCOs.

  1. In the Admin console, click System Interfaces > US Compliance Target Subscription.

  2. In the Entity & Compliance Data Selection section, expand the HCP and HCO  lists and select the source data that you want to export.

    Note: New Network instances have all available compliance data for HCPs and HCOs selected by default.

    CMS Teaching Hospital data

    The CMS Teaching Hospital option for HCOs enables you to select available years.

    Select CMS Teaching Hospital to export data for all years or select individual years. If individual years are selected, the CMS Teaching Hospital option displays as partially selected.

    Tip: Selecting the CMS Teaching Hospital option also ensures that data for a new year is automatically exported when it becomes available.

  3. In the Job Trigger Configuration section, define the schedule for the job and any subsequent actions that will start when this job finishes.

    • Job Schedule - Run the subscription manually or on a scheduled basis. If you select Manual, the subscription only runs when you click Start Job.
    • Job Triggers - Trigger other actions to start after a job runs.

      Available triggers:

      • Send email - Specify users that should be notified for successful and unsuccessful outcomes. For example, send an email to users so they will know if a job fails so they can investigate, or when the job completes so they can retrieve the source files from the FTP server.
      • Start a job - Start a subsequent job when this job successfully completes.

      For more information, see Subscription job triggers.

  4. Save your changes.
  5. Click Start Job to run the subscription or wait until it runs at the next scheduled time.

Exported source files

After the subscription job runs, individual files containing each set of data will be exported in a compressed (.zip) file and placed on your Network FTP server in the following folder:

/outbound/US_Compliance_Target_Subscription

The following files will be exported to the server:

  • found files - Data was found in the raw source for the record.

  • not_found files - No data was found in the raw source for the record.

  • manifest.csv file - A system file that contains the record counts for each file.

The exported files will look similar to this example for MA CRI data:

Alternate keys

If your Network instance has alternate key type custom fields, they are exported when a record is exported in any of the various files. The alternate keys display in the file immediately after the Veeva Network ID (VID) column and before the compliance data.

Matching data in the source files

When the US Compliance target subscription runs, Network matches the US data in your Network instance with the data in the raw source file. Specific fields are used for matching data for each source. Some records are immediately excluded from the job.

Excluded records

Records are immediately excluded from the US Compliance job based on the values for the following fields:

  • Primary county (primary_country__v) – Any HCP or HCO record where the country is not the United States is excluded.
  • Record State - Any record (HCP, HCO, or license) where the state is Deleted or Invalid is excluded.

These records are not considered during the job and are not included in the exported files for any source.

Match criteria for data sources

For any records that are not immediately excluded based on primary country and record state, specific fields are used to match US records with the source data. If your US data matches the data in the raw source file, the record is added to the "found" file for that source. If data is not found in the raw source, the record is added to the "not found" file.

The fields that are used to match the data can be different depending on the entity owner of the record (either Veeva or local). To understand how records are matched for each source, review the following sections.