SQL-036: clsImageIdx¶

This statement updates an existing IMAGE row with 22 bound parameters. UPDATE_DATE is set to Oracle sysdate. AfterUpdate verifies exactly one row affected. A conditional companion data request updating the EAIP association is also executed by BeforeUpdate when EAIP context is present.

Classification¶

Field	Value
SQL ID	SQL-036
Operation type	Update
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text**
Business object	`clsImageIdx`
Criteria property	`UpdateSQL`
Lifecycle method	`BeforeUpdate`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:ClaimID`	Input	[not specified]**	N/A	Claim ID.
`:ClaimNum`	Input	[not specified]**	8	SAIF claim number.
`:CommentText`	Input	[not specified]**	256	Comment text.
`:DiscoveryFlag`	Input	[not specified]**	1	Discovery flag.
`:DisplayField1`	Input	[not specified]**	256	Display field 1.
`:DisplayField2`	Input	[not specified]**	256	Display field 2.
`:DisplayField3`	Input	[not specified]**	256	Display field 3.
`:DisplaySortNum`	Input	[not specified]**	N/A	Display sort number.
`:DocumentDate`	Input	[not specified]**	N/A	Document date.
`:ImageCategoryCode`	Input	[not specified]**	5	Image category code.
`:ImageDeleteCode`	Input	[not specified]**	5	Image delete code.
`:ImageDocumentNameCode`	Input	[not specified]**	5	Document name code.
`:ImageDocumentTypeCode`	Input	[not specified]**	5	Document type code.
`:ImageFileCode`	Input	[not specified]**	5	File type code.
`:PolicyNum`	Input	[not specified]**	N/A	Policy number.
`:ReceivedDate`	Input	[not specified]**	N/A	Received date.
`:SecurityLevelNum`	Input	[not specified]**	N/A	Security level number.
`:UpdateUser`	Input	[not specified]**	30	User ID of the updater.
`:ExternalViewCode`	Input	[not specified]**	5	External view code.
`:ExternalViewUpdateDate`	Input	[not specified]**	N/A	External view update date.
`:SystemGeneratedFlag`	Input	[not specified]**	1	System-generated flag.
`:ImageSeqNum`	Input	[not specified]**	N/A	Primary key (WHERE clause).

Tables¶

Table	Access	Columns used
IMAGE	UPDATE	CLAIM_ID, CLAIM_NUM, COMMENT_TEXT, DISCOVERY_FLAG, DISPLAY_FIELD_1–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, UPDATE_DATE, EXTERNAL_VIEW_CODE, EXTERNAL_VIEW_UPDATE_DATE, SYSTEM_GENERATED_FLAG, UPDATE_USER (WHERE: IMAGE_SEQ_NUM)

Sample SQL¶

Update IMAGE
Set
    CLAIM_ID = :ClaimID,
    CLAIM_NUM = :ClaimNum,
    COMMENT_TEXT = :CommentText,
    DISCOVERY_FLAG = :DiscoveryFlag,
    DISPLAY_FIELD_1 = :DisplayField1,
    DISPLAY_FIELD_2 = :DisplayField2,
    DISPLAY_FIELD_3 = :DisplayField3,
    DISPLAY_SORT_NUM = :DisplaySortNum,
    DOCUMENT_DATE = :DocumentDate,
    IMAGE_CATEGORY_CODE = :ImageCategoryCode,
    IMAGE_DELETE_CODE = :ImageDeleteCode,
    IMAGE_DOCUMENT_NAME_CODE = :ImageDocumentNameCode,
    IMAGE_DOCUMENT_TYPE_CODE = :ImageDocumentTypeCode,
    IMAGE_FILE_CODE = :ImageFileCode,
    POLICY_NUM = :PolicyNum,
    RECEIVED_DATE = :ReceivedDate,
    SECURITY_LEVEL_NUM = :SecurityLevelNum,
    UPDATE_DATE = sysdate,
    EXTERNAL_VIEW_CODE = :ExternalViewCode,
    EXTERNAL_VIEW_UPDATE_DATE = :ExternalViewUpdateDate,
    SYSTEM_GENERATED_FLAG = :SystemGeneratedFlag,
    UPDATE_USER = :UpdateUser
Where IMAGE.IMAGE_SEQ_NUM = :ImageSeqNum

Operations and processes¶

Image indexing

Note: Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources¶

Business\SAIF.Business.Imaging\clsImageIdx.vb