Home
CMO Compliance
User Guides
Data Warehouse
SQL Script to get the Frequency Rates module data from the CMO Data Warehouse Database

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.

Workflow Automation

Corporate Legal & Claims

Governance, Risk & Compliance

Human Resources Compliance

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

Last updated
Save as PDF

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