Data dictionary¶

The app supports six asset classes for Emissions and Climate Risk: Private Equity, Private Debt, Public Equity, Public Debt, Property and Infrastructure. Geospatial Risk is a separate analysis with its own input and its own result table, covered at the end of this page.

Corporate and government bonds are one asset class, Public Debt. They are told apart on the results by the DEBT_TYPE column, not on the input. Loans to private borrowers are Private Debt: the borrower's columns are the Private Equity columns, plus the loan's maturity date and outstanding amount.

Input columns¶

One table per asset class, listing every column that class reads. A run covers a single asset class, so supply the columns for the class you are running. Column names are matched case-insensitively, and you can map your own column names onto these in the user interface or with the column_map parameter.

Financial values must be in US dollars (USD). They are not currency-converted for you.

Where an industry classification is required, the accepted systems are anzsic, factset, gics_l4, rbics_l3, rbics_l4. The system is chosen once for the whole run, not per row.

Private Equity¶

Privately held companies, one row per company and year. Emissions are estimated in your account from the company's financials and industry.

The identifier column is the company name.

Column	Type	Required	Units	Description
`identifier`	string	Yes		Unique company identifier (one row per company-year).
`year`	integer	Yes		Fiscal year of the financials.
`industry`	string	Yes		Industry value in the chosen classification system.
`industry_classification_system`	string	Yes		Classification system the industry value belongs to.
`country`	string	Yes		Country of operation, e.g. "United States". Case-insensitive; accepts a country name, an ISO alpha-2 code (e.g. "US", "GB"), or a common alias.
`revenue`	number	No	USD	Total revenue.
`total_assets`	number	No	USD	Total assets.
`gppe`	number	No	USD	Gross property, plant & equipment.
`evic`	number	No	USD	Enterprise value including cash.
`market_cap`	number	No	USD	Market value: market capitalisation or equity valuation.
`cap_ex`	number	No	USD	Capital expenditure.
`scope1`	number	No	tCO2e	Reported Scope 1 emissions (override; used first if provided).
`scope2`	number	No	tCO2e	Reported Scope 2 emissions (override; used first if provided).
`scope3`	number	No	tCO2e	Reported Scope 3 emissions (override; used first if provided).
`name`	string	No		A readable company name (carried through to the output).
`ebitda`	number	No	USD	Earnings before interest, tax, depreciation & amortisation.
`enterprise_value`	number	No	USD	Enterprise value.
`employees`	number	No	count	Number of employees.
`total_debt`	number	No	USD	Total debt.
`net_debt`	number	No	USD	Net debt.

Private Debt¶

Loans to privately held borrowers, one row per loan and year. The borrower's emissions are estimated in your account from its financials and industry, then attributed to the loan by outstanding amount over EVIC. That ratio is written as OWNERSHIP on the results.

The identifier column is the borrower name.

Column	Type	Required	Units	Description
`identifier`	string	Yes		Unique company identifier (one row per company-year).
`year`	integer	Yes		Fiscal year of the financials.
`industry`	string	Yes		Industry value in the chosen classification system.
`industry_classification_system`	string	Yes		Classification system the industry value belongs to.
`country`	string	Yes		Country of operation, e.g. "United States". Case-insensitive; accepts a country name, an ISO alpha-2 code (e.g. "US", "GB"), or a common alias.
`revenue`	number	No	USD	Total revenue.
`total_assets`	number	No	USD	Total assets.
`gppe`	number	No	USD	Gross property, plant & equipment.
`evic`	number	No	USD	Enterprise value including cash.
`market_cap`	number	No	USD	Market value: market capitalisation or equity valuation.
`cap_ex`	number	No	USD	Capital expenditure.
`scope1`	number	No	tCO2e	Reported Scope 1 emissions (override; used first if provided).
`scope2`	number	No	tCO2e	Reported Scope 2 emissions (override; used first if provided).
`scope3`	number	No	tCO2e	Reported Scope 3 emissions (override; used first if provided).
`name`	string	No		A readable company name (carried through to the output).
`ebitda`	number	No	USD	Earnings before interest, tax, depreciation & amortisation.
`enterprise_value`	number	No	USD	Enterprise value.
`employees`	number	No	count	Number of employees.
`total_debt`	number	No	USD	Total debt.
`net_debt`	number	No	USD	Net debt.
`maturity_date`	string	Yes		Date the loan matures (YYYY-MM-DD or DD/MM/YYYY). A loan that matured before the row's fiscal year end carries no exposure.
`outstanding_amount`	number	No	USD	Principal you currently hold on the loan. The borrower's emissions are attributed to the loan as outstanding amount over the borrower's EVIC (total assets when EVIC is missing).

Public Equity¶

Listed companies, one row per holding. Each identifier is resolved against Emmi's pre-computed public equity universe, so no financials are needed.

The identifier column is the isin.

Column	Type	Required	Units	Description
`identifier`	string	Yes		Unique company identifier (one row per company-year).
`year`	integer	Yes		Fiscal year of the financials.

Public Debt¶

Corporate and government debt securities, one row per holding. Each identifier is resolved against Emmi's fixed income universe. Corporate and government bonds are one asset class here and are told apart by the DEBT_TYPE column on the results.

The identifier column is the isin.

Column	Type	Required	Units	Description
`identifier`	string	Yes		Unique company identifier (one row per company-year).
`year`	integer	Yes		Fiscal year of the financials.

Property¶

Directly held property assets, one row per asset and year. Property has no scope 3 emissions.

The identifier column is the asset name.

Column	Type	Required	Units	Description
`identifier`	string	Yes		Unique company identifier (one row per company-year).
`year`	integer	Yes		Fiscal year of the financials.
`name`	string	No		A readable company name (carried through to the output).
`country`	string	Yes		Country of operation, e.g. "United States". Case-insensitive; accepts a country name, an ISO alpha-2 code (e.g. "US", "GB"), or a common alias.
`scope1`	number	No	tCO2e	Reported Scope 1 emissions (override; used first if provided).
`scope2`	number	No	tCO2e	Reported Scope 2 emissions (override; used first if provided).
`scope3`	number	No	tCO2e	Reported Scope 3 emissions (override; used first if provided).
`state`	string	No		State or region the asset is located in.
`net_lettable_area`	number	Yes		Net lettable area of the property (square metres).
`building_type`	string	Yes		Building type of the property, e.g. "Office" or "Retail".
`energy_rating`	number	No		Energy rating value in the chosen energy rating system.
`energy_rating_system`	string	No		Energy rating system the rating belongs to, e.g. "NABERS".
`market_value`	number	No	USD	Market value of the asset. Provide market value or book value.
`book_value`	number	No	USD	Book value of the asset. Provide market value or book value.
`net_operating_income`	number	No	USD	Net operating income (NOI) generated by the asset.
`operating_cash_flow`	number	No	USD	Operating cash flow generated by the asset.
`gearing_ratio`	number	No		Gearing ratio of the asset (debt over total value, fraction).
`asset_life_remaining`	number	No		Remaining useful life of the asset (years).
`discount_rate`	number	No		Discount rate applied when valuing the asset (fraction).

Infrastructure¶

Directly held infrastructure assets, one row per asset and year.

The identifier column is the asset name.

Column	Type	Required	Units	Description
`identifier`	string	Yes		Unique company identifier (one row per company-year).
`year`	integer	Yes		Fiscal year of the financials.
`name`	string	No		A readable company name (carried through to the output).
`country`	string	Yes		Country of operation, e.g. "United States". Case-insensitive; accepts a country name, an ISO alpha-2 code (e.g. "US", "GB"), or a common alias.
`industry`	string	Yes		Industry value in the chosen classification system.
`industry_classification_system`	string	Yes		Classification system the industry value belongs to.
`sector`	string	No		FactSet sector for the asset. Optional: supply it to override the sector that would otherwise be derived from the industry.
`scope1`	number	No	tCO2e	Reported Scope 1 emissions (override; used first if provided).
`scope2`	number	No	tCO2e	Reported Scope 2 emissions (override; used first if provided).
`scope3`	number	No	tCO2e	Reported Scope 3 emissions (override; used first if provided).
`ebitda`	number	No	USD	Earnings before interest, tax, depreciation & amortisation.
`market_value`	number	No	USD	Market value of the asset. Provide market value or book value.
`book_value`	number	No	USD	Book value of the asset. Provide market value or book value.
`operating_cash_flow`	number	No	USD	Operating cash flow generated by the asset.
`gearing_ratio`	number	No		Gearing ratio of the asset (debt over total value, fraction).
`asset_life_remaining`	number	No		Remaining useful life of the asset (years).
`discount_rate`	number	No		Discount rate applied when valuing the asset (fraction).

Geospatial Risk input¶

Geospatial Risk reads a view of physical assets pinned to a location, one row per asset.

Column	Type	Required	Units	Description
`identifier`	string	Yes		Unique asset identifier, one row per asset.
`latitude`	number	Yes	Degrees	Latitude of the asset, between -90 and 90.
`longitude`	number	Yes	Degrees	Longitude of the asset, between -180 and 180.
`asset_value`	number	No	USD	Value of the asset. Optional: when given, it turns average annual loss into expected damages. Without it `AAL` is still reported as a fraction of asset value and `EXPECTED_DAMAGES` is empty.
`owner_identifier`	string	No		Identifier of the entity that owns the asset. Carried through to the results unchanged.
`name`	string	No		Display name for the asset. Carried through to the results unchanged.

Output columns¶

Results are written to tables in the app's DATA schema, which you have SELECT on. Results accumulate across runs, so filter by TASK_ID to read a single run.

DATA.EMISSIONS¶

One row per holding per year, keyed by (TASK_ID, INPUT_ROW, YEAR). Financial columns are carried through from your input for the classes that supply them, and are empty for Public Equity and Public Debt, which are resolved against Emmi's pre-computed universe instead.

Column	Type	Unit	Example	Description
`TASK_ID`	number		42	The run that produced this row. Filter on it to read one run.
`ASSET_CLASS`	string		Public Equity	The asset class this row was processed as. Rows written by earlier versions of the app have no stored class and read back as `Private Equity`.
`INPUT_ROW`	number		7	Position of the source row in your input, so a result can be traced back to the holding it came from.
`IDENTIFIER`	string		AU000000BHP4	The identifier you supplied, meaning whatever that column means for the asset class.
`NAME`	string		BHP Group Limited	Name of the company or asset.
`YEAR`	number	Year	2024	The year you requested for this holding.
`DATA_YEAR`	number	Year	2023	The year the record actually used came from. It differs from `YEAR` when the requested year had no data and an earlier year was used, and is empty when the holding could not be resolved.
`FISCAL_END_DATE`	date (yyyy-mm-dd)	Date	2025-07-31	Fiscal year end date for the company.
`COUNTRY`	string		Australia	Country the company or asset is in.
`FACTSET_INDUSTRY`	string		Metals/Mining	Industry the emissions estimate was made against, mapped to Emmi's FactSet industry vocabulary.
`DEBT_TYPE`	string		Corporate	For Public Debt only, whether the security resolved as corporate or government debt. `Corporate` or `Government`.
`BOND_TYPE`	string		Corporate	For Public Debt only, the bond security type. Corporate rows are Corporate or Securitized/Collateralized. Government rows are Sovereign, Agency, Local Authority/Political Division or Supranational.
`BUILDING_TYPE`	string		Office	For Property only, the building type used to select the intensity factor.
`MATURITY_DATE`	date (yyyy-mm-dd)	Date	2031-06-30	For Private Debt only, the loan's maturity date as you supplied it.
`OUTSTANDING_AMT`	float	USD	10000000	For Private Debt only, the outstanding amount the emissions were attributed with. Zero for a loan that had matured by 31 December of the row's year, which attributes nothing.
`OWNERSHIP`	float	Fraction	0.1	For Private Debt only, the attribution ratio the scope columns were scaled by: `OUTSTANDING_AMT` over the borrower's EVIC, or over total assets when EVIC is not supplied. Empty when there is nothing to attribute by (no outstanding amount, a negative EVIC, or an outstanding amount larger than the denominator). Divide a scope column by it to recover the borrower's own figure.
`REVENUE`	float	USD	45000000	Total revenue, carried through from your input.
`TOTAL_ASSETS`	float	USD	92000000	Total assets, carried through from your input.
`EBITDA`	float	USD	7300000	EBITDA, carried through from your input.
`ENTERPRISE_VALUE`	float	USD	61000000	Enterprise value, carried through from your input.
`EVIC`	float	USD	68000000	Enterprise value including cash, carried through from your input.
`MARKET_CAP`	float	USD	54000000	Market capitalisation, carried through from your input.
`CAP_EX`	float	USD	3100000	Capital expenditure, carried through from your input.
`EMPLOYEES`	float	Count	1250	Number of employees, carried through from your input.
`GPPE`	float	USD	28000000	Gross property, plant and equipment, carried through from your input.
`TOTAL_DEBT`	float	USD	19000000	Total debt, carried through from your input.
`UNDERLYING_VALUE`	float	USD	68000000	The valuation to attribute emissions against, for the classes computed in your account. Private Equity and Private Debt: EVIC, or enterprise value when EVIC is not supplied, or total assets when neither is. Property and Infrastructure: book value, or market value when book value is not supplied. Empty for Public Equity and Public Debt, whose underlying financials are not disclosed. Multiply a scope column by your holding over this value to get financed emissions.
`NET_DEBT`	float	USD	12000000	Net debt, carried through from your input.
`SCOPE1_EMISSIONS`	float	tCO2e	1621	Scope 1 emissions by the entity. Scope 1 emissions are direct emissions from sources that are owned or controlled by the company, such as emissions from burning fossil fuels. For Public Debt this is the financed figure: the share of the issuer's emissions attributed to the bond, being the issuer's emissions scaled by the bond's outstanding amount over the issuer's enterprise value including cash (for government debt, over the country's PPP-adjusted GDP). It is the same figure Emmi delivers for that bond elsewhere, and is a small fraction of the issuer's total. For Private Debt it is likewise the financed figure: the borrower's estimated emissions scaled by `OWNERSHIP`.
`SCOPE1_PCAF`	float	Score	3	The PCAF score for Scope 1. PCAF is a method for recognising the quality of estimation. 1 = reported and verified, 2 = reported, 3 = estimated using historical emissions, 4 = estimated with financials only.
`SCOPE1_EMISSION_REPORTING_STATUS`	string		reported	Status of emissions reporting for Scope 1. reported, estimated or unavailable.
`SCOPE2_EMISSIONS`	float	tCO2e	13581	Scope 2 emissions by the entity. Scope 2 emissions are indirect emissions from the generation of purchased energy consumed by the company. For Public Debt and Private Debt this is the financed figure attributed to the bond or loan, as for `SCOPE1_EMISSIONS`. Empty for government debt rows, which carry Scope 1 only.
`SCOPE2_PCAF`	float	Score	3	As above, for Scope 2.
`SCOPE2_EMISSION_REPORTING_STATUS`	string		estimated	Status of emissions reporting for Scope 2. reported, estimated or unavailable. Not Applicable for government debt rows.
`SCOPE3_EMISSIONS`	float	tCO2e	75060	Scope 3 emissions by the entity. Scope 3 emissions are all other indirect emissions in the company's value chain, both upstream and downstream. Common categories include purchased goods and services, business travel, employee commuting, waste generated, use of sold products, leased assets, and investments (including financed emissions). For Public Debt and Private Debt this is the financed figure attributed to the bond or loan, as for `SCOPE1_EMISSIONS`. Property has no Scope 3, so this column is empty for property rows, as it is for government debt rows, which carry Scope 1 only.
`SCOPE3_PCAF`	float	Score	4	As above, for Scope 3.
`SCOPE3_EMISSION_REPORTING_STATUS`	string		estimated	Status of emissions reporting for Scope 3. reported, estimated or unavailable. Not Applicable for government debt and property rows.
`WACI_S1`	float	tCO2e per million revenue	123.45	Weighted Average Carbon Intensity of Scope 1. Emissions as a factor of company revenue. For Public Debt and Private Debt the intensity columns describe the issuer or borrower, not the bond or loan: an intensity is a ratio of the entity's emissions to the entity's own revenue or enterprise value, so attributing a share to the holding does not change it.
`WACI_S12`	float	tCO2e per million revenue	123.45	Weighted Average Carbon Intensity of Scopes 1 + 2. Emissions as a factor of company revenue.
`WACI_S123`	float	tCO2e per million revenue	123.45	Weighted Average Carbon Intensity of Scopes 1 + 2 + 3. Emissions as a factor of company revenue.
`EVIC_CARBON_INTENSITY_S12`	float	tCO2e per million EVIC	123.45	An intensity measure of Scope 1 and 2 emissions, as a factor of EVIC.
`EVIC_CARBON_INTENSITY_S123`	float	tCO2e per million EVIC	123.45	An intensity measure of all emissions, as a factor of EVIC.

DATA.CLIMATE_RISK¶

Written when a run requests the risk output. One row per holding per scenario per analysis year, so a run over 100 holdings with 2 scenarios and 2 analysis years writes 400 rows. Rows are keyed by (TASK_ID, INPUT_ROW, YEAR, RISK_YEAR, TRANSITION_RISK_SCENARIO).

Value at risk columns are decimal fractions: 1 = 100%, 0.5 = 50%.

Not every column is filled for every asset class:

Property and Infrastructure carry transition risk and temperature alignment only. Their physical risk columns and TOTAL_CLIMATE_VAR are always empty, because market-based physical risk is not modelled for directly held real assets. Use Geospatial Risk for location-based hazard exposure on those assets.
Public Debt has no market-based physical risk of its own: the four physical risk columns are empty for every debt row. Corporate debt rows carry the issuer's physical risk in UNDERLYING_TOTAL_PHYSICAL_VAR and the bond's TOTAL_CLIMATE_VAR. Government debt rows carry transition risk and temperature alignment only: UNDERLYING_TOTAL_PHYSICAL_VAR and TOTAL_CLIMATE_VAR are empty.
Private Debt is transition risk on the loan: the risk is computed from the borrower's own emissions and financials and scaled by the loan's outstanding amount and maturity, so a loan that has matured by the risk year carries no risk. The physical risk columns and UNDERLYING_TOTAL_PHYSICAL_VAR are empty (no physical figure is computed for a private borrower), and TOTAL_CLIMATE_VAR equals TRANSITION_VAR. Temperature alignment is populated.

Column	Type	Unit	Example	Description
`TASK_ID`	number		42	The run that produced this row.
`ASSET_CLASS`	string		Public Equity	The asset class this row was processed as.
`INPUT_ROW`	number		7	Position of the source row in your input. Join back to `DATA.EMISSIONS` on `TASK_ID` and `INPUT_ROW`.
`IDENTIFIER`	string		AU000000BHP4	The identifier you supplied. Matches `DATA.EMISSIONS.IDENTIFIER`.
`YEAR`	number	Year	2024	The year you requested for this holding.
`RISK_YEAR`	int	Year	2030	Year for emission reductions, transition and physical risk analysis.
`TRANSITION_RISK_SCENARIO`	string		NGFS_NetZero2050	Which climate scenario was used to create the row. See Climate scenarios for the full list.
`FISCAL_END_DATE`	date (yyyy-mm-dd)	Date	2025-07-31	Fiscal year end date for the company.
`EMISSIONS_USED`	string		reported	Whether the analysis used reported, estimated or mix-of-estimated-reported emissions.
`TRANSITION_VAR`	float	%	0.5	Value at risk based on carbon pricing in the scenario at the risk year. Also called Potential Carbon Liability (PCL) or Transition Value at Risk: the potential economic downside of a holding if the scenario plays out and a carbon price is imposed to penalise emissions that exceed the allocated budget.
`REDUCTION`	float	%	0.35	Emission reduction required for the entity's Scope 1+2+3 emissions to be aligned with the scenario at the risk year.
`TEMPERATURE_ALIGNMENT`	float	°C	1.5	Temperature alignment indicates the global warming scenario that a company's current carbon footprint is consistent with. It captures whether the entity's emissions trajectory aligns with the Paris Agreement's goal of limiting warming to well below 2°C, or with higher warming scenarios. Temperature alignment does not change between scenarios.
`ACUTE_PHYSICAL_VAR`	float	%	0.1	Value at risk based on acute climate events caused by the baseline risk and anthropogenic climate change in the scenario at the risk year.
`CHRONIC_PHYSICAL_VAR`	float	%	0.1	Value at risk based on chronic climate events caused by the baseline risk and anthropogenic climate change in the scenario at the risk year.
`BASELINE_PHYSICAL_VAR`	float	%	0.02	Non anthropogenic physical risk.
`TOTAL_PHYSICAL_VAR`	float	%	0.5	Potential capital loss based on acute and chronic physical risk.
`UNDERLYING_TOTAL_PHYSICAL_VAR`	float	%	0.001	Value at risk to the equity of the underlying entity that issues the bond. Corporate debt rows only.
`TOTAL_CLIMATE_VAR`	float	%	0.68	Total value at risk based on transition and physical risk (baseline and anthropogenic) for the given scenario and risk year.

DATA.GEOSPATIAL_RESULTS¶

Written by a Geospatial Risk run. One row per asset per hazard per scenario per time horizon, so every asset produces many rows and you normally filter to the hazard, scenario and year you care about.

Column	Type	Unit	Example	Description
`TASK_ID`	number		43	The run that produced this row.
`SUBMISSION_ID`	string		input_assets	Which submission the row belongs to. Rows from a SQL run are labelled `input_assets`; rows from a file uploaded in the user interface carry that upload's id.
`OWNER_IDENTIFIER`	string		Fund A	Owner identifier from your input, carried through unchanged.
`IDENTIFIER`	string		SITE-001	Asset identifier from your input.
`NAME`	string		Brisbane Distribution Centre	Asset name from your input, carried through unchanged.
`LATITUDE`	float	Degrees	-27.4698	Latitude from your input.
`LONGITUDE`	float	Degrees	153.0251	Longitude from your input.
`HAZARD`	string		riverine_floods	The acute hazard this row reports.
`SCENARIO`	string		rcp4p5	The warming scenario this row reports. One of `baseline`, `rcp4p5`, `rcp8p5`.
`YEAR`	number	Year	2050	The time horizon this row reports. One of 2030, 2050, 2080.
`DATA_AVAILABLE`	boolean		TRUE	Whether the location fell on the hazard map. FALSE for locations off the map, such as open ocean, and the metric columns are then empty.
`AAL`	float	Fraction of asset value	0.0042	Average annual loss. The expected yearly loss from this hazard at this location, as a fraction of asset value.
`INTENSITY`	float		0.8	Modelled hazard intensity at the location.
`PROBABILITY`	float	Fraction	0.02	Modelled annual probability of the hazard occurring at the location.
`DEPTH_METERS`	float	Metres	1.4	Flood depth. Populated for flood hazards only.
`WIND_SPEED_MPS`	float	Metres per second	48.2	Wind speed. Populated for cyclone hazards only.
`FIRE_DANGER_DAYS`	float	Days per year	12	Days per year above the fire danger threshold. Populated for wildfire only.
`ASSET_VALUE`	float	USD	25000000	Asset value from your input, carried through unchanged. Empty when you did not supply one.
`EXPECTED_DAMAGES`	float	USD	105000	`AAL` multiplied by `ASSET_VALUE`. Empty when there is no data or no asset value was supplied, and 0 when the asset value is 0.
`MAP_VERSION`	string		v1.3	Version of the hazard map the row was read from.
`CREATED_DATETIME`	timestamp	Timestamp	2026-09-02 04:15:22	When the row was written.

DATA.TASKS¶

The run ledger. One row per submitted run. You have SELECT on it; every write is made by the app.

Column	Type	Unit	Example	Description
`TASK_ID`	int		42	Run id, as returned by `SRC.SUBMIT_TASK`.
`TASK_TYPE`	string		emissions	The submitted task type, `emissions` or `geospatial`.
`JOB_SPECS`	variant		{"task_type":"emissions","params":{...}}	The task type and parameters exactly as submitted.
`STATUS`	string		COMPLETED	One of `PENDING`, `RUNNING`, `COMPLETED`, `FAILED`, `CANCELLED`.
`ERROR`	string		Unknown scenario: ipcc_net_zero	Why the run failed or was cancelled. Empty on a successful run.
`CREATED_DATETIME`	timestamp	Timestamp	2026-09-02 04:10:03	When the run was submitted.
`COMPLETED_DATETIME`	timestamp	Timestamp	2026-09-02 04:15:22	When the run reached a final status. Empty while it is still running.
`EXCLUSIONS`	variant		[{"identifier":"XS123...","reason":"no emissions data found"}]	Holdings the run could not process, and why. Empty when everything resolved.
`INPUT_RECORDS`	number		25	How many input records the run processed. Recorded for trial listings, where it counts towards the trial allowance.

Timestamps are returned in your Snowflake session's timezone. Wrap them in CONVERT_TIMEZONE('UTC', ...) if you need UTC.

Climate scenarios¶

Transition risk and temperature alignment are reported for 16 scenarios. The user interface runs all of them; a SQL run uses all of them unless the scenarios parameter names a subset. An id outside this list fails the run before any compute.

Pass the id. The results table stores the scenario name, so TRANSITION_RISK_SCENARIO holds NGFS_NetZero2050 for a run submitted with ngfs_net_zero.

Id you pass	Stored as	Warming	Description
`ipcc_ar6_sustainable_dev`	`IPCC_AR6_SustDev`	1.2°C	Sustainable Development. Pairs deep decarbonisation with broader sustainability goals. Lowest-temperature pathway in the AR6 set. Recommended AR6 low emissions scenario.
`ipcc_ar6_low_demand`	`IPCC_AR6_LowDemand`	1.3°C	Low Demand. Reaches below 1.5°C mainly through energy and material efficiency, electrification, and demand-side change, with minimal reliance on carbon dioxide removal.
`ipcc_ar6_high_renewables`	`IPCC_AR6_HighRen`	1.4°C	High Renewables. Rapid near-term scale-up of solar and wind plus electrification of end uses. Supply-side transformation as the central lever.
`ipcc_ar6_1p5_neg_emissions`	`IPCC_AR6_1p5NegEm`	1.5°C	Negative Emissions Trajectory. Slower fossil phase-out, compensated by large-scale carbon dioxide removal delivering net-negative emissions later in the century.
`ipcc_ar6_gradual`	`IPCC_AR6_Gradual`	1.7°C	Gradual Strengthening. Holds to current NDCs through 2030 then accelerates sharply, capturing the cost of delayed ambition. Recommended AR6 medium emissions scenario.
`ipcc_ar6_moderate_action`	`IPCC_AR6_ModAction`	2.7°C	Moderate Action. Modest tightening beyond today's policies but well short of Paris alignment. Emissions peak late and warming overshoots 2°C.
`ipcc_ar6_current_policies`	`IPCC_AR6_Current`	3.0°C	Current Policies. Implements only legislated and operational policies, no new pledges, no NDC tightening, leading to roughly 3°C warming.
`ipcc_ar6_bau`	`IPCC_AR6_BAU`	3.5°C	Business as Usual. High-end stress test based on a CD-LINKS "National Policies Included" baseline: minimal additional climate action and continued high fossil dependence. Recommended AR6 high emissions scenario.
`ipr_fps`	`IPR_FPS`	2.3°C	Inevitable Policy Response, Forecast Policy Scenario. Forecast of the policy response governments are likely to enact as climate impacts intensify. Realistic but late and forceful.
`ngfs_low_demand`	`NGFS_LowDemand`	1.4°C	Low Demand. Reaches Paris-aligned outcomes mainly through efficiency, electrification, and behavioural change, with reduced reliance on carbon dioxide removal.
`ngfs_net_zero`	`NGFS_NetZero2050`	1.5°C	Net Zero 2050. Immediate, coordinated policy action with a smooth carbon-price trajectory to reach global net-zero by 2050. Recommended NGFS low emissions scenario.
`ngfs_delayed_transition`	`NGFS_Delayed`	1.6°C	Delayed Transition. Climate policy stalls until 2030 then tightens abruptly to catch up, producing sharp repricing and stranded-asset risk.
`ngfs_below_two_degree`	`NGFS_TwoDeg`	1.8°C	Below 2°C. Gradual strengthening of policy to hold warming below 2°C, less ambitious than Net Zero 2050 but still coordinated. Recommended NGFS medium emissions scenario.
`ngfs_ndc`	`NGFS_NDC`	2.5°C	NDC. Only the current Nationally Determined Contributions are implemented, with no further tightening, driving high physical risk later in the century.
`ngfs_fragmented_world`	`NGFS_Fragmented`	2.6°C	Fragmented World. Uncoordinated, region-by-region policy response producing divergent carbon prices and uneven transition costs.
`ngfs_current_policies`	`NGFS_Current`	3.3°C	Current Policies. No additional policy action beyond what is already legislated, leading to roughly 3.3°C warming and severe physical risk. Recommended NGFS high emissions scenario.

Geospatial Risk uses its own warming scenarios rather than these: baseline, rcp4p5 and rcp8p5, each at 2030, 2050 and 2080. They are reported for every asset and need no parameter.