Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NULL | The ID of the object that was modified. |
InstanceHFCID | smallint | NULL | The HFC ID of the object that was modified. |
Type | Tinyint | NULL | The type of property that was modified. For example - 3, 105 |
DataType | Tinyint | NULL | The data type of the property that was modified. Allowable Values : 2 - Char/Unique Identifier, 8 - Date time, 100 - int , 101 - Float, 102 - Smallint, 103 - Float, 104 - Bit, 105 - Text, 106 - Tinyint |
PropertyName | varchar(100) | NULL | The name of the property that was modified. |
InvalidationTime | datetime | NULL | The date and time when the object was modified. |
UserID | int | NULL | The logon ID of the user who modified the object. |
CharValue | varchar(3000) | NULL | The values of the object prior to modification.For example, if the residential address was modified, this field stores the address prior to modification. |
RelObjectID | int | NULL | The ID of a new relationship, if set. |
TextValue | ntext | NULL | The value as entered by the user. If the value in the Type field is set to 105, this field is used. |
RelHFCID | smallint | NULL | The HFC ID of the new relation. This field is populated if the ID of the new relation is set in the RelObjectID field. |
OIDValue | int | NULL | The ID assigned to the values as stored in the CharValue field. For example, if the residential address was changed, this field stores the object ID of HAddress, which contains details of the residential address. This field is populated if Type does not equal 3. This field is used to index the values. |
|