Table CTL_ETL_HISTORY

Description

Modified: 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)

In partitioned databases, this table is partitioned.

This table provides information about the execution of each Genesys Info Mart job. A row is added to this table after each job completes.

Tip

Genesys recommends that you use the ADMIN_ETL_JOB_HISTORY view to query the job execution data.

Tip

To assist you in preparing supplementary documentation, click the following link to download a comma-separated text file containing information such as the data types and descriptions for all columns in this table: Download a CSV file.

Hint: For easiest viewing, open the downloaded CSV file in Excel and adjust settings for column widths, text wrapping, and so on as desired. Depending on your browser and other system settings, you might need to save the file to your desktop first.

Column List

Legend

Column	Data Type	P	M	F	DV
JOB_ID	varchar(64)	X	X
WORKFLOW_TYPE	varchar(32)	X	X
JOB_NAME	varchar(32)
JOB_VERSION	varchar(32)
LOCAL_START_TIME	datetime
LOCAL_END_TIME	datetime
GMT_START_TIME	datetime
GMT_END_TIME	datetime
DURATION	int
STATUS	varchar(32)
CREATED_TS	int		X

JOB_ID

ID that uniquely identifies the execution instance of the job.

>> Back to Column List

WORKFLOW_TYPE

The name of the step of the job, such as Outbound.

>> Back to Column List

JOB_NAME

The name of the job, such as Job_ExtractICON.

>> Back to Column List

JOB_VERSION

The version of the job, such as 8.1.000.10.

>> Back to Column List

LOCAL_START_TIME

The date and time the first step of the job started (in the time zone where Genesys Info Mart Server is running).

Note: Because the Genesys Info Mart Server always runs in the GMT time zone, the value of this field is always the same as GMT_START_TIME.

>> Back to Column List

LOCAL_END_TIME

The date and time the last step of the job ended (in the time zone where Genesys Info Mart Server is running).

Note: Because the Genesys Info Mart Server always runs in the GMT time zone, the value of this field is always the same as GMT_END_TIME.

>> Back to Column List

GMT_START_TIME

The date and time the first step of the job started (in GMT time zone).

>> Back to Column List

GMT_END_TIME

The date and time the last step of the job ended (in GMT time zone).

>> Back to Column List

DURATION

The duration of the job, in seconds.

>> Back to Column List

STATUS

The status of the job, such as COMPLETE or FAILED.

>> Back to Column List

CREATED_TS

The UTC-equivalent value of the date and time at which the job started.

>> Back to Column List

Index List

CODE	U	C	Description
I_C_ETL_H_CTS			Improves purge performance.

Index I_C_ETL_H_CTS

Field	Sort	Comment
CREATED_TS	Ascending

Subject Areas

No subject area information available.