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

2022-06-29T04:30:41Z

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

New page

{{ArticleSimplifiedWikiEdit
|DisplayName=Table CTL_EXTRACT_HISTORY
|Context={{#cargo_query:tables=PDMTable|fields=shortDesc|where=_pageName LIKE "{{FULLPAGENAME}}"}}
}}
{{PDMTable
|tableName = CTL_EXTRACT_HISTORY
|shortDesc =
|tableDesc = This table contains information about the last attempted and last successful incremental extraction. The UTC-equivalent value of the date and time and/or a sequence number are provided for the data source table that was used in the last extract attempt. Data source information covers such details as the IDB from which the data was extracted, the ICON instance that populated the IDB, and the application that was the original source of data (T-Server, Outbound Contact Server, and so forth).
|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 = TABLE_NAME
|dataType_Ora = VARCHAR2(255 CHAR)
|dataType_MSSQL = varchar(255)
|dataType_Postgre = varchar(255)
|primaryKey =
|mandatory = yes
|foreignKey =
|default =
|colDesc = The name of the IDB table from which data was extracted.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = DATA_SOURCE_KEY
|dataType_Ora = NUMBER(10)
|dataType_MSSQL = int
|dataType_Postgre = integer
|primaryKey =
|mandatory = yes
|foreignKey =
|default =
|colDesc = The surrogate key that is used to join this table to the CTL_DS table.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = DATA_SOURCE_TYPE
|dataType_Ora = NUMBER(10)
|dataType_MSSQL = int
|dataType_Postgre = integer
|primaryKey =
|mandatory =
|foreignKey =
|default =
|colDesc = The type of the data source server as reported by ICON. This field is set to one of the following values:
* 1 — T-Server
* 2 — Interaction Server
* 3 — OCS Server
* 4 — Configuration Server
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = ROW_COUNT
|dataType_Ora = NUMBER(10)
|dataType_MSSQL = int
|dataType_Postgre = integer
|primaryKey =
|mandatory =
|foreignKey =
|default =
|colDesc = The number of records that are extracted in a given extraction cycle.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = MAX_TIME
|dataType_Ora = TIMESTAMP(3)
|dataType_MSSQL = datetime
|dataType_Postgre = timestamp(3)
|primaryKey =
|mandatory =
|foreignKey =
|default =
|colDesc = The date and time, in the Genesys Info Mart server time zone, that represent the highest timestamp value for the records that are extracted in a given extraction cycle.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = MAX_TS
|dataType_Ora = NUMBER(10)
|dataType_MSSQL = int
|dataType_Postgre = integer
|primaryKey =
|mandatory =
|foreignKey =
|default =
|colDesc = The UTC-equivalent value of the date and time that represents the highest timestamp value for the records that are extracted in a given extraction cycle.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = ICON_DBID
|dataType_Ora = NUMBER(10)
|dataType_MSSQL = int
|dataType_Postgre = integer
|primaryKey =
|mandatory = yes
|foreignKey =
|default = 0
|colDesc = ID that uniquely identifies the ICON application instance. The value is the same as the one that ICON provided in the IDB.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = DSS_ID
|dataType_Ora = NUMBER(10)
|dataType_MSSQL = int
|dataType_Postgre = integer
|primaryKey =
|mandatory =
|foreignKey =
|default =
|colDesc = The data source session identifier that is used in a given extraction cycle.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = PROVIDERTAG
|dataType_Ora = NUMBER(10)
|dataType_MSSQL = int
|dataType_Postgre = integer
|primaryKey =
|mandatory =
|foreignKey =
|default =
|colDesc = The ID of the ICON provider class, such as 5 for the configuration information provider (cfg). This field is reserved.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = EXTRACT_START_TIME
|dataType_Ora = TIMESTAMP(3)
|dataType_MSSQL = datetime
|dataType_Postgre = timestamp(3)
|primaryKey =
|mandatory =
|foreignKey =
|default =
|colDesc = The date and time when the extraction job started.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = EXTRACT_END_TIME
|dataType_Ora = TIMESTAMP(3)
|dataType_MSSQL = datetime
|dataType_Postgre = timestamp(3)
|primaryKey =
|mandatory =
|foreignKey =
|default =
|colDesc = The date and time when the extraction job finished.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = JOB_ID
|dataType_Ora = VARCHAR2(64 CHAR)
|dataType_MSSQL = varchar(64)
|dataType_Postgre = varchar(64)
|primaryKey =
|mandatory = yes
|foreignKey =
|default =
|colDesc = ID that uniquely identifies the execution instance of the job.
|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 that extracted data--for example, Job_ExtractICON.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = JOB_VERSION
|dataType_Ora = VARCHAR2(64 CHAR)
|dataType_MSSQL = varchar(64)
|dataType_Postgre = varchar(64)
|primaryKey =
|mandatory =
|foreignKey =
|default =
|colDesc = The version of the job that extracted data--for example, 8.1.000.10.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = DAP_NAME
|dataType_Ora = VARCHAR2(255 CHAR)
|dataType_MSSQL = varchar(255)/nvarchar(255)
|dataType_Postgre = varchar(255)
|primaryKey =
|mandatory =
|foreignKey =
|default =
|colDesc = The name of the Database Access Point (DAP) through which data was extracted.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = CREATE_AUDIT_KEY
|dataType_Ora = NUMBER(19)
|dataType_MSSQL = numeric(19)
|dataType_Postgre = numeric(19)
|primaryKey =
|mandatory = yes
|foreignKey = yes
|default =
|colDesc = The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data creation. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools--that is, applications that need to identify newly added data.
|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 extraction job started.
|introduced =
|modified =
|discontinued =
}}

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

{{PDMRef
|parentTable = CTL_AUDIT_LOG
|parentColumn = AUDIT_KEY
|foreignKey = CREATE_AUDIT_KEY
}}

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

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