Skip to content

SQL-036: Update significant class row from collection path

SQL-036 update significant class row from collection path in support of clsSignificantClassCollection.

Classification

Field Value
SQL ID SQL-036
Operation type Update
Execution method Inline SQL via BOF data portal
Database Oracle
Schema [unqualified]**
Command type Text
Business object clsSignificantClassCollection
Criteria property UpdateSQL
Lifecycle method BeforeUpdate (body commented out) / 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 = :ManualClassNumber,
  CREATE_DATE = :CreateDate,
  CREATE_USER = :CreateUser,
  UPDATE_DATE = :UpdateDate,
  UPDATE_USER = :UpdateUser
Where
  GROUP_ELIGIBILITY_CLASS.GROUP_ASSOCIATION_CODE = :GroupAssociationCode
  AND GROUP_ELIGIBILITY_CLASS.EFF_DATE = :EffectiveDate

Operations and processes

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