General Measures DPI

This chapter documents the Data Provider Interface (DPI) for General Measures, including the DPI’s measure information and the DPI-specific dimensions.
General Measures DPI: Measure Information

ID Measure

Dimension

Measure Unit

Sustainability Metric

Measure

DLS_LOCAL_MIN_WAGE

Currency

Group currency

Wage Level

Local minimum wage

DLS_AGE

Time

YR (year)

Median Workforce Age

Age

DLS_CEO_COMPENSATION

Currency

Group currency

Level of CEO Compensation

Total CEO compensation

DLS_WF_MEDIAN_REMUN

Currency

Group currency

Level of CEO Compensation

Workforce median remuneration

Measure Description

DLS_LOCAL_MIN_WAGE

  • Description: The minimum wage defined for the units of the standard organizational structure of the legal entity hierarchy type and time period.

  • Unit: Currency. It must be unique for the whole data set - group currency. The period type of these records must be the same as the period type of measure Base salary (ID_MEASURE = PPL_BASE_SALARY).

    For example, if the base salary records use a period type of quarter ("Q"), it is necessary to upload minimum wage records with a period type of quarter as well.

DLS_AGE

  • Description: The measure contains a value for age for a given organizational structure unit and time period. MEASURE_COUNT indicates how many employees were counted by the age value, that is, how many employees have this value.

  • Unit: YR (year). This value must be the same for the whole data set.

DLS_CEO_COMPENSATION

  • Description: The DLS_CEO_COMPENSATION means the value of the CEO's compensation for a given time period. The following pair of measures is used to calculate the level of CEO compensation sustainability metric.

  • Calculation: CEO remuneration / Median remuneration for employees excluding the CEO (per period).

    • Remuneration - Total compensation per employee (in group currency) for the given time period.

    • Denominator of the calculation - see DLS_WF_MEDIAN_REMUN.

  • Unit: Currency. It must be the same for the whole data set - group currency. This measure is used together with the measure DLS_WF_MEDIAN_REMUN, it is necessary that both are loaded with the same period type for the calculation.

DLS_WF_MEDIAN_REMUN

  • Description: The median value for remuneration for the given time period.

  • Unit: Currency. It must be the same for whole data set - group currency.

General Measures DPI: Specific Dimensions

Dimension Name and Dimension ID

Data Type

Description

Mandatory

About this Dimension

ID Source

ID_SOURCE

String(32)

ID of the data source

Yes

Period Type

PERIOD_TYPE

String(2)

Y (year)

Q (quarter)

M (month)

FY (fiscal year)

FQ (fiscal quarter)

FP (fiscal period)

Yes

  

Year

PERIOD_YEAR

Integer

Calendar year or fiscal year (depending on the variant that is activated).

Yes

  

Quarter

PERIOD_QUARTER

Integer

The number of the quarter in the year - can be null if period type is 'Y'.

This dimension must remain empty when the period type is 'FY' (fiscal year) or 'FP' (fiscal period).

No

  

Month

PERIOD_MONTH

Integer

The number of the month in the year - can be null if period type is 'Q' or 'Y'.

This dimension must remain empty when the period type is 'FY' (fiscal year), 'FQ' (fiscal quarter), or 'FP' (fiscal period).

No

  

Fiscal Period

FISCAL_PERIOD

Integer

Custom-defined fiscal period (FP), different from the calendar year. The required format is 'PPP', but if you enter for example '1', the system changes it to '001'.

This dimension must remain empty when the period type is 'FY' (fiscal year) or 'FQ' (fiscal quarter).

No

  

ID Company code

ID_COMPANY_CODE

String(100)

Company code: Key related to reporting structures

Hierarchy type: Legal entity

No

Learn more about Reporting Structures

ID Organizational Unit

ID_ORG_UNIT

String(100)

Organizational unit: Key related to reporting structures

Hierarchy type: Organizational unit/reporting line

No

Learn more about Reporting Structures

ID Business location

ID_BUSINESS_LOC

String(100)

Business location: Key related to reporting structures

Hierarchy type: Business location

No

Learn more about Reporting Structures

ID Measure

ID_MEASURE

String(20)

ID of any of the measure types:

  • DLS_LOCAL_MIN_WAGE

  • DLS_AGE

  • DLS_CEO_COMPENSATION

  • DLS_WF_MEDIAN_REMUN

Yes

  

Aggregated Value

MEASURE_VALUE_CHAR

Decimal (31, 14)

Record value

Yes

  

Measure Unit

MEASURE_UNIT

String(3)

The unit of measure of the value, described in the preceding table - DPI: General. Measures, column Measure unit

No

  

Row Count

MEASURE_COUNT

Integer

Record count.

Yes