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.
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