AutomatedCategoryUpdate table - SuperOffice

AutomatedCategoryUpdate Table (551)

Info on how to autoupdate category when changing sale or leadstatus on person

Fields

Name	Description	Type	Nullable
automatedcategoryupdate_id	Primary key	PK	No
trigger_type	The type of change to trigger the auto update	Enum CategoryUpdateTrigger	Yes
user_confirmation	Whether to ask the user for confirmation before applying the autoupdate	Bool	Yes
default_category	The default category id to update to, and the actual new value if no user confirmation is needed	FK Category	Yes
registered	Registered when	UtcDateTime	No
registered_associate_id	Registered by whom	FK associate	No
updated	Last updated when	UtcDateTime	No
updated_associate_id	Last updated by whom	FK associate	No
updatedCount	Number of updates made to this record	UShort	No
leadstatus_id	The leadstatus id to match on person, to trigger autoupdate of category	FK leadstatus	Yes

AutomatedCategoryUpdate table relationship diagram

Indexes

Fields	Types	Description
trigger_type	Enum	Unique

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
Category	Category list table
leadstatus	List items of lead status that is selectable for contacts and persons that have specific category

Replication Flags

None

Security Flags

No access control via user’s Role.