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

# Ideal Rewards

### Table Details

| Property          | Value                               |
| ----------------- | ----------------------------------- |
| Table Name        | `beacon.raw.ideal_rewards`          |
| Table Status      | Production-Ready                    |
| Unique Key        | `epoch_number`, `effective_balance` |
| Clustering Key(s) | `to_date("epoch_timestamp")`        |

### Table Columns

| Column Name           | Data Type         | Description                                                                      |
| --------------------- | ----------------- | -------------------------------------------------------------------------------- |
| epoch\_timestamp      | TIMESTAMP\_NTZ(9) | Epoch timestamp when the validator is scheduled to propose a block.              |
| execution\_optimistic | BOOLEAN           | If the slot/epoch is executed optimistically.                                    |
| effective\_balance    | NUMBER(38,0)      | Effective balance of the validator.                                              |
| head                  | VARCHAR(16777216) | 534132                                                                           |
| target                | VARCHAR(16777216) | 1034226                                                                          |
| source                | VARCHAR(16777216) | 552116                                                                           |
| inclusion\_delay      | VARCHAR(16777216) | 0                                                                                |
| inactivity            | VARCHAR(16777216) | 0                                                                                |
| \_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.                    |
| epoch\_number         | NUMBER(38,0)      | Epoch number of the state where the pending deposits to beacon chain is fetched. |