SQL-134: Update policy period master¶

Update policy period master in the context of clsPolicyPeriodMaster.

Classification¶

Field	Value
SQL ID	SQL-134
Operation type	Update
Execution method	IDataRequest.SQLStatement (CommandType.Text)
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`clsPolicyPeriodMaster`
Criteria property	`UpdateSQL`
Lifecycle method	`BeforeUpdate / AfterUpdate`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:PolicyNumber`	Input	bound from `PolicyNumber`	-	Bound in `clsPolicyPeriodMaster.BeforeUpdate` (line 232)
`:EffectiveDate`	Input	bound from `EffectiveDate`	-	Bound in `clsPolicyPeriodMaster.BeforeUpdate` (line 233)
`:SourceSystem`	Input	bound from `SourceSystem`	4	Bound in `clsPolicyPeriodMaster.BeforeUpdate` (line 234)
`:PolicySuffix`	Input	bound from `m_PolicySuffix`	3	Bound in `clsPolicyPeriodMaster.BeforeUpdate` (line 235)
`:CancelDate`	Input	bound from `m_CancelDate`	-	Bound in `clsPolicyPeriodMaster.BeforeUpdate` (line 236)
`:LegacyWriteoffPremiumAmount`	Input	bound from `m_LegacyWriteoffPremiumAmount`	-	Bound in `clsPolicyPeriodMaster.BeforeUpdate` (line 237)
`:LegacyWriteoffAssessmentAmount`	Input	bound from `m_LegacyWriteoffAssessmentAmount`	-	Bound in `clsPolicyPeriodMaster.BeforeUpdate` (line 238)
`:LegacyWriteoffCourtAmount`	Input	bound from `m_LegacyWriteoffCourtAmount`	-	Bound in `clsPolicyPeriodMaster.BeforeUpdate` (line 239)

Tables¶

Table	Access	Columns used
POLICY_PERIOD_MASTER	UPDATE	See sample SQL

Sample SQL¶

UPDATE
  POLICY_PERIOD_MASTER
SET
  POLICY_NUM = :PolicyNumber,
  POLICY_PERIOD_EFF_DATE = :EffectiveDate,
  SOURCE_SYSTEM = :SourceSystem,
  POLICY_SFX = :PolicySuffix,
  CANCEL_DATE = :CancelDate,
  LEGACY_WRITEOFF_PREMIUM_AMT = :LegacyWriteoffPremiumAmount,
  LEGACY_WRITEOFF_ASSESSMENT_AMT = :LegacyWriteoffAssessmentAmount,
  LEGACY_WRITEOFF_COURT_AMT = :LegacyWriteoffCourtAmount
WHERE
  POLICY_PERIOD_MASTER.POLICY_NUM = :PolicyNumber
  AND POLICY_PERIOD_MASTER.POLICY_PERIOD_EFF_DATE = :EffectiveDate

Operations and processes¶

Build a unified policy period timeline

Business rules¶

BR-010: A policy's period history is the union of

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.Core\clsPolicyPeriodMaster.vb