Table Apm_Case_Assignment_Rules
Entity
Entity: Projects.Agile.CaseAssignmentRules
Contains rules for automatically assigning cases to users based on the values of the case fields, such as project, project area, case category, system state, user state, etc. Entity: Apm_Case_Assignment_Rules (Introduced in version 25.1.3.5)
Summary
| Name |
Type |
Description |
| Assign_To_User_Id |
uniqueidentifier |
The user who will be automatically assigned to the case when the rule conditions are matched. |
| Case_Assignment_Rule_Id |
uniqueidentifier PK |
|
| Case_Category_Id |
uniqueidentifier |
The case category to which the rule applies. NULL means the rule applies to all categories. |
| From_Date |
date |
Starting date of rule validity. NULL means no from date restriction. |
| Is_Active |
bit |
Indicates whether the current rule is active. |
| Notes |
nvarchar(max) |
Additional information or comments related to the rule. |
| Priority |
char(1) Allowed: 1, 2, 3, 4, 5 |
Priority when multiple rules match the criteria. |
| Project_Area_Id |
uniqueidentifier |
The project area to which the rule applies. NULL means the rule applies to all project areas. |
| Project_Id |
uniqueidentifier |
The project to which the rule applies. NULL means the rule applies to all projects. |
| Project_Milestone_Id |
uniqueidentifier |
The project milestone to which the rule applies. NULL means the rule applies to all milestones. |
| Row_Version |
timestamp |
|
| Rule_No |
int |
Consecutive number of the rule. |
| Stakeholder_Party_Id |
uniqueidentifier |
The stakeholder party to which the rule applies. NULL means the rule applies to all parties. |
| System_State |
char(1) Allowed: 1, 2, 3, 4, 5, 6, 7 |
The system state to which the rule applies. NULL means the rule applies to all user states. |
| To_Date |
date |
Ending date (inclusive) of rule validity. NULL means that the rule is valid forever. |
| User_State_Id |
uniqueidentifier |
The user state to which the rule applies. NULL means the rule applies to all user states. |
Columns
Assign_To_User_Id
The user who will be automatically assigned to the case when the rule conditions are matched.
| Property |
Value |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
None |
| Enter Stop |
yes |
| Ignore for Insert Order |
no |
| Is Entity Name |
no |
| Max Length |
-1 |
| Order |
6 |
| Ownership Reference |
no |
| Pasword |
no |
| Picture |
no |
| Primary Key |
no |
| Readonly |
no |
| Referenced Table |
Sec_Users |
| RTF |
no |
| Sortable |
no |
| Summary Type |
None |
| Supports EQUALS_IN |
yes |
| Type |
uniqueidentifier |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Assign_To_User_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
no |
no |
Case_Assignment_Rule_Id
| Property |
Value |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
NewGuid |
| Enter Stop |
yes |
| Ignore for Insert Order |
no |
| Is Entity Name |
no |
| Max Length |
-1 |
| Order |
0 |
| Ownership Reference |
no |
| Pasword |
no |
| Picture |
no |
| Primary Key |
yes (order: 1) |
| Readonly |
no |
| RTF |
no |
| Sortable |
no |
| Summary Type |
None |
| Supports EQUALS_IN |
yes |
| Type |
uniqueidentifier |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
no |
Case_Assignment_Rule_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
no |
no |
Case_Category_Id
The case category to which the rule applies. NULL means the rule applies to all categories.
| Property |
Value |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
None |
| Enter Stop |
yes |
| Ignore for Insert Order |
no |
| Is Entity Name |
no |
| Max Length |
-1 |
| Order |
10 |
| Ownership Reference |
no |
| Pasword |
no |
| Picture |
no |
| Primary Key |
no |
| Readonly |
no |
| Referenced Table |
Apm_Case_Categories |
| RTF |
no |
| Sortable |
no |
| Summary Type |
None |
| Supports EQUALS_IN |
yes |
| Type |
uniqueidentifier (Allows NULL) |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Case_Category_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
yes |
no |
From_Date
Starting date of rule validity. NULL means no from date restriction.
| Property |
Value |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
None |
| Enter Stop |
yes |
| Ignore for Insert Order |
no |
| Is Entity Name |
no |
| Max Length |
-1 |
| Order |
2 |
| Ownership Reference |
no |
| Pasword |
no |
| Picture |
no |
| Primary Key |
no |
| Readonly |
no |
| RTF |
no |
| Sortable |
no |
| Summary Type |
None |
| Supports EQUALS_IN |
no |
| Type |
date (Allows NULL) |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
From_Date - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
yes |
no |
| GreaterThanOrLessThan |
None |
yes |
no |
Is_Active
Indicates whether the current rule is active.
| Property |
Value |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
True |
| Enter Stop |
yes |
| Ignore for Insert Order |
no |
| Is Entity Name |
no |
| Max Length |
-1 |
| Order |
4 |
| Ownership Reference |
no |
| Pasword |
no |
| Picture |
no |
| Primary Key |
no |
| Readonly |
no |
| RTF |
no |
| Sortable |
no |
| Summary Type |
None |
| Supports EQUALS_IN |
no |
| Type |
bit |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Is_Active - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
no |
no |
Notes
Additional information or comments related to the rule.
| Property |
Value |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
None |
| Enter Stop |
yes |
| Ignore for Insert Order |
no |
| Is Entity Name |
no |
| Max Length |
2147483647 |
| Order |
14 |
| Ownership Reference |
no |
| Pasword |
no |
| Picture |
no |
| Primary Key |
no |
| Readonly |
no |
| RTF |
no |
| Sortable |
no |
| Summary Type |
None |
| Supports EQUALS_IN |
no |
| Type |
nvarchar(max) (Allows NULL) |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Notes - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Like |
None |
no |
no |
Priority
Priority when multiple rules match the criteria.
| Property |
Value |
| Allowed Values |
1, 2, 3, 4, 5 |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
3 |
| Enter Stop |
yes |
| Ignore for Insert Order |
no |
| Is Entity Name |
no |
| Max Length |
1 |
| Order |
5 |
| Ownership Reference |
no |
| Pasword |
no |
| Picture |
no |
| Primary Key |
no |
| Readonly |
no |
| RTF |
no |
| Sortable |
no |
| Summary Type |
None |
| Supports EQUALS_IN |
no |
| Type |
char(1) |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Priority - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
no |
no |
Project_Area_Id
The project area to which the rule applies. NULL means the rule applies to all project areas.
| Property |
Value |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
None |
| Enter Stop |
yes |
| Ignore for Insert Order |
no |
| Is Entity Name |
no |
| Max Length |
-1 |
| Order |
8 |
| Ownership Reference |
no |
| Pasword |
no |
| Picture |
no |
| Primary Key |
no |
| Readonly |
no |
| Referenced Table |
Apm_Project_Areas |
| RTF |
no |
| Sortable |
no |
| Summary Type |
None |
| Supports EQUALS_IN |
yes |
| Type |
uniqueidentifier (Allows NULL) |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Project_Area_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
yes |
no |
Project_Id
The project to which the rule applies. NULL means the rule applies to all projects.
| Property |
Value |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
None |
| Enter Stop |
yes |
| Ignore for Insert Order |
no |
| Is Entity Name |
no |
| Max Length |
-1 |
| Order |
7 |
| Ownership Reference |
no |
| Pasword |
no |
| Picture |
no |
| Primary Key |
no |
| Readonly |
no |
| Referenced Table |
Apm_Projects |
| RTF |
no |
| Sortable |
no |
| Summary Type |
None |
| Supports EQUALS_IN |
yes |
| Type |
uniqueidentifier (Allows NULL) |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Project_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
yes |
no |
Project_Milestone_Id
The project milestone to which the rule applies. NULL means the rule applies to all milestones.
| Property |
Value |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
None |
| Enter Stop |
yes |
| Ignore for Insert Order |
no |
| Is Entity Name |
no |
| Max Length |
-1 |
| Order |
9 |
| Ownership Reference |
no |
| Pasword |
no |
| Picture |
no |
| Primary Key |
no |
| Readonly |
no |
| Referenced Table |
Apm_Project_Milestones |
| RTF |
no |
| Sortable |
no |
| Summary Type |
None |
| Supports EQUALS_IN |
yes |
| Type |
uniqueidentifier (Allows NULL) |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Project_Milestone_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
yes |
no |
Row_Version
| Property |
Value |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
None |
| Enter Stop |
yes |
| Ignore for Insert Order |
no |
| Is Entity Name |
no |
| Max Length |
-1 |
| Order |
15 |
| Ownership Reference |
no |
| Pasword |
no |
| Picture |
no |
| Primary Key |
no |
| Readonly |
no |
| RTF |
no |
| Sortable |
no |
| Summary Type |
None |
| Supports EQUALS_IN |
no |
| Type |
timestamp |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
no |
Rule_No
Consecutive number of the rule.
| Property |
Value |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
None |
| Enter Stop |
yes |
| Ignore for Insert Order |
no |
| Is Entity Name |
no |
| Max Length |
-1 |
| Order |
1 |
| Ownership Reference |
no |
| Pasword |
no |
| Picture |
no |
| Primary Key |
no |
| Readonly |
no |
| RTF |
no |
| Sortable |
yes |
| Summary Type |
None |
| Supports EQUALS_IN |
no |
| Type |
int |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Rule_No - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
no |
yes |
Stakeholder_Party_Id
The stakeholder party to which the rule applies. NULL means the rule applies to all parties.
| Property |
Value |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
None |
| Enter Stop |
yes |
| Ignore for Insert Order |
no |
| Is Entity Name |
no |
| Max Length |
-1 |
| Order |
11 |
| Ownership Reference |
no |
| Pasword |
no |
| Picture |
no |
| Primary Key |
no |
| Readonly |
no |
| Referenced Table |
Gen_Parties |
| RTF |
no |
| Sortable |
no |
| Summary Type |
None |
| Supports EQUALS_IN |
yes |
| Type |
uniqueidentifier (Allows NULL) |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Stakeholder_Party_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
yes |
no |
System_State
The system state to which the rule applies. NULL means the rule applies to all user states.
| Property |
Value |
| Allowed Values |
1, 2, 3, 4, 5, 6, 7 |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
None |
| Enter Stop |
yes |
| Ignore for Insert Order |
no |
| Is Entity Name |
no |
| Max Length |
1 |
| Order |
12 |
| Ownership Reference |
no |
| Pasword |
no |
| Picture |
no |
| Primary Key |
no |
| Readonly |
no |
| RTF |
no |
| Sortable |
no |
| Summary Type |
None |
| Supports EQUALS_IN |
yes |
| Type |
char(1) (Allows NULL) |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
System_State - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
yes |
no |
To_Date
Ending date (inclusive) of rule validity. NULL means that the rule is valid forever.
| Property |
Value |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
None |
| Enter Stop |
yes |
| Ignore for Insert Order |
no |
| Is Entity Name |
no |
| Max Length |
-1 |
| Order |
3 |
| Ownership Reference |
no |
| Pasword |
no |
| Picture |
no |
| Primary Key |
no |
| Readonly |
no |
| RTF |
no |
| Sortable |
no |
| Summary Type |
None |
| Supports EQUALS_IN |
no |
| Type |
date (Allows NULL) |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
To_Date - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
yes |
no |
| GreaterThanOrLessThan |
None |
yes |
no |
User_State_Id
The user state to which the rule applies. NULL means the rule applies to all user states.
| Property |
Value |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
None |
| Enter Stop |
yes |
| Ignore for Insert Order |
no |
| Is Entity Name |
no |
| Max Length |
-1 |
| Order |
13 |
| Ownership Reference |
no |
| Pasword |
no |
| Picture |
no |
| Primary Key |
no |
| Readonly |
no |
| Referenced Table |
Apm_User_States |
| RTF |
no |
| Sortable |
no |
| Summary Type |
None |
| Supports EQUALS_IN |
yes |
| Type |
uniqueidentifier (Allows NULL) |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
User_State_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
yes |
no |