SummaryHistory
- Last UpdatedMar 10, 2025
- 2 minute read
Contains one row for each occurrence of a summary operation. This table is used by the Event subsystem; it is not used by the replication subsystem. Rows are inserted even if the operation did not return data.
|
Column |
Data Type |
Description |
|---|---|---|
|
(PK) LogKey |
int NOT NULL |
The unique numerical identifier of the summary's historical log. This value is automatically generated by the system when the record is added. |
|
(FK) OperationKey |
int NOT NULL |
The unique numerical identifier for the summary operation. OperationKey is a foreign key from the SummaryOperation table. |
|
SummaryDate |
datetime2(7) NOT NULL |
The date applicable to the results of the calculation. It is either the time of the beginning or end of the calculation period, as specified by the summary operation definition. |
|
SumDateTimeStamp |
tinyint NULL |
Duplication of the TimeStamp column of the SummaryOperation table at the SummaryDate. This column allows you to keep the original calculation timestamp setting performed, in case of a later modification of the summary operation definition. |
|
SumDateCalcType |
varchar(3) NULL |
Duplication of the CalcType column of the SummaryOperation table at the SummaryDate. This column allows you to keep the original calculation type performed, in case of a later modification of the summary operation definition. |
|
SumDateDuration |
real NULL |
Duplication of the Duration column of the SummaryOperation table at the SummaryDate. This column allows you to keep the original calculation duration used in case of a later modification of the summary operation definition. |
|
SumDateResolution |
int NULL |
Duplication of the Resolution column of the SummaryOperation table at the SummaryDate. This column allows you to keep the original calculation resolution used, in case of a later modification of the summary operation definition. |
|
Status |
tinyint NOT NULL |
The flag indicating the status of the operation. 0 = Operation completed successfully; Not 0 = Operation is in progress or has failed. Reserved for future use. |
|
OperationStart |
datetime2(7) NULL |
The timestamp when the calculation started for the operation. |
|
OperationEnd |
datetime2(7) NULL |
The timestamp when the calculation completed for the operation. |