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	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¶

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

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