Components installed with the GRC: Metrics application
- UpdatedJan 30, 2025
- 4 minutes to read
- Yokohama
- Environmental, Social, Governance
When the ESG Management application is activated, the GRC: Metrics application is automatically installed. The GRC: Metrics application adds several tables, properties, and roles that are listed here.
Roles installed
The following roles are installed with the GRC: Metrics application.
Role | Description | Contains |
---|---|---|
sn_grc_metric.admin | This role is the admin role for the application. This role can do the following:
|
sn_grc_metric.manager |
sn_grc_metric.manager | Enterprise owner and approver role for the application. This role can do the following:
If there's an integration with Project Portfolio Management
If there's an integration with Integrated Risk Management, this role can do the following:
|
sn_grc_metric.user |
sn_grc_metric.user | This role is a read-only role. Users with this role can't create, edit, or update any metric definitions or metrics | None |
sn_grc_metric.developer | User with this role can edit the script in automated metric definition. | None |
Tables installed
Name | Description |
---|---|
Base Metric Definition (sn_grc_metric_base_definition) |
Base table for all metric definitions. |
Calculated Metric Definition (sn_grc_metric_composite_definition) |
Calculated metric definitions that are used to aggregate data for two or more metric definitions. |
Metric Definition (sn_grc_metric_definition) |
Metric definitions that are used to define automated and manual metrics. |
Metric (sn_grc_metric_metric) |
Metric instances that are generated when a metric definition is applied to an entity. |
Metric Unit (sn_grc_metric_unit) |
Unit for a metric definition or metric. |
Parent Data (sn_grc_metric_parent_data) |
Parent table for metric data. |
Metric definition data (sn_grc_metric_collector_data) |
Data for automated and manual metric definitions. |
Metric Data (sn_grc_metric_metric_data) |
Data for metric instances. |
Metric Data Task (sn_grc_metric_data_task) |
Task to collect data for manual metrics. |
Entity type to Metric Definition (sn_grc_metric_m2m_definition_profile_type) |
Association between Entity type and Metric definition. |
Entity to Metric Definition (sn_grc_metric_m2m_definition_profile) |
Association between Entity and Metric definition. |
Metric to Calculated Metric Definition (sn_grc_metric_m2m_metric_composite_defnition) |
Association between Metric and Calculated Metric definition. |
Child Metric Definition (sn_grc_metric_m2m_metric_definition) |
Association between Metric and Metric definition. |
Control objective to Metric Definition (sn_grc_metric_m2m_definition_control_objective) |
Association between Control objective and Metric definition. |
Control to Metric Definition (sn_grc_metric_m2m_definition_control) |
Association between a control and a metric definition |
Unit family (sn_grc_metric_unit_family) |
A unit family to group similar units together. |
Unit conversion (sn_grc_metric_unit_conversion) |
Convert any metric data into a preferred reporting unit. |
Metric to Calculated Metric Definition (sn_grc_metric_m2m_metric_composite_definition) |
Association between a metric and calculated metric definition. |
Metric data process queue (sn_grc_metric_data_process_queue) |
Indicates the metric definitions that are in the queue for refreshing the data for calculated metric definitions or updating the entity hierarchical data for all the types of metric definitions. |
Metric data by entity (sn_grc_metric_data_by_entity) |
Includes data for entities in metric definition and aggregated data for its parent entities defined in the entity hierarchy. |
Time dimension (sn_grc_metric_time_dimension) |
Includes date, week, quarter, month, semi_annual, year for each day in the year. |
Metric import job (sn_grc_metric_import_job) |
Table that holds the details of import jobs for metrics. |
Metric data import sn_grc_metric_data_import |
Staging table that stores the records parsed from input data file. |
Metric import log sn_grc_metric_st_import_log |
Remote table that has data for showing import logs for import jobs. |
Metric transform history sn_grc_metric_st_transform_history |
Remote table that has data of transaction history for import jobs. |
Metric import template sn_grc_metric_import_template |
Table that stores the import templates used for preparing input data file for import job. |
Scheduled jobs
Name | Description |
---|---|
Aggregate metric definitions | This job is executed every 30 minutes. It pulls all types of metric definitions data which are active and have the state as Pending. It updates the "state" and "value" for each metric definitions data based on the aggregation of its corresponding metric data for that period. |
CMD validity check | This job is executed once everyday at 12AM. For Each calculated metric definition, it updates the "status" to valid/invalid and the "notes" based on its duplicate child metric definitions and child metrics. |
Execute calculated metric definitions | This job is executed for each calculated metric definition for both the entity level as well as the metric data definition level and updates with the calculated value. |
Execute metrics | This job is executed daily once at 4:30PM. This executes for each metric definition and its metrics that create metric data and the metric data task if it does not exists for that period. |
Generate metric data by entity | This job runs daily to do entity hierarchy rollup for all the metric definitions. |
Generate time dimensions | This job runs on first day of every year and creates time dimensions for that year. |
Properties installed
Name | Description | Default value |
---|---|---|
sn_grc_metric.metric_data_task_schedule | Specifies schedule to be used for due date calculation | 08fcd0830a0a0b2600079f56b1adb9ae |
sn_grc_metric.all_words | Is used to replace all comma separated defined string in value to 'All' while importing metric data using Metric Integration. | (blank), blank, na, all, empty, (empty) |
com.glide.event_manager.grc_metrics_queue.even.load.distribution.enabled | Is used to distribute the events in the 'grc_metric_queue' queue equally between two worker threads. | 500 |
com.glide.event_manager.grc_metrics_queue.claim_limit | Defines the maximum number of events that one worker thread can claim from the event queue. | true |