Jump to: navigation, search

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.
This page was last edited on January 10, 2020, at 20:48.
Comments or questions about this documentation? Contact us for support!