Previous Topic: Delegation_Server TableNext Topic: Document_Repository Table


Doc_Versions Table

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.