SQL-009 Retrieve unprocessed 1502 transfers for a claim¶

Retrieves DCBS 1502 transfer rows for a specific claim that have not yet been processed.

Classification¶

Field	Value
SQL ID	SQL-009
Operation type	Read
Execution method	Inline SQL (SqlHelper.ResultSetQuery)
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`cls1502Transfer / cls1502TransferList`
Criteria property	`(none — static function)`
Lifecycle method	`GetTransferList`

Parameter	Direction	Type	Max length	Description
`ClaimId`	Input	Decimal	—	Claim filter. Parameter is named ClaimId while the bind variable is :claimID — case mismatch flagged*

Table	Access	Columns used
CL_1502_DCBS_TRANSFER	SELECT	PROCESSED_DATE, CLAIM_ID

-- Retrieve unprocessed transfers for a claim
select *
  from CL_1502_DCBS_TRANSFER
 where processed_date is null
   and claim_id = :claimID