SQL-062: Read Pa Selection Rule Threshold Data¶

This statement supports the premium-audit library by read Pa Selection Rule Threshold Data.

Classification¶

Field	Value
SQL ID	SQL-062
Operation type	Read
Execution method	CommandType.Text / DataRequestType.DataResultSet
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`clsAuditSelectionTester`
Criteria property	n/a — application layer
Lifecycle method	`clsAuditSelectionTester.GetThresholdValues (application layer)`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:in_Premium_Amount`	Input	bound from `inPremiumAmount`	—	Bound in `clsAuditSelectionTester.GetThresholdAmount` (line 218)
`:in_threshold_type`	Input	bound from `"PREM"`	5	Bound in `clsAuditSelectionTester.GetThresholdAmount` (line 220)

Tables¶

Table	Access	Columns used
`PA_SELECTION_RULE_THRESHOLD`	SELECT	See sample SQL.

Sample SQL¶

SELECT
  threshold_tolerable_amount as ThresholdTolerableAmt,
  threshold_tolerable_percent as ThresholdTolerablePercent
FROM
  pa_selection_rule_threshold
WHERE
  :in_Premium_Amount between threshold_low_premium_amount
  AND NVL(threshold_high_premium_amount, (:in_Premium_Amount + 1))
  AND pa_threshold_type_code = :in_threshold_type

Operations and processes¶

Run audit selection tests

Business rules¶

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources¶

Business/SAIF.Business.Policy.Audit.Premium/clsAuditSelectionTester.vb:205-245, 1176-1186