SQL-041: Insert s a i f office collection

Insert s a i f office collection in the context of clsSAIFOfficeCollection.

Classification

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

Parameters

Parameter	Direction	Type	Max length	Description
:Code	Input	bound from Code	5	Bound in clsSAIFOfficeCollection.BeforeInsert (line 499)
:CodeDescr	Input	bound from CodeDescr	65	Bound in clsSAIFOfficeCollection.BeforeInsert (line 500)
:PmsOfficeCode	Input	bound from PMSOfficeCode	4	Bound in clsSAIFOfficeCollection.BeforeInsert (line 286)
:PolicyRenewalTrackCode	Input	bound from PolicyRenewalTrackCode	5	Bound in clsSAIFOfficeCollection.BeforeInsert (line 287)
:LocSeqNum	Input	bound from MyCriteria.LocSeqNum	-	Bound in clsSAIFOfficeCollection.BeforeRetrieve (line 456)
:CancellationTrackCode	Input	bound from m_CancellationTrackCode	5	Bound in clsSAIFOfficeCollection.BeforeInsert (line 595)
:PolicyRegionCode	Input	bound from m_PolicyRegionCode	5	Bound in clsSAIFOfficeCollection.BeforeInsert (line 291)

Tables

Table	Access	Columns used
OFFICE_CODE	INSERT	See sample SQL

Sample SQL

INSERT INTO
  OFFICE_CODE
  (
    CODE,
    CODE_DESCR,
    PMS_OFFICE_CODE,
    POLICY_RENEWAL_TRACK_CODE,
    LOC_SEQ_NUM,
    CANCELLATION_TRACK_CODE,
    POLICY_REGION_CODE
  )
VALUES
  (
    :Code,
    :CodeDescr,
    :PmsOfficeCode,
    :PolicyRenewalTrackCode,
    :LocSeqNum,
    :CancellationTrackCode,
    :PolicyRegionCode
  )

Business rules

• BR-030: The service centre office is identified by office
• 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\clsSAIFOfficeCollection.vb