Retrieve employers-liability limits

Retrieve employers-liability limits describes the corresponding policy-core workflow and its BOF or Oracle touchpoints.

Field	Value
Operation ID	OP-014
Trigger	—
Inputs	—
Outputs	—
Primary components	`clsEmployerLiabilityLimits.Criteria.RetrieveSQL (clsEmployerLiabilityLimits.vb)`
Entry point	Business\SAIF.Business.Policy.Core

Steps

1. Consolidate supporting references.
2. Related business rules: BR-021, BR-024, BR-025, BR-033
3. Related SQL statements: SQL-010, SQL-011, SQL-031, SQL-032, SQL-056, SQL-057, SQL-089, SQL-090, SQL-132, SQL-133, SQL-153, SQL-154
4. Related tables: DUAL, POLICY_PERIOD_EMP_LIAB, EMPLOYERS_LIABILITY_LIMITS, EMPLOYERS_LIABILITY_FACTORS

Process flow

The following diagram visualizes this operation's control flow.

flowchart TD
    Start([Trigger]) --> S1[Apply policy-core logic]
    S1 --> D{Validation or branch?}
    D -->|Continue| S2[Execute BOF SQL or Oracle call]
    D -->|Stop| EndErr([Return error or empty result])
    S2 --> EndOk([Return populated result])

Failure and edge-case behavior

• Error, warning, and empty-result behavior follows the rules and SQL cited in the steps above.
• Stored-procedure-backed paths depend on Oracle-side logic outside this repository.**

Related documentation

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

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

• Business\SAIF.Business.Policy.Core\clsPolicy.vb
• Business\SAIF.Business.Policy.Core\clsPolicyPeriodBase.vb
• Business\SAIF.Business.Policy.Core\clsPolicyPeriod.vb
• Business\SAIF.Business.Policy.Core\clsLegacyPolicyPeriod.vb
• Business\SAIF.Business.Policy.Core\clsCancelReasonOverride.vb
• Business\SAIF.Business.Policy.Core\WCISInquiry.vb