Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NULL | Unique Identifier that is used for referencing records in this table. |
InstanceHFCID | smallint | NULL | HFC(Healthcare Foundation Class) ID of the object. |
Type | Tinyint | NULL | Type of property that is modified. For example - 3, 105. |
DataType | Tinyint | NULL | 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 | Name of the property that was modified. |
InvalidationTime | datetime | NULL | Date and time when the object was modified. |
UserID | int | NULL | Logon ID of the user who modified the object. |
CharValue | varchar(3000) | NULL | Values of the object prior to modification.For example, if the residential address is modified, this field will store the address prior to modification. |
RelObjectID | int | NULL | ID of a new relationship, if set. |
TextValue | ntext | NULL | Value as entered by the user. If the value in the Type field is set to 105, this field is used. |
RelHFCID | smallint | NULL | 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 | ID assigned to the values as stored in the CharValue field. For example, if the residential address was changed, this field will store the object ID of HAddress, which contains details of the residential address. This field is populated if Type is not equal to 3. This field is used to index the values. |
|