Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HObsExtraInfo Information about LTE (Large Text Editor) Elements and Images will be stored in this table.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL The primary key for the table.
InstanceHFCIDsmallintNOT NULL HFC(Healthcare Foundation Class) ID of the object.
RecordIdintNULL This column is not used.
Descriptionvarchar(1)NULL This column is not used
IsVersionedbitNOT NULL When set to True(1), indicates that the object is modified.
CreatedUserIdintNULL ID of the user who created the object.
CreationTimesmalldatetimeNULL Date and time when the object was created.
Observation_oidbigintNOT NULLID of the HObservation.
ObservationIDbigintNOT NULLThe same information as the Observation_oid column.
EndDTsmalldatetimeNULL Last date and time when the assessment is available for selection or processing.
Typevarchar(6)NOT NULLType of LTE(Large Text Editor) used.
Valuevarchar(2000)NULL This column is not used.
VersionsmallintNOT NULLWhen set to True(1), indicates that the LTE was modified.
ExtAppNamevarchar(64)NULL External application name.
TypeIDvarchar(64)NULL This column is not used.
ObsTextValvarchar(max)NULL Data entered in the LTE element.
ObsImgValvarbinary(max)NULL Data about the image.

Return to Table-Index

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