SQL-124: Count DCBS split rows¶

Count DCBS split rows in the context of clsPremiumSet.

Classification¶

Field	Value
SQL ID	SQL-124
Operation type	Read
Execution method	Reader/Scalar
Database	Oracle
Command type	Text
Schema	N/A — accessed via DB link @POLDB (Policy database)
Business object	N/A (Application layer)
Criteria property	`GetDcbsSplitsRetrieveSql`
Lifecycle method	Application-layer method: clsPremiumSet.GetDCBSSplits()

Parameters¶

Parameter	Direction	Type	Max length	Description
`:prem_hist_set_id`	Input	Numeric*	inferred/unknown	Bind variable in clsPremiumSet.GetDcbsSplitsRetrieveSql.

Tables¶

Table	Access	Columns used
PREM_HIST_PREM_ADJUSTMENT	SELECT	See sample SQL

Sample SQL¶

SELECT
  count(*) as DCBSsplits
FROM PREM_HIST_PREM_ADJUSTMENT pa
WHERE
  pa.prem_adjustment_type_code = 'DCBS'
  AND prem_hist_set_id = :prem_hist_set_id

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