# SYSTEMPREEMPTIVELOADHINTS: Data Dictionary System pre-emptive load hints The announcements this session received that a table will be needed shortly, with who announced it and whether a candidate was found for it. Live session state rather than a log. - Catalog: `DataDictionary` - Schema: `Invantive` - Alias: `plh` - Label: System pre-emptive load hints This is a read-only view. The Data Dictionary API may not support changing the data or the Invantive UniversalSQL driver for Data Dictionary does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Data Dictionary API. ## View Columns The columns of the view `SYSTEMPREEMPTIVELOADHINTS` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `CANDIDATE_ID` | `int64` | Candidate | ☐ | Candidate it raised, or empty when nothing matched. | | `CATALOG_NAME` | `varchar2(240)` | Catalog | ☐ | Catalog named in the announcement, or empty for any. | | `CONTEXT` | `varchar2(240)` | Announced By | ☐ | Who announced it. | | `EXPIRED_DATE_UTC` | `datetime` | Expired Date | ☑ | Moment at which the announcement has decayed to nothing (UTC). | | `HONOURED` | `boolean` | Honoured | ☑ | Whether a candidate was found for it. | | `PARTITION_CODE` | `varchar2(240)` | Partition | ☐ | Partition announced, or empty for the partitions in scope. | | `RECEIVED_DATE_UTC` | `datetime` | Received Date | ☑ | Moment the announcement was received (UTC). | | `SCHEMA_NAME` | `varchar2(240)` | Schema | ☐ | Schema named in the announcement, or empty for any. | | `TABLE_NAME` | `varchar2(240)` | Table | ☑ | Name of the table announced. | | `WITHIN_SEC` | `double` | Within | ☑ | Number of seconds within which it was announced to be needed. |