Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
DdcDocVersion Contains a row for each version of the document.
Column Name Column Datatype Column Null Option Column Comment
DdcDocVersion_OIDBIGINTNOT NULL Primary Key
VersionIdSMALLINTNOT NULL Id of document version
IsCurrentBITNOT NULL True(1) if this is the latest version of the document
DdcDoc_OIDBIGINTNOT NULL Object ID of the document in reference to DdcDoc
ChangedByStaff_OIDINTNOT NULL Staff OID for the user who changed the document.
ChangedByStaffNameVARCHAR(187)NULL Name of user who made changes
DocumentStatusCdSMALLINTNOT NULL Status code of the document
DocumentStatusVARCHAR(25)NOT NULL Status of the document. Allowable Values include: "UNCHARTED", "DRAFT", "INPROGRESS", "COMPLETE", "UNABLE_TO_COMPLETE", "ERRONEOUS", "DELETED", "FINAL"
IsRequiredMissingBITNOT NULL Required element value is missing. Allowable Values: 0 - No, 1 - Yes.
ReasonForCngVARCHAR(255)NULL Reason for which the change was made
NeedsCosignCountSMALLINTNOT NULL Number of cosigns needed for this version(0 = no cosign needed)
CollectedDTimeDATETIMENOT NULL Collected Date Time(wall clock)
LastModifiedDTimeDATETIMENOT NULL Last modified Date Time(wall clock)
SignedDTimeDATETIMENULL Signed Date Time(wall clock) set if document is currently signed, NULL Otherwise
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