> ## 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_hoodi.raw.ideal_rewards` |
| Table Status      | Beta 🌱                          |
| Clustering Key(s) | `to_date("epoch_timestamp")`     |

### Table Columns

| Column Name           | Data Type         | Description                                                                                                  |
| --------------------- | ----------------- | ------------------------------------------------------------------------------------------------------------ |
| epoch\_number         | NUMBER(38,0)      | Epoch number.                                                                                                |
| epoch\_timestamp      | TIMESTAMP\_NTZ(9) | Epoch timestamp.                                                                                             |
| execution\_optimistic | BOOLEAN           | A boolean indicating whether the execution of rewards for the specified epoch is done optimistically or not. |
| effective\_balance    | NUMBER(38,0)      | The effective balance for the ideal reward calculation.                                                      |
| head                  | VARCHAR(16777216) | The reward for attesting to the head block.                                                                  |
| target                | VARCHAR(16777216) | The reward for attesting to the target block.                                                                |
| source                | VARCHAR(16777216) | The reward for attesting to the source block.                                                                |
| inclusion\_delay      | VARCHAR(16777216) | (Optional) The reward for including the attestation in a block with a specific delay.                        |
| inactivity            | VARCHAR(16777216) | (Optional) The inactivity penalty for the ideal reward calculation.                                          |
| \_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.                                                |