---
title: "SQL-018: Sp82348 claim authorization"
summary: Sp82348 claim authorization.
status: draft
owner: SAIF
last_reviewed: 2026-07-24
library: SAIF.Business
reference_type: package
---

# SQL-018: Sp82348 claim authorization

This document describes `SQL-018`, the sp82348 claim authorization statement or call used by `SAIF.Business`.

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-018 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `WCIS_DBA` |
| **Command type** | StoredProcedure |
| **Business object** | `ClaimServices` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `HasAuthorization` |

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `:inMailid` | Input | Varchar2 | 30 | Employee mail ID to authorize. |`r`n| `:inBusProcess` | Input | Varchar2 | N/A | Claim business-process code to authorize. |`r`n| `:inAuthPurpose` | Input | Varchar2 | N/A | Claim authorization-purpose code to authorize. |`r`n| `:inFunction` | Input | Varchar2 | N/A | Claim business-function code to authorize. |`r`n| `:inAmount` | Input | Number | N/A | Requested amount checked against `MAX_AMOUNT`. |`r`n| `:outCount` | InputOutput | Number | N/A | Returned count of qualifying authorization rows. |

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [ADP_EMPLOYEE](../database-tables.md#adp-employee) | SELECT | `USER_ID`, `EMPLID` |`r`n| [CL_CLAIM_EMP_BUS_FUNC_LIMIT](../database-tables.md#cl-claim-emp-bus-func-limit) | JOIN | `EMPLOYEE_EMPLID`, `CLAIM_BUS_PROCESS_CODE`, `CLAIM_AUTH_PURPOSE_CODE`, `CLAIM_BUS_FUNCTION_CODE`, `MAX_AMOUNT` |

## Sample SQL

```sql
sp82348_claim_authorization(:inMailid, :inBusProcess, :inAuthPurpose, :inFunction, :inAmount, :outCount)
```

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

## Business rules
- [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)

## Sources
- `Business\SAIF.Business\ClaimServices.vb`