Acudose Data Specification

Options
Leslie James
Leslie James Posts: 323 admin

Version: 1

Release Date: April 6, 2023

Introduction

This is the data specification for the information ControlCheck (formally known as Bluesight for Controlled Substances) requires for dispensing data coming from Acudose systems. ControlCheck ingests Administration data from the hospital's EMR and dispensing data from the hospital’s automated dispensing cabinets. ControlCheck then compares the two sets of data to ensure that all dispenses of controlled substances have a corresponding administration for an equal amount.

ControlCheck officially supports BD Pyxis and Omnicell, for which individual data specifications exist. The data specification below is provided so hospitals can create ControlCheck-compatible data loads for their Acudose dispensing data. If your hospital cannot meet the following data specification, please discuss this with your implementation specialist or contact help@kitcheck.com.


💡 Note: Acudose is considered a not-supported or limited-supported source system. ControlCheck’s ability to troubleshoot unsupported ADC data loads is limited, and we offer no guarantee that ControlCheck will work as intended using data from said ADC now or in the future.

File Transport

Acudose files can be uploaded via the ControlCheck user interface. However, delivery over SFTP is highly preferred. File transfers should occur once daily, in the middle of the night, containing Dispensing data from the previous day. Data dumps should be scheduled after any ETL process has been completed, which may cause delays for when events are available for reconciliation in the ControlCheck platform.

Recommended file transfer times are from 0400-0600 to ensure 1) data has migrated to the appropriate servers and 2) that Bluesight is able to process files in a timely manner prior to customer auditing. Additionally, it is recommended that the ADC file(s) can be sent at least 30 minutes after the EMR file for optimized processing and data ingestion.

Individual files should be generated per facility, although certain use cases would require including multiple facilities. Discuss with your implementation specialist before finalizing hospital groupings.

File Requirements

  • Files must be formatted as .csv that conforms to RFC 4180 and utilize UTF-8 for character encoding
  • File size should not exceed 50 mb
  • The file name should follow the schema and can only contain letters, numbers, and underscores.
    • bluesight_IDNname_hospitalname_Acudose_dispensedate.csv
  • Output column headers must match the values specified below. The order in which those columns appear differs from the order listed below. However, it is highly recommended that customers follow the order below for consistency and readability.

Pre-Implementation & Data Validation File

During implementation, your implementation specialist will request a historical extract of data. This is a one-time request that will be manually uploaded into the application. The historical file upload would not depend on the SFTP being fully set up. Potentially some requirements may be different during testing/validation, such as file size, naming, and date range.

Data Fields

Output Column Name

Required

Data Type

Formatting

Description

Event_Name

Y

String

N/A

The transaction type that occurred on the ADC (dispense, waste, override, etc.).

Alias_Id

Y

String

N/A

The unique drug identifier of the medication.

Full_Site_Drug_Desc

Y

Varchar

Molecule(s), Concentration, Form Factor

Drug name for the drug that was dispensed. Should include molecule(s), concentration, and form factor.

Trans_Qty

Y

Numeric

N/A

The amount of drug dispensed or wasted.

User_Name

Y

String

“Last Name, First Name” (includes quotes)

Name of the provider that dispensed the medication.

Role

Y

String

N/A

Role of the provider that dispensed the medication.

Site_User_Id

Y

String

N/A

System login ID of the provider that dispensed the medication.

Event_Dttm

Y

DateTime

ISO 8601 calendar dates and times with time zone designators; MM-DD-YYYY hh:mm:ss

Time the medication was dispensed.

Station_Id

Y

String

N/A

The name or location of the cabinet the transaction occurred on.

Displayed_Pocket_Num

Y

String

N/A

The pocket name or number the medication was dispensed from.

Site_Patient_Id

Y

Numeric

N/A

Unique ID of that patient encounter/visit number associated with the dispense (i.e. financial information number).

MRN

Y

Numeric

N/A

Unique Medical Record Number patient identifier for the patient receiving the medication.

Order_Number

Y

Numeric

N/A

The unique ID for the order associated with the dispense.

Pat_Name

Y

String

“Last Name, First Name” (includes quotes)

Name of the patient receiving the medication.

Witness_Name

Y

String

“Last Name, First Name” (includes quotes)

Name of the provider that witnessed the waste.

Witness_Site_User_ID

Y

String

N/A

System login ID of the provider that witnessed the waste.

NarcVault File

File requirements for the NarcVault are slightly different from the above Accudose requirements.

Data Fields

Output Column Name

Required

Data Type

Formatting

Description

Event_Name

Y

String

N/A

The transaction type that occurred on the ADC (dispense, waste, override, etc.).

Full_Site_Drug_Desc

Y

Varchar

Molecule(s), Concentration, Form Factor

Drug name for the drug that was dispensed. Should include molecule(s), concentration, and form factor.

Trans_Qty

Y

Numeric

N/A

The amount of drug dispensed or wasted.

User_Name

Y

String

“Last Name, First Name” (includes quotes)

Name of the provider that dispensed the medication.

User Card #

Y

String

N/A

System login ID of the provider that dispensed the medication.

Event_Dttm

Y

DateTime

ISO 8601 calendar dates and times with time zone designators; MM-DD-YYYY hh:mm:ss

Time the medication was dispensed.

Station_Id

Y

String

N/A

The name or location of the cabinet the transaction occurred on.

Displayed_Pocket_Num

Y

String

N/A

The pocket name or number the medication was dispensed from.

Site_Patient_Id

Y

Numeric

N/A

Unique ID of that patient encounter/visit number associated with the dispense (i.e. financial information number).

Pat_Name

Y

String

“Last Name, First Name” (includes quotes)

Name of the patient receiving the medication.

Witness_Name

Y

String

“Last Name, First Name” (includes quotes)

Name of the provider that witnessed the waste.