WikiSysop: Created page with "{{ArticleSimplifiedWikiEdit |DisplayName=Table CTL_ETL_HISTORY |Context={{#cargo_query:tables=PDMTable|fields=shortDesc|where=_pageName LIKE "{{FULLPAGENAME}}"}} }} {{PDMTabl..."

2022-06-29T04:30:39Z

Created page with "{{ArticleSimplifiedWikiEdit |DisplayName=Table CTL_ETL_HISTORY |Context={{#cargo_query:tables=PDMTable|fields=shortDesc|where=_pageName LIKE "{{FULLPAGENAME}}"}} }} {{PDMTabl..."

New page

{{ArticleSimplifiedWikiEdit
|DisplayName=Table CTL_ETL_HISTORY
|Context={{#cargo_query:tables=PDMTable|fields=shortDesc|where=_pageName LIKE "{{FULLPAGENAME}}"}}
}}
{{PDMTable
|tableName = CTL_ETL_HISTORY
|shortDesc =
|tableDesc = This table provides information about the execution of each Genesys Info Mart job. A row is added to this table after each job completes.

{{NoteFormat|Genesys recommends that you use the <tt>ADMIN_ETL_JOB_HISTORY</tt> view to query the job execution data.|2}}
|subjectAreas =
|introduced =
|modified = 8.5.003 (in Oracle, fields with <tt>VARCHAR</tt> data types use explicit <tt>CHAR</tt> character-length semantics)
|discontinued =
|group =
|partitioned = yes
}}

{{PDMColumn
|colName = JOB_ID
|dataType_Ora = VARCHAR2(64 CHAR)
|dataType_MSSQL = varchar(64)
|dataType_Postgre = varchar(64)
|primaryKey = yes
|mandatory = yes
|foreignKey =
|default =
|colDesc = ID that uniquely identifies the execution instance of the job.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = WORKFLOW_TYPE
|dataType_Ora = VARCHAR2(32 CHAR)
|dataType_MSSQL = varchar(32)
|dataType_Postgre = varchar(32)
|primaryKey = yes
|mandatory = yes
|foreignKey =
|default =
|colDesc = The name of the step of the job, such as Outbound.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = JOB_NAME
|dataType_Ora = VARCHAR2(32 CHAR)
|dataType_MSSQL = varchar(32)
|dataType_Postgre = varchar(32)
|primaryKey =
|mandatory =
|foreignKey =
|default =
|colDesc = The name of the job, such as Job_ExtractICON.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = JOB_VERSION
|dataType_Ora = VARCHAR2(32 CHAR)
|dataType_MSSQL = varchar(32)
|dataType_Postgre = varchar(32)
|primaryKey =
|mandatory =
|foreignKey =
|default =
|colDesc = The version of the job, such as 8.1.000.10.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = LOCAL_START_TIME
|dataType_Ora = TIMESTAMP(3)
|dataType_MSSQL = datetime
|dataType_Postgre = timestamp(3)
|primaryKey =
|mandatory =
|foreignKey =
|default =
|colDesc = The date and time the first step of the job started (in the time zone where Genesys Info Mart Server is running).

<b>Note:</b> 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.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = LOCAL_END_TIME
|dataType_Ora = TIMESTAMP(3)
|dataType_MSSQL = datetime
|dataType_Postgre = timestamp(3)
|primaryKey =
|mandatory =
|foreignKey =
|default =
|colDesc = The date and time the last step of the job ended (in the time zone where Genesys Info Mart Server is running).

<b>Note:</b> 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.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = GMT_START_TIME
|dataType_Ora = TIMESTAMP(3)
|dataType_MSSQL = datetime
|dataType_Postgre = timestamp(3)
|primaryKey =
|mandatory =
|foreignKey =
|default =
|colDesc = The date and time the first step of the job started (in GMT time zone).
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = GMT_END_TIME
|dataType_Ora = TIMESTAMP(3)
|dataType_MSSQL = datetime
|dataType_Postgre = timestamp(3)
|primaryKey =
|mandatory =
|foreignKey =
|default =
|colDesc = The date and time the last step of the job ended (in GMT time zone).
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = DURATION
|dataType_Ora = NUMBER(10)
|dataType_MSSQL = int
|dataType_Postgre = integer
|primaryKey =
|mandatory =
|foreignKey =
|default =
|colDesc = The duration of the job, in seconds.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = STATUS
|dataType_Ora = VARCHAR2(32 CHAR)
|dataType_MSSQL = varchar(32)
|dataType_Postgre = varchar(32)
|primaryKey =
|mandatory =
|foreignKey =
|default =
|colDesc = The status of the job, such as COMPLETE or FAILED.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = CREATED_TS
|dataType_Ora = NUMBER(10)
|dataType_MSSQL = int
|dataType_Postgre = integer
|primaryKey =
|mandatory = yes
|foreignKey =
|default =
|colDesc = The UTC-equivalent value of the date and time at which the job started.
|introduced =
|modified =
|discontinued =
}}

{{PDMIndex}}
{{PDMIndexItem
|indexName = I_C_ETL_H_CTS
|indexDesc = Improves purge performance.
|indexPresentInPartitioned = yes
|indexKey = CREATED_TS
|keyPresentInNonpartitioned = yes
|sort = Ascending
|unique =
|cluster =
}}

Documentation:PEC-REP/Library/PDMLibraryGIM/Table-CTL ETL HISTORY - Revision history

WikiSysop: Created page with "{{ArticleSimplifiedWikiEdit |DisplayName=Table CTL_ETL_HISTORY |Context={{#cargo_query:tables=PDMTable|fields=shortDesc|where=_pageName LIKE "{{FULLPAGENAME}}"}} }} {{PDMTabl..."