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
JOB_ID	Oracle: VARCHAR2(64 CHAR) MSSQL: varchar(64) PostgreSQL: varchar(64)	X	X
WORKFLOW_TYPE	Oracle: VARCHAR2(32 CHAR) MSSQL: varchar(32) PostgreSQL: varchar(32)	X	X
JOB_NAME	Oracle: VARCHAR2(32 CHAR) MSSQL: varchar(32) PostgreSQL: varchar(32)
JOB_VERSION	Oracle: VARCHAR2(32 CHAR) MSSQL: varchar(32) PostgreSQL: varchar(32)
LOCAL_START_TIME	Oracle: TIMESTAMP(3) MSSQL: datetime PostgreSQL: timestamp(3)
LOCAL_END_TIME	Oracle: TIMESTAMP(3) MSSQL: datetime PostgreSQL: timestamp(3)
GMT_START_TIME	Oracle: TIMESTAMP(3) MSSQL: datetime PostgreSQL: timestamp(3)
GMT_END_TIME	Oracle: TIMESTAMP(3) MSSQL: datetime PostgreSQL: timestamp(3)
DURATION	Oracle: NUMBER(10) MSSQL: int PostgreSQL: integer
STATUS	Oracle: VARCHAR2(32 CHAR) MSSQL: varchar(32) PostgreSQL: varchar(32)
CREATED_TS	Oracle: NUMBER(10) MSSQL: int PostgreSQL: integer		X