NADAC Pricing File Download and Load Process

• NADAC (National Average Drug Acquisition Cost) is a US government-provided pricing file. The data is available in https://data.medicaid.gov/ and is updated weekly.
• NADAC pricing data is stored similarly to the Basis of cost pricing data, meaning it is maintained at the PBM level. If your instance includes multiple PBMs, you must perform the required setup for file download and load process for each PBM individually.
• To use NADAC pricing in the Ingredient Cost Rule, create a Basis of Cost Registration with the code NADAC.
• 'NADAC' is the default basis of cost code that is added when loading the pricing data into the system.

How to set up NADAC Pricing Load Job 

This is a one time process. Creating the NADAC pricing load job is similar to creating a Basis of Cost pricing load process.

1. Navigate to Administration -> Data Management.
2. Click on Add icon. 
3. Select the job type as Basis of Cost and then click Next button
   
   
   
   
   
4. In the job configuration, enter the following

• Job Name
• Effective dates
• Job Criteria: Select Load
• Basis of Cost Load Job format : Select NADAC (✅ Important step!)
• Run Time Settings: Schedule this job to run after the file download job, this will ensure that the NADAC pricing file is available to load (✅ Important )
• Email: Add the email address of the users who you want to notify about the Job success or failure notification.
  
  
  

        5. Click Save and Activate the job configuration.

        6. After activation, note the registration code of the job. You will need this code when creating NADAC pricing file download job configuration

⚠️ Note: 

We have separate NADAC pricing file download job that automatically downloads the file. It is critical to provide the correct registration code from this load job in the download job configuration, so the the file is placed in the correct S3 path for the file load process

In case of any interruption or failure in automated download, you can manually download the file from https://data.medicaid.gov/. Place the downloaded file in the S3 input file path and run the NADAC pricing load job to load the data into the system.

Additionally, when beginning to use NADAC pricing, you might need to load historical data (e.g., 2023 and 2024). In that case, you can manually download the full file, place it in the correct S3 path, and run the NADAC pricing load job manually. This load job supports both full files and filtered (recent) data.

• 📌 Just like any other data management job, this job runs as per defined schedule. Job success or failure notification will be sent to the users configured in the job.

• 📊 You can view job execution stats via View Job Execution Details, which includes:

  • Total Count

  • Success Count

  • Failure Count

                 If there are any failures, the notification email will include the Error file path, which provides details about the failure.

How to set up NADAC Pricing File Download Job 

Follow the steps below to configure the job that automatically downloads the NADAC pricing CSV file and places in the appropriate S3 folder for the loading process.

🔁 Note: This job configuration needs to be updated or setup annually because the UUID used in the download process changes every year.

1. Navigate to Administration -> Data Management 
2. Click on the Add icon
   
   
   
   
   
3. Select the job type as NADAC File Download. Then click on Next
   
   
   
   

4. Fill in the Job Configuration details.

   • Job Name - Enter your preferred name to easily identify the job as file download job.
   • Effective Dates - Set the Effective End date to the end of the current calendar year.
     • ✅ This is important because the UUID sent in the file download API request changes annually.
     • You must update the UUID annually either by editing the existing job or creating a new one.
   • Job Criteria - Select Other
   • BOC Load Registration Code:
     • Enter the registration code from the previously created NADAC pricing load job.
     • ✅ This ensures that the downloaded pricing file will be placed in the correct location for the load job to process.
   • Download UUID -

     • This is the unique identifier sent in the API request to download the NADAC pricing csv file.

     • ✅ This UUID changes every year, so you must update it annually in the job configuration.
   • Run Time Settings: 
     • Schedule this job to run before the NADAC pricing load job, this will ensure that the NADAC pricing file is available to load.
   • Email: Add the email address of the users who you want to notify about the Job success or failure notification.
     

        5. Click Save and Activate the job configuration.

How to Get the UUID for NADAC file download job

To download the correct NADAC file, you need the UUID (unique identifier) for the year you are scheduling the job. Follow these steps to locate it:

• Navigate to CMS Data Explorer

• Locate the dataset for the year you want to schedule the download job.

• Click on the API link for that dataset.

• Copy the UUID (highlighted) from the URL.
• Paste this UUID into the Download UUID field in the NADAC File Download Job Configuration
  
  

How to download the NADAC pricing file manually

If the automated file download is interrupted or fails for any reason, you can manually download the NADAC pricing file:

1. Visit: https://data.medicaid.gov/
2. Navigate to the dataset, Search for the relevant NADAC CSV dataset for the intended year.
3. To get the most recent data, use the column filter 'As of Date' greater than <your last downloaded date>
    
   
   
   
4. Download the file and place it in the appropriate S3 path. The S3 file path can be referred in the NADAC Pricing load job configuration 
   
   

Alternatively, use the API to download the CSV file. It is important to get the most recent data (Using As of Date filter). Avoid loading full (unfiltered) data unless required, as it takes longer to process.

⚠️ Note: 

• Procella system expects the input file in Comma separated TXT file. So CSV file has to be modified and renamed accordingly.
• Expected File naming format <PBMCODE>_PRICELOAD_<BASIS_OF_COST_CODE>_<DATE>_SORTED.txt   
  For eg., ACMEPBM_PRICELOAD_NADAC_20250529_SORTED.txt
• If you receive Error code - GROUP_PATTERN_MATCH_FAILURE in the email, after upload the file. Then it means either the file type or file name does not match the expected pattern. Recheck the file format and name, fix and reupload to process the file.

How to download the NADAC FULL file (Historical data) manually

Downloading the full file may be required when you want to load the historical data.

1. Visit: https://data.medicaid.gov/
2. Navigate to the NADAC dataset 
3. Click on the year for which you want to get the full file.
   
   
   
   
4. Click on the Download Full Dataset(CSV) option to download the full file
   
   
   
   
   
5. Place this full file in the input S3 file path of the NADAC pricing load job to load the data into the sytem.

Points to Note when downloading the file manually

• Ensure to follow correct file format and file name when placing the file manually for data load.
• File should be text file. (The downloaded CSV file has to be modified to comma delimited text file)
• File name should be in this format
  • <PBMCODE>_PRICELOAD_<BASIS_OF_COST_CODE>_<DATE>_SORTED.txt   
    For eg., ACMEPBM_PRICELOAD_NADAC_20250529_SORTED.txt
• If you receive Error code - GROUP_PATTERN_MATCH_FAILURE in the email, after upload the file. Then it means either the file type or file name does not match the expected pattern. Recheck the file format and name, fix and reupload to process the file.