1 day snapshot.xlsx
XLSX spreadsheet 17 KB Posted
- Attached to
- 3650--763-26-2-228-0242 -Lancaster CMOP Low to Medium Volume TCA and Sorting Loops Project (VA-26-00039446)
- Solicitation number
- 36C77026T0007
About this file
This file is a one-day snapshot document, likely a data export or operational status report for the Dallas Consolidated Mail Outpatient Pharmacy (CMOP) facility. The document supports the Special Notice solicitation (36C77026T0007) for the Lancaster CMOP Low to Medium Volume TCA and Sorting Loops Project, issued by the Department of Veterans Affairs Veterans Health Administration Veterans Integrated Service Network 15. The RFP has been updated and extended until August 20, 2026.
The Dallas CMOP, operating as one of seven nationwide facilities under the VA, currently processes approximately 90,000 prescriptions daily and requires upgrades to its automation infrastructure, including advanced robotics and integrated equipment systems for the low to medium volume TCA (Tablet Counting and Automation) and sorting loops operations. The facility serves prescription fulfillment and mailing services for Veteran patients from VA Medical Centers and Community Based Outpatient Clinics across the United States. The modernization project is essential to maintain operational efficiency, ensure accuracy and safety in prescription processing, support anticipated increases in workload, and enable scalability for future agency growth and potential interagency partnerships. Without access to the actual spreadsheet data within the file, specific metrics, timelines, or detailed requirements cannot be further elaborated, but the snapshot likely contains operational performance indicators relevant to the procurement scope.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| G. Dallas Manual Dispensing for New TCA.xlsx | XLSX spreadsheet | |
| H. Dallas TCA Products 07132026.xlsx | XLSX spreadsheet | |
| K. L034.00113-510A.pdf | ||
| I. Dallas_CMOP_Floor Plan.pdf | ||
| L. CHIP Programming job aid 1.pdf | ||
| B. Attachment 1 for Dallas CMOP TCA Low to Medium Volume.docx | DOCX document | |
| A. PWS TCA System Installation_Final_updated 7.8.26.docx | DOCX document | |
| J. FlexLink Layout from KNAPP System.docx | DOCX document | |
| E. BOT2000.pdf | ||
| RFP_36C77026R0007_extended.docx | DOCX document | |
| D. Past Performance Questionnaire.docx | DOCX document | |
| F. CAP1185CL-foil-lined- CAP1190CL-foam-lined.pdf | ||
| C. BUSINESS ASSOCIATE AGREEMENT.pdf | ||
| M. CHIP Program Deleting job aid 2.pdf | ||
| S06_Amendment_36C77026R0007.docx | DOCX document | |
| S05_Questions and Clarifications_R0007.docx | DOCX document |
Show all 16
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Sheet1
| OrderID | OrderSplitNumber | OrderDetailNumber | SupertoteID | SecondaryOrderSplitNumber | SecondaryOrderDetailNumber | ProductCode | NDC | QuantityRequested | DaysSupply | SnapCapFlag | LastBackorderDateTime | OrderDetailStatus | PackSize | QuantityToPick | QuantityPicked | UnitType | UnitNumber | CellNumber | Volume | Weight | ExceptionCode | ExceptionText | CancelCode | CancelReason | RxCancelledDateTime | LastModifiedDateTime | PickedDateTime | VerificationDateTime | UseBeforeDate | PickCompletedFlag | DispenseUnitText | NumberOfPacksPerLabel | PickingMethod | AllocationInstanceNumber | BinNumber | RxExportStatus | HazardFlag | ExtraDetailsFlag | DocumentInsertCode | LongSIGFlag | OrderSplitStatus | ToteID | OrderPriority | SplitExportStatus | OrderReceivedDateTime | OrderSplitDateTime | PackedDateTime | NeedsToteFlag | SupertoteType |
| Order_00001 | 3 | 1 | NULL | 0 | 0 | F0002 | 51407068410 | 180 | 90 | 0 | 00:00.0 | 8 | 1 | 180 | 180 | 5 | 31 | 35 | 120 | 5 | 0 | 0 | 00:00.0 | 43:18.8 | 29:52.8 | 34:07.1 | 29:52.9 | 1 | TAB | 1 | 0 | 3 | 0 | 1 | 0 | 2 | 0 | 0 | 8 | 0 | 10 | 1 | 49:05.0 | 15:25.0 | 41:32.7 | 0 | 0 | ||
| Order_00002 | 4 | 4 | NULL | 0 | 0 | G0192 | 77771017790 | 270 | 90 | 0 | 00:00.0 | 8 | 90 | 3 | 3 | 20 | 53 | 21 | 810 | 5 | 0 | 0 | 00:00.0 | 58:27.3 | 44:12.0 | 45:29.0 | 43:52.0 | 1 | TAB | 1 | 1 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 0 | 10 | 1 | 52:29.0 | 02:57.0 | 56:48.0 | 1 | 0 | ||
| Order_00003 | 7 | 6 | NULL | 0 | 0 | O0207 | 71610088060 | 90 | 90 | 0 | 00:00.0 | 8 | 90 | 1 | 1 | 20 | 52 | 46 | 209.9 | 5 | 0 | 0 | 00:00.0 | 28:30.1 | 20:11.0 | 22:37.0 | 20:07.0 | 1 | CAP | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 0 | 10 | 1 | 58:11.0 | 19:23.0 | 23:19.0 | 1 | 0 | ||
| Order_00004 | 3 | 2 | NULL | 0 | 0 | H0044 | 71610048845 | 45 | 90 | 0 | 00:00.0 | 8 | 45 | 1 | 1 | 20 | 57 | 122 | 209.9 | 5 | 0 | 0 | 00:00.0 | 04:25.2 | 36:48.0 | 44:11.0 | 36:42.0 | 1 | TAB | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 0 | 10 | 1 | 16:44.0 | 02:20.0 | 49:46.0 | 1 | 0 | ||
| Order_00004 | 3 | 3 | NULL | 0 | 0 | L0158 | 72865014290 | 90 | 90 | 0 | 00:00.0 | 8 | 90 | 1 | 1 | 20 | 49 | 44 | 182 | 5 | 0 | 0 | 00:00.0 | 04:25.2 | 36:40.0 | 44:12.0 | 36:31.0 | 1 | TAB | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 0 | 10 | 1 | 16:44.0 | 02:20.0 | 49:46.0 | 1 | 0 | ||
| Order_00004 | 3 | 4 | NULL | 0 | 0 | M0968 | 469260230 | 90 | 90 | 0 | 00:00.0 | 8 | 30 | 3 | 3 | 20 | 47 | 18 | 456.3 | 5 | 0 | 0 | 00:00.0 | 04:25.2 | 36:29.0 | 44:06.0 | 35:57.0 | 1 | TAB | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 0 | 10 | 1 | 16:44.0 | 02:20.0 | 49:46.0 | 1 | 0 | ||
| Order_00005 | 3 | 3 | NULL | 0 | 0 | A1126 | 77771045405 | 45 | 90 | 0 | 00:00.0 | 8 | 1 | 45 | 45 | 5 | 31 | 134 | 108 | 5 | 0 | 0 | 00:00.0 | 43:36.5 | 48:46.9 | 57:36.7 | 48:46.9 | 1 | TAB | 1 | 0 | 4 | 0 | 1 | 0 | 2 | 0 | 0 | 8 | 0 | 10 | 1 | 59:23.0 | 24:31.0 | 39:51.7 | 0 | 0 | ||
| Order_00006 | 3 | 3 | NULL | 0 | 0 | C0336 | 52817021050 | 360 | 90 | 0 | 00:00.0 | 8 | 1 | 360 | 360 | 5 | 31 | 304 | 108 | 5 | 0 | 0 | 00:00.0 | 43:47.2 | 09:29.9 | 09:30.0 | 09:29.9 | 1 | TAB | 1 | 0 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 5075 | 10 | 1 | 59:22.0 | 19:12.0 | 39:54.5 | 1 | 0 | ||
| Order_00006 | 3 | 4 | NULL | 0 | 0 | D0665 | 16714048402 | 540 | 90 | 0 | 00:00.0 | 8 | 1 | 540 | 540 | 5 | 31 | 42 | 432 | 5 | 0 | 0 | 00:00.0 | 43:47.2 | 15:05.4 | 18:36.9 | 15:05.4 | 1 | TAB | 1 | 0 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 5075 | 10 | 1 | 59:22.0 | 19:12.0 | 39:54.5 | 1 | 0 | ||
| Order_00006 | 3 | 9 | NULL | 0 | 0 | M0087 | 76282079510 | 90 | 90 | 0 | 00:00.0 | 8 | 1 | 90 | 90 | 5 | 31 | 18 | 108 | 5 | 0 | 0 | 00:00.0 | 43:47.2 | 12:20.4 | 16:02.3 | 12:20.4 | 1 | TAB | 1 | 0 | 2 | 0 | 1 | 0 | 2 | 0 | 0 | 8 | 5075 | 10 | 1 | 59:22.0 | 19:12.0 | 39:54.5 | 1 | 0 | ||
| Order_00006 | 3 | 11 | NULL | 0 | 0 | N0462 | 68682010510 | 90 | 90 | 0 | 00:00.0 | 8 | 1 | 90 | 90 | 5 | 31 | 87 | 108 | 5 | 0 | 0 | 00:00.0 | 43:47.2 | 12:12.4 | 15:36.3 | 12:12.5 | 1 | TAB | 1 | 0 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 5075 | 10 | 1 | 59:22.0 | 19:12.0 | 39:54.5 | 1 | 0 | ||
| Order_00007 | 5 | 6 | NULL | 0 | 0 | P0572 | 72865023090 | 90 | 90 | 0 | 00:00.0 | 8 | 90 | 1 | 1 | 20 | 58 | 71 | 190 | 5 | 0 | 0 | 00:00.0 | 04:25.5 | 58:28.0 | 53:47.0 | 58:23.0 | 1 | TAB | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 0 | 10 | 1 | 52:25.0 | 02:48.0 | 54:48.0 | 1 | 0 | ||
| Order_00007 | 5 | 7 | NULL | 0 | 0 | S0370 | 10135031401 | 200 | 90 | 0 | 00:00.0 | 8 | 100 | 2 | 2 | 20 | 51 | 8 | 372.4 | 5 | 0 | 0 | 00:00.0 | 04:25.5 | 58:17.0 | 53:53.0 | 58:04.0 | 1 | TAB | 1 | 1 | 1 | 0 | 1 | 0 | 129 | 0 | 0 | 8 | 0 | 10 | 1 | 52:25.0 | 02:48.0 | 54:48.0 | 1 | 0 | ||
| Order_00007 | 5 | 8 | NULL | 0 | 0 | S0776 | 73190000518 | 180 | 90 | 0 | 00:00.0 | 8 | 180 | 1 | 1 | 20 | 48 | 11 | 1 | 5 | 0 | 0 | 00:00.0 | 04:25.5 | 58:38.0 | 53:56.0 | 58:32.0 | 1 | TAB | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 0 | 10 | 1 | 52:25.0 | 02:48.0 | 54:48.0 | 1 | 0 | ||
| Order_00008 | 2 | 3 | NULL | 0 | 0 | P0332 | 378700393 | 60 | 30 | 0 | 00:00.0 | 8 | 30 | 2 | 2 | 20 | 60 | 18 | 310 | 5 | 0 | 0 | 00:00.0 | 58:27.3 | 43:25.0 | 46:18.0 | 43:11.0 | 1 | TAB | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 0 | 10 | 1 | 52:27.0 | 02:55.0 | 52:23.0 | 1 | 0 | ||
| Order_00009 | 2 | 2 | NULL | 0 | 0 | F0612 | 54629064501 | 200 | 90 | 0 | 00:00.0 | 8 | 100 | 2 | 2 | 20 | 51 | 14 | 286 | 5 | 0 | 0 | 00:00.0 | 28:30.1 | 24:55.0 | 25:31.0 | 24:44.0 | 1 | TAB | 1 | 1 | 1 | 0 | 1 | 0 | 129 | 0 | 0 | 8 | 0 | 10 | 1 | 52:22.0 | 02:32.0 | 27:05.0 | 1 | 0 | ||
| Order_00010 | 3 | 2 | NULL | 0 | 0 | F0285 | 378932032 | 3 | 90 | 0 | 00:00.0 | 8 | 1 | 3 | 3 | 20 | 50 | 11 | 1425.3 | 5 | 0 | 0 | 00:00.0 | 53:08.2 | 43:01.0 | 46:32.0 | 00:00.0 | 1 | EA | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 0 | 10 | 1 | 52:31.0 | 03:06.0 | 51:11.0 | 1 | 0 | ||
| Order_00011 | 5 | 2 | NULL | 0 | 0 | C1916 | 54629001162 | 200 | 90 | 0 | 00:00.0 | 8 | 100 | 2 | 2 | 20 | 45 | 12 | 306.934 | 5 | 0 | 0 | 00:00.0 | 53:32.5 | 33:24.0 | 36:31.0 | 33:00.0 | 1 | TAB | 1 | 1 | 1 | 0 | 1 | 0 | 129 | 0 | 0 | 8 | 0 | 10 | 1 | 52:24.0 | 02:37.0 | 50:51.0 | 1 | 0 | ||
| Order_00011 | 5 | 5 | NULL | 0 | 0 | P0082 | 71610097760 | 90 | 90 | 0 | 00:00.0 | 8 | 90 | 1 | 1 | 20 | 54 | 42 | 210 | 5 | 0 | 0 | 00:00.0 | 53:32.5 | 32:57.0 | 36:36.0 | 32:49.0 | 1 | TABLET | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 0 | 10 | 1 | 52:24.0 | 02:37.0 | 50:51.0 | 1 | 0 | ||
| Order_00011 | 5 | 6 | NULL | 0 | 0 | S0369 | 51407001309 | 18 | 30 | 0 | 00:00.0 | 8 | 9 | 2 | 2 | 20 | 46 | 49 | 375.6 | 5 | 0 | 0 | 00:00.0 | 53:32.5 | 33:47.0 | 36:35.0 | 33:27.0 | 1 | TAB | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 0 | 10 | 1 | 52:24.0 | 02:37.0 | 50:51.0 | 1 | 0 | ||
| Order_00011 | 5 | 7 | NULL | 0 | 0 | T0372 | 72789032530 | 60 | 30 | 0 | 00:00.0 | 8 | 30 | 2 | 2 | 20 | 52 | 12 | 254 | 5 | 0 | 0 | 00:00.0 | 53:32.5 | 34:02.0 | 36:28.0 | 32:36.0 | 1 | TAB | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 0 | 10 | 1 | 52:24.0 | 02:37.0 | 50:51.0 | 1 | 0 | ||
| Order_00012 | 2 | 2 | NULL | 0 | 0 | C0408 | 10135065201 | 200 | 90 | 0 | 00:00.0 | 8 | 100 | 2 | 2 | 20 | 41 | 1 | 368.2 | 5 | 0 | 0 | 00:00.0 | 28:30.1 | 20:28.0 | 22:29.0 | 20:20.0 | 1 | TAB | 1 | 1 | 1 | 0 | 1 | 0 | 129 | 0 | 0 | 8 | 0 | 10 | 1 | 01:47.0 | 02:13.0 | 22:55.0 | 1 | 0 | ||
| Order_00013 | 3 | 3 | NULL | 0 | 0 | T0372 | 72789032530 | 90 | 90 | 0 | 00:00.0 | 8 | 30 | 3 | 3 | 20 | 52 | 12 | 381 | 5 | 0 | 0 | 00:00.0 | 28:30.1 | 20:55.0 | 22:22.0 | 20:36.0 | 1 | TAB | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 0 | 10 | 1 | 52:22.0 | 02:35.0 | 23:10.0 | 1 | 0 | ||
| Order_00014 | 3 | 3 | NULL | 0 | 0 | D0592 | 536124801 | 200 | 90 | 0 | 00:00.0 | 8 | 100 | 2 | 2 | 20 | 47 | 24 | 317.6 | 5 | 0 | 0 | 00:00.0 | 53:47.3 | 13:41.0 | 47:55.0 | 13:23.0 | 1 | TAB | 1 | 1 | 1 | 0 | 1 | 0 | 129 | 0 | 0 | 8 | 5249 | 10 | 1 | 52:24.0 | 02:40.0 | 50:43.10 | 1 | 0 | ||
| Order_00015 | 3 | 2 | NULL | 0 | 0 | S0997 | 70710190009 | 90 | 90 | 0 | 00:00.0 | 8 | 90 | 1 | 1 | 20 | 52 | 16 | 120.2 | 5 | 0 | 0 | 00:00.0 | 58:27.3 | 44:42.0 | 46:08.0 | 44:34.0 | 1 | TAB | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 0 | 10 | 1 | 52:27.0 | 02:52.0 | 53:15.0 | 1 | 0 | ||
| Order_00015 | 3 | 3 | NULL | 0 | 0 | A0449 | 60429002590 | 90 | 90 | 0 | 00:00.0 | 8 | 90 | 1 | 1 | 20 | 55 | 5 | 243.4 | 5 | 0 | 0 | 00:00.0 | 58:27.3 | 44:25.0 | 46:06.0 | 44:19.0 | 1 | TAB | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 0 | 10 | 1 | 52:27.0 | 02:52.0 | 53:15.0 | 1 | 0 | ||
| Order_00015 | 3 | 5 | NULL | 0 | 0 | R0288 | 50458057990 | 90 | 90 | 0 | 00:00.0 | 8 | 90 | 1 | 1 | 20 | 55 | 33 | 150 | 5 | 0 | 0 | 00:00.0 | 58:27.3 | 44:33.0 | 46:09.0 | 44:27.0 | 1 | TAB | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 0 | 10 | 1 | 52:27.0 | 02:52.0 | 53:15.0 | 1 | 0 | ||
| Order_00016 | 3 | 3 | NULL | 0 | 0 | L0046 | 76282072990 | 180 | 90 | 0 | 00:00.0 | 8 | 90 | 2 | 2 | 20 | 54 | 10 | 296 | 5 | 0 | 0 | 00:00.0 | 52:12.3 | 52:59.0 | 44:29.0 | 52:38.0 | 1 | TAB | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 0 | 10 | 1 | 52:24.0 | 02:43.0 | 44:59.0 | 1 | 0 |
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it. Updated .