fineract-provider/src/main/resources/sql/migrations/core_db/V155__stretchy_into_pentaho.sql

INSERT INTO stretchy_report (report_name, report_type, report_category, report_sql, description, core_report, use_report)VALUES ("Active Loans - Details(Pentaho)", 'Pentaho', 'Loan', '(NULL)', '(NULL)', 1, 1);
INSERT INTO stretchy_report (report_name, report_type, report_category, report_sql, description, core_report, use_report) VALUES ("Active Loans - Summary(Pentaho)", 'Pentaho', 'Loan', '(NULL)', '(NULL)', 1, 1);
INSERT INTO stretchy_report (report_name, report_type, report_category, report_sql, description, core_report, use_report) VALUES ("Active Loans by Disbursal Period(Pentaho)", 'Pentaho', 'Loan', '(NULL)', '(NULL)', 1, 1);
INSERT INTO stretchy_report (report_name, report_type, report_category, report_sql, description, core_report, use_report) VALUES ("Active Loans in last installment Summary(Pentaho)", 'Pentaho', 'Loan', '(NULL)', '(NULL)', 1, 1);
INSERT INTO stretchy_report (report_name, report_type, report_category, report_sql, description, core_report, use_report)VALUES ("Active Loans in last installment(Pentaho)", 'Pentaho', 'Loan', '(NULL)', '(NULL)', 1, 1);
INSERT INTO stretchy_report (report_name, report_type, report_category, report_sql, description, core_report, use_report) VALUES ("Active Loans Passed Final Maturity Summary(Pentaho)", 'Pentaho', 'Loan', '(NULL)', '(NULL)', 1, 1);
INSERT INTO stretchy_report (report_name, report_type, report_category, report_sql, description, core_report, use_report) VALUES ("Active Loans Passed Final Maturity(Pentaho)", 'Pentaho', 'Loan', '(NULL)', '(NULL)', 1, 1);
INSERT INTO stretchy_report (report_name, report_type, report_category, report_sql, description, core_report, use_report) VALUES ("Aging Detail(Pentaho)", 'Pentaho', 'Loan', '(NULL)', '(NULL)', 1, 1);
INSERT INTO stretchy_report (report_name, report_type, report_category, report_sql, description, core_report, use_report) VALUES ("Aging Summary (Arrears in Months)(Pentaho)", 'Pentaho', 'Loan', '(NULL)', '(NULL)', 1, 1);
INSERT INTO stretchy_report (report_name, report_type, report_category, report_sql, description, core_report, use_report) VALUES ("Aging Summary (Arrears in Weeks)(Pentaho)", 'Pentaho', 'Loan', '(NULL)', '(NULL)', 1, 1);
INSERT INTO stretchy_report (report_name, report_type, report_category, report_sql, description, core_report, use_report) VALUES ("Client Listing(Pentaho)", 'Pentaho', 'Client', '(NULL)', '(NULL)', 1, 1);
INSERT INTO stretchy_report (report_name, report_type, report_category, report_sql, description, core_report, use_report) VALUES ("Client Loans Listing(Pentaho)", 'Pentaho', 'Client', '(NULL)', '(NULL)', 1, 1);
INSERT INTO stretchy_report (report_name, report_type, report_category, report_sql, description, core_report, use_report) VALUES ("Expected Payments By Date - Basic(Pentaho)", 'Pentaho', 'Loan', '(NULL)', '(NULL)', 1, 1);
INSERT INTO stretchy_report (report_name, report_type, report_category, report_sql, description, core_report, use_report) VALUES ("Funds Disbursed Between Dates Summary by Office(Pentaho)", 'Pentaho', 'Fund', '(NULL)', '(NULL)', 1, 1);
INSERT INTO stretchy_report (report_name, report_type, report_category, report_sql, description, core_report, use_report) VALUES ("Funds Disbursed Between Dates Summary(Pentaho)", 'Pentaho', 'Fund', '(NULL)', '(NULL)', 1, 1);
INSERT INTO stretchy_report (report_name, report_type, report_category, report_sql, description, core_report, use_report) VALUES ("Loans Awaiting Disbursal Summary by Month(Pentaho)", 'Pentaho', 'Loan', '(NULL)', '(NULL)', 1, 1);
INSERT INTO stretchy_report (report_name, report_type, report_category, report_sql, description, core_report, use_report) VALUES ("Loans Awaiting Disbursal Summary(Pentaho)", 'Pentaho', 'Loan', '(NULL)', '(NULL)', 1, 1);
INSERT INTO stretchy_report (report_name, report_type, report_category, report_sql, description, core_report, use_report) VALUES ("Loans Awaiting Disbursal(Pentaho)", 'Pentaho', 'Loan', '(NULL)', '(NULL)', 1, 1);
INSERT INTO stretchy_report (report_name, report_type, report_category, report_sql, description, core_report, use_report) VALUES ("Loans Pending Approval(Pentaho)", 'Pentaho', 'Loan', '(NULL)', '(NULL)', 1, 1);
INSERT INTO stretchy_report (report_name, report_type, report_category, report_sql, description, core_report, use_report) VALUES ("Obligation Met Loans Details(Pentaho)", 'Pentaho', 'Loan', '(NULL)', '(NULL)', 1, 1);
INSERT INTO stretchy_report (report_name, report_type, report_category, report_sql, description, core_report, use_report) VALUES ("Obligation Met Loans Summary(Pentaho)", 'Pentaho', 'Loan', '(NULL)', '(NULL)', 1, 1);
INSERT INTO stretchy_report (report_name, report_type, report_category, report_sql, description, core_report, use_report) VALUES ("Portfolio at Risk by Branch(Pentaho)", 'Pentaho', 'Loan', '(NULL)', '(NULL)', 1, 1);
INSERT INTO stretchy_report (report_name, report_type, report_category, report_sql, description, core_report, use_report) VALUES ("Portfolio at Risk(Pentaho)", 'Pentaho', 'Loan', '(NULL)', '(NULL)', 1, 1);
INSERT INTO stretchy_report (report_name, report_type, report_category, report_sql, description, core_report, use_report) VALUES ("Rescheduled Loans(Pentaho)", 'Pentaho', 'Loan', '(NULL)', '(NULL)', 1, 1);
INSERT INTO stretchy_report (report_name, report_type, report_category, report_sql, description, core_report, use_report) VALUES ("TxnRunningBalances(Pentaho)", 'Pentaho', 'Transaction', '(NULL)', '(NULL)', 1, 1);
INSERT INTO stretchy_report (report_name, report_type, report_category, report_sql, description, core_report, use_report) VALUES ("Written-Off Loans(Pentaho)", 'Pentaho', 'Loan', '(NULL)', '(NULL)', 1, 1);

INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name) VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans - Details(Pentaho)'),(select sp.id from stretchy_parameter sp where sp.parameter_name='OfficeIdSelectOne'),'branch');

INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name) VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans - Details(Pentaho)'),(select sp.id from stretchy_parameter sp where sp.parameter_name='loanOfficerIdSelectAll'),
 'loanOfficer');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name) VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans - Details(Pentaho)'),(select sp.id from stretchy_parameter sp where sp.parameter_name='currencyIdSelectAll'),
 'currencyId');
INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name) VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans - Details(Pentaho)'),(select sp.id from stretchy_parameter sp where sp.parameter_name='fundIdSelectAll'),'fundId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name) VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans - Details(Pentaho)'),(select sp.id from stretchy_parameter sp where sp.parameter_name='loanProductIdSelectAll'),
 'loanProductId');
INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name) VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans - Details(Pentaho)'),(select sp.id from stretchy_parameter sp where sp.parameter_name='loanPurposeIdSelectAll'),'loanPurposeId');

INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans - Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='OfficeIdSelectOne'),
 'Branch');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans - Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanOfficerIdSelectAll'),
 'loanOfficer');


 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans - Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='currencyIdSelectAll'),
 'CurrencyId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans - Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='fundIdSelectAll'),
 'fundId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans - Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanProductIdSelectAll'),
 'loanProductId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans - Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanPurposeIdSelectAll'),
 'loanPurposeId');


 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans - Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='parTypeSelect'),
 'parType');

INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans by Disbursal Period(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='OfficeIdSelectOne'),
 'Branch');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans by Disbursal Period(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanOfficerIdSelectAll'),
 'loanOfficer');


 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans by Disbursal Period(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='currencyIdSelectAll'),
 'CurrencyId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans by Disbursal Period(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='fundIdSelectAll'),
 'fundId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans by Disbursal Period(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanProductIdSelectAll'),
 'loanProductId');


 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans by Disbursal Period(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanPurposeIdSelectAll'),
 'loanPurposeId');
 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans by Disbursal Period(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='startDateSelect'),
 'startDate');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans by Disbursal Period(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='endDateSelect'),
 'endDate');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans in last installment Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='OfficeIdSelectOne'),
 'Branch');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans in last installment Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanOfficerIdSelectAll'),
 'Loan Officer');


 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans in last installment Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='currencyIdSelectAll'),
 'CurrencyId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans in last installment Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='fundIdSelectAll'),
 'fundId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans in last installment Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanProductIdSelectAll'),
 'loanProductId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans in last installment Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanPurposeIdSelectAll'),
 'loanPurposeId');


 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans in last installment Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='parTypeSelect'),
 'parType');



 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans in last installment(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='OfficeIdSelectOne'),
 'Branch');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans in last installment(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanOfficerIdSelectAll'),
 'Loan Officer');


 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans in last installment(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='currencyIdSelectAll'),
 'CurrencyId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans in last installment(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='fundIdSelectAll'),
 'fundId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans in last installment(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanProductIdSelectAll'),
 'loanProductId');


 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans in last installment(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanPurposeIdSelectAll'),
 'loanPurposeId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans Passed Final Maturity Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='OfficeIdSelectOne'),
 'Branch');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans Passed Final Maturity Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanOfficerIdSelectAll'),
 'Loan Officer');


 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans Passed Final Maturity Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='currencyIdSelectAll'),
 'CurrencyId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans Passed Final Maturity Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='fundIdSelectAll'),
 'fundId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans Passed Final Maturity Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanProductIdSelectAll'),
 'loanProductId');


 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans Passed Final Maturity Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanPurposeIdSelectAll'),
 'loanPurposeId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans Passed Final Maturity Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='parTypeSelect'),
 'parType');

  INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans Passed Final Maturity(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='OfficeIdSelectOne'),
 'Branch');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans Passed Final Maturity(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanOfficerIdSelectAll'),
 'Loan Officer');


 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans Passed Final Maturity(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='currencyIdSelectAll'),
 'CurrencyId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans Passed Final Maturity(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='fundIdSelectAll'),
 'fundId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans Passed Final Maturity(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanProductIdSelectAll'),
 'loanProductId');


 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Active Loans Passed Final Maturity(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanPurposeIdSelectAll'),
 'loanPurposeId');
 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Aging Detail(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='OfficeIdSelectOne'),
 'Branch');
INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Aging Summary (Arrears in Months)(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='OfficeIdSelectOne'),
 'Branch');
 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Aging Summary (Arrears in Months)(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='currencyIdSelectAll'),
 'CurrencyId');
 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Aging Summary (Arrears in Weeks)(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='OfficeIdSelectOne'),
 'Branch');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Aging Summary (Arrears in Weeks)(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='currencyIdSelectAll'),
 'CurrencyId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Client Listing(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='OfficeIdSelectOne'),
 'selectOffice');
INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Client Loans Listing(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='OfficeIdSelectOne'),
 'Branch');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Client Loans Listing(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanOfficerIdSelectAll'),
 'Loan Officer');


 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Client Loans Listing(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='currencyIdSelectAll'),
 'CurrencyId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Client Loans Listing(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='fundIdSelectAll'),
'fundId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Client Loans Listing(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanProductIdSelectAll'),
 'loanProductId');


 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Client Loans Listing(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanPurposeIdSelectAll'),
 'loanPurposeId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Expected Payments By Date - Basic(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='OfficeIdSelectOne'),
 'Branch');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Expected Payments By Date - Basic(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanOfficerIdSelectAll'),
 'Loan Officer');
 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Expected Payments By Date - Basic(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='startDateSelect'),
 'startDate');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Expected Payments By Date - Basic(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='endDateSelect'),
 'endDate');
 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Funds Disbursed Between Dates Summary by Office(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='OfficeIdSelectOne'),
 'Branch');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Funds Disbursed Between Dates Summary by Office(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='currencyIdSelectAll'),
 'CurrencyId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Funds Disbursed Between Dates Summary by Office(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='fundIdSelectAll'),
 'fundId');
 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Funds Disbursed Between Dates Summary by Office(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='startDateSelect'),
 'startDate');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Funds Disbursed Between Dates Summary by Office(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='endDateSelect'),
 'endDate');
 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Funds Disbursed Between Dates Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='currencyIdSelectAll'),
 'CurrencyId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Funds Disbursed Between Dates Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='fundIdSelectAll'),
 'fundId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Funds Disbursed Between Dates Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='startDateSelect'),
 'startDate');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Funds Disbursed Between Dates Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='endDateSelect'),
 'endDate');
 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Loans Awaiting Disbursal Summary by Month(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='OfficeIdSelectOne'),
 'Branch');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Loans Awaiting Disbursal Summary by Month(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanOfficerIdSelectAll'),
 'Loan Officer');


 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Loans Awaiting Disbursal Summary by Month(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='currencyIdSelectAll'),
 'CurrencyId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Loans Awaiting Disbursal Summary by Month(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='fundIdSelectAll'),
 'fundId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Loans Awaiting Disbursal Summary by Month(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanProductIdSelectAll'),
 'loanProductId');


 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Loans Awaiting Disbursal Summary by Month(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanPurposeIdSelectAll'),
 'loanPurposeId');
 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Loans Awaiting Disbursal Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='OfficeIdSelectOne'),
 'Branch');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Loans Awaiting Disbursal Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanOfficerIdSelectAll'),
 'Loan Officer');


 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Loans Awaiting Disbursal Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='currencyIdSelectAll'),
 'CurrencyId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Loans Awaiting Disbursal Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='fundIdSelectAll'),
 'fundId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Loans Awaiting Disbursal Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanProductIdSelectAll'),
 'loanProductId');


 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Loans Awaiting Disbursal Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanPurposeIdSelectAll'),
 'loanPurposeId');
 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Loans Awaiting Disbursal(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='OfficeIdSelectOne'),
 'Branch');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Loans Awaiting Disbursal(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanOfficerIdSelectAll'),
 'Loan Officer');


 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Loans Awaiting Disbursal(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='currencyIdSelectAll'),
 'CurrencyId');
  INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Loans Awaiting Disbursal(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='fundIdSelectAll'),
 'fundId');
  INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Loans Awaiting Disbursal(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanProductIdSelectAll'),
 'loanProductId');
  INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Loans Awaiting Disbursal(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanPurposeIdSelectAll'),
 'loanPurposeId');
 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Loans Pending Approval(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='OfficeIdSelectOne'),
 'Branch');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Loans Pending Approval(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanOfficerIdSelectAll'),
 'Loan Officer');


 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Loans Pending Approval(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='currencyIdSelectAll'),
 'CurrencyId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Loans Pending Approval(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='fundIdSelectAll'),
 'fundId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Loans Pending Approval(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanProductIdSelectAll'),
 'loanProductId');


 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Loans Pending Approval(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanPurposeIdSelectAll'),
 'loanPurposeId');
 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Obligation Met Loans Details(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='OfficeIdSelectOne'),
 'Branch');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Obligation Met Loans Details(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanOfficerIdSelectAll'),
'Loan Officer');


 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Obligation Met Loans Details(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='currencyIdSelectAll'),
 'CurrencyId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Obligation Met Loans Details(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='fundIdSelectAll'),
 'fundId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Obligation Met Loans Details(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanProductIdSelectAll'),
 'loanProductId');


 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Obligation Met Loans Details(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanPurposeIdSelectAll'),
 'loanPurposeId');
 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Obligation Met Loans Details(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='startDateSelect'),
 'startDate');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Obligation Met Loans Details(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='endDateSelect'),
 'endDate');
 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Obligation Met Loans Details(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='obligDateTypeSelect'),
 'obligDateType');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Obligation Met Loans Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='OfficeIdSelectOne'),
 'Branch');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Obligation Met Loans Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanOfficerIdSelectAll'),
 'Loan Officer');


 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Obligation Met Loans Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='currencyIdSelectAll'),
 'CurrencyId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Obligation Met Loans Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='fundIdSelectAll'),
 'fundId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Obligation Met Loans Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanProductIdSelectAll'),
 'loanProductId');


 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Obligation Met Loans Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanPurposeIdSelectAll'),
 'loanPurposeId');
 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Obligation Met Loans Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='startDateSelect'),
 'Startdate');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Obligation Met Loans Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='endDateSelect'),
 'Enddate');
 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Obligation Met Loans Summary(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='obligDateTypeSelect'),
 'obligDateType');
 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Portfolio at Risk by Branch(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='OfficeIdSelectOne'),
 'Branch');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Portfolio at Risk by Branch(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanOfficerIdSelectAll'),
 'Loan Officer');


 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Portfolio at Risk by Branch(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='currencyIdSelectAll'),
 'CurrencyId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Portfolio at Risk by Branch(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='fundIdSelectAll'),
 'fundId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Portfolio at Risk by Branch(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanProductIdSelectAll'),
 'loanProductId');


 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Portfolio at Risk by Branch(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanPurposeIdSelectAll'),
 'loanPurposeId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Portfolio at Risk by Branch(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='parTypeSelect'),
 'parType');
 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Portfolio at Risk(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='OfficeIdSelectOne'),
 'Branch');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Portfolio at Risk(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanOfficerIdSelectAll'),
 'loanOfficer');


 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Portfolio at Risk(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='currencyIdSelectAll'),
 'CurrencyId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Portfolio at Risk(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='fundIdSelectAll'),
 'fundId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Portfolio at Risk(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanProductIdSelectAll'),
 'loanProductId');
 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Portfolio at Risk(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanPurposeIdSelectAll'),
 'loanPurposeId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Portfolio at Risk(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='parTypeSelect'),
 'parType');
 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Rescheduled Loans(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='OfficeIdSelectOne'),
 'Branch');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Rescheduled Loans(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='currencyIdSelectAll'),
 'CurrencyId');
  INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Rescheduled Loans(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanProductIdSelectAll'),
 'loanProductId');
INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Rescheduled Loans(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='startDateSelect'),
 'startDate');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Rescheduled Loans(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='endDateSelect'),
 'endDate');
INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='TxnRunningBalances(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='OfficeIdSelectOne'),
 'Branch');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='TxnRunningBalances(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanOfficerIdSelectAll'),
 'Loan Officer');
 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='TxnRunningBalances(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='startDateSelect'),
 'startDate');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='TxnRunningBalances(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='endDateSelect'),
 'endDate');
 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Written-Off Loans(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='OfficeIdSelectOne'),
 'Branch');
  INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Written-Off Loans(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='currencyIdSelectAll'),
 'CurrencyId');
 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Written-Off Loans(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='loanProductIdSelectAll'),
 'loanProductId');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Written-Off Loans(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='startDateSelect'),
 'startDate');

 INSERT INTO stretchy_report_parameter (report_id, parameter_id, report_parameter_name)
VALUES ((select sr.id From stretchy_report sr where sr.report_name='Written-Off Loans(Pentaho)'),
 (select sp.id from stretchy_parameter sp where sp.parameter_name='endDateSelect'),
 'endDate');