--- title: SAIF.Business.Imaging database tables summary: Database tables used by this library with relationships and usage context. status: draft owner: last_reviewed: 2026-07-24 library: SAIF.Business.Imaging reference_type: package --- # SAIF.Business.Imaging database tables This page catalogs all database tables accessed by SAIF.Business.Imaging. ## Table catalog | Table | Database | Schema/Link | CRUD | Purpose | Primary business object | | --- | --- | --- | --- | --- | --- | | [CL_INJURY_CLAIM](#cl_injury_claim) | Oracle | [unqualified]** | R | Provides claim context for EAIP period lookups | `clsEAIP` | | [DUAL](#dual) | Oracle | SYS | R | Oracle sequence NEXTVAL generation | `clsImageAffiliation`, `clsImageIdx`, `clsImgsys` | | [EAIP_PERIOD](#eaip_period) | Oracle | [unqualified]** | R | EAIP period records for claim-specialist lookup | `clsEAIP`, `clsEAIPMessages` | | [EAIP_STATUS_CODE](#eaip_status_code) | Oracle | [unqualified]** | R | Code table for EAIP status values | `clsEAIP` | | [IMAGE](#image) | Oracle | [unqualified]** | C/R/U/D | Core image record storage | `clsImageCollection`, `clsImageIdx` | | [IMAGE_AFFILIATION](#image_affiliation) | Oracle | [unqualified]** | C/R/U/D | Associations between images and business entities | `clsImageAffiliation`, `clsImageAffiliationCollection` | | [IMAGE_AGENCY](#image_agency) | Oracle | [unqualified]** | C | Agency sub-records for agency-type images | `clsImageIdx` | | [IMAGE_CATEGORY_CODE](#image_category_code) | Oracle | [unqualified]** | R | Code table for image categories | `clsExternalImageInfo`, `clsImageCategoryCode`, `clsImageCategoryCodeCollection`, `clsImageCollection`, `clsImageIdx` | | [IMAGE_CATEGORY_GCODE](#image_category_gcode) | Oracle | [unqualified]** | R | Culture-specific descriptions for image categories | `clsExternalImageInfo`, `clsImageIdx` | | [IMAGE_DOCUMENT_NAME_CODE](#image_document_name_code) | Oracle | [unqualified]** | C/R/U/D | Code table for image document names | `clsImageCollection`, `clsImageDocumentNameCode` | | [IMAGE_DOCUMENT_NAME_GCODE](#image_document_name_gcode) | Oracle | [unqualified]** | R | Culture-specific descriptions for document names | `clsImageDocumentNameCode` | | [IMAGE_DOCUMENT_TYPE_CODE](#image_document_type_code) | Oracle | [unqualified]** | R | Code table for image document types | `clsExternalImageInfo`, `clsImageCollection`, `clsImageDocumentTypeCode`, `clsImageDocumentTypeCodeCollection`, `clsImageIdx`, `clsImageMsgConst` | | [IMAGE_DOCUMENT_TYPE_GCODE](#image_document_type_gcode) | Oracle | [unqualified]** | R | Culture-specific descriptions for document types | `clsExternalImageInfo`, `clsImageIdx` | | [IMAGE_EAIP](#image_eaip) | Oracle | [unqualified]** | C/D | EAIP sub-records associated with images | `clsImageIdx` | | [IMAGE_FILE_CODE](#image_file_code) | Oracle | [unqualified]** | R | Code table for image file types | `clsExternalImageInfo`, `clsImageFileCode`, `clsImageFileCodeCollection` | | [IMAGE_FILE_EXT_VIEW_UPDATE](#image_file_ext_view_update) | Oracle | [unqualified]** | C/R/U/D | Tracks external view update state per image file | `clsImageFileExternalViewUpdate` | | [IMAGE_GROUP](#image_group) | Oracle | [unqualified]** | C | Group sub-records for group-type images | `clsImageIdx` | | [IMGSYS](#imgsys) | Oracle | [unqualified]** | C/R/U/D | Imaging system records (TOWID owners); batch index state | `clsImageCollection`, `clsImgsys`, `clsIndexBatch`, `clsIndexBatchCollection` | | [PDF_CACHE](#pdf_cache) | Oracle | [unqualified]** | R | PDF cache status for images | `clsImageCollection` | | [PDF_CACHE_REQUEST](#pdf_cache_request) | Oracle | [unqualified]** | R | PDF cache request records | `clsImageCollection` | | [PDF_CACHE_STATUS_CODE](#pdf_cache_status_code) | Oracle | [unqualified]** | R | Code table for PDF cache status values | `clsImageCollection` | --- ## CL_INJURY_CLAIM | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Provides claim context (CLAIM_ID, SAIF_CLAIM_NUM) for EAIP period lookups in `clsEAIP`. | | **Access pattern** | Direct SQL | | **CRUD operations** | Read | | **Key columns used** | CLAIM_ID, SAIF_CLAIM_NUM | | **Sequence** | N/A | | **Related tables** | EAIP_PERIOD, EAIP_STATUS_CODE | | **Business objects** | `clsEAIP` | ### SQL referencing this table - [SQL-013: EAIP period dropdown by claim ID](sql/SQL-013-saif-business-imaging.md) - [SQL-014: EAIP period dropdown by claim number](sql/SQL-014-saif-business-imaging.md) --- ## DUAL | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | SYS | | **Purpose** | Oracle system table used to evaluate NEXTVAL expressions for sequence generation. | | **Access pattern** | Direct SQL | | **CRUD operations** | Read | | **Key columns used** | N/A (sequence expression only) | | **Sequence** | IMAGE_AFFILIATION_SEQ, image_seq, tower.TOWER_SEQ | | **Related tables** | N/A | | **Business objects** | `clsImageAffiliation`, `clsImageIdx`, `clsImgsys` | ### SQL referencing this table - [SQL-001: IMAGE_AFFILIATION_SEQ NEXTVAL](sql/SQL-001-saif-business-imaging.md) - [SQL-002: image_seq NEXTVAL](sql/SQL-002-saif-business-imaging.md) - [SQL-003: tower.TOWER_SEQ NEXTVAL](sql/SQL-003-saif-business-imaging.md) --- ## EAIP_PERIOD | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Records EAIP periods for claims, used to identify the assigned specialist and build EAIP period dropdowns. | | **Access pattern** | Direct SQL | | **CRUD operations** | Read | | **Key columns used** | CLAIM_ID, EAIP_PERIOD_SEQ_NUM, EAIP_PERIOD_EFF_DATE, EAIP_PERIOD_EXP_DATE, EAIP_STATUS_CODE, EAIP_USER | | **Sequence** | N/A | | **Related tables** | CL_INJURY_CLAIM, EAIP_STATUS_CODE | | **Business objects** | `clsEAIP`, `clsEAIPMessages` | ### Business rules referencing this table - [BR-IMG-01: EAIP specialist selection by active/new period status](business-rules.md#br-img-01-eaip-specialist-selection-by-activenew-period-status) ### SQL referencing this table - [SQL-013: EAIP period dropdown by claim ID](sql/SQL-013-saif-business-imaging.md) - [SQL-014: EAIP period dropdown by claim number](sql/SQL-014-saif-business-imaging.md) - [SQL-015: EAIP specialist lookup](sql/SQL-015-saif-business-imaging.md) --- ## EAIP_STATUS_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Code table providing descriptions for EAIP status values (N=New, A=Active, I=Inactive, C=Closed). | | **Access pattern** | Direct SQL | | **CRUD operations** | Read | | **Key columns used** | CODE, CODE_DESCR | | **Sequence** | N/A | | **Related tables** | EAIP_PERIOD | | **Business objects** | `clsEAIP` | ### SQL referencing this table - [SQL-013: EAIP period dropdown by claim ID](sql/SQL-013-saif-business-imaging.md) - [SQL-014: EAIP period dropdown by claim number](sql/SQL-014-saif-business-imaging.md) --- ## IMAGE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Core storage for image metadata records: category, document type/name, file type, claim/policy association, view settings, delete status. | | **Access pattern** | Direct SQL | | **CRUD operations** | Create, Read, Update, Delete | | **Key columns used** | IMAGE_SEQ_NUM, CLAIM_ID, CLAIM_NUM, COMMENT_TEXT, CREATE_DATE, CREATE_USER, DISCOVERY_FLAG, DISPLAY_FIELD_1, DISPLAY_FIELD_2, DISPLAY_FIELD_3, DISPLAY_SORT_NUM, DOCUMENT_DATE, IMAGE_CATEGORY_CODE, IMAGE_DELETE_CODE, IMAGE_DOCUMENT_NAME_CODE, IMAGE_DOCUMENT_TYPE_CODE, IMAGE_FILE_CODE, POLICY_NUM, RECEIVED_DATE, SECURITY_LEVEL_NUM, TOWID, UPDATE_DATE, UPDATE_USER, EXTERNAL_VIEW_CODE, EXTERNAL_VIEW_UPDATE_DATE, SYSTEM_GENERATED_FLAG | | **Sequence** | IMAGE_SEQ (image_seq.nextval) | | **Related tables** | IMGSYS, IMAGE_CATEGORY_CODE, IMAGE_DOCUMENT_TYPE_CODE, IMAGE_DOCUMENT_NAME_CODE, IMAGE_EAIP, IMAGE_AGENCY, IMAGE_GROUP, PDF_CACHE, PDF_CACHE_REQUEST | | **Business objects** | `clsImageCollection`, `clsImageIdx` | ### Operations referencing this table - [Image indexing](operations/image-indexing.md) - [Image collection retrieval](operations/image-collection-retrieval.md) ### SQL referencing this table - [SQL-010: Insert IMAGE row](sql/SQL-010-saif-business-imaging.md) - [SQL-011: Insert IMAGE row without sequence](sql/SQL-011-saif-business-imaging.md) - [SQL-021: Retrieve image collection](sql/SQL-021-saif-business-imaging.md) - [SQL-028: Retrieve single IMAGE record](sql/SQL-028-saif-business-imaging.md) - [SQL-036: Update IMAGE row](sql/SQL-036-saif-business-imaging.md) - [SQL-043: Delete IMAGE row](sql/SQL-043-saif-business-imaging.md) --- ## IMAGE_AFFILIATION | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Records associations between an image and an affiliated business entity. | | **Access pattern** | Direct SQL | | **CRUD operations** | Create, Read, Update, Delete | | **Key columns used** | IMAGE_AFFILIATION_SEQ_NUM, AFFILIATION_IMAGE_SEQ_NUM, CREATE_DATE, CREATE_USER, IMAGE_SEQ_NUM | | **Sequence** | IMAGE_AFFILIATION_SEQ | | **Related tables** | IMAGE | | **Business objects** | `clsImageAffiliation`, `clsImageAffiliationCollection` | ### Operations referencing this table - [Image affiliation](operations/image-affiliation.md) ### SQL referencing this table - [SQL-004: Insert IMAGE_AFFILIATION row](sql/SQL-004-saif-business-imaging.md) - [SQL-017: Retrieve IMAGE_AFFILIATION by sequence](sql/SQL-017-saif-business-imaging.md) - [SQL-018: Retrieve IMAGE_AFFILIATION collection by image](sql/SQL-018-saif-business-imaging.md) - [SQL-033: Update IMAGE_AFFILIATION row](sql/SQL-033-saif-business-imaging.md) - [SQL-039: Delete IMAGE_AFFILIATION row](sql/SQL-039-saif-business-imaging.md) --- ## IMAGE_AGENCY | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Sub-record linking an image to an agency when IMAGE_FILE_CODE = "AGNCY". | | **Access pattern** | Direct SQL | | **CRUD operations** | Create | | **Key columns used** | IMAGE_AGENCY_SEQ_NUM, IMAGE_SEQ_NUM, AGENCY_SEQ_NUM | | **Sequence** | IMAGE_AGENCY_SEQ | | **Related tables** | IMAGE | | **Business objects** | `clsImageIdx` | ### Operations referencing this table - [Image indexing](operations/image-indexing.md) ### SQL referencing this table - [SQL-008: Insert IMAGE_AGENCY row](sql/SQL-008-saif-business-imaging.md) --- ## IMAGE_CATEGORY_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Code table for image categories, providing descriptions and retention schedule codes. | | **Access pattern** | Direct SQL | | **CRUD operations** | Read | | **Key columns used** | CODE, CODE_DESCR, IMAGE_FILE_CODE, RETENTION_SCHEDULE_CODE, CREATE_DATE, CREATE_USER, EXTERNAL_DESCR | | **Sequence** | N/A | | **Related tables** | IMAGE, IMAGE_CATEGORY_GCODE, IMAGE_DOCUMENT_TYPE_CODE | | **Business objects** | `clsExternalImageInfo`, `clsImageCategoryCode`, `clsImageCategoryCodeCollection`, `clsImageCollection`, `clsImageIdx` | ### Operations referencing this table - [Code table management](operations/code-table-management.md) - [Image collection retrieval](operations/image-collection-retrieval.md) ### SQL referencing this table - [SQL-019: Retrieve IMAGE_CATEGORY_CODE by key](sql/SQL-019-saif-business-imaging.md) - [SQL-020: Retrieve all IMAGE_CATEGORY_CODE rows](sql/SQL-020-saif-business-imaging.md) - [SQL-021: Retrieve image collection](sql/SQL-021-saif-business-imaging.md) - [SQL-028: Retrieve single IMAGE record](sql/SQL-028-saif-business-imaging.md) --- ## IMAGE_CATEGORY_GCODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Culture-specific (localized) external descriptions for image categories. | | **Access pattern** | Direct SQL | | **CRUD operations** | Read | | **Key columns used** | CODE, IMAGE_FILE_CODE, CULTURE_CODE, EXTERNAL_DESCR | | **Sequence** | N/A | | **Related tables** | IMAGE_CATEGORY_CODE | | **Business objects** | `clsExternalImageInfo`, `clsImageIdx` | ### SQL referencing this table - [SQL-016: Retrieve external image info](sql/SQL-016-saif-business-imaging.md) - [SQL-028: Retrieve single IMAGE record](sql/SQL-028-saif-business-imaging.md) --- ## IMAGE_DOCUMENT_NAME_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Code table for image document names, providing descriptions and cross-references to file/category/type. | | **Access pattern** | Direct SQL | | **CRUD operations** | Create, Read, Update, Delete | | **Key columns used** | CODE, CODE_DESCR, INTERNAL_DESCR, IMAGE_FILE_CODE, IMAGE_CATEGORY_CODE, IMAGE_DOCUMENT_TYPE_CODE | | **Sequence** | N/A | | **Related tables** | IMAGE, IMAGE_DOCUMENT_NAME_GCODE | | **Business objects** | `clsImageCollection`, `clsImageDocumentNameCode` | ### Operations referencing this table - [Code table management](operations/code-table-management.md) ### SQL referencing this table - [SQL-005: Insert IMAGE_DOCUMENT_NAME_CODE row](sql/SQL-005-saif-business-imaging.md) - [SQL-022: Retrieve IMAGE_DOCUMENT_NAME_CODE by key](sql/SQL-022-saif-business-imaging.md) - [SQL-034: Update IMAGE_DOCUMENT_NAME_CODE row](sql/SQL-034-saif-business-imaging.md) - [SQL-040: Delete IMAGE_DOCUMENT_NAME_CODE row](sql/SQL-040-saif-business-imaging.md) --- ## IMAGE_DOCUMENT_NAME_GCODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Culture-specific descriptions for image document name codes. | | **Access pattern** | Direct SQL | | **CRUD operations** | Read | | **Key columns used** | CODE, CODE_DESCR, CULTURE_CODE | | **Sequence** | N/A | | **Related tables** | IMAGE_DOCUMENT_NAME_CODE | | **Business objects** | `clsImageDocumentNameCode` | ### SQL referencing this table - [SQL-022: Retrieve IMAGE_DOCUMENT_NAME_CODE by key](sql/SQL-022-saif-business-imaging.md) --- ## IMAGE_DOCUMENT_TYPE_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Code table for image document types: effective/expiration dates, default flags, external descriptions, sort order, priority. | | **Access pattern** | Direct SQL | | **CRUD operations** | Read | | **Key columns used** | CODE, CODE_DESCR, CREATE_DATE, CREATE_USER, DEFAULT_DISCOVERY_FLAG, DEFAULT_CONFIDENTIAL_FLAG, DEFAULT_EXTERNAL_VIEW_CODE, EFFECTIVE_DATE, EXPIRATION_DATE, EXTERNAL_DESCR, IMAGE_CATEGORY_CODE, IMAGE_FILE_CODE, PRIORITY_CODE, SORT_ORDER_NUM, UPDATE_DATE, UPDATE_USER | | **Sequence** | N/A | | **Related tables** | IMAGE, IMAGE_CATEGORY_CODE, IMAGE_DOCUMENT_TYPE_GCODE | | **Business objects** | `clsExternalImageInfo`, `clsImageCollection`, `clsImageDocumentTypeCode`, `clsImageDocumentTypeCodeCollection`, `clsImageIdx`, `clsImageMsgConst` | ### Operations referencing this table - [Code table management](operations/code-table-management.md) - [Image collection retrieval](operations/image-collection-retrieval.md) ### SQL referencing this table - [SQL-023: Retrieve IMAGE_DOCUMENT_TYPE_CODE by key](sql/SQL-023-saif-business-imaging.md) - [SQL-024: Retrieve IMAGE_DOCUMENT_TYPE_CODE collection](sql/SQL-024-saif-business-imaging.md) - [SQL-029: Count category/type matches](sql/SQL-029-saif-business-imaging.md) --- ## IMAGE_DOCUMENT_TYPE_GCODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Culture-specific external descriptions for image document types. | | **Access pattern** | Direct SQL | | **CRUD operations** | Read | | **Key columns used** | CODE, IMAGE_FILE_CODE, IMAGE_CATEGORY_CODE, CULTURE_CODE, EXTERNAL_DESCR, EXTERNAL_LONG_DESCR | | **Sequence** | N/A | | **Related tables** | IMAGE_DOCUMENT_TYPE_CODE | | **Business objects** | `clsExternalImageInfo`, `clsImageIdx` | ### SQL referencing this table - [SQL-016: Retrieve external image info](sql/SQL-016-saif-business-imaging.md) - [SQL-028: Retrieve single IMAGE record](sql/SQL-028-saif-business-imaging.md) --- ## IMAGE_EAIP | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Links an image to an EAIP period record when the image is associated with an EAIP claim. | | **Access pattern** | Direct SQL | | **CRUD operations** | Create, Delete | | **Key columns used** | IMAGE_EAIP_SEQ_NUM, IMAGE_SEQ_NUM, CLAIM_ID, EAIP_PERIOD_SEQ_NUM, CLAIM_OPEN_DATE, CREATE_DATE, CREATE_USER | | **Sequence** | IMAGE_EAIP_SEQ | | **Related tables** | IMAGE | | **Business objects** | `clsImageIdx` | ### Operations referencing this table - [Image indexing](operations/image-indexing.md) ### SQL referencing this table - [SQL-007: Insert IMAGE_EAIP row](sql/SQL-007-saif-business-imaging.md) - [SQL-042: Delete IMAGE_EAIP row](sql/SQL-042-saif-business-imaging.md) --- ## IMAGE_FILE_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Code table for image file types, providing code descriptions. | | **Access pattern** | Direct SQL | | **CRUD operations** | Read | | **Key columns used** | CODE, CODE_DESCR, CREATE_DATE, CREATE_USER | | **Sequence** | N/A | | **Related tables** | IMAGE_CATEGORY_CODE, IMAGE_DOCUMENT_TYPE_CODE | | **Business objects** | `clsExternalImageInfo`, `clsImageFileCode`, `clsImageFileCodeCollection` | ### Operations referencing this table - [Code table management](operations/code-table-management.md) ### SQL referencing this table - [SQL-025: Retrieve IMAGE_FILE_CODE by key](sql/SQL-025-saif-business-imaging.md) - [SQL-026: Retrieve all IMAGE_FILE_CODE rows](sql/SQL-026-saif-business-imaging.md) --- ## IMAGE_FILE_EXT_VIEW_UPDATE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Tracks the date and update sequence when an image file's external (portal-facing) view was updated, supporting optimistic concurrency. | | **Access pattern** | Direct SQL | | **CRUD operations** | Create, Read, Update, Delete | | **Key columns used** | IMAGE_FILE_CODE, IMAGE_FILE_KEY, EXTERNAL_VIEW_DATE, UPDATE_NUM, UPDATE_USER, UPDATE_DATE, CREATE_USER, CREATE_DATE | | **Sequence** | N/A | | **Related tables** | N/A | | **Business objects** | `clsImageFileExternalViewUpdate` | ### Operations referencing this table - [External view update tracking](operations/external-view-update-tracking.md) ### SQL referencing this table - [SQL-006: Insert IMAGE_FILE_EXT_VIEW_UPDATE row](sql/SQL-006-saif-business-imaging.md) - [SQL-027: Retrieve IMAGE_FILE_EXT_VIEW_UPDATE row](sql/SQL-027-saif-business-imaging.md) - [SQL-035: Update IMAGE_FILE_EXT_VIEW_UPDATE row](sql/SQL-035-saif-business-imaging.md) - [SQL-041: Delete IMAGE_FILE_EXT_VIEW_UPDATE row](sql/SQL-041-saif-business-imaging.md) --- ## IMAGE_GROUP | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Sub-record linking an image to a group when IMAGE_FILE_CODE = "GROUP". | | **Access pattern** | Direct SQL | | **CRUD operations** | Create | | **Key columns used** | IMAGE_GROUP_SEQ_NUM, IMAGE_SEQ_NUM, GROUP_ASSOCIATION_CODE | | **Sequence** | IMAGE_GROUP_SEQ | | **Related tables** | IMAGE | | **Business objects** | `clsImageIdx` | ### Operations referencing this table - [Image indexing](operations/image-indexing.md) ### SQL referencing this table - [SQL-009: Insert IMAGE_GROUP row](sql/SQL-009-saif-business-imaging.md) --- ## IMGSYS | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Imaging system records that own the TOWID key referenced by IMAGE rows; also stores batch indexing state (BATID, IDXFL, DELCD). | | **Access pattern** | Direct SQL | | **CRUD operations** | Create, Read, Update, Delete | | **Key columns used** | TOWID, BATID, CRTRID, DELCD, IDXFL, IFNDS, IFNID, NPAGES, SCANDT, SLEVEL, UPDRID, UPDTTS | | **Sequence** | tower.TOWER_SEQ | | **Related tables** | IMAGE | | **Business objects** | `clsImageCollection`, `clsImgsys`, `clsIndexBatch`, `clsIndexBatchCollection` | ### Operations referencing this table - [Imaging system management](operations/imaging-system-management.md) - [Image collection retrieval](operations/image-collection-retrieval.md) ### SQL referencing this table - [SQL-012: Insert IMGSYS row](sql/SQL-012-saif-business-imaging.md) - [SQL-021: Retrieve image collection](sql/SQL-021-saif-business-imaging.md) - [SQL-030: Retrieve IMGSYS by TOWID](sql/SQL-030-saif-business-imaging.md) - [SQL-031: Retrieve index batch by batch ID](sql/SQL-031-saif-business-imaging.md) - [SQL-032: Retrieve all active index batches](sql/SQL-032-saif-business-imaging.md) - [SQL-037: Update IMGSYS row](sql/SQL-037-saif-business-imaging.md) - [SQL-038: Update IMGSYS batch scan date](sql/SQL-038-saif-business-imaging.md) - [SQL-044: Soft-delete IMGSYS batch rows](sql/SQL-044-saif-business-imaging.md) --- ## PDF_CACHE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | PDF cache entries for images; joined in image collection query to determine CacheStatus. | | **Access pattern** | Direct SQL | | **CRUD operations** | Read | | **Key columns used** | TOWID | | **Sequence** | N/A | | **Related tables** | IMAGE | | **Business objects** | `clsImageCollection` | ### SQL referencing this table - [SQL-021: Retrieve image collection](sql/SQL-021-saif-business-imaging.md) --- ## PDF_CACHE_REQUEST | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | PDF cache request records; joined in image collection query to determine CacheStatus. | | **Access pattern** | Direct SQL | | **CRUD operations** | Read | | **Key columns used** | TOWID, PDF_CACHE_STATUS_CODE | | **Sequence** | N/A | | **Related tables** | IMAGE, PDF_CACHE_STATUS_CODE | | **Business objects** | `clsImageCollection` | ### SQL referencing this table - [SQL-021: Retrieve image collection](sql/SQL-021-saif-business-imaging.md) --- ## PDF_CACHE_STATUS_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Code table for PDF cache status values; provides CODE_DESCR used in CacheStatus display. | | **Access pattern** | Direct SQL | | **CRUD operations** | Read | | **Key columns used** | CODE, CODE_DESCR | | **Sequence** | N/A | | **Related tables** | PDF_CACHE_REQUEST | | **Business objects** | `clsImageCollection` | ### SQL referencing this table - [SQL-021: Retrieve image collection](sql/SQL-021-saif-business-imaging.md) --- ## Table relationship diagram The following diagram shows the primary table relationships used by this library. ```mermaid erDiagram IMAGE ||--o{ IMAGE_AFFILIATION : "IMAGE_SEQ_NUM" IMAGE ||--o{ IMAGE_EAIP : "IMAGE_SEQ_NUM" IMAGE ||--o{ IMAGE_AGENCY : "IMAGE_SEQ_NUM" IMAGE ||--o{ IMAGE_GROUP : "IMAGE_SEQ_NUM" IMAGE }o--|| IMGSYS : "TOWID" IMAGE }o--|| IMAGE_CATEGORY_CODE : "IMAGE_CATEGORY_CODE + IMAGE_FILE_CODE" IMAGE }o--|| IMAGE_DOCUMENT_TYPE_CODE : "IMAGE_DOCUMENT_TYPE_CODE + IMAGE_CATEGORY_CODE + IMAGE_FILE_CODE" IMAGE_CATEGORY_CODE ||--o{ IMAGE_CATEGORY_GCODE : "CODE + IMAGE_FILE_CODE" IMAGE_DOCUMENT_TYPE_CODE ||--o{ IMAGE_DOCUMENT_TYPE_GCODE : "CODE + IMAGE_FILE_CODE + IMAGE_CATEGORY_CODE" IMAGE_DOCUMENT_NAME_CODE ||--o{ IMAGE_DOCUMENT_NAME_GCODE : "CODE" IMGSYS ||--o{ PDF_CACHE : "TOWID" IMGSYS ||--o{ PDF_CACHE_REQUEST : "TOWID" PDF_CACHE_REQUEST }o--|| PDF_CACHE_STATUS_CODE : "PDF_CACHE_STATUS_CODE" EAIP_PERIOD }o--|| CL_INJURY_CLAIM : "CLAIM_ID" EAIP_PERIOD }o--|| EAIP_STATUS_CODE : "EAIP_STATUS_CODE" ``` ## 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) - [SQL catalog](sql/index.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` - `Business\SAIF.Business.Imaging\app.config`