Daily validation

The daily validation csv file contains the data use to validate each day of the recording. Further details on the validation algorithm are described here.

When produced by the batch processing tool PALbatch, the data from multiple files are included in a single csv file.

Column headingDescription
Serial NumberDevice Serial Number
File CodeFile identifier set on recording setup
Download IdentifierFile identifier set on download of recording from the device
Day of WeekDay name (Mon-Sun)
DateDate in DD MMM YYYY format e.g. 17 May 2018
ValidPasses validation algorithm criteria (0 – Fail, 1 – Pass)
Inverted wear correctionAuto-correction for inverted wear applied (0 – No, 1 – Yes)
Alignment (%)Data quality index: device alignment orthogonal to the thigh axis
(100% – fully aligned, 50% – 45 degree angle offset)
Dominant Stepping Dice FaceThe dominant orientation (Orientation dice face 1-6) of the device with accelerations consistent with stepping
Dominant Sitting Dice FaceThe dominant orientation (Orientation dice face 1-6) of the device when adjacent to identified upright orientations 
Total Still TimeTotal time (in hours) spent in continuous stillness bouts greater than an hour
Duration Total duration of day in hours
>1h Still Upright TimeTotal time (in hours) the device spent in continuous stillness bouts greater than an hour in upright orientation (Orientation dice face 1)
>1h Still Upside Down TimeTotal time (in hours) the device spent in continuous stillness bouts greater than an hour in upside down orientation  (Orientation dice face 6)
>1h Still Back Lying TimeTotal time (in hours) the device spent in continuous stillness bouts greater than an hour in back lying orientation (Orientation dice face 2)
>1h Still Front Lying TimeTotal time (in hours) the device spent in continuous stillness bouts greater than an hour in front lying orientation (Orientation dice face 5)
>1h Still Left Lying TimeTotal time (in hours) the device spent in continuous stillness bouts greater than an hour in left lying orientation (Orientation dice face 4)  
>1h Still Right Lying TimeTotal time (in hours) the device spent in continuous stillness bouts greater than an hour in right lying orientation (Orientation dice face 3) 
Upright Num SteppingNumber of 15s epochs in the day with accelerations consistent with stepping in upright orientation (Orientation dice face 1) 
Upside Down Num SteppingNumber of 15s epochs in the day with accelerations consistent with stepping in upside down orientation (Orientation dice face 6) 
Back Num SteppingNumber of 15s epochs in the day with accelerations consistent with stepping in back lying orientation (Orientation dice face 2) 
Front Num SteppingNumber of 15s epochs in the day with accelerations consistent with stepping in front lying orientation (Orientation dice face 5)
Left Num SteppingNumber of 15s epochs in the day with accelerations consistent with stepping in left lying orientation (Orientation dice face 4) 
Right Num SteppingNumber of 15s epochs in the day with accelerations consistent with stepping in right lying orientation (Orientation dice face 3)  
Upright Stepping AbsSumDiffAbsolute sum of differences of 15s epoch accelerations consistent with stepping in upright orientation (Orientation dice face 1)  
Upside Down Stepping AbsSumDiffAbsolute sum of differences of 15s epoch accelerations consistent with stepping in upside down orientation (Orientation dice face 6)  
Back Stepping AbsSumDiffAbsolute sum of differences of 15s epoch accelerations consistent with stepping in back lying orientation (Orientation dice face 2)
Front Stepping AbsSumDiffAbsolute sum of differences of 15s epoch accelerations consistent with stepping in front lying orientation (Orientation dice face 5) 
Left Stepping AbsSumDiff  Absolute sum of differences of 15s epoch accelerations consistent with stepping in left lying orientation (Orientation dice face 4) 
Right Stepping AbsSumDiffAbsolute sum of differences of 15s epoch accelerations consistent with stepping in right lying orientation (Orientation dice face 3)  
Upright Num Adjacent To SteppingNumber of 15s epochs adjacent to identified stepping orientation for the day in upright orientation (Orientation dice face 1) 
Upside Down Num Adjacent To SteppingNumber of 15s epochs adjacent to identified stepping orientation for the day in upside down orientation (Orientation dice face 6) 
Back Num Adjacent To SteppingNumber of 15s epochs adjacent to identified stepping orientation for the day in back lying orientation (Orientation dice face 2) 
Front Num Adjacent To SteppingNumber of 15s epochs adjacent to identified stepping orientation for the day in front lying orientation (Orientation dice face 5) 
Left Num Adjacent To SteppingNumber of 15s epochs adjacent to identified stepping orientation for the day in left lying orientation (Orientation dice face 4)  
Right Num Adjacent To SteppingNumber of 15s epochs adjacent to identified stepping orientation for the day in right lying orientation (Orientation dice face 3)
Upright Time(h)Total time device spent in upright orientation (Orientation dice face 1)
Upside Down Time(h) Total time device spent in upside down orientation (Orientation dice face 6) 
Back Lying Time(h)Total time device spent in back lying orientation (Orientation dice face 2) 
Front Lying Time(h)Total time device spent in front lying orientation (Orientation dice face 5) 
Left Lying Time(h)Total time device spent in left lying orientation (Orientation dice face 4) 
Right Lying Time(h)Total time device spent in right lying orientation (Orientation dice face 3)
Upright AbsSumDiffTotal absolute sum of differences of acceleration signal in upright orientation (Orientation dice face 1)
Upside Down AbsSumDiffTotal absolute sum of differences of acceleration signal in upside down orientation (Orientation dice face 6) 
Back AbsSumDiffTotal absolute sum of differences of acceleration signal in back lying orientation (Orientation dice face 2)
Front AbsSumDiffTotal absolute sum of differences of acceleration signal in back lying orientation (Orientation dice face 5)
Left AbsSumDiffTotal absolute sum of differences of acceleration signal in left lying orientation (Orientation dice face 4)
Right AbsSumDiffTotal absolute sum of differences of acceleration signal in right lying orientation (Orientation dice face 3)
X Average Stepping AccelAverage x acceleration value when in identified stepping orientation
Y Average Stepping AccelAverage y acceleration value when in identified stepping orientation
Z Average Stepping AccelAverage z acceleration value when in identified stepping orientation

Related Articles