QUOTA_PersonalAssigned table
This table records target counts for specific interviewers. Data is generated when importing a quota allocation file. Table values for a field interviewer have a higher priority than the quota percentage allocation. When synchronizing quota allocation targets from the server, the quota value is retrieved directly from the server when an interviewer with a quota target name is found in the table. Otherwise the quota percentage value is used to calculate the interviewer's quota cell target value.
Definition
CREATE TABLE QUOTA_PersonalAssigned (
Interviewer_ID int(4) NOT NULL
Quota_ID int(4) NOT NULL
Target int(4) NOT NULL
)
Columns
Interviewer_ID
The interviewer user ID. The ID is the GUID key that is in the mrUserData.Users table.
Quota_ID
The unique quota ID.
Target
The interviewer quota target value that is allocated to the interviewer.
See also