SELECT DISTINCT datasetid AS datasetid , ds_icr_headerid AS ds_icr_headerid , ds_icr_unique_key AS ds_icr_unique_key , ds_icr_rec_num AS ds_icr_rec_num , NULL AS ds_icr_generic_key1 , ibr_segment AS ibr_segment , MAX(DECODE(data_element_prompt,'Segment Action Type',TRIM(data_value))) AS action , MAX(DECODE (data_element_num,'1',TRIM(data_value))) AS de_1 , MAX(incident_nbr) AS de_2 , MAX(DECODE(data_element_num,'23',TRIM(data_value))) AS de_23 , STRAGG(DECODE(data_element_num,'24',TRIM(data_value))) AS de_24 , MAX(DECODE(data_element_num,'25',TRIM(data_value))) AS de_25 , MAX(DECODE(data_element_num,'25A',TRIM(data_value))) AS de_25A , MAX(DECODE(data_element_num,'25B',TRIM(data_value))) AS de_25B , MAX(DECODE(data_element_num,'25C',TRIM(data_value))) AS de_25C , MAX(DECODE(data_element_num,'26',TRIM(data_value))) AS de_26 , MAX(DECODE(data_element_num,'27',TRIM(data_value))) AS de_27 , MAX(DECODE(data_element_num,'28',TRIM(data_value))) AS de_28 , MAX(DECODE(data_element_num,'29',TRIM(data_value))) AS de_29 , MAX(DECODE(data_element_num,'30',TRIM(data_value))) AS de_30 , STRAGG(DECODE(data_element_num,'31',TRIM(data_value))) AS de_31 , MAX(DECODE(data_element_num,'32',TRIM(data_value))) AS de_32 , STRAGG(DECODE(data_element_num,'33',TRIM(data_value))) AS de_33 , STRAGG(DECODE(data_element_num,'34',TRIM(data_value))) AS de_34 , STRAGG(DECODE(data_element_num,'35',TRIM(data_value))) AS de_35 FROM ds_ibr_field_values_vw WHERE ibr_segment = 'VICTIMS' AND posted = 'Y' GROUP BY datasetid , ds_icr_headerid , ds_icr_unique_key , ds_icr_rec_num , ibr_segment ORDER BY ds_icr_headerid