Developer Documentation Library > Interviewer - Server > Administration and maintenance > Databases > Quota database > QUOTA_PendHistory table
 
QUOTA_PendHistory table
This table holds historical information that is used for tracking the Pend history when it is necessary to roll back an interview's quotas. A record is added to this table every time a quota is pended. When the interview ends, completed records are moved to QUOTA_CompleteHistory and others are removed.
Definition
CREATE TABLE QUOTA_PendHistory (
  Instance_ID    int(4)         NOT NULL
  Quota_ID       int(4)         NOT NULL
  InstanceCount  int(4)         NOT NULL
  Tstmp          datetime(8)    NOT NULL DEFAULT (getdate())
  Project_ID     nvarchar(255)  NOT NULL
)
Columns
Instance_ID
The interview’s program ID.
Quota_ID
The foreign key to the QUOTA_Quota table.
InstanceCount
The count that the program has for the current quota.
Tstmp
A timestamp.
Project_ID
The project name.
See also
Quota database