{"revision":"c10276e953456835cdbb1f3a60d58ae1980be353","document":{"id":14443,"path":"environmental-social-governance/tables-installed-with-metrics.md","title":null,"bundle":null,"doc_type":null,"release":null,"body":"---\ntitle: Components installed with the GRC: Metrics application\ndescription: When the Operational Sustainability 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.\nlocale: en-US\ncanonical_url: https://www.servicenow.com/docs/r/australia/environmental-social-governance/tables-installed-with-metrics.html\nrelease: australia\ntopic_type: reference\nlast_updated: \"2026-03-12\"\nreading_time_minutes: 4\nbreadcrumb: [GRC: Metrics reference, GRC: Metrics, Operational Sustainability Management \\(formerly Environmental, Social, and Governance\\)]\n---\n\n# Components installed with the GRC: Metrics application\n\nWhen the Operational Sustainability 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.\n\n## Roles installed\n\nThe following roles are installed with the GRC: Metrics application.\n\n\n
\n\nRole\n\n\n\nDescription\n\n\n\nContains\n\n
\n\nsn\\_grc\\_metric.admin\n\n\n\nThis role is the admin role for the application. This role can do the following:- Create, read, write, and delete metric definitions, metrics, and metric units.\n- Override the results in metric data tasks.\n- Read metric data.\n- Create schedule.\n\n\n\nsn\\_grc\\_metric.manager, sn\\_grc.library\\_admin\n\n
\n\nsn\\_grc\\_metric.manager\n\n\n\nEnterprise owner and approver role for the application. This role can do the following:- Create, read, write, and delete material topics, goals, targets, metric definitions, metrics, citations, and metric units.\n- Override the results in metric data tasks.\n- Read metric data, metric data tasks, disclosures, and authority documents.\n\n If there's an integration with Project Portfolio Management\n\n- Create, read, and write, projects and programs\n- Delete projects and programs\n\n If there's an integration with Integrated Risk Management, this role can do the following:\n\n- Create, read, write, and delete control objectives, controls, risk statements, and policies.\n- Read risks and issues.\n\n\n\nsn\\_grc\\_metric.user\n\n
\n\nsn\\_grc\\_metric.user\n\n\n\nThis role is a read-only role. Users with this role can't create, edit, or update any metric definitions or metrics\n\n\n\nNone\n\n
\n\nsn\\_grc\\_metric.developer\n\n\n\nUser with this role can edit the script in automated metric definition.\n\n\n\nNone\n\n
## Tables installed\n\nThe following tables are installed with the GRC: Metrics application.\n\n\n
\n\nName\n\n\n\nDescription\n\n
\n\nBase Metric Definition\n\n \\(sn\\_grc\\_metric\\_base\\_definition\\)\n\n\n\nBase table for all metric definitions.\n\n
\n\nCalculated Metric Definition\n\n \\(sn\\_grc\\_metric\\_composite\\_definition\\)\n\n\n\nCalculated metric definitions that are used to aggregate data for two or more metric definitions.\n\n
\n\nMetric Definition\n\n \\(sn\\_grc\\_metric\\_definition\\)\n\n\n\nMetric definitions that are used to define automated and manual metrics.\n\n
\n\nMetric\n\n \\(sn\\_grc\\_metric\\_metric\\)\n\n\n\nMetric instances that are generated when a metric definition is applied to an entity.\n\n
\n\nMetric Unit\n\n \\(sn\\_grc\\_metric\\_unit\\)\n\n\n\nUnit for a metric definition or metric.\n\n
\n\nParent Data\n\n \\(sn\\_grc\\_metric\\_parent\\_data\\)\n\n\n\nParent table for metric data.\n\n
\n\nMetric definition data\n\n \\(sn\\_grc\\_metric\\_collector\\_data\\)\n\n\n\nData for automated and manual metric definitions.\n\n
\n\nMetric Data\n\n \\(sn\\_grc\\_metric\\_metric\\_data\\)\n\n\n\nData for metric instances.\n\n
\n\nMetric Data Task\n\n \\(sn\\_grc\\_metric\\_data\\_task\\)\n\n\n\nTask to collect data for manual metrics.\n\n
\n\nEntity type to Metric Definition\n\n \\(sn\\_grc\\_metric\\_m2m\\_definition\\_profile\\_type\\)\n\n\n\nAssociation between Entity type and Metric definition.\n\n
\n\nEntity to Metric Definition\n\n \\(sn\\_grc\\_metric\\_m2m\\_definition\\_profile\\)\n\n\n\nAssociation between Entity and Metric definition.\n\n
\n\nMetric to Calculated Metric Definition\n\n \\(sn\\_grc\\_metric\\_m2m\\_metric\\_composite\\_defnition\\)\n\n\n\nAssociation between Metric and Calculated Metric definition.\n\n
\n\nChild Metric Definition\n\n \\(sn\\_grc\\_metric\\_m2m\\_metric\\_definition\\)\n\n\n\nAssociation between Metric and Metric definition.\n\n
\n\nControl objective to Metric Definition\\(sn\\_grc\\_metric\\_m2m\\_definition\\_control\\_objective\\)\n\n\n\nAssociation between Control objective and Metric definition.\n\n
\n\nControl to Metric Definition\n\n \\(sn\\_grc\\_metric\\_m2m\\_definition\\_control\\)\n\n\n\nAssociation between a control and a metric definition\n\n
\n\nUnit family\n\n \\(sn\\_grc\\_metric\\_unit\\_family\\)\n\n\n\nA unit family to group similar units together.\n\n
\n\nUnit conversion\n\n \\(sn\\_grc\\_metric\\_unit\\_conversion\\)\n\n\n\nConvert any metric data into a preferred reporting unit.\n\n
\n\nMetric to Calculated Metric Definition\n\n \\(sn\\_grc\\_metric\\_m2m\\_metric\\_composite\\_definition\\)\n\n\n\nAssociation between a metric and calculated metric definition.\n\n
\n\nMetric data process queue\\(sn\\_grc\\_metric\\_data\\_process\\_queue\\)\n\n\n\nIndicates 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.\n\n
\n\nMetric data by entity\\(sn\\_grc\\_metric\\_data\\_by\\_entity\\)\n\n\n\nIncludes data for entities in metric definition and aggregated data for its parent entities defined in the entity hierarchy.\n\n
\n\nTime dimension\\(sn\\_grc\\_metric\\_time\\_dimension\\)\n\n\n\nIncludes date, week, quarter, month, semi\\_annual, year for each day in the year.\n\n
\n\nMetric import job\\(sn\\_grc\\_metric\\_import\\_job\\)\n\n\n\nTable that holds the details of import jobs for metrics.\n\n
\n\nMetric data importsn\\_grc\\_metric\\_data\\_import\n\n\n\nStaging table that stores the records parsed from input data file.\n\n
\n\nMetric import logsn\\_grc\\_metric\\_st\\_import\\_log\n\n\n\nRemote table that has data for showing import logs for import jobs.\n\n
\n\nMetric transform historysn\\_grc\\_metric\\_st\\_transform\\_history\n\n\n\nRemote table that has data of transaction history for import jobs.\n\n
\n\nMetric import templatesn\\_grc\\_metric\\_import\\_template\n\n\n\nTable that stores the import templates used for preparing input data file for import job.\n\n
## Scheduled jobs\n\nThe scheduled jobs installed with the GRC: Metrics application run automatically at a specific time or schedule. Scheduled jobs can be set up to perform a wide variety of tasks such as running reports or data exports on a regular schedule.\n\n|Name|Description|\n|----|-----------|\n|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.|\n|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.|\n|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.|\n|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.|\n|Generate metric data by entity|This job runs daily to do entity hierarchy rollup for all the metric definitions.|\n|Generate time dimensions|This job runs on first day of every year and creates time dimensions for that year.|\n\n## Properties installed\n\n|Name|Description|Default value|\n|----|-----------|-------------|\n|sn\\_grc\\_metric.metric\\_data\\_task\\_schedule|Specifies schedule to be used for due date calculation|08fcd0830a0a0b2600079f56b1adb9ae|\n|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\\)|\n|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|\n|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|\n\n**Parent Topic:**[GRC: Metrics reference](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/environmental-social-governance/grc-metrics-reference.md)\n\n"}}