InterviewerSyncDownloadProject table
The InterviewerSyncDownloadProject table records when the remote device downloads the project for the first time, or downloads project changes.
Fields
Id
The unique identifier, assigned by the SQL Server, for this table (used for the project changes download).
Data type: int
SessionId
Foreign key to the IntervewerSyncSessions table’s Id field.
Data type: int
InterviewerId
The interviewer ID that will receive the project changes. This includes all users, registered on the device ID, that are assigned to the project. Users are listed on separate rows.
Data type: nvarchar(200)
Project
The project for which changes are being downloaded.
Data type: nvarchar(200)
RequestTime
The time that the server received the Get request for the project changes (in UTC).
Data type: datetime
Version
The project’s version number at the time of download. This is either the version that the server is sending to the client, or the existing client version when no download is required (the client already has the correct version).
Data type: nvarchar(200)
DownloadStartTime
The time of the OpenDownloadPackage call (in UTC).
Data type: datetime
DownloadEndTime
The time of the CloseDownloadPackage call (in UTC).
Data type: datetime
InitialDownload
Bit is set when the project is first download.
Data type: bit
Notes
Currently, whenever a user downloads a project, the changes are applied to all users on the device. An entry has been added to the InterviewerSyncDownloadProject table for each Interviewer ID that is registered on the computer and assigned to the project.
When the client issues a Get() request for project changes, an entry is added to the InterviewerSyncDownloadProject table for each Interviewer ID that is registered on the Device ID and assigned to the project.
The InitialDownload bit is set to 1 when the client indicates in the Get request that it has no files. The Id, SessionId, InterviewerId, Project, RequestTime, Version, and InitialDownload fields are populated when the Get request returns.
The DownloadStartTime field is populated when the OpenDownloadPackage method is called; the DownloadEndTime is populated when the CloseDownloadPackage method is called. If there is a client problem, and it does not start or finish downloading the package, the DownloadStartTime and/or DownloadEndTime fields are left as NULL. This information is recorded so that it is possible to calculate the length of time that a particular device takes to download the project changes.
The InterviewerSyncDownloadProject table is indexed on the following fields:
▪SessionId: This allows entries to be quickly removed when the parent session is removed during database cleanup.
▪Project: Because the Remote Administration activity is per-project, this index enables quick filtering of the table entries.
See also