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,'40',TRIM(data_value))) AS de_40 , MAX(DECODE(data_element_num,'41',TRIM(data_value))) AS de_41 , MAX(DECODE(data_element_num,'42',TRIM(data_value))) AS de_42 , MAX(DECODE(data_element_num,'43',TRIM(data_value))) AS de_43 , MAX(DECODE(data_element_num,'44',TRIM(data_value))) AS de_44 , MAX(DECODE(data_element_num,'45',TRIM(data_value))) AS de_45 , STRAGG(DECODE(data_element_num,'46',TRIM(data_value))) AS de_46 , MAX(DECODE(data_element_num,'47',TRIM(data_value))) AS de_47 , MAX(DECODE(data_element_num,'48',TRIM(data_value))) AS de_48 , MAX(DECODE(data_element_num,'49',TRIM(data_value))) AS de_49 , MAX(DECODE(data_element_num,'50',TRIM(data_value))) AS de_50 , MAX(DECODE(data_element_num,'51',TRIM(data_value))) AS de_51 , MAX(DECODE(data_element_num,'52',TRIM(data_value))) AS de_52 FROM ds_ibr_field_values_vw WHERE ibr_segment = 'ARRESTS' AND posted = 'Y' GROUP BY datasetid , ds_icr_headerid , ds_icr_unique_key , ds_icr_rec_num , ibr_segment ORDER BY ds_icr_headerid