SQL-044: Pharmacy-eligibility update¶

This document describes SQL-044, the pharmacy-eligibility update statement or call used by SAIF.Business.

Classification¶

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

Parameters¶

Parameter	Direction	Type	Max length	Description
`:ClaimID`, `:UpdateUser`	Input	Decimal / String	30	Pharmacy eligibility update

Tables¶

Table	Access	Columns used
CL_PHARMACY_ELIGIBILITY_REPORT	UPDATE	See sample SQL and source implementation.

Sample SQL¶

UPDATE CL_PHARMACY_ELIGIBILITY_REPORT SET ELIGIBILITY_STATUS_CODE = 'I', ELIGIBILITY_EFF_DATE = TRUNC(SYSDATE), UPDATE_DATE = SYSDATE, UPDATE_NUM = UPDATE_NUM + 1, UPDATE_USER = :UpdateUser WHERE CLAIM_ID = :ClaimID AND ELIGIBILITY_STATUS_CODE <> 'I'

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