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) |
Related documentation¶
Sources¶
Business\SAIF.Business.Policy.Premium\clsPremiumSet.vbBusiness\SAIF.Business.Policy.Premium\clsClassCoverage.vbBusiness\SAIF.Business.Policy.Premium\clsPremiumSummaryAdjustment.vb- Oracle DBA_SOURCE for the referenced objects