Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HDiagnosisHistory Contains patient's Diagnosis History Information.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectId of HDiagnosisHistory Rows generated by Architecture
InstanceHFCIDsmallintNOT NULL Instance HFC(Healthcare Foundation Class) ID generated by Architecture
RecordIdintNULL Not Used
Descriptionvarchar(255)NULL Not Used
IsVersionedbitNOT NULL Indicates if the row has been modified. Allowable Values: 0 - Not Modified 1 - Modified
CreatedUserIdintNULL UserId of the user who created the HDiagnosisHistory row
CreationTimesmalldatetimeNULL The date and time when the object is created.
PatientObjectIDintNULL Object ID of the patient whose diagnosis is modified.
VisitObjectIDintNULL Object ID of the patient visit associated with the patient whose diagnosis is modified.
ICDCodeIDintNULL ICD code associated with the diagnosis of the patient's ailment.
DiagnosisNamevarchar(255)NULL The name of the diagnosis that is modified.
FieldChangedvarchar(40)NULL Database fields that are modified in the diagnosis.
OldValuevarchar(255)NULL Value prior to the modification of the diagnosis.
NewValuevarchar(255)NULL New value after modification of the diagnosis.
Changedbyvarchar(24)NULL User ID who modified the diagnosis.
DateChangedsmalldatetimeNULL Date and time when the diagnosis is modified.
Reasonvarchar(255)NULL Reason(s) for modifying the diagnosis.
DiagTypesmallintNULL Indicates if Diagnosis is a Lifetime Cancer Diagnosis(Patient Level) or Visit Level Diagnosis("Financial")
LastCngDtimedatetimeNULL UTC time when name was last changed.

Return to Table-Index

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