{'Using GRC': 'Metrics to provide data'} › {'GRC': 'Metrics'} › Operational Sustainability Management \(formerly Environmental › Social › and Governance\)

Release: Australia · Updated: 2026-03-12 · Official documentation · View source

Create a unique metric definition name

Specify the value formula in the sn_grc_metric_definition in the required record table to create unique metric definition names to import data from an external source such as Watershed spreadsheets.

Before you begin

Role required: sn_grc_metric.admin

About this task

Any external source that contains data must be imported into the metric definitions and each metric definition must have a unique name. The metric definition name can either use a single column from the spreadsheet or it can be a combination of multiple columns. This procedure uses the Operational Sustainability Integration with Watershed and the sn_grc_metric_definition table as an example. You can specify the formulae in the sn_grc_metric_definition table to create the unique metric definition names. The same procedure can be repeated for the other tables as well. The following tables are installed by default.

sn_grc_profile
sn_grc_profile_type
sn_grc_metric_definition

The following image shows the string and value columns from a sample spreadsheet.

Image omitted: value-formula.png
Sample strings and values from a spreadsheet.

Procedure

Navigate to All > Metrics > Metric Integrations.
Select Watershed Integration.
In the Data Mappings section, select the data mapping for which you want to specify the formula.
On the Required Records form, in the Value Formulas section select New.
On the form, fill in the fields.

Field	Description
Source table.	Name of the source table. This field is automatically set to Watershed Data [sn_esg_watershed_data].
Required record	Name of the table being modified.Note: In this procedure, the example used is the sn_grc_metric_definition table.
Column	Column containing GHG protocol category.
Format	Format of the name. The choices are as follows- String: Use this option to specify a text string. - Value: Use this option to use any value of the column. - String+Value: Use this option prepend text to beginning of column value. - Value+String: Use this option to append text to end of column value. Specify the text in the String field.
String	Text to use in the format.
Sequence	Specify the sequence of the formula. Multiple value formula under same required record will be concatenated following the sequence specified.

Select Submit.

Parent Topic:Using GRC: Metrics to provide data