QUOTA_PersonalDistribution table
This table records the distributed quota counts for field interviewers. Data is generated when quota data is synchronized from the server to the client.
Definition
CREATE TABLE QUOTA_PersonalDistribution (
Interviewer_ID int(4) NOT NULL
Quota_ID int(4) NOT NULL
DistributedCount int(4) 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.
DistributedCount
The quota count value that is assigned to the interviewer.
See also