QUOTA_PersonalCompleted table
This table records completed quota counts for field interviewers. Data is generated when quota data is synchronized from the client to the server.
Definition
CREATE TABLE QUOTA_PersonalCompleted (
Interviewer_ID int(4) NOT NULL
Quota_ID int(4) NOT NULL
CompletedCount int(4) NOT NULL
TimeLastUpdated datetime(8) NOT NULL
)
Columns
Interviewer_ID
The interviewer user ID. The ID is the GUID key that can be found in the mrUserData.Users table.
Quota_ID
The unique quota ID.
CompletedCount
The quota count value that was completed by the interviewer.
TimeLastUpdated
The last time the quota count was updated.
See also