Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HWorkingDiagnosis This table contains the details of the diagnosis associated with the order
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.
InstanceHFCIDsmallintNOT NULL Healthcare Foundation Class(HFC) Identifier of the object.HFCID of this object is 1507. 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 Whether the table data is Versioned or not.
Allowable Values:
0 - No version data captured.
1 - Version changes available in _Ver table.
Once this field is set to 1, you cannot reset it to 0. If value is 1 , the current row represents the latest state , and all version data will be present in another table with the name HWorkingDiagnosis_Ver.
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.
Codevarchar(30)NULL ICD(International Classification of Diseases) code from HICDMaster table. This field can null for a free text diagnosis entered for the order.
CodeDescriptionvarchar(255)NULL Freetext description of diagnosis or Long Description from HICDMaster table.
Order_oidintNULL Internal Order Identifier. ObjectID of Order(HOrder table). Diagnosis associated during order entry is linked to an order , which is then copied over to the occurrence , when the occurrence gets generated on the order.
Occurrence_oidbigintNULL Internal Order Occurrence Identifier. ObjectID of Occurrence(HOccurrenceOrder table). Valued only for Non-Medication order. Diagnosis associated with Occurrence is communicated for the billing events. Note: Not all environments / databases will have the datatype of BIGINT. Some will remain with the INT datatype.
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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