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