McDewey

Rule (RI-334): Type: Validation (Insert/Update/Delete) Rule Name: Standard DirGroup Functional Role Resctrict Description: The Functional Roles associated with a stand Test Condition: ON INSERT/UPDATE/DELETE IN FunctionRole DirGroup WHERE pkid = @fkDirGroup) = 'T' T Error Message: Cannot modify the Functional Roles associate Remedy: Create a new DirGroup with the desired Role 2.3.206.2 fkfunctionrole (FI-1670) Type: guid (Cascade Delete) Rule (RI-334): Type: Validation (Insert/Update/Delete) Rule Name: Standard DirGroup Functional Role Resctrict Description: The Functional Roles associated with a stand Test Condition: ON INSERT/UPDATE/DELETE IN FunctionRole DirGroup WHERE pkid = @fkDirGroup) = 'T' T Error Message: Cannot modify the Functional Roles associate Remedy: Create a new DirGroup with the desired Role 2.3.206.3 pkid (FI-1669) Type: guid (Unique, Indexed, Not Modifiable) Default Value: newid() Remarks: Unique ID to identify a record. Uniqueness: fkfunctionrole + fkdirgroup is unique. (MFI-96) 2.3.207 functionroleresourcemap (TI-237) Description: Captures what roles have what permissions. Fields: 2.3.207.1 fkfunctionrole (FI-1681) Type: guid (Cascade Delete) Rule (RI-335): Type: Validation (Insert/Update/Delete) Rule Name: Standard Functional Role Resource Restrictio Description: The Resources and Permissions associated w changed in any way Test Condition: ON INSERT/UPDATE/DELETE IN FunctionRole FuntionRole WHERE pkid = @fkFunctionRole Error Message: Cannot modify the Permission and Resources Remedy: Create a new Role with the desired resources