Skip to content

Retrieve a group contact

Loads the contact row for either the group-level contact or the chapter-scoped contact branch exposed by the UNION retrieve SQL.

Field Value
Operation ID OP-006
Trigger
Inputs —
Outputs A populated clsContact.
Primary components clsContact.GetContact
Entry point Business\SAIF.Business.Policy.Group\clsContact.vb

Steps

  1. Build Criteria(dpi, groupAssociationCode, groupChapterCode) and call RetrieveObject.
  2. BeforeRetrieve binds :GroupAssociationCode and :GroupChapterCode.
  3. RetrieveSQL selects contact name, title description, phone, 800 phone, fax and e-mail from GROUP_ASSOCIATION_CONTACT.
  4. AfterRetrieve fills the object and marks it old.
  5. Database statements executed or relied on by this operation: SQL-020; affected tables: GROUP_ASSOCIATION_CONTACT.

Process flow

The following diagram visualizes this operation's control flow.

flowchart TD
    Start([Trigger]) --> Step1[Build criteria / load state]
    Step1 --> Step2[Apply local business logic]
    Step2 --> Decision{Valid and complete?}
    Decision -->|Yes| Step3[Return data or persist rows]
    Decision -->|No| EndErr([Return BOF validation or SQL-state issues])
    Step3 --> EndOk([Operation completes])

Failure and edge-case behavior

  • The retrieve SQL uses a UNION so the group-level contact and chapter-level contact are resolved through a single request.

Sources

  • Business\SAIF.Business.Policy.Group\clsContact.vb