Developer Documentation Library > Interviewer - Server > Administration and maintenance > Databases > Quota database > QUOTA_PersonalAssigned table
 
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
Quota database