ID

Long

Primary index.

Identifies the unique (to the table) numeric ID of the primary index.

persid

nvarchar(30)

Required field.

This is the Persistent ID.

Del

INTEGER (0/1)

Required field.

Deleted flag.

0—Active

1—Inactive/marked as deleted

last_mod_dt

Long (date)

Displays the last modified date.

last_mod_by

UUID

SREL to the ca_contacts table.

Displays the last date of when a user modified the record.

obj_type

nvarchar(30)

Required field. SREL to event_prod_list.

Kind of object for this event (knowledge document, and so forth).

query

nvarchar(30)

Required field. SREL to the cr_stored_queries.

Identifies the store query name.

sym

nvarchar(30)

Required field.

Identifies the policy name.

description

nvarchar(80)

Query policy description.