SAIF.Business.CustomerContact database tables

This page catalogs Oracle tables accessed by SAIF.Business.CustomerContact.

Table catalog

Table	Database	Schema/Link	CRUD	Purpose	Primary business object
ADDRESS	Oracle	[unqualified]**	CDRU	Stores standalone address records that can be linked to either customers or contacts.	clsAddressInfo, clsContactAddressCollection, clsCustomerAddressCollection
AGENCY	Oracle	[unqualified]**	R	Supplies source agency data used during external-to-local customer conversion.	mdlCustomerContact
AGENT	Oracle	[unqualified]**	R	Supplies source agent data used during external-to-local customer and contact conversion.	mdlCustomerContact
COMPANY	Oracle	[unqualified]**	CDRU	Stores the root customer record created and maintained by this library.	clsContact, clsCustomer, clsCustomerCollection
COMPANY_ADDRESS	Oracle	[unqualified]**	CDR	Associates customer records with standalone address rows.	clsCustomerAddressCollection
COMPANY_ADDRESS_PHONE	Oracle	[unqualified]**	R	Extends customer-address retrieval with address-linked phone data.*	clsCustomerAddressCollection
COMPANY_EMAIL	Oracle	[unqualified]**	CDR	Associates customer records with standalone email-address rows.	clsCustomerEmailCollection
COMPANY_NOTE	Oracle	[unqualified]**	CDRU	Stores long-form notes attached to customer records.	clsCustomerNote
COMPANY_PERSON	Oracle	[unqualified]**	CDRU	Stores customer-to-contact relationship rows.	clsContact, clsContactCollection, clsCustomerCollection, clsCustomerContact, clsCustomerContactCollection
COMPANY_PHONE	Oracle	[unqualified]**	CDR	Associates customer records with standalone phone rows.	clsCustomerPhoneCollection
CUSTOMER_AGENCY	Oracle	[unqualified]**	CR	Stores lookup mappings between agency identifiers and local customer records.	mdlCustomerContact
CUSTOMER_AGENT	Oracle	[unqualified]**	CR	Stores lookup mappings between agent identifiers and local customer/contact records.	mdlCustomerContact
CUSTOMER_AUDITOR	Oracle	[unqualified]**	CR	Stores lookup mappings between auditor identifiers and local customer records.	mdlCustomerContact
CUSTOMER_GROUP	Oracle	[unqualified]**	CR	Stores lookup mappings between group-association identifiers and local customer records.	mdlCustomerContact
CUSTOMER_POLICY	Oracle	[unqualified]**	CR	Stores lookup mappings between policy identifiers and local customer records.	mdlCustomerContact
CUSTOMER_PROVIDER	Oracle	[unqualified]**	CR	Stores lookup mappings between provider identifiers and local customer records.	mdlCustomerContact
CUSTOMER_SOURCE	Oracle	[unqualified]**	CR	Stores lookup mappings between source-system identifiers and local customer records.	mdlCustomerContact
EMAIL_ADDRESS	Oracle	[unqualified]**	CDRU	Stores standalone email-address records that can be linked to either customers or contacts.	clsContactEmailCollection, clsCustomerEmailCollection, clsEmailAddressInfo
GROUP_ASSOCIATION	Oracle	[unqualified]**	R	Supplies source group-association data used during external conversion flows.	mdlCustomerContact
PA_AUDITOR	Oracle	[unqualified]**	R	Supplies source auditor data used during external conversion flows.	mdlCustomerContact
PERSON	Oracle	[unqualified]**	CDRU	Stores the root contact record created and maintained by this library.	clsContact, clsContactCollection, clsCustomerContactCollection
PERSON_ADDRESS	Oracle	[unqualified]**	CDR	Associates contact records with standalone address rows.	clsContactAddressCollection
PERSON_ADDRESS_PHONE	Oracle	[unqualified]**	R	Extends contact-address retrieval with address-linked phone data.*	clsContactAddressCollection
PERSON_EMAIL	Oracle	[unqualified]**	CDR	Associates contact records with standalone email-address rows.	clsContactEmailCollection
PERSON_NOTE	Oracle	[unqualified]**	CDRU	Stores long-form notes attached to contact records.	clsContactNote
PERSON_PHONE	Oracle	[unqualified]**	CDR	Associates contact records with standalone phone rows.	clsContactPhoneCollection
PHONE	Oracle	[unqualified]**	CDRU	Stores standalone phone records that can be linked to either customers or contacts.	clsContactPhoneCollection, clsCustomerPhoneCollection, clsPhoneInfo
POLICY	Oracle	[unqualified]**	R	Supplies source policy data used during external conversion flows.	mdlCustomerContact
PROVIDER	Oracle	[unqualified]**	R	Supplies source provider data used during external conversion flows.	mdlCustomerContact
PROVIDER_TAX_ID	Oracle	[unqualified]**	R	Supplies provider tax-identifier data used while creating provider-based customer records.	mdlCustomerContact
RTW_LOAD_CODE	Oracle	[unqualified]**	R	Supplies return-to-work source data used during external conversion flows.	mdlCustomerContact

---

ADDRESS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores standalone address records that can be linked to either customers or contacts.
Access pattern	BOF criteria SQL
CRUD operations	C/D/R/U
Key columns used	ACTIVE_FLAG, ADDRESS_CODE, ADDRESS_LINE1, ADDRESS_LINE2, ADDRESS_LINE3, ADDRESS_LINE4, ADDRESS_SEQ_NUM, CITY_NAME, COMPANY_SEQ_NUM, COUNTRY_CODE, COUNTY_CODE, CREATE_DATE, CREATE_USER, EFF_DT, EXP_DT, FOREIGN_ADDRESS_FLAG, FOREIGN_POSTAL_CODE, LOCATION_NAME, NOTE_TEXT, PERSON_SEQ_NUM, PRIMARY_FLAG, STATE, UPDATE_DATE, UPDATE_USER, ZIP_CODE, ZIP_CODE_EXT
Sequence	ADDRESS_SEQ
Related tables	COMPANY_ADDRESS, PERSON_ADDRESS
Business objects	clsAddressInfo, clsContactAddressCollection, clsCustomerAddressCollection

Operations referencing this table

• Address info CRUD and linking

Business rules referencing this table

• BR-005: Address records require an ID and address type

SQL referencing this table

• SQL-001: Insert ADDRESS
• SQL-002: Insert ADDRESS
• SQL-026: Read ADDRESS
• SQL-027: Read ADDRESS
• SQL-030: Read ADDRESS
• SQL-036: Read ADDRESS
• SQL-064: Update ADDRESS
• SQL-065: Update ADDRESS
• SQL-075: Delete ADDRESS
• SQL-076: Delete ADDRESS

---

AGENCY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supplies source agency data used during external-to-local customer conversion.
Access pattern	Direct helper SQL
CRUD operations	R
Key columns used	Not enumerated directly in the supplied findings**
Sequence	N/A
Related tables	None identified
Business objects	mdlCustomerContact

Operations referencing this table

• Agency, agent, and provider customer resolution

SQL referencing this table

• SQL-046: Read AGENCY

---

AGENT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supplies source agent data used during external-to-local customer and contact conversion.
Access pattern	Direct helper SQL
CRUD operations	R
Key columns used	Not enumerated directly in the supplied findings**
Sequence	N/A
Related tables	None identified
Business objects	mdlCustomerContact

Operations referencing this table

• Agency, agent, and provider customer resolution

SQL referencing this table

• SQL-048: Read AGENT
• SQL-063: Read AGENT

---

COMPANY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores the root customer record created and maintained by this library.
Access pattern	BOF criteria SQL and direct helper SQL
CRUD operations	C/D/R/U
Key columns used	ACTIVE_FLAG, COMPANY_CODE, COMPANY_NAME, COMPANY_SEQ_NUM, COMPANY_SHORT_DESCR, CONTACT_NAME, EFF_DT, EXP_DT, EXTERNAL_REFERENCE_ID, INTERNAL_REFERENCE_ID, NOTE_TEXT, PERSON_FLAG, PRIMARY_FLAG, TAX_ID, UPDATE_DATE, UPDATE_USER
Sequence	COMPANY_SEQ
Related tables	COMPANY_NOTE, COMPANY_PERSON, CUSTOMER_AGENCY, CUSTOMER_AGENT, CUSTOMER_AUDITOR, CUSTOMER_GROUP, CUSTOMER_POLICY, CUSTOMER_PROVIDER, CUSTOMER_SOURCE
Business objects	clsContact, clsCustomer, clsCustomerCollection

Operations referencing this table

• Customer/contact search
• Customer CRUD with child persistence
• Customer-contact relationship CRUD

Business rules referencing this table

• BR-001: Search requires at least one populated criterion
• BR-002: Search results are capped at 300
• BR-003: Contacts with customer relationships cannot be deleted
• BR-008: Generated agency, agent, and provider records can be forced inactive

SQL referencing this table

• SQL-008: Insert COMPANY
• SQL-028: Read COMPANY
• SQL-035: Read COMPANY
• SQL-037: Read COMPANY
• SQL-068: Update COMPANY
• SQL-082: Delete COMPANY

---

COMPANY_ADDRESS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Associates customer records with standalone address rows.
Access pattern	BOF criteria SQL
CRUD operations	C/D/R
Key columns used	ADDRESS_SEQ_NUM, COMPANY_SEQ_NUM
Sequence	N/A
Related tables	ADDRESS, COMPANY_ADDRESS_PHONE
Business objects	clsCustomerAddressCollection

Operations referencing this table

• Address info CRUD and linking

SQL referencing this table

• SQL-009: Insert COMPANY_ADDRESS
• SQL-036: Read COMPANY_ADDRESS
• SQL-083: Delete COMPANY_ADDRESS

---

COMPANY_ADDRESS_PHONE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Extends customer-address retrieval with address-linked phone data.*
Access pattern	BOF criteria SQL
CRUD operations	R
Key columns used	Not enumerated directly in the supplied findings**
Sequence	N/A
Related tables	COMPANY_ADDRESS
Business objects	clsCustomerAddressCollection

SQL referencing this table

• SQL-036: Read COMPANY_ADDRESS_PHONE

---

COMPANY_EMAIL

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Associates customer records with standalone email-address rows.
Access pattern	BOF criteria SQL
CRUD operations	C/D/R
Key columns used	COMPANY_SEQ_NUM, EMAIL_ADDRESS_SEQ_NUM
Sequence	N/A
Related tables	EMAIL_ADDRESS
Business objects	clsCustomerEmailCollection

Operations referencing this table

• Email info CRUD and linking

SQL referencing this table

• SQL-011: Insert COMPANY_EMAIL
• SQL-039: Read COMPANY_EMAIL
• SQL-085: Delete COMPANY_EMAIL

---

COMPANY_NOTE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores long-form notes attached to customer records.
Access pattern	BOF criteria SQL
CRUD operations	C/D/R/U
Key columns used	COMPANY_SEQ_NUM, NOTE_TEXT
Sequence	N/A
Related tables	COMPANY
Business objects	clsCustomerNote

Operations referencing this table

• Long-note persistence

SQL referencing this table

• SQL-012: Insert COMPANY_NOTE
• SQL-040: Read COMPANY_NOTE
• SQL-070: Update COMPANY_NOTE
• SQL-086: Delete COMPANY_NOTE

---

COMPANY_PERSON

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores customer-to-contact relationship rows.
Access pattern	BOF criteria SQL and direct helper SQL
CRUD operations	C/D/R/U
Key columns used	COMPANY_SEQ_NUM, PERSON_SEQ_NUM, RELATIONSHIP_CODE, TITLE
Sequence	N/A
Related tables	COMPANY, PERSON
Business objects	clsContact, clsContactCollection, clsCustomerCollection, clsCustomerContact, clsCustomerContactCollection

Operations referencing this table

• Customer/contact search
• Customer-contact relationship CRUD

Business rules referencing this table

• BR-001: Search requires at least one populated criterion
• BR-002: Search results are capped at 300
• BR-003: Contacts with customer relationships cannot be deleted
• BR-004: Customer-contact links require a relationship code

SQL referencing this table

• SQL-010: Insert COMPANY_PERSON
• SQL-028: Read COMPANY_PERSON
• SQL-031: Read COMPANY_PERSON
• SQL-037: Read COMPANY_PERSON
• SQL-038: Read COMPANY_PERSON
• SQL-069: Update COMPANY_PERSON
• SQL-084: Delete COMPANY_PERSON

---

COMPANY_PHONE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Associates customer records with standalone phone rows.
Access pattern	BOF criteria SQL
CRUD operations	C/D/R
Key columns used	COMPANY_SEQ_NUM, PHONE_SEQ_NUM
Sequence	N/A
Related tables	PHONE
Business objects	clsCustomerPhoneCollection

Operations referencing this table

• Phone info CRUD and linking

SQL referencing this table

• SQL-013: Insert COMPANY_PHONE
• SQL-041: Read COMPANY_PHONE
• SQL-087: Delete COMPANY_PHONE

---

CUSTOMER_AGENCY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores lookup mappings between agency identifiers and local customer records.
Access pattern	Direct helper SQL
CRUD operations	C/R
Key columns used	AGENCY_SEQ_NUM, COMPANY_SEQ_NUM
Sequence	N/A
Related tables	COMPANY
Business objects	mdlCustomerContact

Operations referencing this table

• Agency, agent, and provider customer resolution

Business rules referencing this table

• BR-008: Generated agency, agent, and provider records can be forced inactive

SQL referencing this table

• SQL-018: Insert CUSTOMER_AGENCY
• SQL-047: Read CUSTOMER_AGENCY

---

CUSTOMER_AGENT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores lookup mappings between agent identifiers and local customer/contact records.
Access pattern	Direct helper SQL
CRUD operations	C/R
Key columns used	AGENT_NUM, COMPANY_SEQ_NUM, PERSON_SEQ_NUM
Sequence	N/A
Related tables	COMPANY, PERSON
Business objects	mdlCustomerContact

Operations referencing this table

• Agency, agent, and provider customer resolution

Business rules referencing this table

• BR-008: Generated agency, agent, and provider records can be forced inactive

SQL referencing this table

• SQL-019: Insert CUSTOMER_AGENT
• SQL-049: Read CUSTOMER_AGENT

---

CUSTOMER_AUDITOR

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores lookup mappings between auditor identifiers and local customer records.
Access pattern	Direct helper SQL
CRUD operations	C/R
Key columns used	AUDITOR_ID, COMPANY_SEQ_NUM
Sequence	N/A
Related tables	COMPANY
Business objects	mdlCustomerContact

Operations referencing this table

• External identifier resolution

SQL referencing this table

• SQL-020: Insert CUSTOMER_AUDITOR
• SQL-050: Read CUSTOMER_AUDITOR

---

CUSTOMER_GROUP

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores lookup mappings between group-association identifiers and local customer records.
Access pattern	Direct helper SQL
CRUD operations	C/R
Key columns used	COMPANY_SEQ_NUM, GROUP_ASSOCIATION_CODE
Sequence	N/A
Related tables	COMPANY
Business objects	mdlCustomerContact

Operations referencing this table

• External identifier resolution

SQL referencing this table

• SQL-021: Insert CUSTOMER_GROUP
• SQL-053: Read CUSTOMER_GROUP

---

CUSTOMER_POLICY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores lookup mappings between policy identifiers and local customer records.
Access pattern	Direct helper SQL
CRUD operations	C/R
Key columns used	COMPANY_SEQ_NUM, POLICY_NUM
Sequence	N/A
Related tables	COMPANY
Business objects	mdlCustomerContact

Operations referencing this table

• External identifier resolution

SQL referencing this table

• SQL-023: Insert CUSTOMER_POLICY
• SQL-057: Read CUSTOMER_POLICY

---

CUSTOMER_PROVIDER

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores lookup mappings between provider identifiers and local customer records.
Access pattern	Direct helper SQL
CRUD operations	C/R
Key columns used	COMPANY_SEQ_NUM, PROVIDER_SEQ_NUM
Sequence	N/A
Related tables	COMPANY
Business objects	mdlCustomerContact

Operations referencing this table

• Agency, agent, and provider customer resolution

Business rules referencing this table

• BR-008: Generated agency, agent, and provider records can be forced inactive

SQL referencing this table

• SQL-024: Insert CUSTOMER_PROVIDER
• SQL-059: Read CUSTOMER_PROVIDER

---

CUSTOMER_SOURCE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores lookup mappings between source-system identifiers and local customer records.
Access pattern	Direct helper SQL
CRUD operations	C/R
Key columns used	COMPANY_CODE, COMPANY_SEQ_NUM, SOURCE_SYSTEM_ID
Sequence	N/A
Related tables	COMPANY
Business objects	mdlCustomerContact

Operations referencing this table

• External identifier resolution

SQL referencing this table

• SQL-022: Insert CUSTOMER_SOURCE
• SQL-025: Insert CUSTOMER_SOURCE
• SQL-054: Read CUSTOMER_SOURCE
• SQL-055: Read CUSTOMER_SOURCE
• SQL-056: Read CUSTOMER_SOURCE
• SQL-062: Read CUSTOMER_SOURCE

---

EMAIL_ADDRESS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores standalone email-address records that can be linked to either customers or contacts.
Access pattern	BOF criteria SQL
CRUD operations	C/D/R/U
Key columns used	ACTIVE_FLAG, EFF_DT, EMAIL_ADDRESS, EMAIL_ADDRESS_SEQ_NUM, EMAIL_CODE, EXP_DT, NOTE_TEXT, PRIMARY_FLAG, UPDATE_DATE, UPDATE_USER, VALIDATED_FLAG
Sequence	EMAIL_ADDRESS_SEQ
Related tables	COMPANY_EMAIL, PERSON_EMAIL
Business objects	clsContactEmailCollection, clsCustomerEmailCollection, clsEmailAddressInfo

Operations referencing this table

• Email info CRUD and linking

Business rules referencing this table

• BR-006: Email validation severity and depth are configurable

SQL referencing this table

• SQL-014: Insert EMAIL_ADDRESS
• SQL-015: Insert EMAIL_ADDRESS
• SQL-032: Read EMAIL_ADDRESS
• SQL-039: Read EMAIL_ADDRESS
• SQL-042: Read EMAIL_ADDRESS
• SQL-043: Read EMAIL_ADDRESS
• SQL-071: Update EMAIL_ADDRESS
• SQL-072: Update EMAIL_ADDRESS
• SQL-088: Delete EMAIL_ADDRESS
• SQL-089: Delete EMAIL_ADDRESS

---

GROUP_ASSOCIATION

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supplies source group-association data used during external conversion flows.
Access pattern	Direct helper SQL
CRUD operations	R
Key columns used	Not enumerated directly in the supplied findings**
Sequence	N/A
Related tables	None identified
Business objects	mdlCustomerContact

Operations referencing this table

• External identifier resolution

SQL referencing this table

• SQL-052: Read GROUP_ASSOCIATION

---

PA_AUDITOR

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supplies source auditor data used during external conversion flows.
Access pattern	Direct helper SQL
CRUD operations	R
Key columns used	Not enumerated directly in the supplied findings**
Sequence	N/A
Related tables	None identified
Business objects	mdlCustomerContact

Operations referencing this table

• External identifier resolution

SQL referencing this table

• SQL-051: Read PA_AUDITOR

---

PERSON

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores the root contact record created and maintained by this library.
Access pattern	BOF criteria SQL
CRUD operations	C/D/R/U
Key columns used	ACTIVE_FLAG, ALIAS_NAME, ANNIVERSARY_DATE, BIRTH_DATE, COMPANY_SEQ_NUM, CREATE_DATE, CREATE_USER, DRIVERS_LICENSE_NUM, DRIVERS_LICENSE_STATE, EFF_DT, ETHNIC_GROUP_CODE, EXP_DT, FIRST_NAME, GENDER_CODE, LAST_NAME, MAIDEN_NAME, MARRIED_NAME, MIDDLE_INITIAL, NAME, NAME_EXTENSION, NICK_NAME, NOTE_TEXT, PERSON_SEQ_NUM, PREFERRED_NAME, PRIMARY_FLAG, RELATIONSHIP_CODE, TAX_ID, TITLE, UPDATE_DATE, UPDATE_USER
Sequence	PERSON_SEQ
Related tables	COMPANY_PERSON, CUSTOMER_AGENT, PERSON_NOTE
Business objects	clsContact, clsContactCollection, clsCustomerContactCollection

Operations referencing this table

• Customer/contact search
• Contact CRUD with child persistence
• Customer-contact relationship CRUD

Business rules referencing this table

• BR-001: Search requires at least one populated criterion
• BR-002: Search results are capped at 300
• BR-003: Contacts with customer relationships cannot be deleted
• BR-008: Generated agency, agent, and provider records can be forced inactive

SQL referencing this table

• SQL-003: Insert PERSON
• SQL-029: Read PERSON
• SQL-031: Read PERSON
• SQL-038: Read PERSON
• SQL-066: Update PERSON
• SQL-077: Delete PERSON

---

PERSON_ADDRESS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Associates contact records with standalone address rows.
Access pattern	BOF criteria SQL
CRUD operations	C/D/R
Key columns used	ADDRESS_SEQ_NUM, PERSON_SEQ_NUM
Sequence	N/A
Related tables	ADDRESS, PERSON_ADDRESS_PHONE
Business objects	clsContactAddressCollection

Operations referencing this table

• Address info CRUD and linking

SQL referencing this table

• SQL-004: Insert PERSON_ADDRESS
• SQL-030: Read PERSON_ADDRESS
• SQL-078: Delete PERSON_ADDRESS

---

PERSON_ADDRESS_PHONE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Extends contact-address retrieval with address-linked phone data.*
Access pattern	BOF criteria SQL
CRUD operations	R
Key columns used	Not enumerated directly in the supplied findings**
Sequence	N/A
Related tables	PERSON_ADDRESS
Business objects	clsContactAddressCollection

SQL referencing this table

• SQL-030: Read PERSON_ADDRESS_PHONE

---

PERSON_EMAIL

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Associates contact records with standalone email-address rows.
Access pattern	BOF criteria SQL
CRUD operations	C/D/R
Key columns used	EMAIL_ADDRESS_SEQ_NUM, PERSON_SEQ_NUM
Sequence	N/A
Related tables	EMAIL_ADDRESS
Business objects	clsContactEmailCollection

Operations referencing this table

• Email info CRUD and linking

SQL referencing this table

• SQL-005: Insert PERSON_EMAIL
• SQL-032: Read PERSON_EMAIL
• SQL-079: Delete PERSON_EMAIL

---

PERSON_NOTE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores long-form notes attached to contact records.
Access pattern	BOF criteria SQL
CRUD operations	C/D/R/U
Key columns used	NOTE_TEXT, PERSON_SEQ_NUM
Sequence	N/A
Related tables	PERSON
Business objects	clsContactNote

Operations referencing this table

• Long-note persistence

SQL referencing this table

• SQL-006: Insert PERSON_NOTE
• SQL-033: Read PERSON_NOTE
• SQL-067: Update PERSON_NOTE
• SQL-080: Delete PERSON_NOTE

---

PERSON_PHONE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Associates contact records with standalone phone rows.
Access pattern	BOF criteria SQL
CRUD operations	C/D/R
Key columns used	PERSON_SEQ_NUM, PHONE_SEQ_NUM
Sequence	N/A
Related tables	PHONE
Business objects	clsContactPhoneCollection

Operations referencing this table

• Phone info CRUD and linking

SQL referencing this table

• SQL-007: Insert PERSON_PHONE
• SQL-034: Read PERSON_PHONE
• SQL-081: Delete PERSON_PHONE

---

PHONE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores standalone phone records that can be linked to either customers or contacts.
Access pattern	BOF criteria SQL
CRUD operations	C/D/R/U
Key columns used	ACTIVE_FLAG, AREA_CODE, COMPANY_SEQ_NUM, COUNTRY_CODE, EFF_DT, EXP_DT, FOREIGN_FLAG, FOREIGN_NUMBER, LONG_DISTANCE_FLAG, NOTE_TEXT, PERSON_SEQ_NUM, PHONE_CODE, PHONE_EXTENSION, PHONE_NUM, PHONE_PREFIX, PHONE_SEQ_NUM, PRIMARY_FLAG, UPDATE_DATE, UPDATE_USER
Sequence	PHONE_SEQ
Related tables	COMPANY_PHONE, PERSON_PHONE
Business objects	clsContactPhoneCollection, clsCustomerPhoneCollection, clsPhoneInfo

Operations referencing this table

• Phone info CRUD and linking

Business rules referencing this table

• BR-007: Phone records require an ID and formatted value

SQL referencing this table

• SQL-016: Insert PHONE
• SQL-017: Insert PHONE
• SQL-034: Read PHONE
• SQL-041: Read PHONE
• SQL-044: Read PHONE
• SQL-045: Read PHONE
• SQL-073: Update PHONE
• SQL-074: Update PHONE
• SQL-090: Delete PHONE
• SQL-091: Delete PHONE

---

POLICY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supplies source policy data used during external conversion flows.
Access pattern	Direct helper SQL
CRUD operations	R
Key columns used	Not enumerated directly in the supplied findings**
Sequence	N/A
Related tables	None identified
Business objects	mdlCustomerContact

Operations referencing this table

• External identifier resolution

SQL referencing this table

• SQL-058: Read POLICY

---

PROVIDER

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supplies source provider data used during external conversion flows.
Access pattern	Direct helper SQL
CRUD operations	R
Key columns used	Not enumerated directly in the supplied findings**
Sequence	N/A
Related tables	PROVIDER_TAX_ID
Business objects	mdlCustomerContact

Operations referencing this table

• Agency, agent, and provider customer resolution

SQL referencing this table

• SQL-060: Read PROVIDER

---

PROVIDER_TAX_ID

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supplies provider tax-identifier data used while creating provider-based customer records.
Access pattern	Direct helper SQL
CRUD operations	R
Key columns used	Not enumerated directly in the supplied findings**
Sequence	N/A
Related tables	PROVIDER
Business objects	mdlCustomerContact

Operations referencing this table

• Agency, agent, and provider customer resolution

SQL referencing this table

• SQL-060: Read PROVIDER_TAX_ID

---

RTW_LOAD_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supplies return-to-work source data used during external conversion flows.
Access pattern	Direct helper SQL
CRUD operations	R
Key columns used	Not enumerated directly in the supplied findings**
Sequence	N/A
Related tables	None identified
Business objects	mdlCustomerContact

Operations referencing this table

• External identifier resolution

SQL referencing this table

• SQL-061: Read RTW_LOAD_CODE

Table relationship diagram

The following diagram shows relationships between tables used by this library.

erDiagram
    COMPANY ||--o{ COMPANY_PERSON : "COMPANY_SEQ_NUM = COMPANY_SEQ_NUM"
    PERSON ||--o{ COMPANY_PERSON : "PERSON_SEQ_NUM = COMPANY_PERSON_SEQ_NUM"
    ADDRESS ||--o{ COMPANY_ADDRESS : "ADDRESS_SEQ_NUM = COMPANY_ADDRESS_SEQ_NUM"
    ADDRESS ||--o{ PERSON_ADDRESS : "ADDRESS_SEQ_NUM = PERSON_ADDRESS_SEQ_NUM"
    EMAIL_ADDRESS ||--o{ COMPANY_EMAIL : "EMAIL_ADDRESS_SEQ_NUM = EMAIL_ADDRESS_SEQ_NUM"
    EMAIL_ADDRESS ||--o{ PERSON_EMAIL : "EMAIL_ADDRESS_SEQ_NUM = EMAIL_ADDRESS_SEQ_NUM"
    PHONE ||--o{ COMPANY_PHONE : "PHONE_SEQ_NUM = COMPANY_PHONE_SEQ_NUM"
    PHONE ||--o{ PERSON_PHONE : "PHONE_SEQ_NUM = PERSON_PHONE_SEQ_NUM"
    COMPANY_ADDRESS ||--|| COMPANY_ADDRESS_PHONE : "COMPANY_SEQ_NUM = COMPANY_SEQ_NUM AND ADDRESS_SEQ_NUM = ADDRESS_SEQ_NUM"
    PERSON_ADDRESS ||--|| PERSON_ADDRESS_PHONE : "PERSON_SEQ_NUM = PERSON_SEQ_NUM AND ADDRESS_SEQ_NUM = ADDRESS_SEQ_NUM"
    PROVIDER ||--o{ PROVIDER_TAX_ID : "PROVIDER_SEQ_NUM = PROVIDER_SEQ_NUM AND PRIMARY_TAX_ID = TAX_ID"
    COMPANY ||--o{ CUSTOMER_AUDITOR : "COMPANY_SEQ_NUM = COMPANY_SEQ_NUM"
    COMPANY ||--o{ CUSTOMER_SOURCE : "COMPANY_SEQ_NUM = COMPANY_SEQ_NUM"
    COMPANY ||--o{ CUSTOMER_GROUP : "COMPANY_SEQ_NUM = COMPANY_SEQ_NUM"
    COMPANY ||--o{ CUSTOMER_POLICY : "COMPANY_SEQ_NUM = COMPANY_SEQ_NUM"
    COMPANY ||--o{ CUSTOMER_AGENCY : "COMPANY_SEQ_NUM = COMPANY_SEQ_NUM"
    COMPANY ||--o{ CUSTOMER_AGENT : "COMPANY_SEQ_NUM = COMPANY_SEQ_NUM"
    PERSON ||--o{ CUSTOMER_AGENT : "PERSON_SEQ_NUM = PERSON_SEQ_NUM"
    COMPANY ||--o{ CUSTOMER_PROVIDER : "COMPANY_SEQ_NUM = COMPANY_SEQ_NUM"
    COMPANY ||--|| COMPANY_NOTE : "COMPANY_SEQ_NUM = COMPANY_SEQ_NUM"
    PERSON ||--|| PERSON_NOTE : "PERSON_SEQ_NUM = PERSON_SEQ_NUM"

Related documentation

• Index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• SQL catalog
• API reference
• Configuration

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.CustomerContact\Contact\clsContactAddressCollection.vb
• Business\SAIF.Business.CustomerContact\Customer\clsCustomerAddressCollection.vb
• Business\SAIF.Business.CustomerContact\InfoItems\clsAddressInfo.vb
• Business\SAIF.Business.CustomerContact\clsAddressInfo.vb
• Business\SAIF.Business.CustomerContact\mdlCustomerContact.vb
• Business\SAIF.Business.CustomerContact\mdlCustomerContact.vb
• Business\SAIF.Business.CustomerContact\Contact\clsContact.vb
• Business\SAIF.Business.CustomerContact\Customer\clsCustomer.vb
• Business\SAIF.Business.CustomerContact\Customer\clsCustomerAddressCollection.vb
• Business\SAIF.Business.CustomerContact\Customer\clsCustomerAddressCollection.vb
• Business\SAIF.Business.CustomerContact\Customer\clsCustomerEmailCollection.vb
• Business\SAIF.Business.CustomerContact\Customer\clsCustomerNote.vb
• Business\SAIF.Business.CustomerContact\Contact\clsContact.vb
• Business\SAIF.Business.CustomerContact\Customer\clsCustomer.vb
• Business\SAIF.Business.CustomerContact\Customer\clsCustomerContact.vb
• Business\SAIF.Business.CustomerContact\Customer\clsCustomerPhoneCollection.vb
• Business\SAIF.Business.CustomerContact\mdlCustomerContact.vb
• Business\SAIF.Business.CustomerContact\mdlCustomerContact.vb
• Business\SAIF.Business.CustomerContact\mdlCustomerContact.vb
• Business\SAIF.Business.CustomerContact\mdlCustomerContact.vb
• Business\SAIF.Business.CustomerContact\mdlCustomerContact.vb
• Business\SAIF.Business.CustomerContact\mdlCustomerContact.vb
• Business\SAIF.Business.CustomerContact\mdlCustomerContact.vb
• Business\SAIF.Business.CustomerContact\Contact\clsContactEmailCollection.vb
• Business\SAIF.Business.CustomerContact\Customer\clsCustomerEmailCollection.vb
• Business\SAIF.Business.CustomerContact\InfoItems\clsEmailAddressInfo.vb
• Business\SAIF.Business.CustomerContact\clsEmailAddressInfo.vb
• Business\SAIF.Business.CustomerContact\mdlCustomerContact.vb
• Business\SAIF.Business.CustomerContact\mdlCustomerContact.vb
• Business\SAIF.Business.CustomerContact\Contact\clsContact.vb
• Business\SAIF.Business.CustomerContact\Customer\clsCustomerContact.vb
• Business\SAIF.Business.CustomerContact\Contact\clsContactAddressCollection.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\Contact\clsContactPhoneCollection.vb
• Business\SAIF.Business.CustomerContact\Customer\clsCustomerPhoneCollection.vb
• Business\SAIF.Business.CustomerContact\InfoItems\clsPhoneInfo.vb
• Business\SAIF.Business.CustomerContact\clsPhoneInfo.vb
• Business\SAIF.Business.CustomerContact\mdlCustomerContact.vb
• Business\SAIF.Business.CustomerContact\mdlCustomerContact.vb
• Business\SAIF.Business.CustomerContact\mdlCustomerContact.vb
• Business\SAIF.Business.CustomerContact\mdlCustomerContact.vb