 DECLARE  _output_json	json;
 BEGIN	
 	RAISE NOTICE 'insert CCST Managment Summary Monthly Report';
-	_output_json := (SELECT * FROM report_manager_schema.action_enter_edit_reports ('{"report_name": "CCST Managment Summary Monthly Report", "description": "This report provides a summary of the performance on all CCST programs over a single month and compares it to that of the year through the previous month. The starting date of the month must be entered when calling the report.", "url": "http://192.168.4.10:8080/WebViewerExample/frameset?__report=CCST_management_summary.rptdesign", "containing_folder_name": "ccst_only_reports", "insert_or_update": "insert", "changing_user_login": "muser", "parameters": [{"parameter_name": "MonthStart"}]}'));
+	_output_json := (SELECT * FROM report_manager_schema.action_enter_edit_reports ('{"report_name": "CCST Managment Summary Monthly Report", "description": "This report provides a summary of the performance on all CCST programs over a single month and compares it to that of the year through the previous month.", "url": "http://192.168.4.10:8080/WebViewerExample/frameset?__report=CCST_management_summary.rptdesign", "containing_folder_name": "ccst_only_reports", "insert_or_update": "insert", "changing_user_login": "muser", "parameters": [{"parameter_name": "MonthStart"}]}'));
 	RAISE NOTICE 'Result = %', (SELECT _output_json ->> 'result_indicator')::text;
 END$$;
 

DECLARE  _output_json	json;
BEGIN	
	RAISE NOTICE 'insert Universal Data Elements Data Quality Summmary for One CoC Version 5.2';
	_output_json := (SELECT * FROM report_manager_schema.action_enter_edit_reports ('{"report_name": "Universal Data Elements Data Quality Summmary for One CoC Version 5.2", "description": "The Universal Data Elements Data Quality Summmary for One CoC Version 5.2 report shows the data quality of the HUD defined Universal Data Elements as specified in the HMIS Data Standards DATA DICTIONARY released June, 2017 for all programs with the selected HMIS Project Types for a single selected continuum over a seleted time period. Its start_dt and end_dt parameters define the selected time period. Its _continuum_name parameter is the name of the single selected Continuum. Its _list_of_hmis_types parameter lists the selected HMIS Project Types as a comma delimited list with no spaces before or after the commas, for example, ''Emergency Shelter,PH - Rapid Re-Housing,Transitional Housing''. The default _list_of_hmis_types are the types used in the HUD Strategic Performance Measures (SPM)", "url": "http://192.168.4.10:8080/WebViewerExample/frameset?__report=ude_dq_ver_5_2_summary_for_one_coc.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": "CocName"}, {"parameter_name": "HmisProjectTypes"}]}'));
	RAISE NOTICE 'Result = %', (SELECT _output_json ->> 'result_indicator')::text;
END$$;


DECLARE  _output_json	json;
BEGIN	
	RAISE NOTICE 'insert United Way Demographics Report People Served';
	_output_json := (SELECT * FROM report_manager_schema.action_enter_edit_reports ('{"report_name": "United Way Demographics Report People Served", "description": "This report provides the United Way of the Southern Tier Demographics data about the people who received a service from one or more selected programs over a selected time period.", "url": "http://192.168.4.10:8080/WebViewerExample/frameset?__report=uw_demographics.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$$;

