---
title: SAIF.Business.CustomerContact SQL catalog
summary: Index of all SQL statements used by this library, grouped by operation type.
status: draft
owner: SAIF
last_reviewed: 2026-07-24
library: SAIF.Business.CustomerContact
reference_type: package
---

# SAIF.Business.CustomerContact SQL catalog

This page indexes all SQL statements identified for `SAIF.Business.CustomerContact`.

## Insert operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-001](SQL-001.md) | Insert ADDRESS for `clsAddressInfo` | Inline | ADDRESS | `clsAddressInfo` |
| [SQL-002](SQL-002.md) | Insert ADDRESS for `clsAddressInfo` | Inline | ADDRESS | `clsAddressInfo` |
| [SQL-003](SQL-003.md) | Insert PERSON for `clsContact` | Inline | PERSON | `clsContact` |
| [SQL-004](SQL-004.md) | Insert PERSON_ADDRESS for `clsContactAddressCollection` | Inline | PERSON_ADDRESS | `clsContactAddressCollection` |
| [SQL-005](SQL-005.md) | Insert PERSON_EMAIL for `clsContactEmailCollection` | Inline | PERSON_EMAIL | `clsContactEmailCollection` |
| [SQL-006](SQL-006.md) | Insert PERSON_NOTE for `clsContactNote` | Inline | PERSON_NOTE | `clsContactNote` |
| [SQL-007](SQL-007.md) | Insert PERSON_PHONE for `clsContactPhoneCollection` | Inline | PERSON_PHONE | `clsContactPhoneCollection` |
| [SQL-008](SQL-008.md) | Insert COMPANY for `clsCustomer` | Inline | COMPANY | `clsCustomer` |
| [SQL-009](SQL-009.md) | Insert COMPANY_ADDRESS for `clsCustomerAddressCollection` | Inline | COMPANY_ADDRESS | `clsCustomerAddressCollection` |
| [SQL-010](SQL-010.md) | Insert COMPANY_PERSON for `clsCustomerContact` | Inline | COMPANY_PERSON | `clsCustomerContact` |
| [SQL-011](SQL-011.md) | Insert COMPANY_EMAIL for `clsCustomerEmailCollection` | Inline | COMPANY_EMAIL | `clsCustomerEmailCollection` |
| [SQL-012](SQL-012.md) | Insert COMPANY_NOTE for `clsCustomerNote` | Inline | COMPANY_NOTE | `clsCustomerNote` |
| [SQL-013](SQL-013.md) | Insert COMPANY_PHONE for `clsCustomerPhoneCollection` | Inline | COMPANY_PHONE | `clsCustomerPhoneCollection` |
| [SQL-014](SQL-014.md) | Insert EMAIL_ADDRESS for `clsEmailAddressInfo` | Inline | EMAIL_ADDRESS | `clsEmailAddressInfo` |
| [SQL-015](SQL-015.md) | Insert EMAIL_ADDRESS for `clsEmailAddressInfo` | Inline | EMAIL_ADDRESS | `clsEmailAddressInfo` |
| [SQL-016](SQL-016.md) | Insert PHONE for `clsPhoneInfo` | Inline | PHONE | `clsPhoneInfo` |
| [SQL-017](SQL-017.md) | Insert PHONE for `clsPhoneInfo` | Inline | PHONE | `clsPhoneInfo` |
| [SQL-018](SQL-018.md) | Insert CUSTOMER_AGENCY for `mdlCustomerContact` | Inline via SqlHelper.DataQuery | CUSTOMER_AGENCY | `mdlCustomerContact` |
| [SQL-019](SQL-019.md) | Insert CUSTOMER_AGENT for `mdlCustomerContact` | Inline via SqlHelper.DataQuery | CUSTOMER_AGENT | `mdlCustomerContact` |
| [SQL-020](SQL-020.md) | Insert CUSTOMER_AUDITOR for `mdlCustomerContact` | Inline via SqlHelper.DataQuery | CUSTOMER_AUDITOR | `mdlCustomerContact` |
| [SQL-021](SQL-021.md) | Insert CUSTOMER_GROUP for `mdlCustomerContact` | Inline via SqlHelper.DataQuery | CUSTOMER_GROUP | `mdlCustomerContact` |
| [SQL-022](SQL-022.md) | Insert CUSTOMER_SOURCE for `mdlCustomerContact` | Dynamic inline via SqlHelper.DataQuery | CUSTOMER_SOURCE | `mdlCustomerContact` |
| [SQL-023](SQL-023.md) | Insert CUSTOMER_POLICY for `mdlCustomerContact` | Inline via SqlHelper.DataQuery | CUSTOMER_POLICY | `mdlCustomerContact` |
| [SQL-024](SQL-024.md) | Insert CUSTOMER_PROVIDER for `mdlCustomerContact` | Inline via SqlHelper.DataQuery | CUSTOMER_PROVIDER | `mdlCustomerContact` |
| [SQL-025](SQL-025.md) | Insert CUSTOMER_SOURCE for `mdlCustomerContact` | Inline via SqlHelper.DataQuery | CUSTOMER_SOURCE | `mdlCustomerContact` |

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-026](SQL-026.md) | Read ADDRESS for `clsAddressInfo` | Inline | ADDRESS | `clsAddressInfo` |
| [SQL-027](SQL-027.md) | Read ADDRESS for `clsAddressInfo` | Inline | ADDRESS | `clsAddressInfo` |
| [SQL-028](SQL-028.md) | Read COMPANY_PERSON, COMPANY for `clsContact` | Inline | COMPANY_PERSON, COMPANY | `clsContact` |
| [SQL-029](SQL-029.md) | Read PERSON for `clsContact` | Inline | PERSON | `clsContact` |
| [SQL-030](SQL-030.md) | Read PERSON_ADDRESS_PHONE, PERSON_ADDRESS, ADDRESS for `clsContactAddressCollection` | Inline | PERSON_ADDRESS_PHONE, PERSON_ADDRESS, ADDRESS | `clsContactAddressCollection` |
| [SQL-031](SQL-031.md) | Read PERSON, COMPANY_PERSON for `clsContactCollection` | Dynamic inline | PERSON, COMPANY_PERSON | `clsContactCollection` |
| [SQL-032](SQL-032.md) | Read PERSON_EMAIL, EMAIL_ADDRESS for `clsContactEmailCollection` | Inline | PERSON_EMAIL, EMAIL_ADDRESS | `clsContactEmailCollection` |
| [SQL-033](SQL-033.md) | Read PERSON_NOTE for `clsContactNote` | Inline | PERSON_NOTE | `clsContactNote` |
| [SQL-034](SQL-034.md) | Read PERSON_PHONE, PHONE for `clsContactPhoneCollection` | Inline | PERSON_PHONE, PHONE | `clsContactPhoneCollection` |
| [SQL-035](SQL-035.md) | Read COMPANY for `clsCustomer` | Inline | COMPANY | `clsCustomer` |
| [SQL-036](SQL-036.md) | Read COMPANY_ADDRESS_PHONE, COMPANY_ADDRESS, ADDRESS for `clsCustomerAddressCollection` | Inline | COMPANY_ADDRESS_PHONE, COMPANY_ADDRESS, ADDRESS | `clsCustomerAddressCollection` |
| [SQL-037](SQL-037.md) | Read COMPANY, COMPANY_PERSON for `clsCustomerCollection` | Dynamic inline | COMPANY, COMPANY_PERSON | `clsCustomerCollection` |
| [SQL-038](SQL-038.md) | Read COMPANY_PERSON, PERSON for `clsCustomerContactCollection` | Inline | COMPANY_PERSON, PERSON | `clsCustomerContactCollection` |
| [SQL-039](SQL-039.md) | Read COMPANY_EMAIL, EMAIL_ADDRESS for `clsCustomerEmailCollection` | Inline | COMPANY_EMAIL, EMAIL_ADDRESS | `clsCustomerEmailCollection` |
| [SQL-040](SQL-040.md) | Read COMPANY_NOTE for `clsCustomerNote` | Inline | COMPANY_NOTE | `clsCustomerNote` |
| [SQL-041](SQL-041.md) | Read COMPANY_PHONE, PHONE for `clsCustomerPhoneCollection` | Inline | COMPANY_PHONE, PHONE | `clsCustomerPhoneCollection` |
| [SQL-042](SQL-042.md) | Read EMAIL_ADDRESS for `clsEmailAddressInfo` | Inline | EMAIL_ADDRESS | `clsEmailAddressInfo` |
| [SQL-043](SQL-043.md) | Read EMAIL_ADDRESS for `clsEmailAddressInfo` | Inline | EMAIL_ADDRESS | `clsEmailAddressInfo` |
| [SQL-044](SQL-044.md) | Read PHONE for `clsPhoneInfo` | Inline | PHONE | `clsPhoneInfo` |
| [SQL-045](SQL-045.md) | Read PHONE for `clsPhoneInfo` | Inline | PHONE | `clsPhoneInfo` |
| [SQL-046](SQL-046.md) | Read AGENCY for `mdlCustomerContact` | Inline via SqlHelper.ResultSetQuery | AGENCY | `mdlCustomerContact` |
| [SQL-047](SQL-047.md) | Read CUSTOMER_AGENCY for `mdlCustomerContact` | Inline via SqlHelper.ResultSetQuery | CUSTOMER_AGENCY | `mdlCustomerContact` |
| [SQL-048](SQL-048.md) | Read AGENT for `mdlCustomerContact` | Inline via SqlHelper.ResultSetQuery | AGENT | `mdlCustomerContact` |
| [SQL-049](SQL-049.md) | Read CUSTOMER_AGENT for `mdlCustomerContact` | Inline via SqlHelper.ResultSetQuery | CUSTOMER_AGENT | `mdlCustomerContact` |
| [SQL-050](SQL-050.md) | Read CUSTOMER_AUDITOR for `mdlCustomerContact` | Inline via SqlHelper.ScalarQuery | CUSTOMER_AUDITOR | `mdlCustomerContact` |
| [SQL-051](SQL-051.md) | Read PA_AUDITOR for `mdlCustomerContact` | Inline via SqlHelper.ResultSetQuery | PA_AUDITOR | `mdlCustomerContact` |
| [SQL-052](SQL-052.md) | Read GROUP_ASSOCIATION for `mdlCustomerContact` | Inline via SqlHelper.ResultSetQuery | GROUP_ASSOCIATION | `mdlCustomerContact` |
| [SQL-053](SQL-053.md) | Read CUSTOMER_GROUP for `mdlCustomerContact` | Inline via SqlHelper.ScalarQuery | CUSTOMER_GROUP | `mdlCustomerContact` |
| [SQL-054](SQL-054.md) | Read CUSTOMER_SOURCE for `mdlCustomerContact` | Inline via SqlHelper.ScalarQuery | CUSTOMER_SOURCE | `mdlCustomerContact` |
| [SQL-055](SQL-055.md) | Read CUSTOMER_SOURCE for `mdlCustomerContact` | Dynamic inline via SqlHelper.ScalarQuery | CUSTOMER_SOURCE | `mdlCustomerContact` |
| [SQL-056](SQL-056.md) | Read CUSTOMER_SOURCE for `mdlCustomerContact` | Inline via SqlHelper.ScalarQuery | CUSTOMER_SOURCE | `mdlCustomerContact` |
| [SQL-057](SQL-057.md) | Read CUSTOMER_POLICY for `mdlCustomerContact` | Inline via SqlHelper.ScalarQuery | CUSTOMER_POLICY | `mdlCustomerContact` |
| [SQL-058](SQL-058.md) | Read POLICY for `mdlCustomerContact` | Inline via SqlHelper.ResultSetQuery | POLICY | `mdlCustomerContact` |
| [SQL-059](SQL-059.md) | Read CUSTOMER_PROVIDER for `mdlCustomerContact` | Inline via SqlHelper.ScalarQuery | CUSTOMER_PROVIDER | `mdlCustomerContact` |
| [SQL-060](SQL-060.md) | Read PROVIDER, PROVIDER_TAX_ID for `mdlCustomerContact` | Inline via SqlHelper.ResultSetQuery | PROVIDER, PROVIDER_TAX_ID | `mdlCustomerContact` |
| [SQL-061](SQL-061.md) | Read RTW_LOAD_CODE for `mdlCustomerContact` | Inline via SqlHelper.ResultSetQuery | RTW_LOAD_CODE | `mdlCustomerContact` |
| [SQL-062](SQL-062.md) | Read CUSTOMER_SOURCE for `mdlCustomerContact` | Inline via SqlHelper.ScalarQuery | CUSTOMER_SOURCE | `mdlCustomerContact` |
| [SQL-063](SQL-063.md) | Read AGENT for `mdlCustomerContact` | Inline via SqlHelper.ResultSetQuery | AGENT | `mdlCustomerContact` |

## Update operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-064](SQL-064.md) | Inline update used by clsAddressInfo | Inline | ADDRESS | `clsAddressInfo` |
| [SQL-065](SQL-065.md) | Inline update used by clsAddressInfo | Inline | ADDRESS | `clsAddressInfo` |
| [SQL-066](SQL-066.md) | Inline update used by clsContact | Inline | PERSON | `clsContact` |
| [SQL-067](SQL-067.md) | Inline update used by clsContactNote | Inline | PERSON_NOTE | `clsContactNote` |
| [SQL-068](SQL-068.md) | Inline update used by clsCustomer | Inline | COMPANY | `clsCustomer` |
| [SQL-069](SQL-069.md) | Inline update used by clsCustomerContact | Inline | COMPANY_PERSON | `clsCustomerContact` |
| [SQL-070](SQL-070.md) | Inline update used by clsCustomerNote | Inline | COMPANY_NOTE | `clsCustomerNote` |
| [SQL-071](SQL-071.md) | Inline update used by clsEmailAddressInfo | Inline | EMAIL_ADDRESS | `clsEmailAddressInfo` |
| [SQL-072](SQL-072.md) | Inline update used by clsEmailAddressInfo | Inline | EMAIL_ADDRESS | `clsEmailAddressInfo` |
| [SQL-073](SQL-073.md) | Inline update used by clsPhoneInfo | Inline | PHONE | `clsPhoneInfo` |
| [SQL-074](SQL-074.md) | Inline update used by clsPhoneInfo | Inline | PHONE | `clsPhoneInfo` |

## Delete operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-075](SQL-075.md) | Inline delete used by clsAddressInfo | Inline | ADDRESS | `clsAddressInfo` |
| [SQL-076](SQL-076.md) | Inline delete used by clsAddressInfo | Inline | ADDRESS | `clsAddressInfo` |
| [SQL-077](SQL-077.md) | Inline delete used by clsContact | Inline | PERSON | `clsContact` |
| [SQL-078](SQL-078.md) | Inline delete used by clsContactAddressCollection | Inline | PERSON_ADDRESS | `clsContactAddressCollection` |
| [SQL-079](SQL-079.md) | Inline delete used by clsContactEmailCollection | Inline | PERSON_EMAIL | `clsContactEmailCollection` |
| [SQL-080](SQL-080.md) | Inline delete used by clsContactNote | Inline | PERSON_NOTE | `clsContactNote` |
| [SQL-081](SQL-081.md) | Inline delete used by clsContactPhoneCollection | Inline | PERSON_PHONE | `clsContactPhoneCollection` |
| [SQL-082](SQL-082.md) | Inline delete used by clsCustomer | Inline | COMPANY | `clsCustomer` |
| [SQL-083](SQL-083.md) | Inline delete used by clsCustomerAddressCollection | Inline | COMPANY_ADDRESS | `clsCustomerAddressCollection` |
| [SQL-084](SQL-084.md) | Inline delete used by clsCustomerContact | Inline | COMPANY_PERSON | `clsCustomerContact` |
| [SQL-085](SQL-085.md) | Inline delete used by clsCustomerEmailCollection | Inline | COMPANY_EMAIL | `clsCustomerEmailCollection` |
| [SQL-086](SQL-086.md) | Inline delete used by clsCustomerNote | Inline | COMPANY_NOTE | `clsCustomerNote` |
| [SQL-087](SQL-087.md) | Inline delete used by clsCustomerPhoneCollection | Inline | COMPANY_PHONE | `clsCustomerPhoneCollection` |
| [SQL-088](SQL-088.md) | Inline delete used by clsEmailAddressInfo | Inline | EMAIL_ADDRESS | `clsEmailAddressInfo` |
| [SQL-089](SQL-089.md) | Inline delete used by clsEmailAddressInfo | Inline | EMAIL_ADDRESS | `clsEmailAddressInfo` |
| [SQL-090](SQL-090.md) | Inline delete used by clsPhoneInfo | Inline | PHONE | `clsPhoneInfo` |
| [SQL-091](SQL-091.md) | Inline delete used by clsPhoneInfo | Inline | PHONE | `clsPhoneInfo` |

## Related documentation
- [Index](../index.md)
- [Overview](../overview.md)
- [Architecture](../architecture.md)
- [Dependencies](../dependencies.md)
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- [Database tables](../database-tables.md)
- [API reference](../api/index.md)
- [Configuration](../configuration.md)

## Sources
- `Business\SAIF.Business.CustomerContact\Contact\clsContact.vb`
- `Business\SAIF.Business.CustomerContact\Contact\clsContactAddressCollection.vb`
- `Business\SAIF.Business.CustomerContact\Contact\clsContactEmailCollection.vb`
- `Business\SAIF.Business.CustomerContact\Contact\clsContactNote.vb`
- `Business\SAIF.Business.CustomerContact\Contact\clsContactPhoneCollection.vb`
- `Business\SAIF.Business.CustomerContact\Customer\clsCustomer.vb`
- `Business\SAIF.Business.CustomerContact\Customer\clsCustomerAddressCollection.vb`
- `Business\SAIF.Business.CustomerContact\Customer\clsCustomerContact.vb`
- `Business\SAIF.Business.CustomerContact\Customer\clsCustomerEmailCollection.vb`
- `Business\SAIF.Business.CustomerContact\Customer\clsCustomerNote.vb`
- `Business\SAIF.Business.CustomerContact\Customer\clsCustomerPhoneCollection.vb`
- `Business\SAIF.Business.CustomerContact\InfoItems\clsAddressInfo.vb`
- `Business\SAIF.Business.CustomerContact\InfoItems\clsEmailAddressInfo.vb`
- `Business\SAIF.Business.CustomerContact\InfoItems\clsPhoneInfo.vb`
- `Business\SAIF.Business.CustomerContact\clsAddressInfo.vb`
- `Business\SAIF.Business.CustomerContact\clsEmailAddressInfo.vb`
- `Business\SAIF.Business.CustomerContact\clsPhoneInfo.vb`
- `Business\SAIF.Business.CustomerContact\mdlCustomerContact.vb`