SQL-035: Insert premiumsummaryadjustment

Insert premiumsummaryadjustment in the context of clsPremiumSummaryAdjustment.

Classification

Field	Value
SQL ID	SQL-035
Operation type	Insert
Execution method	NonQuery
Database	Oracle
Command type	Text
Schema	N/A — accessed via DB link @POLDB (Policy database)
Business object	clsPremiumSummaryAdjustment
Criteria property	InsertSQL
Lifecycle method	BeforeInsert / AfterInsert

Parameters

Parameter	Direction	Type	Max length	Description
:PolicyNumber	Input	Numeric*	inferred/unknown	Bind variable in clsPremiumSummaryAdjustment.InsertSQL.
:PolicyPeriodEffectiveDate	Input	Date	inferred/unknown	Bind variable in clsPremiumSummaryAdjustment.InsertSQL.
:PremiumSetID	Input	Numeric*	inferred/unknown	Bind variable in clsPremiumSummaryAdjustment.InsertSQL.
:PriorityNumber	Input	Numeric*	inferred/unknown	Bind variable in clsPremiumSummaryAdjustment.InsertSQL.
:PremiumAdjustmentTypeCode	Input	String*	inferred/unknown	Bind variable in clsPremiumSummaryAdjustment.InsertSQL.
:RatingRuleMasterID	Input	Numeric*	inferred/unknown	Bind variable in clsPremiumSummaryAdjustment.InsertSQL.
:EffectiveDate	Input	Date	inferred/unknown	Bind variable in clsPremiumSummaryAdjustment.InsertSQL.
:ExpirationDate	Input	Date	inferred/unknown	Bind variable in clsPremiumSummaryAdjustment.InsertSQL.
:Adjustment	Input	Unknown*	inferred/unknown	Bind variable in clsPremiumSummaryAdjustment.InsertSQL.
:BaseAmount	Input	Numeric*	inferred/unknown	Bind variable in clsPremiumSummaryAdjustment.InsertSQL.
:DifferenceAmount	Input	Numeric*	inferred/unknown	Bind variable in clsPremiumSummaryAdjustment.InsertSQL.
:DCBSDifferenceAmount	Input	Numeric*	inferred/unknown	Bind variable in clsPremiumSummaryAdjustment.InsertSQL.

Tables

Table	Access	Columns used
PREM_HIST_PREM_SUMMARY	INSERT	See sample SQL

Sample SQL

Insert into PREM_HIST_PREM_SUMMARY (
  POLICY_NUM,
  POLICY_PERIOD_EFF_DATE,
  PREM_HIST_SET_ID,
  PRIORITY_NUM,
  PREM_ADJUSTMENT_TYPE_CODE,
  RATING_RULE_MASTER_ID,
  PREM_SUMMARY_EFF_DATE,
  PREM_SUMMARY_EXP_DATE,
  PREM_SUMMARY_ADJUSTMENT,
  PREM_SUMMARY_BASE_AMOUNT,
  PREM_SUMMARY_DIFF_AMOUNT,
  DCBS_DIFF_AMT)
Values (
  :PolicyNumber,
  :PolicyPeriodEffectiveDate,
  :PremiumSetID,
  :PriorityNumber,
  :PremiumAdjustmentTypeCode,
  :RatingRuleMasterID,
  :EffectiveDate,
  :ExpirationDate,
  :Adjustment,
  :BaseAmount,
  :DifferenceAmount,
  :DCBSDifferenceAmount)

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/clsPremiumSummaryAdjustment.vb