---
title: "SYSTEMPREEMPTIVELOADCANDIDATES (Data Dictionary)"
description: "Pre-emptive Load Candidates"
language: es
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/es/datamodels/datadictionary/DataDictionary.Invantive.SYSTEMPREEMPTIVELOADCANDIDATES
original: https://documentation.invantive.eu/en/datamodels/datadictionary/DataDictionary.Invantive.SYSTEMPREEMPTIVELOADCANDIDATES
updated: 2026-11-16T20:45:26Z
license: https://documentation.invantive.eu/es/
---

# SYSTEMPREEMPTIVELOADCANDIDATES: Data Dictionary Pre-emptive Load Candidates

`read only`

- Catálogo: `DataDictionary`
- Esquema: `Invantive`
- Label: Pre-emptive Load Candidates

The tables which this session may fetch before they are asked for, with who advised each one, how it is weighed and how many rows of it are wanted. One row per table; how far the fetching got is per partition, in SystemPreemptiveLoadingPartitions. Live session state rather than a log: the list is gone when the session ends.

Solo puede recuperar datos.

## Columnas de la Tabla

A continuación se muestran las columnas de la tabla `SYSTEMPREEMPTIVELOADCANDIDATES`. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

| Name | Tipo de Datos | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `ADVISOR` | `varchar2(32)` | Con el asesoramiento de | [x] |  | Who advised it: 'DriverDefault' for the driver of the platform, 'Hint' for something which announced it, and 'Journal' for the earlier questions of this user. |
| `ADVISOR_CONTEXT` | `varchar2(240)` | Con el asesoramiento de Context | [ ] |  | Who gave the hint, where a hint advised it. |
| `CATALOG_NAME` | `varchar2(240)` | Catalog | [ ] |  | Catalog of the object. |
| `DATA_CONTAINER_ALIAS` | `varchar2(240)` | Alias del Contenedor de Datos | [ ] |  | Alias of the data container whose driver proposed it. |
| `ESTIMATED_NUMBER_OF_CALLS` | `int64` | Número estimado de llamadas | [ ] |  | Number of calls one fetch is expected to take, or empty when the driver cannot tell. |
| `ESTIMATED_NUMBER_OF_ROWS` | `int64` | Número Estimado de Filas | [ ] |  | Number of rows the platform is expected to hold, as far as the driver knows. |
| `FRESHNESS_AGE_SEC` | `double` | Edad de frescura | [x] |  | Age in seconds below which what is already cached makes a fetch pointless. |
| `ID` | `int64` | Candidate | [x] |  | Identity of the candidate within the session. |
| `INCLUDE_ON_FIRST_USE` | `boolean` | Incluir en el primer uso | [x] |  | Whether a session with no prior history of earlier use by the use fetches this one. |
| `INTEREST_UNTIL_DATE_UTC` | `datetime` | Intereses hasta la fecha | [ ] |  | Moment until which it is expected to be asked for (UTC), or empty when the expectation is open-ended. |
| `KIND` | `varchar2(32)` | Kind | [x] |  | What has to be done to fetch it: 'IncrementalRefresh', 'PageSet', 'Blobs' or 'Metadata'. |
| `MAXIMUM_NUMBER_OF_ROWS` | `int64` | Número Máximo de Filas | [ ] |  | Number of rows to fetch, or empty for the whole dataset. |
| `PARTITION_CODE` | `varchar2(240)` | Partition | [ ] |  | The partition it covers, when the scope is one partition; empty when the scope is the selected partitions or all of them, since the partitions are then reported per partition in SystemPreemptiveLoadingPartitions. |
| `PARTITION_SCOPE` | `varchar2(32)` | Ámbito de la partición | [x] |  | Which partitions it covers: 'One', 'Selected' or 'All'. |
| `PRIORITY` | `varchar2(32)` | Priority | [x] |  | Allowance made available: 'Always', 'Normal' or 'Spare'. |
| `SCHEMA_NAME` | `varchar2(240)` | Schema | [ ] |  | Schema of the object. |
| `SCORE` | `double` | Score | [x] |  | Calls expected to be saved per call spent, by which candidates are ordered within their priority. |
| `SCORE_FROM_HINT` | `double` | Puntuación desde el anuncio | [x] |  | Part of the score which comes from an announcement that it will be asked for. |
| `SCORE_FROM_JOURNAL` | `double` | Resultado histórico | [x] |  | Part of the score which comes from the earlier questions of this user at this time of day. |
| `SCORE_FROM_PRIOR` | `double` | Diferencia respecto a lo esperado | [x] |  | Part of the score which comes from what the driver expects of this object. |
| `TABLE_NAME` | `varchar2(240)` | Table | [x] |  | Name of the table, table function or view. |

## Referenciado por

- [SYSTEMPREEMPTIVELOADHINTS](DataDictionary.Invantive.SYSTEMPREEMPTIVELOADHINTS) `CANDIDATE_ID` (Key)
- [SYSTEMPREEMPTIVELOADINGPARTITIONS](DataDictionary.Invantive.SYSTEMPREEMPTIVELOADINGPARTITIONS) `CANDIDATE_ID` (Key)


## Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador:

- [Data Dictionary](/es/release-notes/drivers?driver=data-dictionary)
