QUOTA_PendHistory table

Interviewer - Server > Administration and maintenance > Databases > Quota database > 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.