SQL-123: Fetch next premium set key¶

Fetch next premium set key in the context of clsPremiumSet.

Classification¶

Field	Value
SQL ID	SQL-123
Operation type	Read
Execution method	Scalar (Text)
Database	Oracle
Command type	Text
Schema	[unqualified]**
Business object	N/A (Application layer)
Criteria property	`GetPremiumHistSummarySeqSql`
Lifecycle method	Application-layer method: GetPremiumHistSummarySeqSql

Parameters¶

Parameter	Direction	Type	Max length	Description
None	—	—	—	No parameters.

Tables¶

Table	Access	Columns used
N/A	Sequence / procedure	Sequence lookup prior to insert; no base table is queried directly.

Sample SQL¶

SELECT PREMIUM_HIST_SUMMARY_SEQ.NEXTVAL[@POLDB] FROM dual

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.Premium/clsPremiumSet.vb