View-ADMIN_EXTRACT_HISTORY

Description

This view provides information about the data that is extracted from each source database table. A row is added to this view after Job_ExtractICON successfully completes extracting a source data table. Rows in this view are written once and are not updated.

Column List

Column	Description
JOB_ID	ID that uniquely identifies the execution instance of the job.
JOB_NAME	The name of the job, such as Job_ExtractICON.
JOB_VERSION	The version of the job, such as 8.1.000.10.
START_TIME	The date and time at which the first step started (UTC time zone).
END_TIME	The date and time at which the last step ended (UTC time zone).
DURATION	The duration of the job, in seconds.
DBCONNECTION	The name of the Database Access Point (DAP) through which data was extracted.
ICON_DBID	ID that uniquely identifies the ICON application instance. Applies only to tables extracted by Job_ExtractICON.
TABLE_NAME	The name of the table from which data is extracted.
LATEST_DATA_TIME	Provides the highest timestamp value for the records that are extracted in a given extraction cycle.
ROW_COUNT	Provides the number of records that are extracted in a given extraction cycle.