SQL-036: PreviousPaidInfo¶

This statement supports PreviousPaidInfo by executing a Read operation through inline.

Classification¶

Field	Value
SQL ID	SQL-036
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`PreviousPaidInfo`
Criteria property	`IssueDate`
Lifecycle method	`—`

Parameters¶

Parameter	Direction	Type	Max length	Description
`—`	—	—	—	No explicit bind parameters were found in the matched caller.

Tables¶

Table	Access	Columns used
CBP_AUDITED_SERVICE_ADJUSTMENT	Read	Not enumerated directly in the stage findings.**

Sample SQL¶

SELECT
    provider_location_seq_num,
    NVL (SUM (audit_adjustment_amt) * -1, 0) audit_adjustment_amt
FROM cbp_audited_service_adjustment, cbp_bill , cbp_audited_service
WHERE
    cbp_bill.claim_id = :ClaimID AND
    cbp_bill.bill_id = cbp_audited_service.bill_id AND
    cbp_bill.bill_id = cbp_audited_service_adjustment.bill_id AND
    cbp_audited_service.audit_seq_num = cbp_audited_service_adjustment.audit_seq_num AND
    cbp_audited_service_adjustment.audit_adjustment_code IN ('DA', 'DB', 'DE') AND
    cbp_audited_service.bill_orig_code <> 'D'
GROUP BY cbp_bill.provider_location_seq_num

Operations and processes¶

PreviousPaidInfo IssueDate

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

Sources¶

Business/SAIF.Business.Claim.Payment/Payments/SettlementPayments/clsDCSPayment.vb