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.

Tables

Table	Access	Columns used
ADP_EMPLOYEE	SELECT	USER_ID, EMPLID

Sample SQL

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

Operations and processes

• Claim authorization and visibility checks

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.

Sources

• Business\SAIF.Business\ClaimServices.vb