Skip to main content
Mitratech Success Center

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

Goal

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. 

FrequencyRates_11.jpg

 

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?