FORMATS

library(oncmap)

All timestamps are assumed in the patient’s timezone and then internally encoded as UTC to avoid inconsistencies with operator settings.

ECAP OLD

  • Device ID column “Package ID”
  • No defined headers
  • Patient ID column “Subject ID”
  • Datetime column “Dose Timestamp”,
  • Datetime format “%Y-%m-%dT%H:%M:%S”, # “YYYY-MM-DDTHH:MM:SS-TZ”,

ECAP1

The same as ECAP OLD: * Datetime column and format

Different from ECAP OLD: * Patient ID column “Patient ID”, * Device ID column “ECM ID”, * Header line “Index,Patient ID,ECM ID,Dose #,Dose Timestamp,Dose Timestamp UTC,Dose Group,Dose Label”,

ECAP2

The same as ECAP1: * Datetime column

Different from ECAP1: * Datetime format changed – month is now 3 letter abbreviation i.e. ‘2022-May-10T07:28:49-04:00’ * Device ID column “Package ID”, * Header line “Patient,Project,Package ID,Regimen ID,Package Label,Patient Dose Index,Dose Date,Dose Timestamp,Dose Timestamp UTC,Dose Group,Dose Label,Adherent”, * Patient ID column “Patient”,

ECAP2XLS

The same as ECAP2 except * Datetime format changed back to ECAP1 – month is 2 digits i.e. ‘2022-05-10T07:28:49-04:00’ * Header line “Package Index,Study ID,Site ID,Subject ID,Kit ID,Package ID,Dose Regimen,Dose Index,Dose Date,Dose Timestamp,Dose Timestamp UTC,Dose Group,Dose Label,Compliant”, * Patient ID columnt “Study ID”,

ECAP3

The same as ECAP2 except * Header line “Patient,Project,Package ID,Regimen ID,Config Label,Patient Dose Index,Dose Timestamp,Dose Timestamp UTC,Medications,Dose Group,Dose Label,Adherent,Type,eDiary Status,Original Timestamp,reason”,

datetime_format = "%Y-%m-%dT%H:%M:%S%z", # "YYYY-MMM-DDTHH:MM:SS-TZ",

MEMS

  • Skip first line – contains who exported and when
  • Datetime column “Date”
  • Device ID column “Identification number”,
  • headers = “Date,IntakeStatusDisplayResource,Indication / pathology,Identification number,Label,CavityLabel,IntakeChangeReasons,”,
  • Datetime format “%m/%d/%Y %I:%M:%S %p”, # “m/d/yyyy hh:mm:ss am”,

MEMS2

Based on MEMS except: * headers changed (added Comment column) to “Date,IntakeStatusDisplayResource,Indication / pathology,Identification number,Label,CavityLabel,Comment,IntakeChangeReasons”, * Datetime format changed “%m/%d/%Y %H:%M”, # “m/d/yyyy hh:mm”, * Accept lines where “IntakeStatusDisplayResource!=Missing day”

SIMPLEMED

  • First line has patient id “Patient: \(ID: ([^)])\).”,
  • Device ID header = “Device SN”,
  • Headers line “,Event ID,Device SN,Event Type,Details,Create Time,is Rpm event”,
  • Datetime column “Create Time”,
  • Datetime format “%m/%d/%Y, %I:%M:%S %p”, # “m/d/yyyy, hh:mm:ss am”,
  • Accept lines where “Event Type==Pill was taken”,

ADHERETECH

  • Device ID column “Device_UID”,
  • Headers line “Patient_UID,Device_UID,Site,Medication,Reminder_Sent,Status,Deadline_UTC,Dose_Date_UTC,Time_Recorded_UTC,Patient_Timezone,Deadline_Patient_Timezone,Dose_Date_Patient_Timezone,Time_Recorded_Patient_Timezone”,
  • Patient ID column “Patient_UID”,
  • Datetime column “Time_Recorded_Patient_Timezone”,
  • Datetime format “%m/%d/%Y %H:%M”, # “m/d/yyyy hh:mm”,
  • Accept lines where “Status!=MISSED”,