SQL-010 Retrieve all unprocessed 1502 transfers

Retrieves all unprocessed DCBS 1502 transfer rows across claims, ordered by file name, for the transfer sweep.

Classification

Field	Value
SQL ID	SQL-010
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	GetUnprocessedTransferList

Tables

Table	Access	Columns used
CL_1502_DCBS_TRANSFER	SELECT	PROCESSED_DATE, FILE_NAME

Sample SQL

-- Retrieve all unprocessed transfers
select d.*
  from CL_1502_DCBS_TRANSFER d
 where processed_date is null
 order by FILE_NAME

Operations and processes

• DCBS 1502 transfer handling

Sources

• SAIF.Business.Claim/cls1502Transfer.vb