Interviewer - Server > Administration and maintenance > Databases > Interviewer Sync Records (InterviewerSyncInfo) table
 
Interviewer Sync Records (InterviewerSyncInfo) table
Note This table is obsolete and 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, 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
Databases