SQL-033: Update group underwriting criteria row (truncated)¶

SQL-033 update group underwriting criteria row (truncated) in support of clsGroupUnderwritingCriteria. The statement text is truncated at a bare Where and is not executable as written.

Classification¶

Field	Value
SQL ID	SQL-033
Operation type	Update
Execution method	Inline SQL via BOF data portal
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsGroupUnderwritingCriteria`
Criteria property	`UpdateSQL`
Lifecycle method	`BeforeUpdate` / `AfterUpdate`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:GroupAssociationCode`	In	String	not specified	Owning group code (BR-017: at least one non-blank character).
`:EffDate`	In	Date	not specified	Start of the underwriting-criteria period.
`:ExpDate`	In	Date	not specified	End of the period; null while open.
`:PremiumThresholdAmount`	In	Decimal	not specified	Premium threshold for group eligibility.
`:ExperienceRatingFactor`	In	Decimal	not specified	Experience-rating factor applied to group members.
`:ExperienceRatingEarnedFlag`	In	String	not specified	Flag driving experience-rating-earned status (BR-016).
`:LossRatioFactor`	In	Decimal	not specified	Loss-ratio eligibility factor.
`:NewBusinessFreqFactor`	In	Decimal	not specified	Frequency factor applied to new business.
`:RenewalFreqFactor`	In	Decimal	not specified	Frequency factor applied at renewal.
`:SwingLimitedFlag`	In	String	not specified	Flag driving swing-limited status (BR-016).
`:CreateDate`	In	Date	not specified	Audit — row creation timestamp.
`:CreateUser`	In	String	not specified	Audit — creating user.
`:UpdateDate`	In	Date	not specified	Audit — last update timestamp (BR-021).
`:UpdateUser`	In	String	30 (BR-021)	Audit — last updating user.

Tables¶

Table	Access	Columns used
GROUP_UNDERWRITING_CRITERIA	UPDATE	GROUP_ASSOCIATION_CODE, EFF_DATE, EXP_DATE, PREMIUM_THRESHOLD_AMOUNT, EXPERIENCE_RATING_FACTOR, EXPERIENCE_RATING_EARNED_FLAG, LOSS_RATIO_FACTOR, NEW_BUSINESS_FREQ_FACTOR, RENEWAL_FREQ_FACTOR, SWING_LIMITED_FLAG, CREATE_DATE, CREATE_USER, UPDATE_DATE, UPDATE_USER

Sample SQL¶

Update GROUP_UNDERWRITING_CRITERIA
Set
  GROUP_ASSOCIATION_CODE = :GroupAssociationCode,
  EFF_DATE = :EffDate,
  EXP_DATE = :ExpDate,
  PREMIUM_THRESHOLD_AMOUNT = :PremiumThresholdAmount,
  EXPERIENCE_RATING_FACTOR = :ExperienceRatingFactor,
  EXPERIENCE_RATING_EARNED_FLAG = :ExperienceRatingEarnedFlag,
  LOSS_RATIO_FACTOR = :LossRatioFactor,
  NEW_BUSINESS_FREQ_FACTOR = :NewBusinessFreqFactor,
  RENEWAL_FREQ_FACTOR = :RenewalFreqFactor,
  SWING_LIMITED_FLAG = :SwingLimitedFlag,
  CREATE_DATE = :CreateDate,
  CREATE_USER = :CreateUser,
  UPDATE_DATE = :UpdateDate,
  UPDATE_USER = :UpdateUser
Where
-- statement ends here; no predicate follows (anomaly A-2)

Operations and processes¶

Evaluate group underwriting eligibility inputs

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.Group\clsGroupUnderwritingCriteria.vb