---
title: SAIF.Business 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
reference_type: package
---

# SAIF.Business SQL catalog

This page indexes the inline SQL statements and stored-procedure calls used by `SAIF.Business`.

## Create operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-002](SQL-002-pk82029-titan-insert-employee-leave.md) | Pk82029 titan insert employee leave | StoredProc | EMPLOYEE_LEAVE | `clsEmployeeLeave` |
| [SQL-003](SQL-003-insert-into-pdf-conversion-error-values-pdf-conversion-error-seq-nextval.md) | Inline create used by ImageServices | Inline | PDF_CONVERSION_ERROR | `ImageServices` |

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-004](SQL-004-sp82288-calcmaxburialamt.md) | Sp82288 calcmaxburialamt | StoredProc | N/A | `ClaimServices` |
| [SQL-005](SQL-005-pk82001-claim-getpersonaddress.md) | Pk82001 claim getpersonaddress | StoredProc | CL_INJURY_CLAIM | `ClaimServices` |
| [SQL-006](SQL-006-responsible-adjuster-lookup-by-claim-number.md) | Responsible-adjuster lookup by claim number | Inline | CL_INJURY_CLAIM, CL_CLAIM_RESPONSIBILITY | `ClaimServices` |
| [SQL-007](SQL-007-responsible-adjuster-lookup-by-claim-id.md) | Responsible-adjuster lookup by claim id | Inline | CL_INJURY_CLAIM, CL_CLAIM_RESPONSIBILITY | `ClaimServices` |
| [SQL-008](SQL-008-claim-existence-check.md) | Claim existence check | Inline | CL_INJURY_CLAIM | `ClaimServices` |
| [SQL-009](SQL-009-responsibility-code-validation.md) | Responsibility-code validation | Inline | CL_CLAIM_RESPONSIBILITY | `ClaimServices` |
| [SQL-010](SQL-010-legal-collection-existence.md) | Legal-collection existence | Inline | LEGAL_COLLECTION | `ClaimServices` |
| [SQL-011](SQL-011-investigation-request-date.md) | Investigation request date | Inline | INVESTIGATION | `ClaimServices` |
| [SQL-012](SQL-012-existing-benefit-payment-search.md) | Existing benefit-payment search | Inline | CL_FINANCIAL_TRANS, CL_FINANCIAL_TRANS_DTL | `ClaimServices` |
| [SQL-013](SQL-013-payment-transaction-status-checks.md) | Payment-transaction status checks* | Inline | CL_FINANCIAL_TRANS | `ClaimServices` |
| [SQL-014](SQL-014-override-security-lookup.md) | Override-security lookup | Inline | CL_SECURITY_OVERRIDE, ADP_VIRTUAL_EMPLOYEE_VIEW | `ClaimServices` |
| [SQL-015](SQL-015-legal-case-existence.md) | Legal-case existence | Inline | LEGAL_CASE | `ClaimServices` |
| [SQL-016](SQL-016-incurred-cost-aggregation.md) | Incurred-cost aggregation | Inline | CL_INCURRED_CATEGORY_COST, CL_INCURRED_COST_HISTORY | `ClaimServices` |
| [SQL-017](SQL-017-support-order-existence.md) | Support-order existence | Inline | CL_CLAIM_SUPPORT_ORDER_CONN | `ClaimServices` |
| [SQL-018](SQL-018-sp82348-claim-authorization.md) | Sp82348 claim authorization | StoredProc | ADP_EMPLOYEE | `ClaimServices` |
| [SQL-019](SQL-019-pk82350-eft-isauthorizedforeft.md) | Pk82350 eft isauthorizedforeft | StoredProc | PAYMENT_AUTHORIZATION | `ClaimServices` |
| [SQL-020](SQL-020-pk82350-eft-isbeneficiaryauthforeft.md) | Pk82350 eft isbeneficiaryauthforeft | StoredProc | PAYMENT_AUTHORIZATION | `ClaimServices` |
| [SQL-021](SQL-021-external-view-eligibility-query.md) | External-view eligibility query | Inline | CL_INJURY_CLAIM | `ClaimServices` |
| [SQL-022](SQL-022-address-state-country-zip-validation-family.md) | Address/state/country/zip validation family* | Inline | ALL_STATES, ZIP_CODE, COUNTRY, ZIP_MCO_COUNTY | `clsAddress, clsAddressStructure, ObjectServices` |
| [SQL-023](SQL-023-employee-retrieval-adp-virtual-variant.md) | Employee retrieval (adp / virtual variant)* | Inline | ADP_EMPLOYEE, VIRTUAL_EMPLOYEE | `clsEmployeeData` |
| [SQL-024](SQL-024-wcis-employee-fallback.md) | Wcis employee fallback | Inline | WCIS_EMPLOYEE | `clsEmployeeData` |
| [SQL-025](SQL-025-employee-adjunct-lookups.md) | Employee adjunct lookups* | Inline | ADP_EMPLOYEE, ADP_EMPLOYEE_PHONE_VIEW | `clsEmployeeData` |
| [SQL-026](SQL-026-employee-collection-retrieval.md) | Employee collection retrieval* | Inline | ADP_EMPLOYEE, VIRTUAL_EMPLOYEE | `clsEmployeeDataCollection` |
| [SQL-027](SQL-027-employee-leave-retrieval.md) | Employee-leave retrieval | Inline | EMPLOYEE_LEAVE | `clsEmployeeLeave` |
| [SQL-028](SQL-028-pk82029-titan-select-employee-leave.md) | Pk82029 titan select employee leave | StoredProc | EMPLOYEE_LEAVE | `clsEmployeeLeaveCollection` |
| [SQL-029](SQL-029-help-text-retrieval.md) | Help-text retrieval | Inline | APPLICATION_HELP_DETAIL | `clsHelpText` |
| [SQL-030](SQL-030-help-text-collection-retrieval.md) | Help-text collection retrieval | Inline | APPLICATION_HELP_MASTER, APPLICATION_HELP_DETAIL | `clsHelpTextCollection` |
| [SQL-031](SQL-031-language-translation-retrieval.md) | Language-translation retrieval | Inline | LANGUAGE_TRANSLATION | `clsLanguageTranslation` |
| [SQL-032](SQL-032-language-translation-collection-retrieval.md) | Language-translation collection retrieval* | Inline | LANGUAGE_TRANSLATION | `clsLanguageTranslationCollection` |
| [SQL-033](SQL-033-saif-output-address-retrieval.md) | Saif output-address retrieval | Inline | LOCATION | `clsSAIFOutputAddress` |
| [SQL-034](SQL-034-cp-get-group-key-4-pms-info.md) | Cp get group key 4 pms info | StoredProc | N/A | `clsUserType` |
| [SQL-035](SQL-035-eft-procedure-family.md) | Eft procedure family* | StoredProc | N/A | `EFTServices` |
| [SQL-036](SQL-036-external-user-last-logon-user-lookup-family.md) | External-user last-logon/user lookup family* | Inline | EXT_USER, EXT_USER_TYPE | `ExternalUserServices` |
| [SQL-037](SQL-037-image-ifn-lookup-family.md) | Image/ifn lookup family* | Inline | IMAGE, IMGSYS | `ImageInfo` |
| [SQL-038](SQL-038-imaging-helper-sql-procedure-family.md) | Imaging helper sql/procedure family* | Mixed | RECORDING; procedures only** | `ImageServices` |
| [SQL-039](SQL-039-mco-lookup-family.md) | Mco lookup family | Inline | MCO_PLAN, MCO_GSA_LOCATION | `MCOInfo` |
| [SQL-040](SQL-040-code-map-lookup-family.md) | Code-map lookup family* | Inline | Code/lookup tables | `mdlCodeMaps` |
| [SQL-041](SQL-041-cp-report-date.md) | Cp report date | StoredProc | N/A | `ObjectServices` |
| [SQL-042](SQL-042-policy-lookup-family.md) | Policy lookup family* | Mixed | POLICY_PERIOD_ALL, POLICY, NON_EMPR_ACCT; procedures only** | `PolicyServices` |
| [SQL-043](SQL-043-unit-stat-lookup-family.md) | Unit-stat lookup family | Inline | POLICY_PERIOD_MASTER, POLICY, US_POLICY_UNIT | `UnitStatServices` |

## Update operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-044](SQL-044-pharmacy-eligibility-update.md) | Pharmacy-eligibility update | Inline | CL_PHARMACY_ELIGIBILITY_REPORT | `ClaimServices` |
| [SQL-045](SQL-045-payment-transaction-type-next-issue-date-update.md) | Payment-transaction-type next issue date update | Inline | PAYMENT_TRANSACTION_TYPE_CODE | `ClaimServices` |
| [SQL-046](SQL-046-pk82029-titan-update-employee-leave.md) | Pk82029 titan update employee leave | StoredProc | EMPLOYEE_LEAVE | `clsEmployeeLeave` |

## Delete operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-047](SQL-047-pk82029-titan-delete-employee-leave.md) | Pk82029 titan delete employee leave | StoredProc | EMPLOYEE_LEAVE | `clsEmployeeLeave` |

## Sequence operations

| SQL ID | Description | Sequence | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-001](SQL-001-select-reference-key-value-nextval-from-dual.md) | `dual` sequence used by clsHelpText | `dual` | DUAL | `clsHelpText` |

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

> **Note:** Statements marked with `*` are inferred from code behavior rather than explicit documentation or comments.

## 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\clsUserType.vb`
- `Business\SAIF.Business\EFTServices.vb`
- `Business\SAIF.Business\ImageInfo.vb`
- `Business\SAIF.Business\ImageServices.vb`
- `Business\SAIF.Business\MCOInfo.vb`
- `Business\SAIF.Business\mdlCodeMaps.vb`
- `Business\SAIF.Business\ObjectServices.vb`
- `Business\SAIF.Business\PolicyServices.vb`
- `Business\SAIF.Business\UnitStatServices.vb`
- `Business\SAIF.Business\ContactInfo\clsAddress.vb`
- `Business\SAIF.Business\ContactInfo\clsAddressStructure.vb`
- `Business\SAIF.Business\Services\ExternalUserServices.vb`