---
title: "SQL-031: Update group association row from collection path (truncated)"
summary: Update group association row from collection path (truncated) — statement is truncated at bare WHERE
status: draft
owner: Technical Writer
last_reviewed: 2026-07-31
library: SAIF.Business.Policy.Group
reference_type: package
---

# SQL-031: Update group association row from collection path (truncated)

`SQL-031` update group association row from collection path (truncated) in support of `clsGroupAssociationCollection`. The statement text is truncated at a bare `Where` and is not executable as written.

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-031 |
| **Operation type** | Update |
| **Execution method** | Inline SQL via BOF data portal |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsGroupAssociationCollection` |
| **Criteria property** | `UpdateSQL` |
| **Lifecycle method** | `BeforeUpdate` (body commented out) / `AfterUpdate` |

## 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) | UPDATE | 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
Update GROUP_ASSOCIATION
Set
  CODE = :Code,
  CODE_DESCR = :CodeDescr,
  ADDRESS1 = :Address1,
  ADDRESS2 = :Address2,
  CITY = :City,
  STATE = :State,
  ZIP = :Zip,
  ZIP4 = :Zip4,
  USPS_BARCODE = :UspsBarcode,
  COUNTY = :County,
  PHONE = :Phone,
  FAX = :Fax,
  ASSOCIATION_EFF_DATE = :AssociationEffDate,
  ASSOCIATION_EXP_DATE = :AssociationExpDate,
  GROUP_TYPE_CODE = :GroupTypeCode,
  GROUP_PLAN_CODE = :GroupPlanCode,
  ADD_ENDORSE_CODE = :AddEndorseCode,
  GROUP_RENEWAL_DATE = :GroupRenewalDate,
  PMS_GROUP_NUMBER = :PmsGroupNumber,
  CREATE_DATE = :CreateDate,
  CREATE_USER = :CreateUser,
  UPDATE_DATE = :UpdateDate,
  UPDATE_USER = :UpdateUser,
  PMS_GROUP_SUB_CODE = :PmsGroupSubCode,
  GROUP_ENROLL_FORM = :GroupEnrollForm,
  RATE_CHANGE_ENDORSE_CODE = :RateChangeEndorseCode,
  CODE_ACRONYM = :CodeAcronym,
  FIXED_PLAN_DATE_FLAG = :FixedPlanDateFlag,
  PRINT_AT_PLAN_FLAG = :PrintATPlanFlag,
  AUTO_RENEWAL_FLAG = :AutoRenewalFlag,
  GROUP_REPRESENTATIVE = :GroupRepresentative,
  MANDATORY_FINANCIAL_SYSTEM = :MandatoryFinancialSystem,
  MANDATORY_RENEWAL_TRACK = :MandatoryRenewalTrack,
  PENDING_ENDORSE_CODE = :PendingEndorseCode,
  CANCEL_ENDORSE_CODE = :CancelEndorseCode,
  PARENT_GROUP = :ParentGroup
Where
-- statement ends here; no predicate follows (anomaly A-2)
```

## 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\clsGroupAssociationCollection.vb`