Spreadsheet: 885929d1735851202-sorting-by-more-than-1-criteria-for-excel-help
Sheet: Consolidate Green Tabs

Consolidated System Pull
Organization | Staff Name | [NAME] | Service Date | < 14 Days | > 14 Days | Activity Name | Error | Error Summarized | Client ID | Credential | [NAME] To: | Actual Duration | Failed Days | First Signed | First Signed Date | Fully Signed | Fully Signed Date | Next Staff to sign | Known staff error | Created by | Status | Program Name | Service End Date | Billed | Expected | Procedure | Minutes
 | [NAME] | [NAME]
ACT 1 | [NAME] | [NAME] | 2024-12-23 00:00:00 | Yes | No | ACT- [NAME] | Service Documentation not signed | Other/Multiple Errors |  | Medical Assistant | Ann Too | 30 | 3 | Yes | 2024-12-27 22:49:13 | No | 00:00:00 |  | 0
ACT 1 | [NAME] | [NAME] | 2024-12-23 00:00:00 | Yes | No | ACT- [NAME] | Service Documentation not signed | Other/Multiple Errors |  | Medical Assistant | Ann Too | 30 | 3 | Yes | 2024-12-27 22:51:29 | No | 00:00:00 |  | 0
ACT 1 | [NAME] | [NAME] | 2024-12-24 00:00:00 | Yes | No | ACT- [NAME] | Service Documentation not signed | Other/Multiple Errors |  | Medical Assistant | Ann Too | 30 | 3 | Yes | 2024-12-27 23:03:32 | No | 00:00:00 |  | 0
ACT 1 | [NAME] | [NAME] | 2024-12-24 00:00:00 | Yes | No | ACT- [NAME] | Service Documentation not signed | Other/Multiple Errors |  | Medical Assistant | Ann Too | 30 | 3 | Yes | 2024-12-27 23:06:19 | No | 00:00:00 |  | 0
ACT 1 | [NAME] | [NAME] | 2024-12-24 00:00:00 | Yes | No | ACT- [NAME] | Service Documentation not signed | Other/Multiple Errors |  | Medical Assistant | Ann Too | 30 | 3 | Yes | 2024-12-27 23:15:17 | No | 00:00:00 |  | 0
ACT 1 | [NAME] | [NAME] | 2024-12-24 00:00:00 | Yes | No | ACT- [NAME] | Service Documentation not signed | Other/Multiple Errors |  | Medical Assistant | Ann Too | 30 | 3 | Yes | 2024-12-27 23:22:02 | No | 00:00:00 |  | 0
ACT 1 | [NAME] | [NAME] | 2024-12-24 00:00:00 | Yes | No | ACT- [NAME] | Service Documentation not signed | Other/Multiple Errors |  | Medical Assistant | Ann Too | 30 | 3 | Yes | 2024-12-27 23:19:03 | No | 00:00:00 |  | 0
ACT 1 | [NAME] | [NAME] | 2024-12-26 00:00:00 | Yes | No | ACT- [NAME] | Service Documentation not signed | Other/Multiple Errors |  | Medical Assistant | Ann Too | 30 | 3 | Yes | 2024-12-27 23:25:56 | No | 00:00:00 |  | 0
ACT 1 | [NAME] | [NAME] | 2024-12-26 00:00:00 | Yes | No | ACT- [NAME] | Service Documentation not signed | Other/Multiple Errors |  | Medical Assistant | Ann Too | 30 | 3 | Yes | 2024-12-27 23:29:39 | No | 00:00:00 |  | 0
ACT 1 | [NAME] | [NAME] | 2024-12-26 00:00:00 | Yes | No | ACT- [NAME] | Service Documentation not signed | Other/Multiple Errors |  | Medical Assistant | Ann Too | 30 | 3 | Yes | 2024-12-27 23:36:06 | No | 00:00:00 |  | 0
ACT 1 | [NAME] | [NAME] | 2024-12-26 00:00:00 | Yes | No | ACT- [NAME] | Service Documentation not signed | Other/Multiple Errors |  | Medical Assistant | Ann Too | 30 | 3 | Yes | 2024-12-27 23:33:16 | No | 00:00:00 |  | 0
ACT 1 | [NAME] | [NAME] | 2024-12-27 00:00:00 | Yes | No | ACT- [NAME] | Service Documentation not signed | Other/Multiple Errors |  | Medical Assistant | Ann Too | 30 | 3 | Yes | 2024-12-27 23:50:37 | No | 00:00:00 |  | 0
ACT 1 | [NAME] | [NAME] | 2024-12-27 00:00:00 | Yes | No | ACT- [NAME] | Service Documentation not signed | Other/Multiple Errors |  | Medical Assistant | Ann Too | 30 | 3 | Yes | 2024-12-27 23:47:43 | No | 00:00:00 |  | 0
ACT 1 | [NAME] | [NAME] | 2024-12-27 00:00:00 | Yes | No | ACT- [NAME] | Service Documentation not signed | Other/Multiple Errors |  | Medical Assistant | Ann Too | 30 | 3 | Yes | 2024-12-27 23:45:11 | No | 00:00:00 |  | 0
ACT 1 | [NAME] | [NAME] | 2024-12-27 00:00:00 | Yes | No | ACT- [NAME] | Service Documentation not signed | Other/Multiple Errors |  | Medical Assistant | Ann Too | 30 | 3 | Yes | 2024-12-27 23:42:38 | No | 00:00:00 |  | 0
ACT 1 | [NAME] | [NAME] | 2024-12-27 00:00:00 | Yes | No | ACT- [NAME] | Service Documentation not signed | Other/Multiple Errors |  | Medical Assistant | Ann Too | 30 | 3 | Yes | 2024-12-27 23:38:58 | No | 00:00:00 |  | 0
ACT 5 | [NAME] | [NAME] | 2024-10-22 00:00:00 | No | Yes | ACT- [NAME] | Service Documentation not found | Other/Multiple Errors |  | 0 | [NAME] | 30 | 21 | 0 | 00:00:00 | 0 | 00:00:00 |  | 0
ACT Dover | [NAME] | [NAME] | 2024-09-26 00:00:00 | No | Yes | ACT- Treatment/Therapy Services | Service Documentation not signed | Other/Multiple Errors |  | Master [NAME] | [NAME] | 45 | 95 | No | 00:00:00 | No | 00:00:00 |  | 0
ACT Dover | [NAME] | [NAME] | 2024-12-23 00:00:00 | Yes | No | ACT- Treatment/Therapy Services | Service Documentation not signed | Other/Multiple Errors |  | Master [NAME] | [NAME] | 45 | 7 | Yes | 2024-12-23 15:58:28 | No | 00:00:00 |  | 0
ACT Dover | [NAME] | [NAME] | 2024-12-23 00:00:00 | Yes | No | ACT- Treatment/Therapy Services | Service Documentation not signed | Other/Multiple Errors |  | Master [NAME] | [NAME] | 45 | 7 | Yes | 2024-12-23 16:19:50 | No | 00:00:00 |  | 0
ACT Dover | [NAME] | [NAME] | 2024-12-23 00:00:00 | Yes | No | ACT- Treatment/Therapy Services | Service Documentation not signed | Other/Multiple Errors |  | Master [NAME] |  | 45 | 7 | Yes | 2024-12-23 15:48:38 | No | 00:00:00 |  | 0
ACT Dover | [NAME] | [NAME] | 2024-12-23 00:00:00 | Yes | No | ACT- Treatment/Therapy Services | Service Documentation not signed | Other/Multiple Errors |  | Master [NAME] |  | 45 | 7 | Yes | 2024-12-23 16:36:13 | No | 00:00:00 |  | 0
ACT Dover | [NAME] | [NAME] | 2024-12-23 00:00:00 | Yes | No | ACT- Treatment/Therapy Services | Service Documentation not signed | Other/Multiple Errors |  | Master [NAME] |  | 45 | 7 | Yes | 2024-12-23 16:45:20 | No | 00:00:00 |  | 0
ACT Dover | [NAME] | [NAME] | 2024-12-24 00:00:00 | Yes | No | ACT- Treatment/Therapy Services | Service Documentation not signed | Other/Multiple Errors |  | Master [NAME] |  | 45 | 6 | Yes | 2024-12-24 15:19:28 | No | 00:00:00 |  | 0
ACT Dover | [NAME] | [NAME] | 2024-12-24 00:00:00 | Yes | No | ACT- Treatment/Therapy Services | Service Documentation not signed | Other/Multiple Errors |  | Master [NAME] |  | 45 | 6 | Yes | 2024-12-24 14:57:37 | No | 00:00:00 |  | 0
ACT Dover | [NAME] | [NAME] | 2024-12-24 00:00:00 | Yes | No | ACT- Treatment/Therapy Services | Service Documentation not signed | Other/Multiple Errors |  | Master [NAME] |  | 45 | 6 | Yes | 2024-12-24 15:58:46 | No | 00:00:00 |  | 0
ACT Dover | [NAME] | [NAME] | 2024-12-24 00:00:00 | Yes | No | ACT- Treatment/Therapy Services | Service Documentation not signed | Other/Multiple Errors |  | Master [NAME] |  | 45 | 6 | Yes | 2024-12-24 15:31:24 | No | 00:00:00 |  | 0
ACT Dover | [NAME] | [NAME] | 2024-12-24 00:00:00 | Yes | No | ACT- Treatment/Therapy Services | Service Documentation not signed | Other/Multiple Errors |  | Master [NAME] |  | 45 | 6 | Yes | 2024-12-24 15:45:28 | No | 00:00:00 |  | 0
ACT Dover | [NAME] | [NAME] | 2024-12-24 00:00:00 | Yes | No | ACT- Treatment/Therapy Services | Service Documentation not signed | Other/Multiple Errors |  | Master [NAME] |  | 45 | 6 | Yes | 2024-12-24 15:07:46 | No | 00:00:00 |  | 0
ACT Dover | [NAME] | [NAME] | 2024-12-24 00:00:00 | Yes | No | ACT- Treatment/Therapy Services | Service Documentation not signed | Other/Multiple Errors |  | Master [NAME] |  | 45 | 6 | Yes | 2024-12-24 16:11:31 | No | 00:00:00 |  | 0
ACT Dover | [NAME] | [NAME] | 2024-12-26 00:00:00 | Yes | No | ACT- Treatment/Therapy Services | Service Documentation not signed | Other/Multiple Errors |  | Master [NAME] |  | 45 | 4 | Yes | 2024-12-27 00:16:00 | No | 00:00:00 |  | 0
ACT Dover | [NAME] | [NAME] | 2024-12-26 00:00:00 | Yes | No | ACT- Treatment/Therapy Services | Service Documentation not signed | Other/Multiple Errors |  | Master [NAME] |  | 45 | 4 | Yes | 2024-12-27 00:25:08 | No | 00:00:00 |  | 0
ACT Dover | [NAME] | [NAME] | 2024-12-26 00:00:00 | Yes | No | ACT- Treatment/Therapy Services | Service Documentation not signed | Other/Multiple Errors |  | Master [NAME] |  | 45 | 4 | Yes | 2024-12-27 00:32:35 | No | 00:00:00 |  | 0
New Hope | [NAME] | [NAME] | 2024-09-27 00:00:00 | No | Yes | Residential Medication Check | Service Documentation not found | Other/Multiple Errors |  | FNP |  | 30 | 65 | 0 | 00:00:00 | 0 | 00:00:00 |  | Wrong Location
New Hope | [NAME] | [NAME] | 2024-10-30 00:00:00 | No | Yes | Residential Psychiatric Assessment | Service Documentation not found | Other/Multiple Errors |  | FNP |  | 45 | 52 | 0 | 00:00:00 | 0 | 00:00:00 |  | 0
New Hope | [NAME] | [NAME] | 2024-12-26 00:00:00 | Yes | No | Residential Medication Check | Service Documentation not signed | Other/Multiple Errors |  | FNP |  | 30 | 4 | No | 00:00:00 | No | 00:00:00 |  | 0
Newark Clinic | [NAME] | [NAME] | 2024-10-15 00:00:00 | No | Yes | Initial Assessment - with Medical Services | Service Documentation not signed | Other/Multiple Errors |  | FNP |  | 60 | 25 | No | 00:00:00 | No | 00:00:00 |  | 0
Newark Clinic | [NAME] | [NAME] | 2024-10-22 00:00:00 | No | Yes | Initial Assessment - with Medical Services | Service Documentation not signed | Other/Multiple Errors |  | FNP |  | 60 | 26 | No | 00:00:00 | No | 00:00:00 |  | 0
Newark Clinic | [NAME] | [NAME] | 2024-11-13 00:00:00 | No | Yes | Telehealth-Initial Assess - without medical service | Service Documentation not found | Other/Multiple Errors |  | FNP |  | 60 | 47 | 0 | 00:00:00 | 0 | 00:00:00 |  | Wrong Location
Newark Clinic | [NAME] | [NAME] | 2024-11-25 00:00:00 | No | Yes | Medication Check | Service Documentation not signed | Other/Multiple Errors |  | FNP |  | 30 | 35 | No | 00:00:00 | No | 00:00:00 |  | Wrong Location
Promise Peers | [NAME] | [NAME] | 2024-12-02 00:00:00 | No | Yes | PROMISE PEER Services | Service Documentation not signed | Other/Multiple Errors |  | [NAME] |  | 180 | 1 | Yes | 2024-12-29 11:00:37 | No | 00:00:00 |  | 0
Promise Peers | [NAME] | [NAME] | 2024-12-02 00:00:00 | No | Yes | PROMISE PEER Services | Service Documentation not signed | Other/Multiple Errors |  | [NAME] |  | 195 | 1 | Yes | 2024-12-29 11:08:43 | No | 00:00:00 |  | Time - Check AM/PM
Promise Peers | [NAME] | [NAME] | 2024-12-03 00:00:00 | No | Yes | PROMISE PEER Services | Service Documentation not signed | Other/Multiple Errors |  | [NAME] |  | 240 | 1 | Yes | 2024-12-29 11:18:59 | No | 00:00:00 |  | Time - Check AM/PM
Promise Peers | [NAME] | [NAME] | 2024-12-03 00:00:00 | No | Yes | PROMISE PEER Services | Service Documentation not signed | Other/Multiple Errors |  | [NAME] |  | 120 | 1 | Yes | 2024-12-29 11:39:22 | No | 00:00:00 |  | 0
Promise Peers | [NAME] | [NAME] | 2024-12-04 00:00:00 | No | Yes | PROMISE PEER Services | Service Documentation not signed | Other/Multiple Errors |  | [NAME] |  | 120 | 1 | Yes | 2024-12-29 12:16:02 | No | 00:00:00 |  | 0
Promise Peers | [NAME] | [NAME] | 2024-12-04 00:00:00 | No | Yes | PROMISE PEER Services | Service Documentation not signed | Other/Multiple Errors |  | [NAME] |  | 180 | 1 | Yes | 2024-12-29 11:57:40 | No | 00:00:00 |  | 0
WRP | [NAME] | [NAME] | 2024-09-26 00:00:00 | No | Yes | Medication Check | Service Documentation not found | Other/Multiple Errors |  | FNP |  | 30 | 52 | 0 | 00:00:00 | 0 | 00:00:00 |  | 0