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**	SELECT	See sample SQL and source implementation.

Sample 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

Business rules

• 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.
• 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.

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