SQL-035: Update significant class row (truncated)

SQL-035 update significant class row (truncated) in support of clsSignificantClass. The statement text is truncated at a bare Where and is not executable as written.

Classification

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

Parameters

Parameter	Direction	Type	Max length	Description
:GroupAssociationCode	In	String	not specified	Owning group association code.
:EffectiveDate	In	Date	not specified	Effective date of the eligibility class row.
:ManualClassNum	In	String	not specified	NCCI manual class number treated as significant (BR-020).
: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_ELIGIBILITY_CLASS	UPDATE	GROUP_ASSOCIATION_CODE, EFF_DATE, MANUAL_CLASS_NUM, CREATE_DATE, CREATE_USER, UPDATE_DATE, UPDATE_USER

Sample SQL

Update GROUP_ELIGIBILITY_CLASS
Set
  GROUP_ASSOCIATION_CODE = :GroupAssociationCode,
  EFF_DATE = :EffectiveDate,
  MANUAL_CLASS_NUM = :ManualClassNum,
  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

• Maintain a group's significant classes

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\clsSignificantClass.vb