SQL-028: Criteria
This document records the SQL used by Criteria in SAIF.Business.Claim.
Classification
| Field |
Value |
| SQL ID |
SQL-028 |
| Operation type |
Update |
| Execution method |
Inline |
| Database |
Oracle |
| Schema |
CLM_DBA |
| Command type |
Text |
| Business object |
Criteria |
| Criteria property |
UpdateSQL |
| Lifecycle method |
BeforeUpdate |
Parameters
| Parameter |
Direction |
Type |
Max length |
Description |
:Cl1502SeqNum |
Input |
Number |
N/A |
Binds Cl1502SeqNum from active calling code or Oracle signature. |
:ClaimID |
Input |
Number |
N/A |
Binds ClaimID from active calling code or Oracle signature. |
:RequestDate |
Input |
Date |
N/A |
Binds RequestDate from active calling code or Oracle signature. |
:FilingReasonCode |
Input |
String |
N/A |
Binds FilingReasonCode from active calling code or Oracle signature. |
:DocumentTypeCode |
Input |
String |
N/A |
Binds DocumentTypeCode from active calling code or Oracle signature. |
:FileName |
Input |
String |
N/A |
Binds FileName from active calling code or Oracle signature. |
:FileID |
Input |
Number |
N/A |
Binds FileID from active calling code or Oracle signature. |
:ImageSeqNum |
Input |
Number |
N/A |
Binds ImageSeqNum from active calling code or Oracle signature. |
:TOWID |
Input |
Number |
N/A |
Binds TOWID from active calling code or Oracle signature. |
:ProcessedDate |
Input |
Date |
N/A |
Binds ProcessedDate from active calling code or Oracle signature. |
:CreateDate |
Input |
Date |
N/A |
Binds CreateDate from active calling code or Oracle signature. |
:CreateUser |
Input |
String |
N/A |
Binds CreateUser from active calling code or Oracle signature. |
Tables
| Table |
Access |
Columns used |
| CLM_DBA.CL_1502_DCBS_TRANSFER |
UPDATE |
C, CLAIM_ID, CLM_DBA, CL_, CREATE_DATE, CREATE_USER, D, F, FILE_ID, FILE_NAME, I, ID |
Sample SQL
UPDATE CLM_DBA.CL_1502_DCBS_TRANSFER
SET CL_1502_DCBS_TRANSFER_SEQ_NUM = :Cl1502SeqNum, CLAIM_ID = :ClaimID, REQUEST_DATE = :RequestDate, CL_1502_FILING_REASON_CODE = :FilingReasonCode, CL_1502_DOCUMENT_TYPE_CODE = :DocumentTypeCode, FILE_NAME = :FileName, FILE_ID = :FileID, IMAGE_SEQ_NUM = :ImageSeqNum, TOWID = :TOWID, PROCESSED_DATE = :ProcessedDate, CREATE_DATE = :CreateDate, CREATE_USER = :CreateUser
WHERE CL_1502_DCBS_TRANSFER_SEQ_NUM = :Cl1502SeqNum
Sources
Business\SAIF.Business.Claim\cls1502Transfer.vb