---
title: "SQL-021: Retrieve group association by code"
summary: Retrieve group association by code
status: draft
owner: Technical Writer
last_reviewed: 2026-07-31
library: SAIF.Business.Policy.Group
reference_type: package
---

# SQL-021: Retrieve group association by code

`SQL-021` retrieve group association by code in support of `clsGroupAssociation`. Earlier analysis described the bind as `:Code`, while source binds `:GroupCode`; the downstream significance of that naming difference is unknown.**

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-021 |
| **Operation type** | Read |
| **Execution method** | Inline SQL via BOF data portal |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsGroupAssociation` |
| **Criteria property** | `RetrieveSQL` (+ const `RETRIEVE_SQL`) |
| **Lifecycle method** | `BeforeRetrieve` / `AfterRetrieve` |

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `:GroupCode` | In | String | not specified | Criteria property `GroupCode` — group primary key (see anomaly A-5). |

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [GROUP_ASSOCIATION](../database-tables.md#group_association) | SELECT | 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
Select
  GROUP_ASSOCIATION.CODE as Code,
  GROUP_ASSOCIATION.CODE_DESCR as Name,
  GROUP_ASSOCIATION.ADDRESS1 as Address1,
  GROUP_ASSOCIATION.ADDRESS2 as Address2,
  GROUP_ASSOCIATION.CITY as City,
  GROUP_ASSOCIATION.STATE as State,
  GROUP_ASSOCIATION.ZIP as Zip,
  GROUP_ASSOCIATION.ZIP4 as Zip4,
  GROUP_ASSOCIATION.USPS_BARCODE as USPSBarcode,
  GROUP_ASSOCIATION.COUNTY as County,
  GROUP_ASSOCIATION.PHONE as Phone,
  GROUP_ASSOCIATION.FAX as Fax,
  GROUP_ASSOCIATION.ASSOCIATION_EFF_DATE as AssociationEffectiveDate,
  GROUP_ASSOCIATION.ASSOCIATION_EXP_DATE as AssociationExpirationDate,
  GROUP_ASSOCIATION.GROUP_TYPE_CODE as GroupTypeCode,
  GROUP_ASSOCIATION.GROUP_PLAN_CODE as GroupPlanCode,
  GROUP_ASSOCIATION.ADD_ENDORSE_CODE as AddEndorseCode,
  GROUP_ASSOCIATION.GROUP_RENEWAL_DATE as GroupRenewalDate,
  GROUP_ASSOCIATION.PMS_GROUP_NUMBER as PMSGroupNumber,
  GROUP_ASSOCIATION.CREATE_DATE as CreateDate,
  GROUP_ASSOCIATION.CREATE_USER as CreateUser,
  GROUP_ASSOCIATION.UPDATE_DATE as UpdateDate,
  GROUP_ASSOCIATION.UPDATE_USER as UpdateUser,
  GROUP_ASSOCIATION.PMS_GROUP_SUB_CODE as PMSGroupSubCode,
  GROUP_ASSOCIATION.GROUP_ENROLL_FORM as GroupEnrollForm,
  GROUP_ASSOCIATION.RATE_CHANGE_ENDORSE_CODE as RateChangeEndorseCode,
  GROUP_ASSOCIATION.CODE_ACRONYM as CodeAcronym,
  GROUP_ASSOCIATION.FIXED_PLAN_DATE_FLAG as FixedPlanDateFlag,
  GROUP_ASSOCIATION.PRINT_AT_PLAN_FLAG as PrintATPlanFlag,
  GROUP_ASSOCIATION.AUTO_RENEWAL_FLAG as AutoRenewalFlag,
  GROUP_ASSOCIATION.GROUP_REPRESENTATIVE as GroupRepresentative,
  GROUP_ASSOCIATION.MANDATORY_FINANCIAL_SYSTEM as MandatoryFinancialSystem,
  GROUP_ASSOCIATION.MANDATORY_RENEWAL_TRACK as MandatoryRenewalTrack,
  GROUP_ASSOCIATION.PENDING_ENDORSE_CODE as PendingEndorseCode,
  GROUP_ASSOCIATION.CANCEL_ENDORSE_CODE as CancelEndorseCode,
  GROUP_ASSOCIATION.PARENT_GROUP as ParentGroup
From
  GROUP_ASSOCIATION
Where
  GROUP_ASSOCIATION.code = :GroupCode
```

## Operations and processes
- [Retrieve a group association](../operations/retrieve-group-association.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`