SQL-116: Retrieve adjusted-rate billing flag¶

Retrieve adjusted-rate billing flag in the context of clsPremiumSummaryAdjustment.

Classification¶

Field	Value
SQL ID	SQL-116
Operation type	Read
Execution method	Reader/Scalar
Database	Oracle
Command type	Text
Schema	[unqualified]
Business object	N/A (Application layer)
Criteria property	`GetAdjustedRateFlagSQL`
Lifecycle method	Application-layer method: clsPremiumSummaryAdjustment.GetAdjustedRateFlag()

Parameters¶

Parameter	Direction	Type	Max length	Description
`:policy_num`	Input	Numeric*	inferred/unknown	Bind variable in clsPremiumSummaryAdjustment.GetAdjustedRateFlagSQL.
`:pp_eff_date`	Input	Date	inferred/unknown	Bind variable in clsPremiumSummaryAdjustment.GetAdjustedRateFlagSQL.

Tables¶

Table	Access	Columns used
BILLING_MASTER	SELECT	See sample SQL
BILLING_DEFAULTS	SELECT	See sample SQL
PAYMENT_PLAN_TYPE_CODE	SELECT	See sample SQL

Sample SQL¶

SELECT
  adjusted_rate_calculation_flag AS AdjRateFlag
FROM BILLING_MASTER bm,
     BILLING_DEFAULTS bd,
     PAYMENT_PLAN_TYPE_CODE pptc
WHERE
  bm.policy_num = :policy_num
  AND bm.policy_period_eff_date = :pp_eff_date
  AND bm.billing_default_code = bd.billing_default_code
  AND bd.payment_plan_type = pptc.code

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/clsPremiumSummaryAdjustment.vb