Skip to content

SQL-020: Criteria

This document records the SQL used by Criteria in SAIF.Business.Claim.Authority.

Classification

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

Parameters

Parameter Direction Type Max length Description
:AuthorizedByEmplid Input Number N/A Binds AuthorizedByEmplid from active calling code or Oracle signature.
:ClaimAuthPurposeCode Input String N/A Binds ClaimAuthPurposeCode from active calling code or Oracle signature.
:ClaimCostCategoryCode Input String N/A Binds ClaimCostCategoryCode from active calling code or Oracle signature.
:EmployeeEmplid Input Number N/A Binds EmployeeEmplid from active calling code or Oracle signature.
:ExpDate Input Date N/A Binds ExpDate from active calling code or Oracle signature.
:MaxChangeAmount Input Number N/A Binds MaxChangeAmount from active calling code or Oracle signature.
:UpdateUser Input Date N/A Binds UpdateUser from active calling code or Oracle signature.
:EmpCatChgLimitSeqNum Input Number N/A Binds EmpCatChgLimitSeqNum from active calling code or Oracle signature.
:UpdateNum Input Date N/A Binds UpdateNum from active calling code or Oracle signature.

Tables

Table Access Columns used
CL_CLAIM_EMP_CAT_CHANGE_LIMIT UPDATE A, AUTHORIZED_BY_EMPLID, B, C, CLAIM_AUTH_PURPOSE_CODE, CLAIM_COST_CATEGORY_CODE, CL_CLAIM_EMP_CAT_CHANGE_LIMIT, CL_CLM_EMP_CAT_CHG_LIM_SEQ_NUM, D, E, EMPLOYEE_EMPLID, EXP_DATE

Sample SQL

Update CL_CLAIM_EMP_CAT_CHANGE_LIMIT 
SET AUTHORIZED_BY_EMPLID = :AuthorizedByEmplid, CLAIM_AUTH_PURPOSE_CODE = :ClaimAuthPurposeCode, CLAIM_COST_CATEGORY_CODE = :ClaimCostCategoryCode, EMPLOYEE_EMPLID = :EmployeeEmplid, EXP_DATE = :ExpDate, MAX_CHANGE_AMOUNT = :MaxChangeAmount, UPDATE_DATE = SYSDATE, UPDATE_NUM = UPDATE_NUM + 1, UPDATE_USER = :UpdateUser 
WHERE CL_CLM_EMP_CAT_CHG_LIM_SEQ_NUM = :EmpCatChgLimitSeqNum 
  AND UPDATE_NUM = :UpdateNum

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

  • Business\SAIF.Business.Claim.Authority\clsClaimEmpCatChangeLimit.vb