The Control Points' definitions are stored as XML within the RULESEGMENT column of the RULEPART table.
The query below will display control names in a format where the entity and point names are concatenated with an underscore, along with the XML configuration of that control point:
SELECT c.DISPLAYNAME, r.* FROM RULEPART r INNER JOIN "RULE" c on RULEFK=RULEPK
WHERE RULETYPEFK = 63
ORDER BY DISPLAYNAME
Within the XML in the RULESEGMENT column will a parameter named notifyInsightOverride that contains the setting value. An example of the XML is below:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ns3:controlPointRule xmlns="/generated/export/integrityrules/ocm" xmlns:ns2="/generated/export/val/actions" xmlns:ns3="/generated/export/integrityrules/ocm/cp">
<multiInstanceControlPoint name="samplecontrol" processDefinitionId="229051b0-4d3d-11ec-b5c7-048120524153" captureRule="_228a1020-4d3d-11ec-b5c7-048120524153_Capture" merge="_228fdc80-4d3d-11ec-b5c7-048120524153_Merge" storeHistory="false" instanceManagement="creates" cycleManagement="creates" executionActionLimit="100" executionProfile="default" dqplusControlDataPostProcessing="process" instancePreProcessing="none" notifyInsightOverride="bypass">
<description></description>
<actions>
<ns2:controlReportGeneration action="suppress"/>
<ns2:controlInstanceLifeCycle action="store"/>
<ns2:applyProcessMonitorControl action="apply"/>
<ns2:setRetentionPolicy policy="standard"/>
</actions>
<concurrency>
<fail/>
</concurrency>
</multiInstanceControlPoint>
</ns3:controlPointRule>
As a general disclaimer, the syntax and location of how controls are stored may change over time.