Historical Data Properties
The following table describes the properties on the Data Shape for historical data (PTC.SCA.SCO.HistoricalData):
Model Property
Description
Model Type
UID
The internal unique identifier of the entry in the historical data table. Autogenerated.
LONG
ReferenceKey
The internal unique identifier (UID) of the object in the database table for that object.
STRING
TableName
The name of the object's database table.
STRING
ColumnName
The name of the column that was changed in the object’s database table.
STRING
Value
The new value of the column.
STRING
DataType
The base type of the value in the object’s database table.
STRING
DataShapeName
The name of the Data Shape corresponding to the object's database table.
STRING
FieldName
The name of the field being changed, as it appears in the Data Shape.
STRING
ActionType
* A numerical value representing the action being recorded (1 = Create, 2 = Update, 3 = Delete).
INTEGER
TimeStamp
The time at which the action was executed.
DATETIME
UserName
The name of the user who executed the action.
STRING
Was this helpful?