Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HPtProblemReconcile Records of when a Problem for a Patient has been Reconciled - Patient, Visit, User, Date and Time. US Only.
Column Name Column Datatype Column Null Option Column Comment
PtProblemReconcileOIdintNOT NULL Object ID of the patients problem reconcile, PrimaryKey
PtProblemRawDataOidintNOT NUll Object ID of the raw XML for support to find the source data
PatientVisitOIDintNOT NULL Object ID of the Patient Visit(HPatientVisit) associated with the patient whose Problem(s) were reconciled
PatientOIDintNOT NULL Object ID of the Patient(HPatient) associated with the patient whose Problem(s) were reconciled
ReconcileSeqNointNOT NULL Reconciliation Sequence number(Unique for an environment). Used for determining the most recent reconciliation for a Patient / Visit combination.
ReconcileDateTimedatetimeNOT NULL Date and Time(local) of when the problem reconciliation occurred
CreatedUserIdintNULL Object ID of the user(HSUser) who reconciled the problems. Always valued. Nullable for Porting / No Downtime requirements when column was added
CreatedUserNamevarchar(188)NOT NULL Name of the user(HSUser) who reconciled the problem
LastCngDtimedatetimeNOT NULL Date and time(UTC) the Problem was reconciled

Return to Table-Index

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