SQL-013: Retrieve clsFederalCoverageLiabilityLimitCollection data¶

This document records the SQL used by clsFederalCoverageLiabilityLimitCollection in SAIF.Business.Policy.Rating.

Classification¶

Field	Value
SQL ID	SQL-013
Operation type	Read
Execution method	Data portal — criteria SQL (dynamic predicate builder)
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`clsFederalCoverageLiabilityLimitCollection`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve / AfterRetrieve`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:FederalCoverageTypeCode`	Input	Not specified	not specified	Bound parameter.
`:SelectDate`	Input	Not specified	not specified	Bound parameter.

Tables¶

Table	Access	Columns used
FED_COVERAGE_LIABILITY_LIMIT	SELECT	See sample SQL and source for column usage.

Sample SQL¶

Select
  FED_COVERAGE_LIABILITY_LIMIT.FED_LIABILITY_LIMIT_SEQ_NUM as FedLiabilityLimitSeqNum,
  FED_COVERAGE_LIABILITY_LIMIT.FED_COVERAGE_TYPE_CODE as FederalCoverageTypeCode,
  FED_COVERAGE_LIABILITY_LIMIT.LIABILITY_LIMIT_EFF_DATE as LiabilityLimitEffDate,
  FED_COVERAGE_LIABILITY_LIMIT.LIABILITY_LIMIT_EXP_DATE as LiabilityLimitExpDate,
  FED_COVERAGE_LIABILITY_LIMIT.LIABILITY_LIMIT_AMOUNT as LiabilityLimitAmount,
  FED_COVERAGE_LIABILITY_LIMIT.PREMIUM_ADJ_FACTOR as PremiumAdjustmentFactor,
  FED_COVERAGE_LIABILITY_LIMIT.VALID_FOR_ARP_FLAG as ValidForArpFlag,
  FED_COVERAGE_LIABILITY_LIMIT.MINIMUM_PREMIUM_AMOUNT as MinimumPremiumAmount,
  FED_COVERAGE_LIABILITY_LIMIT.NCCI_STAT_CODE as NcciStatCode
From
  FED_COVERAGE_LIABILITY_LIMIT
Where
  FED_COVERAGE_LIABILITY_LIMIT.FED_COVERAGE_TYPE_CODE = :FederalCoverageTypeCode
  AND (
    :SelectDate >= FED_COVERAGE_LIABILITY_LIMIT.LIABILITY_LIMIT_EFF_DATE AND
    :SelectDate < NVL(FED_COVERAGE_LIABILITY_LIMIT.LIABILITY_LIMIT_EXP_DATE,'01-Jan-2199')
  )

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.Rating\clsFederalCoverageLiabilityLimitCollection.vb:246-274