<p>{margintop=-15:The Data Warehouse utilizes Microsoft SQL Server Reporting Services (SSRS).}</p>
<p>The Clinical Quality Metrics Database (CQMD), located in the TRICARE Overseas Program (TOP) Data Warehouse, is accessible to Military Treatment Facility (MTF) and TRICARE Area Office (TAO) users and provides data regarding Purchased Care Sector Providers (PCSPs). The CQMD includes information relating to the providers such as the medical risk of the country, the National Quality Statistics (NQS) of the country, and the safety score for that provider. It also details the retrospective utilization summary and status of PQIs, as well as the summary episode of care data.</p>
<p>International SOS has posted the following useful resources, to assist in accessing, using and learning the SSRS platform:</p>
<ul>
<li>{downloaddocs=/government/tco-media/documents/TOP-DW-Migration-FAQs-Aug-2021:Frequently Asked Questions (FAQs)}</li>
<li>{sametab;showvideo=/government/tco-media/videos/Basics-of-SQL-Server-Reporting-for-TOP:TOP Data Warehouse Introductory Training Video}</li>
<li>{downloaddocs=/government/tco-media/documents/TOP-DW-Access-Req-Form-Aug-2021:Data Warehouse Access Form}</li>
<li>{downloaddocs=/government/tco-media/documents/TOP-DW-How-To-Request-Access:TOP Data Warehouse: How to Request Access and Log In}</li>
<li>{downloaddocs=/government/tco-media/documents/CQ-Metrics-DB-UG-Oct2021:Clinical Quality Metrics Database User Guide}</li>
</ul>
<p>International SOS offers a 24/7 Help Desk, which can be reached by telephone to assist existing Data Warehouse users with unlocking their accounts or other technical issues. Please note, you will find useful information by clicking the "Frequently Asked Questions (FAQs)" link above. Or, you may email <a href="mailto:TOPDataWarehouse@internationalsos.com" target="_blank">TOPDataWarehouse@internationalsos.com</a> or call {fontweight=500:1-800-697-0116} for assistance.</p>
<p>{fontweight=500:Note:} Please be sure to state that you are a "TOP Data Warehouse User" and have your Data Warehouse User ID ready to provide to the IT Help Desk Representative. </p>
<p>Click the image below to watch the TOP Data Warehouse Introductory Training Video posted on the Government Extranet site.</p>
<p><br></p>
<p><a href="https://www.tricare-overseas.com/media?source=/government/tco-media/videos/Basics-of-SQL-Server-Reporting-for-TOP" target="_blank"><img src="https://www.tricare-overseas.com/cms/delivery/media/MCRSLFTMROVNCJ7MCYMC7IIY3YFE" data-fileid="20Yt0000000bliO" data-contentkey="MCRSLFTMROVNCJ7MCYMC7IIY3YFE" data-cms-filename="training-video-preview-2.png"></a></p>
<p>* * * * * * * * * * * * * * * * * * *</p>
<p>Data Warehouse Accounts are for TRICARE Overseas Program Analysts within Military Treatment Facilities (MTF) or TRICARE Area Offices (TAO), and may be granted on an individual basis if required and approved.</p>
<p><a href="https://citrix.wpsic.com/vpn/index.html" target="_blank">Data Warehouse</a></p>
<p>The Data Warehouse is a single repository for Claims, Beneficiary Enrollment, Authorization, and Network information. The TRICARE Overseas Program Data Warehouse uses Microsoft SQL Server Reporting Services (SSRS) to facilitate queries and reports among key stakeholders in the TRICARE Overseas Program.</p>
<p>Access to the Microsoft SQL SSRS Data Warehouse will require CITRIX and an RSA Secure ID token. To obtain the required token, every user will need to complete a request form to be signed off by their commanding officer or immediate supervisor and the TRICARE Overseas Program COR. {downloaddocs=/government/tco-media/documents/TOP-DW-Access-Req-Form-Aug-2021:Click here} to download the TOP Data Warehouse Access Request Form.</p>
<p>{fontweight=500:Password Reset:}</p>
<p>{nomargin:Your account will automatically lock within 30 days if no activity occurs. Please be sure to log-in at least once every 30 days.}</p>
<p>{fontweight=lighter:<a href="mailto:TOPDataWarehouse@InternationalSOS.com?subject=COGNOS%20Data%20Warehouse%20-%20Government%20User%20Password%20Reset&body=***Data%20Warehouse%20Accounts%20are%20for%20TRICARE%20Overseas%20Program%20Analysts%20within%20Military%20Treatment%20Facilities%20(MTF)%20or%20TRICARE%20Area%20Offices%20(TAO),%20and%20may%20be%20granted%20on%20an%20individual%20basis%20if%20required%20and%20approved.***%0a%0aHello,%0a%0aI%20am%20a%20Government%20Analyst,%20MTF%20Administrator,%20or%20TAO%20Administrator%20and%20am%20trying%20to%20access%20my%20IBM%20COGNOS%20-%20TOP%20Data%20Warehouse%20Account.%0A%0AMy%20name%20is:%0A%0AUsername:%0A%0AKind%20regards,%0a%0a%0a" target="_blank">Request Password Reset</a>}</p>
<p>{fontweight=500:Note:} <i>To ensure optimal usability of the TOP Data Warehouse, please confirm you are using the newest supported version of </i><a href="https://support.microsoft.com/en-us/products/internet-explorer" target="_blank">Microsoft® Internet Explorer,</a><i> </i><a href="https://www.mozilla.org/en-US/firefox/new/" target="_blank">Mozilla Firefox,</a><i> or </i><a href="https://www.google.com/chrome/browser/desktop/index.html" target="_blank">Google® Chrome.</a> </p>