Business Glossary¶

This glossary defines key business terms used throughout the EWE Numera data platform. Terms are organized by domain.

Core Trading Concepts¶

Deal¶

A contractual agreement between two parties to buy or sell a commodity (energy, gas, power) at a specified price and delivery schedule. Each deal has a unique deal_id that persists across amendments.

Deal Side¶

A single deal may have multiple "sides" representing different delivery parameters, pricing legs, or settlement terms. Each side has a param_seq_id identifier.

Transaction (Tran)¶

A specific version of a deal. When a deal is amended, a new transaction is created with a new tran_id while the deal_id remains constant. The tran_version increments with each amendment.

Portfolio¶

A logical grouping of deals for P&L reporting and risk management purposes. Examples: GAS_Trading, POWER_ShortTerm, POWER_Origination.

Instrument¶

The product type being traded. Common instruments include: - GAS-PHYS: Physical gas delivery - POWER-PHYS: Physical power delivery - GAS-FIN: Gas financial derivative - POWER-FIN: Power financial derivative

Counterparty¶

The external party on the other side of a trade. Counterparties are organized into: - Legal Entity (LEntity): The legal contracting party - Business Unit (BUnit): The operational unit within the legal entity

P&L and Valuation¶

Metric Date¶

The "as-of" date for valuations. All P&L and risk metrics are calculated as of a specific metric date.

Reval Type¶

The type of valuation: - MTM (Mark-to-Market): Current market value - Settlement: Actual settled amounts

Realized P&L¶

Profit or loss from transactions that have been settled (payment received or made).

Unrealized P&L¶

Profit or loss from open positions that have not yet been settled, based on current market prices.

Delivery Month¶

The month when commodity delivery occurs. P&L is often analyzed by delivery month to understand forward exposure.

Payment Month¶

The month when payment is expected for delivered commodities.

Volume and Scheduling¶

Volume¶

The quantity of commodity being traded, typically measured in: - MWh: Megawatt-hours (power and gas) - Therms: Heat energy units (gas)

Schedule¶

The operational delivery plan specifying when and how much commodity will be delivered. Schedules have granular time periods (e.g., 15-minute intervals for power).

Nomination¶

The formal communication of scheduled volumes to counterparties, grid operators, or pipelines.

Period¶

A time interval for volume delivery: - 15-minute: Standard power market interval (96 periods per day) - Hourly: Hourly aggregation - Daily: Daily totals

Best Available¶

A flag (is_best_available = TRUE) indicating the most current schedule data. Always filter on this for operational reporting.

Locations¶

Delivery Location¶

The physical location where commodity is delivered.

Receipt Location¶

The physical location where commodity is received (for pipeline transportation).

Control Area / Grid¶

The electrical grid zone for power delivery. EWE operates in German control areas.

Pipeline¶

The gas transportation network for gas delivery.

Credit Exposure¶

Current Exposure¶

The mark-to-market exposure at the present date. Represents what would be lost if the counterparty defaulted today.

Performance Exposure¶

Expected exposure based on deal performance, assuming the counterparty continues to perform under the contract.

Potential Exposure (PEX)¶

Worst-case future exposure, calculated using statistical methods and stress scenarios.

Settlement Exposure¶

Exposure arising from potential settlement failures, typically for short periods around payment dates.

PEX Factor¶

A commodity-specific multiplier used in potential exposure calculations. Different commodities have different volatility characteristics.

Exposure Line¶

A credit limit assigned to a counterparty. Exposures are measured against exposure lines to monitor credit utilization.

Netting¶

The practice of offsetting positive and negative exposures: - Payment Netting: Netting of payment obligations - Close-out Netting: Netting in the event of default - Cross-Commodity Netting: Netting across different commodity types

Collateral Agreement¶

An agreement specifying collateral requirements to mitigate credit exposure.

Clearing Bank Concepts¶

Clearing Bank¶

A financial institution that provides clearing services for exchange-traded derivatives. EWE uses: - ABN AMRO Clearing Bank N.V. - BNP Paribas S.A.

Open Position¶

Outstanding futures or options contracts held with a clearing bank.

Variation Margin¶

Daily settlement of gains and losses on open positions.

OTE (Open Trade Equity)¶

The unrealized profit or loss on open positions.

Settlement Price¶

The official closing price used for margin calculations.

Risk Metrics¶

Delta¶

Price sensitivity expressed as an equivalent volume position. Shows how much P&L changes for a unit price movement.

VaR (Value at Risk)¶

A statistical measure of potential loss over a specified time horizon at a given confidence level (e.g., 95% VaR, 99% VaR).

Stress Test¶

Valuation of portfolio under adverse market scenarios.

Index¶

A reference price for commodity pricing. Common indices: - TTF: Dutch gas hub - NBP: UK gas hub - EEX: European power exchange

Transaction Status¶

Deals progress through lifecycle statuses:

Status	Description
New	Recently created, not yet validated
Validated	Approved and active
Amended	Modified from original terms
Matured	Delivery completed
Cancelled	Terminated before completion

For business reporting, typically filter to: tran_status IN ('Validated', 'Matured', 'Amended')

Identifiers¶

Identifier	Description	Scope
`deal_id`	Persistent deal identifier	Survives amendments
`tran_id`	Transaction identifier	Unique per version
`tran_version`	Amendment sequence number	Increments with changes
`param_seq_id`	Deal side identifier	Unique within a deal
`ins_num`	Endur internal number	Source system ID

Time Concepts¶

Concept	Description
Trade Date	When the deal was executed
Delivery Start/End	Period of commodity delivery
Payment Date	When payment is due
Metric Date	As-of date for valuations

Parties¶

Internal Party¶

EWE's own business units and legal entities that are party to trades.

External Party¶

Counterparties outside EWE's organization.

Trader¶

The individual who executed the trade.

Common Dimension Prefixes¶

Prefix	Meaning
`dim_`	Dimension table
`fct_`	Fact table
`_id`	Surrogate key column
`_key`	Hash key column
`_attribute`	Deal-level dimension
`_sub_attribute`	Side-level dimension

EWE-Specific Terms¶

Business Case¶

A categorization of power trading activity by trading strategy or desk. Used in short-term power trading analysis.

E17 Archive¶

Historical deal data from the legacy E17 data warehouse extraction system, retained for historical analysis and validation.

UDSR (User-Defined Stored Result)¶

Endur simulation results stored for later retrieval. UDSRs capture credit exposure, party data, and other calculations from batch simulation runs.