SQL-026: Retrieve policy-period group association¶

SQL-026 retrieve policy-period group association in support of clsPolicyPeriodGroupAssociation.

Classification¶

Field	Value
SQL ID	SQL-026
Operation type	Read
Execution method	Inline SQL via BOF data portal
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsPolicyPeriodGroupAssociation`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve` / `AfterRetrieve`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:PolicyNumber`	In	Decimal	not specified	Criteria property — policy number.
`:PolicyPeriodEffectiveDate`	In	Date	not specified	Criteria property — policy period effective date.

Tables¶

Table	Access	Columns used
POLICY_PERIOD_GROUP_ASSOC	SELECT	POLICY_NUM, POLICY_PERIOD_EFF_DATE, GROUP_ASSOCIATION_CODE, GROUP_MBRSHP_EFF_DATE, GROUP_MBRSHP_EXP_DATE, GROUP_TERMINATION_DATE, CHAPTER_CODE, CREATE_DATE, CREATE_USER, UPDATE_DATE, UPDATE_USER, GROUP_MEMBERSHIP_TYPE_CODE

Sample SQL¶

Select
  POLICY_PERIOD_GROUP_ASSOC.POLICY_NUM as PolicyNumber,
  POLICY_PERIOD_GROUP_ASSOC.POLICY_PERIOD_EFF_DATE as PolicyPeriodEffectiveDate,
  POLICY_PERIOD_GROUP_ASSOC.GROUP_ASSOCIATION_CODE as GroupAssociationCode,
  POLICY_PERIOD_GROUP_ASSOC.GROUP_MBRSHP_EFF_DATE as GroupMembershipEffectiveDate,
  POLICY_PERIOD_GROUP_ASSOC.GROUP_MBRSHP_EXP_DATE as GroupMembershipExpirationDate,
  POLICY_PERIOD_GROUP_ASSOC.GROUP_TERMINATION_DATE as GroupTerminationDate,
  POLICY_PERIOD_GROUP_ASSOC.CHAPTER_CODE as ChapterCode,
  POLICY_PERIOD_GROUP_ASSOC.CREATE_DATE as CreateDate,
  POLICY_PERIOD_GROUP_ASSOC.CREATE_USER as CreateUser,
  POLICY_PERIOD_GROUP_ASSOC.UPDATE_DATE as UpdateDate,
  POLICY_PERIOD_GROUP_ASSOC.UPDATE_USER as UpdateUser,
  POLICY_PERIOD_GROUP_ASSOC.GROUP_MEMBERSHIP_TYPE_CODE as GroupMembershipTypeCode
From
  POLICY_PERIOD_GROUP_ASSOC
Where
  POLICY_PERIOD_GROUP_ASSOC.POLICY_NUM = :PolicyNumber
  AND POLICY_PERIOD_GROUP_ASSOC.POLICY_PERIOD_EFF_DATE = :PolicyPeriodEffectiveDate

Operations and processes¶

Link a policy period to a group

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\clsPolicyPeriodGroupAssociation.vb