description

STRING 100

Comments field

addl_query

STRING 240

Additional query

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.

last_sync_dt

LOCAL_TIME

What was the last sync date

reoccur_interv

DURATION

How often to re-query

sched

STRING 30

Bop_Workshift:: persid

Valid run schedule

sym

STRING 30 UNIQUE NOT_NULL S_KEY

Name for rule

table_map

INTEGER

Global_Table_ Map::id

Table map