Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
ObjectID | int | NULL | ObjectId. The same as related Object ID in HMoveLog table. |
InstanceHFCID | smallint | NULL | Instance HFCID the same as in HMoveLog table. |
Type | Tinyint | NULL | Relationship type of change. For this table it will always be as 3 - Simple Property change. |
DataType | Tinyint | NULL | Data type of column that was changed. For this table it will always be as 2- varchar. |
PropertyName | varchar(100) | NULL | Column name that has the changed value. |
InvalidationTime | datetime | NULL | Date and Time when value was changed. |
UserID | int | NULL | User Id that updated "Comments" field after move visit is complete. |
CharValue | varchar(3000) | NULL | Previous Value for changed "Comments" field. |
RelObjectID | int | NULL | Not used. |
TextValue | ntext | NULL | Not used. |
RelHFCID | smallint | NULL | Not used. |
OIDValue | int | NULL | Not used. |
|