Solution for RD accounts Linked as Agent Account but not having Agent Details

Solution for RD accounts Linked as Agent Account but not having Agent Details

DPT 7.1 Discrepancies like RD Accounts linked as Agent account but not having agent details. This discrepancy is occurs when closed agents accounts are linked with agent details. It should be removed i.e it should be converted into Individual account. Download the below query and execute to fix the above mentioned issues.

Query 1

Use Post
delete from dcl.accountopen_through_agent
where agentcode not in (select code from post.dcl.institution_details) and scheme='RD')
go

 Query 2

Use Post
delete from dcl.accountopen_through_agent
where agentcode in (select code from post.dcl.institution_details where status='C') and scheme='RD'

1. Take Necessary Backup before executing the above query
2. It should be executed by System Administrator.

Note : Author of Blog / Query developer is not responsible for any data losses / corruption . It should be executed by SA after taking the backup of concerned database(s).