Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
DdcDocSection Contains a row for each saved section of the document.
Column Name Column Datatype Column Null Option Column Comment
DdcDocSection_OIDBIGINTNOT NULL Section Object ID of the document(Primary Key)
DdcDocTemplateContent_OIDBIGINTNOT NULL FK(Foreign Key) to DdcDocSectionDef table
DdcDocVersion_OIDBIGINTNOT NULL Document Version Object Id reference to DdcDocumentVersion
CreateDTimeDATETIMENOT NULL Created Date Time(wall clock)
LastCngDTimeDATETIMENOT NULL Current Universal Time Coordinate or Greenwich Mean Time
IsNarrativeErrorBITNOT NULL True(1) if the saved section has an error
IsChangedBITNOT NULL True(1) if the section is changed
IsSignedBITNOT NULL True(1) if the section is signed
IsEverChangedBITNOT NULL True(1) if the section is ever changed
IsHiddenBITNULL If the section is hidden by default or is visible. Allowable Values: 0 - Visible, 1 - Hidden.
NarrativeNVARCHAR(MAX)NULL Generated natural language text
IsHTML5BITNULL If html snippet in Narrative column as HTML5 compliant. Values: True(1), False(0), or NULL if html snippet is Non compliant.
IsPublicNarrativePrevValuedBITNULL True(1) if the previous version of this section were saved with non-blank Narrative in a public status
IsPublicNarrativeEverValuedBITNULL True(1) if the section were ever saved with non-blank Narrative in a public status

Return to Table-Index

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