Interviewer - Server > Administration and maintenance > Databases > mrInterviewData database stored procedures > UNICOM Intelligence Interviewer synchronization tables > InterviewerSyncUploadCaseData table
 
InterviewerSyncUploadCaseData table
After the initial processing of the sample and quota data in the uploaded package, the package is moved to an Inbox for further processing by a background worker thread. When the worker thread processes the package files, the information is recorded in an InterviewerSyncUploadCaseData table. Entries are only written to the InterviewerSyncUploadCaseData table for packages where Type = "ProjectData".
Fields
Id
Data type: int
The unique identifier, assigned by the SQL Server, for this table (used for the processed case data file).
UploadId
Data type: int
Foreign key to the Id field in the InterviewerSyncUploadPackage table.
FileName
Data type: nvarchar(200)
Name of the cache file.
InterviewerId
Data type: nvarchar(200)
The interviewer who conducted the interview.
RespondentId
Data type: nvarchar(200)
The respondent ID.
FinishTime
Data type: datetime
The DataCollection.FinishTime in the cache file. When this field does not exist, the cache file's ISubscription.DateLastUpdated value is used (in UTC).
Status
Data type: nvarchar(200)
The DataCollection.Status value in text form (for example, {completed,signal}).
ClientSerial
Data type: int
The record's serial number as it exists on the client.
ServerSerial
Data type: int
The serial number that was allocated to the record when merging with the server data.
Result
Data type: int
The result of processing the data.
Result field codes
Code
Description
0
Success.
1
Code is obsolete.
2
Rejected: Database record is already complete. Cache files that are marked as incomplete do not overwrite completed database records, even if the cache file DataCollection.FinishTime is more recent.
3
Rejected: Cache file is older than the database record (based on the DataCollection.FinishTime).
4
Cache file is unreadabl.e
5
Cache file does not contain a Respondent.Id.
6
Unable to transfer cache data to the database.
7
Ignored: Sample was rejected.
See also
UNICOM Intelligence Interviewer synchronization tables