******************** Data Legends ******************** Input Data -------------- Portfolio Data ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ +-------------------+----------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------+ | **Data field** | **Expected value** | **Explanation** | **Optional / required** | **comment** | +-------------------+----------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------+ | company_name | Text | Name of the company in your portfolio | Required | Used for output purposes only | +-------------------+----------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------+ | company_id | Text | Identifier for the company in your portfolio, used to map target and fundamental data to the company | Required | You can use any unique company identifier, but must use the same identifier in all three input data files/tabs. | +-------------------+----------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------+ | company_isin | Text | Identifier for the company in your portfolio, used to identify the company e.g. for SBTi status | Required, for portfolio coverage and temperature score. | The column is needed in the file even if data is missing | +-------------------+----------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------+ | company_lei | Text | Legal Entity Identifier for the company in your portfolio, used identify the company e.g. for SBTi status | Required, for portfolio coverage and temperature score. | The column is needed in the file even if data is missing | +-------------------+----------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------+ | Investment_value | Monetary value | The monetary value invested in the company. Used for aggregation | Required | Make sure all values are in the same currency. | +-------------------+----------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------+ | engagement_target | TRUE, FALSE or empty | Used for engagement analysis. When set to TRUE for a company it is possible to analyze what it would do for your portfolio temperature score if this company would set a well below 2 degree Celsius (C) or a 2C target. | Optional | | +-------------------+----------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------+ | Additional_field | Text | It is possible to add additional fields to your portfolio data. These fields can be used to group companies by other categories than sectors, industries, regions and countries, e.g. market cap bucket, investment strategy, asset class, etc. | Optional | | +-------------------+----------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------+ Fundamental Data ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ +-----------------------------+-------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------+ | | | | | | | Data field | Expected value | Explanation | Optional / required | comment | +-----------------------------+-------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------+ | | | | | | | company_name | Text | Name of the company in your portfolio | Optional | | +-----------------------------+-------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------+ | | | | | | | company_id | Text | Identifier for the company in your portfolio, used to map target and fundamental data to the company | Required | You can use any unique company identifier, but must use the same identifier in all three input data files/tabs. | +-----------------------------+-------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------+ | | | | | | | isic | Text | Sector classification code for the company based on the International Standard Industrial Classification (https://siccode.com/page/what-is-an-isic-code). Used to map targets to the correct regression model. Should include at least the first two levels: Section and Division. | Required | | +-----------------------------+-------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------+ | | | | | | | country | Text | Country where the company has its headquarter. Used for analysis purposes only. | Optional | | +-----------------------------+-------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------+ | | | | | | | region | Text | Region where the company has its headquarter. Used for analysis purposes only. Can be continental or more granular. | Optional | | +-----------------------------+-------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------+ | | | | | | | industry_level_1-4 | Text | Level 1 through 4 of the industry classification of the company. Used for analysis purposes only. Can be based on any industry classification system. | Optional | | +-----------------------------+-------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------+ | | | | | | | sector | Text | Sector of the company. Used for analysis purposes only. Can be based on any classification system. | Optional | | +-----------------------------+-------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------+ | | | | | | | ghg_s1s2 | tCO2e | Total GHG emissions for scope 1 + 2 for the company. Used to combine temperature scores for scope 1 + 2 and scope 3 to temperature score for scope 1 + 2 + 3. Required together with ghg_s3 when using all aggregation methods (except WATS) | Optional | | +-----------------------------+-------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------+ | | | | | | | ghg_s3 | tCO2e | Total GHG emissions for scope 3 for the company. Used to combine temperature scores for scope 1 + 2 and scope 3 to temperature score for scope 1 + 2 + 3. Required together with ghg_s1s2 in all aggregation methods (except WATS) | Optional | | +-----------------------------+-------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------+ | | | | | | | company_revenue | Monetary value | In single dollars / euros / …. (can be any currency you choose). Revenue of the company in the most recent year. | Required only if using aggregation method ROTS. | All values must be in the same currency. | +-----------------------------+-------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------+ | | | | | | | company_market_cap | Monetary value | Market capitalization of the company in single dollars / euros / …. | Required only if using aggregation method MOTS. | All values must be in the same currency. | +-----------------------------+-------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------+ | | | | | | | company_enterprise_value | Monetary value | Enterprise value of the company in single dollars / euros / …. | Required only if using aggregation method EOTS or ECOTS. | All values must be in the same currency. | +-----------------------------+-------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------+ | | | | | | | company_total_assets | Monetary value | Total assets of the company in single dollars / euros / …. | Required only if using aggregation method AOTS. | All values must be in the same currency. | +-----------------------------+-------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------+ | | | | | | | company_cash_equivalents | Monetary value | Cash equivalents of the company in single dollars / euros / … . | Required only if using aggregation method ECOTS. | All values must be in the same currency. | +-----------------------------+-------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------+ Target data ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ +--------------------+---------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | **Data field** | **Expected value** | **Explanation** | **Optional / required** | **comment** | +--------------------+---------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | company_name | Text | Name of the company in your portfolio | Optional | | +--------------------+---------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | company_id | Text | Identifier for the company in your portfolio, used to map target and fundamental data to the company | Required | You can use any unique company identifier, but must use the same identifier in all three input data files/tabs. | +--------------------+---------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | target_type | Absolute, Intensity or Other | Type of target. Can be absolute or intensity based GHG emission reduction target. All targets that are not GHG emissions reduction targets can be mapped to Other. Used in the target validation protocol and to map the target to the relevant regression model in the temperature score module. | Required | If target_type is left empty the target will not be valid. If no other target is available for that time-frame and scope combination the company will be given a default score. | +--------------------+---------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | intensity_metric | Revenue, Product, Cement, Oil, Steel, Aluminum, Power Generation or Other | The metric the intensity based GHG emission reduction target is based on. All intensity metrics must be mapped to these 8 categories. Used in target validation protocol and to map the target to the relevant regression model in the temperature score module. | Required for targets with target type “Intensity”. Can be left empty for other targets. | | +--------------------+---------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | scope | S1, S2, S1+S2, S1+S2+S3, S3 | The scope(s) covered by the target. All scope 3 targets, whether covering downstream, upstream or both must be mapped to S3. | Required | Targets without scope are not valid. If no target is available for a time-frame and scope combination the company will be given a default score. | +--------------------+---------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | | | The part of emissions covered in scope 1 for the target. Used to determine the temperature score. | | | | coverage_s1 | Number in decimals, between 0 and 1, e.g. 70% is denoted 0.7. | | Required for a target that covers scope 1 | | | | | For targets covering scope 1 and 2 specify the same coverage percentage in coverage_s1 and coverage_s2 | | | +--------------------+---------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | | | The part of emissions covered in scope 2 for the target. Used to determine the temperature score. | | | | coverage_s2 | Number in decimals, between 0 and 1, e.g. 70% is denoted 0.7. | | Required for a target that covers scope 2 | | | | | For targets covering scope 1 and 2 specify the same coverage percentage in coverage_s1 and coverage_s2. | | | +--------------------+---------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | | | The part of emissions covered in scope 3 for the target. Used to determine the temperature score. | | | | coverage_s3 | Number in decimals, between 0 and 1, e.g. 70% is denoted 0.7. | | Required for a target that covers scope 3 | | | | | Note: this should be the coverage compare to the whole scope 3 emissions, so not just the part that is covered by the target. | | | +--------------------+---------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | reduction_ambition | Number in decimals, between 0 and 1, e.g. 70% is denoted 0.7. | The emission reduction that is set as ambition in the target. Used to determine the temperature score. | Required | | +--------------------+---------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | base_year | Year | Base year of the target. Used in the target validation protocol and to determine the time frame of the target. | Required | | +--------------------+---------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | end_year | Year | End year of the target. Used in the target validation protocol and to determine the time frame of the target. | Required | | +--------------------+---------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | start_year | Year | Year the target was announced. Used in the target validation protocol. If not specified, it will be assumed the start year is equal to the base year. | Optional | | +--------------------+---------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | base_year_ghg_s1 | tCO2e | Total reported GHG emissions for scope 1 for the company at the base year of the target. Used to convert targets covering only scope 1 or scope 2 to scope 1 + scope 2 targets. | Required for targets that only cover scope 1 or scope 2 | | +--------------------+---------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | base_year_ghg_s2 | tCO2e | Total reported GHG emissions for scope 2 for the company at the base year of the target. Used to convert targets covering only scope 1 or scope 2 to scope 1 + scope 2 targets. | Required for targets that only cover scope 1 or scope 2 | | +--------------------+---------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | base_year_ghg_s3 | tCO2e | Total reported GHG emissions for scope 3 for the company at the base year of the target. | Optional | | +--------------------+---------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | achieved_reduction | Number between 0 and 1 | Part of the reduction ambition of the target that is already achieved by the company. Used in the target validation protocol. Targets with achieved reduction of 1 are invalidated. | Optional. If not specified, assumed below 1 | | +--------------------+---------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | target_ids | An optional identifier for the target | An identifier that allows the user to see what targets are used as input to a specific temperture score. Is provided by some data providers. | Optional. If not specified, assumed empty | | +--------------------+---------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ Output data ----------- +---------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ | Data field | Expected value | Explanation | From | +---------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ | achieved_reduction | Number between 0 and 1 | Part of the reduction ambition of the target that is already achieved by the company. Used in the target validation protocol. Targets with achieved reduction of 1 are invalidated. | Target data | +---------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ | base_year | Year | Base year of the target. Used in the target validation protocol and to determine the time frame of the target. | Target data | +---------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ | base_year_ghg_s1 | In tCO2e | Total GHG emissions for scope 1 for the company at the base year of the target. | Target data | +---------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ | base_year_ghg_s2 | In tCO2e | Total GHG emissions for scope 2 for the company at the base year of the target. | Target data | +---------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ | base_year_ghg_s3 | In tCO2e | Total GHG emissions for scope 3 for the company at the base year of the target. | Target data | +---------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ | company_id | text | Identifier for the company in your portfolio, used to map target and fundamental data to the company | Portfolio data | +---------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ | company_isin | text | Identifier for the company in your portfolio, used to get the SBTi status of the company (i.e. whether or not the company has a target approved by the SBTi) | Portfolio data | +---------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ | company_name | text | Name of the company in your portfolio | Portfolio data | +---------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ | coverage_s1 | Number in decimals, between 0 and 1 | The part of emissions covered in scope 1 for the target. Used to determine the temperature score. | Target data | +---------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ | coverage_s2 | Number in decimals, between 0 and 1 | The part of emissions covered in scope 2 for the target. Used to determine the temperature score. | Target data | +---------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ | coverage_s3 | Number in decimals, between 0 and 1 | The part of emissions covered in scope 3 for the target. Used to determine the temperature score. | Target data | +---------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ | end_year | Year | End year of the target. Used in the target validation protocol and to determine the time frame of the target. | Target data | +---------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ | Intensity_metric | Revenue, Product, Cement, Oil, Steel, Aluminum, Power Generation or Other | The metric the intensity based GHG emission reduction target is based on. All intensity metrics must be mapped to the eight categories in the column on the left. Used in target validation protocol and to map the target to the relevant regression model in the temperature score module. | Target data | +---------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ | Reduction_ambition | Number in decimals, between 0 and 1 | The emission reduction that is set as ambition in the target. Used to determine the temperature score. | Target data | +---------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ | start_year | Year | Year the target was announced. Used in the target validation protocol. If not specified, it is assumed the start year is equal to the base year. | Target data | +---------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ | Target_type | Absolute, Intensity or Other | Type of target. Can be absolute or intensity based GHG emission reduction target. All targets that are not GHG emissions reduction targets can be mapped to Other. Used in the target validation protocol and to map the target to the relevant regression model in the temperature score module. | Target data | +---------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ | | | The targets are sorted by time frame. | | | | +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | | | | SHORT: targets shorter than 5 years | | | Time_frame | SHORT, MID or LONG +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ Determined in tool | | | | MID: targets between 5 and 15 years | | | | +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | | | | LONG: targets between 15 and 30 years. | | +---------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ | target_ids | list of target ids | A list showing the IDs of the targets that have been used in calculating this temperature score. If IDs are not used the field will return empty. | Target data | +---------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ | ghg_s1s2 | tCO2e | Total GHG emissions for scope 1 + 2 for the company. Used to combine temperature scores for scope 1 + 2 and scope 3 to temperature score for scope 1 + 2 + 3. Also used in combination with ghg_s3 in most aggregation methods (except WATS) | Fundamental data | +---------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ | ghg_s3 | tCO2e | Total GHG emissions for scope 3 for the company. Used to combine temperature scores for scope 1 + 2 and scope 3 to temperature score for scope 1 + 2 + 3. Also used in combination with ghg_s3 in all aggregation methods, except WATS. | Fundamental data | +---------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ | sbti_validated | FALSE or TRUE | Returns true if the company has a SBTi-approved target. | SBTi data or fundamental data | +---------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ | Investment_value | Monetary value | The monetary value invested in the company. | Portfolio data | +---------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ | engagement_target | TRUE, FALSE or empty | Used for engagement analysis. When set to TRUE for a company it is possible to analyze what it would do for your portfolio temperature score if this company would set a (well below) 2 degrees target. | Portfolio data | +---------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ | sr15 | text | The regression model used. This is determined based on the target type, ISIC, intensity_metric and scope. See [link to methodology doc, updated mapping section] for more detail | Output from the tool | +---------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ | | | The annual reduction based on the reduction_ambition and the length of the target. Calculated as | | | Annual_reduction | Number in decimals, between 0 and 1 +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ Output from the tool | | | | | | +---------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ | | | Used in determining the regression model to use to calculate the temperature score for a specific target based on its time frame. | | | | +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | | | | Short-term targets: slope5 | | | slope | Slope5, slope15, slope30 +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ Output from the tool | | | | Mid-term targets: slope15 | | | | +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | | | | Long-term targets: slope30 | | +---------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ | samplesize | Number | The sample size used in the regression model. For model 4 this is 128. Not used in calculations. See https://github.com/CDPworldwide/TROPICS-regression/ for more detail about the regressions. | Regression model | +---------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ | model | Integer | The regression model used. This is model 4 by default. See https://github.com/CDPworldwide/TROPICS-regression/ for more detail about the regressions. | Regression model | +---------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ | | | The regression scenario used to determine the temperature score of a target, for example | | | | +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | | variable | text | Emissions|Kyoto Gases | Regression model | | | +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | | | | | | +---------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ | param | Number in decimals, between 0 and 1 | The temperature score (TS) is calculated using linear regressions. | Regression model | +---------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ | intercept | Number in decimals, between 0 and 1 | The temperature score (TS) is calculated using linear regressions. | Regression model | +---------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ | r2 | Number in decimals, between 0 and 1 | r2 represents the fit of the regression model on the data used to create the regressions. Not used in calculations. | Regression model | +---------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ | temperature_score | Number | The temperature score calculated for the combination of company, scope and time frame | Output from tool | +---------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+ | temperature_results | Number in decimals, between 0 and 1 | Represents the part of the score that is calculated using a valid target as defined by the target validation protocol vs. the part using the default score. For more detail, see [link to Chapter 2 of Methodology document] | | +---------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+