Program control table used by CA SDM Knowledge Management.
|
Field |
Data Type |
Reference |
Remarks |
|---|---|---|---|
|
ID |
INTEGER |
|
Specifies the primary key. |
|
doc_ID |
INTEGER |
skeletons::id |
Specifies the SREL to the knowledge document object. |
|
ver_count |
INTEGER |
|
Specifies the internal version ID that indicates the number of versions created (1, 2, 3, 4...) |
|
ver_comment |
STRING (2000) |
|
Specifies the comment text. |
|
start_date |
DATE |
|
Specifies the date when this version started. |
|
end_date |
DATE |
|
Specifies the date when this version ended. |
|
started_by |
UUID |
|
Specifies the user that created this version. |
|
published_by |
UUID |
|
Specifies the user that published this version. |
|
status_ID |
INTEGER |
|
Specifies the document version status. |
|
ver_status |
INTEGER |
|
Specifies the previous version's status: 0—Existed 1—Archived 2—Deleted (this only relates to the resolution field) |
|
title |
STRING |
|
Specifies the document version title. |
|
summary |
STRING |
|
Specifies the document summary text. |
|
problem |
STRING |
|
Specifies the problem description. |
|
notes |
STRING |
|
Specifies the document notes. |
|
doc_type_ID |
INTEGER |
|
Specifies the document type. |
|
ext_doc_ID |
INTEGER |
|
Specifies the Tree ID when Decision Tree is used. |
|
last_mod_by |
Byte(16) |
ca_contact::uuid |
Specifies the UUID of the contact who last modified this record. |
|
last_mod_dt |
INTEGER |
|
Indicates the timestamp of when this record was last modified. |
|
Copyright © 2013 CA.
All rights reserved.
|
|