---
title: "SQL-022: Retrieve all group associations"
summary: Retrieve all group associations with no WHERE filter
status: draft
owner: Technical Writer
last_reviewed: 2026-07-31
library: SAIF.Business.Policy.Group
reference_type: package
---

# SQL-022: Retrieve all group associations

`SQL-022` retrieve all group associations in support of `clsGroupAssociationCollection`. The statement contains no `WHERE` clause, so it can perform a full-table scan.

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-022 |
| **Operation type** | Read |
| **Execution method** | Inline SQL via BOF data portal |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsGroupAssociationCollection` |
| **Criteria property** | `RetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` / `AfterRetrieve` |

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| None | N/A | N/A | N/A | This statement has no bind parameters. |

## 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
```

## Operations and processes
- [Retrieve all group associations](../operations/retrieve-all-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\clsGroupAssociationCollection.vb`