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

> Pending consolidations on the Beacon Chain at a given Epoch, enriched with validator entities

<Warning>
  **Data Retention Notice**: This data is not backfilled and will be regularly
  pruned. Historical pending consolidation data may not be available for past
  epochs.
</Warning>

`beacon.raw.pending_consolidations_enriched` provides epoch-level data on pending consolidations waiting to process in the beacon chain, enriched with detailed validator information for both source and target validators.

This data is only available post-Pectra upgrade.

### Table Column

Unique Key: `slot_number`, `pending_consolidation_index`

| Column Name                            | Description                                                                                                                                                                              |
| -------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| slot\_number                           | Beacon Chain slot number of when the pending consolidation state was indexed                                                                                                             |
| slot\_timestamp                        | Beacon Chain slot timestamp of slot when the pending consolidation state was indexed                                                                                                     |
| pending\_consolidation\_index          | Array index of the pending consolidation for the given epoch                                                                                                                             |
| pending\_consolidation\_count          | Total count of pending consolidations at this slot                                                                                                                                       |
| has\_pending\_consolidations           | Boolean flag indicating whether there are pending consolidations                                                                                                                         |
| source\_index                          | Validator index of the source validator being consolidated                                                                                                                               |
| source\_pubkey                         | The source validator's BLS public key, uniquely identifying them. 48-bytes, hex encoded with 0x prefix, case insensitive                                                                 |
| source\_balance                        | The source validator's balance in ETH                                                                                                                                                    |
| source\_raw\_balance                   | The source validator's balance in gwei (1e9 gwei = 1 ETH on Beacon Chain)                                                                                                                |
| source\_effective\_balance             | The source validator's effective balance in ETH used for consensus calculations                                                                                                          |
| source\_raw\_effective\_balance        | The source validator's effective balance in gwei                                                                                                                                         |
| source\_slashed                        | Boolean flag indicating whether the source validator has been slashed                                                                                                                    |
| source\_status                         | The source validator's status (e.g., active\_ongoing, exited\_unslashed, exited\_slashed)                                                                                                |
| source\_activation\_epoch              | Epoch when the source validator was activated                                                                                                                                            |
| source\_activation\_eligibility\_epoch | Epoch when the source validator became eligible for activation                                                                                                                           |
| source\_exit\_epoch                    | Epoch when the source validator exited or will exit                                                                                                                                      |
| source\_withdrawable\_epoch            | Epoch when the source validator's balance becomes withdrawable                                                                                                                           |
| source\_withdrawal\_credentials        | Source validator's withdrawal credentials, a 32-byte field for verifying the destination of valid withdrawals                                                                            |
| target\_index                          | Validator index of the target validator receiving the consolidation                                                                                                                      |
| target\_pubkey                         | The target validator's BLS public key, uniquely identifying them. 48-bytes, hex encoded with 0x prefix, case insensitive                                                                 |
| target\_balance                        | The target validator's balance in ETH                                                                                                                                                    |
| target\_raw\_balance                   | The target validator's balance in gwei (1e9 gwei = 1 ETH on Beacon Chain)                                                                                                                |
| target\_effective\_balance             | The target validator's effective balance in ETH used for consensus calculations                                                                                                          |
| target\_raw\_effective\_balance        | The target validator's effective balance in gwei                                                                                                                                         |
| target\_slashed                        | Boolean flag indicating whether the target validator has been slashed                                                                                                                    |
| target\_status                         | The target validator's status (e.g., active\_ongoing, exited\_unslashed, exited\_slashed)                                                                                                |
| target\_activation\_epoch              | Epoch when the target validator was activated                                                                                                                                            |
| target\_activation\_eligibility\_epoch | Epoch when the target validator became eligible for activation                                                                                                                           |
| target\_exit\_epoch                    | Epoch when the target validator exited or will exit                                                                                                                                      |
| target\_withdrawable\_epoch            | Epoch when the target validator's balance becomes withdrawable                                                                                                                           |
| target\_withdrawal\_credentials        | Target validator's withdrawal credentials, a 32-byte field for verifying the destination of valid withdrawals                                                                            |
| execution\_optimistic                  | It's true if the response references an unverified execution payload. The optimistic information may be invalidated at a later time. If the field is not present, assume the false value |
| finalized                              | Indicates whether the response data is finalized                                                                                                                                         |
| \_created\_at                          | Timestamp of the pending consolidation data creation                                                                                                                                     |
| \_updated\_at                          | Timestamp of the pending consolidation data update                                                                                                                                       |