SQL-054: Update clsStatPremiumClass row¶

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

Classification¶

Field	Value
SQL ID	SQL-054
Operation type	Update
Execution method	Data portal — criteria SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`clsStatPremiumClass`
Criteria property	`UpdateSQL`
Lifecycle method	`BeforeUpdate / AfterUpdate`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:StatClassNumber`	Input	Not specified	not specified	Bound parameter.
`:RetroEvalPremiumType`	Input	Not specified	not specified	Bound parameter.
`:RetroEvalPremProrateCode`	Input	Not specified	not specified	Bound parameter.
`:ERModSubjectFlag`	Input	Not specified	not specified	Bound parameter.
`:PrimaryStatutoryTransCode`	Input	Not specified	not specified	Bound parameter.
`:SecondaryStatutoryTransCode`	Input	Not specified	not specified	Bound parameter.
`:SAIFOnlyFlag`	Input	Not specified	not specified	Bound parameter.
`:PerCapitaFlag`	Input	Not specified	not specified	Bound parameter.
`:ProrateExposureFlag`	Input	Not specified	not specified	Bound parameter.
`:StatClassNum`	Input	Not specified	not specified	Bound parameter.

Tables¶

Table	Access	Columns used
STAT_PREMIUM_CLASS	UPDATE	See sample SQL and source for column usage.

Sample SQL¶

Update STAT_PREMIUM_CLASS
Set
  STAT_CLASS_NUM = :StatClassNumber,
  RETRO_EVAL_PREMIUM_TYPE_CODE = :RetroEvalPremiumType,
  RETRO_EVAL_PREM_PRORATE_CODE = :RetroEvalPremProrateCode,
  ERMOD_SUBJECT_FLAG = :ERModSubjectFlag,
  PRIM_POL_STATUTORY_TRANS_CODE = :PrimaryStatutoryTransCode,
  SCND_POL_STATUTORY_TRANS_CODE = :SecondaryStatutoryTransCode,
  SAIF_ONLY_FLAG = :SAIFOnlyFlag,
  PER_CAPITA_FLAG = :PerCapitaFlag,
  PRORATE_EXPOSURE_FLAG = :ProrateExposureFlag
Where
  STAT_PREMIUM_CLASS.STAT_CLASS_NUM = :StatClassNum

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\clsStatPremiumClass.vb:724-741