InterviewerSyncDownloadProject table
The InterviewerSyncDownloadProject table records when the remote device downloads the project for the first time, or downloads project changes.
Fields
Id
Data type: int
The unique identifier, assigned by the SQL Server, for this table (used for the project changes download).
SessionId
Data type: int
Foreign key to the IntervewerSyncSessions table's Id field.
InterviewerId
Data type: nvarchar(200)
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.
Project
Data type: nvarchar(200)
The project for which changes are being downloaded.
RequestTime
Data type: datetime
The time that the server received the Get request for the project changes (in UTC).
Version
Data type: nvarchar(200)
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).
DownloadStartTime
Data type: datetime
The time of the OpenDownloadPackage call (in UTC).
DownloadEndTime
Data type: datetime
The time of the CloseDownloadPackage call (in UTC).
InitialDownload
Data type: bit
Bit is set upon the project's first download.
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