SQL-011: Fetch next policy period employer liability limits collection sequence value

Fetch next policy period employer liability limits collection sequence value in the context of clsPolicyPeriodEmployerLiabilityLimitsCollection.

Classification

Field	Value
SQL ID	SQL-011
Operation type	Create (sequence)
Execution method	IDataRequest.SQLStatement (CommandType.Text)
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsPolicyPeriodEmployerLiabilityLimitsCollection
Criteria property	CreateSQL
Lifecycle method	BeforeCreate / AfterCreate

Parameters

This statement has no bind parameters.

Tables

Table	Access	Columns used
DUAL	SELECT	See sample SQL

Sample SQL

SELECT
  POLICY_NUM_NEXTVAL
FROM
  DUAL

Operations and processes

• Retrieve employers-liability limits

Business rules

• BR-025: Per-period employers-liability limits must carry a valid statistical
• BR-033: New sequence values for writable entities are obtained

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\clsPolicyPeriodEmployerLiabilityLimitsCollection.vb