Interviewer - Server > Administration and maintenance > Databases > Quota database > QUOTA_Serial table
 
QUOTA_Serial table
This table is used to link the case data record and quota data.
Definition
CREATE TABLE QUOTA_Serial (
  Serial             int(4)          NOT NULL
  Created            datetime(8)     NOT NULL
  Project_ID         nvarchar (255)  NULL
  Respondent_Serial  int NULL
  Interviewer_ID     nvarchar(500)   NULL
  Status             int             NULL
)
Columns
Serial
The interview's program ID (this is named Instance_ID in all the other tables).
Created
A timestamp.
Project_ID
The project name.
Respondent_Serial
The related interview Respondent.Serial value.
Interviewer_ID
The related interviewer ID value.
Status
The quota status (usually decided by the interview status).
See also
Quota database