| epoch_number | NUMBER(38,0) | Epoch number of the state where the pending deposits to beacon chain is fetched. |
| 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. |
| deposit_index | NUMBER(38,0) | (Nullable) Deposit index of the entry from the Execution Layer. This is based on the order of deposits from Execution Layer to Beacon Chain via EIP-6110. NULL when the pending deposit originates from consensus layer operations (e.g., validator consolidations via EIP-7251, or excess balance from exiting validators) rather than the execution layer deposit contract. |
| deposit_slot | NUMBER(38,0) | The slot number where the deposit is made into beacon chain. When slot=0 (GENESIS_SLOT), this indicates the pending deposit did NOT originate from the Execution Layer - typically from validator consolidations (EIP-7251) or excess balance from exiting validators. These deposits are created by consensus layer operations and will have deposit_index=NULL. |
| pubkey | VARCHAR(16777216) | The validator’s BLS public key, uniquely identifying them. 48-bytes, hex encoded with 0x prefix, case insensitive. |
| status | VARCHAR(16777216) | (Nullable) Current status of the validator. Once a validator has been processed and added to the beacon state’s validators, the validator’s status is defined by the status of the ValidatorRecord in the beacon state. |
| exit_epoch | VARCHAR(16777216) | Epoch when validator exited. |
| eth_pending | FLOAT | Amount of ETH that is pending for deposits for the validator. |
| eth_in_queue | FLOAT | The total amount of ETH in front of the validator waiting to be processed for deposits. |
| epoch_to_entry | FLOAT | Estimated number of epochs to entry for deposits base on the current churn rate. |
| est_entry_epoch | FLOAT | Estimated entry epoch number where the deposit is expected to be processed. |
| est_entry_timestamp | TIMESTAMP_NTZ(0) | Estimated entry timestamp where the deposit is expected to be processed. |
| _pending_deposit_updated_at | TIMESTAMP_NTZ(9) | Timestamp of the entry update for pending deposits. |
| _balances_latest_updated_at | TIMESTAMP_NTZ(9) | Timestamp of the entry update for beacon state balances. |
