Entity Taxonomy Revenue

entity_taxonomy_revenue is the headline table of the revenue dataset: one best-available revenue figure per entity, taxon and year, combining all available data origins. Use it whenever you want a company’s revenue exposure to a taxonomy activity, theme or SDG without worrying about where the underlying data came from. It is an aggregation of the entity_segment_revenue table, grouping by taxon_id, and excluding segments which have a value <0, such as eliminations.

Versioned — filter is_current = TRUE.

Data origins

Revenue for the same entity and year can be known from several origins. Each row states its origin, and data_origin_rank orders origins by preference where multiple exist:

`data_origin`	Meaning
`reported`	From the company’s own segment disclosures (via `entity_segment_revenue`)
`psi`	Modelled by the Net Purpose estimation layer

`entity_taxonomy_revenue`

Column	Type	Description
`entity_taxonomy_revenue_id`	VARCHAR (UUID)	Primary key
`entity_id`	NUMBER	Who. Joins to `entities`
`year`	NUMBER	Fiscal year
`taxon_id`	NUMBER	The taxonomy activity; NULL for revenue not mapped to any taxon. Joins to `taxonomy`
`data_origin`	VARCHAR	Where the figure comes from (see above)
`data_origin_class_id`	NUMBER	1 = Reported, 2 = Derived, 3 = Estimated (see Conventions)
`revenue_amount`	FLOAT	Revenue attributed to the taxon, USD
`revenue_pct`	FLOAT	Share of the entity’s total revenue
`confidence`	NUMBER	Confidence score of the mapping
`data_origin_rank`	NUMBER	1 = the preferred origin for this entity/year
`year_rank`	NUMBER	1 = most recent year available for the entity

For the single best view per entity and year, filter data_origin_rank = 1; add year_rank = 1 for the latest year only.

Example: latest taxonomy revenue for one company

SELECT t.name                AS taxon,
       t.sdg_alignment_type AS alignment,
       ts.goal               AS SDG,
       etr.year,
       etr.revenue_amount,
       etr.revenue_pct
FROM NET_PURPOSE_REVENUE.REVENUE.ENTITY_TAXONOMY_REVENUE etr
LEFT JOIN NET_PURPOSE.REFERENCE.TAXONOMY t
  ON t.taxon_id = etr.taxon_id
WHERE etr.is_current = TRUE
  AND etr.entity_id = 12345
  AND etr.year_rank = 1
ORDER BY etr.revenue_pct DESC;