---
title: "SQL-038: Imaging helper sql/procedure family*"
summary: Imaging helper sql/procedure family*.
status: draft
owner: SAIF
last_reviewed: 2026-07-24
library: SAIF.Business
reference_type: package
---

# SQL-038: Imaging helper sql/procedure family*

This document describes `SQL-038`, the imaging helper sql/procedure family* statement or call used by `SAIF.Business`.

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-038 |
| **Operation type** | Read |
| **Execution method** | Mixed |
| **Database** | Oracle |
| **Schema** | [unqualified]** |
| **Command type** | Text / StoredProcedure |
| **Business object** | `ImageServices` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `alert/media/report helpers` |

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `:inClaimId`, `:outAlertFlag`, `:inPolicyNum`, `:inAuditPeriodStartDate`, `:vreturn` | Mixed | Mixed | 1 / 4000 / N/A | Imaging alert/media/report helpers |

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [RECORDING; procedures only**](../database-tables.md#recording-procedures-only) | SELECT | See sample SQL and source implementation. |

## Sample SQL

```sql
pk80001_LegalNet.AlertLegalCase(:inClaimId, :outAlertFlag)
SELECT COUNT(1) FROM recording rec WHERE rec.recording_system_code = 'CLM' AND delete_flag = 'N' AND rec.claim_id = :inClaimId
pk73101_image.Track_In_Report(:inPolicyNum, :inAuditPeriodStartDate, :vreturn)
pk73101_image.who_was_alerted(:inImageSeqNum, :vreturn)
```

## Operations and processes
- [Imaging lookup and alert support](../operations/imaging-lookup-and-alert-support.md)

## Business rules
- [PROC-RULE-001: Alert recipients are concatenated only while the output buffer remains under 4000 characters.](../business-rules.md#proc-rule-001-alert-recipients-are-concatenated-only-while-the-output-buffer-remains-under-4000-characters)
- [PROC-RULE-002: Missing alert tasks produce an explicit not-found message.](../business-rules.md#proc-rule-002-missing-alert-tasks-produce-an-explicit-not-found-message)
- [PROC-RULE-003: The result message uses singular or plural grammar based on alert count.](../business-rules.md#proc-rule-003-the-result-message-uses-singular-or-plural-grammar-based-on-alert-count)
- [PROC-RULE-004: Claim image alerting is enabled only when at least one flagged legal case exists for the claim.](../business-rules.md#proc-rule-004-claim-image-alerting-is-enabled-only-when-at-least-one-flagged-legal-case-exists-for-the-claim)

> **Note:** Statements marked with `*` were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with `**` could not be confirmed; treat as unknown until verified.

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