> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Pending Consolidations Enriched 🌱

### Table Details

| Property | Value |
| - | - |
| Table Name | `beacon.raw.pending_consolidations_enriched` |
| Table Status | Beta 🌱 |
| Unique Key | `slot_number`, `pending_consolidation_index` |
| Clustering Key(s) | `to_date("slot_timestamp")` |

### Table Columns

| Column Name | Data Type | Description |
| - | - | - |
| slot\_number | NUMBER(38,0) | Slot number of the state where the pending deposits to beacon chain is fetched. |
| slot\_timestamp | TIMESTAMP\_NTZ(9) | Slot timestamp of the state where the pending deposits to beacon chain is fetched. |
| source\_index | NUMBER(38,0) | Validator index of the source validator being consolidated |
| source\_pubkey | VARCHAR(16777216) | The source validator's BLS public key, uniquely identifying them. 48-bytes, hex encoded with 0x prefix, case insensitive |
| source\_raw\_balance | VARCHAR(16777216) | The source validator's balance in gwei (1e9 gwei = 1 ETH on Beacon Chain) |
| source\_balance | FLOAT | The source validator's balance in ETH |
| source\_raw\_effective\_balance | VARCHAR(16777216) | The source validator's effective balance in gwei |
| source\_effective\_balance | FLOAT | The source validator's effective balance in ETH used for consensus calculations |
| source\_activation\_epoch | VARCHAR(16777216) | Epoch when the source validator was activated |
| source\_activation\_eligibility\_epoch | VARCHAR(16777216) | Epoch when the source validator became eligible for activation |
| source\_exit\_epoch | VARCHAR(16777216) | Epoch when the source validator exited or will exit |
| source\_withdrawable\_epoch | VARCHAR(16777216) | Epoch when the source validator's balance becomes withdrawable |
| source\_status | VARCHAR(16777216) | The source validator's status (e.g., active\_ongoing, exited\_unslashed, exited\_slashed) |
| source\_slashed | BOOLEAN | Boolean flag indicating whether the source validator has been slashed |
| source\_withdrawal\_credentials | VARCHAR(16777216) | Source validator's withdrawal credentials, a 32-byte field for verifying the destination of valid withdrawals |
| target\_index | NUMBER(38,0) | Validator index of the target validator receiving the consolidation |
| target\_pubkey | VARCHAR(16777216) | The target validator's BLS public key, uniquely identifying them. 48-bytes, hex encoded with 0x prefix, case insensitive |
| target\_raw\_balance | VARCHAR(16777216) | The target validator's balance in gwei (1e9 gwei = 1 ETH on Beacon Chain) |
| target\_balance | FLOAT | The target validator's balance in ETH |
| target\_raw\_effective\_balance | VARCHAR(16777216) | The target validator's effective balance in gwei |
| target\_effective\_balance | FLOAT | The target validator's effective balance in ETH used for consensus calculations |
| target\_activation\_epoch | VARCHAR(16777216) | Epoch when the target validator was activated |
| target\_activation\_eligibility\_epoch | VARCHAR(16777216) | Epoch when the target validator became eligible for activation |
| target\_exit\_epoch | VARCHAR(16777216) | Epoch when the target validator exited or will exit |
| target\_withdrawable\_epoch | VARCHAR(16777216) | Epoch when the target validator's balance becomes withdrawable |
| target\_status | VARCHAR(16777216) | The target validator's status (e.g., active\_ongoing, exited\_unslashed, exited\_slashed) |
| target\_slashed | BOOLEAN | Boolean flag indicating whether the target validator has been slashed |
| target\_withdrawal\_credentials | VARCHAR(16777216) | Target validator's withdrawal credentials, a 32-byte field for verifying the destination of valid withdrawals |
| execution\_optimistic | BOOLEAN | If the slot/epoch is executed optimistically. |
| finalized | BOOLEAN | If the slot/epoch is finalized. |
| pending\_consolidation\_index | NUMBER(38,0) | Array index of the pending consolidation for the given epoch |
| has\_pending\_consolidations | BOOLEAN | Boolean flag indicating whether there are pending consolidations |
| pending\_consolidation\_count | NUMBER(38,0) | Total count of pending consolidations at this slot |
| \_created\_at | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was created in the database. |
| \_updated\_at | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was last updated in the database. |