Delete Report IRRBB

mail@pastecode.io avatar
unknown
plain_text
7 months ago
1.5 kB
20
Indexable
Never
delete from mrms.irrbb_depositoRedemptionRate where reportid = 1;
delete from mrms.irrbb_eveAnalysis where reportid = 1;
delete from mrms.irrbb_eveBase where reportid = 1;
delete from mrms.irrbb_eveScenario where reportid = 1;
delete from mrms.irrbb_eveSensitivity where reportid = 1;
delete from mrms.irrbb_loanPrepaymentRate where reportid = 1;
delete from mrms.irrbb_niiScenario where reportid = 1;

delete from mrms.irrbb_niiSensitivityConstantBalanceSheet 
where exists (select 1 from mrms.irrbb_niiSensitivity nii 
where nii.id = mrms.irrbb_niiSensitivityConstantBalanceSheet.NIISensitivityId 
and nii.reportid = 1);

delete from mrms.irrbb_niiSensitivityParallelDown 
where exists (select 1 from mrms.irrbb_niiSensitivity nii 
where nii.id = mrms.irrbb_niiSensitivityParallelDown.NIISensitivityId
and nii.reportid = 1);

delete from mrms.irrbb_niiSensitivityParallelUp
where exists (select 1 from mrms.irrbb_niiSensitivity nii 
where nii.id = mrms.irrbb_niiSensitivityParallelUp.NIISensitivityId
and nii.reportid = 1);

delete from mrms.irrbb_niiSensitivity where reportid = 1
delete from mrms.irrbb_prepaymentRedemption where reportid = 1;
delete from mrms.irrbb_reportOJK where reportid = 1;
delete from mrms.irrbb_reportSummaryEvePerEve where reportid = 1;
delete from mrms.irrbb_reportSummaryNIIPerNII where reportid = 1;
delete from mrms.irrbb_repricingGap where reportid = 1;
delete from mrms.irrbb_scenario where reportid = 1;
delete from mrms.irrbb_report where id = 1;
Leave a Comment