SQL-067: Retrieve premiumratingrulebasis¶

Retrieve premiumratingrulebasis in the context of clsPremiumRatingRuleBasis.

Classification¶

Field	Value
SQL ID	SQL-067
Operation type	Read
Execution method	Reader/Scalar
Database	Oracle
Command type	Text
Schema	[unqualified]
Business object	`clsPremiumRatingRuleBasis`
Criteria property	`RetrieveSQL`
Lifecycle method	BeforeRetrieve / AfterRetrieve

Parameters¶

Parameter	Direction	Type	Max length	Description
`:RatingRuleMasterID`	Input	Numeric*	inferred/unknown	Bind variable in clsPremiumRatingRuleBasis.RetrieveSQL.
`:PriorityNum`	Input	Numeric*	inferred/unknown	Bind variable in clsPremiumRatingRuleBasis.RetrieveSQL.
`:PremAdjustmentIncluded`	Input	Unknown*	inferred/unknown	Bind variable in clsPremiumRatingRuleBasis.RetrieveSQL.

Tables¶

Table	Access	Columns used
PREM_RATING_RULE_BASIS	SELECT	See sample SQL

Sample SQL¶

SELECT
  PREM_RATING_RULE_BASIS.RATING_RULE_MASTER_ID as RatingRuleMasterID,
  PREM_RATING_RULE_BASIS.PRIORITY_NUM as PriorityNum,
  PREM_RATING_RULE_BASIS.PREM_ADJUSTMENT_INCLUDED as PremAdjustmentIncluded,
  PREM_RATING_RULE_BASIS.PREM_ADJ_DCBS_TAXABLE_FLAG as PremAdjDcbsTaxableFlag
FROM PREM_RATING_RULE_BASIS
WHERE
  PREM_RATING_RULE_BASIS.RATING_RULE_MASTER_ID = :RatingRuleMasterID
  AND PREM_RATING_RULE_BASIS.PRIORITY_NUM = :PriorityNum
  AND PREM_RATING_RULE_BASIS.PREM_ADJUSTMENT_INCLUDED = :PremAdjustmentIncluded

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.Premium/Rating/clsPremiumRatingRuleBasis.vb