pk72846_view_policy.sp73111_get_wcis_std_premium¶

Overview¶

Field	Value
Schema	`WCIS_DBA`
Type	Package function
Database	Oracle / WCIS
Calling libraries	`SAIF.Business.Policy.Audit.Premium`
Calling classes	`clsAuditPolicyPeriod`

Purpose¶

Resolves the newest premium-history set for the policy period and returns its standard premium

Procedures / Methods¶

sp73111_get_wcis_std_premium¶

Field	Value
Returns	See Oracle signature / caller behavior
Called by	`GetCurrentStandardPremium` (SQL-040)

Description: Resolves the newest premium-history set for the policy period and returns its standard premium

Business Rules¶

Rule ID	Rule	Condition	Action
PROC-RULE-037	Standard premium always comes from the maximum premium-history set for the policy period	Always	`RETURN pk73059_prem_hist_summary.get_standard_premium(pk73059_prem_hist_summary.get_max_ph_set_id(in_policy_num, in_pol_per_eff_date))`
PROC-RULE-038	The algorithm is duplicated in BDS and must be changed in lockstep	Header comment: "THIS LOGIC IS ALSO USED IN BDS. IF YOU CHANGE THIS YOU MUST CORRODINATE WITH THE BDS TEAM."	Any change requires BDS-team coordination

Operations¶

Operation	Description	Trigger
Get the WCIS standard premium	Resolves the newest premium-history set for the policy period and returns its standard premium	`clsAuditPolicyPeriod.GetCurrentStandardPremium` (SQL-040); OP-009

Source Code¶

PL/SQL package or method excerpt

   FUNCTION sp73111_get_wcis_std_premium
/****************************************************************
*Procedure Title  : Get WCIS Standard Premium
*Name             : SP73111_GET_WCIS_STD_PREMIUM
*Called by        : Business Online
*****************************************************************
* Description: This procedure gets the Standardized Standard Premium
*               based on the 9/8/07 New Standard Premium Project.
*
*               THIS LOGIC IS ALSO USED IN BDS.  IF YOU CHANGE THIS
*               YOU MUST CORRODINATE WITH THE BDS TEAM.
*
*               It gets the max premium history set for the policy
*               and policy period passed in.  It uses the Prem_Summary
*               view to define the correct set.
*
* Maintenance Log:
*   Name            CSR        Date     Description
* John Frey                 09/08/2007  Initial Release
******************************************************************/
   (
      in_policy_num         IN   NUMBER,
      in_pol_per_eff_date   IN   DATE
   )
      RETURN NUMBER
   IS
   BEGIN
      RETURN pk73059_prem_hist_summary.get_standard_premium(
                     pk73059_prem_hist_summary.get_max_ph_set_id(in_policy_num,in_pol_per_eff_date));
   END sp73111_get_wcis_std_premium;

/* Formatted on 4/23/2020 4:26:52 PM (QP5 v5.256.13226.35510) */

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: pk72846_view_policy.sp73111_get_wcis_std_premium
Calling code: `analysis\oracle-source\pk72846_view_policy.sql; clsAuditPolicyPeriod.vb