Comments

This table contains the following topics:
casm173
This table contains the following topics:
O_COMMENTS Table
Program control table used by CA SDM Knowledge Management.
  • SQL Name
    -- O_Comments
  • Object
    -- O_Comments
Field
Data Type
Reference
Remarks
ASSIGNEE
UUID
 
SREL to the Contacts table.
CLOSE_DATE
DATE
 
Represents the timestamp of when this flag was closed.
CLOSE_DESC
nvarchar(50)
 
Displays the description when the flag is closed.
COMMENT_TEXT
nvarchar(255)
 
Displays comment text.
COMMENT_ TIMESTAMP
DATE
 
Indicates the timestamp of when this record was last created.
DEADLINE_DATE
DATE
 
Displays the date when the flag should be fixed by the user.
DOC_ID
INTEGER
SKELETONS:: id
Identifies the unique doc ID.
EMAIL_ADDRESS
nvarchar(75)
 
Identifies the email address.
FLG_CODE
nvarchar(50)
 
Prevents duplicate flags from being created for the same broken link.
FLG_STATUS
INTEGER
KT_FLG_ STATUS
Identifies the flag status as active or inactive.
FLG_TYPE
INTEGER
 
SREL to the KT_Flg_Type Table.
ID
INTEGER KEY
 
Unique (to the table) Numeric ID.
last_mod_by
UUID
ca_contact
Specifies the UUID of the contact who last modified this record.
last_mod_dt
DATE
 
Indicates the timestamp of when this record was last modified.
tenant
UUID
ca_tenant
Specifies the UUID of the tenant.
USER_ID
UUID
ca_contact:: uuid
Identifies the unique user ID
USER_NAME
STRING 50
 
Identifies the user name.
VER_COUNT
INTEGER
 
Identifies the unique version ID and displays the number of versions created (1, 2, 3, 4...)
NR_Comment Table
Standard comments table.
  • SQL Name
    -- nr_com
  • Object
    -- nr_com
Field
Data Type
Reference
Remarks
attr_name
nvarchar(60)
 
For ITIL, this contains the Asset attribute that has changed.
com_comment
nvarchar(1000)
 
Identifies the comment text.
com_dt
INTEGER
 
Acts as the pointer to the parent row (nr_did), for the dt_ comment written.
com_par_id
byte(16)
ca_owned_ resource::uuid
Foreign key to the id field of the ca_owned_resource table, this is the Asset.
com_userid
nvarchar(40)
 
Identifies the userid of the commenting author.
id
INTEGER
 
Primary key of this table, this is a unique numeric ID.
new_value
nvarchar(1000)
 
For ITIL, this contains the new value of the Asset's attribute that has changed.
old_value
nvarchar(1000)
 
For ITIL, this contains the old value of the Asset's attribute that has changed.
writer_id
byte(16)
 
Primary key to the table, this is a unique identifier.