Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HExternalIdentifier This table has details of when Non-med Order Occurrence were sent out to external systems (like LAB,RAD systems)
Column Name Column Datatype Column Null Option Column Comment
ObjectIDbigintNOT NULL Object Identifier of this record. This field is a primary key for the associated table. Note: Not all environments / databases will have the datatype of BIGINT. Some will remain with the INT datatype.
InstanceHFCIDsmallintNOT NULL Healthcare Foundation Class(HFC) Identifier of the object.HFCID of this object is 1506. The value specified in the ObjectID field and in this field enables unique identification of an object instance across the application.
RecordIdintNULL Not Valued in this table. Column exists as part of persistence framework implementation.
Descriptionvarchar(1)NULL Not Valued in this table. Column exists as part of persistence framework implementation.
IsVersionedbitNOT NULL When set to True, the object was modified. Once this field is set to True, you cannot reset it to False. Allowable Values: 0 - False, 1 - True. Note: The presence of this field in tables depends on the configuration at the time of table design.
CreatedUserIdintNULL Object ID of the logged in user who created this record.
This field is linked to HSUser table to get details about the user. For more information see description of HSUser table
CreationTimesmalldatetimeNULL Date and time when the record is created.
ProviderUnitAbbrvarchar(10)NULL Abbreviation of external Healthcare unit where the order message is to be sent
FillerOrderIDvarchar(30)NULL The identifier of the order in external system. This field is valued when the external system sends an acknowledgment on receiving an order message from Soarian.
SendOutsidebitNULL Whether the occurrence is sent out to the external system.
Allowable Values:
0 - Not sent out.
1 - Sent out.
SystemAcknowledgebitNULL Whether acknowledgment is received from external system.
Allowable Values:
0 - Not received acknowledgment from external system.
1 - Received acknowledgment from external system.
OccurrenceOrder_oidbigintNOT NULLObjectID of HOccurrenceOrder table which is sent outside. Note: Not all environments / databases will have the datatype of BIGINT. Some will remain with the INT datatype.
DateOfServicesmalldatetimeNULL Planned DateTime of the Occurrence when the service is to be provided to the patient.
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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