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 | Generate IMAGE_AFFILIATION_SEQ_NUM | IMAGE_AFFILIATION_SEQ |
DUAL | clsImageAffiliation |
| SQL-002 | Generate IMAGE_SEQ_NUM | image_seq |
DUAL | clsImageIdx |
| SQL-003 | Generate TOWID from tower.TOWER_SEQ | tower.TOWER_SEQ |
DUAL | clsImgsys |
Create operations¶
| SQL ID | Description | Type | Tables | Business object |
|---|---|---|---|---|
| SQL-004 | Insert IMAGE_AFFILIATION row | Inline SQL | IMAGE_AFFILIATION | clsImageAffiliation |
| SQL-005 | Insert IMAGE_DOCUMENT_NAME_CODE row | Inline SQL | IMAGE_DOCUMENT_NAME_CODE | clsImageDocumentNameCode |
| SQL-006 | Insert IMAGE_FILE_EXT_VIEW_UPDATE row | Inline SQL | IMAGE_FILE_EXT_VIEW_UPDATE | clsImageFileExternalViewUpdate |
| SQL-007 | Insert IMAGE_EAIP row (conditional on EAIP flag) | Inline SQL | IMAGE_EAIP | clsImageIdx |
| SQL-008 | Insert IMAGE_AGENCY row (conditional on AGNCY file code) | Inline SQL | IMAGE_AGENCY | clsImageIdx |
| SQL-009 | Insert IMAGE_GROUP row (conditional on GROUP file code) | Inline SQL | IMAGE_GROUP | clsImageIdx |
| SQL-010 | Insert IMAGE row (24 parameters) | Inline SQL | IMAGE | clsImageIdx |
| SQL-011 | Insert IMAGE row using inline sequence (unreferenced)** | Inline SQL | IMAGE | clsImageIdx |
| SQL-012 | Insert IMGSYS row | Inline SQL | IMGSYS | clsImgsys |
Read operations¶
| SQL ID | Description | Type | Tables | Business object |
|---|---|---|---|---|
| SQL-013 | EAIP period dropdown by claim ID | Inline SQL | CL_INJURY_CLAIM, EAIP_PERIOD, EAIP_STATUS_CODE | clsEAIP |
| SQL-014 | EAIP period dropdown by claim number | Inline SQL | CL_INJURY_CLAIM, EAIP_PERIOD, EAIP_STATUS_CODE | clsEAIP |
| SQL-015 | EAIP specialist lookup by claim ID | Inline SQL | EAIP_PERIOD | clsEAIPMessages |
| SQL-016 | 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 | Retrieve IMAGE_AFFILIATION by sequence | Inline SQL | IMAGE_AFFILIATION | clsImageAffiliation |
| SQL-018 | Retrieve IMAGE_AFFILIATION collection by image | Inline SQL | IMAGE_AFFILIATION | clsImageAffiliationCollection |
| SQL-019 | Retrieve IMAGE_CATEGORY_CODE by code and file code | Inline SQL | IMAGE_CATEGORY_CODE | clsImageCategoryCode |
| SQL-020 | Retrieve all IMAGE_CATEGORY_CODE rows | Inline SQL | IMAGE_CATEGORY_CODE | clsImageCategoryCodeCollection |
| SQL-021 | 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 | Retrieve IMAGE_DOCUMENT_NAME_CODE by key (incomplete)** | Inline SQL | IMAGE_DOCUMENT_NAME_CODE, IMAGE_DOCUMENT_NAME_GCODE | clsImageDocumentNameCode |
| SQL-023 | Retrieve IMAGE_DOCUMENT_TYPE_CODE by key | Inline SQL | IMAGE_DOCUMENT_TYPE_CODE | clsImageDocumentTypeCode |
| SQL-024 | Retrieve IMAGE_DOCUMENT_TYPE_CODE collection | Inline SQL | IMAGE_DOCUMENT_TYPE_CODE | clsImageDocumentTypeCodeCollection |
| SQL-025 | Retrieve IMAGE_FILE_CODE by code | Inline SQL | IMAGE_FILE_CODE | clsImageFileCode |
| SQL-026 | Retrieve all IMAGE_FILE_CODE rows | Inline SQL | IMAGE_FILE_CODE | clsImageFileCodeCollection |
| SQL-027 | Retrieve IMAGE_FILE_EXT_VIEW_UPDATE by key | Inline SQL | IMAGE_FILE_EXT_VIEW_UPDATE | clsImageFileExternalViewUpdate |
| SQL-028 | 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 | Count IMAGE_DOCUMENT_TYPE_CODE rows for validation | Inline SQL | IMAGE_DOCUMENT_TYPE_CODE | clsImageMsgConst |
| SQL-030 | Retrieve IMGSYS row by TOWID | Inline SQL | IMGSYS | clsImgsys |
| SQL-031 | Retrieve index batch summary by batch ID | Inline SQL | IMGSYS | clsIndexBatch |
| SQL-032 | Retrieve all active non-indexed batches | Inline SQL | IMGSYS | clsIndexBatchCollection |
Update operations¶
| SQL ID | Description | Type | Tables | Business object |
|---|---|---|---|---|
| SQL-033 | Inline SQL update used by clsImageAffiliation | Inline SQL | IMAGE_AFFILIATION | clsImageAffiliation |
| SQL-034 | Inline SQL update used by clsImageDocumentNameCode | Inline SQL | IMAGE_DOCUMENT_NAME_CODE | clsImageDocumentNameCode |
| SQL-035 | Inline SQL update used by clsImageFileExternalViewUpdate | Inline SQL | IMAGE_FILE_EXT_VIEW_UPDATE | clsImageFileExternalViewUpdate |
| SQL-036 | Inline SQL update used by clsImageIdx | Inline SQL | IMAGE | clsImageIdx |
| SQL-037 | Inline SQL update used by clsImgsys | Inline SQL | IMGSYS | clsImgsys |
| SQL-038 | Inline SQL update used by clsIndexBatch | Inline SQL | IMGSYS | clsIndexBatch |
Delete operations¶
| SQL ID | Description | Type | Tables | Business object |
|---|---|---|---|---|
| SQL-039 | Inline SQL delete used by clsImageAffiliation | Inline SQL | IMAGE_AFFILIATION | clsImageAffiliation |
| SQL-040 | Inline SQL delete used by clsImageDocumentNameCode | Inline SQL | IMAGE_DOCUMENT_NAME_CODE | clsImageDocumentNameCode |
| SQL-041 | Inline SQL delete used by clsImageFileExternalViewUpdate | Inline SQL | IMAGE_FILE_EXT_VIEW_UPDATE | clsImageFileExternalViewUpdate |
| SQL-042 | Inline SQL delete used by clsImageIdx | Inline SQL | IMAGE_EAIP | clsImageIdx |
| SQL-043 | Inline SQL delete used by clsImageIdx | Inline SQL | IMAGE | clsImageIdx |
| SQL-044 | Soft-delete IMGSYS batch rows (sets DELCD) | Inline SQL | IMGSYS | clsIndexBatch |
Related documentation¶
- Index
- Overview
- Architecture
- Dependencies
- Operations and processes
- Business rules
- Database tables
- API reference
- Configuration
Note: Statements marked with
**could not be confirmed; treat as unknown until verified.
Sources¶
Business\SAIF.Business.Imaging\clsImageAffiliation.vbBusiness\SAIF.Business.Imaging\clsImageAffiliationCollection.vbBusiness\SAIF.Business.Imaging\clsImageCategoryCode.vbBusiness\SAIF.Business.Imaging\clsImageCategoryCodeCollection.vbBusiness\SAIF.Business.Imaging\clsImageCollection.vbBusiness\SAIF.Business.Imaging\clsImageDocumentNameCode.vbBusiness\SAIF.Business.Imaging\clsImageDocumentTypeCode.vbBusiness\SAIF.Business.Imaging\clsImageDocumentTypeCodeCollection.vbBusiness\SAIF.Business.Imaging\clsImageFileCode.vbBusiness\SAIF.Business.Imaging\clsImageFileCodeCollection.vbBusiness\SAIF.Business.Imaging\clsImageFileExternalViewUpdate.vbBusiness\SAIF.Business.Imaging\clsImageIdx.vbBusiness\SAIF.Business.Imaging\clsImgsys.vbBusiness\SAIF.Business.Imaging\clsIndexBatch.vbBusiness\SAIF.Business.Imaging\clsIndexBatchCollection.vbBusiness\SAIF.Business.Imaging\clsEAIP.vbBusiness\SAIF.Business.Imaging\clsExternalImageInfo.vbBusiness\SAIF.Business.Imaging\clsImageMsgConst.vb