---
title: "SQL-010: Insert group association row"
summary: Insert group association row
status: draft
owner: Technical Writer
last_reviewed: 2026-07-31
library: SAIF.Business.Policy.Group
reference_type: package
---

# SQL-010: Insert group association row

`SQL-010` insert group association row in support of `clsGroupAssociation`.

## Classification

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

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| N/A | In | String | not specified | Group association code — primary key ([BR-001](../business-rules.md#br-001-group-association-code-is-required): must be non-empty). |
| N/A | In | String | not specified | Group name / code description. |
| N/A | In | String | not specified | Mailing address line 1. |
| N/A | In | String | not specified | Mailing address line 2. |
| N/A | In | String | not specified | Mailing city. |
| N/A | In | String | not specified | Mailing state. |
| N/A | In | String | not specified | 5-digit ZIP. |
| N/A | In | String | not specified | ZIP+4 extension. |
| N/A | In | String | not specified | USPS delivery barcode. |
| N/A | In | String | not specified | Mailing county. |
| N/A | In | String | not specified | Group phone number. |
| N/A | In | String | not specified | Group fax number. |
| N/A | In | Date | not specified | Group effective date. |
| N/A | In | Date | not specified | Group expiration date; null means never expired ([BR-002](../business-rules.md#br-002-group-expiration-is-date-effective)). |
| N/A | In | String | not specified | Stored group type code driving [BR-003](../business-rules.md#br-003-group-type-derives-from-stored-code) classification. |
| N/A | In | String | not specified | Plan code used by the sales-plan filter ([BR-004](../business-rules.md#br-004-salesplan-excludes-listed-plan-codes)). |
| N/A | In | String | not specified | Endorsement code used when adding a member. |
| N/A | In | Date | not specified | Common renewal date for the group. |
| N/A | In | String | not specified | Policy Management System group number. |
| N/A | In | Date | not specified | Audit — row creation timestamp. |
| N/A | In | String | not specified | Audit — creating user. |
| N/A | In | Date | not specified | Audit — last update timestamp ([BR-021](../business-rules.md#br-021-writes-stamp-update-date-and-user)). |
| N/A | In | String | 30 ([BR-021](../business-rules.md#br-021-writes-stamp-update-date-and-user)) | Audit — last updating user. |
| N/A | In | String | not specified | PMS group sub-code. |
| N/A | In | String | not specified | Enrollment form identifier. |
| N/A | In | String | not specified | Endorsement code used on rate change. |
| N/A | In | String | not specified | Short acronym for the group. |
| N/A | In | String | not specified | Y/N — group uses a fixed plan date. |
| N/A | In | String | not specified | Y/N — print at plan. |
| N/A | In | String | not specified | Y/N — auto-renew members. |
| N/A | In | String | not specified | Named group representative. |
| N/A | In | String | not specified | Y/N — financial system participation is mandatory. |
| N/A | In | String | not specified | Y/N — renewal tracking is mandatory. |
| N/A | In | String | not specified | Endorsement code for pending membership. |
| N/A | In | String | not specified | Endorsement code for cancelled membership. |
| N/A | In | String | not specified | Parent group code for hierarchy ([BR-003](../business-rules.md#br-003-group-type-derives-from-stored-code) `PARNT`). |

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [GROUP_ASSOCIATION](../database-tables.md#group_association) | INSERT | CODE, CODE_DESCR, ADDRESS1, ADDRESS2, CITY, STATE, ZIP, ZIP4, USPS_BARCODE, COUNTY, PHONE, FAX, ASSOCIATION_EFF_DATE, ASSOCIATION_EXP_DATE, GROUP_TYPE_CODE, GROUP_PLAN_CODE, ADD_ENDORSE_CODE, GROUP_RENEWAL_DATE |

## Sample SQL

```sql
Insert into GROUP_ASSOCIATION
  (
    CODE,
    CODE_DESCR,
    ADDRESS1,
    ADDRESS2,
    CITY,
    STATE,
    ZIP,
    ZIP4,
    USPS_BARCODE,
    COUNTY,
    PHONE,
    FAX,
    ASSOCIATION_EFF_DATE,
    ASSOCIATION_EXP_DATE,
    GROUP_TYPE_CODE,
    GROUP_PLAN_CODE,
    ADD_ENDORSE_CODE,
    GROUP_RENEWAL_DATE,
    PMS_GROUP_NUMBER,
    CREATE_DATE,
    CREATE_USER,
    UPDATE_DATE,
    UPDATE_USER,
    PMS_GROUP_SUB_CODE,
    GROUP_ENROLL_FORM,
    RATE_CHANGE_ENDORSE_CODE,
    CODE_ACRONYM,
    FIXED_PLAN_DATE_FLAG,
    PRINT_AT_PLAN_FLAG,
    AUTO_RENEWAL_FLAG,
    GROUP_REPRESENTATIVE,
    MANDATORY_FINANCIAL_SYSTEM,
    MANDATORY_RENEWAL_TRACK,
    PENDING_ENDORSE_CODE,
    CANCEL_ENDORSE_CODE,
    PARENT_GROUP
  )
Values
  (
    :Code,
    :Name,
    :Address1,
    :Address2,
    :City,
    :State,
    :Zip,
    :Zip4,
    :USPSBarcode,
    :County,
    :Phone,
    :Fax,
    :AssociationEffectiveDate,
    :AssociationExpirationDate,
    :GroupTypeCode,
    :GroupPlanCode,
    :AddEndorseCode,
    :GroupRenewalDate,
    :PMSGroupNumber,
    :CreateDate,
    :CreateUser,
    :UpdateDate,
    :UpdateUser,
    :PMSGroupSubCode,
    :GroupEnrollForm,
    :RateChangeEndorseCode,
    :CodeAcronym,
    :FixedPlanDateFlag,
    :PrintATPlanFlag,
    :AutoRenewalFlag,
    :GroupRepresentative,
    :MandatoryFinancialSystem,
    :MandatoryRenewalTrack,
    :PendingEndorseCode,
    :CancelEndorseCode,
    :ParentGroup
  )
```

## Operations and processes
- [Persist group associations (insert / update / delete)](../operations/persist-group-associations.md)

> **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\clsGroupAssociation.vb`