user_calldetail_viw View

  • Last Changed Version - 17.1.0.324
  • Last Changed Reason - Added for the new Crystal Call Detail report.

SQL Column Definitions

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason
CallId char (18) False Unknown

17.1.0.324 Added for the new Crystal Call Detail report.
CallType varchar (20) True Unknown

17.1.0.324 Added for the new Crystal Call Detail report.
CallDirection varchar (20) True Unknown

17.1.0.324 Added for the new Crystal Call Detail report.
LocalUserId nvarchar (50) True Unknown

17.1.0.324 Added for the new Crystal Call Detail report.
LocalNumber varchar (200) True Unknown

17.1.0.324 Added for the new Crystal Call Detail report.
RemoteNumberFmt varchar (50) True Unknown

17.1.0.324 Added for the new Crystal Call Detail report.
RemoteName nvarchar (50) True Unknown

17.1.0.324 Added for the new Crystal Call Detail report.
InitiatedDateTimeGMT datetime True Unknown

17.1.0.324 Added for the new Crystal Call Detail report.
ConnectedDateTimeGMT datetime True Unknown

17.1.0.324 Added for the new Crystal Call Detail report.
CallDurationSeconds bigint True Unknown

17.1.0.324 Added for the new Crystal Call Detail report.
HoldDurationSeconds bigint True Unknown

17.1.0.324 Added for the new Crystal Call Detail report.
DNIS nvarchar (50) True Unknown

17.1.0.324 Added for the new Crystal Call Detail report.
InteractionType tinyint False Unknown

17.1.0.324 Added for the new Crystal Call Detail report.
AccountCode nvarchar (50) True Unknown

17.1.0.324 Added for the new Crystal Call Detail report.
SiteID smallint False Unknown

17.1.0.324 Added for the new Crystal Call Detail report.