Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HExtendedValue This table stores information related to the Result value when the Result value length is more than 80 characters.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL Oobject ID and primary key of the table, HExtendedValue.
InstanceHFCIDsmallintNOT 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.
RecordIdintNULL Record ID.
Descriptionvarchar(1)NULL User-defined description for the row.
IsDeletedtinyintNOT NULL Result is deleted. Allowable Values: 0 - No, 1 - Yes.
IsVersionedbitNOT NULL Indicates whether the result is modified. Allowable Values: 0 - No, 1 - Yes.
CreatedUserIdintNULL Object ID of the user who created the result. This field is linked to the HSUser table to get details about the user.
CreationTimesmalldatetimeNULL Date and time when the Result is created.
Valuevarchar(max)NOT NULLIf 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.
ExtendedTypevarchar(3)NOT NULLType of the Result that is being stored in this table. Allowable values: VAL - ResultValue, COM - Comments,REQ - RequisitionComments.
ParentObjectIdbigintNOT NULL ObjectId in HIvestigationResult_Active table.
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates