Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
XMLDocStorage This table stores all the Medication Reconciliation documents.
Column Name Column Datatype Column Null Option Column Comment
XMLDocStorageOidintNOT NULL Primary key to XMLDocStorage table
LastCngDTimedatetimeNOT NULL Last Updated Date Time( EA/DSS(UTC) - Current Universal Time Coordinate or Greenwich Mean Time)
Patient_OIDintNOT NULL Foreign key to HPatient(References to HPatient table Object ID column)
PatientVisit_OIDintNOT NULL Foreign key to HPatientVisit(References to HPatientVisit table Object ID column)
DocumentTypevarchar(5)NOT NULL Indicates type of document(possible values: AMR - Admission Medication Reconciliation, HML-Home Med List, DMR -Discharge Med Reconciliation)
DocumentAuthorStaff_OIDintNOT NULL Foreign key to HStaff(References to HStaff table Object ID column)
DocumentAuthorvarchar(187)NOT NULL Name of the staff who created or updated the document.
DocumentStatusCdsmallintNOT NULL Indicates status code of the document(example: 1,0)
DocumentStatusvarchar(25)NOT NULL Indicates Status of the document(example: InProgress, Complete)
DocumentXMLVersionNosmallintNOT NULL XML Version number, indicates version of the schema used
Commentsvarchar(255)NULL Comment entered for the list
DocumentXMLxmlNOT NULL The XML document which is a snapshot of the state of the widget at the time the medication list was signed
CollectedDTimedatetimeNOT NULL DateTime the information was collected
DocumentDTimedatetimeNOT NULL DateTime the document was saved
PrintCounterintNOT NULL Indicates how many times the record was printed(not used at this moment)
LastPrintedUserOidintNULL HStaff table Object ID of user that last printed the document(not used at this moment)
LastPrintedDTimedatetimeNULL DateTime the document was last printed(not used at this moment)
SuppressintNULL Column indicating if the document needs to be suppressed during new home med list creation. Allowable values: 0 - not suppressed; 1 - suppressed
HM_XMLDocStorageOidintNULL Column holding the key in the XMLDocStorage table for the Home Med document
Contextvarchar(20)NULL Column holding information under which calling Context the document was created.
EPrescriberSAMLSignaturexmlNULL Column holding the digital signature in case this document contains electronically prescribed controlled substances
EntityOIDintNULL Entity ID of the user who stored the document
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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