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.
Following fields will be extracted from the Database in separate columns -
1. Org Unit
3. Entity Type
7. Number of Workers