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.
• 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