SQL-014: Override-security lookup¶

This document describes SQL-014, the override-security lookup statement or call used by SAIF.Business.

Classification¶

Field	Value
SQL ID	SQL-014
Operation type	Read
Execution method	Inline
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`ClaimServices`
Criteria property	`N/A`
Lifecycle method	`HasOverrideAcess`

Parameters¶

This SQL statement has no explicit parameters in the provided findings.

Tables¶

Table	Access	Columns used
CL_SECURITY_OVERRIDE	SELECT	See sample SQL and source implementation.
ADP_VIRTUAL_EMPLOYEE_VIEW	SELECT	See sample SQL and source implementation.

Sample SQL¶

SELECT COUNT(*)
  FROM cl_security_override so,
       ADP_VIRTUAL_EMPLOYEE_VIEW emp
 WHERE so.emplid = emp.emplid
   AND emp.user_id = :MailID
   AND SYSDATE BETWEEN so.eff_date AND so.exp_date + 1
   AND so.claim_id = :ClaimID

Operations and processes¶

Claim authorization and visibility checks

Note: Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources¶

Business\SAIF.Business\ClaimServices.vb