Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HPtProblemReconcileDetail Problem Reconciliation Details - Row created for every Problem that was available to be reconciled. US only.
Column Name Column Datatype Column Null Option Column Comment
PtProblemReconcileDetailOidintNOT NULL Object ID of the patients problem reconcile detail instance
CreatedUserIdintNULL Object ID of the User who reconciled the problem information(HSUser table)
PtProblemReconcileOIdintNOT NULL Indicates the object ID of the patient problem reconcile that is related to the reconcile.
ProblemNamevarchar(255)NOT NULL Name of the problem to be reconciled
ProblemStatusCodevarchar(32)NOT NULL Status code of the problem being reconciled(e.g. ACTIVE, INACTIVE, COMPLETE, ERRONEOUS)
ProblemStatusvarchar(254)NOT NULL Status of the problem being reconciled
ProblemOnsetDatevarchar(32)NULL Onset date of the problem. Value could be an actual date or 'fuzzy'(e.g. childhood)
Commentsvarchar(254)NULL User entered information regarding the problem
ReconcileCodeTypevarchar(32)NULL Type sent on the CCD document(eg. SNOMED)
ReconcileCodevarchar(32)NULL Code used to reconcile the problem
PtProblemOidintNULL Indicates the value stored as a result of a one-to-one relationship between HPtProblemReconcileDetail and HPtProblem
DocumentRootIDvarchar(256)NULL Root ID of the CCD document
DocumentIDExtensionvarchar(128)NULL Document ID extension of the CCD document
DocumentIDAssigningAuthorityvarchar(256)NULL Assigning Authority / Organization that created the CCD document.
DocumentCreationTimevarchar(32)NULL Date and time(Local) the document was created.
LastCngDtimedatetimeNOT NULL Date and time(UTC) this information was Inserted

Return to Table-Index

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