Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | The primary key for the associated table. |
InstanceHFCID | smallint | NOT NULL | The 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 that 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. |
Name | varchar(64) | NULL | The data source name of the IMA element |
Data | text | NULL | Information about the datasource. |
DataFormat | tinyint | NULL | This column is not used anymore. |
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 | NULL | The ID of the document. |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|