SQL-052: Update prepay frequency code row (compiled SQL is incomplete)

This document records the SQL used by clsPrepayFrequencyCodeCollection in SAIF.Business.Policy.Rating.

Classification

Field	Value
SQL ID	SQL-052
Operation type	Update
Execution method	Data portal — criteria SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsPrepayFrequencyCodeCollection
Criteria property	UpdateSQL
Lifecycle method	BeforeUpdate / AfterUpdate

Parameters

Parameter	Direction	Type	Max length	Description
:Code	Input	Not specified	not specified	Bound parameter.
:CodeDescr	Input	Not specified	not specified	Bound parameter.
:EndorseSubcode	Input	Not specified	not specified	Bound parameter.
:CreateDate	Input	Not specified	not specified	Bound parameter.
:CreateUser	Input	Not specified	not specified	Bound parameter.

Tables

Table	Access	Columns used
PREPAY_FREQUENCY_CODE	UPDATE	See sample SQL and source for column usage.

Sample SQL

Update PREPAY_FREQUENCY_CODE
Set
  CODE = :Code,
  CODE_DESCR = :CodeDescr,
  ENDORSE_SUBCODE = :EndorseSubcode,
  CREATE_DATE = :CreateDate,
  CREATE_USER = :CreateUser
Where

[!WARNING] Source text ends at a bare Where clause and is not executable as written.

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.Rating\clsPrepayFrequencyCollection.vb:401-414