legal_entities

source

The legal entities we report under.

Definition

One row per legal entity — code, name, country, functional currency. The consolidation dimension; a single default entity is seeded today with structure ready for multi-entity rollups.

8 of 8

Column

Description

Tests · PII

legal_entity_id

Primary key — BIGSERIAL on the source.

2 tests

entity_code

Short unique code (e.g. `US-INC`, `EU-GMBH`).

2 tests

legal_name

Full legal name of the entity.

country

ISO country of incorporation (normalised uppercase in staging).

functional_currency

Functional reporting currency (default `USD`).

is_active

True for entities currently in use.

created_at

Row insert timestamp in the source DB.

updated_at

Row update timestamp in the source DB.