McDewey

Rule Name: Insert/Update on DevicePoolRouteGroupMa Description: On insert/update on the DevicePoolRouteGr contain the fk to RouteGroup only if isLocal should contain the fk to RouteGroup only if for the combination of fkDevicePool and fkR Test Condition: On I/U on DevicePoolRouteGroupMap, SELE RouteGroup WHERE pkid = new_fkRouteGro exception; SELECT IsLocalRouteGroup INTO new_fkRouteGroup; IF (isLRG <> 'f') THEN th DevicePoolRouteGroupMap WHERE fkDevic fkRouteGroup_Local=new_fkRouteGroup_Lo 2.3.112.4 pkid (FI-21154) Type: guid (Unique, Indexed, Not Modifiable) Default Value: newid() Migration Source: Generated Remarks: Unique ID to identify a record. Rule (RI-962): Type: Validation (Insert/Update) Rule Name: Insert/Update on DevicePoolRouteGroupMa Description: On insert/update on the DevicePoolRouteGr contain the fk to RouteGroup only if isLocal should contain the fk to RouteGroup only if for the combination of fkDevicePool and fkR Test Condition: On I/U on DevicePoolRouteGroupMap, SELE RouteGroup WHERE pkid = new_fkRouteGro exception; SELECT IsLocalRouteGroup INTO new_fkRouteGroup; IF (isLRG <> 'f') THEN th DevicePoolRouteGroupMap WHERE fkDevic fkRouteGroup_Local=new_fkRouteGroup_Lo Uniqueness: No multicolumn uniqueness constraints 2.3.113 deviceprivacydynamic (TI-435) Description: Frequently updated settings for Privacy Insert/Delete is not allowed. Fields: 2.3.113.1 datetimestamp (FI-3302) Type: long Default Value: 0 Rule (RI-400): Type: Active (Insert/Update) Rule Name: Update the DateTimeStamp for Dynamic reco