 DECLARE  _output_json	json;
 BEGIN	
 	RAISE NOTICE 'insert CCST Treatment Apartments Report to Chemung DSS 2018';
-	_output_json := (SELECT * FROM report_manager_schema.action_enter_edit_reports ('{"report_name": "CCST Treatment Apartments Report to Chemung DSS 2018", "description": "This report shows the OMH defined outputs over the selected time period for the Treatment Apartments (Sunshine). The starting date and the ending date of the selected time period must be entered when calling the report.", "url": "http://192.168.4.10:8080/WebViewerExample/frameset?__report=trtmnt_aprtmnts_chemung_dss_report.rptdesign", "containing_folder_name": "ccst_only_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": "CCST Treatment Apartments Report to Chemung DSS 2018", "description": "This report shows the OMH defined outputs over the selected time period for the Treatment Apartments (Sunshine).", "url": "http://192.168.4.10:8080/WebViewerExample/frameset?__report=trtmnt_aprtmnts_chemung_dss_report.rptdesign", "containing_folder_name": "ccst_only_reports", "insert_or_update": "insert", "changing_user_login": "muser", "parameters": [{"parameter_name": "ReportStartDate"}, {"parameter_name": "ReportEndDate"}]}'));
 	RAISE NOTICE 'Result = %', (SELECT _output_json ->> 'result_indicator')::text;
 END$$;
 

DECLARE  _output_json	json;
BEGIN	
	RAISE NOTICE 'insert Supported Housing Case Management Report to Chemung DSS 2018';
	_output_json := (SELECT * FROM report_manager_schema.action_enter_edit_reports ('{"report_name": "Supported Housing Case Management Report to Chemung DSS 2018", "description": "This report shows the OMH defined outputs over the selected time period for the combined supported housing programs. The starting date and the ending date of the selected time period must be entered when calling the report. ", "url": "http://192.168.4.10:8080/WebViewerExample/frameset?__report=spprtd_hsng_cse_mgmt_chemung_dss_report.rptdesign", "containing_folder_name": "ccst_only_reports", "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 Project Entry and Exit Data Entry Timeliness Summary for Selected Projects';
	_output_json := (SELECT * FROM report_manager_schema.action_enter_edit_reports ('{"report_name": "Project Entry and Exit Data Entry Timeliness Summary for Selected Projects", "description": "The Project Entry and Exit Data Entry Timeliness Summary for Selected Projects report shows the timeliness (days lag between an entry or exit event and when the data was recorded) for the selected programs over a seleted time period. It shows the number of people that entered (admitted) or exited (discharged) each selected project, 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_summary_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$$;

