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	Insert group eligibility control row	Inline	GROUP_ELIGIBILITY_CTL	clsClassSignificance
SQL-010	Insert group association row	Inline	GROUP_ASSOCIATION	clsGroupAssociation
SQL-011	Insert group association row from collection path	Inline	GROUP_ASSOCIATION	clsGroupAssociationCollection
SQL-012	Insert group association discount row	Inline	GROUP_ASSOCIATION_DETAIL	clsGroupAssociationDiscount
SQL-013	Insert group underwriting criteria row	Inline	GROUP_UNDERWRITING_CRITERIA	clsGroupUnderwritingCriteria
SQL-014	Insert policy-period group association row	Inline	POLICY_PERIOD_GROUP_ASSOC	clsPolicyPeriodGroupAssociation
SQL-015	Insert significant class row	Inline	GROUP_ELIGIBILITY_CLASS	clsSignificantClass
SQL-016	Insert significant class row from collection path	Inline	GROUP_ELIGIBILITY_CLASS	clsSignificantClassCollection

Read operations

SQL ID	Description	Type	Tables	Business object
SQL-017	Retrieve chapter as of a date	Inline	GROUP_CHAPTER	clsChapter
SQL-018	Retrieve chapters for a group	Inline	GROUP_CHAPTER	clsChapterCollection
SQL-019	Retrieve class-significance control row	Inline	GROUP_ELIGIBILITY_CTL	clsClassSignificance
SQL-020	Retrieve group or chapter contact	Inline	GROUP_ASSOCIATION_CONTACT	clsContact
SQL-021	Retrieve group association by code	Inline	GROUP_ASSOCIATION	clsGroupAssociation
SQL-022	Retrieve all group associations with no WHERE filter	Inline	GROUP_ASSOCIATION	clsGroupAssociationCollection
SQL-023	Retrieve group discount as of a date	Inline	GROUP_ASSOCIATION_DETAIL	clsGroupAssociationDiscount
SQL-024	Retrieve all group discounts with no WHERE filter	Inline	GROUP_ASSOCIATION_DETAIL	clsGroupAssociationDiscountCollection
SQL-025	Retrieve underwriting criteria as of a date	Inline	GROUP_UNDERWRITING_CRITERIA	clsGroupUnderwritingCriteria
SQL-026	Retrieve policy-period group association	Inline	POLICY_PERIOD_GROUP_ASSOC	clsPolicyPeriodGroupAssociation
SQL-027	Retrieve significant class row (truncated) — statement is truncated at bare WHERE	Inline	GROUP_ELIGIBILITY_CLASS	clsSignificantClass
SQL-028	Retrieve significant classes for a group	Inline	GROUP_ELIGIBILITY_CLASS	clsSignificantClassCollection

Update operations

SQL ID	Description	Type	Tables	Business object
SQL-029	Update group eligibility control row	Inline	GROUP_ELIGIBILITY_CTL	clsClassSignificance
SQL-030	Update group association row (truncated) — statement is truncated at bare WHERE	Inline	GROUP_ASSOCIATION	clsGroupAssociation
SQL-031	Update group association row from collection path (truncated) — statement is truncated at bare WHERE	Inline	GROUP_ASSOCIATION	clsGroupAssociationCollection
SQL-032	Update group association discount row	Inline	GROUP_ASSOCIATION_DETAIL	clsGroupAssociationDiscount
SQL-033	Update group underwriting criteria row (truncated) — statement is truncated at bare WHERE	Inline	GROUP_UNDERWRITING_CRITERIA	clsGroupUnderwritingCriteria
SQL-034	Update policy-period group association row	Inline	POLICY_PERIOD_GROUP_ASSOC	clsPolicyPeriodGroupAssociation
SQL-035	Update significant class row (truncated) — statement is truncated at bare WHERE	Inline	GROUP_ELIGIBILITY_CLASS	clsSignificantClass
SQL-036	Update significant class row from collection path	Inline	GROUP_ELIGIBILITY_CLASS	clsSignificantClassCollection

Delete operations

SQL ID	Description	Type	Tables	Business object
SQL-037	Delete group eligibility control row	Inline	GROUP_ELIGIBILITY_CTL	clsClassSignificance
SQL-038	Delete group association row (truncated) — statement is truncated at bare WHERE	Inline	GROUP_ASSOCIATION	clsGroupAssociation
SQL-039	Delete group association row from collection path (truncated) — statement is truncated at bare WHERE	Inline	GROUP_ASSOCIATION	clsGroupAssociationCollection
SQL-040	Delete group association discount row	Inline	GROUP_ASSOCIATION_DETAIL	clsGroupAssociationDiscount
SQL-041	Delete group underwriting criteria row (truncated) — statement is truncated at bare WHERE	Inline	GROUP_UNDERWRITING_CRITERIA	clsGroupUnderwritingCriteria
SQL-042	Delete policy-period group association row	Inline	POLICY_PERIOD_GROUP_ASSOC	clsPolicyPeriodGroupAssociation
SQL-043	Delete significant class row (truncated) — statement is truncated at bare WHERE	Inline	GROUP_ELIGIBILITY_CLASS	clsSignificantClass
SQL-044	Delete significant class row from collection path	Inline	GROUP_ELIGIBILITY_CLASS	clsSignificantClassCollection

Sequence operations

SQL ID	Description	Sequence	Tables	Business object
SQL-001	Fetch significant-class control sequence token using a placeholder token	placeholder token	DUAL	clsClassSignificance
SQL-002	Fetch group-association sequence token using a placeholder token	placeholder token	DUAL	clsGroupAssociation
SQL-003	Fetch group-association collection sequence token using a placeholder token	placeholder token	DUAL	clsGroupAssociationCollection
SQL-004	Fetch group-discount sequence token using a placeholder token	placeholder token	DUAL	clsGroupAssociationDiscount
SQL-005	Fetch underwriting-criteria sequence token using a placeholder token	placeholder token	DUAL	clsGroupUnderwritingCriteria
SQL-006	Fetch policy-period group-association sequence token using a placeholder token	placeholder token	DUAL	clsPolicyPeriodGroupAssociation
SQL-007	Fetch significant-class sequence token using a placeholder token	placeholder token	DUAL	clsSignificantClass
SQL-008	Fetch significant-class collection sequence token using a placeholder token	placeholder token	DUAL	clsSignificantClassCollection

Related documentation

• Index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• Database tables
• API reference

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