Carbon Extraction

`gee_compensation_events`

Column	Type	Description
`gee_compensation_event_id`	int64	Primary key of the compensation event (`gee_compensation_events.id`).
`tenancy_id`	int64	Tenant that owns the event.
`name`	string	Display name from `data_collect_company_hierarchy` (`name`).
`projects`	string	Related compensation project names, comma-separated.
`start_serial_number`	string	Start of certificate / serial range for the event.
`end_serial_number`	string	End of certificate / serial range.
`status`	string	Workflow status of the compensation event.
`co2_equivalent_emission`	double	Emissions associated with the event scope (t CO₂e).
`co2_equivalent_compensation`	double	Compensated amount (t CO₂e).
`updated_at`	dateTime	Last update at source.
`deleted_at`	dateTime	Soft delete.

Column	Type	Description
`gee_electric_power_emission_by_consumption_id`	string	Synthetic key: `{electric_power_source_id}-{monthly_consumption_id}-{monthlyConsumptionFieldValue}` (month field from dynamic month name).
`gee_electric_power_source_id`	int64	`electric_power_sources.id`.
`tenancy_id`	int64	Tenant of the power source.
`company_id`	int64	Company behind the tenant (`tenancy.company_id`).
`business_group_id`	int64	Business group of that company.
`data_collect_task_id`	int64	Data-collect task driving the inventory cycle.
`month_num`	int32	Calendar month 1–12.
`cycle_name`	string	Name of the data collect cycle (`data_collect_cycles.name`).
`company_name`	string	Company trade or legal name.
`breadcrumb`	string	Navigation breadcrumb from the electric power source (`getBreadcrumb()`).
`year`	string	Inventory year from the cycle (`dataCollectCycle.cycle`).
`month`	string	Month label from `CarbonExtractionHelper::getMonth` (or `'NA'`).
`unit_measure`	string	`kWh` or `GJ` depending on calculation mode (`EnergyBuyTypeEnum::BUY_CHOOSE` → GJ, else kWh).
`consumption`	double	Energy consumption for that month (in `unit_measure`).
`emission`	double	CO₂e emission for that month (`co2EquivalentMonthlyEmission` month field).
`end_of_month_date`	date	Last day of the month for the row (`createEndOfMonthDate`).
`updated_at`	dateTime	Last update of the electric power source.
`deleted_at`	dateTime	Soft delete of the electric power source.

Column	Type	Description
`gee_emission_balance_detail_id`	int64	Primary key of the period row (`gee_emission_by_periods.id`).
`gee_emission_balance_id`	int64	Parent emission balance header (`gee_emission_balances.id`).
`referenced_tenancy_id`	int64	Referenced tenant the balance line refers to (scoped company/tenant in the balance).
`year`	string	Year of the period (as stored on the model).
`month_num`	int32	Month number 1–12 from `MonthEnum`.
`calculate_way`	string	Calculation method / pathway for the line.
`category`	string	GHG inventory category (domain enum / code).
`co2_equivalent_emission`	double	CO₂e for the line (t CO₂e).
`tonne_waste_quantity`	double	Waste quantity in metric tonnes when applicable (`waste_quantity` on model).
`end_of_month_date`	date	Month end date for the period.
`updated_at`	dateTime	Last update at source.
`deleted_at`	dateTime	Soft delete.

Column	Type	Description
`gee_emission_balance_id`	int64	Primary key (`gee_emission_balances.id`).
`business_group_id`	int64	Business group of the balance.
`tenancy_id`	int64	EloCarbon Free tenant id for the group (first tenancy with `system_module_id` = EloCarbon Free among companies in the group).
`referenced_tenancy_id`	int64	Tenant being balanced / reported.
`referenced_company_id`	int64	Company id of `referencedTenancy`.
`referenced_company_name`	string	Trade name, else legal name of the referenced company.
`year`	int32	Balance year (integer).
`month_num`	int32	Month 1–12.
`co2_equivalent_emission`	double	Total emissions (t CO₂e).
`co2_equivalent_compensation`	double	Compensation (t CO₂e); forced to 0 when source value is ≤ 0.
`end_of_month_date`	date	Month end date.
`updated_at`	dateTime	Last update.
`deleted_at`	dateTime	Soft delete.

Column	Type	Description
`gee_environmental_goal_detail_id`	int64	Declared detail id on the DTO (verify runtime population; `environmental_goal_id` + `year` identify the slice for analytics).
`environmental_goal_id`	int64	Parent environmental goal (`environmental_goals.id`).
`year`	string	Calendar year of the KPI row.
`emission_intensity_value`	double	Emission intensity metric for the year.
`production_value`	double	Production driver used in intensity (domain-specific unit).
`emission_value`	double	Emissions total for the slice (aligned with goal logic).
`variation_value`	double	Year-on-year (or plan) variation for reporting.
`reduction_force`	double	Reduction leverage / effort indicator from the goal engine.
`updated_at`	dateTime	Last update of the environmental goal.
`deleted_at`	dateTime	Soft delete of the environmental goal.

Column	Type	Description
`gee_source_detail_id`	string	Synthetic key: `{gee_company_emission_id}-{monthly_emission_id}-{englishMonthName}`.
`gee_company_emission_id`	int64	Note: property is `?string` in the DTO while Parquet is `int64`; `gee_company_emissions.id` is not assigned in `fromModel` today — confirm pipeline / serialization if you rely on this column.
`tenancy_id`	int64	Tenant of the data collect cycle.
`company_id`	int64	Company owning the emission line.
`business_group_id`	int64	Business group of the company.
`data_collect_task_ids`	string	Comma-separated data collect task ids resolved via `DataCollectCompanyHierarchy` for the cycle + category hierarchy type.
`month_num`	int32	Month 1–12.
`cycle_name`	string	Data collect cycle name.
`company_name`	string	Company trade or legal name.
`year`	string	Cycle year (`dataCollectCycle.cycle`).
`month`	string	Localized month label (or `'NA'`).
`scope`	string	GHG scope (1 / 2 / 3 style — domain value).
`category`	string	Inventory category on the emission line.
`gas`	string	Gas or pollutant bucket (e.g. CO₂, CH₄).
`breadcrumb`	string	Hierarchy path (company hierarchy + category label; category segment may be translated via `__()`).
`value`	double	Emission quantity for that month (`monthlyEmission` dynamic month field).
`is_quioto`	boolean	`?bool`
`end_of_month_date`	date	Month end date.
`updated_at`	dateTime	Last update of the company emission record.
`deleted_at`	dateTime	Soft delete.

Column	Type	Description
`gee_waste_movement_emission_id`	int64	Primary key (`gee_waste_movement_emissions.id`).
`gee_emission_by_period_id`	int64	Linked `gee_emission_by_periods.id` (balance detail context).
`waste_movement_id`	int64	`waste_movements.id` for the underlying movement.
`business_group_id`	int64	Business group from `wasteMovement.company`.
`tenancy_id`	int64	Tenant of the waste movement.
`category`	string	Inventory category (e.g. upstream product transport).
`calculate_way`	string	Calculation method used for the line.
`origin_city`	string	Origin city (generator address) when category is `PRODUCTS_TRANSPORT_UPSTREAM`; else null.
`destination_city`	string	Destination city (recycler address) for that category; else null.
`origin_state`	string	Origin state (UF) for that category; else null.
`destination_state`	string	Destination state (UF) for that category; else null.
`distance`	double	Haul distance used in the emission factor chain (domain unit, typically km).
`co2_emission`	double	CO₂ (fossil / non-biogenic component per model).
`ch4_emission`	double	CH₄ emission.
`n2o_emission`	double	N₂O emission.
`co2_equivalent_emission`	double	Total CO₂e.
`co2_bio_emission`	double	Biogenic CO₂ component when modeled separately.
`is_elevated_emission`	boolean	`?bool`
`updated_at`	dateTime	Last update.
`deleted_at`	dateTime	Soft delete.