ADT Data Specification

CodyTong

Version: v1.2

Release Date: December 2, 2024

Introduction

This is the data specification for the information ControlCheck requires for ADT (Admission, Discharge, Transfer) ingestion to support diversion identification by tracking medication dispenses after patient discharge.

This document outlines the data specification, file transport, file requirements, and column definitions necessary for a compliant ADT data feed.

Data Extract

Customers are strongly encouraged to use the template Clarity Reporting query provided as the fastest path to a compliant data feed. The canned query can be found attached to this post below. Customers may opt to author their own query to extract the required data if the output meets the following data specification. The customer is solely responsible for any issues involving a custom query. If your hospital cannot meet the following data specification, please discuss this with your implementation specialist or contact help@bluesight.com.

KT-ADT-FEED_V1.2.docx

File Transport

ADT files can be uploaded via the ControlCheck user interface; however, delivery over SFTP is highly preferred. Most customers choose to transfer files once per day. File transfers are typically scheduled to occur after midnight and contain the previous day’s data. Data transfers should be scheduled after the Clarity ETL process has been completed.

Recommended file transfer times are from 0400-0600 to ensure:

1. Data has migrated to the appropriate servers.
2. Bluesight is able to process files in a timely manner prior to customer auditing.

Individual files should be generated per facility. Specific use cases may require including multiple facilities, which should be discussed with your implementation specialist.

File Requirements

• Files must be formatted with pipe delimiters and as .csv that conform 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_adt_date.csv
• Output column headers are case sensitive and must match the values specified below. The order of the columns can differ but should adhere to the specified schema for consistency.

https://www.rfc-editor.org/rfc/rfc4180

Data Requirements

The provided query includes all required fields and relationships:

Header	Clarity Table.Column Name	Data Type	Format	Description of Data Element
ENC_CSN	CLARITY_ADT.PAT_ENC_CSN_ID	VARCHAR	Alphanumeric	Encounter CSN ID, uniquely identifies the encounter.
PRIM_ENC_CSN_ID	HSP_ACCOUNT.PRIM_ENC_CSN_ID	VARCHAR	Alphanumeric	Primary Encounter CSN ID linked to the hospital account.
HAR	PAT_ENC_HSP.HSP_ACCOUNT_ID	VARCHAR	Alphanumeric	Hospital Account Record ID.
INT_PAT_ID	CLARITY_ADT.PAT_ID	VARCHAR	Alphanumeric	Internal Patient ID assigned by the hospital system.
EVENT_ID	CLARITY_ADT.EVENT_ID	VARCHAR	Alphanumeric	Unique identifier for the event.
PAT_BASE_CLS	CLARITY_ADT.BASE_PAT_CLASS_C	VARCHAR	Numeric Code	Patient Base Class Code.
PAT_CLASS_ID	CLARITY_ADT.PAT_CLASS_C	VARCHAR	Numeric Code	Patient Class Code ID.
PAT_CLASS	ZC_PAT_CLASS.NAME	VARCHAR	Text	Patient Class Name, descriptive text for class.
PAT_LVL_OF_CARE	CLARITY_ADT.PAT_LVL_OF_CARE_C	VARCHAR	Numeric Code or Text	Patient Level of Care.
EFF_TIME	CLARITY_ADT.EFFECTIVE_TIME	DATETIME	YYYY-MM-DD HH:MM:SS	Effective time of the event.
EVENT_TIME	CLARITY_ADT.EVENT_TIME	DATETIME	YYYY-MM-DD HH:MM:SS	Actual occurrence time of the event.
EVENT_TYPE_ID	CLARITY_ADT.EVENT_TYPE_C	VARCHAR	Numeric Code	Event Type ID, categorizes the event.
EVENT_NAME	ZC_EVENT_TYPE.NAME	VARCHAR	Text	Event Type Name, descriptive text for type.
EVENT_SUBTYPE_ID	CLARITY_ADT.EVENT_SUBTYPE_C	VARCHAR	Numeric Code	Event Subtype ID.
EVENT_SUBTYPE	ZC_EVENT_SUBTYPE.NAME	VARCHAR	Text	Event Subtype Name, descriptive text for subtype.
ORIGINAL_EVENT_ID	CLARITY_ADT.ORIGINAL_EVENT_ID	VARCHAR	Alphanumeric	Original Event ID for updates.
ROOM_ID	CLARITY_ADT.ROOM_ID	VARCHAR	Alphanumeric	Unique identifier for the room.
ROOM_NAME	CLARITY_ROM.ROOM_NAME	VARCHAR	Text	Room Name as described in the system.
BED_ID	CLARITY_ADT.BED_ID	VARCHAR	Alphanumeric	Unique identifier for the bed.
BED_NAME	CLARITY_BED.BED_LABEL	VARCHAR	Text	Bed Label, descriptive text for the bed.
XFER_EVENT_ID	CLARITY_ADT.XFER_EVENT_ID	VARCHAR	Alphanumeric	Transfer Event ID, if applicable.
XFER_IN_EVENT_ID	CLARITY_ADT.XFER_IN_EVENT_ID	VARCHAR	Alphanumeric	Transfer-In Event ID, if applicable.
DEPT_ID	CLARITY_ADT.DEPARTMENT_ID	VARCHAR	Alphanumeric	Department ID where the event occurred.
DEP_NAME	CLARITY_DEP.DEPARTMENT_NAME	VARCHAR	Text	Department Name, descriptive text for the department.