Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HObservation_Active Information about the value (example:Temperature)and type (example:UOM(Unit of Measure),Range) of findings charted for the assessment.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDBigintNOT NULL The primary key for the associated 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 was modified.
CreatedUserIdintNULL ID of the user who created the object.
CreationTimesmalldatetimeNULL Date and time when the object was created.
Patient_oidintNOT NULLObject ID of the patient for whom the observation was done.
ObservationStatuschar(2)NOT NULL Status of the observation.
FindingAbbrvarchar(16)NOT NULL Abbreviation of the non-diagnostic finding.
AssessmentIDintNOT NULL Assessment ID associated with the observation.
StartDTsmalldatetimeNOT NULL Start date and time when the observation was valid.
EndDTsmalldatetimeNULL Last date and time when the observation is valid.
InternalValuevarchar(500)NULL Internal value of the encoded observation.
Valuevarchar(2000)NULL Value of the observation and the encoded display name.
UOMCodevarchar(16)NULL Code associated with the unit of measure used for the observation.
UOMvarchar(16)NULL Description of the unit of measure used for the observation.
AbnCrtIndicatorCodeintNULL Code associated with the abnormal indicator to describe an abnormal or a critical observation. Allowable Values 1, 2, 3, 4, 7, 8, 9, or NULL. Key of allowable values: 1 - Abnormally Low, 2 - Abnormally High, 3 - Critically Low, 4 - Critically High, 7 - Normal, 8 - Abnormal, 9 - Critical.
AbnCrtIndicatorvarchar(20)NULL Text to describe an abnormal or a critical observation. Allowable Values: LL, L, N, H, HH, AA, CC, or NULL. Key of allowable values: LL - Critically Low, L - Abnormally Low, N - Normal, H - Abnormally High, HH - Critically High, AA - Abnormal, CC - Critical.
RangeIndicatorintNULL Range associated with the observation.
FindingDataTypetinyintNOT NULL Data type code of the finding in the Findings Catalog. Allowable Values: 0, 1, 2, 3, 6, 7, 8, 9, 10, 11 or NULL. Key of allowable values: 0 - Numeric, 1 - Alphanumeric, 2 - Encoded result, 3 - Formatted Text, 6 - Form, 7 - HTML, 8 - URL, 9 - DateTime, 10 - Ambiguous Numeric, 11 - TextBlock.
NormalLowerValuevarchar(300)NULL Lower boundary of a normal reference range for the finding defined for a given age range and sex.
NormalUpperValuevarchar(20)NULL Upper boundary of a normal reference range for the finding defined for a given age range and sex.
CriticalLowerValuevarchar(300)NULL Lower boundary of a critical reference range for the finding defined for a given age range and sex.
CriticalUpperValuevarchar(20)NULL Upper boundary of a critical reference range for the finding defined for a given age range and sex.
ProcessingTypeCodetinyintNULL Processing type code of the finding in the Findings Catalog. Allowable Values: 0, 1, 2, 3, 4, 5, 6, 7, or NULL. Key of allowable values: 0 - Intake, 1 - Output, 2 - BP, 3 - Height, 4 - Weight, 5 - Temperature, 6 - Diagnostic, 7 - None.
Assessment_oidintNOT NULL ID of the HAssessment.
FindingTypetinyintNULL Type of the non-diagnostic finding. Allowable Values: 1, 2, or NULL. Key of allowable values: 1 - Assessment Level Element(e.g. Patient Info or Headers), 2 - User defined Level Element.
Finding_oidintNOT NULL ID of the non-diagnostic finding.
FindingNamevarchar(64)NULL Name of the non-diagnostic finding.
BaseUnitValuefloat(53)NULL Equivalent value of the observation in the base unit of measure.
DisplayFormattinyintNULL Display format that allows the service layer to reconstruct the original charted format of the data. Allowable Values: 0, 1, 2, 3, or NULL. Key of allowable values: 0 - No Format, 1 - Major Unit Only, 2 - Minor Unit Only, 3 - Major and Minor Unit.
UnitOfReferenceRangevarchar(16)NULL Reference range units defined for findings. For example, the reference range units for height could be 'in', 'ft', 'cm', 'm'; the units for weight could be 'oz', 'lb', 'g', 'kg' and the units for temperature could be 'C', 'F'.
VersionsmallintNULL Version of the observation. The version is incremented by one every time the observation is modified. When a new assessment is charted, the initial version of the observation is one if the observation is valued and zero if the observation is not valued.
MinValuevarchar(20)NULL Minimum value defined for the observation in the adaptability tool. This is applicable only for numeric finding types.
MaxValuevarchar(20)NULL Maximum value defined for the observation in the adaptability tool. This is applicable only for numeric finding types.
AllowApproxValuetinyintNULL If the user can enter approximate value indicators(such as "~", "+") for the observation. Consider that a nurse may enter the amount of water a patient drank. The patient does not know the exact amount and he gives the information that he drank half a glass of water. If the value in this field is set to 1, the nurse can enter this amount as '~50cc' instead of 'approx 50cc'. Allowable Values: 0, 1, or NULL. Key of allowable values: 0 - User cannot enter approximate value indicators, 1 - User can enter approximate value indicators.
IncludeInTotalstinyintNULL If the observation value can be included in total calculations. I&O(Intake and Output) values entered for a patient during his course of stay are totalled into charting, shift, and daily totals for the nurse's or physician's quick reference. From these totals, the balances are examined to determine whether or not the patient is dehydrated. These balances help assist in determining outcomes of treatments and medicines. If this field is set to 1, the value of the source is included in the calculation of the totals. Allowable Values: 0, 1, or NULL. Key of allowable values: 0 - Observation value cannot be included in total calculations, 1 - Observation value can be included in total calculations.
IsAddedRemovedtinyintNULL If the observation is added to the assessment, removed from the assessment, or is a part of the original assessment. Allowable Values 0, 1, 2, or NULL. Key of allowable values: 0 - Observation is a part of the original assessment, 1 - Observation is added to the original assessment, 2 - Observation is removed from the original assessment.
IrrigationIndicatortinyintNULL Whether the observation is used for irrigation purposes. If the observation is used for irrigation purpose, a special processing type finding determines if the observation is irrigation intake(I) or irrigation output(O). Large amounts of fluid are infused directly into the bladder. This fluid drains out with the urine. In order to calculate the amount of actual or True urine, the irrigation infused must be subtracted from the total amount drained out of the bladder. The actual amount of irrigation is not included in the overall Intake total and the amount over and above the True urine is not included in the overall output total. It is important to note that any I&O(Intake and Output) charting with bladder in and out contains a true urine source as well. Allowable Values: 0, 1, or NULL. Key of allowable values: 0 - Observation is not used for irrigation, 1 - Observation is used for irrigation.
SourceDetailvarchar(60)NULL Name qualifiers and comments for I&O(Intake and Output) observations. Users may enter comments about each source as they are charting. For example, there may be five sources to chart IV. The sources can be IV_1, IV_2, IV_3, IV_4 and IV_5. The user can put a name qualifier on IV_1 to call it "Saline drip" as opposed to IV_1, which has greater clinical meaning than IV_1.
UOMTypevarchar(16)NOT NULL Unit of measure type for the observation.
ObservationIDBigintNOT NULL Unique ID assigned to the observation. This ID remains the same even when an observation is modified.
ReplicateSourceDetailtinyintNULL If the source detail must be replicated to new copies of observation. Allowable Values: 0, 1, or NULL. Key of allowable values: 0 - Source details do not require replication to new copies of observation, 1 - Source details require replication to new copies of observation.
ComponentIDintNULL The element used to render observation. The elements are defined in the Adaptability Tool module in the application and are used to chart the source. Note: The Component ID is valid for I&O(Intake and Output) observation.
ComponentDateTimesmalldatetimeNULL Date and time of the component. The date and time indicates the version of the element to extract from the Adaptability Tool module in the application and display to the user.
SeqNosmallintNULL If sequence numbers apply to the observation. '-1' indicates that no sequence numbers apply to the observation.
IsChartedtinyintNULL When you chart observations with multi-select checklists, drop-down lists, or combo-boxes, the sequence number stores the index of the selected item in the list that the observation is charted. Allowable Values: 0, 1, or NULL. Key of allowable values: 0 - Not charted, 1 - Charted.
LastcngDtimedatetimeNULL The date and time of the last change..

Return to Table-Index

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