Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HProcedureHistory Contains patient's Procedure History Information.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectId of HProcedureHistory Rows generated by Architecture
InstanceHFCIDsmallintNOT NULL Instance HFC(Healthcare Foundation Class) ID generated by Architecture
RecordIdintNULL RecordId of the Patient Procedure History
Descriptionvarchar(1)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 HProcedureHistory row
CreationTimesmalldatetimeNULL Date and time when the object is created.
PatientObjectIDintNULL Patient's unique identifier as Objectid in HPatient table.
VisitObjectIDintNULL Patient's visit unique identifier as ObjectID in HPatientVisit Table.
CPTCodeIDintNULL CPT code associated with the patient's procedure.
ProcedureNamevarchar(255)NULL The name of the procedure that is performed on a patient. Client can value it as CPT code description.
FieldChangedvarchar(40)NULL Database fields that are modified in the procedure.
OldValuevarchar(255)NULL Value prior to the modification of the procedure.
NewValuevarchar(255)NULL New value after modification of the procedure.
ChangedByvarchar(184)NULL User name who modified the procedure.
DateChangedsmalldatetimeNULL Date and time when the procedure is modified.
Reasonvarchar(255)NULL Reason(s) for modifying the procedure.
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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