 DECLARE  _output_json	json;
 BEGIN	
 	RAISE NOTICE 'insert Trends in Project Entry and Exit Data Entry Timeliness for Selected Projects';
-	_output_json := (SELECT * FROM report_manager_schema.action_enter_edit_reports ('{"report_name": "Trends in Project Entry and Exit Data Entry Timeliness for Selected Projects", "description": "The Trends in Project Entry and Exit Data Entry Timeliness for Selected Projects report shows the monthly trends in the data entry timeliness for the selected programs over a seleted time period. These trends help program managers improve the timeliness of their program''s data entry. The report shows the monthlhy trend in the percent of the admission or discharge records entered within the defined data entry standard, the maximum data entry lag, and the average data entry lag for the admission and discharge records. Its start_dt and end_dt parameters define the selected time period. Its in_specified_programs parameter is a comma delimited list of the program_ids of the selected programs.", "url": "http://192.168.4.10:8080/WebViewerExample/frameset?__report=timeliness_monthly_trend_by_program.rptdesign", "containing_folder_name": "coc_data_quality_reports", "insert_or_update": "insert", "changing_user_login": "muser", "parameters": [{"parameter_name": "ReportStartDate"}, {"parameter_name": "ReportEndDate"}, {"parameter_name": "ProgramIds"}]}'));
+	_output_json := (SELECT * FROM report_manager_schema.action_enter_edit_reports ('{"report_name": "Trends in Project Entry and Exit Data Entry Timeliness for Selected Projects", "description": "The Trends in Project Entry and Exit Data Entry Timeliness for Selected Projects report shows the monthly trends in the data entry timeliness for the selected programs over a seleted time period. These trends help program managers improve the timeliness of their program''s data entry. The report shows the monthlhy trend in the percent of the admission or discharge records entered within the defined data entry standard, the maximum data entry lag, and the average data entry lag for the admission and discharge records.", "url": "http://192.168.4.10:8080/WebViewerExample/frameset?__report=timeliness_monthly_trend_by_program.rptdesign", "containing_folder_name": "data_quality_reports_for_selected_programs", "insert_or_update": "insert", "changing_user_login": "muser", "parameters": [{"parameter_name": "ReportStartDate"}, {"parameter_name": "ReportEndDate"}, {"parameter_name": "ProgramIds"}]}'));
+	RAISE NOTICE 'Result = %', (SELECT _output_json ->> 'result_indicator')::text;
+END$$;
+
+DO $$
+DECLARE  _output_json	json;
+BEGIN	
+	RAISE NOTICE 'insert Agency Duplicated Households';
+	_output_json := (SELECT * FROM report_manager_schema.action_enter_edit_reports ('{"report_name": "Agency Duplicated Households", "description": "This report lists the clients in duplicated households participating in an agency''s housing programs over a selected time period.", "url": "http://192.168.4.10:8080/WebViewerExample/frameset?__report=agency_duplicates.rptdesign", "containing_folder_name": "data_quality_reports_for_selected_programs", "insert_or_update": "insert", "changing_user_login": "muser", "parameters": [{"parameter_name": "ReportStartDate"}, {"parameter_name": "ReportEndDate"}, {"parameter_name": "AgencyName"}]}'));
 	RAISE NOTICE 'Result = %', (SELECT _output_json ->> 'result_indicator')::text;
 END$$;
 

DECLARE  _output_json	json;
BEGIN	
	RAISE NOTICE 'insert Monthly Housing Unit Occupancy for Selected Programs';
	_output_json := (SELECT * FROM report_manager_schema.action_enter_edit_reports ('{"report_name": "Monthly Housing Unit Occupancy for Selected Programs", "description": "This report presents the total, individual, and family unit occupancies for each month over a selected time period for one or more selected programs. The starting date and the ending date of the time period, and the program ids for the selected programs must be entered when calling the report.", "url": "http://192.168.4.10:8080/WebViewerExample/frameset?__report=housing_monthly_unit_occupancy_by_program.rptdesign", "containing_folder_name": "generic_program_data", "insert_or_update": "insert", "changing_user_login": "muser", "parameters": [{"parameter_name": "ReportStartDate"}, {"parameter_name": "ReportEndDate"}, {"parameter_name": "ProgramIds"}]}'));
	RAISE NOTICE 'Result = %', (SELECT _output_json ->> 'result_indicator')::text;
END$$;


DECLARE  _output_json	json;
BEGIN	
	RAISE NOTICE 'insert Data Quality Error Details Version 5.2';
	_output_json := (SELECT * FROM report_manager_schema.action_enter_edit_reports ('{"report_name": "Data Quality Error Details Version 5.2", "description": "The Data Quality Error Details Version 5.2 report lists all the clients active in the selected programs during the selected time period with data quality errors in the HUD defined Universal Data Elements (UDE) as specified in the HMIS Data Standards DATA DICTIONARY released June, 2017. It is used to locate and fix specific UDE errors.", "url": "http://192.168.4.10:8080/WebViewerExample/frameset?__report=ude_dq_ver_5_2_error_detail_by_project.rptdesign", "containing_folder_name": "data_quality_reports_for_selected_programs", "insert_or_update": "insert", "changing_user_login": "muser", "parameters": [{"parameter_name": "ReportStartDate"}, {"parameter_name": "ReportEndDate"}, {"parameter_name": "ProgramIds"}]}'));
	RAISE NOTICE 'Result = %', (SELECT _output_json ->> 'result_indicator')::text;
END$$;

