---
title: clsImageMsgConst
summary: API reference for clsImageMsgConst.
status: draft
owner: <owner>
last_reviewed: 2026-07-24
library: SAIF.Business.Imaging
reference_type: package
---

# clsImageMsgConst

`clsImageMsgConst` is a constants/helper class that contains SQL and message constants used during image indexing, particularly the `SQL_CAT_TYPE_MISMATCH` validation query.

## Purpose
- Provides the validation SQL that counts `IMAGE_DOCUMENT_TYPE_CODE` rows to confirm a category/type/file combination is valid before saving an image index record.

## Context
- Namespace: `SAIF.Business.Imaging`
- Assembly/package: `SAIF.BOF.Business.Imaging`

## Public members

| Member | Signature | Purpose |
| --- | --- | --- |
| `DEF_IMG_DEL_CODE` | `Public Const DEF_IMG_DEL_CODE As String = "Y"` | Default image delete code. |
| `DEF_IMG_UNDEL_CODE` | `Public Const DEF_IMG_UNDEL_CODE As String = " "` | Default image un-delete code (space). |
| `DEF_DOC_DAYS` | `Public Const DEF_DOC_DAYS As Integer = 0` | Default document date offset for claim images (days). |
| `DEF_DOC_DAYS_IMPORT` | `Public Const DEF_DOC_DAYS_IMPORT As Integer = 7` | Document date offset for auto-import scenarios. |
| `DEF_DOC_DAYS_POLICY` | `Public Const DEF_DOC_DAYS_POLICY As Integer = 458` | Default document date offset for policy images. |
| `DEF_DOC_DAYS_AGENCY` | `Public Const DEF_DOC_DAYS_AGENCY As Integer = 90` | Default document date offset for agency images. |
| `MSG_AFF_AFF_IMG_SEQ_MISSING` | `Public Const MSG_AFF_AFF_IMG_SEQ_MISSING As String = "Error: You must have a AffiliationImageSeqNum."` | Validation error: AffiliationImageSeqNum is required. |
| `MSG_AFF_IMG_SEQ_MISSING` | `Public Const MSG_AFF_IMG_SEQ_MISSING As String = "Error: You must enter a ImageSeqNum."` | Validation error: ImageSeqNum is required. |
| `MSG_REQ_IMAGE_FILE_CODE` | `Public Const MSG_REQ_IMAGE_FILE_CODE As String = "Error: You must enter a Document Type Group."` | Validation error: Document Type Group is required. |
| `MSG_REQ_IMG_DOC_TYP_CODE` | `Public Const MSG_REQ_IMG_DOC_TYP_CODE As String = "Error: The document and sub type must be valid."` | Validation error: document/sub-type must be valid. |
| `MSG_REQ_IMG_CAT_CODE` | `Public Const MSG_REQ_IMG_CAT_CODE As String = "Error: You must enter a Document Type."` | Validation error: Document Type is required. |
| `MSG_REQ_DOC_DATE` | `Public Const MSG_REQ_DOC_DATE As String = "Error: You must enter a Document Date."` | Validation error: Document Date is required. |
| `MSG_DOC_DATE_FUTURE` | `Public Const MSG_DOC_DATE_FUTURE As String = "Error: The Document Date cannot be in the future."` | Validation error: Document Date cannot be in the future. |
| `MSG_DOC_DATE_7DAYS` | `Public Const MSG_DOC_DATE_7DAYS As String = "Error: The Document Date cannot be more than 7 days in the future"` | Validation error: Document Date cannot be more than 7 days in the future. |
| `MSG_DOC_DATE_XDAYS` | `Public Const MSG_DOC_DATE_XDAYS As String = "Error: The Document Date cannot be more than "` | Validation error prefix: Document Date exceeds allowed days (part 1). |
| `MSG_DOC_DATE_XDAYS2` | `Public Const MSG_DOC_DATE_XDAYS2 As String = " in the future."` | Validation error suffix: Document Date exceeds allowed days (part 2). |
| `MSG_CAT_TYPE_MISMATCH` | `Public Const MSG_CAT_TYPE_MISMATCH As String = "Error: The Doc Type must be in the Doc Category."` | Validation error: Doc Type must be in the Doc Category. |
| `MSG_HAS_EAIP_RECORD` | `Public Const MSG_HAS_EAIP_RECORD As String = "Document is being used for EAIP. Contact EAIP to delete document."` | Error: Document is in use by EAIP. |
| `MSG_HAS_EXTERNAL_VIEW_AND_DISCOVERY` | `Public Const MSG_HAS_EXTERNAL_VIEW_AND_DISCOVERY As String = "Error: Non Discoverable documents cannot be externally viewable."` | Error: Non-discoverable documents cannot be externally viewable. |
| `MSG_HAS_EXTERNAL_VIEW_AND_SECURE` | `Public Const MSG_HAS_EXTERNAL_VIEW_AND_SECURE As String = "Error: Secured documents cannot be externally viewable."` | Error: Secured documents cannot be externally viewable. |
| `SQL_IMAGE_PRE_LIMIT_SORT` | `Public Const SQL_IMAGE_PRE_LIMIT_SORT As String = " scandt desc "` | Default pre-limit sort expression for image collection queries. |
| `SQL_DEFAULT_SORT` | `Public Const SQL_DEFAULT_SORT As String = "ImageCategoryCode,ASC,ImageDocumentTypeCode,ASC,DocumentDate,DESC"` | Default sort expression (category/type ascending, date descending). |
| `SQL_CAT_TYPE_MISMATCH` | `Public Const SQL_CAT_TYPE_MISMATCH As String = "Select Count(*) from " & " Image_Document_Type_Code " & "where Code = :ImageDocumentTypeCode " & "and Image_Category_Code = :ImageCategoryCode " & "and Image_File_Code = :ImageFileCode"` | SQL string used to validate that an IMAGE_DOCUMENT_TYPE_CODE row exists for a given type/category/file combination. |
| `CriteriaMode` | `Public Enum CriteriaMode` | Criteria mode values: `Print`, `List`, `Index`, `EAIPList`. |

## Behavioral notes
- `SQL_CAT_TYPE_MISMATCH` is referenced by `clsImageIdx` category/type validation logic and is executed as [SQL-029](../../sql/SQL-029-saif-business-imaging.md).
- A count of zero indicates a mismatch between the category and document type codes*.

## Constraints and usage notes

> **Note:** Statements marked with `*` were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts.

## Sources
- `Business\SAIF.Business.Imaging\clsImageMsgConst.vb`