Interviewer Sync Records (InterviewerSyncInfo) table
Obsolete table
This table is obsolete. It has been superseded by the tables documented in the
UNICOM Intelligence Interviewer synchronization tables. The
InterviewSyncInfo table and its data has not been removed. Historical data from the table is not migrated and the table data is no longer accessible from the user interface. The Remote Administration activity only reports on data that is recorded in the
UNICOM Intelligence Interviewer synchronization tables.
The Interviewer Sync Records (InterviewerSyncInfo) table is part of the mrUserData database. The table holds information for the purpose of sharing interviewer synchronization records in Remote Administration reports among clustered servers.
Structure
CREATE TABLE [dbo].[InterviewerSyncInfo](
[Id] [int] IDENTITY(1,1) NOT NULL,
[SyncSessionId] [nvarchar](128) NOT NULL,
[InterviewerId] [nvarchar](128) NOT NULL,
[ProjectId] [nvarchar](200) NULL,
[DeviceId] [nvarchar](200) NOT NULL,
[SyncDateTime] [datetime] NOT NULL,
[SyncResult] [tinyint] NOT NULL,
[Message] [nvarchar](256) NULL,
CONSTRAINT [PK_InterviewerSyncInfo] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
Columns
Id
Stores the unique identifier of each record in the table. This number is automatically generated.
SyncSessionId
A GUID unique identifier for each synchronization process.
InterviewerId
The interviewer name who initiated the synchronization process.
ProjectId
Reserved for future use.
DeviceId
A GUID unique identifier for each client computer.
SyncDateTime
When the synchronization process took place (end time).
SyncResult
The synchronization process status. The results are as follows:
STATUS_SUCCESS = 0
STATUS_CACHE_ERROR = 1
STATUS_SITEINFO_ERROR = 2
STATUS_PROJECT_ERROR = 4
STATUS_LOG_ERROR = 8
STATUS_ABORT_ERROR = 16
STATUS_CONFIG_ERROR = 32
STATUS_SAMPLE_QUOTA_ERROR = 64
STATUS_PROJECT_DATA_DOWN_ERROR = 256
STATUS_SHARED_CONTENT_ERROR = 512
Message
Reserved for future use.
See also