SELECT DISTINCT nf.offense_code offense_code, nf.nibrs_code nibrs_code, nm.code_type m_code_type, nm.code m_code, en.ec_code_type code_type, ecq.screen_prompt ques, ecq.sort_order FROM nibrs_offenses nf INNER JOIN nibrs_code_ejs_mappings nm ON nm.nibrs_code = nf.nibrs_code INNER JOIN ejs_code_nibrs_mappings en ON en.nibrs_code = nm.nibrs_code AND en.code_type = nm.code_type AND en.code = nm.code INNER JOIN ejs_codes ecq ON ecq.code = en.ec_code_type INNER JOIN nibrs_tab_cols nt ON nt.code = ecq.code AND nt.inc_section_code = 'OFFENSES' AND ecq.active = 'Y' ORDER BY ecq.sort_order, ques