notifycat Table
notifycat Table
Create notification category names to assign to notification templates in order to organize (filter/find) notifications by its template’s category. Using categories is completely optional.
| Field | Description |
|---|---|
| activity_id | Required - A foreign key to the afm_activities table to associate this category with an activity. Because notification category nomenclature will be unique to each application, the purpose of this field is for each activity to define and present only the categories that are applicable to the activity. This field is part of the Primary Key of the table |
| notify_cat |
Required - A 32-char descriptive name for the category. This is the Primary Key of the table. You should use a string that describes the category’s purpose or usage. Some sample categories would be to organize by importance: “URGENT”, “IMPORTANT”, etc. or by type “REMINDER”, “OVERDUE”, “IN-PROGRESS”, “COMPLETION”, etc. or by recipient type: “MANAGER”, “MAINTENANCE”, “COORDINATOR”, “VENDOR”, etc. |
| description | Optional 256-char long description for the category. You can use this to describe the category’s purpose and when it should be applied. |