Section

Key Figure

Definition

Data Rules

HSE

TRII 

Reportable Injuries and Illness (RII) rate

Number of work-related Injury or Illness resulting from accidents requiring a treatment greater than a First Aid Injury. It represents the number of reportable injuries per hours of work in the past 12 months.

Only work-related incidents classified as "RII" should be considered:

• Workflow_state != { 'Deleted'}
• Work_related = {'Work related'}
• Classif = {'RII'}

Regarding the total hours worked:

• Indicator='WKHR_EMPL','WKHR_CONTR'

HSE

PSI (Process Safety Incident (PSI) rate)

Number of process safety incidents per hour of work in the past 12 months, where a process safety incident is an event involving a chemical or a chemical process, and generating a release of chemicals or energy.

Only process safety incidents with severities classified as 'Medium','High','Critical' should be considered:

• Global_Severity IN ('Medium','High','Critical')

Regarding the total hours worked:

• Indicator='WKHR_EMPL','WKHR_CONTR'

HSE

GHG Emissions - GHG emissions scope 1 & 2

Amount of kt CO2 equivalent emitted by GBU-Site every month. It includes CO2 resulting from energy (fuels, electricity, steam) and CO2 equivalent emitted by processes (Methane, Nitrous oxide).

Cerise:

• Scope 1 = CO2 emission in Scope 1 NRJ ([K_SC1EMIS]) + CO2 emission in Scope 1 Process ([K_SC1EMPR])
• Scope 2 = CO2 emission in Scope 2 ([K_SC2EMIS])

Pure:

Only two Sites (and 2 components) should be considered:

• Site: Green River (532) ; Methane - E12600
• Site: Paulinia (1317): Nitrous oxide - E12104

Costs

Fixed Costs

Fixed Costs measures the company's fixed expenses, which remain constant regardless of production volume or sales levels.

Once information was already available on GCP, a copy of the connector was created.

Project: prj-data-industrial-dash-dev   

Table: ODS_BWH_0000_F002_F_M_fixedcosts

Costs

Variable Costs

Variable Costs are expenses that fluctuate directly with the level of production or sales. Unlike fixed costs, variable costs increase or decrease depending on the volume of goods or services produced. This cost category is essential for understanding the expenses directly associated with generating revenue and plays a crucial role in pricing, budgeting, and profit margin analysis.

Once information was already available on GCP, a copy of the connector was created.

Project: prj-data-industrial-dash-dev   

Table: ODS_BWH_0000_F002_F_M_variablecosts

Costs

Wave

Overview of all savings initiated by transformation activities within the STAR FACTORY program. Track all the transformation savings of the Group GBU and site level.

Once information was already available on GCP, a copy of the connector was created.

Costs

Headcount

Full Time Equivalent Headcount working in an establishment with a Group Work contract (temporary staff, employed and paid by a staff agency, are excluded).

Number of active company employees following the rules:

a) Employee status: Active, Active Leave

b) Employee class: Regular, Impatriate, Semi-retiree

Costs

Inventory Value

Inventory of raw materials, work in progress, semi-finished and finished goods.

-

Quality

Customer Complaints Rate

Provides a number with which to compare whether the rate of complaints is increasing or decreasing based on the ratio with the number of deliveries. This rate serves as an indicator of customer satisfaction, product quality, and service performance.

The Customer Complaints that should be considered:

• Justified complaints

SLV_Justified__c = ‘Y’

• External complaints

SLV4_1_Internal_Complaint__c = ‘N’)

• Record Type:

CASE_RECORD_TYPE = 'Open Complaint' or CASE_RECORD_TYPE = 'Close ReadOnly Complaint'

Productivity

OEE - Overall Equipment Effectiveness

Overall Equipment Effectiveness measures the perf. of the asset (and not the product!) at the bottleneck. It represents the rate of production by the maximum sustainable production ever achieved.

–

Supply Chain

OTIF

To measure the accuracy and punctuality of order deliveries in terms of both timing and completeness. This KPI reflects how well a company meets customer expectations by assessing if orders are delivered exactly when expected (On-Time) and in the correct quantities (In-Full). On Time (an order is considered to be delivered on time when it is delivered at the right time).

On Time (an order is considered to be delivered on time when it is delivered at the right time)

In Full (an order is considered in full when it is delivered with the right quantity). 

Supply Chain

Forecast Accuracy

Evaluates the ability to get visibility on customers' demand in terms of quantity.

Supply Chain

DOS

This is a major Group KPI as it is linked to Working Capital and cash delivery. It is measured in Days of Supply. It represents the days of sales in inventory.

Reports

Prompts

Query Name

HSE

Calendar Year/Month

Site

GBU

PO2 flag :ECO/SCO*

*For GHG it is important to show the evolution for a couple of years for sites. ECO vs SCO is related to company and not sites. In a couple of cases (Cincinnatti, Chicago, Livorno,... ) the emissions were reported in a company that is now SCO but they concern activities that are now in ECO. This is why it is important to also extract SCO data to include all GHG related to the site to be able to compare present data with past data.

TRII: Os_data, core_hd_monthly

PSI: Ps_data, core_hd_monthly

This information was already available on GCP project solvay-ind-conso-prod, schema “ehs_pure“ by the name of “Core_HD_Monthly”, ”PS_data” and “OS_data"

GHG Emissions:

• QV_BW_QRY_CPECO202_0001 (Cerise)
•  2024-06-05 Non CO2 GHG - Google Sheets (Pure)

Costs

Calendar Year/Month

Site

GBU

PO2 flag: ECO

Fixed and Variable Costs: 

GCP (BigQuery) Finance Data upload - Google Sheets

Wave:

sustain_impact_start
https://docs.google.com/spreadsheets/d/1a6KJrEUuGIuO_tpHuXwuG4sFtpdJXDt9BYFXzqrmE4c/edit?gid=27576149#gid=27576149

·activity_star :
https://docs.google.com/spreadsheets/d/1agiL3r2Dogxa2iXUi731MyMcIYxRGRGe765uSsP1YxY/edit?gid=1890118141#gid=1890118141

project star :

https://docs.google.com/spreadsheets/d/10MsxlWyX4JUEI1xMrAYYV7evTZO7li3fMO-05cxZSWk/edit?gid=245672719#gid=245672719

Headcount:

• DO_BW_QRY_CPHRPAHDM_0005 (People at Solvay)

Inventory Value:

• BW_QRY_CPIMMM01_0002 (Stock Analysis)
• BW_QRY_CPMMIM02_0001 (SMOG)

Quality

Calendar Year/Month

Site

GBU

PO2 flag: ECO/SCO

Salesforce:

• Case

SAP BW:

• BW_QRY_MVSDSO57_0002 (Deliveries)

Productivity

Index

PO2 flag: ECO

Excel:

• OEE database for Power BI - DEV - Google Sheets

• OEE database for Power BI - PROD - Google Sheets

Supply Chain

SLK_KEY

PO2 flag: ECO

DOS:

• Project: bi-gcp-sandbox.DataOcean_dt

• View: v_Solvay_Monthly_Inventory_Performance-Data_Finance_Snapshot_mv_pbi