PureConnect Reporting Data Dictionary

Expand All Collapse All

IWP Data

New schema dbo have been created for IWP related tables, sprocs, views and triggers.

IWPAudit Table

This is IWPAudit Table

IWPAudit Column Definitions

Column	Data Type (Size)	Is Nullable	Contains PII	Last Change Version	Last Change Reason	CX Insights Name	CX Insights Type	CX Insights Folder Name
AuditId	uniqueidentifier	False	Unknown	4.0.106.453	4.0 Release	Audit Id	Attribute	Interaction Web Portal
EventType	smallint	False	Unknown	4.0.106.453	4.0 Release	Event Type	Attribute	Interaction Web Portal
ObjectType	smallint	False	Unknown	4.0.106.453	4.0 Release	Object Type	Attribute	Interaction Web Portal
ObjectId	uniqueidentifier	True	Unknown	4.0.106.453	4.0 Release	Object Id	Attribute	Interaction Web Portal
ObjectName	nvarchar (48)	True	Unknown	4.0.106.453	4.0 Release	Object Name	Attribute	Interaction Web Portal
AuditTimeUTC	datetime	False	Unknown	4.0.106.453	4.0 Release	Audit Time UTC	Attribute	Interaction Web Portal
AuditTimeOffset	smallint	False	Unknown	4.0.106.453	4.0 Release	Audit Time Offset	Attribute	Interaction Web Portal
OrganizationId	uniqueidentifier	True	Unknown	4.0.106.453	4.0 Release	Organization Id	Attribute	Interaction Web Portal
OrganizationName	nvarchar (48)	True	Unknown	4.0.106.453	4.0 Release	Organization Name	Attribute	Interaction Web Portal
SiteId	smallint	False	Unknown	4.0.106.453	4.0 Release	Site Id	Attribute	Interaction Web Portal
IndivId	char (22)	False	Unknown	4.0.106.453	4.0 Release	Indiv Id	Attribute	Interaction Web Portal
ICUserId	nvarchar (50)	False	Unknown	4.0.106.453	4.0 Release	IC User Id	Attribute	Interaction Web Portal
ResultCode	smallint	True	Unknown	4.0.106.453	4.0 Release	Result Code	Attribute	Interaction Web Portal
ResultText	nvarchar (256)	True	Unknown	4.0.106.453	4.0 Release	Result Text	Attribute	Interaction Web Portal
Notes	nvarchar (256)	True	Unknown	4.0.106.453	4.0 Release	Notes	Attribute	Interaction Web Portal

Column	Data Type (Size)	Is Nullable	Contains PII	Last Change Version	Last Change Reason
AuditId	raw (16)	False	Unknown	4.0.106.453	4.0 Release
EventType	smallint	False	Unknown	4.0.106.453	4.0 Release
ObjectType	smallint	False	Unknown	4.0.106.453	4.0 Release
ObjectId	raw (16)	True	Unknown	4.0.106.453	4.0 Release
ObjectName	nvarchar2 (48)	True	Unknown	4.0.106.453	4.0 Release
AuditTimeUTC	date	False	Unknown	4.0.106.453	4.0 Release
AuditTimeOffset	smallint	False	Unknown	4.0.106.453	4.0 Release
OrganizationId	raw (16)	True	Unknown	4.0.106.453	4.0 Release
OrganizationName	nvarchar2 (48)	True	Unknown	4.0.106.453	4.0 Release
SiteId	smallint	False	Unknown	4.0.106.453	4.0 Release
IndivId	char (22)	False	Unknown	4.0.106.453	4.0 Release
ICUserId	nvarchar2 (50)	False	Unknown	4.0.106.453	4.0 Release
ResultCode	smallint	True	Unknown	4.0.106.453	4.0 Release
ResultText	nvarchar2 (256)	True	Unknown	4.0.106.453	4.0 Release
Notes	nvarchar2 (256)	True	Unknown	4.0.106.453	4.0 Release

IWPAudit Constraints

Primary Key Name	Type	Column Name (sort order)
PK_IWPAudit	Clustered	AuditId (Ascending)

Primary Key Name	Column Name (sort order)
PK_IWPAudit	AuditId (Ascending)

IWPAuditDetail Table

This is IWPAuditDetail Table

IWPAuditDetail Column Definitions

Column	Data Type (Size)	Is Nullable	Contains PII	Last Change Version	Last Change Reason	CX Insights Name	CX Insights Type	CX Insights Folder Name
AuditDetailId	uniqueidentifier	False	Unknown	4.0.106.453	4.0 Release	Audit Detail Id	Attribute	Interaction Web Portal
AuditId	uniqueidentifier	False	Unknown	4.0.106.453	4.0 Release	Audit Id	Attribute	Interaction Web Portal
ObjectAttribute	nvarchar (48)	False	Unknown	4.0.106.453	4.0 Release	Object Attribute	Attribute	Interaction Web Portal
OldValue	nvarchar (50)	True	Unknown	4.0.106.453	4.0 Release	Old Value	Attribute	Interaction Web Portal
NewValue	nvarchar (50)	True	Unknown	4.0.106.453	4.0 Release	New Value	Attribute	Interaction Web Portal

Column	Data Type (Size)	Is Nullable	Contains PII	Last Change Version	Last Change Reason
AuditDetailId	raw (16)	False	Unknown	4.0.106.453	4.0 Release
AuditId	raw (16)	False	Unknown	4.0.106.453	4.0 Release
ObjectAttribute	nvarchar2 (48)	False	Unknown	4.0.106.453	4.0 Release
OldValue	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
NewValue	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release

IWPAuditDetail Constraints

Primary Key Name	Type	Column Name (sort order)
PK_IWPAuditDetail	Clustered	AuditDetailId (Ascending)

Primary Key Name	Column Name (sort order)
PK_IWPAuditDetail	AuditDetailId (Ascending)

SR_AutomatedReports Table

This is SR_AutomatedReports Table

SR_AutomatedReports Column Definitions

Column	Data Type (Size)	Is Nullable	Contains PII	Last Change Version	Last Change Reason	CX Insights Name	CX Insights Type	CX Insights Folder Name
ScheduledReportId	int	False	Unknown	4.0.106.453	4.0 Release	Scheduled Report Id	Attribute	Interaction Web Portal
SiteName	nvarchar (25)	False	Unknown	4.0.106.453	4.0 Release	Site Name	Attribute	Interaction Web Portal
Name	nvarchar (100)	False	Unknown	4.0.106.453	4.0 Release	Name	Attribute	Interaction Web Portal
ReportName	nvarchar (100)	True	Unknown	4.0.106.453	4.0 Release	Report Name	Attribute	Interaction Web Portal
Description	nvarchar (MAX)	True	Unknown	4.0.106.453	4.0 Release	Description	Attribute	Interaction Web Portal
Active	bit	False	Unknown	4.0.106.453	4.0 Release	Active	Attribute	Interaction Web Portal
Frequency	nvarchar (30)	True	Unknown	4.0.106.453	4.0 Release	Frequency	Attribute	Interaction Web Portal
Period	nvarchar (30)	True	Unknown	4.0.106.453	4.0 Release	Period	Attribute	Interaction Web Portal
ScheduledTime	nvarchar (5)	True	Unknown	4.0.106.453	4.0 Release	Scheduled Time	Attribute	Interaction Web Portal
StartDateTime	datetime	True	Unknown	4.0.106.453	4.0 Release	Start Date Time	Attribute	Interaction Web Portal
EndDateTime	datetime	True	Unknown	4.0.106.453	4.0 Release	End Date Time	Attribute	Interaction Web Portal
LastFrequency	datetime	True	Unknown	4.0.106.453	4.0 Release	Last Frequency	Attribute	Interaction Web Portal
StringParameterNames	nvarchar (255)	True	Unknown	4.0.106.453	4.0 Release	String Parameter Names	Attribute	Interaction Web Portal
StringParameterValues	nvarchar (MAX)	True	Unknown	4.0.106.453	4.0 Release	String Parameter Values	Attribute	Interaction Web Portal
DTParameterNames	nvarchar (255)	True	Unknown	4.0.106.453	4.0 Release	DT Parameter Names	Attribute	Interaction Web Portal
DTParameterValues	nvarchar (255)	True	Unknown	4.0.106.453	4.0 Release	DT Parameter Values	Attribute	Interaction Web Portal
NumericParameterNames	nvarchar (255)	True	Unknown	4.0.106.453	4.0 Release	Numeric Parameter Names	Attribute	Interaction Web Portal
NumericParameterValues	nvarchar (MAX)	True	Unknown	4.0.106.453	4.0 Release	Numeric Parameter Values	Attribute	Interaction Web Portal
EmailAddresses	nvarchar (1028)	True	Unknown	4.0.106.453	4.0 Release	Email Addresses	Attribute	Interaction Web Portal
FileLocations	nvarchar (1028)	True	Unknown	4.0.106.453	4.0 Release	File Locations	Attribute	Interaction Web Portal
FileOverwriteFrequency	nvarchar (20)	True	Unknown	4.0.106.453	4.0 Release	File Overwrite Frequency	Attribute	Interaction Web Portal
PrinterNames	nvarchar (1028)	True	Unknown	4.0.106.453	4.0 Release	Printer Names	Attribute	Interaction Web Portal
EmailReportFormat	nvarchar (50)	True	Unknown	4.0.106.453	4.0 Release	Email Report Format	Attribute	Interaction Web Portal
FileReportFormat	nvarchar (50)	True	Unknown	4.0.106.453	4.0 Release	File Report Format	Attribute	Interaction Web Portal
LastUpdate	datetime	True	Unknown	4.0.106.453	4.0 Release	Last Update	Attribute	Interaction Web Portal
LastUpdateBy	nvarchar (50)	True	Unknown	4.0.106.453	4.0 Release	Last Update by	Attribute	Interaction Web Portal
Modified	bit	True	Unknown	4.0.106.453	4.0 Release	Modified	Attribute	Interaction Web Portal
AccessLvl	nvarchar (25)	True	Unknown	4.0.106.453	4.0 Release	Access level to automated reports	Attribute	Interaction Web Portal
ReportXML	nvarchar (MAX)	True	Unknown	4.0.106.453	4.0 Release	Report XML	Attribute	Interaction Web Portal
ReportType	nvarchar (50)	True	Unknown	4.0.106.453	4.0 Release	Report Type	Attribute	Interaction Web Portal
Username	nvarchar (50)	True	Unknown	4.0.106.453	4.0 Release	User Name	Attribute	Interaction Web Portal
Password	nvarchar (50)	True	Unknown	4.0.106.453	4.0 Release	Password	Attribute	Interaction Web Portal
Server	nvarchar (50)	True	Unknown	4.0.106.453	4.0 Release	Server	Attribute	Interaction Web Portal

Column	Data Type (Size)	Is Nullable	Contains PII	Last Change Version	Last Change Reason
ScheduledReportId	number	False	Unknown	4.0.106.453	4.0 Release
SiteName	nvarchar2 (25)	False	Unknown	4.0.106.453	4.0 Release
Name	nvarchar2 (100)	False	Unknown	4.0.106.453	4.0 Release
ReportName	nvarchar2 (100)	True	Unknown	4.0.106.453	4.0 Release
Description	nclob	True	Unknown	4.0.106.453	4.0 Release
Active	integer	False	Unknown	4.0.106.453	4.0 Release
Frequency	nvarchar2 (30)	True	Unknown	4.0.106.453	4.0 Release
Period	nvarchar2 (30)	True	Unknown	4.0.106.453	4.0 Release
ScheduledTime	nvarchar2 (5)	True	Unknown	4.0.106.453	4.0 Release
StartDateTime	date	True	Unknown	4.0.106.453	4.0 Release
EndDateTime	date	True	Unknown	4.0.106.453	4.0 Release
LastFrequency	date	True	Unknown	4.0.106.453	4.0 Release
StringParameterNames	nvarchar2 (255)	True	Unknown	4.0.106.453	4.0 Release
StringParameterValues	nclob	True	Unknown	4.0.106.453	4.0 Release
DTParameterNames	nvarchar2 (255)	True	Unknown	4.0.106.453	4.0 Release
DTParameterValues	nvarchar2 (255)	True	Unknown	4.0.106.453	4.0 Release
NumericParameterNames	nvarchar2 (255)	True	Unknown	4.0.106.453	4.0 Release
NumericParameterValues	nclob	True	Unknown	4.0.106.453	4.0 Release
EmailAddresses	nvarchar2 (1028)	True	Unknown	4.0.106.453	4.0 Release
FileLocations	nvarchar2 (1028)	True	Unknown	4.0.106.453	4.0 Release
FileOverwriteFrequency	nvarchar2 (20)	True	Unknown	4.0.106.453	4.0 Release
PrinterNames	nvarchar2 (1028)	True	Unknown	4.0.106.453	4.0 Release
EmailReportFormat	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
FileReportFormat	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
LastUpdate	date	True	Unknown	4.0.106.453	4.0 Release
LastUpdateBy	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
Modified	integer	True	Unknown	4.0.106.453	4.0 Release
AccessLvl	nvarchar2 (25)	True	Unknown	4.0.106.453	4.0 Release
ReportXML	nclob	True	Unknown	4.0.106.453	4.0 Release
ReportType	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
Username	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
Password	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
Server	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release

SR_AutomatedReports Constraints

SR_Groups Table

This is SR_Groups Table

SR_Groups Column Definitions

Column	Data Type (Size)	Is Nullable	Contains PII	Last Change Version	Last Change Reason	CX Insights Name	CX Insights Type	CX Insights Folder Name
SiteName	nvarchar (25)	False	Unknown	4.0.106.453	4.0 Release	Site Name	Attribute	Interaction Web Portal
Name	nvarchar (25)	False	Unknown	4.0.106.453	4.0 Release	Name	Attribute	Interaction Web Portal
UserId	nvarchar (25)	True	Unknown	4.0.106.453	4.0 Release	User Id	Attribute	Interaction Web Portal

Column	Data Type (Size)	Is Nullable	Contains PII	Last Change Version	Last Change Reason
SiteName	nvarchar2 (25)	False	Unknown	4.0.106.453	4.0 Release
Name	nvarchar2 (25)	False	Unknown	4.0.106.453	4.0 Release
UserId	nvarchar2 (25)	True	Unknown	4.0.106.453	4.0 Release

SR_Groups Constraints

SR_ReportParameters Table

This is SR_ReportParameters Table

SR_ReportParameters Column Definitions

Column	Data Type (Size)	Is Nullable	Contains PII	Last Change Version	Last Change Reason	CX Insights Name	CX Insights Type	CX Insights Folder Name
ReportName	nvarchar (100)	False	Unknown	4.0.106.453	4.0 Release	Report Name	Attribute	Interaction Web Portal
SiteName	nvarchar (25)	False	Unknown	4.0.106.453	4.0 Release	Site Name	Attribute	Interaction Web Portal
ParameterName	nvarchar (50)	True	Unknown	4.0.106.453	4.0 Release	Parameter Name	Attribute	Interaction Web Portal
ParameterValueType	nvarchar (50)	True	Unknown	4.0.106.453	4.0 Release	Parameter Value Type	Attribute	Interaction Web Portal
Description	nvarchar (MAX)	True	Unknown	4.0.106.453	4.0 Release	Description	Attribute	Interaction Web Portal
DefaultValue	nvarchar (MAX)	True	Unknown	4.0.106.453	4.0 Release	Default Value	Attribute	Interaction Web Portal
AllowInput	nvarchar (50)	True	Unknown	4.0.106.453	4.0 Release	Allow Input	Attribute	Interaction Web Portal

Column	Data Type (Size)	Is Nullable	Contains PII	Last Change Version	Last Change Reason
ReportName	nvarchar2 (100)	False	Unknown	4.0.106.453	4.0 Release
SiteName	nvarchar2 (25)	False	Unknown	4.0.106.453	4.0 Release
ParameterName	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
ParameterValueType	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release
Description	nclob	True	Unknown	4.0.106.453	4.0 Release
DefaultValue	nclob	True	Unknown	4.0.106.453	4.0 Release
AllowInput	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release

SR_ReportParameters Constraints

SR_Reports Table

This is SR_Reports Table

SR_Reports Column Definitions

Column	Data Type (Size)	Is Nullable	Contains PII	Last Change Version	Last Change Reason	CX Insights Name	CX Insights Type	CX Insights Folder Name
ReportName	nvarchar (100)	False	Unknown	4.0.106.453	4.0 Release	Report Name	Attribute	Interaction Web Portal
SiteName	nvarchar (25)	False	Unknown	4.0.106.453	4.0 Release	Site Name	Attribute	Interaction Web Portal
ReportTitle	nvarchar (100)	True	Unknown	4.0.106.453	4.0 Release	Report Title	Attribute	Interaction Web Portal
Category	nvarchar (100)	True	Unknown	4.0.106.453	4.0 Release	Category	Attribute	Interaction Web Portal
Description	nvarchar (MAX)	True	Unknown	4.0.106.453	4.0 Release	Description	Attribute	Interaction Web Portal

Column	Data Type (Size)	Is Nullable	Contains PII	Last Change Version	Last Change Reason
ReportName	nvarchar2 (100)	False	Unknown	4.0.106.453	4.0 Release
SiteName	nvarchar2 (25)	False	Unknown	4.0.106.453	4.0 Release
ReportTitle	nvarchar2 (100)	True	Unknown	4.0.106.453	4.0 Release
Category	nvarchar2 (100)	True	Unknown	4.0.106.453	4.0 Release
Description	nclob	True	Unknown	4.0.106.453	4.0 Release

SR_Reports Constraints

SR_Results Table

This is SR_Results Table

SR_Results Column Definitions

Column	Data Type (Size)	Is Nullable	Contains PII	Last Change Version	Last Change Reason	CX Insights Name	CX Insights Type	CX Insights Folder Name
ReportName	nvarchar (100)	False	Unknown	4.0.106.453	4.0 Release	Report Name	Attribute	Interaction Web Portal
SiteName	nvarchar (25)	False	Unknown	4.0.106.453	4.0 Release	Site Name	Attribute	Interaction Web Portal
Name	nvarchar (100)	True	Unknown	4.0.106.453	4.0 Release	Name	Attribute	Interaction Web Portal
RunTime	datetime	True	Unknown	4.0.106.453	4.0 Release	Run Time	Attribute	Interaction Web Portal
StartDateTime	datetime	True	Unknown	4.0.106.453	4.0 Release	Start Date Time	Attribute	Interaction Web Portal
EndDateTime	datetime	True	Unknown	4.0.106.453	4.0 Release	End Date Time	Attribute	Interaction Web Portal
EmailAddresses	nvarchar (1028)	True	Unknown	4.0.106.453	4.0 Release	Email Addresses	Attribute	Interaction Web Portal
EmailResult	nvarchar (100)	True	Unknown	4.0.106.453	4.0 Release	Email Result	Attribute	Interaction Web Portal
FileLocations	nvarchar (1028)	True	Unknown	4.0.106.453	4.0 Release	File Locations	Attribute	Interaction Web Portal
FileResult	nvarchar (100)	True	Unknown	4.0.106.453	4.0 Release	File Result	Attribute	Interaction Web Portal
PrinterNames	nvarchar (1028)	True	Unknown	4.0.106.453	4.0 Release	Printer Names	Attribute	Interaction Web Portal
PrinterResult	nvarchar (100)	True	Unknown	4.0.106.453	4.0 Release	Printer Result	Attribute	Interaction Web Portal
TestSchedule	char (1)	False	Unknown	4.0.106.453	4.0 Release	Test Schedule	Attribute	Interaction Web Portal
LastUpdate	datetime	True	Unknown	4.0.106.453	4.0 Release	Last Update	Attribute	Interaction Web Portal
LastUpdatedBy	nvarchar (50)	True	Unknown	4.0.106.453	4.0 Release	Last Update By	Attribute	Interaction Web Portal

Column	Data Type (Size)	Is Nullable	Contains PII	Last Change Version	Last Change Reason
ReportName	nvarchar2 (100)	False	Unknown	4.0.106.453	4.0 Release
SiteName	nvarchar2 (25)	False	Unknown	4.0.106.453	4.0 Release
Name	nvarchar2 (100)	True	Unknown	4.0.106.453	4.0 Release
RunTime	date	True	Unknown	4.0.106.453	4.0 Release
StartDateTime	date	True	Unknown	4.0.106.453	4.0 Release
EndDateTime	date	True	Unknown	4.0.106.453	4.0 Release
EmailAddresses	nvarchar2 (1028)	True	Unknown	4.0.106.453	4.0 Release
EmailResult	nvarchar2 (100)	True	Unknown	4.0.106.453	4.0 Release
FileLocations	nvarchar2 (1028)	True	Unknown	4.0.106.453	4.0 Release
FileResult	nvarchar2 (100)	True	Unknown	4.0.106.453	4.0 Release
PrinterNames	nvarchar2 (1028)	True	Unknown	4.0.106.453	4.0 Release
PrinterResult	nvarchar2 (100)	True	Unknown	4.0.106.453	4.0 Release
TestSchedule	char (1)	False	Unknown	4.0.106.453	4.0 Release
LastUpdate	date	True	Unknown	4.0.106.453	4.0 Release
LastUpdatedBy	nvarchar2 (50)	True	Unknown	4.0.106.453	4.0 Release

SR_Results Constraints

SR_UserAccess Table

This is SR_UserAccess Table

SR_UserAccess Column Definitions

Column	Data Type (Size)	Is Nullable	Contains PII	Last Change Version	Last Change Reason	CX Insights Name	CX Insights Type	CX Insights Folder Name
SiteName	nvarchar (25)	False	Unknown	4.0.106.453	4.0 Release	Site Name	Attribute	Interaction Web Portal
UserId	nvarchar (50)	False	Unknown	4.0.106.453	4.0 Release	User Id	Attribute	Interaction Web Portal
ReportName	nvarchar (100)	True	Unknown	4.0.106.453	4.0 Release	Report Name	Attribute	Interaction Web Portal

Column	Data Type (Size)	Is Nullable	Contains PII	Last Change Version	Last Change Reason
SiteName	nvarchar2 (25)	False	Unknown	4.0.106.453	4.0 Release
UserId	nvarchar2 (50)	False	Unknown	4.0.106.453	4.0 Release
ReportName	nvarchar2 (100)	True	Unknown	4.0.106.453	4.0 Release

SR_UserAccess Constraints

SR_Values Table

This is SR_Values Table

SR_Values Column Definitions

Column	Data Type (Size)	Is Nullable	Contains PII	Last Change Version	Last Change Reason	CX Insights Name	CX Insights Type	CX Insights Folder Name
SiteName	nvarchar (25)	False	Unknown	4.0.106.453	4.0 Release	Site Name	Attribute	Interaction Web Portal
vcType	nvarchar (50)	False	Unknown	4.0.106.453	4.0 Release	vcType	Attribute	Interaction Web Portal
vcName	nvarchar (100)	False	Unknown	4.0.106.453	4.0 Release	vcName	Attribute	Interaction Web Portal
vcValue	nvarchar (100)	True	Unknown	4.0.106.453	4.0 Release	vcValue	Attribute	Interaction Web Portal