In the Column List:
- P = Primary key
- M = Mandatory field
- F = Foreign key (where the term is used loosely to indicate a surrogate key reference to a field in another table, not a formal constraint)
- DV = Default value
- For Microsoft SQL Server, varchar/nvarchar in the Data Type column means that the data type is varchar except in multi-language databases that use Unicode, in which case the data type is nvarchar. (The Info Mart database in cloud deployments is not multi-language.) THIS BULLET WILL DISPLAY ONLY IN THE PE MSSQL PDM.
- 1 Description
- 2 Column List
- 3 Index List
- 4 Subject Areas
- 5 References
This table contains information about the last attempted and last successful incremental extraction. The UTC-equivalent value of the date and time and/or a sequence number are provided for the data source table that was used in the last extract attempt. Data source information covers such details as the IDB from which the data was extracted, the ICON instance that populated the IDB, and the application that was the original source of data (T-Server, Outbound Contact Server, and so forth).
The name of the IDB table from which data was extracted.
The surrogate key that is used to join this table to the CTL_DS table.
The type of the data source server as reported by ICON. This field is set to one of the following values:
- 1 — T-Server
- 2 — Interaction Server
- 3 — OCS Server
- 4 — Configuration Server
The number of records that are extracted in a given extraction cycle.
The date and time, in the Genesys Info Mart server time zone, that represent the highest timestamp value for the records that are extracted in a given extraction cycle.
The UTC-equivalent value of the date and time that represents the highest timestamp value for the records that are extracted in a given extraction cycle.
ID that uniquely identifies the ICON application instance. The value is the same as the one that ICON provided in the IDB.
The data source session identifier that is used in a given extraction cycle.
The ID of the ICON provider class, such as 5 for the configuration information provider (cfg). This field is reserved.
The date and time when the extraction job started.
The date and time when the extraction job finished.
ID that uniquely identifies the execution instance of the job.
The name of the job that extracted data--for example, Job_ExtractICON.
The version of the job that extracted data--for example, 8.1.000.10.
The name of the Database Access Point (DAP) through which data was extracted.
The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data creation. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools--that is, applications that need to identify newly added data.
The UTC-equivalent value of the date and time at which the extraction job started.
|I_C_EXTRACT_H_CTS||Improves purge performance.|
The summary List of References will include the following entries for this table or view:
|Child Table/View||Child Table/View Column||Parent Table/View||Parent Table/View Column|