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 document is deleted. |
IsVersioned | bit | NOT NULL | When set to True(1), indicates that the object was modified. |
CreatedUserId | int | NULL | Object ID of the user who created the object. |
CreationTime | smalldatetime | NULL | Date and time when the object was created. |
DocumentID | int | NOT NULL | ID of the document used to chart items having an IMA(Inter Module Adaptability) element. |
VersionID | int | NULL | Version of the document. |
Type | varchar(50) | NULL | Type of the document. |
ParentDocumentID | int | NULL | ID of the parent document. |
TopLevelDocumentID | int | NULL | The top level document id. |
ValidFrom | smalldatetime | NULL | Date from which the document was valid. |
ValidTo | smalldatetime | NULL | Date to which the document is valid. |
State | varchar(20) | NULL | This column is not used. |
UserOID | int | NULL | The same as CreatedUserId. |
PatientOID | int | NULL | Object ID of the patient. |
VisitOID | int | NULL | Object ID of the visit. |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|