SQL-013: Payment-transaction status checks*¶
This document describes SQL-013, the payment-transaction status checks* statement or call used by SAIF.Business.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-013 |
| Operation type | Read |
| Execution method | Inline |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | Text |
| Business object | ClaimServices |
| Criteria property | N/A |
| Lifecycle method | released/unposted payment helper family |
Parameters¶
This SQL statement has no explicit parameters in the provided findings.
Tables¶
| Table | Access | Columns used |
|---|---|---|
| CL_FINANCIAL_TRANS | SELECT | See sample SQL and source implementation. |
Sample SQL¶
Representative variants:
SELECT COUNT(*) FROM cl_financial_trans WHERE claim_id = :claimID AND benefit_payment_sub_num = :benePaySeqNum AND financial_trans_status_code = 1
SELECT COUNT(*) FROM cl_financial_trans WHERE claim_id = :claimID AND financial_trans_type_code = '1' AND payment_transaction_type_code = 'FA' AND financial_trans_status_code = 1
SELECT COUNT(*) FROM CL_FINANCIAL_TRANS WHERE CLAIM_ID = :claimId AND FINANCIAL_TRANS_STATUS_CODE <> '5'
Operations and processes¶
Note: Statements marked with
*are inferred from code behavior rather than explicit documentation or comments; statements marked with**could not be confirmed and should be treated as unknown until verified.
Sources¶
Business\SAIF.Business\ClaimServices.vb