SQL-029: Update group eligibility control row

SQL-029 update group eligibility control row in support of clsClassSignificance.

Classification

Field	Value
SQL ID	SQL-029
Operation type	Update
Execution method	Inline SQL via BOF data portal
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsClassSignificance
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	Start of the class-significance period.
:ExpirationDate	In	Date	not specified	End of the class-significance period; null while open.
:IncludeExcludeFlag	In	String	not specified	I = inclusion; any other value is treated as exclusion (BR-019).
: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_CTL	UPDATE	GROUP_ASSOCIATION_CODE, EFF_DATE, EXP_DATE, INCLUDE_EXCLUDE_FLAG, CREATE_DATE, CREATE_USER, UPDATE_DATE, UPDATE_USER

Sample SQL

Update GROUP_ELIGIBILITY_CTL
Set
  GROUP_ASSOCIATION_CODE = :GroupAssociationCode,
  EFF_DATE = :EffectiveDate,
  EXP_DATE = :ExpirationDate,
  INCLUDE_EXCLUDE_FLAG = :IncludeExcludeFlag,
  CREATE_DATE = :CreateDate,
  CREATE_USER = :CreateUser,
  UPDATE_DATE = :UpdateDate,
  UPDATE_USER = :UpdateUser
Where
  GROUP_ELIGIBILITY_CTL.GROUP_ASSOCIATION_CODE = :GroupAssociationCode
  AND GROUP_ELIGIBILITY_CTL.EFF_DATE = :EffectiveDate

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