Reports
This continually gets updated as new reports are added and reports are brought to my attention. If the report you are looking for is not here, please send Karlene Thompson an email asking for information on that report. This remains a work in progress.
Menu | Miscellaneous | Reporting | Reports
Also see Queries for more reporting options
USERS
Authorized users (AuthorizedUsers)
This report will produce a list of all people with access to Quest. You can pull the list to show everyone or you can run it for a specific agency or security group. It shows the user name, ID, Agency, Security Group, whether they still have the default password, and the date of their last sign on. This is an excellent way to find people who are no longer using the system, so you can remove their Quest access.
Expire passwords not changed in specified days (CheckPasswords)
This report produces no output. The report settings allow you to specify how long a password is valid, how many days prior to expiring it should start notifying users that their password is about to expire, and then if a person hasn’t changed their password in the specified number of days, it will expire their password. This should be set up as a scheduled job to run nightly if your passwords expire periodically. If this is not scheduled and you manually run it, you risk expiring everyone’s password instantly.
Identity usage report (IdentityUsage)
This is a techy report used by G&W. If you try to delete someone and you can’t because the system tells you their name is in use somewhere, you can run this report on the person to determine where their name has been used.
PERSON
Identity attribute inquiry (AttributeInquiry)
This will produce a list of everyone who matches the person attributes you’ve selected. You can narrow this list to only include certain criteria, such as only open cases, specific race, ethnicity, sex, age, active cases before or after a certain date, to name a few.
This will produce a list of everyone who has the physical identifier you’ve selected, such as Tattoos. You can narrow this list to only include certain criteria, such as a specific race, ethnicity, sex, age, born before or after a specific date. The report lists the names, race, ethnicity, sex, dob, file number of those matching.
Potential identity matches (PotentialMatches)
This report will go through all the people in Quest and product a list of all possible duplicate people.
Substance reports over period (SubstanceStats)
This report will provide the findings of the substance tests given during a date range. It will list the name of those people, the date of the test, and the results of the test. It will also provide a summary of all test findings.
Family assignment audit (FamilyAssignmentAudit)
This report will search all open cases to find those that are missing the “other identifier” that
represents the family ID number.
CASES
Attorney Average Life of Case Report (AttorneyAvgLifeOfCase)
This report will list the type of case type, broken into different severity levels if applicable, how many cases of each type were filed during the time period, and the average days to disposition for each type of case. This report can be pulled for different agencies and different assigned roles.
Open case counts (OpenCaseCounts)
This report will produce an excel spreadsheet with every open case in Quest. You can set up the report for a specific case type, like Dependent/Neglect. It will show every case that is still open, show information about assigned roles if desired, and will list the permanency plan requirements. This is a great report to help clean up open cases that shouldn’t be open or that are missing information.
Open caseload breakdown by court (CourtAssignments)
This report will list the number of open cases, with how many people are associated with those cases for each assigned/home court. It will breakdown how many are over 21 years old. If you’ve used other ID to identify “families” it will also report how many families each court has open.
Audit cases for logical errors (AuditCases)
This report will look at the cases and determine if there are any errors. You know when you go to close a case and you get an error message that users ignore? This will help you find all those
cases with errors so you can fix them. Things like “case open but no case names are active” and “case closed but requirements are still open.”
Cases open beyond specified period (OpenCases)
This report will provide a list of all the cases, either for a specific case type or all cases, that have been open for longer than you specify. If you specify 180 days for example, this report will list all cases that have been open for longer than 180 days starting with either the file date or the date of the last hearing.
Audit agency cases for logical errors (AuditAgencyCases)
This report will look at cases to determine if they meet the criteria set up in this audit report. You can require the open cases to have a specific assigned role, such as a GAL. You can require open cases to have an assigned/home court, or they must have a case number, or each case person must have an other ID. In addition you can include the audit cases for logical errors information.
Case attribute inquiry (CaseAttributeInquiry)
This report allows you to search for specific case attributes and will provide you with a list of names and cases where that attribute can be found. You can limit the report in many ways.
Case status follow-up stats (CaseStatusFollowup)
This report allows you to choose a specific case status, such as adjudicated. It will then report how many cases had that case status before the reporting period, how many new cases came in during the period, how many were closed during the period, and how many cases had that case status at the end of the period. It will also report if the person has a new offense during or after the status was active.
Case status statistics (CaseStatusStats)
This report shows the average length of time between two case statuses. You can search a specific case type, Dependency & Neglect cases for example, and choose Filed or Open for the first case status and Closed or Wardship Terminated for the second case status and the report will tell you the average length of days between the two, broken down by race and sex.
Case Efficiency Statistics (CaseEfficiency)
This report will look at specific case types and determine the efficiency or how long it takes to get to disposition from various starting points such as referral date, preliminary inquiry date, and filed date. It compares all referrals to those who have had an alternative to detention and secure detention. It breaks it down by race and sex and provides a beautiful graph of the results.
RAI Efficiency Statistics (RAIEfficiency)
This report will look at specific case types and risk assessments. It will report recidivism based on risk assessment level, race and sex and provides a beautiful graph of the results.
Open people by court (OpenPeopleByCourt)
This report will list show how many people there are with open cases in each court. It will sort the case types by groupings so delinquency cases are displayed as a group, and D&N cases are displayed as a group, or Family cases are displayed as another group. It will also report how many of these people are over 21.
People with Both Delinquency and Dependency Cases (DuallyIdentified & DuallyIdentified2)
There are actually two reports that are available. DullyIdentified provides a nice list of all the children who have both delinquency and dependency cases in Quest. DullyIdentified2 takes that nice list and expands it to include permanency plans, placements, assessments.
Dependency Performance Measures (CourtPerformanceMeasures)
This report provides a wide range of statistics about the dependency case. The report must be configured, and it assumes that case attributes are being used to track a lot of information. It includes recidivism information; percentage of children who reach permanency or not; how many times a child was moved; how many different judges, case managers, and public defenders were assigned to the case. Many more statistics are included in the spreadsheet which can be uploaded to BI.
Court Improvement Project Timelines (CIPTimelines)
This report provides the statistics requested by the Federal Court Improvement Program. It includes: Time to first permanency hearing, time to subsequent permanency hearings, time to permanency placement, time to termination of parental rights petition, time to termination of parental rights.
Seal Cases of People Over Age (SealOldCases)
This report will search for specific case types and search the names associated with the case to determine if all are over the age of 21 or whatever age you specify. If so, it will seal the case. It can also add a person or case attribute indicating it has sealed a case. It will provide a report that informs you of those people and cases found.
Cases open where everyone is over 18 (OpenCasesOver18)
This report provides a list of case numbers and case names where the case is still open but all names associated with the case are over the age of 18.
Case Assignments
Case Assignments for Period (CaseAssignmentsForPeriod)
This report will list every assigned role, how many of each active role there was at the start of the period, how many were assigned during the period, and how many were active at the end of
the period. If you ever wanted to know how many GALs were appointed during the period, this would tell you that. This can be run by court if desired.
New cases over a period (NewCasesOverPeriod)
This report will list all cases that opened during the time period. It will allow you to select a specific role and it will tell you if that role was assigned to the case during the time period. For example, if you wanted to see how many cases that opened last month have a GAL or a Public Defender assigned, this report will tell you. You can pull this by specific case type.
New/ended case assignments (NewAssignments)
This report asks you to select an agency or a user id, and it will list all the cases and the date of the assignment start and end date. If you run it for an entire agency, such as the public
defender’s office, it will list the names of each public defender and list their cases that started or
ended during the time period. If you choose it for a specific user id, it will only list their cases.
Attorney Workload Summary Report (AttorneyWorkloadSum)
This report will look through the attorney case assignments to determine the number of new case assignments, ended case assignments and the total caseload per attorney at the end of the reporting period. Great for Public Defenders or GALs.
Open assignments by court (OpenAssignmentsByCourt)
This report will list how many open assignments for a specific agency there are for each assigned/home court. This is a great report if you want to see how many public defenders or guardian ad litems are currently assigned to cases in each court.
Workload measure (WorkloadMeasure)
This reports the number of cases each person from the selected agency has assigned to them. It breaks down the number of cases by supervision level and hours. It also reports how many PDR, PI and Review Reports each officer created during the time period. It then gives averages and total by division and unit.
Agency person statistics (AgencyPersonStats)
This report will show by person how many case assignments, events, contacts, filed statutes, and statute dispositions were made for the month.
Appointment Statistics (AppointmentStats)
This report uses the Order Appointing GAL and Order Appointing Counsel to determine how many GAL’s were appointed and how many Attorneys were appointed by each judicial officer during a time period. It will also look at fee requirements to determine the number and amount of administrative Fees assessed and waived. Used in Tennessee.
Warrants
Open warrants (OpenWarrants)
This report will list all open warrants. You can limit this list by warrants issued after a specific date, type of warrant, or court. It will display identifying information on the person, including address and phone numbers, the case number, charges, and next event.
Map open warrants (map-openwarrants)
This report will produce a map indicating where those people with an open warrant live. You can hover over the dots on the map to see who lives there along with links to their person detail, history, contact, and events.
Quash warrants (QuashWarrants)
This will produce a report that shows the open warrants that have exceeded the number of days you’ve indicated a warrant may remain active, and it will warn you of warrants that are getting close to that date. For those that have exceeded the number of days, this report will inactive them. If you have a warrant type that expires after 6 months for example, this is a very handy report to keep on top of those warrants about to expire. You may want to make it a scheduled job.
Warrants issued statistics (WarrantsIssued)
This report will list all the warrants that were issued or closed during a date range. It will produce a report that breaks down these statistics by warrant type, race, sex, age, case type and warrant status. It will provide the details on the people for whom a warrant was issued or closed.
Incidents
Incident Statistics by Attributes (IncidentAttributeStats)
The report lists the types of incidents during the time period and reports the number of each attribute of those incidents, broken down by incident type.
Federal Disproportionate Minority Contact Stats (FederalDMC)
The report looks at the incidents during a time period to determine the race, ethnicity, and sex of those juveniles who had contact with the judicial system and reports the disposition of those contacts.
Filed Statutes
Court Case Counts by Statute (CourtChargeFilings)
This report will list the filed statutes filed during the time period and report how many of each were filed broken down by court.
Court Case Counts by Statute Disposition (CourtChargeDispositions)
This report will list all the filed statutes filed during the time period and show how many were filed and what their disposition was, broken down by court.
Events
Agency Trial Result Report (AgencyTrialResult)
This was created for the public defender’s office. It tells how many “trials” were held and how
many of them were guilty findings.
Open cases with no future court events (CasesWithNoEvents)
This report will provide you with a list of cases where there is no future event scheduled. This is a great report to ensure old cases are getting closed and open cases aren’t falling through the cracks.
Complete open events (CompleteEvents)
This report will allow you to select a date, and any open event that matches the report settings will be closed or “disposed”. This is a great way to ensure you don’t have old events sitting out there.
Court Events Over a Period (CourtEvents)
This report will list all completed events for a specific court during a time period. It will list the event date, court, event type, event disposition, name, file number, and cause number. It will also list the name and date of any document tied to the event AFTER the event date. This is useful if you want to count how many hearings were held in a specific court and if you want to see how timely court orders are being prepared on these events.
Create Events for Requirements (CreateEventsForRequirements)
This report will automatically schedule events based on specific types of requirements. For example, if you add a requirement of “drug testing” you may want Quest to randomly select people with that requirement to come in for testing. This report will randomly pick the person and schedule an event for them to appear.
Daily events (DailyEvents)
This report will list all events scheduled for a specific date. You can include court and/or non-
court events, disposed events, and person “at risk” attributes.
Event attribute inquiry (EventAttributeInquiry)
This report looks at the different event attributes and produces a report that tell you how many times this attribute was used and in which case. It can be narrowed by specific event types, event dates, or even by agency, division, unit, or user id.
Event audit (EventAudit)
This report will list every event, court and/or non-court events, completed and/or incomplete only scheduled for the date range. It will list the event names in alphabetical order and report that person’s dob, case number, type and date of the event, event disposition and the name
assigned to the case that matches the “attorney role” defined. This is a great way to ensure all events get disposed.
Next events (NextEvents)
This report will show the next selected event on cases. It will list the probation status, on probation or not, the supervision level and the date of the future event. This is a great report to ensure cases with a specific supervision level have their next “office visit” scheduled for example.
Next events for requirements (NextEventByRequirement)
This report will list cases with a specific requirement type or code and tell you the next event on the case. For example, you can specify a certain requirement, such as “DCS Commitment” or a “DCS Placement” to limit the report those children who have been removed from the home.
Then you can pull this report to ensure these cases have a future event scheduled.
Voice Notification of Events (VoiceNotifyEvents)
This report is the interface between Twillio and Quest. Running this report causes voice calls and/or text messages to be sent to notify people about upcoming events.
FTA court events statistics (FTAEvents)
The report lists the number of events that were scheduled during the time period and the number of those events that had an event disposition that means failed to appear. It will list this by age, case type, race, and sex of the event names. It will provide it for all courts as a total, then break it down by the different courts.
Deadlines
Email people of deadlines coming due (DeadlinesEnding)
This report will send an email to specific people based on their “person type” of specific deadline types that are coming due. If you have a real problem with staff not getting their deadlines completed on time, you can also send the email to their supervisor or manager.
Open deadlines (OpenDeadlines)
This report will provide a list of those cases that have a specific deadline type open. This can be run by agency, division, unit or for a specific user ID.
Open deadlines by Court (OpenDeadlinesByCourt)
This report will provide a list of those cases that have a specific deadline type open. You can specify a specific deadline type or all. You can specify a specific court and only those deadlines in that assigned/home court will be displayed.
Requirements
1006 Requirements reporting (Requirements1006)
This is a community corrections report. It will search for specific requirements then report demographic information on the individual, such as name, dob, ssn. It also reports the most serious offense the individual was charged with, the specific requirement name, start date, end date and type of completion. It also provides the employment status of that person on the last day of the requirement period.
Alcohol and Drug Program Data Report (ADProgramDataReport)
This report will search for specific requirements, it will then report information such as race, gender, age, charges, income, education, employment, types of programs referred to, disposition of the requirement, and risk levels based on risk assessments.
Assigned requirement list (AssignedRequirements)
This report will provide a list of people with a specific requirement that have a name assigned to the case from the agency selected. It will show the person’s name and file number, requirement, requirement start date, how long it has been open, the scheduled end date, the next court date and the name of the person assigned to the case from the selected agency.
Current location associated with requirements (RequirementLocationsRpt)
This report will provide a list of all the people with a specific requirement and the address of that person. For example, children in foster care have a placement requirement. You can add the specific address and contact information of the foster parents in that requirement location. You can then pull this report and it will give you the exact address of every child in foster care. This would be a great report to have in the event of a disaster.
Notify users of requirements ending (RequirementsEnding)
This report will send a Quest Message to specific or all names assigned to the case notifying them that a requirement is about to reach its scheduled end date.
Open requirements (OpenRequirements)
This report provides a list of the names and identifying information for all people with an open requirement specified. It also lists the names of the people assigned to the case.
Open requirements by school (OpenRequirementsBySchool)
This report provides the same list of names as open requirements, but this report breaks them down by the name of the school they are currently attending. If the child is not currently attending a school, the report will provide a list of these children as well.
Title IV-E (TitleIVE)
This program produces a report of all DCS requirements for a person, unit, division or agency. It shows the date of the last DCSIVE document for each and calculates the date the next DOCIVE is due.
Program disposition report (ProgramDisposition)
This report will produce a list of everyone who has or had a particular requirement. It will then display columns with the severity and put each case in the appropriate column based on the worst offense. It will show if the person successfully completed the requirement or failed to do so, and if so why they failed. It will look at the requirement status and at other requirements added to the case after this requirement was added.
Program monitoring report (Daily Counts) (ProgramMonitoringDaily)
This report will look for specific requirements to determine the number of “active clients” in the program and will calculate the number of vacancies in the program. This is an excellent report if you have a program that only has a certain number of spots available.
Requirement completion report (RequireCompletions)
This report will list all the requirement types you select that closed during a specific time period and let you know how what percentage of each type were completed successfully. It will also break it down by a specific assigned role.
Requirement referral report (RequirementReferrals)
This report will search for the specific requirement requested and report the numbers for the specific time period plus since inception. It will report referring agency, sex, age, race, zip code and ethnicity of participant. It will report case attributes, crime types, as well as provide the number of requirements and the different requirement statuses during the period.
Requirement sanctions/incentives statistics (SanctionIncentiveStats)
This will search for a specific requirement and report the number of each possible sanction and incentive used during the requested time period.
Requirement statistical report (RequirementStatistical)
This report will provide information on specific requirements that were opened or closed during a time period. It will break down the report by race, sex, and age of the participants. It will report schools attended, drug screen, requirement status, and recidivism numbers.
Requirements by worker (RequirementsByWorker)
You can select a requirement and a date range and this report will provide a list by worker of the number of cases they have with that requirement.
Informal Adjustment/Diversion Statistics (InformalDiversionStats)
This report will tell you how many people and cases of a specific case type were referred to the court during a time period. It will also report how many informal and/or diversion requirements were started during the time period. It breaks it down by assigned/home court and case type.
Problem Solving Performance Measures (ProblemSolvingPerformance)
This report will search for a specific requirement, such as drug court, and then provide information about those participants. It will report such things as demographics, abstinence and use, employment and education, and program success and failure rates.
Law Enforcement Report (LawEnforcement)
This report will provide a list of information on those people who either match a specific requirement, such as all the kids on probation or home detention, and/or people who have a warrant. This can be separated by city. This is a great report to send to the county sheriff and/or the city police departments to let them know about the people in their area.
Create Events for Requirements (CreateEventsForRequirements)
This report will automatically schedule events based on specific types of requirements. For example, if you add a requirement of “drug testing” you may want Quest to randomly select people with that requirement to come in for testing. This report will randomly pick the person and schedule an event for them to appear.
Financials
Create judgment book (CreateJudgmentBook)
This report searches for new Judgments added to the system and put them into the Judgment Book.
Judgment Book & Index (Judgment Index)
This report will provide a list of the Judgments entered during a time period. It can include only open judgments or all judgments.
This report will produce a list of people who have received payments on Judgments. It will the total amount each person has received, it will list their name, address, SSN or EIN, and the total amount paid to them.
This report lists the amount disbursed to the county. It breaks it down by the different funds with their fund number.
Automatic assessment of periodic fees (AutoAssessment)
This report will automatically assess the periodic fees. You can program the report to stop calculating fees as of the scheduled end date and start calculating on the requirement start date, if desired.
Bank Positive Pay (BankCheckExtract)
This report provides an excel spreadsheet of the checks written so it can be sent to your bank to avoid fraud.
Check & Receipt Register (CheckReceiptRegister)
This report runs either the check register or the receipt register. It simply lists all the checks or all the receipts issued during the time period.
Court Clerk Reimbursement Invoice (StatuteFeesForPeriod)
This report will produce an invoice to the State of Tennessee for reimbursement of clerk fees for specific documents filed by the Title IV-D Division.
Daily Collections & Report of Collections (CollectionsByRequirement)
This report produces a list of collections by requirement. If you include details it is called the Daily Collections report. If you do not include details it is called the Report of Collections. Both reports simply report the receipts. They do not report transfers between funds.
Reconciliation Report (ReconciliationReport)
The reconciliation report will provide a report of your bank reconciliation. It will list the cleared and outstanding checks as well as the cleared and outstanding deposits and a calculated bank balance.
Disbursement Report (DisbursementReport)
This report will list the money disbursed by liability account during the time period. The report will list the amount by account and will also display the check information. If fund numbers are set up in the liability accounts this report will print those as well.
Docket ledger (DocketLedger)
This report will show all accounts where money is being held.
Financial Report (FinancialReport)
This report will provide the beginning balances, receipts, disbursements, and ending balances for the time period. It will also report any transfers and adjustments made.
General Ledger (GeneralLedger )
This report lists all the transactions in each account. You can show all the transactions or just the balances.
Investment Details (InvestmentDetail)
This report provides information on the investments being held. It will report the name and address of the requirement name, file number, case number, dob, requirement code, provider, and notes. The requirement start date, beginning balance, debits and credits made during the time period, ending balance and the requirement end date.
Print billing statements (CreateBillingStatements)
This report will produce a billing statement for open fee requirements. It will also schedule an event if you choose to do so.
Trial Balance (TrialBalance)
This report will show the balances on the asset and liability accounts. These should equal. It is a great way to ensure you are in balance.
Requirement costs (RequirementCosts)
This report will list all monetary requirement codes. It will report the assessment transaction amounts and the default amounts set up in the notes. This is a great report to run when there are fee increases.
Transaction Journal (TransactionJournal)
This report will list every transaction that matches the selected transaction type. You can run by transaction date or date added. You can run every transaction or only specific types of transactions, such as adjustments or voided transactions.
Void uncashed checks (VoidCheck)
This report will find and automatically void any check that has not cleared the bank within a
certain number of days. Many checks will have the words “Void after 60 days” or something similar on them. This is a way to void those checks that are past that number of days. Keep in mind, the bank often cashes these checks after that day.
Documents:
Print batch docket forms /Print Pending Notices (CreateBatchNotices)
This report will cause pending notices to be sent to the designated parties via email or u.s. mail. It will provide you with an information list about documents that were sent via email. It will provide an address cover sheet and a copy of the document to be mailed so it can be printed and stuffed into window envelopes to be sent to the post office. It will update the document detail screen to indicate the date notice was sent, how it was sent, and the address where it was sent.
Create document packet (DocumentPacket)
This report will combine all of a person’s or case’s documents into a single PDF that can be sent
out.
STATISTICS:
Monthly/year to date statistics (MonthlyYTD)
This report will provide you with more information that you will ever need! Referring agencies, age and race of referrals, times referred, charges, case status, how many open cases, statute dispositions, requirements, and document information.
Recidivism extract (Recidivism)
This report will look at case types, requirements, or incidents to provide a list of potential people who have reoffended.
Model Court Dependency Statistics (DependencyStats)
This report will provide the number of new dependency petitions filed for the reporting year. It will average that caseload for the number of judicial officers who hear these cases. It will list the number of children under the court jurisdiction and in out of home placements. It will show how many achieved permanency and the type, the number of orders terminating parental rights, the number of appeals and the length of time for many points in the case. It will also provide recidivism numbers.
COURT
Court docket (CourtDocket)
This report will print a court docket allowing you to customize the docket in more ways than you can just by using the court docket screen. You can display a child’s initials only if they are under 18, limit the docket to only specific event types, you can include such things as: at risk attributes, notes, amount owed, and current location.
Court docket notes (CourtNotes)
This report will look at a specific court docket from a specific date and print the docket along with the docket notes. You can pull this for past or future dockets.
Court sign in (CourtSignIn)
This report will pull the events for a specific day and list the people who could possibly be appearing for this hearing and provide a place for them to “sign in.” Give you a manual way to check people in for hearings.
Folders to pull for court (FoldersToPull)
The report will list the folders needed for a specific court on a specific date. It will sort in either file number or case number. If you chose to update the file location the report will add a folder location detail in the case detail screen to indicate that this file has been pulled for court.
SUPERVISION
Contact Summary (ContactSummary)
This report will count the number of contacts made by a specific person or by an agency, division, unit. It will display the contact person and contact types made during the time period.
Contact attribute inquiry (ContactAttributeInquiry)
This report provides information on the contact attributes that have been selected on the contact detail screen.
Administrative Sanctions/Violations Process Report (SanctionsViolations)
This report will list the number of specific contact types and filed statutes that were completed during the time period for each user in the specific agency, division, unit or for a specific person.
Risk assessment statistics (RiskStats)
This report will look at the selected detention assessments for the time period and provide statistics about them. It reports the overall score, the assessment level which is the detention decision: detain, release, release with conditions, and override reasons. It presents the data comparing the different detention decisions by sex, race, age and offense reason. This is a JDAI Report.
Risk assessment summary (RiskSummary)
This report will look at selected assessment for all children or only currently detained children. It will report information about the assessment, such as overall score, assessment levels, override reasons and notes as well as the incident charges.
Probation risk assessment (RiskAssessmentsNeeded)
This report will provide a list of those people with a probation requirement that have not had a specific risk assessment or are in need of the assessment again. This report is by names assigned to the case for a specific agency, division, unit, or user ID.
DETENTION
Custody overview (CustodyOverview)
The report looks for open facility stays and open requirements that are defined in the report settings. It will also report on any facility stay or requirement that closed during the time period. It reports locations, classifications, attributes, start date and duration. If defined, it will look for people with a warrant and report on them. The report can also contain school information if desired.
Detained as of specific date (DetainedOnDate)
This report will list every person with an open facility stay on a specific date. The report can be limited to only certain locations and/or only secure locations. It will show the name, race, sex, age, location, length of time at that location, stay length and name of probation officer at that time.
Detained felonies (DetainedFelonies)
The report will provide a list of people in secure detention locations who have at least one felony level filed statute that has been disposed as guilty. The report will provide name, race, sex, dob, height, weight, hair, eyes, location, and the officer listed on the incident.
Detainee info over period (DetaineeInfo)
The report lists all people with an open stay location during the time period. It will list the name, location, start date, admission type or reason the person was detained, duration, and release reason if the person was released.
Detention contact information (DetentionContactInfo)
The report is searching the open locations selected and providing a list of the people in each of those locations along with their race, sex, age, current location, their approved list of visitors and the phone list numbers they are allowed to call, if selected.
Detention Meals (DetentionMeals)
This report will list the people currently detained in a specific location. It will print a sheet that lists the person’s name, age, race, and bed. Then will provide columns for Breakfast, Lunch, Snack, Dinner, Snack so each meal the person receives can be marked. If requested, the report can also list the dietary needs for that person, so you can ensure their meals do not include anything they are not to receive.
Detention movement over period (DetentionMovement)
This report lists everyone who was moved in to or out of the selected location during the time period. It will report the date/time of the movement, name of person, race, sex, age, moved from location, moved to location, location length and stay length. It will also provide this information in a spreadsheet format.
Detention population (DetentionPopulation)
This report will list the number of people in the locations specified in the report criteria, at the start of the period, end of period, how many were admitted or released during the period, and
how many of those were pre or post adjudication. The report breaks down the information by sex, race, age, offense category, and reason or charges against them. It will provide details if requested.
Detention school attendance (IDNotesForStays)
This report was created so those detention centers with schools could have a designated area to make notes about school attendance while in detention. This report will give a count of the residents in each location with notes on that date. It will break the students down by school district.
Detention statistics (DetentionStats)
This report looks at the specified locations to determine statistics such as, new referrals, broken down by sex, month, hour, race, ethnicity, school, agency and recidivism. It also calculates monthly statistics such as bed days, chargeable bed days, post disposition bed days, average daily population, and average length of stay.
Detention stays over period (DetentionStays)
This report is providing information on the people who were in the locations specified in the report criteria at any time during the reporting period. It will provide name, race, sex, dob, age, start date, end date, location, allegations, classifications and attributes, and length of time at that location. This is a great report if you need to justify why you are holding children in your facility, if you invoice others for detaining, or are invoiced for your children being detained.
Incident monitoring report (IncidentReports)
This report looks at a specific document, such as “Detention Incident Reports” and tallies the responses to various questions, such as “where did the incident occur,” “was there self-harm,” “was there use of force,” etc. to provide a summary report of the incidents.
Detention incident extract (DetentionIncidentExtract)
This report produces a .csv (spreadsheet) file with the detention incident statistics for detention incidents that occurred during the date range. It includes information such as injuries, restraints, DCS referrals, and people involved in the incident.
Location Counts Over a Period (LocationCounts)
This report will provide the total number of males and females in specified locations on every day during the time period. It will be broken down by location, with a total of all locations at the end.
People detained over period (DetainedOverPeriod)
This report will search for people detained in the specified location for at least the minimum number of days entered in the report criteria. It will display the name, race, sex, dob, age, ssn, file number, times held and length held.
PREA Violations or PREA Stay Review Report (DetainedTooLong)
This report will list those people who were held for a specified number of hours in a specific location, such as the intake or screening area. The report will provide the location, stay and end times and the length of time in that location.
Stay statistics report (StayStats)
This report provides statistics about a specific location. It can be narrowed to include only specific types of incidents. Every section is broken down by Sex and Race. It provides statistics about the people in that location during the report period. It reports statistics such as Day, Month, Hour of arrest details, Age, Offense, Time Referred, Release, Case Disposition, Referring Agency, and zip codes.
Stay attribute inquiry (StayAttributeInquiry) –
This report will provide a list of the people matching the facility stay attribute selected as well as the total number of matches for each attribute requested.
AUTHORITY
System Authority Report (TableAuthorityReportPdf)
This is a large report that will list every security item with a description of what it is, then report what each security groups access to this item is. For example, which security groups have access to Quest from the internet. Good audit report. I ran this for Allen County and it was over 4,000 pages.
Manage System:
End old open schools attended (EndOpenSchoolAssignments)
This report will change the status of the schools attended section to “unknown” if it still shows “attending” and the status date is more than 2 years old.
Recalculate case assignments (RECALCASSIGN)
This report recalculates the case assignments for those people assigned to a case. You can cause it to recalculate all case assignments or only for a specific person type.
Delete old messages (DeleteOldMessags)
This report will check messages and delete any that are older than the number of days to keep a message before deleting set up in the Default Tables: Number of days to keep messages before deleting. It will also skip any messages that have a message status that means ‘do not automatically delete’.
Notifications:
Print pending notices (CreateBatchNotices)
This report will send a copy of filings and orders that need served on the parties. It will send the copy via email or us mail. It will update the document detail screen notices section with information on when and how each party was served.
Print pending Subpoenas (CreateBatchSubpoenas)
This report will print the subpoenas that are waiting to be printed.
Notify of assigned documents (NotifyAssignedDocuments)
Reads through all assigned documents and warns assigned users of the documents that have been assigned longer than the grace period provided. It will also send a message to the user who created the document and the user running this report.
Tennessee specific reports
Tennessee data extract (TnDataExtract)
This report automatically sends the statistics required by the state of Tennessee to the TN Data Portal.
TN DCS County Probation Extract (PC 1005) (TnDCSProbationExtract)
This report is in response to PC 1005. It looks for children that have been placed on any type of supervised county probation after being adjudicated or placed on judicial diversion. It produces a .csv spreadsheet that shows name, race, sex, DOB, SSN, probation start date, end date, primary offense and why services ended if applicable.
TN DCS IV-D Magistrate Docket Detail (DHSDocketDetails)
This report provides information to the Tennessee Department of Human Services, Child Support Division, about the hearings held by the IV-D Magistrates for the purpose of receiving IV-D reimbursement.
Indiana specific reports
Indiana Probation Quarterly Report
Indiana Supreme Court Quarterly Report
Community Corrections DOC Annual Report (CCAnnualReport)
This report will provide the information required by DOC for its annual report.
Community Corrections Quarterly Report (DocCCQuarterly2)
This report will produce the data required for the Indiana Department of Correction: Community Corrections Quarterly Data Report.
DOC Snapshot (DOCSnapshot)