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	Oracle	[unqualified]**	R	Provides claim context for EAIP period lookups	clsEAIP
DUAL	Oracle	SYS	R	Oracle sequence NEXTVAL generation	clsImageAffiliation, clsImageIdx, clsImgsys
EAIP_PERIOD	Oracle	[unqualified]**	R	EAIP period records for claim-specialist lookup	clsEAIP, clsEAIPMessages
EAIP_STATUS_CODE	Oracle	[unqualified]**	R	Code table for EAIP status values	clsEAIP
IMAGE	Oracle	[unqualified]**	C/R/U/D	Core image record storage	clsImageCollection, clsImageIdx
IMAGE_AFFILIATION	Oracle	[unqualified]**	C/R/U/D	Associations between images and business entities	clsImageAffiliation, clsImageAffiliationCollection
IMAGE_AGENCY	Oracle	[unqualified]**	C	Agency sub-records for agency-type images	clsImageIdx
IMAGE_CATEGORY_CODE	Oracle	[unqualified]**	R	Code table for image categories	clsExternalImageInfo, clsImageCategoryCode, clsImageCategoryCodeCollection, clsImageCollection, clsImageIdx
IMAGE_CATEGORY_GCODE	Oracle	[unqualified]**	R	Culture-specific descriptions for image categories	clsExternalImageInfo, clsImageIdx
IMAGE_DOCUMENT_NAME_CODE	Oracle	[unqualified]**	C/R/U/D	Code table for image document names	clsImageCollection, clsImageDocumentNameCode
IMAGE_DOCUMENT_NAME_GCODE	Oracle	[unqualified]**	R	Culture-specific descriptions for document names	clsImageDocumentNameCode
IMAGE_DOCUMENT_TYPE_CODE	Oracle	[unqualified]**	R	Code table for image document types	clsExternalImageInfo, clsImageCollection, clsImageDocumentTypeCode, clsImageDocumentTypeCodeCollection, clsImageIdx, clsImageMsgConst
IMAGE_DOCUMENT_TYPE_GCODE	Oracle	[unqualified]**	R	Culture-specific descriptions for document types	clsExternalImageInfo, clsImageIdx
IMAGE_EAIP	Oracle	[unqualified]**	C/D	EAIP sub-records associated with images	clsImageIdx
IMAGE_FILE_CODE	Oracle	[unqualified]**	R	Code table for image file types	clsExternalImageInfo, clsImageFileCode, clsImageFileCodeCollection
IMAGE_FILE_EXT_VIEW_UPDATE	Oracle	[unqualified]**	C/R/U/D	Tracks external view update state per image file	clsImageFileExternalViewUpdate
IMAGE_GROUP	Oracle	[unqualified]**	C	Group sub-records for group-type images	clsImageIdx
IMGSYS	Oracle	[unqualified]**	C/R/U/D	Imaging system records (TOWID owners); batch index state	clsImageCollection, clsImgsys, clsIndexBatch, clsIndexBatchCollection
PDF_CACHE	Oracle	[unqualified]**	R	PDF cache status for images	clsImageCollection
PDF_CACHE_REQUEST	Oracle	[unqualified]**	R	PDF cache request records	clsImageCollection
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-014: EAIP period dropdown by claim number

---

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-002: image_seq NEXTVAL
• SQL-003: tower.TOWER_SEQ NEXTVAL

---

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

SQL referencing this table

• SQL-013: EAIP period dropdown by claim ID
• SQL-014: EAIP period dropdown by claim number
• SQL-015: EAIP specialist lookup

---

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-014: EAIP period dropdown by claim number

---

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
• Image collection retrieval

SQL referencing this table

• SQL-010: Insert IMAGE row
• SQL-011: Insert IMAGE row without sequence
• SQL-021: Retrieve image collection
• SQL-028: Retrieve single IMAGE record
• SQL-036: Update IMAGE row
• SQL-043: Delete IMAGE row

---

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

SQL referencing this table

• SQL-004: Insert IMAGE_AFFILIATION row
• SQL-017: Retrieve IMAGE_AFFILIATION by sequence
• SQL-018: Retrieve IMAGE_AFFILIATION collection by image
• SQL-033: Update IMAGE_AFFILIATION row
• SQL-039: Delete IMAGE_AFFILIATION row

---

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

SQL referencing this table

• SQL-008: Insert IMAGE_AGENCY row

---

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
• Image collection retrieval

SQL referencing this table

• SQL-019: Retrieve IMAGE_CATEGORY_CODE by key
• SQL-020: Retrieve all IMAGE_CATEGORY_CODE rows
• SQL-021: Retrieve image collection
• SQL-028: Retrieve single IMAGE record

---

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-028: Retrieve single IMAGE record

---

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

SQL referencing this table

• SQL-005: Insert IMAGE_DOCUMENT_NAME_CODE row
• SQL-022: Retrieve IMAGE_DOCUMENT_NAME_CODE by key
• SQL-034: Update IMAGE_DOCUMENT_NAME_CODE row
• SQL-040: Delete IMAGE_DOCUMENT_NAME_CODE row

---

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

---

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
• Image collection retrieval

SQL referencing this table

• SQL-023: Retrieve IMAGE_DOCUMENT_TYPE_CODE by key
• SQL-024: Retrieve IMAGE_DOCUMENT_TYPE_CODE collection
• SQL-029: Count category/type matches

---

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-028: Retrieve single IMAGE record

---

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

SQL referencing this table

• SQL-007: Insert IMAGE_EAIP row
• SQL-042: Delete IMAGE_EAIP row

---

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

SQL referencing this table

• SQL-025: Retrieve IMAGE_FILE_CODE by key
• SQL-026: Retrieve all IMAGE_FILE_CODE rows

---

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

SQL referencing this table

• SQL-006: Insert IMAGE_FILE_EXT_VIEW_UPDATE row
• SQL-027: Retrieve IMAGE_FILE_EXT_VIEW_UPDATE row
• SQL-035: Update IMAGE_FILE_EXT_VIEW_UPDATE row
• SQL-041: Delete IMAGE_FILE_EXT_VIEW_UPDATE row

---

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

SQL referencing this table

• SQL-009: Insert IMAGE_GROUP row

---

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
• Image collection retrieval

SQL referencing this table

• SQL-012: Insert IMGSYS row
• SQL-021: Retrieve image collection
• SQL-030: Retrieve IMGSYS by TOWID
• SQL-031: Retrieve index batch by batch ID
• SQL-032: Retrieve all active index batches
• SQL-037: Update IMGSYS row
• SQL-038: Update IMGSYS batch scan date
• SQL-044: Soft-delete IMGSYS batch rows

---

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

---

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

---

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

---

Table relationship diagram

The following diagram shows the primary table relationships used by this library.

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
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• SQL catalog
• API reference
• Configuration

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