SQL-057: Retrieve employer liability limits collection¶

Retrieve employer liability limits collection in the context of clsEmployerLiabilityLimitsCollection.

Classification¶

Field	Value
SQL ID	SQL-057
Operation type	Read
Execution method	IDataRequest.SQLStatement (CommandType.Text)
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`clsEmployerLiabilityLimitsCollection`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve / AfterRetrieve`

Parameters¶

This statement has no bind parameters.

Tables¶

Table	Access	Columns used
EMPLOYERS_LIABILITY_LIMITS	SELECT	See sample SQL
EMPLOYERS_LIABILITY_FACTORS	SELECT	See sample SQL

Sample SQL¶

SELECT
  ELL.EMP_LIAB_STAT_CODE as StatCode,
  ELF.EMP_LIAB_EFF_DATE as EffectiveDate,
  ELF.EMP_LIAB_EXP_DATE as ExpirationDate,
  ELL.EMP_LIAB_LIMIT1 as AccidentLimitAmount,
  ELL.EMP_LIAB_LIMIT2 as DiseaseEmployeeLimitAmount,
  ELL.EMP_LIAB_LIMIT3 as DiseasePolicyLimitAmount,
  ELL.NCCI_STAT_CODE as NcciStatCode,
  ELF.EMP_LIAB_PERCENT as LiabilityFactor,
  ELF.EMP_LIAB_MINIMUM as MinimumPremiumAmount,
  ELF.EMP_LIAB_ASSIGNED_RISK as ARPMinimumPremiumAmount,
  ELF.STANDARD_LIMITS_FLAG as StandardLimitsFlag,
  ELL.VALID_FOR_ARP_FLAG as ValidForArpFlag,
  ELF.CONVERSION_EMP_LIAB_STAT_CODE as ConversionStatCode
FROM
  EMPLOYERS_LIABILITY_LIMITS ELL,
  EMPLOYERS_LIABILITY_FACTORS ELF
WHERE
  ELL.EMP_LIAB_STAT_CODE = ELF.EMP_LIAB_STAT_CODE

Operations and processes¶

Retrieve employers-liability limits

Business rules¶

BR-021: Employers-liability limits may be retrieved by 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\clsEmployerLiabilityLimitsCollection.vb