aptnum | patnum | aptstatus | pattern | confirmed | trial_timelocked_6 | op | trial_note_8 | provnum | provhyg | aptdatetime | nextaptnum | unschedstatus | trial_isnewpatient_14 | procdescript | assistant | clinicnum | ishygiene | trial_datetstamp_19 | datetimearrived | datetimeseated | datetimedismissed | insplan1 | insplan2 | datetimeaskedtoarrive | trial_procscolored_26 | trial_coloroverride_27 | appointmenttypenum | secusernumentry | secdatetentry | priority | provbartext | trial_patternsecondary_33 | trial_securityhash_34 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4 | 20 | 1 | * TRIAL | 19 | 1 | 2 | 3 | 0 | 2023-07-13T09:00:00.000Z | 0 | 0 | 1 | * TRIA | 0 | 0 | 0 | 2023-07-13T11:48:28.000Z | 0001-01-01T00:00:00.000Z | 0001-01-01T00:00:00.000Z | 0001-01-01T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | Exception | ||||
| 3 | 21 | 2 | //XXXXXX// | 19 | 1 | 6 | 3 | 4 | 2023-07-13T09:00:00.000Z | 0 | 0 | 1 | Ex | 0 | 0 | 1 | 2023-07-13T11:48:28.000Z | 0001-01-01T00:00:00.000Z | 0001-01-01T00:00:00.000Z | 0001-01-01T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | Exception | ||||
| 6 | 15 | 2 | //XXXXXX//// | 19 | 1 | 5 | 1 | 2 | 2023-06-12T09:00:00.000Z | 0 | 0 | 1 | Flo, Ex, Pro | 0 | 0 | 1 | 2023-07-13T11:48:28.000Z | 2023-06-12T00:00:00.000Z | 2023-06-12T00:00:00.000Z | 2023-06-12T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | Exception | ||||
| 7 | 15 | 6 | //XXXX// | 19 | 1 | 0 | 1 | 0 | 2023-07-13T00:00:00.000Z | 0 | 0 | 0 | Ext, Ext | 0 | 0 | 0 | 2023-07-13T11:48:28.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | * TRIAL * | ||||
| 8 | 15 | 6 | //XXXX// | 19 | 1 | 0 | 1 | 0 | 2023-07-13T00:00:00.000Z | 0 | 0 | 0 | Ext, Ext | 0 | 0 | 0 | 2023-07-13T11:48:28.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | Exception | ||||
| 9 | 15 | 6 | * TRIA | 19 | 1 | 0 | 1 | 0 | 2023-07-13T00:00:00.000Z | 0 | 0 | 0 | * TRI | 0 | 0 | 0 | 2023-07-13T11:48:28.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | * TRIAL * | ||||
| 10 | 16 | 2 | * TRIAL * TR | 19 | 1 | 5 | 1 | 2 | 2023-06-12T10:00:00.000Z | 0 | 0 | 1 | Flo, Ex, 4-BWX, Pro | 0 | 0 | 1 | 2023-07-13T11:48:28.000Z | 0001-01-01T00:00:00.000Z | 0001-01-01T00:00:00.000Z | 0001-01-01T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | * TRIAL * | ||||
| 11 | 17 | 2 | * TRIA | 19 | 1 | 5 | 1 | 2 | 2023-06-12T11:00:00.000Z | 0 | 0 | 1 | FloChld, Ex, ProCld | 0 | 0 | 1 | 2023-07-13T11:48:28.000Z | 2023-06-12T00:00:00.000Z | 2023-06-12T00:00:00.000Z | 2023-06-12T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | Exception | ||||
| 12 | 18 | 2 | //XX// | 19 | 1 | 5 | 1 | 2 | 2023-06-12T11:30:00.000Z | 0 | 0 | 1 | * | 0 | 0 | 1 | 2023-07-13T11:48:28.000Z | 2023-06-12T00:00:00.000Z | 2023-06-12T00:00:00.000Z | 2023-06-12T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | Exception | ||||
| 13 | 16 | 6 | * TRIA | 19 | 1 | 0 | 1 | 0 | 2023-07-13T00:00:00.000Z | 0 | 0 | 0 | C1(P) | 0 | 0 | 0 | 2023-07-13T11:48:28.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | Exception | ||||
| 14 | 15 | 1 | * TRIAL | 19 | 1 | 1 | 1 | 0 | 2023-07-13T08:00:00.000Z | 7 | 0 | 0 | Ext, Ext | 0 | 0 | 0 | 2023-07-13T11:48:28.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | * TRIAL * | ||||
| 15 | 16 | 1 | //XX// | 19 | 1 | 1 | 1 | 0 | 2023-07-13T09:00:00.000Z | 13 | 0 | 0 | C1(P) | 0 | 0 | 0 | 2023-07-13T11:48:28.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | Exception | ||||
| 16 | 17 | 6 | * TRIAL | 19 | 1 | 0 | 1 | 0 | 2023-07-13T00:00:00.000Z | 0 | 0 | 0 | Seal, Seal | 0 | 0 | 0 | 2023-07-13T11:48:28.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | * TRIAL * | ||||
| 17 | 17 | 6 | * TRIAL | 19 | 1 | 0 | 1 | 0 | 2023-07-13T00:00:00.000Z | 0 | 0 | 0 | * TRIAL * | 0 | 0 | 0 | 2023-07-13T11:48:28.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | Exception | ||||
| 18 | 17 | 1 | * TRIAL | 19 | 1 | 3 | 1 | 0 | 2023-07-13T08:30:00.000Z | 16 | 0 | 0 | Seal, Seal | 0 | 0 | 0 | 2023-07-13T11:48:28.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | Exception | ||||
| 44 | 21 | 6 | * TRIAL * TRIA | 19 | 1 | 0 | 3 | 0 | 2023-07-13T00:00:00.000Z | 0 | 0 | 0 | Ext, Ext, Ext, Ext, Ext | 0 | 0 | 0 | 2023-07-13T11:48:28.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | Exception | ||||
| 19 | 11 | 2 | //XXXXXX// | 19 | 1 | 1 | 1 | 0 | 2023-06-12T08:00:00.000Z | 0 | 0 | 1 | Ex, PA, Ext | 0 | 0 | 0 | 2023-07-13T11:48:28.000Z | 2023-06-12T00:00:00.000Z | 2023-06-12T00:00:00.000Z | 2023-06-12T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | Exception | ||||
| 21 | 11 | 6 | * TRIAL * TRIAL * TRIAL | 19 | 1 | 0 | 1 | 0 | 2023-07-13T00:00:00.000Z | 0 | 0 | 0 | RetPFM, PontPFM, RetPFM | 0 | 0 | 0 | 2023-07-13T11:48:28.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | Exception | ||||
| 22 | 11 | 1 | //XXXXXX//////////////// | 19 | 1 | 1 | 1 | 0 | 2023-07-13T09:40:00.000Z | 21 | 0 | 0 | RetPFM, PontPFM, RetPFM | 0 | 0 | 0 | 2023-07-13T11:48:28.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | Exception | ||||
| 23 | 12 | 2 | * TRIAL * TR | 19 | 1 | 5 | 1 | 2 | 2023-06-12T13:00:00.000Z | 0 | 0 | 1 | * TRIAL * TR | 0 | 0 | 1 | 2023-07-13T11:48:28.000Z | 0001-01-01T00:00:00.000Z | 0001-01-01T00:00:00.000Z | 0001-01-01T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | * TRIAL * | ||||
| 24 | 13 | 2 | //XXXXXX//// | 19 | 1 | 5 | 1 | 2 | 2023-06-12T14:00:00.000Z | 0 | 0 | 1 | Flo, Ex, Pro | 0 | 0 | 1 | 2023-07-13T11:48:28.000Z | 0001-01-01T00:00:00.000Z | 0001-01-01T00:00:00.000Z | 0001-01-01T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | * TRIAL * | ||||
| 25 | 13 | 6 | //XXXX// | 19 | 1 | 0 | 1 | 0 | 2023-07-13T00:00:00.000Z | 0 | 0 | 0 | * TRIAL | 0 | 0 | 0 | 2023-07-13T11:48:28.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | Exception | ||||
| 26 | 13 | 6 | * TRIA | 19 | 1 | 0 | 1 | 0 | 2023-07-13T00:00:00.000Z | 0 | 0 | 0 | C2(P) | 0 | 0 | 0 | 2023-07-13T11:48:28.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | * TRIAL * | ||||
| 27 | 13 | 1 | //XXXX// | 19 | 1 | 1 | 1 | 0 | 2023-07-13T13:00:00.000Z | 25 | 0 | 0 | Ext, Ext | 0 | 0 | 0 | 2023-07-13T11:48:28.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | * TRIAL * | ||||
| 29 | 9 | 6 | * TRIAL | 19 | 1 | 0 | 3 | 0 | 2023-07-13T00:00:00.000Z | 0 | 0 | 0 | * TRIAL | 0 | 0 | 0 | 2023-07-13T11:48:28.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | Exception | ||||
| 30 | 9 | 6 | //XXXXXX// | 19 | 1 | 0 | 3 | 0 | 2023-07-13T00:00:00.000Z | 0 | 0 | 0 | * TRIAL * TRI | 0 | 0 | 0 | 2023-07-13T11:48:28.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | * TRIAL * | ||||
| 31 | 9 | 6 | //XXXXXX// | 19 | 1 | 0 | 3 | 0 | 2023-07-13T00:00:00.000Z | 0 | 0 | 0 | RetPFM, PontPFM, RetPFM | 0 | 0 | 0 | 2023-07-13T11:48:28.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | Exception | ||||
| 33 | 9 | 6 | //XX// | 19 | 1 | 0 | 3 | 0 | 2023-07-13T00:00:00.000Z | 0 | 0 | 0 | BridgeSeat | 0 | 0 | 0 | 2023-07-13T11:48:28.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | Exception | ||||
| 34 | 9 | 2 | * TRIAL | 19 | 1 | 2 | 3 | 0 | 2023-06-12T09:00:00.000Z | 29 | 0 | 0 | Ext, Ext | 0 | 0 | 0 | 2023-07-13T11:48:28.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | Exception | ||||
| 35 | 9 | 2 | //XXXXXX// | 19 | 1 | 2 | 3 | 0 | 2023-06-14T09:00:00.000Z | 30 | 0 | 0 | * TRIAL * TRI | 0 | 0 | 0 | 2023-07-13T11:48:28.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | Exception | ||||
| 36 | 9 | 1 | * TRIAL * TRIAL * TRIAL * TRIAL * TR | 19 | 1 | 2 | 3 | 0 | 2023-07-13T10:00:00.000Z | 31 | 0 | 0 | * TRIAL * TRIAL * TRIAL | 0 | 0 | 0 | 2023-07-13T11:48:28.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | Exception | ||||
| 37 | 10 | 2 | //XX// | 19 | 1 | 1 | 1 | 0 | 2023-06-12T09:10:00.000Z | 0 | 0 | 0 | Ext | 0 | 0 | 0 | 2023-07-13T11:48:28.000Z | 0001-01-01T00:00:00.000Z | 0001-01-01T00:00:00.000Z | 0001-01-01T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | Exception | ||||
| 38 | 10 | 6 | * TRIA | 19 | 1 | 0 | 1 | 0 | 2023-07-13T00:00:00.000Z | 0 | 0 | 0 | * TRI | 0 | 0 | 0 | 2023-07-13T11:48:28.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | Exception | ||||
| 39 | 10 | 1 | //XX// | 19 | 1 | 1 | 1 | 0 | 2023-07-13T14:00:00.000Z | 38 | 0 | 0 | * TRI | 0 | 0 | 0 | 2023-07-13T11:48:28.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | * TRIAL * | ||||
| 40 | 14 | 6 | //XX// | 19 | 1 | 0 | 1 | 0 | 2023-07-13T00:00:00.000Z | 0 | 0 | 0 | A1 | 0 | 0 | 0 | 2023-07-13T11:48:28.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | Exception | ||||
| 41 | 14 | 1 | //XX// | 19 | 1 | 2 | 3 | 0 | 2023-07-13T14:00:00.000Z | 40 | 0 | 0 | * | 0 | 0 | 0 | 2023-07-13T11:48:28.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | Exception | ||||
| 42 | 8 | 6 | //XX// | 19 | 1 | 0 | 3 | 0 | 2023-07-13T00:00:00.000Z | 0 | 0 | 0 | C1(P) | 0 | 0 | 0 | 2023-07-13T11:48:28.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | Exception | ||||
| 43 | 9 | 2 | * TRIAL * TR | 19 | 1 | 6 | 3 | 4 | 2023-04-06T08:00:00.000Z | 0 | 0 | 0 | * T | 0 | 0 | 1 | 2023-07-13T11:48:28.000Z | 2023-04-20T00:00:00.000Z | 2023-04-20T00:00:00.000Z | 2023-04-20T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | |||||
| 45 | 21 | 6 | //XXXX// | 19 | 1 | 0 | 3 | 0 | 2023-07-13T00:00:00.000Z | 0 | 0 | 0 | MaxDent, MandDent | 0 | 0 | 0 | 2023-07-13T11:48:28.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | * TRIAL * | ||||
| 46 | 8 | 2 | * TRIAL * TRIA | 19 | 1 | 6 | 1 | 0 | 2023-07-13T14:10:00.000Z | 0 | 0 | 0 | Ext | 0 | 0 | 0 | 2023-07-13T11:48:28.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | Exception | ||||
| 47 | 8 | 1 | * TRIAL * TR | 19 | 1 | 1 | 1 | 0 | 2023-08-09T10:00:00.000Z | 0 | 0 | 0 | * TRIAL * TRIAL * T | 0 | 0 | 0 | 2023-07-13T11:48:28.000Z | 0001-01-01T00:00:00.000Z | 0001-01-01T00:00:00.000Z | 0001-01-01T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | Exception | ||||
| 48 | 9 | 1 | * TRIAL | 19 | 1 | 2 | 3 | 0 | 2023-07-21T09:00:00.000Z | 33 | 0 | 0 | BridgeSeat | 0 | 0 | 0 | 2023-07-13T11:48:28.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 2023-07-13T00:00:00.000Z | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | Exception |