Skip to content

SAIF.Business.Policy.Premium stored procedures

This page catalogs Oracle stored procedures and PL/SQL packages invoked by this library.

Procedure catalog

Package / Procedure Schema Type Purpose Calling business objects
pk72195_renewal WCIS_DBA Package Given a premium history set's total MAN-type premium adjustment, recompute what that manual premium would be under a different rate tier, using the ratio of the two tiers' rate factors. clsPremiumSet (GetRecalcModifiedPremiumOnSpecifiedTier)
pk73059_prem_hist_summary WCIS_DBA Package Sum the reported (flagged) payroll for a class coverage line across its adjusted-rate-class detail rows. clsClassCoverage (inline call in GetRetreiveSql)
sp72652_get_saifplus WCIS_DBA Procedure (thin wrapper) Oracle helper logic referenced by this library. clsPremiumSummaryAdjustment (GetSAIFPlusInfo)
sp72151_determine_ncci_stat WCIS_DBA Function Oracle helper logic referenced by this library. clsPremiumSummaryAdjustment (GetStatClassNumber)

Sources

  • Business\SAIF.Business.Policy.Premium\clsPremiumSet.vb
  • Business\SAIF.Business.Policy.Premium\clsClassCoverage.vb
  • Business\SAIF.Business.Policy.Premium\clsPremiumSummaryAdjustment.vb
  • Oracle DBA_SOURCE for the referenced objects