# Corps Water Management System (CWMS) Database Authorization Canonical: https://abierto.us/opportunities/w912hq25r0007 - Solicitation number: W912HQ25R0007 - Notice type: Combined synopsis and solicitation - Status: Awarded to Solid Logix LLC - Department: Department of the Army - Agency: Department of the Army - Contracting office: W4LD USA Hecsa (W912HQ) - NAICS: 541511 Custom Computer Programming Services - Product or service code: DA01 Support services for activities involved with application development and support to include analysis, design, development, coding, testing, and release packaging, as well as support of off-the-shelf Business Applications. - Set-aside: Total small business set-aside - Place of performance: Davis, California - County: Yolo County (FIPS 06113). https://abierto.us/counties/yolo-county-ca-06113 - City: Davis. https://abierto.us/cities/davis-ca-0618100 - First posted: February 27, 2025 - Last posted: March 25, 2025 - SAM.gov: https://sam.gov/workspace/contract/opp/882a239a9ae84d718842d438f8311ffb/view ## Description This is a combined synopsis/solicitation for commercial services prepared in accordance with the format in FAR 12.603 – Streamlined Solicitation for Commercial Items, as supplemented with additional information included in this notice and FAR Part 13 procedures. This announcement constitutes the only solicitation. Proposals are being requested. This solicitation document and incorporated provisions and clauses are those in effect through Federal Acquisition Circular 2025-03, dated 03 JAN 2025. Background: The mission of the US Army Corps of Engineers (USACE) Institute for Water Resources (IWR) Hydrologic Engineering Center (HEC) is to serve as the USACE Center of Expertise in the technical areas of surface and groundwater hydrology, river hydraulics and sediment transport, reservoir system analysis and a number of other closely associated technical subjects. HEC's primary goal is to support the nation in its water resources management responsibilities by increasing USACE’s technical capability in hydrologic engineering and water resources planning and management. Additionally, HEC provides services to other Federal, state, local and international agencies engaged in these technical areas. The Corps Water Management System (CWMS) is the Army Information System (AIS) that supports and enhances the decision-making process for the USACE water management mission. USACE is responsible for round-the-clock monitoring and operation of approximately 600 reservoir, lock and dam, and other water control projects. This responsibility also expands, during flood control operations, to approximately 120 additional Section 7 (Non-USACE) projects. The focus of this contract is on the database and API components of our CWMS system. CWMS is currently going through a transition from maintaining 32 independent, and geographically isolated systems, that feed into a public only central database, to a "single" cloud-based system that will contain all data, both public and private. Part of this transition is merging the multiple District databases into an Oracle RDS instance with an HTTP REST API called CWMS-Data-API (CDA). Previous to this decision, much of the data authorization was done within each individual database so that appropriate data constraints could be implemented while allowing District applications to access Oracle directly. The CWMS Database Schema (CWMS DB) has thus made heavy use of session contexts and the Oracle Virtual Private Database (VPD) system to provide appropriate authorization. Due to changes in technology, a more appropriate model of authorization needs to be adopted. **Requirement:** The objective of this contract is to develop a detailed plan on how to implement the Authorization Scheme into the CWMS Data API and then implement the created plan. This will include a review of our current data Schema and API to determine the best path forward. After the initial review, the following objectives will be required for the accomplishments of this contract. 1. ability to authorize read permissions to data objects in the database 2. ability to authorize write permissions to data objects in the database 3. ability to authorize delete permissions to data objects in the database 4. ability to authorize create permissions to data objects in the database 5. ability to authorize update permissions to data objects in the database 6. ability and platform for data administrators to assign the above permissions to users as appropriate The overall period of performance (POP) is two-hundred and seventy (270) days from the date of contract award; there are different POPs per each task in the Performance Work Statement (PWS). See the Combined Synopsis-Solicitation and the Performance Work Statement for additional information. Amendment 001 is to correct the date proposals are due on SAM.gov to match what is in the attached Combined Synopsis-Solicitation. The correct date proposals are due is 20 March 2025. Amendment 002 is to provide all answers to all questions received prior to the due date and time for questions. A revised Combined Synopsis-Solicitation is attached. A Past Performance Questionnaire is attached. The due date and time for receipt of proposals is extended to 28 March 2025. Amendment 003 is to provide additional supporting documents for the Performance Work Statement. Amendment 004 is to provide the missing Past Performance Questionnaire. Amendment 005 is to allow for an increased page count for Factors 1 and 2. ## Award on USAspending - Recipient: Solid Logix LLC (UEI XJATJC99J287) - Contract: W912HQ25P0049, purchase order - Obligated: $241,435.00 - Competition: Competed Under SAP, 26 offers received - Link: solicitation number W912HQ25R0007 equals the FPDS solicitation identifier; same awarding office W912HQ (high confidence) - Record: https://www.usaspending.gov/award/CONT_AWD_W912HQ25P0049_9700_-NONE-_-NONE-/ ## Publications - February 27, 2025: Combined synopsis and solicitation, due April 20, 2025 at 4:30 PM EDT. Notice 43d7f8435caa44ac9ec5f729bdc8e6cd. https://sam.gov/workspace/contract/opp/43d7f8435caa44ac9ec5f729bdc8e6cd/view - February 28, 2025: Combined synopsis and solicitation, due March 20, 2025 at 4:30 PM EDT. Notice 97e42c7df6624625b3955fa06a8a396d. https://sam.gov/workspace/contract/opp/97e42c7df6624625b3955fa06a8a396d/view - March 10, 2025: Combined synopsis and solicitation, due March 28, 2025 at 4:30 PM EDT. Notice 67ab8856025e46dd80ea5ca18715dbc3. https://sam.gov/workspace/contract/opp/67ab8856025e46dd80ea5ca18715dbc3/view - March 10, 2025: Combined synopsis and solicitation, due March 28, 2025 at 4:30 PM EDT. Notice 6c5bdad1720d47969e764fb9a875efbc. https://sam.gov/workspace/contract/opp/6c5bdad1720d47969e764fb9a875efbc/view - March 11, 2025: Combined synopsis and solicitation, due March 28, 2025 at 4:30 PM EDT. Notice b9969ffbcfaf4c97a55a3114040c6615. https://sam.gov/workspace/contract/opp/b9969ffbcfaf4c97a55a3114040c6615/view - March 25, 2025: Combined synopsis and solicitation, due March 28, 2025 at 4:30 PM EDT. Notice 882a239a9ae84d718842d438f8311ffb. https://sam.gov/workspace/contract/opp/882a239a9ae84d718842d438f8311ffb/view ## Points of contact - David A. Kaplan, david.a.kaplan@usace.army.mil, 7034288487 - Quan Nguyen, Quan.Nguyen@usace.army.mil --- Source: SAM.gov Contract Opportunities bulk extract and USAspending.gov award data. Confirm deadlines on SAM.gov before responding. Cite https://abierto.us/opportunities/w912hq25r0007.