description

STRING 240

Specifies the textual description of this stored query.

code

STRING 12 UNIQUE NOT_NULL S_KEY

Specifies the non-editable handle for the query.

count_url

STRING 240

Specifies the URL for counts, if obj_type=url.

criteria

STRING 240

Specifies the where clause for querying.

del

INTEGER NOT_NULL

Active_Boolean_ Table::enum

The deleted flag

0—active

1—inactive/marked as deleted)

id

INTEGER UNIQUE NOT_NULL KEY

Specifies the key (to the table) Numeric ID.

label

STRING 80

Specifies the label to display on the scoreboard.

last_mod_by

UUID

ca_contact::uuid

Specifies the UUID of the contact who last modified this record.

last_mod_dt

LOCAL_TIME

Indicates the timestamp for when this record was last modified.

obj_type

STRING 30

Indicates the scoreboard, with the capability of having enough space to allow for expansions to accommodate the cr, tt, ir, and chg types.

persid

STRING 30

The Persistent ID (SystemObjectName:id).