--- title: SAIF.Business.Policy.Group SQL catalog summary: Index of SQL statements used by SAIF.Business.Policy.Group. status: draft owner: Technical Writer last_reviewed: 2026-07-31 library: SAIF.Business.Policy.Group reference_type: package --- # SAIF.Business.Policy.Group SQL catalog This catalog documents the 44 SQL statements extracted from compiled source for `SAIF.Business.Policy.Group`. An earlier analysis reported 41 non-empty SQL properties; the 44-statement extraction remains the authoritative catalog and the discrepancy is left open for reconciliation.** ## Create operations | SQL ID | Description | Type | Tables | Business object | | --- | --- | --- | --- | --- | | [SQL-009](SQL-009-saif-business-policy-group.md) | Insert group eligibility control row | Inline | GROUP_ELIGIBILITY_CTL | `clsClassSignificance` | | [SQL-010](SQL-010-saif-business-policy-group.md) | Insert group association row | Inline | GROUP_ASSOCIATION | `clsGroupAssociation` | | [SQL-011](SQL-011-saif-business-policy-group.md) | Insert group association row from collection path | Inline | GROUP_ASSOCIATION | `clsGroupAssociationCollection` | | [SQL-012](SQL-012-saif-business-policy-group.md) | Insert group association discount row | Inline | GROUP_ASSOCIATION_DETAIL | `clsGroupAssociationDiscount` | | [SQL-013](SQL-013-saif-business-policy-group.md) | Insert group underwriting criteria row | Inline | GROUP_UNDERWRITING_CRITERIA | `clsGroupUnderwritingCriteria` | | [SQL-014](SQL-014-saif-business-policy-group.md) | Insert policy-period group association row | Inline | POLICY_PERIOD_GROUP_ASSOC | `clsPolicyPeriodGroupAssociation` | | [SQL-015](SQL-015-saif-business-policy-group.md) | Insert significant class row | Inline | GROUP_ELIGIBILITY_CLASS | `clsSignificantClass` | | [SQL-016](SQL-016-saif-business-policy-group.md) | Insert significant class row from collection path | Inline | GROUP_ELIGIBILITY_CLASS | `clsSignificantClassCollection` | ## Read operations | SQL ID | Description | Type | Tables | Business object | | --- | --- | --- | --- | --- | | [SQL-017](SQL-017-saif-business-policy-group.md) | Retrieve chapter as of a date | Inline | GROUP_CHAPTER | `clsChapter` | | [SQL-018](SQL-018-saif-business-policy-group.md) | Retrieve chapters for a group | Inline | GROUP_CHAPTER | `clsChapterCollection` | | [SQL-019](SQL-019-saif-business-policy-group.md) | Retrieve class-significance control row | Inline | GROUP_ELIGIBILITY_CTL | `clsClassSignificance` | | [SQL-020](SQL-020-saif-business-policy-group.md) | Retrieve group or chapter contact | Inline | GROUP_ASSOCIATION_CONTACT | `clsContact` | | [SQL-021](SQL-021-saif-business-policy-group.md) | Retrieve group association by code | Inline | GROUP_ASSOCIATION | `clsGroupAssociation` | | [SQL-022](SQL-022-saif-business-policy-group.md) | Retrieve all group associations with no WHERE filter | Inline | GROUP_ASSOCIATION | `clsGroupAssociationCollection` | | [SQL-023](SQL-023-saif-business-policy-group.md) | Retrieve group discount as of a date | Inline | GROUP_ASSOCIATION_DETAIL | `clsGroupAssociationDiscount` | | [SQL-024](SQL-024-saif-business-policy-group.md) | Retrieve all group discounts with no WHERE filter | Inline | GROUP_ASSOCIATION_DETAIL | `clsGroupAssociationDiscountCollection` | | [SQL-025](SQL-025-saif-business-policy-group.md) | Retrieve underwriting criteria as of a date | Inline | GROUP_UNDERWRITING_CRITERIA | `clsGroupUnderwritingCriteria` | | [SQL-026](SQL-026-saif-business-policy-group.md) | Retrieve policy-period group association | Inline | POLICY_PERIOD_GROUP_ASSOC | `clsPolicyPeriodGroupAssociation` | | [SQL-027](SQL-027-saif-business-policy-group.md) | Retrieve significant class row (truncated) — statement is truncated at bare WHERE | Inline | GROUP_ELIGIBILITY_CLASS | `clsSignificantClass` | | [SQL-028](SQL-028-saif-business-policy-group.md) | Retrieve significant classes for a group | Inline | GROUP_ELIGIBILITY_CLASS | `clsSignificantClassCollection` | ## Update operations | SQL ID | Description | Type | Tables | Business object | | --- | --- | --- | --- | --- | | [SQL-029](SQL-029-saif-business-policy-group.md) | Update group eligibility control row | Inline | GROUP_ELIGIBILITY_CTL | `clsClassSignificance` | | [SQL-030](SQL-030-saif-business-policy-group.md) | Update group association row (truncated) — statement is truncated at bare WHERE | Inline | GROUP_ASSOCIATION | `clsGroupAssociation` | | [SQL-031](SQL-031-saif-business-policy-group.md) | Update group association row from collection path (truncated) — statement is truncated at bare WHERE | Inline | GROUP_ASSOCIATION | `clsGroupAssociationCollection` | | [SQL-032](SQL-032-saif-business-policy-group.md) | Update group association discount row | Inline | GROUP_ASSOCIATION_DETAIL | `clsGroupAssociationDiscount` | | [SQL-033](SQL-033-saif-business-policy-group.md) | Update group underwriting criteria row (truncated) — statement is truncated at bare WHERE | Inline | GROUP_UNDERWRITING_CRITERIA | `clsGroupUnderwritingCriteria` | | [SQL-034](SQL-034-saif-business-policy-group.md) | Update policy-period group association row | Inline | POLICY_PERIOD_GROUP_ASSOC | `clsPolicyPeriodGroupAssociation` | | [SQL-035](SQL-035-saif-business-policy-group.md) | Update significant class row (truncated) — statement is truncated at bare WHERE | Inline | GROUP_ELIGIBILITY_CLASS | `clsSignificantClass` | | [SQL-036](SQL-036-saif-business-policy-group.md) | Update significant class row from collection path | Inline | GROUP_ELIGIBILITY_CLASS | `clsSignificantClassCollection` | ## Delete operations | SQL ID | Description | Type | Tables | Business object | | --- | --- | --- | --- | --- | | [SQL-037](SQL-037-saif-business-policy-group.md) | Delete group eligibility control row | Inline | GROUP_ELIGIBILITY_CTL | `clsClassSignificance` | | [SQL-038](SQL-038-saif-business-policy-group.md) | Delete group association row (truncated) — statement is truncated at bare WHERE | Inline | GROUP_ASSOCIATION | `clsGroupAssociation` | | [SQL-039](SQL-039-saif-business-policy-group.md) | Delete group association row from collection path (truncated) — statement is truncated at bare WHERE | Inline | GROUP_ASSOCIATION | `clsGroupAssociationCollection` | | [SQL-040](SQL-040-saif-business-policy-group.md) | Delete group association discount row | Inline | GROUP_ASSOCIATION_DETAIL | `clsGroupAssociationDiscount` | | [SQL-041](SQL-041-saif-business-policy-group.md) | Delete group underwriting criteria row (truncated) — statement is truncated at bare WHERE | Inline | GROUP_UNDERWRITING_CRITERIA | `clsGroupUnderwritingCriteria` | | [SQL-042](SQL-042-saif-business-policy-group.md) | Delete policy-period group association row | Inline | POLICY_PERIOD_GROUP_ASSOC | `clsPolicyPeriodGroupAssociation` | | [SQL-043](SQL-043-saif-business-policy-group.md) | Delete significant class row (truncated) — statement is truncated at bare WHERE | Inline | GROUP_ELIGIBILITY_CLASS | `clsSignificantClass` | | [SQL-044](SQL-044-saif-business-policy-group.md) | Delete significant class row from collection path | Inline | GROUP_ELIGIBILITY_CLASS | `clsSignificantClassCollection` | ## Sequence operations | SQL ID | Description | Sequence | Tables | Business object | | --- | --- | --- | --- | --- | | [SQL-001](SQL-001-saif-business-policy-group.md) | Fetch significant-class control sequence token using a placeholder token | `placeholder token` | DUAL | `clsClassSignificance` | | [SQL-002](SQL-002-saif-business-policy-group.md) | Fetch group-association sequence token using a placeholder token | `placeholder token` | DUAL | `clsGroupAssociation` | | [SQL-003](SQL-003-saif-business-policy-group.md) | Fetch group-association collection sequence token using a placeholder token | `placeholder token` | DUAL | `clsGroupAssociationCollection` | | [SQL-004](SQL-004-saif-business-policy-group.md) | Fetch group-discount sequence token using a placeholder token | `placeholder token` | DUAL | `clsGroupAssociationDiscount` | | [SQL-005](SQL-005-saif-business-policy-group.md) | Fetch underwriting-criteria sequence token using a placeholder token | `placeholder token` | DUAL | `clsGroupUnderwritingCriteria` | | [SQL-006](SQL-006-saif-business-policy-group.md) | Fetch policy-period group-association sequence token using a placeholder token | `placeholder token` | DUAL | `clsPolicyPeriodGroupAssociation` | | [SQL-007](SQL-007-saif-business-policy-group.md) | Fetch significant-class sequence token using a placeholder token | `placeholder token` | DUAL | `clsSignificantClass` | | [SQL-008](SQL-008-saif-business-policy-group.md) | Fetch significant-class collection sequence token using a placeholder token | `placeholder token` | DUAL | `clsSignificantClassCollection` | ## Related documentation - [Index](../index.md) - [Overview](../overview.md) - [Architecture](../architecture.md) - [Dependencies](../dependencies.md) - [Operations and processes](../operations-processes.md) - [Business rules](../business-rules.md) - [Database tables](../database-tables.md) - [API reference](../api/index.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\clsChapter.vb` - `Business\SAIF.Business.Policy.Group\clsChapterCollection.vb` - `Business\SAIF.Business.Policy.Group\clsClassSignificance.vb` - `Business\SAIF.Business.Policy.Group\clsContact.vb` - `Business\SAIF.Business.Policy.Group\clsGroupAssociation.vb` - `Business\SAIF.Business.Policy.Group\clsGroupAssociationCollection.vb` - `Business\SAIF.Business.Policy.Group\clsGroupAssociationDiscount.vb` - `Business\SAIF.Business.Policy.Group\clsGroupAssociationDiscountCollection.vb` - `Business\SAIF.Business.Policy.Group\clsGroupUnderwritingCriteria.vb` - `Business\SAIF.Business.Policy.Group\clsPolicyPeriodGroupAssociation.vb` - `Business\SAIF.Business.Policy.Group\clsSignificantClass.vb` - `Business\SAIF.Business.Policy.Group\clsSignificantClassCollection.vb`