Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | The primary key for the associated table. |
InstanceHFCID | smallint | NOT NULL | HFC(Healthcare Foundation Class) ID of the object. |
RecordId | int | NULL | This column is not used. |
Description | varchar(255) | NULL | This column is not used. |
IsDeleted | tinyint | NOT NULL | When set to true(1) indicates the object was deleted. |
IsVersioned | bit | NOT NULL | When set to True(1), indicates the object was modified. |
CreatedUserId | int | NULL | The ID of the user who created the object. |
CreationTime | smalldatetime | NULL | The date and time when the object was created. |
FormID | int | NULL | The ID of the form used to chart the assessment having an IMA(Inter Module Adaptability) element. |
ValidFrom | smalldatetime | NULL | The date from which the document was valid. |
ValidTo | smalldatetime | NULL | The date to which the document is valid. |
Doc_oid | int | NOT NULL | The ID of the document. |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|