Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HChiefComplaintHistory contains Chief Complaint History Information.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectId of HChiefComplaintHistory 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 HChiefComplaintHistory row.
CreationTimesmalldatetimeNULL Date and time when the object is created.
PatientObjectIDintNULL Patient ObjectID as in Hpatient table
VisitObjectIDintNULL Visit ObjectID as in HPatientVisit Table
UnitContactedNamevarchar(75)NULL Unit Contacted Name for the visit. Must exist in HHealthCareUnit Table.
VisitStartDateTimedatetimeNULL Visit start date and time.
VisitEndDateTimedatetimeNULL Visit End Date and time.
VisitTypevarchar(30)NULL Visit Type. Must exist as a code in HPatientClass table.
OldValuevarchar(255)NULL Previous Chief Complaint value for the visit.
NewValuevarchar(255)NULL New Chief Complaint value for the visit.
ChangedByvarchar(184)NULL UserId of the user who changed Chief Complaint value for the visit
ChangedDateTimedatetimeNULL Last system UTC date /time when row was updated.

Return to Table-Index

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