Contents

AgentComplianceOverrides Table

If an agent chooses an override option while using the Follow Up Call feature, there will be a code number in the agentoverride column in the CallHistory table that indicates what type of override occurred. This table is used to identify those code numbers.

By performing an SQL join of the CallHistory table and the AgentComplianceOverrides table, a database administrator can extract the pertinent data.

Note: In addition to identifying overrides from the Follow Up Call feature, this table also identifies overrides from the use of custom Icelib Manual call overrides.

AgentComplianceOverrides Schema

Column Name	Details	Description
Id	tinyint, not null	Code number from the agentoverride column in the CallHistory table.
Filter	bit, not null	This flag indicates whether Filter was overridden. This only applies to custom Icelib Manual Call overrides. If it is a 1, Filter was overridden. If it is a 0, Filter was not a factor.
QueryTimeFilter	bit, not null	This flag indicates whether QueryTimeFilter was overridden. This only applies to custom Icelib Manual Call overrides. If it is a 1, QueryTimeFilter was overridden. If it is a 0, QueryTimeFilter was not a factor.
ZoneBlocking	bit, not null	This flag indicates whether ZoneBlocking was overridden to make the call while using the Follow Up Call feature. If it is a 1, ZoneBlocking was overridden. If it is a 0, ZoneBlocking was not a factor.
Skills	bit, not null	This flag indicates whether Skills was overridden to make the call while using the Follow Up Call feature. If it is a 1, Skills was overridden. If it is a 0, Skills was not a factor.
DailyLimit	bit, not null	This flag indicates whether DailyLimit was overridden to make the call while using the Follow Up Call feature. If it is a 1, DailyLimit was overridden. If it is a 0, DailyLimit was not a factor.
MinimumSpacing	bit, not null	This flag indicates whether MinimumSpacing was overridden. This only applies to custom Icelib Manual Call overrides. If it is a 1, MinimumSpacing was overridden. If it is a 0, MinimumSpacing was not a factor.
PNDStatus	bit, not null	This flag indicates whether PNDStatus was overridden. This only applies to custom Icelib Manual Call overrides. If it is a 1, PNDStatus was overridden. If it is a 0, PNDStatus was not a factor.
DNCScrub	bit, not null	This flag indicates whether DNC was overridden to make the call while using the Follow Up Call feature. If it is a 1, DNC was overridden. If it is a 0, DNC was not a factor.
CampaignOwnership	bit, not null	This flag indicates whether CampaignOwnership was overridden. This only applies to custom Icelib Manual Call overrides. If it is a 1, CampaignOwnership was overridden. If it is a 0, CampaignOwnership was not a factor.