Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | The primary key for the table. |
InstanceHFCID | smallint | NOT NULL | HFC(Healthcare Foundation Class) ID of the object. |
RecordId | int | NULL | This column is not used. |
Description | varchar(1) | NULL | This column is not used |
IsVersioned | bit | NOT NULL | When set to True(1), indicates that the object is modified. |
CreatedUserId | int | NULL | ID of the user who created the object. |
CreationTime | smalldatetime | NULL | Date and time when the object was created. |
Observation_oid | bigint | NOT NULL | ID of the HObservation. |
ObservationID | bigint | NOT NULL | The same information as the Observation_oid column. |
EndDT | smalldatetime | NULL | Last date and time when the assessment is available for selection or processing. |
Type | varchar(6) | NOT NULL | Type of LTE(Large Text Editor) used. |
Value | varchar(2000) | NULL | This column is not used. |
Version | smallint | NOT NULL | When set to True(1), indicates that the LTE was modified. |
ExtAppName | varchar(64) | NULL | External application name. |
TypeID | varchar(64) | NULL | This column is not used. |
ObsTextVal | varchar(max) | NULL | Data entered in the LTE element. |
ObsImgVal | varbinary(max) | NULL | Data about the image. |
|
|
|