---
title: SAIF.Business.Imaging SQL catalog
summary: Index of all SQL statements used by this library, grouped by operation type.
status: draft
owner: <owner>
last_reviewed: 2026-07-24
library: SAIF.Business.Imaging
reference_type: package
---

# SAIF.Business.Imaging SQL catalog

This page indexes all SQL statements in this library, grouped by CRUD type. All statements are inline Oracle SQL; no stored procedure calls were found in this library.

## Sequence operations

| SQL ID | Description | Sequence | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-001](SQL-001-saif-business-imaging.md) | Generate IMAGE_AFFILIATION_SEQ_NUM | `IMAGE_AFFILIATION_SEQ` | DUAL | `clsImageAffiliation` |
| [SQL-002](SQL-002-saif-business-imaging.md) | Generate IMAGE_SEQ_NUM | `image_seq` | DUAL | `clsImageIdx` |
| [SQL-003](SQL-003-saif-business-imaging.md) | Generate TOWID from tower.TOWER_SEQ | `tower.TOWER_SEQ` | DUAL | `clsImgsys` |

## Create operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-004](SQL-004-saif-business-imaging.md) | Insert IMAGE_AFFILIATION row | Inline SQL | IMAGE_AFFILIATION | `clsImageAffiliation` |
| [SQL-005](SQL-005-saif-business-imaging.md) | Insert IMAGE_DOCUMENT_NAME_CODE row | Inline SQL | IMAGE_DOCUMENT_NAME_CODE | `clsImageDocumentNameCode` |
| [SQL-006](SQL-006-saif-business-imaging.md) | Insert IMAGE_FILE_EXT_VIEW_UPDATE row | Inline SQL | IMAGE_FILE_EXT_VIEW_UPDATE | `clsImageFileExternalViewUpdate` |
| [SQL-007](SQL-007-saif-business-imaging.md) | Insert IMAGE_EAIP row (conditional on EAIP flag) | Inline SQL | IMAGE_EAIP | `clsImageIdx` |
| [SQL-008](SQL-008-saif-business-imaging.md) | Insert IMAGE_AGENCY row (conditional on AGNCY file code) | Inline SQL | IMAGE_AGENCY | `clsImageIdx` |
| [SQL-009](SQL-009-saif-business-imaging.md) | Insert IMAGE_GROUP row (conditional on GROUP file code) | Inline SQL | IMAGE_GROUP | `clsImageIdx` |
| [SQL-010](SQL-010-saif-business-imaging.md) | Insert IMAGE row (24 parameters) | Inline SQL | IMAGE | `clsImageIdx` |
| [SQL-011](SQL-011-saif-business-imaging.md) | Insert IMAGE row using inline sequence (unreferenced)** | Inline SQL | IMAGE | `clsImageIdx` |
| [SQL-012](SQL-012-saif-business-imaging.md) | Insert IMGSYS row | Inline SQL | IMGSYS | `clsImgsys` |

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-013](SQL-013-saif-business-imaging.md) | EAIP period dropdown by claim ID | Inline SQL | CL_INJURY_CLAIM, EAIP_PERIOD, EAIP_STATUS_CODE | `clsEAIP` |
| [SQL-014](SQL-014-saif-business-imaging.md) | EAIP period dropdown by claim number | Inline SQL | CL_INJURY_CLAIM, EAIP_PERIOD, EAIP_STATUS_CODE | `clsEAIP` |
| [SQL-015](SQL-015-saif-business-imaging.md) | EAIP specialist lookup by claim ID | Inline SQL | EAIP_PERIOD | `clsEAIPMessages` |
| [SQL-016](SQL-016-saif-business-imaging.md) | Retrieve external image info with localized descriptions | Inline SQL | IMAGE_FILE_CODE, IMAGE_CATEGORY_CODE, IMAGE_DOCUMENT_TYPE_CODE, IMAGE_CATEGORY_GCODE, IMAGE_DOCUMENT_TYPE_GCODE | `clsExternalImageInfo` |
| [SQL-017](SQL-017-saif-business-imaging.md) | Retrieve IMAGE_AFFILIATION by sequence | Inline SQL | IMAGE_AFFILIATION | `clsImageAffiliation` |
| [SQL-018](SQL-018-saif-business-imaging.md) | Retrieve IMAGE_AFFILIATION collection by image | Inline SQL | IMAGE_AFFILIATION | `clsImageAffiliationCollection` |
| [SQL-019](SQL-019-saif-business-imaging.md) | Retrieve IMAGE_CATEGORY_CODE by code and file code | Inline SQL | IMAGE_CATEGORY_CODE | `clsImageCategoryCode` |
| [SQL-020](SQL-020-saif-business-imaging.md) | Retrieve all IMAGE_CATEGORY_CODE rows | Inline SQL | IMAGE_CATEGORY_CODE | `clsImageCategoryCodeCollection` |
| [SQL-021](SQL-021-saif-business-imaging.md) | Retrieve image collection (dynamic, up to 300 rows) | Inline SQL (dynamic StringBuilder) | IMGSYS, IMAGE, IMAGE_CATEGORY_CODE, IMAGE_DOCUMENT_TYPE_CODE, IMAGE_DOCUMENT_NAME_CODE, PDF_CACHE, PDF_CACHE_REQUEST, PDF_CACHE_STATUS_CODE | `clsImageCollection` |
| [SQL-022](SQL-022-saif-business-imaging.md) | Retrieve IMAGE_DOCUMENT_NAME_CODE by key (incomplete)** | Inline SQL | IMAGE_DOCUMENT_NAME_CODE, IMAGE_DOCUMENT_NAME_GCODE | `clsImageDocumentNameCode` |
| [SQL-023](SQL-023-saif-business-imaging.md) | Retrieve IMAGE_DOCUMENT_TYPE_CODE by key | Inline SQL | IMAGE_DOCUMENT_TYPE_CODE | `clsImageDocumentTypeCode` |
| [SQL-024](SQL-024-saif-business-imaging.md) | Retrieve IMAGE_DOCUMENT_TYPE_CODE collection | Inline SQL | IMAGE_DOCUMENT_TYPE_CODE | `clsImageDocumentTypeCodeCollection` |
| [SQL-025](SQL-025-saif-business-imaging.md) | Retrieve IMAGE_FILE_CODE by code | Inline SQL | IMAGE_FILE_CODE | `clsImageFileCode` |
| [SQL-026](SQL-026-saif-business-imaging.md) | Retrieve all IMAGE_FILE_CODE rows | Inline SQL | IMAGE_FILE_CODE | `clsImageFileCodeCollection` |
| [SQL-027](SQL-027-saif-business-imaging.md) | Retrieve IMAGE_FILE_EXT_VIEW_UPDATE by key | Inline SQL | IMAGE_FILE_EXT_VIEW_UPDATE | `clsImageFileExternalViewUpdate` |
| [SQL-028](SQL-028-saif-business-imaging.md) | Retrieve single IMAGE record with code descriptions | Inline SQL | IMAGE, IMAGE_CATEGORY_CODE, IMAGE_DOCUMENT_TYPE_CODE, IMAGE_CATEGORY_GCODE, IMAGE_DOCUMENT_TYPE_GCODE | `clsImageIdx` |
| [SQL-029](SQL-029-saif-business-imaging.md) | Count IMAGE_DOCUMENT_TYPE_CODE rows for validation | Inline SQL | IMAGE_DOCUMENT_TYPE_CODE | `clsImageMsgConst` |
| [SQL-030](SQL-030-saif-business-imaging.md) | Retrieve IMGSYS row by TOWID | Inline SQL | IMGSYS | `clsImgsys` |
| [SQL-031](SQL-031-saif-business-imaging.md) | Retrieve index batch summary by batch ID | Inline SQL | IMGSYS | `clsIndexBatch` |
| [SQL-032](SQL-032-saif-business-imaging.md) | Retrieve all active non-indexed batches | Inline SQL | IMGSYS | `clsIndexBatchCollection` |

## Update operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-033](SQL-033-saif-business-imaging.md) | Inline SQL update used by clsImageAffiliation | Inline SQL | IMAGE_AFFILIATION | `clsImageAffiliation` |
| [SQL-034](SQL-034-saif-business-imaging.md) | Inline SQL update used by clsImageDocumentNameCode | Inline SQL | IMAGE_DOCUMENT_NAME_CODE | `clsImageDocumentNameCode` |
| [SQL-035](SQL-035-saif-business-imaging.md) | Inline SQL update used by clsImageFileExternalViewUpdate | Inline SQL | IMAGE_FILE_EXT_VIEW_UPDATE | `clsImageFileExternalViewUpdate` |
| [SQL-036](SQL-036-saif-business-imaging.md) | Inline SQL update used by clsImageIdx | Inline SQL | IMAGE | `clsImageIdx` |
| [SQL-037](SQL-037-saif-business-imaging.md) | Inline SQL update used by clsImgsys | Inline SQL | IMGSYS | `clsImgsys` |
| [SQL-038](SQL-038-saif-business-imaging.md) | Inline SQL update used by clsIndexBatch | Inline SQL | IMGSYS | `clsIndexBatch` |

## Delete operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-039](SQL-039-saif-business-imaging.md) | Inline SQL delete used by clsImageAffiliation | Inline SQL | IMAGE_AFFILIATION | `clsImageAffiliation` |
| [SQL-040](SQL-040-saif-business-imaging.md) | Inline SQL delete used by clsImageDocumentNameCode | Inline SQL | IMAGE_DOCUMENT_NAME_CODE | `clsImageDocumentNameCode` |
| [SQL-041](SQL-041-saif-business-imaging.md) | Inline SQL delete used by clsImageFileExternalViewUpdate | Inline SQL | IMAGE_FILE_EXT_VIEW_UPDATE | `clsImageFileExternalViewUpdate` |
| [SQL-042](SQL-042-saif-business-imaging.md) | Inline SQL delete used by clsImageIdx | Inline SQL | IMAGE_EAIP | `clsImageIdx` |
| [SQL-043](SQL-043-saif-business-imaging.md) | Inline SQL delete used by clsImageIdx | Inline SQL | IMAGE | `clsImageIdx` |
| [SQL-044](SQL-044-saif-business-imaging.md) | Soft-delete IMGSYS batch rows (sets DELCD) | Inline SQL | IMGSYS | `clsIndexBatch` |

## Related documentation
- [Index](../index.md)
- [Overview](../overview.md)
- [Architecture](../architecture.md)
- [Dependencies](../dependencies.md)
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- [Database tables](../database-tables.md)
- [API reference](../api/index.md)
- [Configuration](../configuration.md)

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

## Sources
- `Business\SAIF.Business.Imaging\clsImageAffiliation.vb`
- `Business\SAIF.Business.Imaging\clsImageAffiliationCollection.vb`
- `Business\SAIF.Business.Imaging\clsImageCategoryCode.vb`
- `Business\SAIF.Business.Imaging\clsImageCategoryCodeCollection.vb`
- `Business\SAIF.Business.Imaging\clsImageCollection.vb`
- `Business\SAIF.Business.Imaging\clsImageDocumentNameCode.vb`
- `Business\SAIF.Business.Imaging\clsImageDocumentTypeCode.vb`
- `Business\SAIF.Business.Imaging\clsImageDocumentTypeCodeCollection.vb`
- `Business\SAIF.Business.Imaging\clsImageFileCode.vb`
- `Business\SAIF.Business.Imaging\clsImageFileCodeCollection.vb`
- `Business\SAIF.Business.Imaging\clsImageFileExternalViewUpdate.vb`
- `Business\SAIF.Business.Imaging\clsImageIdx.vb`
- `Business\SAIF.Business.Imaging\clsImgsys.vb`
- `Business\SAIF.Business.Imaging\clsIndexBatch.vb`
- `Business\SAIF.Business.Imaging\clsIndexBatchCollection.vb`
- `Business\SAIF.Business.Imaging\clsEAIP.vb`
- `Business\SAIF.Business.Imaging\clsExternalImageInfo.vb`
- `Business\SAIF.Business.Imaging\clsImageMsgConst.vb`