---
title: SAIF.Business.Claim.Authority database tables
summary: Database tables used by SAIF.Business.Claim.Authority.
status: draft
owner: Technical Writer
last_reviewed: 2026-07-28
library: SAIF.Business.Claim.Authority
reference_type: package
---

# SAIF.Business.Claim.Authority database tables

This page catalogs the Oracle tables used by `SAIF.Business.Claim.Authority`.

## Table catalog

| Table | Database | Schema/Link | CRUD | Purpose | Primary business object |
| --- | --- | --- | --- | --- | --- |
| [CL_CLAIM_AUTH_PURPOSE_CODE](#cl_claim_auth_purpose_code) | Oracle | [unqualified]** | R | Supports Criteria data access. | `Criteria` |
| [CL_CLAIM_AUTH_TYPE_CODE](#cl_claim_auth_type_code) | Oracle | [unqualified]** | R | Supports Criteria data access. | `Criteria` |
| [CL_CLAIM_BUS_FUNCTION_CODE](#cl_claim_bus_function_code) | Oracle | [unqualified]** | R | Supports Criteria data access. | `Criteria` |
| [CL_CLAIM_BUS_PROCESS_CODE](#cl_claim_bus_process_code) | Oracle | [unqualified]** | R | Supports Criteria data access. | `Criteria` |
| [CL_CLAIM_EMP_AUTH_TYPE](#cl_claim_emp_auth_type) | Oracle | [unqualified]** | C/D/R/U | Supports Criteria data access. | `Criteria` |
| [CL_CLAIM_EMP_BUS_FUNC_LIMIT](#cl_claim_emp_bus_func_limit) | Oracle | [unqualified]** | C/D/R/U | Supports Criteria data access. | `Criteria` |
| [CL_CLAIM_EMP_CAT_CHANGE_LIMIT](#cl_claim_emp_cat_change_limit) | Oracle | [unqualified]** | C/D/R/U | Supports Criteria data access. | `Criteria` |
| [CL_CLM_EMP_BUS_FUN_LIM_SEQ](#cl_clm_emp_bus_fun_lim_seq) | Oracle | [unqualified]** | R | Supports Criteria data access. | `Criteria` |
| [CL_CLM_EMP_CAT_CHG_LIM_SEQ](#cl_clm_emp_cat_chg_lim_seq) | Oracle | [unqualified]** | R | Supports Criteria data access. | `Criteria` |

## CL_CLAIM_AUTH_PURPOSE_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports `Criteria` data access in `SAIF.Business.Claim.Authority`. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | B, C, CLAIM_BUS_PROCESS_CODE, CL_CLAIM_AUTH_PURPOSE_CODE, CODE, CODE_DESCR, D, F, N, O |
| **Sequence** | N/A |
| **Related tables** | CL_CLAIM_AUTH_PURPOSE_CODE |
| **Business objects** | `Criteria` |

### SQL referencing this table
- [SQL-006](sql/SQL-006-saif-business-claim-authority.md)
- [SQL-007](sql/SQL-007-saif-business-claim-authority.md)

---

## CL_CLAIM_AUTH_TYPE_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports `Criteria` data access in `SAIF.Business.Claim.Authority`. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | C, CL_CLAIM_AUTH_TYPE_CODE, CODE, CODE_DESCR, D, F, N, O, S, U |
| **Sequence** | N/A |
| **Related tables** | CL_CLAIM_AUTH_TYPE_CODE |
| **Business objects** | `Criteria` |

### SQL referencing this table
- [SQL-008](sql/SQL-008-saif-business-claim-authority.md)
- [SQL-009](sql/SQL-009-saif-business-claim-authority.md)

---

## CL_CLAIM_BUS_FUNCTION_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports `Criteria` data access in `SAIF.Business.Claim.Authority`. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | B, C, CLAIM_BUS_PROCESS_CODE, CL_CLAIM_BUS_FUNCTION_CODE, CODE, CODE_DESCR, CODE_LONG_DESCR, D, F, L |
| **Sequence** | N/A |
| **Related tables** | CL_CLAIM_BUS_FUNCTION_CODE |
| **Business objects** | `Criteria` |

### SQL referencing this table
- [SQL-010](sql/SQL-010-saif-business-claim-authority.md)
- [SQL-011](sql/SQL-011-saif-business-claim-authority.md)

---

## CL_CLAIM_BUS_PROCESS_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports `Criteria` data access in `SAIF.Business.Claim.Authority`. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | C, CL_CLAIM_BUS_PROCESS_CODE, CODE, CODE_DESCR, CODE_LONG_DESCR, D, F, L, N, O |
| **Sequence** | N/A |
| **Related tables** | CL_CLAIM_BUS_PROCESS_CODE |
| **Business objects** | `Criteria` |

### SQL referencing this table
- [SQL-012](sql/SQL-012-saif-business-claim-authority.md)
- [SQL-013](sql/SQL-013-saif-business-claim-authority.md)

---

## CL_CLAIM_EMP_AUTH_TYPE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports `Criteria` data access in `SAIF.Business.Claim.Authority`. |
| **Access pattern** | direct SQL |
| **CRUD operations** | C/D/R/U |
| **Key columns used** | A, AND, B, C, CLAIM_AUTH_TYPE_CODE, CLAIM_BUS_PROCESS_CODE, CL_CLAIM_EMP_AUTH_TYPE, D, E, EMPLOYEE_EMPLID |
| **Sequence** | N/A |
| **Related tables** | CL_CLAIM_EMP_AUTH_TYPE |
| **Business objects** | `Criteria` |

### SQL referencing this table
- [SQL-003](sql/SQL-003-saif-business-claim-authority.md)
- [SQL-014](sql/SQL-014-saif-business-claim-authority.md)
- [SQL-018](sql/SQL-018-saif-business-claim-authority.md)
- [SQL-021](sql/SQL-021-saif-business-claim-authority.md)

---

## CL_CLAIM_EMP_BUS_FUNC_LIMIT

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports `Criteria` data access in `SAIF.Business.Claim.Authority`. |
| **Access pattern** | direct SQL |
| **CRUD operations** | C/D/R/U |
| **Key columns used** | A, AND, AS, AUTHORIZED_BY_EMPLID, B, C, CLAIM_AUTH_PURPOSE_CODE, CLAIM_BUS_FUNCTION_CODE, CLAIM_BUS_PROCESS_CODE, CL_CLAIM_EMP_BUS_FUNC_LIMIT |
| **Sequence** | N/A |
| **Related tables** | CL_CLAIM_EMP_BUS_FUNC_LIMIT |
| **Business objects** | `Criteria` |

### SQL referencing this table
- [SQL-004](sql/SQL-004-saif-business-claim-authority.md)
- [SQL-015](sql/SQL-015-saif-business-claim-authority.md)
- [SQL-019](sql/SQL-019-saif-business-claim-authority.md)
- [SQL-022](sql/SQL-022-saif-business-claim-authority.md)

---

## CL_CLAIM_EMP_CAT_CHANGE_LIMIT

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports `Criteria` data access in `SAIF.Business.Claim.Authority`. |
| **Access pattern** | direct SQL |
| **CRUD operations** | C/D/R/U |
| **Key columns used** | A, AS, AUTHORIZED_BY_EMPLID, B, C, CLAIM_AUTH_PURPOSE_CODE, CLAIM_COST_CATEGORY_CODE, CL_CLAIM_EMP_CAT_CHANGE_LIMIT, CL_CLM_EMP_CAT_CHG_LIM_SEQ_NUM, D |
| **Sequence** | N/A |
| **Related tables** | CL_CLAIM_EMP_CAT_CHANGE_LIMIT |
| **Business objects** | `Criteria` |

### SQL referencing this table
- [SQL-005](sql/SQL-005-saif-business-claim-authority.md)
- [SQL-016](sql/SQL-016-saif-business-claim-authority.md)
- [SQL-017](sql/SQL-017-saif-business-claim-authority.md)
- [SQL-020](sql/SQL-020-saif-business-claim-authority.md)
- [SQL-023](sql/SQL-023-saif-business-claim-authority.md)

---

## CL_CLM_EMP_BUS_FUN_LIM_SEQ

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports `Criteria` data access in `SAIF.Business.Claim.Authority`. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | N/A |
| **Sequence** | CL_CLM_EMP_BUS_FUN_LIM_SEQ |
| **Related tables** | N/A |
| **Business objects** | `Criteria` |

---

## CL_CLM_EMP_CAT_CHG_LIM_SEQ

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports `Criteria` data access in `SAIF.Business.Claim.Authority`. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | N/A |
| **Sequence** | CL_CLM_EMP_CAT_CHG_LIM_SEQ |
| **Related tables** | N/A |
| **Business objects** | `Criteria` |

---

## Table relationship diagram

The following diagram shows the relationships identified in this library's SQL.

```mermaid
erDiagram
```

## 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)
- [API reference](api/index.md)

> **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.Claim.Authority\clsClaimEmpBusFuncLimit.vb`
- `Business\SAIF.Business.Claim.Authority\clsClaimEmpCatChangeLimit.vb`
- `Business\SAIF.Business.Claim.Authority\clsClaimEmpAuthType.vb`
- `Business\SAIF.Business.Claim.Authority\clsClaimAuthPurposeCode.vb`
- `Business\SAIF.Business.Claim.Authority\clsClaimAuthPurposeCodeCollection.vb`
- `Business\SAIF.Business.Claim.Authority\clsClaimAuthTypeCode.vb`
- `Business\SAIF.Business.Claim.Authority\clsClaimAuthTypeCodeCollection.vb`
- `Business\SAIF.Business.Claim.Authority\clsClaimBusFunctionCode.vb`
- `Business\SAIF.Business.Claim.Authority\clsClaimBusFunctionCodeCollection.vb`
- `Business\SAIF.Business.Claim.Authority\clsClaimBusProcessCode.vb`
- `Business\SAIF.Business.Claim.Authority\clsClaimBusProcessCodeCollection.vb`
- `Business\SAIF.Business.Claim.Authority\clsClaimEmpBusFuncLimitCollection.vb`
- `Business\SAIF.Business.Claim.Authority\clsClaimEmpCatChangeLimitCollection.vb`
- `Business\SAIF.Business.Claim.Authority\SAIF.BOF.Business.Claim.Authority.vbproj`