Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
DdcDoc Contains a row for each document. Also contains document data that is unchanged for the life of the document
Column Name Column Datatype Column Null Option Column Comment
DdcDoc_OIDBIGINTNOT NULL Primary Key
Patient_OIDINTNOT NULL Object Id reference to HPatient
PatientVisit_OIDINTNULL Object Id reference to HPatientVisit
DdcDocTemplateDef_OIDBIGINTNOT NULL Template definition OID
Context_OIDBIGINTNOT NULL Id of context object associated with this document
ContextTypeVARCHAR(8)NOT NULL Type of the context object
SecondaryContext_OIDBIGINTNULL Id of context object associated with this document
SecondaryContextTypeVARCHAR(8)NULL Type of the context object
DocumentAuthorStaff_OIDINTNULL Object Id reference to HStaff
DocumentAuthorStaffNameVARCHAR(187)NULL Name of the author
DocumentTypeConceptIdVARCHAR(32)NOT NULL Reference to DdcDocumentTypes table
DocumentNameVARCHAR(280)NOT NULL Name of the document template
IsMadeFinalOnCompleteBITNULL Marks the document whether it should transition to Final on Complete. Values are: 1 - Yes, 0 - No
ParentDocument_OIDBIGINTNULL If an addendum, the OID of the parent document
CreateDTimeDATETIMENOT NULL Created Date Time(wall clock)
LastCngDTimeDATETIMENOT NULL Current Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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