 DECLARE  _output_json	json;
 BEGIN	
 	RAISE NOTICE 'insert Special Populations Served by the Selected Programs';
-	_output_json := (SELECT * FROM report_manager_schema.action_enter_edit_reports ('{"report_name": "Special Populations Served by the Selected Programs", "description": "This report summarizes the special populations served by the selected programs during the defined time period. The special populations summarized are unaccompanied and parenting youth, domestic violence survivors, veterans, chronically homeless, adults with various disabilities, and the elderly. 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=special_populations_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"}]}'));
+	_output_json := (SELECT * FROM report_manager_schema.action_enter_edit_reports ('{"report_name": "Special Populations Served by the Selected Programs", "description": "This report summarizes the special populations served by the selected programs during the defined time period. The special populations summarized are unaccompanied and parenting youth, domestic violence survivors, veterans, chronically homeless, adults with various disabilities, and the elderly.", "url": "http://192.168.4.10:8080/WebViewerExample/frameset?__report=special_populations_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 Project Specific Elements Data Quality Summmary for One CoC Version 5.2';
	_output_json := (SELECT * FROM report_manager_schema.action_enter_edit_reports ('{"report_name": "Project Specific Elements Data Quality Summmary for One CoC Version 5.2", "description": "The Project Specific Elements Data Quality Summmary for One CoC Version 5.2 report shows the data quality of the HUD defined project specific data elements required for HUD:CoC and the HUD:ESG funded projects. It reports foe 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) Its _return_coc_funded_only parameter specifies if data only for the CoC funded programs is to be returned or if all data is to be returned. The parameter''s allowed values are Yes (return only CoC funded programs data) and No (return data for all programs)","url": "http://192.168.4.10:8080/WebViewerExample/frameset?__report=coc_esg_project_specific_dq_summary_for_one_coc_ver_5_2.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"}, {"parameter_name": "IncludeCocFundedPrjctOnly"}]}'));
	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.", "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$$;

