Kronos Data Specification

Options

Introduction

This is the data specification for the information ControlCheck (formally known as Bluesight for Controlled Substances) requires to process Kronos Time and Attendance files for the Shift Analysis with Timecards metric. Currently, customers must author their own query to pull the required data.

ControlCheck will ingest the Kronos file and match the unique provider identifiers with identifiers ControlCheck has already received in other source files (EMR/ADC files). This allows the system to associate shift information with controlled substance activity in the hospital. If your hospital cannot meet the following data specification, please contact your Account Manager.

File Transport

Kronos files can be uploaded via the ControlCheck user interface, however, delivery over SFTP is highly preferred. File transfers should occur after the pay period ends and time adjustments have been made. This is usually every two weeks or once per month.

File Requirements

  • Files must be formatted as .csv that conform to RFC 4180 https://www.rfc-editor.org/rfc/rfc4180 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_hospitalname_kronos_date.csv
  • Output column headers are case-sensitive and must match the values specified below. The order in which those columns appear can be different than the order listed below. However, it is highly recommended that customers follow the order below for consistency and readability.

Data Fields