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 | Insert ADDRESS for clsAddressInfo |
Inline | ADDRESS | clsAddressInfo |
| SQL-002 | Insert ADDRESS for clsAddressInfo |
Inline | ADDRESS | clsAddressInfo |
| SQL-003 | Insert PERSON for clsContact |
Inline | PERSON | clsContact |
| SQL-004 | Insert PERSON_ADDRESS for clsContactAddressCollection |
Inline | PERSON_ADDRESS | clsContactAddressCollection |
| SQL-005 | Insert PERSON_EMAIL for clsContactEmailCollection |
Inline | PERSON_EMAIL | clsContactEmailCollection |
| SQL-006 | Insert PERSON_NOTE for clsContactNote |
Inline | PERSON_NOTE | clsContactNote |
| SQL-007 | Insert PERSON_PHONE for clsContactPhoneCollection |
Inline | PERSON_PHONE | clsContactPhoneCollection |
| SQL-008 | Insert COMPANY for clsCustomer |
Inline | COMPANY | clsCustomer |
| SQL-009 | Insert COMPANY_ADDRESS for clsCustomerAddressCollection |
Inline | COMPANY_ADDRESS | clsCustomerAddressCollection |
| SQL-010 | Insert COMPANY_PERSON for clsCustomerContact |
Inline | COMPANY_PERSON | clsCustomerContact |
| SQL-011 | Insert COMPANY_EMAIL for clsCustomerEmailCollection |
Inline | COMPANY_EMAIL | clsCustomerEmailCollection |
| SQL-012 | Insert COMPANY_NOTE for clsCustomerNote |
Inline | COMPANY_NOTE | clsCustomerNote |
| SQL-013 | Insert COMPANY_PHONE for clsCustomerPhoneCollection |
Inline | COMPANY_PHONE | clsCustomerPhoneCollection |
| SQL-014 | Insert EMAIL_ADDRESS for clsEmailAddressInfo |
Inline | EMAIL_ADDRESS | clsEmailAddressInfo |
| SQL-015 | Insert EMAIL_ADDRESS for clsEmailAddressInfo |
Inline | EMAIL_ADDRESS | clsEmailAddressInfo |
| SQL-016 | Insert PHONE for clsPhoneInfo |
Inline | PHONE | clsPhoneInfo |
| SQL-017 | Insert PHONE for clsPhoneInfo |
Inline | PHONE | clsPhoneInfo |
| SQL-018 | Insert CUSTOMER_AGENCY for mdlCustomerContact |
Inline via SqlHelper.DataQuery | CUSTOMER_AGENCY | mdlCustomerContact |
| SQL-019 | Insert CUSTOMER_AGENT for mdlCustomerContact |
Inline via SqlHelper.DataQuery | CUSTOMER_AGENT | mdlCustomerContact |
| SQL-020 | Insert CUSTOMER_AUDITOR for mdlCustomerContact |
Inline via SqlHelper.DataQuery | CUSTOMER_AUDITOR | mdlCustomerContact |
| SQL-021 | Insert CUSTOMER_GROUP for mdlCustomerContact |
Inline via SqlHelper.DataQuery | CUSTOMER_GROUP | mdlCustomerContact |
| SQL-022 | Insert CUSTOMER_SOURCE for mdlCustomerContact |
Dynamic inline via SqlHelper.DataQuery | CUSTOMER_SOURCE | mdlCustomerContact |
| SQL-023 | Insert CUSTOMER_POLICY for mdlCustomerContact |
Inline via SqlHelper.DataQuery | CUSTOMER_POLICY | mdlCustomerContact |
| SQL-024 | Insert CUSTOMER_PROVIDER for mdlCustomerContact |
Inline via SqlHelper.DataQuery | CUSTOMER_PROVIDER | mdlCustomerContact |
| SQL-025 | Insert CUSTOMER_SOURCE for mdlCustomerContact |
Inline via SqlHelper.DataQuery | CUSTOMER_SOURCE | mdlCustomerContact |
Read operations¶
| SQL ID | Description | Type | Tables | Business object |
|---|---|---|---|---|
| SQL-026 | Read ADDRESS for clsAddressInfo |
Inline | ADDRESS | clsAddressInfo |
| SQL-027 | Read ADDRESS for clsAddressInfo |
Inline | ADDRESS | clsAddressInfo |
| SQL-028 | Read COMPANY_PERSON, COMPANY for clsContact |
Inline | COMPANY_PERSON, COMPANY | clsContact |
| SQL-029 | Read PERSON for clsContact |
Inline | PERSON | clsContact |
| SQL-030 | Read PERSON_ADDRESS_PHONE, PERSON_ADDRESS, ADDRESS for clsContactAddressCollection |
Inline | PERSON_ADDRESS_PHONE, PERSON_ADDRESS, ADDRESS | clsContactAddressCollection |
| SQL-031 | Read PERSON, COMPANY_PERSON for clsContactCollection |
Dynamic inline | PERSON, COMPANY_PERSON | clsContactCollection |
| SQL-032 | Read PERSON_EMAIL, EMAIL_ADDRESS for clsContactEmailCollection |
Inline | PERSON_EMAIL, EMAIL_ADDRESS | clsContactEmailCollection |
| SQL-033 | Read PERSON_NOTE for clsContactNote |
Inline | PERSON_NOTE | clsContactNote |
| SQL-034 | Read PERSON_PHONE, PHONE for clsContactPhoneCollection |
Inline | PERSON_PHONE, PHONE | clsContactPhoneCollection |
| SQL-035 | Read COMPANY for clsCustomer |
Inline | COMPANY | clsCustomer |
| SQL-036 | Read COMPANY_ADDRESS_PHONE, COMPANY_ADDRESS, ADDRESS for clsCustomerAddressCollection |
Inline | COMPANY_ADDRESS_PHONE, COMPANY_ADDRESS, ADDRESS | clsCustomerAddressCollection |
| SQL-037 | Read COMPANY, COMPANY_PERSON for clsCustomerCollection |
Dynamic inline | COMPANY, COMPANY_PERSON | clsCustomerCollection |
| SQL-038 | Read COMPANY_PERSON, PERSON for clsCustomerContactCollection |
Inline | COMPANY_PERSON, PERSON | clsCustomerContactCollection |
| SQL-039 | Read COMPANY_EMAIL, EMAIL_ADDRESS for clsCustomerEmailCollection |
Inline | COMPANY_EMAIL, EMAIL_ADDRESS | clsCustomerEmailCollection |
| SQL-040 | Read COMPANY_NOTE for clsCustomerNote |
Inline | COMPANY_NOTE | clsCustomerNote |
| SQL-041 | Read COMPANY_PHONE, PHONE for clsCustomerPhoneCollection |
Inline | COMPANY_PHONE, PHONE | clsCustomerPhoneCollection |
| SQL-042 | Read EMAIL_ADDRESS for clsEmailAddressInfo |
Inline | EMAIL_ADDRESS | clsEmailAddressInfo |
| SQL-043 | Read EMAIL_ADDRESS for clsEmailAddressInfo |
Inline | EMAIL_ADDRESS | clsEmailAddressInfo |
| SQL-044 | Read PHONE for clsPhoneInfo |
Inline | PHONE | clsPhoneInfo |
| SQL-045 | Read PHONE for clsPhoneInfo |
Inline | PHONE | clsPhoneInfo |
| SQL-046 | Read AGENCY for mdlCustomerContact |
Inline via SqlHelper.ResultSetQuery | AGENCY | mdlCustomerContact |
| SQL-047 | Read CUSTOMER_AGENCY for mdlCustomerContact |
Inline via SqlHelper.ResultSetQuery | CUSTOMER_AGENCY | mdlCustomerContact |
| SQL-048 | Read AGENT for mdlCustomerContact |
Inline via SqlHelper.ResultSetQuery | AGENT | mdlCustomerContact |
| SQL-049 | Read CUSTOMER_AGENT for mdlCustomerContact |
Inline via SqlHelper.ResultSetQuery | CUSTOMER_AGENT | mdlCustomerContact |
| SQL-050 | Read CUSTOMER_AUDITOR for mdlCustomerContact |
Inline via SqlHelper.ScalarQuery | CUSTOMER_AUDITOR | mdlCustomerContact |
| SQL-051 | Read PA_AUDITOR for mdlCustomerContact |
Inline via SqlHelper.ResultSetQuery | PA_AUDITOR | mdlCustomerContact |
| SQL-052 | Read GROUP_ASSOCIATION for mdlCustomerContact |
Inline via SqlHelper.ResultSetQuery | GROUP_ASSOCIATION | mdlCustomerContact |
| SQL-053 | Read CUSTOMER_GROUP for mdlCustomerContact |
Inline via SqlHelper.ScalarQuery | CUSTOMER_GROUP | mdlCustomerContact |
| SQL-054 | Read CUSTOMER_SOURCE for mdlCustomerContact |
Inline via SqlHelper.ScalarQuery | CUSTOMER_SOURCE | mdlCustomerContact |
| SQL-055 | Read CUSTOMER_SOURCE for mdlCustomerContact |
Dynamic inline via SqlHelper.ScalarQuery | CUSTOMER_SOURCE | mdlCustomerContact |
| SQL-056 | Read CUSTOMER_SOURCE for mdlCustomerContact |
Inline via SqlHelper.ScalarQuery | CUSTOMER_SOURCE | mdlCustomerContact |
| SQL-057 | Read CUSTOMER_POLICY for mdlCustomerContact |
Inline via SqlHelper.ScalarQuery | CUSTOMER_POLICY | mdlCustomerContact |
| SQL-058 | Read POLICY for mdlCustomerContact |
Inline via SqlHelper.ResultSetQuery | POLICY | mdlCustomerContact |
| SQL-059 | Read CUSTOMER_PROVIDER for mdlCustomerContact |
Inline via SqlHelper.ScalarQuery | CUSTOMER_PROVIDER | mdlCustomerContact |
| SQL-060 | Read PROVIDER, PROVIDER_TAX_ID for mdlCustomerContact |
Inline via SqlHelper.ResultSetQuery | PROVIDER, PROVIDER_TAX_ID | mdlCustomerContact |
| SQL-061 | Read RTW_LOAD_CODE for mdlCustomerContact |
Inline via SqlHelper.ResultSetQuery | RTW_LOAD_CODE | mdlCustomerContact |
| SQL-062 | Read CUSTOMER_SOURCE for mdlCustomerContact |
Inline via SqlHelper.ScalarQuery | CUSTOMER_SOURCE | mdlCustomerContact |
| SQL-063 | Read AGENT for mdlCustomerContact |
Inline via SqlHelper.ResultSetQuery | AGENT | mdlCustomerContact |
Update operations¶
| SQL ID | Description | Type | Tables | Business object |
|---|---|---|---|---|
| SQL-064 | Inline update used by clsAddressInfo | Inline | ADDRESS | clsAddressInfo |
| SQL-065 | Inline update used by clsAddressInfo | Inline | ADDRESS | clsAddressInfo |
| SQL-066 | Inline update used by clsContact | Inline | PERSON | clsContact |
| SQL-067 | Inline update used by clsContactNote | Inline | PERSON_NOTE | clsContactNote |
| SQL-068 | Inline update used by clsCustomer | Inline | COMPANY | clsCustomer |
| SQL-069 | Inline update used by clsCustomerContact | Inline | COMPANY_PERSON | clsCustomerContact |
| SQL-070 | Inline update used by clsCustomerNote | Inline | COMPANY_NOTE | clsCustomerNote |
| SQL-071 | Inline update used by clsEmailAddressInfo | Inline | EMAIL_ADDRESS | clsEmailAddressInfo |
| SQL-072 | Inline update used by clsEmailAddressInfo | Inline | EMAIL_ADDRESS | clsEmailAddressInfo |
| SQL-073 | Inline update used by clsPhoneInfo | Inline | PHONE | clsPhoneInfo |
| SQL-074 | Inline update used by clsPhoneInfo | Inline | PHONE | clsPhoneInfo |
Delete operations¶
| SQL ID | Description | Type | Tables | Business object |
|---|---|---|---|---|
| SQL-075 | Inline delete used by clsAddressInfo | Inline | ADDRESS | clsAddressInfo |
| SQL-076 | Inline delete used by clsAddressInfo | Inline | ADDRESS | clsAddressInfo |
| SQL-077 | Inline delete used by clsContact | Inline | PERSON | clsContact |
| SQL-078 | Inline delete used by clsContactAddressCollection | Inline | PERSON_ADDRESS | clsContactAddressCollection |
| SQL-079 | Inline delete used by clsContactEmailCollection | Inline | PERSON_EMAIL | clsContactEmailCollection |
| SQL-080 | Inline delete used by clsContactNote | Inline | PERSON_NOTE | clsContactNote |
| SQL-081 | Inline delete used by clsContactPhoneCollection | Inline | PERSON_PHONE | clsContactPhoneCollection |
| SQL-082 | Inline delete used by clsCustomer | Inline | COMPANY | clsCustomer |
| SQL-083 | Inline delete used by clsCustomerAddressCollection | Inline | COMPANY_ADDRESS | clsCustomerAddressCollection |
| SQL-084 | Inline delete used by clsCustomerContact | Inline | COMPANY_PERSON | clsCustomerContact |
| SQL-085 | Inline delete used by clsCustomerEmailCollection | Inline | COMPANY_EMAIL | clsCustomerEmailCollection |
| SQL-086 | Inline delete used by clsCustomerNote | Inline | COMPANY_NOTE | clsCustomerNote |
| SQL-087 | Inline delete used by clsCustomerPhoneCollection | Inline | COMPANY_PHONE | clsCustomerPhoneCollection |
| SQL-088 | Inline delete used by clsEmailAddressInfo | Inline | EMAIL_ADDRESS | clsEmailAddressInfo |
| SQL-089 | Inline delete used by clsEmailAddressInfo | Inline | EMAIL_ADDRESS | clsEmailAddressInfo |
| SQL-090 | Inline delete used by clsPhoneInfo | Inline | PHONE | clsPhoneInfo |
| SQL-091 | Inline delete used by clsPhoneInfo | Inline | PHONE | clsPhoneInfo |
Related documentation¶
- Index
- Overview
- Architecture
- Dependencies
- Operations and processes
- Business rules
- Database tables
- API reference
- Configuration
Sources¶
Business\SAIF.Business.CustomerContact\Contact\clsContact.vbBusiness\SAIF.Business.CustomerContact\Contact\clsContactAddressCollection.vbBusiness\SAIF.Business.CustomerContact\Contact\clsContactEmailCollection.vbBusiness\SAIF.Business.CustomerContact\Contact\clsContactNote.vbBusiness\SAIF.Business.CustomerContact\Contact\clsContactPhoneCollection.vbBusiness\SAIF.Business.CustomerContact\Customer\clsCustomer.vbBusiness\SAIF.Business.CustomerContact\Customer\clsCustomerAddressCollection.vbBusiness\SAIF.Business.CustomerContact\Customer\clsCustomerContact.vbBusiness\SAIF.Business.CustomerContact\Customer\clsCustomerEmailCollection.vbBusiness\SAIF.Business.CustomerContact\Customer\clsCustomerNote.vbBusiness\SAIF.Business.CustomerContact\Customer\clsCustomerPhoneCollection.vbBusiness\SAIF.Business.CustomerContact\InfoItems\clsAddressInfo.vbBusiness\SAIF.Business.CustomerContact\InfoItems\clsEmailAddressInfo.vbBusiness\SAIF.Business.CustomerContact\InfoItems\clsPhoneInfo.vbBusiness\SAIF.Business.CustomerContact\clsAddressInfo.vbBusiness\SAIF.Business.CustomerContact\clsEmailAddressInfo.vbBusiness\SAIF.Business.CustomerContact\clsPhoneInfo.vbBusiness\SAIF.Business.CustomerContact\mdlCustomerContact.vb