SQL-025: Insert cancellation warning collection¶

Insert cancellation warning collection in the context of clsCancellationWarningCollection.

Classification¶

Field	Value
SQL ID	SQL-025
Operation type	Insert
Execution method	IDataRequest.SQLStatement (CommandType.Text)
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`clsCancellationWarningCollection`
Criteria property	`InsertSQL`
Lifecycle method	`BeforeInsert / AfterInsert`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:BatchProcessedFlag`	Input	bound from `BatchProcessedFlag`	1	Bound in `clsCancellationWarningCollection.BeforeInsert` (line 563)
`:CancellationSeqNum`	Input	bound from `MyCriteria.CancellationSeqNum`	-	Bound in `clsCancellationWarningCollection.BeforeInsert` (line 194)
`:PolicyNum`	Input	bound from `MyCriteria.PolicyNum`	-	Bound in `clsCancellationWarningCollection.BeforeRetrieve` (line 249)
`:CancelDate`	Input	bound from `m_CancelDate`	-	Bound in `clsCancellationWarningCollection.BeforeInsert` (line 568)
`:CancelUser`	Input	bound from `m_CancelUser`	30	Bound in `clsCancellationWarningCollection.BeforeInsert` (line 569)
`:NoticeOFIntentDate`	Input	bound from `m_NoticeOfIntentDate`	-	Bound in `clsCancellationWarningCollection.BeforeInsert` (line 570)
`:NoticeOFIntentUser`	Input	bound from `m_NoticeOfIntentUser`	30	Bound in `clsCancellationWarningCollection.BeforeInsert` (line 571)
`:ReinstateReasonCode`	Input	bound from `m_ReinstateReasonCode`	5	Bound in `clsCancellationWarningCollection.BeforeInsert` (line 521)
`:CancelReasonCode`	Input	bound from `CancelReasonCode`	5	Bound in `clsCancellationWarningCollection.BeforeInsert` (line 186)
`:RescindDate`	Input	bound from `m_RescindDate`	-	Bound in `clsCancellationWarningCollection.BeforeInsert` (line 574)
`:RescindUser`	Input	bound from `m_RescindUser`	30	Bound in `clsCancellationWarningCollection.BeforeInsert` (line 575)
`:ReinstateDate`	Input	bound from `m_ReinstateDate`	-	Bound in `clsCancellationWarningCollection.BeforeInsert` (line 576)
`:ReinstateUser`	Input	bound from `m_ReinstateUser`	30	Bound in `clsCancellationWarningCollection.BeforeInsert` (line 577)
`:ReinstatementFeeFlag`	Input	bound from `m_ReinstatementFeeFlag`	1	Bound in `clsCancellationWarningCollection.BeforeInsert` (line 578)
`:CreateDate`	Input	bound from `CreateDate`	-	Bound in `clsCancellationWarningCollection.BeforeInsert` (line 190)
`:CreateUser`	Input	bound from `CreateUser`	30	Bound in `clsCancellationWarningCollection.BeforeInsert` (line 189)
`:UpdateUser`	Input	bound from `m_UpdateUser`	30	Bound in `clsCancellationWarningCollection.BeforeInsert` (line 579)
`:RescindUpdateDate`	Input	bound from `m_RescindUpdateDate`	-	Bound in `clsCancellationWarningCollection.BeforeInsert` (line 580)
`:CancelUpdateDate`	Input	bound from `m_CancelUpdateDate`	-	Bound in `clsCancellationWarningCollection.BeforeInsert` (line 581)
`:ReinstateUpdateDate`	Input	bound from `m_ReinstateUpdateDate`	-	Bound in `clsCancellationWarningCollection.BeforeInsert` (line 582)
`:NoticeOFIntentUpdateDate`	Input	bound from `m_NoticeOfIntentUpdateDate`	-	Bound in `clsCancellationWarningCollection.BeforeInsert` (line 583)
`:FuturePlpStatusCode`	Input	bound from `m_FuturePLPStatusCode`	5	Bound in `clsCancellationWarningCollection.BeforeInsert` (line 584)
`:CancelRequestorName`	Input	bound from `m_CancelRequestorName`	50	Bound in `clsCancellationWarningCollection.BeforeInsert` (line 585)
`:CancelRequestMethodCode`	Input	bound from `m_CancelRequestMethodCode`	5	Bound in `clsCancellationWarningCollection.BeforeInsert` (line 586)
`:RequestDate`	Input	bound from `m_RequestDate`	-	Bound in `clsCancellationWarningCollection.BeforeInsert` (line 587)
`:ShortRateFlag`	Input	bound from `m_ShortRateFlag`	1	Bound in `clsCancellationWarningCollection.BeforeInsert` (line 588)
`:UpdateDate`	Input	bound from `m_UpdateDate`	-	Bound in `clsCancellationWarningCollection.BeforeInsert` (line 589)
`:CarrierCode`	Input	bound from `CarrierCode`	5	Bound in `clsCancellationWarningCollection.BeforeInsert` (line 187)
`:ReinstateRequestDate`	Input	bound from `m_ReinstateRequestDate`	-	Bound in `clsCancellationWarningCollection.BeforeInsert` (line 591)
`:PremHistSetID`	Input	unknown	-	Bind variable present in SQL text; no matching `AddParm` located - unknown**
`:PolicyMemoSeqNum`	Input	bound from `m_PolicyMemoSeqNum`	-	Bound in `clsCancellationWarningCollection.BeforeInsert` (line 593)
`:NoticeOFReminderDate`	Input	bound from `m_NoticeOfReminderDate`	-	Bound in `clsCancellationWarningCollection.BeforeInsert` (line 594)
`:CancellationTrackCode`	Input	bound from `m_CancellationTrackCode`	5	Bound in `clsCancellationWarningCollection.BeforeInsert` (line 595)

Tables¶

Table	Access	Columns used
CANCELLATION	INSERT	See sample SQL

Sample SQL¶

INSERT INTO
  CANCELLATION
  (
    BATCH_PROCESSED_FLAG,
    CANCELLATION_SEQ_NUM,
    POLICY_NUM,
    CANCEL_DATE,
    CANCEL_USER,
    NOTICE_OF_INTENT_DATE,
    NOTICE_OF_INTENT_USER,
    REINSTATE_REASON_CODE,
    CANCEL_REASON_CODE,
    RESCIND_DATE,
    RESCIND_USER,
    REINSTATE_DATE,
    REINSTATE_USER,
    REINSTATEMENT_FEE_FLAG,
    CREATE_DATE,
    CREATE_USER,
    UPDATE_USER,
    RESCIND_UPDATE_DATE,
    CANCEL_UPDATE_DATE,
    REINSTATE_UPDATE_DATE,
    NOTICE_OF_INTENT_UPDATE_DATE,
    FUTURE_PLP_STATUS_CODE,
    CANCEL_REQUESTOR_NAME,
    CANCEL_REQUEST_METHOD_CODE,
    REQUEST_DATE,
    SHORT_RATE_FLAG,
    UPDATE_DATE,
    CARRIER_CODE,
    REINSTATE_REQUEST_DATE,
    PREM_HIST_SET_ID,
    POLICY_MEMO_SEQ_NUM,
    NOTICE_OF_REMINDER_DATE,
    CANCELLATION_TRACK_CODE
  )
VALUES
  (
    :BatchProcessedFlag,
    :CancellationSeqNum,
    :PolicyNum,
    :CancelDate,
    :CancelUser,
    :NoticeOFIntentDate,
    :NoticeOFIntentUser,
    :ReinstateReasonCode,
    :CancelReasonCode,
    :RescindDate,
    :RescindUser,
    :ReinstateDate,
    :ReinstateUser,
    :ReinstatementFeeFlag,
    :CreateDate,
    :CreateUser,
    :UpdateUser,
    :RescindUpdateDate,
    :CancelUpdateDate,
    :ReinstateUpdateDate,
    :NoticeOFIntentUpdateDate,
    :FuturePlpStatusCode,
    :CancelRequestorName,
    :CancelRequestMethodCode,
    :RequestDate,
    :ShortRateFlag,
    :UpdateDate,
    :CarrierCode,
    :ReinstateRequestDate,
    :PremHistSetID,
    :PolicyMemoSeqNum,
    :NoticeOFReminderDate,
    :CancellationTrackCode
  )

Operations and processes¶

Record a cancellation reason override

Business rules¶

BR-033: New sequence values for writable entities are obtained

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\clsCancellationWarningCollection.vb