Interviewer Sync Records (InterviewerSyncInfo) table
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, and has the following 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 is an automatically generated number.
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
The DateTime for the synchronization process (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