Skip to main content
Mitratech Success Center

Client Support Center

Need help? Click a product group below to select your application and get access to knowledge articles, webinars, training content, and release notes or to contact our support team.

Authorized users - log in to create a ticket, view tickets status and check your success plan details.


SQL Script to get the Frequency Rates module data from the CMO Data Warehouse Database


This article shares the SQL Script that can be applied on the CMO Data Warehouse database to get the CMO FREQUENCY RATES module data. This will pull out data as how it is displayed in the Frequency Rates module. (shown below).

As a pre requisite, this is a READ ONLY script and should be applied by a qualified DBA  on the CMO Data Warehouse database. 



Script to pull the Frequency Rates data from CMO DWH.txt

Following fields will be extracted from the Database in separate columns -

1. Org Unit

2. Entity

3. Entity Type

4. Month

5. Year

6. Hours

7. Number of Workers 

8. Classification

  • Was this article helpful?