A records request arrives for Harrington, Patrick L, a 2009 offense report. An advanced search, name harrington, record type offense report, reported 2009, source the retired RMS, finds the match, shown in the results list with a preview. Opening it shows the record screen. The matching raw row, CR200900417, 20090314, 2210, 11204, M, HARRINGTON,PATRICK L, 1983, CRP, lifts out of the legacy table, and each value lands in its labelled field of the original Anytown Police Department offense report: case CR-2009-00417, reported Mar 14, 2009 at 22:10, ATC 11-204 Theft from a vehicle, misdemeanor, reporting officer Marsh, T. #1983, suspect Harrington, Patrick L, closed with restitution paid. Each field notes the column it came from. Export makes it a PDF, the original values are kept, and the request is answered.
Simplified from the record screen. Open it in the demo · PDF of CR-2009-00417, opens in a new tab