SQL-011: Insert Pa Policy Period Data¶

This statement supports the premium-audit library by insert Pa Policy Period Data.

Classification¶

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

Parameters¶

Parameter	Direction	Type	Max length	Description
`:AuditSequenceNumber`	Input	bound from `AuditSequenceNumber`	—	Bound in `clsAuditPolicyPeriod.BeforeInsert` (line 487)
`:PolicyNumber`	Input	bound from `PolicyNumber`	—	Bound in `clsAuditPolicyPeriod.BeforeInsert` (line 488)
`:PolicyPeriodEffectiveDate`	Input	bound from `PolicyPeriodEffectiveDate`	—	Bound in `clsAuditPolicyPeriod.BeforeInsert` (line 489)
`:PolicyPeriodExpirationDate`	Input	bound from `PolicyPeriodExpirationDate`	—	Bound in `clsAuditPolicyPeriod.BeforeInsert` (line 479)
`:PayrollSequenceNumber`	Input	bound from `m_PayrollSequenceNumber`	—	Bound in `clsAuditPolicyPeriod.BeforeInsert` (line 481)
`:CancelDate`	Input	bound from `m_CancelDate`	—	Bound in `clsAuditPolicyPeriod.BeforeInsert` (line 480)
`:AfterAuditStdPremAmount`	Input	bound from `m_AfterAuditStdPremAmount`	—	Bound in `clsAuditPolicyPeriod.BeforeInsert` (line 476)
`:BeforeAuditStdPremAmount`	Input	bound from `m_BeforeAuditStdPremAmount`	—	Bound in `clsAuditPolicyPeriod.BeforeInsert` (line 477)
`:WaiverAmount`	Input	bound from `m_WaiverAmount`	—	Bound in `clsAuditPolicyPeriod.BeforeInsert` (line 478)
`:CreateDate`	Input	bound from `CreateDate`	—	Bound in `clsAuditPolicyPeriod.BeforeInsert` (line 482)
`:CreateUser`	Input	bound from `CreateUser`	30	Bound in `clsAuditPolicyPeriod.BeforeInsert` (line 483)
`:UpdateSequenceNumber`	Input	bound from `UpdateSequenceNumber`	—	Bound in `clsAuditPolicyPeriod.BeforeInsert` (line 484)

Tables¶

Table	Access	Columns used
`PA_POLICY_PERIOD`	INSERT	See sample SQL.

Sample SQL¶

INSERT INTO
  PA_POLICY_PERIOD
  (
    PA_AUDIT_SEQ_NUM,
    POLICY_NUM,
    POLICY_PERIOD_EFF_DATE,
    POLICY_PERIOD_EXP_DATE,
    PAYROLL_SEQ_NUM,
    CANCEL_DATE,
    after_audit_std_prem_amount,
    BEFORE_audit_std_prem_amount,
    waiver_amount,
    CREATE_DATE,
    CREATE_USER,
    UPDATE_SEQ_NUM
  )
VALUES
  (
    :AuditSequenceNumber,
    :PolicyNumber,
    :PolicyPeriodEffectiveDate,
    :PolicyPeriodExpirationDate,
    :PayrollSequenceNumber,
    :CancelDate,
    :AfterAuditStdPremAmount,
    :BeforeAuditStdPremAmount,
    :WaiverAmount,
    :CreateDate,
    :CreateUser,
    :UpdateSequenceNumber
  )

Operations and processes¶

Business rules¶

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.Audit.Premium/clsAuditPolicyPeriod.vb:1143