I take that back, you can also utilize the jcellhist table to see who was in a cell at that time, though that is also tricky. I've had a request in to Intergraph for years to have a report to show on a certain date where everyone was in the jail .
When running the ‘ Arrests with unknown or missing Sex, DOB, Ethnic or Race’ diagnostic error report , the Race and Ethnic columns are BLANK. However when you look in WebRMS, the values are entered correctly.
The ASR looks at the ARREST _CODES table in the UCR Code column. For drugs Sale/Manufacturing section uses the code 1811, 1812, 1813, and 1814 and the Possession section uses the code 1821, 1822, 1823, and 1824.