Skip to content

SQL-009: Insert group eligibility control row

SQL-009 insert group eligibility control row in support of clsClassSignificance.

Classification

Field Value
SQL ID SQL-009
Operation type Insert
Execution method Inline SQL via BOF data portal
Database Oracle
Schema [unqualified]**
Command type Text
Business object clsClassSignificance
Criteria property InsertSQL
Lifecycle method BeforeInsert / AfterInsert

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 INSERT GROUP_ASSOCIATION_CODE, EFF_DATE, EXP_DATE, INCLUDE_EXCLUDE_FLAG, CREATE_DATE, CREATE_USER, UPDATE_DATE, UPDATE_USER

Sample SQL

Insert into GROUP_ELIGIBILITY_CTL
  (
    GROUP_ASSOCIATION_CODE,
    EFF_DATE,
    EXP_DATE,
    INCLUDE_EXCLUDE_FLAG,
    CREATE_DATE,
    CREATE_USER,
    UPDATE_DATE,
    UPDATE_USER
  )
Values
  (
    :GroupAssociationCode,
    :EffectiveDate,
    :ExpirationDate,
    :IncludeExcludeFlag,
    :CreateDate,
    :CreateUser,
    :UpdateDate,
    :UpdateUser
  )

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