Historical Data Properties
The following table describes the properties on the Data Shape for historical data (PTC.DBConnection.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
|
 |
Some number type properties relate to another table where their numeric values are mapped to text value strings. These enumeration tables are present in the code, but are not listed here. Numeric properties with a related enumeration table are identified with an asterisk (*) at the start of their description.
|