pk72195_renewal.sp72187_get_standard_prem¶

Overview¶

Field	Value
Schema	WCIS_DBA
Type	Package function
Database	Oracle
Calling libraries	`SAIF.Business.Policy.Core`
Calling classes	`clsPolicyPeriod`

Purpose¶

Sums premium-summary difference amounts up to the experience-modification priority for one premium-history set

Procedures / Methods¶

sp72187_get_standard_prem¶

Field	Value
Returns	See PL/SQL source below.
Called by	`clsPolicyPeriod`

Description: Sums premium-summary difference amounts up to the experience-modification priority for one premium-history set

Parameters¶

Parameter	Direction	Type	Default	Description
`in_policy_num`	IN	`VARCHAR2`	—	Policy number whose premium-history set is being evaluated for standard premium.
`in_set_id`	IN	`NUMBER`	—	Premium-history set identifier whose `prem_summary_diff_amount` rows are summed.

Business Rules¶

Rule ID	Rule	Condition	Action
PROC-RULE-001	Standard premium is the sum of premium-summary differences up to and including the experience-modification priority	`PREM_HIST_PREM_SUMMARY.prem_hist_set_id = in_set_id` and `priority_num <= (select priority_num from PREM_RATING_RULE_PRIORITY where PREM_ADJUSTMENT_TYPE_CODE = 'MOD' and rating_rule_master_id = PREM_HIST_PREM_SUMMARY.rating_rule_master_id)`	Return `SUM(prem_summary_diff_amount)`; adjustments priced after the MOD rule are excluded

Operations¶

Operation	Description	Trigger
Compute WCIS standard premium for a premium-history set	Sums premium-summary difference amounts up to the experience-modification priority for one premium-history set	`clsPolicyPeriod.GetStandardPremium` (SQL-080), after resolving the max set id via `PolicyInformation.MaxPremiumHistorySetId`

Source Code¶

PL/SQL source

FUNCTION sp72187_get_standard_prem (
      in_policy_num IN VARCHAR2,
      in_set_id IN NUMBER
      )
      RETURN NUMBER
   IS

      v_standard_prem               NUMBER;

   BEGIN

      SELECT SUM (prem_summary_diff_amount)
        INTO v_standard_prem
        FROM PREM_HIST_PREM_SUMMARY
       WHERE prem_hist_set_id = in_set_id
         AND priority_num <=
                ( SELECT priority_num
                    FROM PREM_RATING_RULE_PRIORITY
                   WHERE PREM_ADJUSTMENT_TYPE_CODE = 'MOD'
                     AND rating_rule_master_id =
                            PREM_HIST_PREM_SUMMARY.rating_rule_master_id);

      RETURN  (v_standard_prem);

   END sp72187_get_standard_prem;



   /********************************************************
      * Procedure Title   :
      * Name              : sp72190_calc_weighted_freq
      * Called by         :
      * Prepared By       : Brian Cottings/Clay Andrews
      * Created           : 09/01/98
      * Modification History
      * --------------------------------------------------------
      *
      *********************************************************/

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¶

Oracle DBA_SOURCE: pk72195_renewal.sp72187_get_standard_prem
Business\SAIF.Business.Policy.Core\clsPolicyPeriod.vb