SQL-056: Retrieve employer liability limits¶
Retrieve employer liability limits in the context of clsEmployerLiabilityLimits.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-056 |
| Operation type | Read |
| Execution method | CommandType.StoredProcedure |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | Text |
| Business object | clsEmployerLiabilityLimits |
| Criteria property | RetrieveSQL |
| Lifecycle method | BeforeRetrieve / AfterRetrieve |
Parameters¶
This statement has no bind parameters.
Tables¶
This statement executes as a stored procedure call and does not expose table references in repository source.**
Sample SQL¶
> **Composed at runtime.** This property builds its statement conditionally. The block
> below shows every literal fragment in source order, so mutually exclusive branches
> appear consecutively - no single execution emits all of them. See the *Dynamic SQL*
> note in *Scope and evidence notes* for the branch conditions.
-- Stored-procedure invocation; no standalone SQL text in source.
WHERE
ELL.EMP_LIAB_STAT_CODE = :StatCode
AND ELL.EMP_LIAB_LIMIT1 = :AccidentLimitAmount
AND ELL.EMP_LIAB_LIMIT2 = :DiseaseEmployeeLimitAmount
AND ELL.EMP_LIAB_LIMIT3 = :DiseasePolicyLimitAmount
AND ELF.STANDARD_LIMITS_FLAG = 'Y'
Operations and processes¶
Business rules¶
- BR-021: Employers-liability limits may be retrieved by statistical code
- BR-024: Employers-liability limits must carry a valid statistical code
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\clsEmployerLiabilityLimits.vb