Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NULL | ObjectId. The same as related Object ID in HProcedureHistory table |
InstanceHFCID | smallint | NULL | Instance HFC(Healthcare Foundation Class) ID the same as in HProcedureHistory table |
Type | Tinyint | NULL | Relationship type of change. |
| | | Allowable Values: 3 - Simple Property, 20 - One to One Relationship, 21 - One to Many Forward Relationship, 22 - One to Many Reverse Relationship |
DataType | Tinyint | NULL | Data type of column that was changed. |
| | | Allowable Values: 2- varchar, 8 - datetime, 100 - int, 101 - double, 102 - Smallint, Tinyint, 103 - Float, 104 - Bit |
PropertyName | varchar(100) | NULL | Column name in HProcedureHistory table that has the changed value. |
InvalidationTime | datetime | NULL | Date and Time when value was changed. |
UserID | int | NULL | User Id that changed the patient's Procedure information. |
CharValue | varchar(3000) | NULL | Previous Value for character fields |
RelObjectID | int | NULL | Relation ObjectID. |
| | | a) One-To-One Relations values : NULL - If relation is Removed, Not NULL - If relation is Established |
| | | b) One-To-Many Relations(both in Forward and Reverse) : Child ObjectID will be in. |
TextValue | ntext | NULL | Previous Value for text fields |
RelHFCID | smallint | NULL | Relation HFC(Healthcare Foundation Class) ID(Child HFCID incase of OnetoOne & OnetoMany). |
OIDValue | int | NULL | Previous Value for oid fields |
|