Skip to content

Retrieve SAIF Plus information

A SAIFPLUS premium summary adjustment needs its descriptive/rate data

Field Value
Operation ID OP-007
Trigger A SAIFPLUS premium summary adjustment needs its descriptive/rate data
Inputs in_policy_num, in_policy_period_eff_date
Outputs out_pp_eff_date, out_saifplus_eff_date, out_saifplus_desc (100), out_saifplus_rate, out_saifplus_max, out_saifplus_combo_max
Primary components clsPremiumSummaryAdjustment.GetSAIFPlusInfo (clsPremiumSummaryAdjustment.vb:451-478)
Entry point Business\SAIF.Business.Policy.Premium\clsPremiumSummaryAdjustment.vb

Steps

  1. Build a command with CommandType.StoredProcedure for sp72652_get_saifplus.
  2. Add the two input parameters and six output parameters with declared sizes.
  3. Execute through the data portal.
  4. Map the output parameters onto the adjustment's SAIF Plus fields, used later by OP-006.

Process flow

The following diagram visualizes this operation's control flow.

flowchart TD
    Start([Trigger]) --> S1[Step 1]
    S1 --> S2[Step 2]
    S2 --> EndOk([Outputs returned])

Failure and edge-case behavior

  • See the linked rules and SQL references above for validation failures, null-handling, and persistence contention behavior.

Sources

  • Business\SAIF.Business.Policy.Premium\clsPremiumSummaryAdjustment.vb