SQL-009: Insert clsStatPremiumClass row¶

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

Classification¶

Field	Value
SQL ID	SQL-009
Operation type	Insert
Execution method	Data portal — criteria SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`clsStatPremiumClass`
Criteria property	`InsertSQL`
Lifecycle method	`BeforeInsert / AfterInsert`

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.

Tables¶

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

Sample SQL¶

Insert into STAT_PREMIUM_CLASS (
  STAT_CLASS_NUM,
  RETRO_EVAL_PREMIUM_TYPE_CODE,
  RETRO_EVAL_PREM_PRORATE_CODE,
  ERMOD_SUBJECT_FLAG,
  PRIM_POL_STATUTORY_TRANS_CODE,
  SCND_POL_STATUTORY_TRANS_CODE,
  SAIF_ONLY_FLAG,
  PER_CAPITA_FLAG,
  PRORATE_EXPOSURE_FLAG)
Values (
  :StatClassNumber,
  :RetroEvalPremiumType,
  :RetroEvalPremProrateCode,
  :ERModSubjectFlag,
  :PrimaryStatutoryTransCode,
  :SecondaryStatutoryTransCode,
  :SAIFOnlyFlag,
  :PerCapitaFlag,
  :ProrateExposureFlag)

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:691-716