UserProductivity_viw View

  • Last Changed Version - 17.1.0.324
  • Last Changed Reason - Added for the new Crystal User Productivity report.

SQL Column Definitions

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason
StatisticsSet int False No

17.1.0.324 Added for the new Crystal User Productivity report.
cName nvarchar (50) False Yes

17.1.0.324 Added for the new Crystal User Productivity report.
cReportGroup nvarchar (50) False Depends on customer usage

17.1.0.324 Added for the new Crystal User Productivity report.
cHKey3 nvarchar (50) False No

17.1.0.324 Added for the new Crystal User Productivity report.
cHKey4 nvarchar (50) False No

17.1.0.324 Added for the new Crystal User Productivity report.
dIntervalStartUTC datetime True No

17.1.0.324 Added for the new Crystal User Productivity report.
nEnteredAcd int False No

17.1.0.324 Added for the new Crystal User Productivity report.
nAbandonedAcd int False No

17.1.0.324 Added for the new Crystal User Productivity report.
nAnsweredAcd int False No

17.1.0.324 Added for the new Crystal User Productivity report.
tTalkACD int False No

17.1.0.324 Added for the new Crystal User Productivity report.
tHoldACD int False No

17.1.0.324 Added for the new Crystal User Productivity report.
tAcw int False No

17.1.0.324 Added for the new Crystal User Productivity report.
nExternToInternCalls int False No

17.1.0.324 Added for the new Crystal User Productivity report.
nExternToInternAcdCalls int False No

17.1.0.324 Added for the new Crystal User Productivity report.
nInternToExternCalls int False No

17.1.0.324 Added for the new Crystal User Productivity report.
nInternToExternAcdCalls int False No

17.1.0.324 Added for the new Crystal User Productivity report.
tExternToInternCalls int False No

17.1.0.324 Added for the new Crystal User Productivity report.
tExternToInternAcdCalls int False No

17.1.0.324 Added for the new Crystal User Productivity report.
tInternToExternCalls int False No

17.1.0.324 Added for the new Crystal User Productivity report.
tInternToExternAcdCalls int False No

17.1.0.324 Added for the new Crystal User Productivity report.
nTransferedAcd int False No

17.1.0.324 Added for the new Crystal User Productivity report.
nFlowOutAcd int False No

17.1.0.324 Added for the new Crystal User Productivity report.
SiteId smallint False No

17.1.0.324 Added for the new Crystal User Productivity report.
DimensionSet int False No

17.1.0.324 Added for the new Crystal User Productivity report.
ConfigurationSet int False No

17.1.0.324 Added for the new Crystal User Productivity report.