Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
DdcDoc_OID | BIGINT | NOT NULL | Primary Key |
Patient_OID | INT | NOT NULL | Object Id reference to HPatient |
PatientVisit_OID | INT | NULL | Object Id reference to HPatientVisit |
DdcDocTemplateDef_OID | BIGINT | NOT NULL | Template definition OID |
Context_OID | BIGINT | NOT NULL | Id of context object associated with this document |
ContextType | VARCHAR(8) | NOT NULL | Type of the context object |
SecondaryContext_OID | BIGINT | NULL | Id of context object associated with this document |
SecondaryContextType | VARCHAR(8) | NULL | Type of the context object |
DocumentAuthorStaff_OID | INT | NULL | Object Id reference to HStaff |
DocumentAuthorStaffName | VARCHAR(187) | NULL | Name of the author |
DocumentTypeConceptId | VARCHAR(32) | NOT NULL | Reference to DdcDocumentTypes table |
DocumentName | VARCHAR(280) | NOT NULL | Name of the document template |
IsMadeFinalOnComplete | BIT | NULL | Marks the document whether it should transition to Final on Complete. Values are: 1 - Yes, 0 - No |
ParentDocument_OID | BIGINT | NULL | If an addendum, the OID of the parent document |
CreateDTime | DATETIME | NOT NULL | Created Date Time(wall clock) |
LastCngDTime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |