Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HObsSurveillance This table is used to store observation collected for syndromic surveillance (syndromic Surveillance preference should be setup to populate this table).
Column Name Column Datatype Column Null Option Column Comment
ObservationIDBIGINTNOT NULL This is same as the ObservationID in HObservation, indicates the unique ID assigned to the observation.
FindingAbbrVARCHAR(16)NOT NULL Abbreviation of the non-diagnostic finding
ValueVARCHAR(2000)NULL Value of the observation
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
BaseUnitValueFLOAT(53)NULL The equivalent value of the observations in the base unit of measure.
UOMTypeVARCHAR(16)NOT NULL Unit of measure type for the observation
AssessmentIDINTNOT NULL Assessment ID associated with the observation
AsmtCollectedDTimeMinsSMALLDATETIMENOT NULL Date and time when the information about the assessment is collected.
AsmtStatusCodeTINYINTNOT NULL Status code of the assessment
AsmtEnteredDTimeMinsSMALLDATETIMENOT NULL Date and time when the information about the assessment is entered in the application
Patient_oidINTNOT NULL Object id of HPatient table
PatientVisit_oidINTNOT NULL Object id of HPatientVisit table
InternalValueVARCHAR(500)NULL Finding's InternalValue of the encoded observation ex:(Ex:Smoking status -Former smoker(13) Heavy smoker(17))
FindingDataTypeINTNULL Finding's DataType, such as numeric, encoded, etc.
ProcessingTypeCodeINTNULL Finding's ProcessingTypeCode 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

Return to Table-Index

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