> ## 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.                                                            |