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