Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | Oobject ID and primary key of the table, HExtendedValue. |
InstanceHFCID | smallint | NOT NULL | HFC(Healthcare Foundation Class) ID of the object. Note: The value specified in the ObjectID field and in this field enables unique indentification of an object across the application. |
RecordId | int | NULL | Record ID. |
Description | varchar(1) | NULL | User-defined description for the row. |
IsDeleted | tinyint | NOT NULL | Result is deleted. Allowable Values: 0 - No, 1 - Yes. |
IsVersioned | bit | NOT NULL | Indicates whether the result is modified. Allowable Values: 0 - No, 1 - Yes. |
CreatedUserId | int | NULL | Object ID of the user who created the result. This field is linked to the HSUser table to get details about the user. |
CreationTime | smalldatetime | NULL | Date and time when the Result is created. |
Value | varchar(max) | NOT NULL | If a result value is > 80 characters, this field contains the portion of the result which is > 80 characters. The 1st 80 characters are stored in HInvestigationResult. This field is obtained from the inbound HL7 Results interface in the OBX.05.00.00. |
ExtendedType | varchar(3) | NOT NULL | Type of the Result that is being stored in this table. Allowable values: VAL - ResultValue, COM - Comments,REQ - RequisitionComments. |
ParentObjectId | bigint | NOT NULL | ObjectId in HIvestigationResult_Active table. |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|