Jump to: navigation, search

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
  • In the Data Type column, varchar/nvarchar 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.)

Table CTL_ETL_HISTORY

Description


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.

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.

WORKFLOW_TYPE

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

JOB_NAME

The name of the job, such as Job_ExtractICON.

JOB_VERSION

The version of the job, such as 8.1.000.10.

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).

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).

GMT_START_TIME

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

GMT_END_TIME

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

DURATION

The duration of the job, in seconds.

STATUS

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

CREATED_TS

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


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

No subject area information available.

 

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on 29 August 2016, at 15:01.