active_flag

INTEGER NOT_NULL

Boolean_Table:: enum

0—Inactive

1—Active

close_date

LOCAL_TIME

Indicates when closed

cnote_type

INTEGER

Indicates the announcement type

control_group

UUID

Specifies the group to display to

del

INTEGER

Deleted flag

0—Active

1—Inactive/marked as deleted

id

INTEGER UNIQUE NOT_NULL KEY

Unique (to the table) Numeric ID

internal

INTEGER

Internal Flag

loc_id

UUID

ca_location:: location_uuid

Indicates a pointer to location

organization

UUID

ca_organization ::organization_ uuid

Indicates a pointer to Organization

persid

STRING 30

Persistent ID (SystemObjectName:id)

posted_by

UUID

ca_contact::uuid

Specifies who posted the announcement

posted_date

LOCAL_TIME

Indicates the last modify time

text

STRING 4000

Indicates the message text