Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HDiagnosis Contains detailed patient diagnosis information.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL Object ID of the object(such as patient, order, etc.). This field is always a primary key for the associated table.
InstanceHFCIDsmallintNOT NULL HFC(Healthcare Foundation Class) ID of the object. Note: The value specified in the ObjectID field and in this field enables unique indentification of an object across the application.
RecordIdintNULL Record ID of the patient.
Descriptionvarchar(255)NULL Not Used
IsVersionedbitNOT NULL Indicates if the row has been modified. Allowable Values: 0 - Not Modified 1 - Modified
IsDeletedtinyintNOT NULL Indicates if the row has been deleted. Allowable Values: 0 - False, 1 - True(deleted)
CreatedUserIdintNULL Object ID of the user who created the object. This field is linked to HSUser table to get details about the user. For more information on HSUser table.
CreationTimesmalldatetimeNULL Date and time when the object is created.
Codevarchar(30)NULL Unique code of the diagnosis of the patient's ailment.
CodeDescriptionvarchar(255)NULL Description of the code associated with the diagnosis of the patient's ailment.
TypetinyintNULL Diagnosis type. Allowable Values: 0, 1, 2, 3, 4, or NULL Key of allowable values: 0 - RegistrationDiagnosis 1 - AdmittingDiagnosis 2 - WorkingDiagnosis 3 - DischargeDiagnosis 4 - BillingDiagnosis
IsPrimarybitNULL When set to True, indicates that the diagnosis of the patient's ailment is the primary diagnosis Allowable Values: 0, 1, or NULL Key of allowable values: 0 - False 1 - True
PriorityintNULL Priority of the diagnosis. The diagnosis of a patient's ailment is assigned a priority. If the priority is high, indicates that the patient requires immediate medical attention. Allowable Values: For Germany: 0, 1, 2, 3, 4, 5, 6, or NULL Key of allowable values: 0 - Stat 1 - ASAP(As Soon As Possible) 2 - Routine 3 - Preop 4 - Callback 5 - TimingCritical 6 - PRN(As needed) For USA: 1, 2, or NULL Key of allowable values: 1 - Primary 2 - Secondary
Releasevarchar(10)NULL Release number of the set of the International Classification of Diseases(ICD) codes to which the diagnosis belongs. Each release of ICD codes is assigned a release number and contains a set of ICD codes. One or more diagnosis can belong to one or more releases. For example, consider that the release numbers assigned to the two sets of ICD codes are ICD-1 and ICD- 2. Consider that the diagnosis of patient P1 is Diagnosis1 and those of patient P2 are Diagnosis2 and Diagnosis3. Diagnosis1 and Diagnosis3 belong to ICD-1and Diagnosis2 belongs to ICD-2.
Versionvarchar(10)NULL Version number of the set of the International Classification of Diseases(ICD) codes to which the diagnosis belongs. Each release of ICD codes is assigned a release number and contains a set of ICD codes. A version number is assigned to the release number when the same set of ICD codes is release with minor modifications. The version number always follows the release number. One or more diagnosis can belong to one or more releases. For example, consider that the release numbers assigned to the two sets of ICD codes are ICD-1.1 and ICD- 2.2. The version numbers in these are '. 1' and '. 2', respectively. Consider that the diagnosis of patient P1 is Diagnosis1 and those of patient P2 are Diagnosis2 and Diagnosis3. Diagnosis1 and Diagnosis3 belong to ICD-1.1 and Diagnosis2 belongs to ICD-2.2.
StartDatedatetimeNULL Date and Time on which the diagnosis of the patient's ailment starts.
EndDatedatetimeNULL Date and Time on which the diagnosis of the patient's ailment ends.
Commentsvarchar(255)NULL Comments entered by the user related to the diagnosis of the patient's ailment.
IsPreliminarybitNULL When set to True, indicates that the diagnosis of the patient's ailment is in preliminary stage. Allowable Values: 0, 1, or NULL Key of allowable values: 0 - False 1 - True
IsExtensionbitNULL When set to True, indicates that the complete diagnosis of the patient's ailment would take longer time than anticipated. This would require the patient to stay in the hospital longer than usual. Allowable Values: 0, 1, or NULL Key of allowable values: 0 - False 1 - True
IsNursebitNULL When set to True, indicates that the nurse would diagnose the patient's ailment. Allowable Values: 0, 1, or NULL Key of allowable values: 0 - False 1 - True
LinkTypevarchar(1)NULL Specify how different diagnoses are linked together. For example, the different diagnoses could be linked together either by * or by |. The application uses the value stored in this field to identify a parent or sub-diagnosis.
AssignedByvarchar(190)NULL Name of the physician who would diagnose the patient's ailment.
ParentDiagnosisOIDintNULL Object ID of the parent diagnosis for linked diagnosis. For the regular diagnosis, this field stores NULL.
ExternalIDvarchar(10)NULL ID of the diagnosis that belongs to a third-party application.
IsHMDbitNULL When set to True, indicates that the diagnosis belongs to Hospital Main Diagnosis. Allowable Values: 0, 1, or NULL Key of allowable values: 0 - False 1 - True
DiagnosisStatusintNULL Status of the diagnosis of the patient's ailment. The value stored in this field communicates to the Connectivity module whether the diagnosis is newly added, modified, or deleted. Allowable Values: 0, 1, 2, or NULL Key of allowable values: 0 - Added 1 - Modified 2 - Deleted
LocalizationintNULL Localization for diagnosis and procedure. For example, if a patient's elbow needs surgery, LeftLocalization could mean that the surgical procedure needs to be performed on the patient's left elbow. Allowable Values: 0, 1,2 ,3, or NULL Key of allowable values: 0 - NoLocalization 1 - LeftLocalization 2 - RightLocalization 3 - BothLocalization
AssociatedUnitOIDintNULL Object ID of the unit associated with the patient who is diagnosed.
ParentExternalIDvarchar(10)NULL External ID of the parent diagnosis for linked diagnosis. For the regular diagnosis, this field stores NULL.
Visit_oidintNULL Value stored as a result of a one-to-many relationship between HDiagnosis and HPatientVisit.
ExternalObjectIDintNULL Object ID provided a Soarian module.
ExternalObjectTypevarchar(64)NULL Type of the external object. This is a data dictionary item.
LastCngDtimedatetimeNULL Current Universal Time Coordinate or Greenwich Mean Time when object was changed..
Certaintyvarchar(20)NULL Indicates that the diagnosis information was received in inbound transactions.
DiagnosisMainTypevarchar(1)NULL Value that says whether the diagnosis unit is hospital specific or department specific.
DiagTypesmallintNULL Differentiates between Liftetime Cancer Diagnosis(Patient Level) and Visit Level Diagnosis. Lifetime Cancer Diagnosis is valued with DiagType "Lifetime". Visit Level Diagnosis is valued "Financial"
Stagevarchar(64)NULL Lifetime Cancer Diagnosis attribute which provides stage and stage type(Pathologic or Clinical).
Statusvarchar(32)NULL Diagnosis status code. Allowable values are ACTIVE/INACTIVE/RESOLVED/ERRONEOUS/NULL. For ERRONEOUS diagnosis we automatically set its IsDeleted=1, and further ensure that ERRONEOUS diagnoses are NOT purged.
PatientOIDintNOT NULL Object ID of the patient. This is same as the value stored in ObjectID in HPatient.
ClinDiagTypeOIDintNULL Lifetime Cancer Diagnosis attribute.
ClinDiagNamevarchar(128)NULL Lifetime Cancer Diagnosis Name(User Can search on this and it displays on UI)
VisitMoveNumbervarchar(75)NULL Move number of visit. A move occurs in a SAP external system, frequently when a patient changes MRU. For non-SAP users, this column should always be NULL.
ShortDescriptionvarchar(70)NULL De-normalized Short description of the ICD code. Introduced after moving from ICD9 to ICD10
SnomedCodevarchar(32)NULL Snomed Code value of the Diagnosis / It could be NULL
SnomedDescvarchar(256)NULL Snomed Description value of the Diagnosis / It could be NULL
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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