Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HMedDispOrderSuppInfo This table stores dispensable medication order supplementary information
Column Name Column Datatype Column Null Option Column Comment
ObjectIDINTNOT NULL The object ID of the object(such as patient, order, etc.). This field is always a primary key for the associated table.
InstanceHFCIDSMALLINTNOT NULL The HFC(Healthcare Foundation Class) ID of the object(1119). Note: The value specified in the ObjectID field and in this field enables unique indentification of an object across the application
RecordIDINT,The record ID. Not valued in this table. Column exists as part of persistence framework implementation
DescriptionVARCHAR(1),User-defined information provided by the modules in the application. Note: The length of this field varies with tables. Not valued
IsDeletedSMALLINTNOT NULL Indicates whether the record is soft deleted. Allowable Values: 0 - Active, 1 - Marked as Deleted
IsVersionedBITNOT NULL Indicates whether the record was modified through persistent layer after its initial creation. Once this field is set to True, you cannot reset it to False. If this field is set to True in a table, another table with the name HMedDispOrderSuppInfo_Ver is created. Allowable Values: 0 - False, 1 - True
CreatedUserIDINT,The Object ID of the user who created the object. This field is linked to HSUser table to get details about the user.
CreationTimeDATETIME,The date and time when the object was created
ValidFromDATETIMENULL The Date/Time from which the medication prescribed to the patient is valid
ValidToDATETIMENull The Date/Time when the medication prescribed to the patient is no longer valid
PharmacyInstrVARCHAR(256),Instructions given to pharmacy. Example: DO NOT CRUSH OR CHEW / FLUSH BEFORE AND AFTER EACH DOSE ...
ChangeNoSMALLINTNULL The number of times the order has changed. Used to properly sequence the history information
IndicationCodeVARCHAR(18)NULL Medication indication code
IndicationDescriptionVARCHAR(80)NULL Medication indication description
CodeSystemVARCHAR(8)NULL Code system that defines the indication
IndicationRequiredCodeTINYINTNULL Indicates whether this is mandatory. Allowable values: 0/NULL - Not Available, 1 - Optional, 2 - Mandatory
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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