McDewey

Description: Used for mapping multiple Route Groups to a Device Pool. According to the Mu more than one Route Groups to a Device Pool. So this table is used for mapping Fields: 2.3.112.1 fkdevicepool (FI-21155) Type: guid (Cascade Delete, Null OK) Remarks: reference to device pool 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 2.3.112.2 fkroutegroup (FI-21157) Type: guid (Cascade Delete) Remarks: fkRouteGroup should contain the fk to route group only if is mandatory as it will point to the actual Route Group that wi activities. 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 2.3.112.3 fkroutegroup_local (FI-21156) Type: guid (Cascade Delete, Null OK) Default Value: NULL Remarks: fkRouteGroup_local should contain the fk to route group on in this field will just be used to give a name to the actual rou Rule (RI-962): Type: Validation (Insert/Update)