SQL-040: Insert s a i f office

Insert s a i f office in the context of clsSAIFOffice.

Classification

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

Parameters

Parameter	Direction	Type	Max length	Description
:Code	Input	bound from Code	5	Bound in clsSAIFOffice.BeforeInsert (line 285)
:Description	Input	bound from m_Description	65	Bound in clsSAIFOffice.BeforeInsert (line 289)
:PMSOfficeCode	Input	bound from PMSOfficeCode	4	Bound in clsSAIFOffice.BeforeInsert (line 286)
:PolicyRenewalTrackCode	Input	bound from PolicyRenewalTrackCode	5	Bound in clsSAIFOffice.BeforeInsert (line 287)
:LocationSeqNum	Input	bound from m_LocationSeqNum	-	Bound in clsSAIFOffice.BeforeInsert (line 290)
:CancellationTrackCode	Input	bound from CancellationTrackCode	5	Bound in clsSAIFOffice.BeforeInsert (line 288)
:PolicyRegionCode	Input	bound from m_PolicyRegionCode	5	Bound in clsSAIFOffice.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,
    :Description,
    :PMSOfficeCode,
    :PolicyRenewalTrackCode,
    :LocationSeqNum,
    :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\clsSAIFOffice.vb