Contains information for the management of scheduled actions of cases and maintenance
Data model
Fields
| Field | Type | Description |
|---|---|---|
| id* | INT | Unique identifier of the scheduled action |
| is_active* | BIT | Determines whether the scheduled action is enabled or not |
| name* | VARCHAR (255) | Name of the scheduled action |
| number_items* | INT | Number of cases to be created for the scheduled action |
| project_id* | INT | Project associated with the programmed action |
| schedule_id* | INT | Schedule ID |
| template_id* | INT | Template ID |
| type* | INT | Scheduled Action Case Type |
Primary Key
| PK_ASDK_SCHEDULED_ACTION |
|---|
| id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| project_id* | dbo.ASMS_PROJECTS | proj_id | FK01_ASDK_SCHEDULED_ACTION |
| template_id* | Bod. ASDK_TEMPLATES | fl_int_id | FK02_ASDK_SCHEDULED_ACTION |