Developer Documentation Library > Interviewer - Server > Administration and maintenance > Databases > 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
The unique identifier, assigned by the SQL Server, for this table (used for the processed case data file).
Data type: int
UploadId
Foreign key to the Id field in the InterviewerSyncUploadPackage table.
Data type: int
FileName
Name of the cache file.
Data type: nvarchar(200)
InterviewerId
The interviewer who conducted the interview.
Data type: nvarchar(200)
RespondentId
The respondent ID.
Data type: nvarchar(200)
FinishTime
The DataCollection.FinishTime in the cache file. When this field does not exist, the cache file’s ISubscription.DateLastUpdated value is used (in UTC).
Data type: datetime
Status
The DataCollection.Status value in text form (for example, {completed,signal}).
Data type: nvarchar(200)
ClientSerial
The record’s serial number as it exists on the client.
Data type: int
ServerSerial
The serial number that was allocated to the record when merging with the server data.
Data type: int
Result
The result of processing the data.
Data type: int
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