PEC-WFM/Current/ETLRef/SrvCntrTbls - Revision history

WikiSysop: Text replacement - "\|Platform=([^\|])GenesysEngage-onpremises([\|])" to "|Platform=$1GenesysEngage-cloud$2"

2020-07-25T02:39:12Z

Text replacement - "\|Platform=([^\|]*)GenesysEngage-onpremises([\|]*)" to "|Platform=$1GenesysEngage-cloud$2"

WikiSysop: Text replacement - "\|Platforms?=([^\|])PureEngage([\|])" to "|Platform=$1GenesysEngage-onpremises$2"

2020-07-15T11:46:29Z

Text replacement - "\|Platforms?=([^\|]*)PureEngage([\|]*)" to "|Platform=$1GenesysEngage-onpremises$2"

Bgrenon: Published

2020-06-08T15:20:10Z

Published

New page

{{Article
|Standalone=No
|DisplayName=Service and Control tables
|TocName=Service and Control tables
|Context=Find information about the Service and Control tables used in the Workforce Management (WFM) ETL Database schema.
|ComingSoon=No
|Platform=PureEngage
|Role=Administrator
|Prereq=
|Section={{Section
|sectionHeading=
|anchor=
|alignment=Vertical
|Media=
|image=
|structuredtext=Only the Service and Control tables in the Workforce Management (WFM) ETL Database schema that are relevant for customer use are described here. Other Service and Control tables (for example, WM_DB_VERSION) are internal tables and not relevant for customer use.
|structuredtextwide=
|FAQHeading=
|Status=No
}}{{Section
|sectionHeading=CTL_ETL_HISTORY
|anchor=CtlEtlHistory
|alignment=Vertical
|Media=
|image=
|structuredtext=The CTL_ETL_HISTORY table in the WFM ETL Database schema parallels the CTL_ETL_HISTORY table in the Genesys Info Mart database, to indicate the status of ETL processing. A row is added to this table after each job completes.

The ETL cycle is broken down into many small tasks for different types of data and date periods, and the CTL_ETL_HISTORY table is a useful indicator of the status of ETL processing. Failure of even a single small task will result in a value of FAILED in the STATUS field for the whole ETL job. Therefore, a value of FAILED does not necessarily indicate that there is a major ETL problem requiring immediate attention. Genesys recommends that you start monitoring ETL processing more closely if the STATUS field in the table shows a persistently recurring value of FAILED.
|structuredtextwide=
|FAQHeading=
|Status=No
}}{{Section
|sectionHeading=CTL_AUDIT_LOG
|anchor=CtlAuditLog
|alignment=Vertical
|Media=
|image=
|structuredtext=The CTL_AUDIT_LOG table in the WFM ETL Database schema parallels the CTL_AUDIT_LOG table in the Genesys Info Mart database, to allow facts and dimensions to be described by data lineage attributes.
|structuredtextwide=
|FAQHeading=
|Status=No
}}{{Section
|sectionHeading=More information
|anchor=MoreInformation
|alignment=Vertical
|Media=
|image=
|structuredtext=For more information about the [https://docs.genesys.com/Documentation:GIM:PDMMS:Table-CTL_ETL_HISTORY CTL_ETL_HISTORY] and [https://docs.genesys.com/Documentation:GIM:PDMMS:Table-CTL_AUDIT_LOG CTL_AUDIT_LOG] tables in the Info Mart database, see the ''[https://docs.genesys.com/Documentation:GIM:PDMMS:Welcome Genesys Info Mart Physical Data Model for a Microsoft SQL Server Database]''.
|structuredtextwide=
|FAQHeading=
|Status=No
}}
}}

@@ Line 5: / Line 5: @@
 |Context=Find information about the Service and Control tables used in the Workforce Management (WFM) ETL Database schema.
 |ComingSoon=No
-|Platform=GenesysEngage-onpremises
+|Platform=GenesysEngage-cloud
 |Role=Administrator
 |Prereq=

PEC-WFM/Current/ETLRef/SrvCntrTbls - Revision history

WikiSysop: Text replacement - "\|Platform=([^\|]*)GenesysEngage-onpremises([\|]*)" to "|Platform=$1GenesysEngage-cloud$2"

WikiSysop: Text replacement - "\|Platforms?=([^\|]*)PureEngage([\|]*)" to "|Platform=$1GenesysEngage-onpremises$2"

Bgrenon: Published

WikiSysop: Text replacement - "\|Platform=([^\|])GenesysEngage-onpremises([\|])" to "|Platform=$1GenesysEngage-cloud$2"

WikiSysop: Text replacement - "\|Platforms?=([^\|])PureEngage([\|])" to "|Platform=$1GenesysEngage-onpremises$2"