---
title: "SQL-002: clsEligPayeeClaimCollection RetrieveSQL stub"
summary: IBusinessCriteria RetrieveSQL property on clsEligPayeeClaimCollection — returns a single-space string literal; no live SQL is executed.
status: draft
owner: <owner>
last_reviewed: 2026-07-24
library: SAIF.Business.Payment
reference_type: package
---

# SQL-002: clsEligPayeeClaimCollection RetrieveSQL stub

`clsEligPayeeClaimCollection.Criteria.RetrieveSQL` returns a single-space string literal. This property satisfies the `IBusinessCriteria` interface contract but does not constitute an executable SQL statement. `BeforeRetrieve` is present but empty, and `AfterRetrieve` returns `Me` without reading any result set. No database request is constructed, no parameters are bound, and no tables are referenced.

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-002 |
| **Operation type** | Read (stub — not executed) |
| **Execution method** | Inline (single-space string literal) |
| **Database** | Oracle-configured at provider level; no statement executed |
| **Schema** | N/A |
| **Command type** | N/A (no request constructed) |
| **Business object** | `clsEligPayeeClaimCollection` |
| **Criteria property** | `RetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` (empty); `AfterRetrieve` returns `Me` |

## Parameters

No parameters exist. `BeforeRetrieve` is empty and contains no `AddParm` or `AddCursorParm` calls.

## Tables

No tables are referenced. This SQL stub does not access the database.

## Sample SQL

```sql
-- clsEligPayeeClaimCollection.Criteria.RetrieveSQL returns a single-space string literal.
-- No executable SQL is present; the value is never sent to the database.
 
```

## Operations and processes
- [Get eligible claim payees](../operations/get-eligible-claim-payees.md)

## Sources
- `Business\SAIF.Business.Payment\clsEligPayeeClaimCollection.vb`