SAIF.Business.Policy.Group database tables

This page catalogs the Oracle tables touched by SAIF.Business.Policy.Group.

Table catalog

Table	Database	Schema/Link	CRUD	Purpose	Primary business object
GROUP_ASSOCIATION	Oracle	[unqualified]**	C, R, U, D	Stores the master group association record and its identifying, classification, plan, address, and endorsement fields.	clsGroupAssociation`, `clsGroupAssociationCollection
GROUP_CHAPTER	Oracle	[unqualified]**	R	Stores effective-dated chapters for a group; compiled code only reads this table.	clsChapter`, `clsChapterCollection
GROUP_ASSOCIATION_CONTACT	Oracle	[unqualified]**	R	Stores the group-level or chapter-level contact details returned by clsContact.	clsContact
GROUP_ASSOCIATION_DETAIL	Oracle	[unqualified]**	C, R, U, D	Stores the effective-dated group discount rows consumed by rating.	clsGroupAssociationDiscount`, `clsGroupAssociationDiscountCollection
GROUP_UNDERWRITING_CRITERIA	Oracle	[unqualified]**	C, R, U, D	Stores underwriting threshold and factor inputs for group eligibility evaluation.	clsGroupUnderwritingCriteria
GROUP_ELIGIBILITY_CTL	Oracle	[unqualified]**	C, R, U, D	Stores the effective-dated include/exclude control row that classifies significant classes.	clsClassSignificance
GROUP_ELIGIBILITY_CLASS	Oracle	[unqualified]**	C, R, U, D	Stores the significant manual classes tied to a group and effective date.	clsSignificantClass`, `clsSignificantClassCollection
POLICY_PERIOD_GROUP_ASSOC	Oracle	[unqualified]**	C, R, U, D	Stores the effective-dated link between a policy period and group membership details.	clsPolicyPeriodGroupAssociation
DUAL	Oracle	[unqualified]**	R	Oracle pseudo-table used by placeholder create-path sequence reads.	all eight classes exposing aCreateSQL``

GROUP_ASSOCIATION

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores the master group association record and its identifying, classification, plan, address, and endorsement fields.
Access pattern	direct SQL through BOF criteria
CRUD operations	Create, Read, Update, Delete
Key columns used	CODE, EFFECTIVE_DATE, EXPIRATION_DATE, GROUP_TYPE_CODE, GROUP_PLAN_CODE, CREATE_DATE, CREATE_USER, UPDATE_DATE, UPDATE_USER
Sequence	CODE_NEXTVAL (placeholder — see anomaly A-1)
Related tables	GROUP_ASSOCIATION_CONTACT, GROUP_ASSOCIATION_DETAIL, GROUP_CHAPTER, GROUP_ELIGIBILITY_CLASS, GROUP_ELIGIBILITY_CTL, GROUP_UNDERWRITING_CRITERIA, POLICY_PERIOD_GROUP_ASSOC
Business objects	clsGroupAssociation`, `clsGroupAssociationCollection

Operations referencing this table

• Retrieve a group association
• Retrieve all group associations
• Persist group associations (insert / update / delete)

Business rules referencing this table

• BR-001: Group association code is required
• BR-002: Group expiration is date-effective
• BR-003: Group type derives from stored code
• BR-004: SalesPlan excludes listed plan codes
• BR-009: Insert must affect exactly one row
• BR-010: Update must affect exactly one row
• BR-011: Delete must affect exactly one row
• BR-012: Collection persistence reports generic failure messages
• BR-021: Writes stamp update date and user

SQL referencing this table

• SQL-010: Insert group association row
• SQL-011: Insert group association row from collection path
• SQL-021: Retrieve group association by code
• SQL-022: Retrieve all group associations
• SQL-030: Update group association row (truncated)
• SQL-031: Update group association row from collection path (truncated)
• SQL-038: Delete group association row (truncated)
• SQL-039: Delete group association row from collection path (truncated)

---

GROUP_CHAPTER

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores effective-dated chapters for a group; compiled code only reads this table.
Access pattern	direct SQL through BOF criteria
CRUD operations	Read
Key columns used	GROUP_ASSOCIATION_CODE, CODE, EFFECTIVE_DATE, EXPIRATION_DATE
Sequence	N/A
Related tables	GROUP_ASSOCIATION, GROUP_ASSOCIATION_CONTACT, POLICY_PERIOD_GROUP_ASSOC
Business objects	clsChapter`, `clsChapterCollection

Operations referencing this table

• Load a group's chapters
• Create and persist a chapter

Business rules referencing this table

• BR-005: Group exposes a placeholder chapter when none exist
• BR-006: Chapter activity is bounded by effective dates
• BR-007: New chapter seeds key values and starts clean
• BR-008: Chapter retrieval is as-of-date effective
• BR-023: Chapters and contacts load lazily

SQL referencing this table

• SQL-017: Retrieve chapter as of a date
• SQL-018: Retrieve chapters for a group

---

GROUP_ASSOCIATION_CONTACT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores the group-level or chapter-level contact details returned by clsContact.
Access pattern	direct SQL through BOF criteria
CRUD operations	Read
Key columns used	GROUP_ASSOCIATION_CODE, GROUP_CHAPTER_CODE, CONTACT_NAME, TITLE_DESCRIPTION, PHONE, FAX, EMAIL_ADDRESS
Sequence	N/A
Related tables	GROUP_ASSOCIATION, GROUP_CHAPTER
Business objects	clsContact

Operations referencing this table

• Retrieve a group contact

Business rules referencing this table

• BR-023: Chapters and contacts load lazily

SQL referencing this table

• SQL-020: Retrieve group or chapter contact

---

GROUP_ASSOCIATION_DETAIL

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores the effective-dated group discount rows consumed by rating.
Access pattern	direct SQL through BOF criteria
CRUD operations	Create, Read, Update, Delete
Key columns used	GROUP_ASSOCIATION_CODE, EFFECTIVE_DATE, EXPIRATION_DATE, PCNT_DISCOUNT, PENDING_FLAG, CREATE_DATE, CREATE_USER, UPDATE_DATE, UPDATE_USER
Sequence	GROUP_ASSOCIATION_CODE_NEXTVAL (placeholder — A-1)
Related tables	GROUP_ASSOCIATION
Business objects	clsGroupAssociationDiscount`, `clsGroupAssociationDiscountCollection

Operations referencing this table

• Supply the group discount factor to rating

Business rules referencing this table

• BR-013: Group discount code is required
• BR-014: Discount factor returns non-applicable when invalid
• BR-015: Pending flag marks a tentative discount
• BR-021: Writes stamp update date and user

SQL referencing this table

• SQL-012: Insert group association discount row
• SQL-023: Retrieve group discount as of a date
• SQL-024: Retrieve all group discounts
• SQL-032: Update group association discount row
• SQL-040: Delete group association discount row

---

GROUP_UNDERWRITING_CRITERIA

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores underwriting threshold and factor inputs for group eligibility evaluation.
Access pattern	direct SQL through BOF criteria
CRUD operations	Create, Read, Update, Delete
Key columns used	GROUP_ASSOCIATION_CODE, EFF_DATE, EXP_DATE, PREMIUM_THRESHOLD_AMOUNT, EXPERIENCE_RATING_FACTOR, EXPERIENCE_RATING_EARNED_FLAG, LOSS_RATIO_FACTOR, NEW_BUSINESS_FREQ_FACTOR, RENEWAL_FREQ_FACTOR, SWING_LIMITED_FLAG, UPDATE_DATE, UPDATE_USER
Sequence	GROUP_ASSOCIATION_CODE_NEXTVAL (placeholder — A-1)
Related tables	GROUP_ASSOCIATION
Business objects	clsGroupUnderwritingCriteria

Operations referencing this table

• Evaluate group underwriting eligibility inputs

Business rules referencing this table

• BR-016: Underwriting flags derive from stored Y/N values
• BR-017: Underwriting criteria requires a group code
• BR-018: Significant class is period-effective
• BR-019: Include/exclude flag drives significance
• BR-020: Significant-class filters follow significance
• BR-021: Writes stamp update date and user

SQL referencing this table

• SQL-013: Insert group underwriting criteria row
• SQL-025: Retrieve underwriting criteria as of a date
• SQL-033: Update group underwriting criteria row (truncated)
• SQL-041: Delete group underwriting criteria row (truncated)

---

GROUP_ELIGIBILITY_CTL

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores the effective-dated include/exclude control row that classifies significant classes.
Access pattern	direct SQL through BOF criteria
CRUD operations	Create, Read, Update, Delete
Key columns used	GROUP_ASSOCIATION_CODE, EFFECTIVE_DATE, EXPIRATION_DATE, INCLUDE_EXCLUDE_FLAG, CREATE_DATE, CREATE_USER, UPDATE_DATE, UPDATE_USER
Sequence	GROUP_ASSOCIATION_CODE_NEXTVAL (placeholder — A-1)
Related tables	GROUP_ASSOCIATION, GROUP_ELIGIBILITY_CLASS
Business objects	clsClassSignificance

Operations referencing this table

• Maintain a group's significant classes

Business rules referencing this table

• BR-009: Insert must affect exactly one row
• BR-010: Update must affect exactly one row
• BR-011: Delete must affect exactly one row
• BR-012: Collection persistence reports generic failure messages
• BR-018: Significant class is period-effective
• BR-019: Include/exclude flag drives significance
• BR-020: Significant-class filters follow significance
• BR-021: Writes stamp update date and user

SQL referencing this table

• SQL-009: Insert group eligibility control row
• SQL-019: Retrieve class-significance control row
• SQL-029: Update group eligibility control row
• SQL-037: Delete group eligibility control row

---

GROUP_ELIGIBILITY_CLASS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores the significant manual classes tied to a group and effective date.
Access pattern	direct SQL through BOF criteria
CRUD operations	Create, Read, Update, Delete
Key columns used	GROUP_ASSOCIATION_CODE, EFFECTIVE_DATE, MANUAL_CLASS_NUMBER, CREATE_DATE, CREATE_USER, UPDATE_DATE, UPDATE_USER
Sequence	GROUP_ASSOCIATION_CODE_NEXTVAL (placeholder — A-1)
Related tables	GROUP_ASSOCIATION, GROUP_ELIGIBILITY_CTL
Business objects	clsSignificantClass`, `clsSignificantClassCollection

Operations referencing this table

• Maintain a group's significant classes

Business rules referencing this table

• BR-009: Insert must affect exactly one row
• BR-010: Update must affect exactly one row
• BR-011: Delete must affect exactly one row
• BR-012: Collection persistence reports generic failure messages
• BR-018: Significant class is period-effective
• BR-019: Include/exclude flag drives significance
• BR-020: Significant-class filters follow significance
• BR-021: Writes stamp update date and user

SQL referencing this table

• SQL-015: Insert significant class row
• SQL-016: Insert significant class row from collection path
• SQL-027: Retrieve significant class row (truncated)
• SQL-028: Retrieve significant classes for a group
• SQL-035: Update significant class row (truncated)
• SQL-036: Update significant class row from collection path
• SQL-043: Delete significant class row (truncated)
• SQL-044: Delete significant class row from collection path

---

POLICY_PERIOD_GROUP_ASSOC

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores the effective-dated link between a policy period and group membership details.
Access pattern	direct SQL through BOF criteria
CRUD operations	Create, Read, Update, Delete
Key columns used	POLICY_NUM, POLICY_PERIOD_EFF_DATE, GROUP_ASSOCIATION_CODE, GROUP_MEMBERSHIP_EFF_DATE, GROUP_MEMBERSHIP_EXP_DATE, GROUP_TERMINATION_DATE, CHAPTER_CODE, GROUP_MEMBERSHIP_TYPE_CODE, UPDATE_DATE, UPDATE_USER
Sequence	POLICY_NUM_NEXTVAL (placeholder — A-1)
Related tables	GROUP_ASSOCIATION, GROUP_CHAPTER
Business objects	clsPolicyPeriodGroupAssociation

Operations referencing this table

• Link a policy period to a group

Business rules referencing this table

• BR-009: Insert must affect exactly one row
• BR-010: Update must affect exactly one row
• BR-011: Delete must affect exactly one row
• BR-021: Writes stamp update date and user
• BR-022: Policy period group membership uses a composite key

SQL referencing this table

• SQL-014: Insert policy-period group association row
• SQL-026: Retrieve policy-period group association
• SQL-034: Update policy-period group association row
• SQL-042: Delete policy-period group association row

---

DUAL

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Oracle pseudo-table used by placeholder create-path sequence reads.
Access pattern	Oracle pseudo-table used by BOF create-path sequence reads
CRUD operations	Read
Key columns used	Placeholder token expression only
Sequence	N/A (pseudo-table used by all sequence reads)
Related tables	N/A
Business objects	all eight classes exposing aCreateSQL``

Operations referencing this table

• Persist group associations (insert / update / delete)
• Supply the group discount factor to rating
• Evaluate group underwriting eligibility inputs
• Maintain a group's significant classes
• Link a policy period to a group

Business rules referencing this table

• BR-001: Group association code is required
• BR-009: Insert must affect exactly one row
• BR-010: Update must affect exactly one row
• BR-011: Delete must affect exactly one row
• BR-012: Collection persistence reports generic failure messages
• BR-013: Group discount code is required
• BR-014: Discount factor returns non-applicable when invalid
• BR-015: Pending flag marks a tentative discount
• BR-016: Underwriting flags derive from stored Y/N values
• BR-017: Underwriting criteria requires a group code
• BR-018: Significant class is period-effective
• BR-019: Include/exclude flag drives significance
• BR-020: Significant-class filters follow significance
• BR-021: Writes stamp update date and user
• BR-022: Policy period group membership uses a composite key

SQL referencing this table

• SQL-001: Fetch significant-class control sequence token
• SQL-002: Fetch group-association sequence token
• SQL-003: Fetch group-association collection sequence token
• SQL-004: Fetch group-discount sequence token
• SQL-005: Fetch underwriting-criteria sequence token
• SQL-006: Fetch policy-period group-association sequence token
• SQL-007: Fetch significant-class sequence token
• SQL-008: Fetch significant-class collection sequence token

---

Table relationship diagram

The following diagram shows inferred relationships between the tables used by this library.

erDiagram
    GROUP_ASSOCIATION ||--o{ GROUP_CHAPTER : "`GROUP_ASSOCIATION.CODE` = `GROUP_CHAPTER.GROUP_ASSOCIATION_CODE`"
    GROUP_ASSOCIATION ||--o{ GROUP_ASSOCIATION_CONTACT : "`GROUP_ASSOCIATION.CODE` = `GROUP_ASSOCIATION_CONTACT.GROUP_ASSOCIATION_CODE`"
    GROUP_CHAPTER ||--o{ GROUP_ASSOCIATION_CONTACT : "`GROUP_CHAPTER.GROUP_ASSOCIATION_CODE` = `GROUP_ASSOCIATION_CONTACT.GROUP_ASSOCIATION_CODE` AND `GROUP_CHAPTER.CODE` = `GROUP_ASSOCIATION_CONTACT.GROUP_CHAPTER_CODE`"
    GROUP_ASSOCIATION ||--o{ GROUP_ASSOCIATION_DETAIL : "`GROUP_ASSOCIATION.CODE` = `GROUP_ASSOCIATION_DETAIL.GROUP_ASSOCIATION_CODE`"
    GROUP_ASSOCIATION ||--o{ GROUP_UNDERWRITING_CRITERIA : "`GROUP_ASSOCIATION.CODE` = `GROUP_UNDERWRITING_CRITERIA.GROUP_ASSOCIATION_CODE`"
    GROUP_ASSOCIATION ||--o{ GROUP_ELIGIBILITY_CTL : "`GROUP_ASSOCIATION.CODE` = `GROUP_ELIGIBILITY_CTL.GROUP_ASSOCIATION_CODE`"
    GROUP_ASSOCIATION ||--o{ GROUP_ELIGIBILITY_CLASS : "`GROUP_ASSOCIATION.CODE` = `GROUP_ELIGIBILITY_CLASS.GROUP_ASSOCIATION_CODE`"
    GROUP_ELIGIBILITY_CTL ||--o{ GROUP_ELIGIBILITY_CLASS : "`GROUP_ELIGIBILITY_CTL.GROUP_ASSOCIATION_CODE` = `GROUP_ELIGIBILITY_CLASS.GROUP_ASSOCIATION_CODE` AND `GROUP_ELIGIBILITY_CTL.EFF_DATE` = `GROUP_ELIGIBILITY_CLASS.EFF_DATE`"
    GROUP_ASSOCIATION ||--o{ POLICY_PERIOD_GROUP_ASSOC : "`GROUP_ASSOCIATION.CODE` = `POLICY_PERIOD_GROUP_ASSOC.GROUP_ASSOCIATION_CODE`"
    GROUP_CHAPTER ||--o{ POLICY_PERIOD_GROUP_ASSOC : "`GROUP_CHAPTER.CODE` = `POLICY_PERIOD_GROUP_ASSOC.CHAPTER_CODE` (within the same group)"

Related documentation

• Index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• SQL catalog
• 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