Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
DdcDocVersion_OID | BIGINT | NOT NULL | Primary Key |
VersionId | SMALLINT | NOT NULL | Id of document version |
IsCurrent | BIT | NOT NULL | True(1) if this is the latest version of the document |
DdcDoc_OID | BIGINT | NOT NULL | Object ID of the document in reference to DdcDoc |
ChangedByStaff_OID | INT | NOT NULL | Staff OID for the user who changed the document. |
ChangedByStaffName | VARCHAR(187) | NULL | Name of user who made changes |
DocumentStatusCd | SMALLINT | NOT NULL | Status code of the document |
DocumentStatus | VARCHAR(25) | NOT NULL | Status of the document. Allowable Values include: "UNCHARTED", "DRAFT", "INPROGRESS", "COMPLETE", "UNABLE_TO_COMPLETE", "ERRONEOUS", "DELETED", "FINAL" |
IsRequiredMissing | BIT | NOT NULL | Required element value is missing. Allowable Values: 0 - No, 1 - Yes. |
ReasonForCng | VARCHAR(255) | NULL | Reason for which the change was made |
NeedsCosignCount | SMALLINT | NOT NULL | Number of cosigns needed for this version(0 = no cosign needed) |
CollectedDTime | DATETIME | NOT NULL | Collected Date Time(wall clock) |
LastModifiedDTime | DATETIME | NOT NULL | Last modified Date Time(wall clock) |
SignedDTime | DATETIME | NULL | Signed Date Time(wall clock) set if document is currently signed, NULL Otherwise |
CreateDTime | DATETIME | NOT NULL | Created Date Time(wall clock) |
LastCngDTime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |