PureEngage On-Premises

Hello,
when I define a new Exception Type (e.g. "on-line training") using WFM, and I associate it only to one site (e.g. "SiteA"), on WFM_STATE table on WFM ETL DB I find the "on-line training" Exception Type associated to all Sites defined under all Business Unit in my Enterprise.
If I define a new Site (e.g. "SiteZ"), the "on-line training" Exception Type is not associated to the SiteZ in WFM_STATE ETL table.
When I delete from WFM "on-line training" Exception Type, it is still recorded in WFM_STATE ETL table.

No column is availabe to understand which wfm_site - wfm_state association is valid.

Does anyone know if this is a normal behaviour?

Thank you,
Luca

Hello Luca,
There are two types of tables in the ETL database.  Dimension and Schedule Fact.    WFM State is a Dimension type table which means it retains the objects as an identifier.   The Fact tables would look to the Dimension tables for the objects existence.
Dimension Tables             Schedule Fact Tables
WFM_BU                         WFM_SCH_AGENT_DAY
WFM_SITE                        WFM_SCH_AGENT_STATE
WFM_TEAM
WFM_SSG
WFM_STATE