---
title: SAIF.Business database tables
summary: Database tables used by this library with relationships and usage context.
status: draft
owner: SAIF
last_reviewed: 2026-07-24
library: SAIF.Business
reference_type: package
---

# SAIF.Business database tables

This page catalogs Oracle tables, views, and grouped lookup tables accessed by `SAIF.Business`.

## Table catalog

| Table | Database | Schema/Link | CRUD | Purpose | Primary business object |
| --- | --- | --- | --- | --- | --- |
| [ADP_EMPLOYEE](#adp-employee) | Oracle | [unqualified]** | R | Used by clsEmployeeData, clsEmployeeDataCollection. | `clsEmployeeData`, `clsEmployeeDataCollection` |
| [ADP_EMPLOYEE_PHONE_VIEW](#adp-employee-phone-view) | Oracle | [unqualified]** | R | Used by clsEmployeeData. | `clsEmployeeData` |
| [ADP_VIRTUAL_EMPLOYEE_VIEW](#adp-virtual-employee-view) | Oracle | [unqualified]** | R | Used by ClaimServices. | `ClaimServices` |
| [ALL_STATES](#all-states) | Oracle | [unqualified]** | R | Used by clsAddress, ObjectServices. | `clsAddress`, `ObjectServices` |
| [APPLICATION_HELP_DETAIL](#application-help-detail) | Oracle | [unqualified]** | R | Used by clsHelpText, clsHelpTextCollection. | `clsHelpText`, `clsHelpTextCollection` |
| [APPLICATION_HELP_MASTER](#application-help-master) | Oracle | [unqualified]** | R | Used by clsHelpTextCollection. | `clsHelpTextCollection` |
| [COUNTRY](#country) | Oracle | [unqualified]** | R | Used by clsAddress, clsAddressStructure. | `clsAddress`, `clsAddressStructure` |
| [EMPLOYEE_LEAVE](#employee-leave) | Oracle | [unqualified]** | C/R/U/D | Used by clsEmployeeLeave, clsEmployeeLeaveCollection. | `clsEmployeeLeave`, `clsEmployeeLeaveCollection` |
| [EXT_USER / EXT_USER_TYPE](#ext-user-ext-user-type) | Oracle | [unqualified]** | R | Used by ExternalUserServices. | `ExternalUserServices` |
| [IMAGE / IMGSYS](#image-imgsys) | Oracle | [unqualified]** | R | Used by ImageInfo. | `ImageInfo` |
| [LANGUAGE_TRANSLATION](#language-translation) | Oracle | [unqualified]** | R | Used by clsLanguageTranslation, clsLanguageTranslationCollection. | `clsLanguageTranslation`, `clsLanguageTranslationCollection` |
| [LOCATION](#location) | Oracle | [unqualified]** | R | Used by clsSAIFOutputAddress. | `clsSAIFOutputAddress` |
| [MCO_PLAN / MCO_GSA_LOCATION](#mco-plan-mco-gsa-location) | Oracle | [unqualified]** | R | Used by MCOInfo. | `MCOInfo` |
| [POLICY / POLICY_PERIOD_ALL / POLICY_PERIOD_MASTER / US_POLICY_UNIT](#policy-policy-period-all-policy-period-master-us-policy-unit) | Oracle | [unqualified]** | R | Used by PolicyServices, UnitStatServices. | `PolicyServices`, `UnitStatServices` |
| [RECORDING](#recording) | Oracle | [unqualified]** | R | Used by ImageServices. | `ImageServices` |
| [PDF_CONVERSION_ERROR](#pdf-conversion-error) | Oracle | [unqualified]** | C | Used by ImageServices. | `ImageServices` |
| [ZIP_CODE / ZIP_MCO_COUNTY](#zip-code-zip-mco-county) | Oracle | [unqualified]** | R | Used by clsAddress, clsAddressStructure. | `clsAddress`, `clsAddressStructure` |
| [CL_INJURY_CLAIM / CL_CLAIM_RESPONSIBILITY](#cl-injury-claim-cl-claim-responsibility) | Oracle | [unqualified]** | R | Used by ClaimServices. | `ClaimServices` |
| [CL_FINANCIAL_TRANS / CL_FINANCIAL_TRANS_DTL](#cl-financial-trans-cl-financial-trans-dtl) | Oracle | [unqualified]** | R | Used by ClaimServices. | `ClaimServices` |
| [CL_INCURRED_COST_HISTORY / CL_INCURRED_CATEGORY_COST](#cl-incurred-cost-history-cl-incurred-category-cost) | Oracle | [unqualified]** | R | Used by ClaimServices. | `ClaimServices` |
| [CL_SECURITY_OVERRIDE](#cl-security-override) | Oracle | [unqualified]** | R | Used by ClaimServices. | `ClaimServices` |
| [LEGAL_CASE / LEGAL_COLLECTION / INVESTIGATION / CL_CLAIM_SUPPORT_ORDER_CONN](#legal-case-legal-collection-investigation-cl-claim-support-order-conn) | Oracle | [unqualified]** | R | Used by ClaimServices. | `ClaimServices` |
| [CL_PHARMACY_ELIGIBILITY_REPORT](#cl-pharmacy-eligibility-report) | Oracle | [unqualified]** | U | Used by ClaimServices. | `ClaimServices` |
| [PAYMENT_TRANSACTION_TYPE_CODE](#payment-transaction-type-code) | Oracle | [unqualified]** | U | Used by ClaimServices. | `ClaimServices` |
| [BANK_ACCOUNT](#bank_account) | Oracle | [unqualified]** | R | Used by ClaimServices, EFTServices. | `ClaimServices`, `EFTServices` |
| [PAYMENT_AUTHORIZATION](#payment_authorization) | Oracle | [unqualified]** | R | Used by ClaimServices, EFTServices. | `ClaimServices`, `EFTServices` |
| [DEBIT_CARD_ENROLLMENT_REQUEST](#debit_card_enrollment_request) | Oracle | [unqualified]** | R | Used by EFTServices. | `EFTServices` |
| [CL_CLAIM_EMP_BUS_FUNC_LIMIT](#cl_claim_emp_bus_func_limit) | Oracle | [unqualified]** | R | Used by ClaimServices. | `ClaimServices` |
| [NON_EMPR_ACCT](#non_empr_acct) | Oracle | [unqualified]** | R | Used by PolicyServices. | `PolicyServices` |
| [VIRTUAL_EMPLOYEE](#virtual_employee) | Oracle | [unqualified]** | R | Used by clsEmployeeData. | `clsEmployeeData` |
| [LEAVE_TYPE_CODE](#leave_type_code) | Oracle | [unqualified]** | R | Used by clsEmployeeLeaveCollection. | `clsEmployeeLeaveCollection` |
| [DUAL](#dual) | Oracle | `SYS`* | R | Used by clsHelpText, ClaimServices. | `clsHelpText`, `ClaimServices` |
| [WCIS_EMPLOYEE](#wcis-employee) | Oracle | [unqualified]** | R | Used by clsEmployeeData. | `clsEmployeeData` |
| [Code/lookup tables (`EMAIL_CODE`, `ADDRESS_CODE`, `PHONE_CODE`, `COMPANY_CODE`, `RELATIONSHIP_CODE`, `ETHNIC_GROUP_CODE`, `CL_LANGUAGE_PREFERENCE_CODE`, `CL_BENEFIT_TYPE_CODE`, `CL_JURISDICTION_CODE`, `COUNTRY_CODE`, `CL_RELATIONSHIP_TO_WORKER_CODE`, `CLAIM_PERSON_CODE`, `CL_PAYMENT_CATEGORY_CODE`, `CL_REIMB_PROGRAM_CODE`, `CLAIM_DECISION_CODE`, `CL_REQUEST_TYPE_CODE`, `OWN_MOTION_REASON_CODE`, `EAIP_EXPENSE_TYPE_CODE`, `RTW_LOAD_CODE`, `CL_WAGE_PERIOD_PAY_UNIT_CODE`, `CL_SETTLEMENT_FULL_PART_CODE`, `CL_FINANCIAL_TRANS_TYPE_CODE`, `CL_CLAIM_COST_CATEGORY_CODE`, `CL_CLAIM_TYPE_CODE`, `CL_CLAIM_TYPE_GCODE`, `CLAIM_STATUS_CODE`, `CL_CLAIM_STATUS_GCODE`)](#code-lookup-tables-email-code-address-code-phone-code-company-code-relationship-code-ethnic-group-code-cl-language-preference-code-cl-benefit-type-code-cl-jurisdiction-code-country-code-cl-relationship-to-worker-code-claim-person-code-cl-payment-category-code-cl-reimb-program-code-claim-decision-code-cl-request-type-code-own-motion-reason-code-eaip-expense-type-code-rtw-load-code-cl-wage-period-pay-unit-code-cl-settlement-full-part-code-cl-financial-trans-type-code-cl-claim-cost-category-code-cl-claim-type-code-cl-claim-type-gcode-claim-status-code-cl-claim-status-gcode) | Oracle | [unqualified]** | R | Used by mdlCodeMaps, GlobalizationServices. | `mdlCodeMaps`, `GlobalizationServices` |

## ADP_EMPLOYEE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Used by `clsEmployeeData`, `clsEmployeeDataCollection`. |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | R |
| **Key columns used** | See the linked SQL documents for exact column usage. |
| **Sequence** | N/A |
| **Related tables** | See the relationship diagram and linked SQL documents. |
| **Business objects** | `clsEmployeeData`, `clsEmployeeDataCollection` |

### Operations referencing this table
- [Employee profile retrieval](operations/employee-profile-retrieval.md)
- [Employee collection retrieval](operations/employee-directory-retrieval.md)

### Business rules referencing this table
- [BR-SB-011: Employee collection retrieval appends literal filter predicates](business-rules.md#br-sb-011-employee-collection-retrieval-appends-literal-filter-predicates)
- [PROC-RULE-033: Claim authorization exists only when the employee has a matching business-process/function-limit row with a sufficient maximum amount.](business-rules.md#proc-rule-033-claim-authorization-exists-only-when-the-employee-has-a-matching-business-process-function-limit-row-with-a-sufficient-maximum-amount)

### SQL referencing this table
- [SQL-018](sql/SQL-018-sp82348-claim-authorization.md)
- [SQL-023](sql/SQL-023-employee-retrieval-adp-virtual-variant.md)
- [SQL-025](sql/SQL-025-employee-adjunct-lookups.md)
- [SQL-026](sql/SQL-026-employee-collection-retrieval.md)

---

## ADP_EMPLOYEE_PHONE_VIEW

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Used by `clsEmployeeData`. |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | R |
| **Key columns used** | See the linked SQL documents for exact column usage. |
| **Sequence** | N/A |
| **Related tables** | See the relationship diagram and linked SQL documents. |
| **Business objects** | `clsEmployeeData` |

### Operations referencing this table
- [Employee profile retrieval](operations/employee-profile-retrieval.md)

### SQL referencing this table
- [SQL-025](sql/SQL-025-employee-adjunct-lookups.md)

---

## ADP_VIRTUAL_EMPLOYEE_VIEW

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Used by `ClaimServices`. |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | R |
| **Key columns used** | See the linked SQL documents for exact column usage. |
| **Sequence** | N/A |
| **Related tables** | See the relationship diagram and linked SQL documents. |
| **Business objects** | `ClaimServices` |

### Operations referencing this table
- [Claim authorization and visibility checks](operations/claim-information-and-authorization-support.md)

### SQL referencing this table
- [SQL-014](sql/SQL-014-override-security-lookup.md)

---

## ALL_STATES

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Used by `clsAddress`, `ObjectServices`. |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | R |
| **Key columns used** | See the linked SQL documents for exact column usage. |
| **Sequence** | N/A |
| **Related tables** | See the relationship diagram and linked SQL documents. |
| **Business objects** | `clsAddress`, `ObjectServices` |

### Operations referencing this table
- [Address validation and external-user reporting](operations/address-and-bank-validation-support.md)

### SQL referencing this table
- [SQL-022](sql/SQL-022-address-state-country-zip-validation-family.md)

---

## APPLICATION_HELP_DETAIL

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Used by `clsHelpText`, `clsHelpTextCollection`. |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | R |
| **Key columns used** | See the linked SQL documents for exact column usage. |
| **Sequence** | `REFERENCE_KEY_VALUE_NEXTVAL` |
| **Related tables** | See the relationship diagram and linked SQL documents. |
| **Business objects** | `clsHelpText`, `clsHelpTextCollection` |

### Operations referencing this table
- [Help text retrieval](operations/help-text-retrieval.md)

### SQL referencing this table
- [SQL-029](sql/SQL-029-help-text-retrieval.md)
- [SQL-030](sql/SQL-030-help-text-collection-retrieval.md)

---

## APPLICATION_HELP_MASTER

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Used by `clsHelpTextCollection`. |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | R |
| **Key columns used** | See the linked SQL documents for exact column usage. |
| **Sequence** | `REFERENCE_KEY_VALUE_NEXTVAL` |
| **Related tables** | See the relationship diagram and linked SQL documents. |
| **Business objects** | `clsHelpTextCollection` |

### Operations referencing this table
- [Help text retrieval](operations/help-text-retrieval.md)

### SQL referencing this table
- [SQL-030](sql/SQL-030-help-text-collection-retrieval.md)

---

## COUNTRY

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Used by `clsAddress`, `clsAddressStructure`. |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | R |
| **Key columns used** | See the linked SQL documents for exact column usage. |
| **Sequence** | N/A |
| **Related tables** | See the relationship diagram and linked SQL documents. |
| **Business objects** | `clsAddress`, `clsAddressStructure` |

### Operations referencing this table
- [Policy and unit-stat support](operations/policy-and-unit-stat-support.md)
- [Address validation and external-user reporting](operations/address-and-bank-validation-support.md)

### Business rules referencing this table
- [PROC-RULE-022: UW312 and UW310 correspondence prefers the payroll mailing address before standard policy locations.](business-rules.md#proc-rule-022-uw312-and-uw310-correspondence-prefers-the-payroll-mailing-address-before-standard-policy-locations)
- [PROC-RULE-023: Other correspondence uses the standard policy location first and then the latest eligible expired policy location.](business-rules.md#proc-rule-023-other-correspondence-uses-the-standard-policy-location-first-and-then-the-latest-eligible-expired-policy-location)
- [PROC-RULE-024: Policy-location rows are filtered against either the policy effective date or the process date depending on whether processing is before or after the policy period start.](business-rules.md#proc-rule-024-policy-location-rows-are-filtered-against-either-the-policy-effective-date-or-the-process-date-depending-on-whether-processing-is-before-or-after-the-policy-period-start)
- [PROC-RULE-025: Barcode output switches to email address for UW560 correspondence.](business-rules.md#proc-rule-025-barcode-output-switches-to-email-address-for-uw560-correspondence)
- [PROC-RULE-026: Missing country codes default to the United States before country-name lookup.](business-rules.md#proc-rule-026-missing-country-codes-default-to-the-united-states-before-country-name-lookup)
- [PROC-RULE-027: The DBA line is only emitted when the legal name differs from the policy name.](business-rules.md#proc-rule-027-the-dba-line-is-only-emitted-when-the-legal-name-differs-from-the-policy-name)
- [PROC-RULE-028: Missing policy-location data is surfaced as an application error after blanking all output fields.](business-rules.md#proc-rule-028-missing-policy-location-data-is-surfaced-as-an-application-error-after-blanking-all-output-fields)

### SQL referencing this table
- [SQL-022](sql/SQL-022-address-state-country-zip-validation-family.md)

---

## EMPLOYEE_LEAVE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Used by `clsEmployeeLeave`, `clsEmployeeLeaveCollection`. |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | C/R/U/D |
| **Key columns used** | See the linked SQL documents for exact column usage. |
| **Sequence** | `EMPLOYEE_LEAVE_SEQ`* |
| **Related tables** | See the relationship diagram and linked SQL documents. |
| **Business objects** | `clsEmployeeLeave`, `clsEmployeeLeaveCollection` |

### Operations referencing this table
- [Employee leave persistence](operations/employee-leave-management.md)

### Business rules referencing this table
- [BR-SB-001: Employee leave requires investigator, reason, begin date, and end date](business-rules.md#br-sb-001-employee-leave-requires-investigator-reason-begin-date-and-end-date)
- [BR-SB-002: Employee leave dates must stay within allowed ranges and ordering](business-rules.md#br-sb-002-employee-leave-dates-must-stay-within-allowed-ranges-and-ordering)
- [BR-SB-013: Employee leave updates expect single-row success](business-rules.md#br-sb-013-employee-leave-updates-expect-single-row-success)
- [BR-SB-014: Employee leave deletes expect single-row success](business-rules.md#br-sb-014-employee-leave-deletes-expect-single-row-success)

### SQL referencing this table
- [SQL-002](sql/SQL-002-pk82029-titan-insert-employee-leave.md)
- [SQL-027](sql/SQL-027-employee-leave-retrieval.md)
- [SQL-028](sql/SQL-028-pk82029-titan-select-employee-leave.md)
- [SQL-046](sql/SQL-046-pk82029-titan-update-employee-leave.md)
- [SQL-047](sql/SQL-047-pk82029-titan-delete-employee-leave.md)

---

## EXT_USER / EXT_USER_TYPE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Used by `ExternalUserServices`. |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | R |
| **Key columns used** | See the linked SQL documents for exact column usage. |
| **Sequence** | N/A |
| **Related tables** | See the relationship diagram and linked SQL documents. |
| **Business objects** | `ExternalUserServices` |

### Operations referencing this table
- [Address validation and external-user reporting](operations/user-access-and-external-user-reporting.md)

### Business rules referencing this table
- [BR-SB-007: Production external-user queries hide test users](business-rules.md#br-sb-007-production-external-user-queries-hide-test-users)

### SQL referencing this table
- [SQL-036](sql/SQL-036-external-user-last-logon-user-lookup-family.md)

---

## IMAGE / IMGSYS

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Used by `ImageInfo`. |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | R |
| **Key columns used** | See the linked SQL documents for exact column usage. |
| **Sequence** | N/A |
| **Related tables** | See the relationship diagram and linked SQL documents. |
| **Business objects** | `ImageInfo` |

### Operations referencing this table
- [Imaging lookup and alert support](operations/imaging-lookup-and-alert-support.md)

### SQL referencing this table
- [SQL-037](sql/SQL-037-image-ifn-lookup-family.md)

---

## LANGUAGE_TRANSLATION

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Used by `clsLanguageTranslation`, `clsLanguageTranslationCollection`. |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | R |
| **Key columns used** | See the linked SQL documents for exact column usage. |
| **Sequence** | N/A |
| **Related tables** | See the relationship diagram and linked SQL documents. |
| **Business objects** | `clsLanguageTranslation`, `clsLanguageTranslationCollection` |

### Operations referencing this table
- [Language translation retrieval](operations/language-translation-retrieval.md)

### SQL referencing this table
- [SQL-031](sql/SQL-031-language-translation-retrieval.md)
- [SQL-032](sql/SQL-032-language-translation-collection-retrieval.md)

---

## LOCATION

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Used by `clsSAIFOutputAddress`. |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | R |
| **Key columns used** | See the linked SQL documents for exact column usage. |
| **Sequence** | N/A |
| **Related tables** | See the relationship diagram and linked SQL documents. |
| **Business objects** | `clsSAIFOutputAddress` |

### Operations referencing this table
- [SAIF output-address retrieval](operations/saif-output-address-retrieval.md)
- [Policy and unit-stat support](operations/policy-and-unit-stat-support.md)

### Business rules referencing this table
- [BR-SB-009: SAIF output-address retrieval requires at least one LOCATION row for XSAIF](business-rules.md#br-sb-009-saif-output-address-retrieval-requires-at-least-one-location-row-for-xsaif)
- [PROC-RULE-022: UW312 and UW310 correspondence prefers the payroll mailing address before standard policy locations.](business-rules.md#proc-rule-022-uw312-and-uw310-correspondence-prefers-the-payroll-mailing-address-before-standard-policy-locations)
- [PROC-RULE-023: Other correspondence uses the standard policy location first and then the latest eligible expired policy location.](business-rules.md#proc-rule-023-other-correspondence-uses-the-standard-policy-location-first-and-then-the-latest-eligible-expired-policy-location)
- [PROC-RULE-024: Policy-location rows are filtered against either the policy effective date or the process date depending on whether processing is before or after the policy period start.](business-rules.md#proc-rule-024-policy-location-rows-are-filtered-against-either-the-policy-effective-date-or-the-process-date-depending-on-whether-processing-is-before-or-after-the-policy-period-start)
- [PROC-RULE-025: Barcode output switches to email address for UW560 correspondence.](business-rules.md#proc-rule-025-barcode-output-switches-to-email-address-for-uw560-correspondence)
- [PROC-RULE-026: Missing country codes default to the United States before country-name lookup.](business-rules.md#proc-rule-026-missing-country-codes-default-to-the-united-states-before-country-name-lookup)
- [PROC-RULE-027: The DBA line is only emitted when the legal name differs from the policy name.](business-rules.md#proc-rule-027-the-dba-line-is-only-emitted-when-the-legal-name-differs-from-the-policy-name)
- [PROC-RULE-028: Missing policy-location data is surfaced as an application error after blanking all output fields.](business-rules.md#proc-rule-028-missing-policy-location-data-is-surfaced-as-an-application-error-after-blanking-all-output-fields)

### SQL referencing this table
- [SQL-033](sql/SQL-033-saif-output-address-retrieval.md)

---

## MCO_PLAN / MCO_GSA_LOCATION

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Used by `MCOInfo`. |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | R |
| **Key columns used** | See the linked SQL documents for exact column usage. |
| **Sequence** | N/A |
| **Related tables** | See the relationship diagram and linked SQL documents. |
| **Business objects** | `MCOInfo` |

### Operations referencing this table
- [Lookup and reference-data hydration](operations/lookup-and-reference-data-hydration.md)

### SQL referencing this table
- [SQL-039](sql/SQL-039-mco-lookup-family.md)

---

## POLICY / POLICY_PERIOD_ALL / POLICY_PERIOD_MASTER / US_POLICY_UNIT

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Used by `PolicyServices`, `UnitStatServices`. |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | R |
| **Key columns used** | See the linked SQL documents for exact column usage. |
| **Sequence** | N/A |
| **Related tables** | See the relationship diagram and linked SQL documents. |
| **Business objects** | `PolicyServices`, `UnitStatServices` |

### Operations referencing this table
- [Policy and unit-stat support](operations/policy-and-unit-stat-support.md)

### Business rules referencing this table
- [BR-SB-003: Extended policy periods split only when the period exceeds one year plus sixteen days](business-rules.md#br-sb-003-extended-policy-periods-split-only-when-the-period-exceeds-one-year-plus-sixteen-days)
- [BR-SB-004: Report valuation schedules switch from five to ten periods in 2002](business-rules.md#br-sb-004-report-valuation-schedules-switch-from-five-to-ten-periods-in-2002)
- [BR-SB-005: Low-number policies validate against NON_EMPR_ACCT](business-rules.md#br-sb-005-low-number-policies-validate-against-non-empr-acct)
- [BR-SB-012: NCCI policy numbers prefix voluntary policies with A and others with C](business-rules.md#br-sb-012-ncci-policy-numbers-prefix-voluntary-policies-with-a-and-others-with-c)
- [PROC-RULE-022: UW312 and UW310 correspondence prefers the payroll mailing address before standard policy locations.](business-rules.md#proc-rule-022-uw312-and-uw310-correspondence-prefers-the-payroll-mailing-address-before-standard-policy-locations)
- [PROC-RULE-023: Other correspondence uses the standard policy location first and then the latest eligible expired policy location.](business-rules.md#proc-rule-023-other-correspondence-uses-the-standard-policy-location-first-and-then-the-latest-eligible-expired-policy-location)
- [PROC-RULE-024: Policy-location rows are filtered against either the policy effective date or the process date depending on whether processing is before or after the policy period start.](business-rules.md#proc-rule-024-policy-location-rows-are-filtered-against-either-the-policy-effective-date-or-the-process-date-depending-on-whether-processing-is-before-or-after-the-policy-period-start)
- [PROC-RULE-025: Barcode output switches to email address for UW560 correspondence.](business-rules.md#proc-rule-025-barcode-output-switches-to-email-address-for-uw560-correspondence)
- [PROC-RULE-026: Missing country codes default to the United States before country-name lookup.](business-rules.md#proc-rule-026-missing-country-codes-default-to-the-united-states-before-country-name-lookup)
- [PROC-RULE-027: The DBA line is only emitted when the legal name differs from the policy name.](business-rules.md#proc-rule-027-the-dba-line-is-only-emitted-when-the-legal-name-differs-from-the-policy-name)
- [PROC-RULE-028: Missing policy-location data is surfaced as an application error after blanking all output fields.](business-rules.md#proc-rule-028-missing-policy-location-data-is-surfaced-as-an-application-error-after-blanking-all-output-fields)
- [PROC-RULE-029: MAX mode returns the first day of the month 15 months after the effective date.](business-rules.md#proc-rule-029-max-mode-returns-the-first-day-of-the-month-15-months-after-the-effective-date)
- [PROC-RULE-030: Default mode uses a 13-month horizon for second-half effective dates and 12 months otherwise.](business-rules.md#proc-rule-030-default-mode-uses-a-13-month-horizon-for-second-half-effective-dates-and-12-months-otherwise)
- [PROC-RULE-031: AR policies snap the calculated expiration month to quarter boundaries.](business-rules.md#proc-rule-031-ar-policies-snap-the-calculated-expiration-month-to-quarter-boundaries)
- [PROC-RULE-032: Unhandled calculation failures are surfaced as application errors.](business-rules.md#proc-rule-032-unhandled-calculation-failures-are-surfaced-as-application-errors)

### SQL referencing this table
- [SQL-042](sql/SQL-042-policy-lookup-family.md)
- [SQL-043](sql/SQL-043-unit-stat-lookup-family.md)

---

## RECORDING

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Used by `ImageServices`. |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | R |
| **Key columns used** | See the linked SQL documents for exact column usage. |
| **Sequence** | N/A |
| **Related tables** | See the relationship diagram and linked SQL documents. |
| **Business objects** | `ImageServices` |

### Operations referencing this table
- [Imaging lookup and alert support](operations/imaging-lookup-and-alert-support.md)

### Business rules referencing this table
- [PROC-RULE-001: Alert recipients are concatenated only while the output buffer remains under 4000 characters.](business-rules.md#proc-rule-001-alert-recipients-are-concatenated-only-while-the-output-buffer-remains-under-4000-characters)
- [PROC-RULE-002: Missing alert tasks produce an explicit not-found message.](business-rules.md#proc-rule-002-missing-alert-tasks-produce-an-explicit-not-found-message)
- [PROC-RULE-003: The result message uses singular or plural grammar based on alert count.](business-rules.md#proc-rule-003-the-result-message-uses-singular-or-plural-grammar-based-on-alert-count)

---

## PDF_CONVERSION_ERROR

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Used by `ImageServices`. |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | C |
| **Key columns used** | See the linked SQL documents for exact column usage. |
| **Sequence** | `PDF_CONVERSION_ERROR_SEQ` |
| **Related tables** | See the relationship diagram and linked SQL documents. |
| **Business objects** | `ImageServices` |

### Operations referencing this table
- [Imaging lookup and alert support](operations/imaging-lookup-and-alert-support.md)

### SQL referencing this table
- [SQL-003](sql/SQL-003-insert-into-pdf-conversion-error-values-pdf-conversion-error-seq-nextval.md)

---

## ZIP_CODE / ZIP_MCO_COUNTY

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Used by `clsAddress`, `clsAddressStructure`. |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | R |
| **Key columns used** | See the linked SQL documents for exact column usage. |
| **Sequence** | N/A |
| **Related tables** | See the relationship diagram and linked SQL documents. |
| **Business objects** | `clsAddress`, `clsAddressStructure` |

### Operations referencing this table
- [Address validation and external-user reporting](operations/address-and-bank-validation-support.md)

### SQL referencing this table
- [SQL-022](sql/SQL-022-address-state-country-zip-validation-family.md)

---

## CL_INJURY_CLAIM / CL_CLAIM_RESPONSIBILITY

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Used by `ClaimServices`. |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | R |
| **Key columns used** | See the linked SQL documents for exact column usage. |
| **Sequence** | N/A |
| **Related tables** | See the relationship diagram and linked SQL documents. |
| **Business objects** | `ClaimServices` |

### Operations referencing this table
- [Claim authorization and visibility checks](operations/claim-information-and-authorization-support.md)

### Business rules referencing this table
- [BR-SB-006: Claims are externally viewable only when external view flag is Y](business-rules.md#br-sb-006-claims-are-externally-viewable-only-when-external-view-flag-is-y)
- [PROC-RULE-005: The procedure uses the caller-supplied date when one is provided.](business-rules.md#proc-rule-005-the-procedure-uses-the-caller-supplied-date-when-one-is-provided)
- [PROC-RULE-006: Default correspondence address lookup falls back from guardian to mailing to home address.](business-rules.md#proc-rule-006-default-correspondence-address-lookup-falls-back-from-guardian-to-mailing-to-home-address)
- [PROC-RULE-007: Default payment address lookup falls back from guardian to payment to mailing to home address.](business-rules.md#proc-rule-007-default-payment-address-lookup-falls-back-from-guardian-to-payment-to-mailing-to-home-address)
- [PROC-RULE-008: Explicit payment requests only use payment addresses.](business-rules.md#proc-rule-008-explicit-payment-requests-only-use-payment-addresses)
- [PROC-RULE-009: Other requests use the requested address type directly.](business-rules.md#proc-rule-009-other-requests-use-the-requested-address-type-directly)
- [PROC-RULE-010: Guardian correspondence resolves the guardian mailing address and inserts a `For:` line for the worker/beneficiary.](business-rules.md#proc-rule-010-guardian-correspondence-resolves-the-guardian-mailing-address-and-inserts-a-for-line-for-the-worker-beneficiary)
- [PROC-RULE-011: Deceased people are addressed as estates.](business-rules.md#proc-rule-011-deceased-people-are-addressed-as-estates)
- [PROC-RULE-012: Blank address lines are compacted upward to eliminate gaps.](business-rules.md#proc-rule-012-blank-address-lines-are-compacted-upward-to-eliminate-gaps)
- [PROC-RULE-013: Addressee salutation is gender-based.](business-rules.md#proc-rule-013-addressee-salutation-is-gender-based)
- [PROC-RULE-014: An address is valid only when it has a person name, two populated address lines, and either foreign-address status or a city/state pair.](business-rules.md#proc-rule-014-an-address-is-valid-only-when-it-has-a-person-name-two-populated-address-lines-and-either-foreign-address-status-or-a-city-state-pair)
- [PROC-RULE-015: Requests with no qualifying address return no rows.](business-rules.md#proc-rule-015-requests-with-no-qualifying-address-return-no-rows)

### SQL referencing this table
- [SQL-005](sql/SQL-005-pk82001-claim-getpersonaddress.md)
- [SQL-006](sql/SQL-006-responsible-adjuster-lookup-by-claim-number.md)
- [SQL-007](sql/SQL-007-responsible-adjuster-lookup-by-claim-id.md)
- [SQL-008](sql/SQL-008-claim-existence-check.md)
- [SQL-021](sql/SQL-021-external-view-eligibility-query.md)
- [SQL-009](sql/SQL-009-responsibility-code-validation.md)

---

## CL_FINANCIAL_TRANS / CL_FINANCIAL_TRANS_DTL

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Used by `ClaimServices`. |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | R |
| **Key columns used** | See the linked SQL documents for exact column usage. |
| **Sequence** | N/A |
| **Related tables** | See the relationship diagram and linked SQL documents. |
| **Business objects** | `ClaimServices` |

### Operations referencing this table
- [Claim authorization and visibility checks](operations/claim-information-and-authorization-support.md)

### Business rules referencing this table
- [BR-SB-010: Benefit-payment history checks map business context to payment-category filters](business-rules.md#br-sb-010-benefit-payment-history-checks-map-business-context-to-payment-category-filters)

### SQL referencing this table
- [SQL-012](sql/SQL-012-existing-benefit-payment-search.md)
- [SQL-013](sql/SQL-013-payment-transaction-status-checks.md)

---

## CL_INCURRED_COST_HISTORY / CL_INCURRED_CATEGORY_COST

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Used by `ClaimServices`. |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | R |
| **Key columns used** | See the linked SQL documents for exact column usage. |
| **Sequence** | N/A |
| **Related tables** | See the relationship diagram and linked SQL documents. |
| **Business objects** | `ClaimServices` |

### SQL referencing this table
- [SQL-016](sql/SQL-016-incurred-cost-aggregation.md)

---

## CL_SECURITY_OVERRIDE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Used by `ClaimServices`. |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | R |
| **Key columns used** | See the linked SQL documents for exact column usage. |
| **Sequence** | N/A |
| **Related tables** | See the relationship diagram and linked SQL documents. |
| **Business objects** | `ClaimServices` |

### Operations referencing this table
- [Claim authorization and visibility checks](operations/claim-information-and-authorization-support.md)

### SQL referencing this table
- [SQL-014](sql/SQL-014-override-security-lookup.md)

---

## LEGAL_CASE / LEGAL_COLLECTION / INVESTIGATION / CL_CLAIM_SUPPORT_ORDER_CONN

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Used by `ClaimServices`. |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | R |
| **Key columns used** | See the linked SQL documents for exact column usage. |
| **Sequence** | N/A |
| **Related tables** | See the relationship diagram and linked SQL documents. |
| **Business objects** | `ClaimServices` |

### Operations referencing this table
- [Imaging lookup and alert support](operations/imaging-lookup-and-alert-support.md)

### Business rules referencing this table
- [PROC-RULE-004: Claim image alerting is enabled only when at least one flagged legal case exists for the claim.](business-rules.md#proc-rule-004-claim-image-alerting-is-enabled-only-when-at-least-one-flagged-legal-case-exists-for-the-claim)

### SQL referencing this table
- [SQL-015](sql/SQL-015-legal-case-existence.md)
- [SQL-010](sql/SQL-010-legal-collection-existence.md)
- [SQL-011](sql/SQL-011-investigation-request-date.md)
- [SQL-017](sql/SQL-017-support-order-existence.md)

---

## CL_PHARMACY_ELIGIBILITY_REPORT

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Used by `ClaimServices`. |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | U |
| **Key columns used** | See the linked SQL documents for exact column usage. |
| **Sequence** | N/A |
| **Related tables** | See the relationship diagram and linked SQL documents. |
| **Business objects** | `ClaimServices` |

### SQL referencing this table
- [SQL-044](sql/SQL-044-pharmacy-eligibility-update.md)

---

## PAYMENT_TRANSACTION_TYPE_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Used by `ClaimServices`. |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | U |
| **Key columns used** | See the linked SQL documents for exact column usage. |
| **Sequence** | N/A |
| **Related tables** | See the relationship diagram and linked SQL documents. |
| **Business objects** | `ClaimServices` |

### SQL referencing this table
- [SQL-045](sql/SQL-045-payment-transaction-type-next-issue-date-update.md)

---

## WCIS_EMPLOYEE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Used by `clsEmployeeData`. |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | R |
| **Key columns used** | See the linked SQL documents for exact column usage. |
| **Sequence** | N/A |
| **Related tables** | See the relationship diagram and linked SQL documents. |
| **Business objects** | `clsEmployeeData` |

### Operations referencing this table
- [Employee profile retrieval](operations/employee-profile-retrieval.md)

### SQL referencing this table
- [SQL-024](sql/SQL-024-wcis-employee-fallback.md)

---

## Code/lookup tables (`EMAIL_CODE`, `ADDRESS_CODE`, `PHONE_CODE`, `COMPANY_CODE`, `RELATIONSHIP_CODE`, `ETHNIC_GROUP_CODE`, `CL_LANGUAGE_PREFERENCE_CODE`, `CL_BENEFIT_TYPE_CODE`, `CL_JURISDICTION_CODE`, `COUNTRY_CODE`, `CL_RELATIONSHIP_TO_WORKER_CODE`, `CLAIM_PERSON_CODE`, `CL_PAYMENT_CATEGORY_CODE`, `CL_REIMB_PROGRAM_CODE`, `CLAIM_DECISION_CODE`, `CL_REQUEST_TYPE_CODE`, `OWN_MOTION_REASON_CODE`, `EAIP_EXPENSE_TYPE_CODE`, `RTW_LOAD_CODE`, `CL_WAGE_PERIOD_PAY_UNIT_CODE`, `CL_SETTLEMENT_FULL_PART_CODE`, `CL_FINANCIAL_TRANS_TYPE_CODE`, `CL_CLAIM_COST_CATEGORY_CODE`, `CL_CLAIM_TYPE_CODE`, `CL_CLAIM_TYPE_GCODE`, `CLAIM_STATUS_CODE`, `CL_CLAIM_STATUS_GCODE`)

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Used by `mdlCodeMaps`, `GlobalizationServices`. |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | R |
| **Key columns used** | See the linked SQL documents for exact column usage. |
| **Sequence** | N/A |
| **Related tables** | See the relationship diagram and linked SQL documents. |
| **Business objects** | `mdlCodeMaps`, `GlobalizationServices` |

---


## BANK_ACCOUNT

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports EFT authorization status checks by providing bank-account status and prenote fields. |
| **Access pattern** | stored procedure |
| **CRUD operations** | R |
| **Key columns used** | `BANK_ACCOUNT_SEQ_NUM`, `BANK_ACCOUNT_STATUS_CODE`, `PRENOTE_REQUIRED_FLAG`, `PRENOTE_SUCCESS_DATE` |
| **Sequence** | N/A |
| **Related tables** | `PAYMENT_AUTHORIZATION` |
| **Business objects** | `ClaimServices`, `EFTServices` |

### SQL referencing this table
- [SQL-019](sql/SQL-019-pk82350-eft-isauthorizedforeft.md)
- [SQL-020](sql/SQL-020-pk82350-eft-isbeneficiaryauthforeft.md)
- [SQL-035](sql/SQL-035-eft-procedure-family.md)

---

## CL_CLAIM_EMP_BUS_FUNC_LIMIT

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Stores claim authorization limits used to decide whether an employee can release or approve a payment or reserve. |
| **Access pattern** | stored procedure |
| **CRUD operations** | R |
| **Key columns used** | `EMPLOYEE_EMPLID`, `CLAIM_BUS_PROCESS_CODE`, `CLAIM_AUTH_PURPOSE_CODE`, `CLAIM_BUS_FUNCTION_CODE`, `MAX_AMOUNT` |
| **Sequence** | N/A |
| **Related tables** | `ADP_EMPLOYEE` |
| **Business objects** | `ClaimServices` |

### SQL referencing this table
- [SQL-018](sql/SQL-018-sp82348-claim-authorization.md)

---

## DEBIT_CARD_ENROLLMENT_REQUEST

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Tracks debit-card enrollment rows counted by EFT card-enrollment helpers. |
| **Access pattern** | stored procedure |
| **CRUD operations** | R |
| **Key columns used** | `CARDHOLDER_ID_NUM`, `CARD_TERM_DATE` |
| **Sequence** | N/A |
| **Related tables** | N/A |
| **Business objects** | `EFTServices` |

### SQL referencing this table
- [SQL-035](sql/SQL-035-eft-procedure-family.md)

---

## DUAL

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `SYS`* |
| **Purpose** | Oracle pseudo-table used when the library needs a single-row scalar or cursor-backed projection instead of a persisted business table. |
| **Access pattern** | direct SQL / stored procedure |
| **CRUD operations** | R |
| **Key columns used** | Pseudo-columns only; no persisted business columns are read. |
| **Sequence** | `REFERENCE_KEY_VALUE_NEXTVAL` |
| **Related tables** | N/A |
| **Business objects** | `clsHelpText`, `ClaimServices` |

### SQL referencing this table
- [SQL-001](sql/SQL-001-select-reference-key-value-nextval-from-dual.md)
- [SQL-005](sql/SQL-005-pk82001-claim-getpersonaddress.md)

---

## LEAVE_TYPE_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supplies descriptive leave-type text for employee-leave result sets. |
| **Access pattern** | stored procedure |
| **CRUD operations** | R |
| **Key columns used** | `CODE`, `CODE_DESCR` |
| **Sequence** | N/A |
| **Related tables** | `EMPLOYEE_LEAVE` |
| **Business objects** | `clsEmployeeLeaveCollection` |

### SQL referencing this table
- [SQL-028](sql/SQL-028-pk82029-titan-select-employee-leave.md)

---

## NON_EMPR_ACCT

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Stores low-number non-employer accounts used by policy validation logic. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | `ACCT_NUM` |
| **Sequence** | N/A |
| **Related tables** | `POLICY` |
| **Business objects** | `PolicyServices` |

### SQL referencing this table
- [SQL-042](sql/SQL-042-policy-lookup-family.md)

---

## PAYMENT_AUTHORIZATION

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Stores EFT payment authorization rows returned or counted by `pk82350_eft`. |
| **Access pattern** | stored procedure |
| **CRUD operations** | R |
| **Key columns used** | `CUSTOMER_SECOND_ID`, `CUSTOMER_ID`, `CUSTOMER_TYPE_CODE`, `AUTHORIZATION_TYPE_CODE`, `AUTH_DATE`, `REVOKE_DATE`, `BANK_ACCOUNT_SEQ_NUM`, `PAYMENT_AUTHORIZATION_SEQ_NUM` |
| **Sequence** | N/A |
| **Related tables** | `BANK_ACCOUNT` |
| **Business objects** | `ClaimServices`, `EFTServices` |

### SQL referencing this table
- [SQL-019](sql/SQL-019-pk82350-eft-isauthorizedforeft.md)
- [SQL-020](sql/SQL-020-pk82350-eft-isbeneficiaryauthforeft.md)
- [SQL-035](sql/SQL-035-eft-procedure-family.md)

---

## VIRTUAL_EMPLOYEE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Provides the virtual-employee projection used by the employee retrieval variant that joins supervisor data from `ADP_EMPLOYEE`. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | `CITY`, `DEPTID`, `DESCR`, `EMAIL_ADDRESS`, `EMPLID`, `EMPL_STATUS`, `FIRST_NAME`, `LAST_NAME`, `LOCATION`, `MIDDLE_NAME`, `PHONE`, `PHONE_EXTENSION`, `PREFERRED_NAME`, `RPT_MGR_EMPLID` |
| **Sequence** | N/A |
| **Related tables** | `ADP_EMPLOYEE` |
| **Business objects** | `clsEmployeeData` |

### SQL referencing this table
- [SQL-023](sql/SQL-023-employee-retrieval-adp-virtual-variant.md)

---

## Table relationship diagram

The following diagram shows discoverable relationships across the tables and views used by this library.

```mermaid
erDiagram
    CL_CLAIM_RESPONSIBILITY ||--o{ CL_INJURY_CLAIM : "CL_INJURY_CLAIM.CLAIM_RESP_CODE = CL_CLAIM_RESPONSIBILITY.CLAIM_RESP_CODE"
    CL_FINANCIAL_TRANS ||--o{ CL_FINANCIAL_TRANS_DTL : "CL_FINANCIAL_TRANS.CLAIM_FINANCIAL_TRANS_SEQ_NUM = CL_FINANCIAL_TRANS_DTL.CLAIM_FINANCIAL_TRANS_SEQ_NUM"
    CL_INCURRED_COST_HISTORY ||--o{ CL_INCURRED_CATEGORY_COST : "CL_INCURRED_COST_HISTORY.CL_INCURRED_COST_HIST_SEQ_NUM = CL_INCURRED_CATEGORY_COST.CL_INCURRED_COST_HIST_SEQ_NUM"
    ADP_EMPLOYEE ||--o{ ADP_EMPLOYEE : "SPV.EMPLID = ADP.RPT_MGR_EMPLID"
    EXT_USER ||--o{ EXT_USER_TYPE : "EXT_USER_TYPE.EXT_USER_SEQ_NUM = EXT_USER.EXT_USER_SEQ_NUM"
    IMAGE ||--o{ IMGSYS : "IMAGE.TOWID = IMGSYS.TOWID"
    APPLICATION_HELP_MASTER ||--o{ APPLICATION_HELP_DETAIL : "APPLICATION_HELP_MASTER.REFERENCE_KEY_VALUE = APPLICATION_HELP_DETAIL.REFERENCE_KEY_VALUE"
    MCO_PLAN ||--o{ MCO_GSA_LOCATION : "MCO_PLAN.MCO_PLAN_ID = MCO_GSA_LOCATION.MCO_PLAN_ID"
    POLICY ||--o{ POLICY_PERIOD_MASTER : "POLICY.POLICY_NUM = POLICY_PERIOD_MASTER.POLICY_NUM"
    POLICY ||--o{ US_POLICY_UNIT : "US_POLICY_UNIT.POLICY_NUM = POLICY.POLICY_NUM"
```

> **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.

## 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)
- [SQL catalog](sql/index.md)
- [Procedures](procedures/index.md)
- [API reference](api/index.md)
- [Security and authorization](security-authorization.md)
- [Configuration](configuration.md)

## Sources
- `Business\SAIF.Business\ClaimServices.vb`
- `Business\SAIF.Business\clsEmployeeData.vb`
- `Business\SAIF.Business\clsEmployeeDataCollection.vb`
- `Business\SAIF.Business\clsEmployeeLeave.vb`
- `Business\SAIF.Business\clsHelpText.vb`
- `Business\SAIF.Business\clsHelpTextCollection.vb`
- `Business\SAIF.Business\clsLanguageTranslation.vb`
- `Business\SAIF.Business\clsLanguageTranslationCollection.vb`
- `Business\SAIF.Business\clsSAIFOutputAddress.vb`
- `Business\SAIF.Business\ImageInfo.vb`
- `Business\SAIF.Business\ImageServices.vb`
- `Business\SAIF.Business\PolicyServices.vb`
- `Business\SAIF.Business\UnitStatServices.vb`
- `Business\SAIF.Business\MCOInfo.vb`
- `Business\SAIF.Business\mdlCodeMaps.vb`
- `Business\SAIF.Business\ObjectServices.vb`
- `Business\SAIF.Business\EFTServices.vb`
- `Business\SAIF.Business\ContactInfo\clsAddress.vb`
- `Business\SAIF.Business\ContactInfo\clsAddressStructure.vb`
- `Business\SAIF.Business\Services\ExternalUserServices.vb`