SAIF.Business.Policy.Affiliate SQL catalog¶
This page indexes the inline SQL statements used by SAIF.Business.Policy.Affiliate.
Read operations¶
| SQL ID | Description | Type | Tables | Business object |
|---|---|---|---|---|
| SQL-001 | Retrieve one affiliate person record by SSN | Inline | AFFILIATE | clsAffiliate |
| SQL-002 | Retrieve one corporate officer exemption by sequence number | Inline | CORP_OFFICER_EXEMPTION | clsCorporateOfficerExemption |
| SQL-003 | Retrieve corporate officer exemptions for one policy | Inline | CORP_OFFICER_EXEMPTION | clsCorporateOfficerExemptionCollection |
| SQL-004 | Retrieve one interested-party association by policy, affiliate, and effective date | Inline | BUSINESS_AFFILIATE, AFFILIATE | clsInterestedParty |
| SQL-005 | Retrieve interested parties for a policy and date window | Inline | BUSINESS_AFFILIATE, AFFILIATE | clsInterestedPartyCollection |
| SQL-006 | Retrieve one preferred-worker association by policy, affiliate, and effective date | Inline | BUSINESS_AFFILIATE, AFFILIATE | clsPolicyPreferredWorker |
| SQL-007 | Load the earliest preferred-worker eligibility row covering the association dates | Inline | PREFERRED_WORKER | N/A (Application layer) |
| SQL-008 | Retrieve preferred workers for a policy and date window | Inline | BUSINESS_AFFILIATE, AFFILIATE | clsPolicyPreferredWorkerCollection |
Related documentation¶
- Index
- Overview
- Architecture
- Dependencies
- Operations and processes
- Business rules
- Database tables
- API reference
- Configuration
Sources¶
Business\SAIF.Business.Policy.Affiliate\clsAffiliate.vbBusiness\SAIF.Business.Policy.Affiliate\clsCorporateOfficerExemption.vbBusiness\SAIF.Business.Policy.Affiliate\clsCorporateOfficerExemptionCollection.vbBusiness\SAIF.Business.Policy.Affiliate\clsInterestedParty.vbBusiness\SAIF.Business.Policy.Affiliate\clsInterestedPartyCollection.vbBusiness\SAIF.Business.Policy.Affiliate\clsPolicyPreferredWorker.vbBusiness\SAIF.Business.Policy.Affiliate\clsPolicyPreferredWorkerCollection.vb