add_query

STRING 240

arc_file_name

STRING 240

conf_obj_name

STRING 64

days_inactive

INTEGER NOT_NULL

del

INTEGER NOT_NULL

Active_Boolean_ Table::enum

Deleted flag

0—Active

1—Inactive/marked as deleted

id

INTEGER UNIQUE NOT_NULL KEY

Unique (to the table) Numeric ID

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 of when this record was last modified.

name

STRING 30 NOT_NULL UNIQUE NOT_NULL S_KEY

Specifies the text name of this item.

oper_type

INTEGER NOT_NULL

persid

STRING 30

Persistent ID (SystemObjectName:id)

reoccur_interv

DURATION

sched

STRING 30

Bop_Workshift ::persid