PWS_CIS SQL Archive v1.0.docx
DOCX document 170 KB Posted
- Attached to
- DA01--Endoscopy Legacy SQL Data Consolidation, Reporting and Technical Support (VA-26-00066280)
- Solicitation number
- 36C10B26Q0554
About this file
This is a Performance Work Statement (PWS) for the Department of Veterans Affairs' Healthcare Technology Management Program Office to consolidate legacy endoscopy clinical information system (CIS) SQL databases and develop customized reporting capabilities.
The VA seeks to consolidate disparate SQL databases from multiple Veterans Affairs Medical Centers (VAMCs) nationwide into a single national SQL Server 2022 instance, enabling clinical stakeholders to review historical endoscopy data for clinical decision-making. The contractor must analyze legacy SQL database structures (Microsoft SQL Server versions 2014-2019, averaging 100-200 GB per VAMC with approximately 300 tables each), establish a reporting development environment using either SQL Server Reporting Services (SSRS) or PowerBI Online, and develop up to ten customized reports with specific clinical and operational inputs and outputs—including instrument tracking reports, provider quality metrics, patient procedure history, detailed procedure encounters with images, and five additional ad-hoc reports to be clarified by the VA prior to period completion. The reporting system must support web-based access, Microsoft Entra ID authentication integrated with VA Active Directory for role-based access control at VAMC, VISN, or national levels, and export capabilities in Excel and PDF formats. The contractor shall provide system administrator training, quick reference guides for user access management and database extension processes, and technical support including troubleshooting, bug repair, and server failure recovery for one year following report validation, with quarterly summary reporting. The base performance period is twelve months from contract award, with four optional twelve-month periods for continued technical support. All work shall be performed remotely using PIV or MOU/ISA credentialed access to VA systems, with no travel anticipated. Deliverables include a Contractor Project Management Plan, monthly progress reports, database structure analysis reports, capability statements, implemented reporting development environment, customized reports with quality assurance documentation, training documentation, and quarterly technical support summaries. The contractor must comply with extensive federal and VA security, privacy, and IT requirements including FICAM standards, PIV authentication, HIPAA compliance, zero trust architecture, IPv6 support, TIC 3.0 standards, VA Critical Security Controls, generative AI governance requirements if applicable, and SHARE IT Act source code delivery obligations. Contractor personnel require background investigations commensurate with task risk designations (Tier 1 Low Risk through Tier 4 High Risk), with all personnel needing favorable adjudication of Special Agreement Checks and completion of mandatory VA training prior to access to VA systems or facilities.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 36C10B26Q0554_1.docx | DOCX document | |
| 36C10B26Q0554.docx | DOCX document |
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
Endoscopy Legacy SQL Data Consolidation, Reporting and Technical Support
VA-26-00066280
PERFORMANCE WORK STATEMENT (PWS)
DEPARTMENT OF VETERANS AFFAIRS
Healthcare Technology Management (HTM) Program Office GI Program Office
Endoscopy Legacy SQL Data Consolidation, Reporting and Technical Support
Date: June 16, 2026
VA-26-00066280
PWS Version Number: 1.0
Contents
| 1.0 | BACKGROUND | 4 |
| 2.0 | APPLICABLE DOCUMENTS | 4 |
| 3.0 | SCOPE OF WORK | 8 |
| 4.0 | PERFORMANCE DETAILS | 9 |
| 4.1 | PERFORMANCE PERIOD | 9 |
| 4.2 | PLACE OF PERFORMANCE | 9 |
| 4.3 | TRAVEL | 10 |
| 5.0 | SPECIFIC TASKS AND DELIVERABLES | 10 |
| 5.1 | PROJECT MANAGEMENT | 10 |
| 5.1.1 | CONTRACTOR PROJECT MANAGEMENT PLAN | 10 |
| 5.1.2 | REPORTING REQUIREMENTS | 10 |
| 5.2 | DATABASE INFRASTRUCTURE & ANALYSIS | 11 |
| 5.3 | REPORTING DEVELOPMENT ENVIRONMENT (RDE) | 11 |
| 5.4 | CUSTOMIZED REPORTS DEVELOPMENT | 12 |
| 5.5 | REPORTING DEVELOPMENT ENVIRONMENT SYSTEM ADMINISTRATOR AND SUSTAINMENT TRAINING | 14 |
| 5.6 | CUSTOMER SUPPORT | 14 |
| 5.7 | OPTION PERIODS | 15 |
| 6.0 | GENERAL REQUIREMENTS | 15 |
| 6.1 | ENTERPRISE AND IT FRAMEWORK | 15 |
| 6.1.1 | VA TECHNICAL REFERENCE MODEL | 15 |
| 6.1.2 | ZERO TRUST – VA CRITICAL SECURITY CONTROLS | 15 |
| 6.1.3 | FEDERAL IDENTITY, CREDENTIAL, AND ACCESS MANAGEMENT (FICAM) | 15 |
| 6.1.4 | INTERNET PROTOCOL VERSION 6 (IPv6) | 17 |
| 6.1.5 | TRUSTED INTERNET CONNECTION (TIC) | 17 |
| 6.1.6 | STANDARD COMPUTER CONFIGURATION | 18 |
| 6.1.7 | VETERAN FOCUSED INTEGRATION PROCESS (VIP) AND PRODUCT LINE MANAGEMENT (PLM) | 18 |
| 6.1.8 | PROCESS ASSET LIBRARY (PAL) | 19 |
| 6.1.9 | AUTHORITATIVE DATA SOURCES | 19 |
| 6.1.10 | SOCIAL SECURITY NUMBER (SSN) REDUCTION | 20 |
| 6.1.11 | GENERATIVE ARTIFICIAL INTELLIGENCE REQUIREMENTS | 20 |
| 6.1.11.1 | AI SYSTEM/LLM DEVELOPMENT AND OPERATION DOCUMENTATION REQUIREMENTS | 22 |
| 6.1.11.2 | MONITORING, REPORTING, AND CORRECTIVE ACTION | 24 |
| 6.1.11.3 | AI MODEL UPDATES AND CHANGE DISCLOSURES | 24 |
| 6.1.12 | SOURCE CODE HARMONIZATION AND REUSE IN INFORMATION TECHNOLOGY (SHARE IT Act) | 24 |
| 6.2 | SECURITY AND PRIVACY REQUIREMENTS | 25 |
| 6.2.1 | POSITION/TASK RISK DESIGNATION LEVEL(S) | 25 |
| 6.2.2 | CONTRACTOR PERSONNEL SECURITY REQUIREMENTS | 25 |
| 6.3 | METHOD AND DISTRIBUTION OF DELIVERABLES | 27 |
| 6.4 | PERFORMANCE METRICS | 27 |
| 6.5 | FACILITY/RESOURCE PROVISIONS | 31 |
| ADDENDUM A – ADDITIONAL VA REQUIREMENTS, CONSOLIDATED | 33 | |
| ADDENDUM B – VA INFORMATION AND INFORMATION SYSTEM SECURITY/ PRIVACY LANGUAGE | 39 | |
| ADDENDUM C – VAMC LEGACY CIS SCOPE INCLUSION LIST | 58 |
BACKGROUND
The Department of Veteran’s Affairs (VA) uses a variety of clinical information systems (CIS) to document clinical care provided to veterans across a spectrum of clinical services and specialties. These CIS are computer-based systems used to gather, store, and integrate clinical data on patients to the VA’s electronic health record (EHR). These systems may be implemented and used at single VA Medical Center (VAMC) locations, or across entire health care systems at the Veteran Integrated Service Network (VISN) or national levels.
The VA is in the process of transitioning to new CIS for specific clinical solutions as part of national standardization efforts, which introduces a need to retain or migrate the legacy CIS data for a particular endoscopy information system (EIS) in alignment with VA policies. The VA is interested in procuring services to help consolidate legacy SQL databases from disparate VAMC throughout the country into a single SQL server management platform and build customized reporting tools that will allow clinical stakeholders to review this historical data to aid in clinical decision making and optimizing future care. This specific procurement will include several VAMC across VHA as outlined in Addendum C.
APPLICABLE DOCUMENTS
In the performance of the tasks associated with this Performance Work Statement, the Contractor shall comply with the following:
1. “Federal Information Security Modernization Act of 2014”
2. Federal Information Processing Standards (FIPS) Publication 140-3, “Security Requirements for Cryptographic Modules”, March 22, 2019
3. FIPS Pub 199. “Standards for Security Categorization of Federal Information and Information Systems,” February 2004
4. FIPS Pub 200, “Minimum Security Requirements for Federal Information and Information Systems,” March 2006
5. FIPS Pub 201-3, “Personal Identity Verification of Federal Employees and Contractors,” January 2022
6. 10 U.S.C. § 2224, "Defense Information Assurance Program", as amended
7. 5 U.S.C. § 552a, as amended, “The Privacy Act of 1974”
8. Public Law 109-461 (P.L. 109-461), Veterans Benefits, Health Care, and Information Technology Act of 2006, as amended, Title IX, Information Security Matters
9. 42 U.S.C. § 2000d “Title VI of the Civil Rights Act of 1964”, as amended
10. VA Directive 0710, “Personnel Vetting Program,” September 8, 2025, https://www.va.gov/vapubs/index.cfm
11. VA Handbook 0710, “Personnel Vetting Program,” September 8, 2025, https://www.va.gov/vapubs/index.cfm
12. VA Directive 6102, “Internet/Intranet Services,” August 5, 2019
13. 36 C.F.R. Part 1194 “Information and Communication Technology Standards and Guidelines,” as amended
14. Office of Management and Budget (OMB) Circular A-130, “Managing Federal Information as a Strategic Resource,” July 28, 2016
15. 32 C.F.R. Part 199, “Civilian Health and Medical Program of the Uniformed Services (CHAMPUS)”, as amended
16. NIST SP 800-66 Rev. 2, “Implementing the Health Insurance Portability and Accountability Act (HIPAA) Security Rule: A Cybersecurity Resource Guide,” February 2024
17. 45 C.F.R Parts 160 and 164, Subparts A and E, the Standards for Privacy of Individually Identifiable Health Information (“Privacy Rule”); and 45 C.F.R. Parts 160 and 164, Subparts A and C, the Security Standard (“Security Rule”); as amended
18. Sections 504 and 508 of the Rehabilitation Act (29 U.S.C. § 794d), as amended
19. Homeland Security Presidential Directive (12) (HSPD-12), August 27, 2004
20. VA Directive 6500, “VA Cybersecurity Program,” February 24, 2021 (see VA NOTICE 24-18, dated September 27, 2024, “Update to VA Directive 6500 Cybersecurity Program”, and VA Notice 25-07, dated 3/18/25, “Amending VA Directive 6500 to incorporate M-24-15”)
21. VA Handbook 6500, “Risk Management Framework for VA Information Systems VA Information Security Program,” February 24, 2021 (see VA Notice 25-01, dated October 15, 2024, “Update to VA Handbook 6500 Risk Management Framework for VA Information Systems VA Information Security Program”, and VA Notice 25-06, dated 3/18/25, “Amending VA Directive 6500 to incorporate M-24-15”, VA Notice 25-16, dated September 15, 2025, “Amending VA Handbook 6500 to Replace Enterprise Mission Assurance Support Services Tool With Office of Information Technology Governance Risk Compliance Tool, and VA Notice 25-17, dated September 22, 2025, “Rescission Of Office Of Information Security (OIS) Deputy Assistant Secretary (DAS) Memorandum – Requirements of Proper Plan of Action and Milestones (POA&M) Completion)
22. VA Handbook 6500.2, “Management of Breaches Involving Sensitive Personal Information (SPI),” June 30, 2023
23. VA Handbook 6500.6, “Contract Security,” March 12, 2010 (see VA Notice 24-12, dated April 22, 2024, “Update to VA Handbook 6500.6, Contract Security, Appendix C VA Information and Information System Security/Privacy Language For Inclusion Into Contracts, As Appropriate”)
24. VA Handbook 6500.8, “Information System Contingency Planning,” March 25, 2025
25. VA Handbook 6500.10, “Mobile Device Security Policy,” February 15, 2018 (see VA NOTICE 25-10, dated June 9, 2025, “Use of Personally Owned Mobile Devices Policy Amendment of Department of Veterans Affairs Handbook 6500.10”, and VA Notice 25-15, dated August 22, 2025, “Update to VA Handbook 6500.10 Mobile Device Security Policy”)
26. VA Handbook 6500.11, “VA Firewall Configuration,” August 22, 2017
27. OIT Process Asset Library (PAL), OIT Process Asset Library.
28. One-VA Technical Reference Model (TRM) (reference at https://www.va.gov/trm/TRMHomePage.aspx)
29. VA Directive 6508, “Implementation of Privacy Threshold Analysis and Privacy Impact Assessment,” October 15, 2014
30. VA Directive 6510, “VA Identity, Credential and Access Management,” September 3, 2024
31. VA Handbook 6510, “VA Identity, Credential and Access Management,” September 27, 2024
32. VA Directive and Handbook 6513, “Secure External Connections,” October 12, 2017
33. VA Directive 6300, “Records and Information Management,” September 21, 2018
34. VA Handbook, 6300.1, “Records Management Procedures,“ March 24, 2010
35. NIST SP 800-37 Rev 2, “Risk Management Framework for Information Systems and Organizations: A System Life Cycle Approach for Security and Privacy,” December 2018
36. NIST SP 800-53 Rev. 5, “Security and Privacy Controls for Federal Information Systems and Organizations,” September 23, 2020 (includes updates as of 12/10/2020)
37. VA Directive 0735, “Homeland Security Presidential Directive 12 (HSPD-12) Program,” October 26, 2015
38. VA Handbook 0735, “Homeland Security Presidential Directive 12 (HSPD-12) Program,” March 24, 2014
39. OMB Memorandum 05-24, “Implementation of Homeland Security Presidential Directive (HSPD) 12 – Policy for a Common Identification Standard for Federal Employees and Contractors,” August 5, 2005
40. OMB Memorandum M-19-17, “Enabling Mission Delivery Through Improved Identity, Credential, and Access Management,” May 21, 2019
41. OMB Memorandum, “Guidance for Homeland Security Presidential Directive (HSPD) 12 Implementation,” May 23, 2008
42. Federal Identity, Credential, and Access Management (FICAM) Architecture, June 30, 2023 (FICAM Architecture (idmanagement.gov))
43. NIST SP 800-116 Rev 1, “Guidelines for the Use of Personal Identity Verification (PIV) Credentials in Facility Access,“ June 2018
44. NIST SP 800-63 Rev 4, 800-63A-4, 800-63B-4, 800-63C-4, “Digital Identity Guidelines,” August 1, 2025
45. NIST SP 800-157, “Guidelines for Derived PIV Credentials,” December 2014
46. VA Memorandum, VAIQ #7100147, “Continued Implementation of Homeland Security Presidential Directive 12 (HSPD-12),” April 29, 2011 (reference https://www.voa.va.gov/documentlistpublic.aspx?NodeID=514)
47. IAM Identity Management Business Requirements Guidance document, May 2013, (reference Enterprise Architecture Section, PIV/IAM (reference https://www.voa.va.gov/documentlistpublic.aspx?NodeID=514)
48. VA Memorandum “Personal Identity Verification (PIV) Logical Access Policy Clarification,” July 17, 2019, https://www.voa.va.gov/DocumentView.aspx?DocumentID=4896
49. Trusted Internet Connections (TIC) 3.0 Core Guidance Documents, https://www.cisa.gov/publication/tic-30-core-guidance-documents
50. OMB Memorandum M-19-26, “Update to the Trusted Internet Connections (TIC) Initiative,” September 12, 2019
51. OMB Memorandum M-08-23, “Securing the Federal Government’s Domain Name System Infrastructure,” August 22, 2008
52. Sections 524 and 525 of the Energy Independence and Security Act of 2007, (P.L. 110–140), December 19, 2007
53. Section 104 of the Energy Policy Act of 2005, (P.L. 109–58), August 8, 2005
54. Executive Order 13221, “Energy-Efficient Standby Power Devices,” August 2, 2001
55. Executive Order 14148, “Initial Rescissions of Harmful Executive Orders and Actions,” dated January 20, 2025
56. VA Directive 0057, “VA Environmental Management Program,” October 25, 2022
57. OIS VAIQ #7424808 Memorandum, “Remote Access,” January 15, 2014, https://www.voa.va.gov/DocumentListPublic.aspx?NodeId=28
58. Clinger-Cohen Act of 1996, 40 U.S.C. §11101 and §11103
59. “Veteran Focused Integration Process (VIP) Guide 4.0,” March 2021, https://www.voa.va.gov/DocumentView.aspx?DocumentID=4371
60. VA Memorandum “Proper Use of Email and Other Messaging Services,” January 2, 2018, https://www.voa.va.gov/DocumentListPublic.aspx?NodeId=28
61. “Product Line Management Transformation Playbook” version 3.1, August 2023, https://www.voa.va.gov/DocumentView.aspx?DocumentID=4946
62. NIST SP 500-267B Revision 1, “USGv6 Profile,” November 2020
63. OMB Memorandum M-21-07, “Completing the Transition to Internet Protocol Version 6 (IPv6),” November 19, 2020
64. Social Security Number (SSN) Fraud Prevention Act of 2017
65. Section 240 of the Consolidated Appropriations Act (CAA) 2018, March 23, 2018
66. C.F.R Title 15 Part 7, “Securing the Information and Communications Technology and Services (ICTS) Supply Chain”, as amended
67. Executive Order 14028, “Executive Order on Improving the Nation's Cybersecurity,” May 12, 2021, https://bidenwhitehouse.archives.gov/briefing-room/presidential-actions/2025/01/16/executive-order-on-strengthening-and-promoting-innovation-in-the-nations-cybersecurity/
68. OMB Memorandum M-22-09, “Moving the U.S. Government Toward Zero Trust Cybersecurity Principles”, January 26, 2022, https://www.whitehouse.gov/wp-content/uploads/2022/01/M-22-09.pdf.
69. NIST SP 800-52 Revision 2, “Guidelines for the Selection, Configuration, and Use of Transport Layer Security (TLS) Implementations
70. OMB M-26-05, “Adopting a Risk-based Approach to Software and Hardware Security,” January 23, 2026
71. OMB M-21-31, “Improving the Federal Government’s Investigative and Remediation Capabilities Related to Cybersecurity Incidents,” August 27, 2021
72. NIST SP 800-88 Revision 1 “Guidelines for Media Sanitization,” December 2014
73. CISA Binding Operational Directive (BOD) 19-02: “Vulnerability Remediation Requirements of Internet-Accessible Systems,” April 29, 2019, BOD 19-02: Vulnerability Remediation Requirements for Internet-Accessible Systems | CISA
74. CISA BOD 22-01: “Reducing the Significant Risk of Known Exploited Vulnerabilities,” November 3, 2021, BOD 22-01: Reducing the Significant Risk of Known Exploited Vulnerabilities | CISA
75. CISA BOD 23-01: Improving Asset Visibility and Vulnerability Detection on Federal Networks.” Cybersecurity & Infrastructure Security Agency (CISA), BOD 23-01: Improving Asset Visibility and Vulnerability Detection on Federal Networks | CISA
76. VA Directive 6550, Pre-Procurement Assessment and Implementation of Medical Devices/Systems, June 03, 2019
77. VA Memorandum, “VA Security Controls,” January 17, 2025, https://www.voa.va.gov/DocumentView.aspx?DocumentID=5010
78. E.O. 13960, “Promoting the Use of Trustworthy Artificial Intelligence in the Federal Government,” December 3, 2020
79. E.O. 14319, “Preventing Woke AI in the Federal Government,” July 23, 2025
80. OMB Memorandum M-25-21, “Accelerating Federal Use of AI through Innovation, Governance, and Public Trust,” April 3, 2025
81. OMB Memorandum M-25-22, “Driving Efficient Acquisition of Artificial Intelligence in Government,” April 3, 2025
82. OMB Memorandum M-26-04, “Increasing Public Trust in Artificial Intelligence (AI) Through Unbiased AI Principles,” December 11, 2025
SCOPE OF WORK
The Contractor shall provide project management and implementation services to incorporate disparate SQL databases for the legacy CIS into a national SQL management server provided and licensed by VA. Analysis of the CIS SQL database structure will be required to understand the schema and data element relationships.
Using the data from these imported SQL databases, the Contractor shall use either SQL server reporting services (SSRS) or PowerBI reports to develop a reporting system with a graphical user interface (GUI) that allows users to run customized reports with specific input and output data. The Contractor shall develop and provide up to ten customized reports as specified based on the requirements outlined in this PWS. Access to the reporting system must be web based and allow for VA managed permissions based on active directory (AD) credentialling. The reporting system must be scalable and allow for importing of future like-in-kind databases if needed.
The Contractor shall provide training on the use, management, and sustainment of the reporting system in conjunction with the implementation phase of the project.
PERFORMANCE DETAILS
PERFORMANCE PERIOD
The period of performance (PoP) shall be 12 months from the date of award, with optional tasks for additional custom reports. Additionally, there shall be four 12-month option periods for ongoing technical support.
Any work at the Government site shall not take place on Federal holidays or weekends unless directed by the Contracting Officer (CO). There may be instances during deployment or system upgrades where work may need to occur on Weekends, Holidays, Evening, or Nights (WHEN hours). In those instances, the work schedule needs to occur with express permission from the Contracting Officer’s Representative or local Point of Contact (POC) in writing.
There are 11 Federal holidays set by law (USC Title 5 Section 6103) that VA follows:
Under current definitions, five are set by date:
| New Year's Day | January 1 | |
| Juneteenth | June 19 | |
| Independence Day | July 4 | |
| Veterans Day | November 11 | |
| Christmas Day | December 25 |
If any of the above falls on a Saturday, then Friday shall be observed as a holiday. Similarly, if one falls on a Sunday, then Monday shall be observed as a holiday.
The other six are set by a day of the week and month:
| Martin Luther King's Birthday | Third Monday in January |
| Washington's Birthday | Third Monday in February |
| Memorial Day | Last Monday in May |
| Labor Day | First Monday in September |
| Columbus Day | Second Monday in October |
| Thanksgiving | Fourth Thursday in November |
PLACE OF PERFORMANCE
All tasks under this PWS shall be performed remotely by the contractor using PIV or MOU/ISA credentialed remote access to the VA provisioned SQL server with authorization from VA systems owners. This includes all database analysis, reporting system creation, reports development, and training deliverables.
TRAVEL
The Government anticipates no travel is required in the scope of this project to perform the tasks associated with the effort.
SPECIFIC TASKS AND DELIVERABLES
The Contractor shall perform the following:
PROJECT MANAGEMENT
CONTRACTOR PROJECT MANAGEMENT PLAN
The Contractor shall deliver a Contractor Project Management Plan (CPMP) that lays out the Contractor’s approach, timeline, and tools to be used in execution of the contract. The CPMP should take the form of both a narrative and graphic format that displays the schedule, milestones, risks, and resource support. The CPMP shall also include how the Contractor shall coordinate and execute planned, routine, and ad hoc data collection reporting requests as identified within the PWS. The initial baseline CPMP shall be concurred upon and updated in accordance with Section B of the contract. The Contractor shall update and maintain the VA Program Manager (PM) approved CPMP throughout the PoP.
Deliverable:
A. Contractor Project Management Plan
REPORTING REQUIREMENTS
The Contractor shall provide the COR with monthly Progress Reports in electronic form in Microsoft Word and Project formats. The report shall include detailed instructions/explanations for each required data element, to ensure that data is accurate and consistent. These reports shall reflect data as of the last day of the preceding month.
The monthly progress Reports shall cover all work completed during the reporting period and work planned for the subsequent reporting period. The report shall also identify any problems that arose and a description of how the problems were resolved. If problems have not been completely resolved, the Contractor shall provide an explanation including their plan and timeframe for resolving the issue. The report shall also include an itemized list of all Information and Communication Technology (ICT) deliverables and their current Section 508 conformance status. The Contractor shall monitor performance against the CPMP and report any deviations. It is expected that the Contractor will keep in communication with VA accordingly so that issues that arise are transparent to both parties to prevent escalation of outstanding issues.
Deliverable:
A. Monthly Progress Report
DATABASE INFRASTRUCTURE & ANALYSIS
The VA will host a dedicated SQL server 2022 instance to consolidate legacy CIS SQL databases from VAMCs nationwide. This effort will include cloning and migrating each site’s legacy CIS SQL database to the consolidated SQL server. Contractors will receive read only access to the restored/cloned databases.
The Contractor shall provide services to analyze the structure of the cloned SQL databases to identify the structure and variables required based on the reporting development requirements listed in section 5.4. A database structure analysis report will be provided prior to reports development and reviewed with the VA to confirm all reporting elements have been identified.
The characteristics of the legacy CIS database are as follows:
· Databases cloned from Microsoft SQL Server versions 2014 – 2019 (most from 2014 or 2016)
· All databases are from the same Endoscopy Information System solution
· Average database size is 100-200 GB per VAMC
· Average number of tables in the database is 300
· Database includes images that are taken in JPEG format but reside directly in the SQL database in hash format in specified tables
· Legacy data will not be changing so each database imported will be static in size
Deliverable:
A. Database structure analysis report
REPORTING DEVELOPMENT ENVIRONMENT (RDE)
The Contractor shall provide services to establish a reporting development environment that will display reports and data structures from the SQL databases. The requirements of the reporting development environment are as follows:
1. The reporting development environment shall use either SQL Server Reporting Services (SSRS) in tandem with Visual Studio/Business Intelligence Development Studio (BIDS), or PowerBI online, to develop and deploy customized reports.
a. The vendor shall provide a capability statement summarizing qualifications and past project examples demonstrating competency in at least one of the two options.
2. The reporting development environment shall support exports in Microsoft Excel and PDF formats.
3. The reporting development environment shall support web-based access for viewing, managing, and organizing reports.
4. The reporting development environment shall allow for managing data structures organized by site, VISN, or national level access.
5. Microsoft Entra ID authentication shall be implemented to restrict access to VA active directory users by VAMC, VISN, or national level access tiers using client PIV credentials.
6. All configurations, role assignments, and access controls shall adhere to VA data security, privacy, and applicable HIPAA requirements.
Deliverables:
A. Capability statement summarizing qualifications and past project examples demonstrating competency in SSRS and/or PowerBI Online.
B. Implementation of a reporting development environment meeting requirements listed in section 5.3.
CUSTOMIZED REPORTS DEVELOPMENT
The Contractor shall provide services to create custom reports based on the VA’s legacy SQL databases consolidated on the national archive server, using the reporting development environment.
1. The specific reports required by VA are shown in Table 1 below.
| Report # |
| Report Input(s) |
| Report Output(s) |
| Comments |
| 1 |
| · Instrument model |
| · List of procedure encounter numbers associated with the instrument model |
· Corresponding serial number
· Patient name
· Procedure encounter date Needed for endoscopy recall/safety alert management.
| 2 |
| · Provider Name |
| · List of procedure encounter numbers performed by the provider |
· Corresponding Procedure type for each procedure encounter
· Corresponding date of each procedure encounter QC/ clinician metrics
| 3 |
| · Patient name |
· Date of Birth (DOB)
· List of procedure names
· Corresponding dates of procedures
· Corresponding procedure encounter numbers
· Legacy procedure review
| 4 |
| · Procedure Encounter Number |
| · Associated Information for the procedure encounter including: |
· Procedure date
· Patient name
· Date of birth
· Instruments used
· Procedure name
· Indication
· Physician
· Medications
· Procedure technique
· Quality of bowel prep
· Extent of exam
· Findings
· Recommendations
· Colonoscopy withdrawal time
· Procedure images
· Detailed legacy procedure review with images
| 5 |
| · Procedure encounter number |
| · All associated procedure images for the encounter |
| · Legacy procedure review focused on endoscope images |
| 6 |
| Ad hoc report – VA to clarify requirements prior to closure of period of performance |
| 7 |
| Ad hoc report – VA to clarify requirements prior to closure of period of performance |
| 8 |
| Ad hoc report – VA to clarify requirements prior to closure of period of performance |
| 9 |
| Ad hoc report – VA to clarify requirements prior to closure of period of performance |
| 10 |
| Ad hoc report – VA to clarify requirements prior to closure of period of performance |
2. The reports must function for all VAMC SQL databases cloned and uploaded to the national archive SQL server.
3. Progress on the development of reports should be included in the monthly project management reports.
4. Upon completion of each of the reports, the COR will conduct a quality assurance test with the contractor using a sample size of three VAMC databases which must be passed with respect to report input/output functionality. This will be documented in a custom reports development quality assurance (QA) report.
Deliverables:
A. Custom CIS legacy data reports meeting the requirements outlined in section 5.4, Table 1.
B. Custom reports QA report documenting whether reporting functionality meets VA requirements for all ingested databases.
REPORTING DEVELOPMENT ENVIRONMENT SYSTEM ADMINISTRATOR AND SUSTAINMENT TRAINING
The Contractor shall provide training as follows:
1. The Contractor shall provide power-user and system administrator training on the use and sustainment of the reporting develop environment system and production reporting structure.
2. The Contractor shall provide quick reference guides for the following key tasks:
a. Completing user/group reports access change management for VAMC/VISN/national tiers.
b. Extending reporting structure to any future databases that may be added.
c. Any database cleanup/restructuring processes that may be required as part of the database ingestion within the development environment system.
d. Basic troubleshooting for any report generation errors.
e. How reporting structure can be backed up in the event of a server failure.
3. The Contractor shall provide all usernames/passwords created during the report development process to VA for continuing system sustainment.
Deliverables:
A. System administrator training plan and attendance documentation.
B. Reporting development environment username and passwords.
C. Quick reference guides.
CUSTOMER SUPPORT
The Contractor shall provide technical support after reports from section 5.4, Table 1 have been validated and documented on the custom reports QA document deliverable. The technical support shall include:
1. Reports generation troubleshooting.
2. Active directory single sign on (SSO) functionality troubleshooting.
3. Repair of any bugs found in the reports development and input/output functionality.
4. Re-implementation/recovery of the reporting structure in the event of a server failure.
5. A quarterly summary report of technical support requests and resolutions.
Deliverables:
A. Technical support for after reports from section 5.4, Table 1 have been validated and documented on the custom reports QA document deliverable.
B. Quarterly summary report.
OPTION PERIODS
The Contractor shall provide customer support to help maintain and modify the fully functioning national reporting solution in alignment with the customer support requirement defined in section 5.6 1-5, as four 12-month option periods.
Deliverables:
A. Technical support for all reports and reporting infrastructure in alignment with PWS 5.6, 1-5.
B. Quarterly summary report.
GENERAL REQUIREMENTS
ENTERPRISE AND IT FRAMEWORK
VA TECHNICAL REFERENCE MODEL
The Contractor shall comply with the VA OIT Technical Reference Model (VA TRM). Compliance with the VA TRM is achieved by using only technologies and standards that are listed as approved for use in the VA TRM. The Contractor shall provide all necessary information requested by VA to ensure TRM approval is obtained prior to use on VA’s network.
ZERO TRUST – VA CRITICAL SECURITY CONTROLS
VA has established minimum mandatory security requirements and requires that any network connected software system or service must meet the VA Critical Security Controls as outlined in the VA Memorandum, “VA Security Controls”, https://www.voa.va.gov/DocumentView.aspx?DocumentID=5010. VA Critical Security Controls identify the minimum mandatory requirements that must be implemented across all VA enterprise infrastructure, cloud computing environments, information systems, networks, and specialized devices (medical devices/systems, special-purpose systems, and research scientific computing devices) that process, store, and/or transmit VA data. Effective July 1, 2025, the Contractor shall implement these VA Critical Security Controls, within any network connected software system or service prior to being authorized for use in the VA. This functional requirement is not negotiable, and Plan of Action & Milestones (POAM) will not be accepted in the event these controls cannot be implemented for new systems. Critical Security Controls are intended to increase VA’s security posture and provide security and privacy risk visibility into the VA network and is not a new requirement. The Contractor’s failure to maintain these VA Critical Controls after implementation will result in VA discontinuing the use of the system.
FEDERAL IDENTITY, CREDENTIAL, AND ACCESS MANAGEMENT (FICAM)
The Contractor shall ensure Commercial Off-The-Shelf (COTS) product(s), software configuration and customization, and/or new software are Personal Identity Verification (PIV) card-enabled by accepting HSPD-12 PIV credentials using VA Enterprise Architecture (EA), and VA Identity and Access Management (IAM) approved Enterprise Technology Guidelines (ETG). The Contractor shall ensure all Contractor delivered applications and systems comply with the VA Identity, Credential, and Access Management policies and guidelines set forth in Executive Order 14028, VA Handbook 6510 VA Identity and Access Management, VA Handbook 0735 Homeland Security Presidential Directive 12 (HSPD-12) Program, CISA Binding Operational Directive 23-01, and align with the Federal Identity, Credential, and Access Management Roadmap and Implementation Guidance v2.0.
The Contractor shall ensure all Contractor delivered applications and systems provide user authentication services compliant with the National Institute of Standards and Technology (NIST) Special Publication (SP) 800-63-3, VA Handbook 6500, and VA IAM enterprise requirements for direct, assertion based authentication, and/or trust based authentication, as determined by the ETGs. Direct authentication at a minimum must include Public Key Infrastructure (PKI) based authentication supportive of PIV card and/or Common Access Card (CAC), as determined by the business need.
The Contractor shall ensure all Contractor delivered applications and systems conform to the specific Identity and Access Management PIV requirements set forth in the Office of Management and Budget (OMB) Memoranda M-05-24, M-19-17, M-22-09, and NIST Federal Information Processing Standard (FIPS) 201-3. Contractor delivered applications and systems shall be on the FIPS 201 Approved Product List (APL). If the Contractor delivered application and system is not on the APL, the Contractor shall be responsible for taking the application and system through the FIPS 201 Evaluation Program.
The Contractor shall ensure all Contractor delivered applications and systems support:
1. Automated provisioning and are able to use enterprise provisioning service.
2. Interfacing with VA’s Master Person Index (MPI) to provision identity attributes, if the solution relies on VA user identities. MPI is the authoritative source for VA user identity data.
3. The VA defined unique identity (Secure Identifier [SEC ID] / Integrated Control Number [ICN]).
4. Multiple authenticators for a given identity and authenticators at every Authenticator Assurance Level (AAL) appropriate for the solution.
5. Identity proofing for each Identity Assurance Level (IAL) appropriate for the solution.
6. Federation for each Federation Assurance Level (FAL) appropriate for the solution, if applicable.
7. Two-factor authentication (2FA) through an applicable Technology Guideline as outlined in VA ETG.
8. A Security Assertion Markup Language (SAML) implementation if the solution relies on assertion-based authentication. Additional assertion implementations, besides the required SAML assertion, may be provided as long as they are compliant with NIST SP 800-63-3 guidelines.
9. Authentication/account binding based on trusted Hypertext Transfer Protocol (HTTP) headers if the solution relies on Trust based authentication.
10. Role Based Access Control.
11. Auditing and reporting capabilities.
12. Compliance with VIEWS 00155984, PIV Logical Access Policy Clarification https://www.voa.va.gov/DocumentView.aspx?DocumentID=4896.
The required Assurance Levels for this specific effort are Identity Assurance Level 3, Authenticator Assurance Level 3, and Federation Assurance Level 3.
INTERNET PROTOCOL VERSION 6 (IPv6)
The Contractor solution shall support IPv6-Only based upon the memo issued by the Office of Management and Budget (OMB) on November 19, 2020 (https://www.whitehouse.gov/wp-content/uploads/2020/11/M-21-07.pdf). Which defines IPv6-only as the state of an operational system or service when IPv4 protocol functions (addressing, packet forwarding) are not in use. The NIST USGv6 profile defines technical requirements for a product to be capable of operating in IPv6-Only environments. IPv6-Only technology, in accordance with the USGv6 Program (https://www.nist.gov/programs-projects/usgv6-program/usgv6-revision-1), NIST Special Publication (SP) 500-267B Revision 1 “USGv6 Profile” (https://doi.org/10.6028/NIST.SP.500-267Br1), and NIST SP 800-119 “Guidelines for the Secure Deployment of IPv6” (https://doi.org/10.6028/NIST.SP.800-119), compliance shall be included in all IT infrastructures, application designs, application development, operational systems and sub-systems, and their integration. In addition to the above requirements, all devices, applications, and systems shall support all applicable functionality on native IPv6-Only as well as dual stack (IPv6 / IPv4) connectivity without additional memory or other resources being provided by the Government, so that they can function in a mixed environment. All public/external facing servers and services (e.g., web, email, DNS, ISP services, etc.) shall support native IPv6-Only and dual stack (IPv6 / IPv4) users and all internal infrastructure and applications shall support using native IPv6-Only and dual stack (IPv6 / IPv4) for all functionality and operations.
TRUSTED INTERNET CONNECTION (TIC)
The Contractor solution shall meet the requirements outlined in Office of Management and Budget Memorandum M-19-26, “Update to the Trusted Internet Connections (TIC) Initiative“ (https://www.whitehouse.gov/wp-content/uploads/2019/09/M-19-26.pdf), VA Directive 6513 “Secure External Connections”, and shall comply with the TIC 3.0 Core Guidance Documents, including all Volumes and TIC Use Cases, found at the Cybersecurity & Infrastructure Security Agency (CISA) (https://www.cisa.gov/publication/tic-30-core-guidance-documents).
STANDARD COMPUTER CONFIGURATION
The Contractor IT end user solution that is developed for use on standard VA computers shall be compatible with and be supported on the standard VA operating system, Windows 11, Edge (Chromium based), and 365 Apps for enterprise. Applications delivered to VA and intended to be deployed to Windows 11 workstations shall be delivered as a signed .msi package with switches for silent and unattended installation and updates shall be delivered in signed .msp file formats for easy deployment using Microsoft Endpoint Configuration Manager (CM) VA’s current desktop application deployment tool. Signing of the software code shall be through a vendor provided certificate that is trusted by VA using a code signing authority such as Verizon/Cybertrust or Symantec/VeriSign. The Contractor shall also ensure and certify that their solution functions as expected when used from a standard VA computer, with non-admin, standard user rights that have been configured using the Defense Information Systems Agency (DISA) Secure Technical Implementation Guide (STIG) specific to the particular client operating system being used.
VETERAN FOCUSED INTEGRATION PROCESS (VIP) AND PRODUCT LINE MANAGEMENT (PLM)
The Contractor shall support VA efforts IAW the Veteran-Focused Integration Process (VIP) Guide and Product Line Management (PLM) Playbook. The major focus of VIP is on Enterprise Oversight, Governance, reporting, and establishing practices that focus on outcomes and continuously delivering sustainable IT capabilities to benefit the Veteran. PLM is a framework that focuses on delivering functional products that provide the highest priority work to customers while delivering simplified, reliable, and practical solutions to the business, medical staff, and our Veterans. The VIP Guide is a companion guide to the PLM Transformation Playbook and can be found at: https://www.voa.va.gov/DocumentView.aspx?DocumentID=4371 and the PLM Transformation Playbook can be found at https://www.voa.va.gov/DocumentView.aspx?DocumentID=4946. VIP and PLM are the authoritative processes that IT projects must follow to ensure development and delivery of IT products.
The VIP Guide provides guidance for transitioning from project-centric to product-centric delivery. The VIP guide applies to all OIT Office of Management and Budget (OMB) reportable products that are required to collect and report costs, schedules, risks, and other valuable information in VA PARS (whether products are procured or developed by VA) and any VA Information Technology project effort in Software Product Management (SPM) and Infrastructure Operations (IO), or their successors, that touch the VA network regardless of IT organizational alignment (whether it spends government funding from VA's Congressional IT Appropriation or any other appropriation).
The PLM Transformation Playbook details how OIT leadership expects Product Lines (PLs) to implement PLM, DevOps, and Lean-Agile principles, methods, practices, and techniques through levels of maturity. The PLM Transformation Playbook applies to all Information Technology (IT) products aligned to PLs in the Software Product Management, Infrastructure Operations and Product Engineering organizations within the OIT organization.
Others outside the referenced groups or organizations may use the VIP Guide and PLM Transformation Playbook for situational awareness as needed.
PROCESS ASSET LIBRARY (PAL)
The Contractor shall perform their duties consistent with the processes defined in the OIT Process Asset Library (PAL). The PAL includes a spectrum of OIT functions and activities, such as project management, operations, service delivery, communications, acquisition, and resource management. PAL serves as an authoritative and informative repository of searchable processes, activities or tasks, roles, artifacts, tools and applicable standards and guides to assist the OIT workforce, Government and Contractor personnel. OIT utilizes PAL processes to ensure compliance with policies and regulations and to meet VA quality standards. The PAL includes the contractor onboarding process consistent with Section 6.2.2 and can be found at process_CONB_ext.docx (live.com). The main PAL can be accessed at www.va.gov/process.
AUTHORITATIVE DATA SOURCES
The VA Enterprise Architecture Repository (VEAR) is one component within the overall EA that establishes the common framework for data taxonomy for describing the data architecture used to develop, operate, and maintain enterprise applications. The Contractor shall comply with the department’s Authoritative Data Source (ADS) requirement that VA systems, services, and processes throughout the enterprise shall access VA data solely through official VA ADSs where applicable, see below. The Information Classes which compose each ADS are located in the VEAR, in the Data & Information domain. The Contractor shall ensure that all delivered applications and system solutions support:
1. Interfacing with VA’s Master Person Index (MPI) (formerly the Master Veteran Index (MVI)) to provision identity attributes, if the solution relies on VA user identities. MPI is the authoritative source for VA user identity data.
2. Interfacing with Capital Asset Inventory (CAI) to conduct real property record management actions, if the solution relies on real property records data. CAI is the authoritative source for VA real property record management data.
3. Interfacing with electronic Contract Management System (eCMS) for access to contract, contract line item, purchase requisition, offering vendor, and solicitation information above the micro-purchase threshold, if the solution relies on procurement data. ECMS is the authoritative source for VA procurement actions data.
4. Interfacing with HRSmart Human Resources Information System to conduct personnel action processing, on-boarding, benefits management, and compensation management, if the solution relies on personnel data. HRSmart is the authoritative source for VA personnel information data.
5. Interfacing with VA Profile to access personal contact information, if the solution relies on VA Veteran personal contact information data. VA Profile is the authoritative source for VA Veteran Personal Contact Data.
6. Interfacing with VA/Department of Defense (DoD) Identity Repository (VADIR) for determining eligibility for VA benefits under Title 38, if the solution relies on qualifying active duty military service data. VADIR is the authoritative source for qualifying active duty military service in VA.
7. Interfacing with VA Systems Inventory (VASI) to access VA systems information, if the solution relies on VA system information. VASI is the authoritative source for VA Information Technology systems.
8. Interfacing with Enterprise Mission Assurance Support Service (eMASS) to access the historical Authority to Operate (ATO) status of all VA Information Systems prior to migrating to ServiceNow Continuous Authorization and Monitoring (SNowCAM) until it is determined the migration is completed and eMASS is sunset. eMASS contains the historical Authority to Operate (ATO) status of all VA Information Systems prior to September 30, 2025, with all status provided through SNowCAM once migration is completed.
SOCIAL SECURITY NUMBER (SSN) REDUCTION
The Contractor solution shall support the Social Security Number (SSN) Fraud Prevention Act (FPA) of 2017 which prohibits the inclusion of SSNs on any document sent by mail. The Contractor support shall also be performed in accordance with Section 240 of the Consolidated Appropriations Act (CAA) 2018, enacted March 23, 2018, which mandates VA to discontinue using SSNs to identify individuals in all VA information systems as the Primary Identifier. The Contractor shall ensure that any new IT solution discontinues the use of SSN as the Primary Identifier to replace the SSN with the ICN in all VA information systems for all individuals. The Contractor shall ensure that all Contractor delivered applications and systems integrate with the VA MPI for identity traits to include the use of the ICN as the Primary Identifier. The Contractor solution may only use a Social Security Number to identify an individual in an information system if and only if the use of such number is required to obtain information VA requires from an information system that is not under the jurisdiction of VA.
GENERATIVE ARTIFICIAL INTELLIGENCE REQUIREMENTS
If Artificial Intelligence (AI) is part of the Contractor system/solution, the Contractor shall be in compliance with E.O. 13960 and 14319, OMB Memorandums M-25-21, M-25-22, and M-26-04, and VA Directive and Handbook 6500 to support VA in trustworthy, secure, responsible, accountable, Truth Seeking, and Ideologically Neutral AI innovation.
No web-based, publicly available generative AI service has been approved for use with VA-sensitive data including, but not limited to OpenAI’s ChatGPT, Microsoft’s Copilot, Google’s Gemini, and Anthropic’s Claude. No PII, protected health information (PHI), or VA-sensitive data should be entered into these unapproved services. The entire definition of VA Sensitive Data can be found at 38 U.S.C. § 5727 (23). The Contractor shall protect VA Sensitive data from unauthorized disclosure or use, and from being used to train or improve the functionality of the vendor's commercial offerings without express permission from VA.
The Contractor shall deliver the services, technical data, configurations, models, weights, documentation or other information, including source code, developed during contract performance. The Contractor, in collaboration with VA, must evaluate the output of any AI tool for accuracy prior to using the output in VA efforts. All data, including models, weights, algorithms, and outputs generated using either Government-furnished data or data first developed under this contract shall be the property of the Government with unlimited rights as defined by FAR 52.227-14. The Contractor shall also deliver any custom-developed code developed with AI methodologies in accordance with the SHARE IT Act, if applicable. VA shall also retain unlimited rights to any improvements to that data, including the continued design, development, testing, and operation of AI systems and/or systems utilizing AI.
The Contractor shall ensure that all AI Systems, including Large Language Models (LLM), whether standalone LLMs or integrated into broader software platforms, procured under this effort and/or used in performance of this contract complies with the Unbiased AI Principles as defined in Executive Order 14319 and OMB Memorandum M-26-04, e.g. Truth Seeking and Ideologically Neutral, as applicable to the intended use of the system.
The Contractor shall ensure that AI System/LLM generated outputs are truthful in responding to user prompts seeking factual information or analysis, prioritize historical accuracy, scientific inquiry, and objectivity, as well as acknowledge uncertainty where reliable information is incomplete or contradictory and do not fabricate, hallucinate, or present unverifiable information as fact.
The Contractor shall ensure that LLMs and AI outputs are neutral, nonpartisan tools that do not manipulate responses in favor of ideological dogmas such as Diversity, Equity, and Inclusion (DEI). The Contractor shall ensure that the LLMs, including the AI System, are not intentionally encoded with partisan or ideological judgments within an AI System’s/LLM’s outputs unless those judgments are prompted by or otherwise readily accessible to the end user.
Compliance with the AI requirements of this contract, including adherence to the Unbiased AI Principles, Truth-Seeking and Ideological Neutrality requirements, disclosure obligations, monitoring and reporting requirements, and corrective action responsibilities, is a material condition of eligibility for payment and continued performance. In accordance with OMB Memorandum M-26-04, failure to comply with these requirements, or refusal to take timely and appropriate corrective action to remedy identified noncompliance, may constitute a material breach of contract and may result in remedies consistent with the terms of the contract and applicable law including but not limited to withholding of payment, termination for cause/default, or other appropriate contractual remedies, as determined by the Contracting Officer.
All AI for delivery and/or use in performance of the contract shall adhere to the VA Trustworthy AI Framework, available at https://department.va.gov/ai/trustworthy/. Once the Contractor has obtained CO authorization to use specific AI in contract performance, the Contractor shall provide the COR a signed Statement of Attestation prior to AI implementation as identified in the Artificial Intelligence in VA Contracts clause, to include its associated list of AI being used in contract performance.
Deliverable:
A. Statement of Attestation
AI SYSTEM/LLM DEVELOPMENT AND OPERATION DOCUMENTATION REQUIREMENTS
To enable Government continued assessment of compliance with Trustworthy AI requirements and both Unbiased AI Principles, Truth-seeking and Ideological Neutrality, in accordance with OMB M-26-04, the Contractor shall provide AI System/LLM Development and Operation Documentation Package to include, at a minimum:
1. Acceptable Use Policy
The Contractor shall provide an Acceptable Use Policy document governing its AI operation that characterizes and differentiates appropriate and inappropriate use of their product offering
1. Model Cards, System Cards and/or Data Cards
The Contractor shall provide documentation describing essential information about the model, system, and or data as it relates to the AI/LLM product offering. The documentation shall address summaries of training process, identified risks and mitigations, and model evaluation scores on LLM benchmarks at a minimum, where appropriate
1. End User Resources
The Contractor shall provide documentation to include product tutorials, developer guides, and/or other tools to assist VA in ensuring proper use of the AI/LLM to maximize utility
1. Mechanism for End User Feedback
The Contractor shall provide documentation describing the mechanism employed to provide feedback to the Offeror on outputs identified that violate the Unbiased AI Principles. This may be satisfied by a general inbox, specific Point of Contact, or similar feedback mechanism.
1. Pre-Training and Post-Training Activities of the AI System/LLM
The Contractor shall provide documentation of Pre-Training and Post Training Activity that provides details on:
4. Actions taken that impact the factuality and grounding of AI System/LLM outputs
4. System-level prompts that provide natural language instructions to the model specifying guidelines on responding to user-generated queries, to include how a model responds…
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 .