Determine ELCB status

Description building and adjusted-rate handling need to know whether ELCB applies

Field	Value
Operation ID	OP-008
Trigger	Description building and adjusted-rate handling need to know whether ELCB applies
Inputs	Policy number, policy period effective date
Outputs	ELCB status code; sets m_HasELCB
Primary components	clsPremiumSummaryAdjustment.GetELCBStatusCode (clsPremiumSummaryAdjustment.vb:525-548)
Entry point	Business\SAIF.Business.Policy.Premium\clsPremiumSummaryAdjustment.vb

Steps

1. Execute GetELCBStatusSQL: SELECT emp_liab_stat_code FROM POLICY_PERIOD_EMP_LIAB WHERE policy_num = :policy_num AND policy_period_eff_date = :pp_eff_date AND prem_adjustment_eff_date <> prem_adjustment_exp_date.
2. Set m_HasELCB = (result IsNot Nothing) (BR-021).
3. Return the status code to the caller.

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.

Related documentation

• Operations and processes
• Business rules
• SQL catalog
• Database tables

Sources

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