Problem Solving Performance Measures

The example below details the report settings for a mental health court, but can be applied to any problem solving court model.

The text in red will need to be modified for your jurisdiction. Instructions on how to update those areas are listed in bold under each section.

When you have all of your report settings entered and you run the report, you will receive twelve (12) documents in your messages — one (1) Quest report and eleven (11) separate CSV files. The information in each of those CSV files needs to be copied and pasted into the relevant tab in an Excel spreadsheet (click here to download). The tabs must not be renamed or you will receive an error when you attempt to upload the spreadsheet.

Note: If your jurisdiction has multiple problem solving courts, you will need to create a separate report, and a separate Excel spreadsheet, for each problem solving court.

Example Report Settings

# — Required settings —
class=equest.app.reports.Indiana.ProblemSolvingPerformance

# Cover page information
county=County
courtName=Court Name
judge=Judge
coordinator=Coordinator
courtStartDate=Court Start Date
courtModel=Court Model
populationServed=Population Served
Enter the details for your county’s mental health court.

# requirements to include in report
# requirement.n=TYPE or requirement.n=TYPE/CODE
requirement.1=PROG/MHCO
Enter the requirement type or type/code for mental health court.

# number of pre-1/1/2014 people who participated in requirement(s)
pastParticipation=0
Update this number if necessary.

# number of pre-1/1/2014 people who graduated from requirement(s)
pastGraduates=0
Update this number if necessary.

# requirement type for restitution
# restitution.TYPE=1 or restitution.TYPE/CODE=1
restitution.FEE/RS=1
Enter the requirement type or type/code for restitution.

# requirement type for child support
# support.TYPE=1 or support.TYPE/CODE=1
If applicable, enter the requirement type or type/code for child support and remove the # at the beginning of the line.

# requirement type for substance abuse treatment
# substanceAbuseTreat.TYPE=1 or substanceAbuseTreat.TYPE/CODE=1
substanceAbuseTreat.PROG/IOPS=1
substanceAbuseTreat.PROG/SMRT=1
substanceAbuseTreat.PROG/SBCO=1
substanceAbuseTreat.PROG/TEEN=1
Separately add every requirement type or type/code that you have for any different types of substance abuse programming. They can all end with =1 – you just need to update the requirement type or type/code.

# requirement type for mental health treatment
# mentalHealthTreat.TYPE=1 or mentalHealthTreat.TYPE/CODE=1
mentalHealthTreat.PROG/ANG=1
mentalHealthTreat.PROG/PSYA=1
mentalHealthTreat.PROG/CO=1
mentalHealthTreat.PROG/FCT=1
mentalHealthTreat.PROG/FCO=1
mentalHealthTreat.PROG/FAMP=1
mentalHealthTreat.PROG/IHB=1
mentalHealthTreat.PROG/IOPM=1
mentalHealthTreat.PROG/MM=1
mentalHealthTreat.PROG/MST=1
mentalHealthTreat.PROG/STF=1
mentalHealthTreat.PROG/TFBT=1
Separately add every requirement type or type/code that you have for any different types of mental health treatment/programming. They can all end with =1 – you just need to update the requirement type or type/code.

# requirement status that means paid
# paidStatus.TYPE=1 or paidStatus.TYPE/CODE=1
paidStatus.COMP=1
Using your Requirement Status table, separately add any requirement status code(s) that are used when restitution has been paid.

# employment status that means unemployed
# unemployedStatus.CODE=1
unemployedStatus.UNEM=1
unemployedStatus.QUIT=1
unemployedStatus.FIRE=1
Using your Employment Status table, separately add any employment status code(s) that mean that the person is unemployed (not including disabled, which is handled later).

# employment status that means full time student
# studentStatus.CODE=1
studentStatus.FTS=1
Using your Employment Status table, separately add any employment status code(s) that mean that the person is a full-time student. If you do not already have one in your Employment Status table, you will need to add one.

# employment status that means disabled
# disabledStatus.CODE=1
disabledStatus.DIS=1
Using your Employment Status table, separately add any employment status code(s) that mean that the person is disabled. If you do not already have one in your Employment Status table, you will need to add one.

# employment status that means retired
# retiredStatus.CODE=1
retiredStatus.RETI=1
Using your Employment Status table, separately add any employment status code(s) that mean that the person is retired. If you do not already have one in your Employment Status table, you will need to add one.

# employment status that means employed
# employedStatus.CODE=1
employedStatus.EMPL=1
employedStatus.EMPF=1
employedStatus.EMPP=1
Using your Employment Status table, separately add any employment status code(s) that mean that the person is employed.

# school code for GED school
# gedSchool.CODE=1
Using your School table, separately add the code(s) for any school(s) falling within the category of GED school, if applicable, and remove the # at the beginning of the line.

# school code for high school
# highSchool.CODE=1
highSchool.BGHS=1
highSchool.CHS=1
highSchool.HHS=1
highSchool.KHS=1
highSchool.MTHS=1
highSchool.NV=1
highSchool.PHS=1
highSchool.RISE=1
highSchool.VAHS=1
highSchool.VALE=1
highSchool.VHS=1
highSchool.WTHS=1
highSchool.WHS=1
Using your School table, separately add the code(s) for all high schools.

# school code for college
# collegeSchool.CODE=1
collegeSchool.COL=1
Using your School table, separately add the code(s) for college(s).

# school code for vocational
# vocationalSchool.CODE=1
Using your School table, separately add the code(s) for any school(s) falling within the category of vocational school, if applicable, and remove the # at the beginning of the line.

# school status for enrolled
# enrolledStatus.CODE=1
enrolledStatus.AT=1
Using your School Status table, add the code(s) that mean that the person is currently enrolled.

# school status for graduated
# graduatedStatus.CODE=1
graduatedStatus.GR=1
Using your School Status table, add the code(s) that mean that the person graduated.

***Many of the following sections need Person Attributes that you may not already have set up, so you will need to add these categories to your Person Attribute Type table if they do not already exist.***

# person attribute for a veteran
# veteranAttribute.CODE=1
veteranAttribute.VET=1
Using your Person Attribute Type table, add the code for the “Veteran” person attribute.

# person attribute for mental health
# mentalHealthAttribute.CODE=1
mentalHealthAttribute.MENT=1
Using your Person Attribute Type table, add the code for the “Mental Health” person attribute.

# person attribute for substance dependence treatment
# substanceTreatAttribute.CODE=1
substanceTreatAttribute.SBDT=1
Using your Person Attribute Type table, add the code for the “Substance Dependence Treatment” person attribute.

# person attribute for dual diagnosis treatment
# dualDiagnosisAttribute.CODE=1
dualDiagnosisAttribute.DDT=1
Using your Person Attribute Type table, add the code for the “Dual Diagnosis Treatment” person attribute.

# person attribute for schizophrenia diagnosis
# schizoDiagAttribute.CODE=1
schizoDiagAttribute.SCHZ=1
Using your Person Attribute Type table, add the code for the “Schizophrenia” person attribute.

# person attribute for bipolar diagnosis
# bipolarDiagAttribute.CODE=1
bipolarDiagAttribute.BIPD=1
Using your Person Attribute Type table, add the code for the “Bipolar Disorder Diagnosis” person attribute.

# person attribute for major depressive disorder diagnosis
# depressiveDiagAttribute.CODE=1
depressiveDiagAttribute.MDDD=1
Using your Person Attribute Type table, add the code for the “Major Depressive Disorder Diagnosis” person attribute.

# person attribute for substance dependence diagnosis
# substanceDiagAttribute.CODE=1
substanceDiagAttribute.SUBD=1
Using your Person Attribute Type table, add the code for the “Substance Dependence Diagnosis” person attribute.

# person attribute for drug of choice
# drugOfChoice.CODE=1
drugOfChoice.DC01=Alcohol
drugOfChoice.DC02=Amphetamines
drugOfChoice.DC03=Benzodiazepines
drugOfChoice.DC04=Crack/Cocaine
drugOfChoice.DC05=Heroin
drugOfChoice.DC06=Inhalant
drugOfChoice.DC07=LSD
drugOfChoice.DC08=Marijuana
drugOfChoice.DC09=Methamphetamines
drugOfChoice.DC10=PCP
drugOfChoice.DC11=Prescription Opioids
drugOfChoice.DC12=Synthetic Substances
drugOfChoice.DC13=None
You will need a separate person attribute for each drug of choice.

# person attribute for ptsd diagnosis
# ptsdDiagAttribute.CODE=1
ptsdDiagAttribute.PTSD=1
Using your Person Attribute Type table, add the code for the “PTSD Diagnosis” person attribute.

# Statute dispositions to include when determining drug court related statutes
# drugCourtStatuteDisp.CODE=1
drugCourtStatuteDisp.FT=1
drugCourtStatuteDisp.FTT=1
Using your Statute Disposition table, add the code for any dispositions that indicate adjudication.

# use case attributes instead of person attributes for all attribute lookups
# useCaseAttributes=n

# For section I, only check for 1 substance report for a person per day (unless the report type is in alwaysIncludeReport list)
oneTestPerDay=n

# For section I, always include reports of these types, regardless if oneTestPerDay is true

# alwaysIncludeReport.n=REPORTTYPE (all caps)

# For section VIII, stay locations to include. if none specified, all will be included.
# locations.n=LOCATIONCODE (all caps)
locations.1=JAIL
Using your Location Code For Facilities table, add each code that means incarceration for adult problem solving court participants. If necessary, add a code to the table to account for this population. No juvenile detention locations should be included in this section.

# For section VIII, stay reasons to exclude from the total time for locations above.
# reasonsToExclude.n=REASONCODE (all caps)
reasonsToExclude.1=COHD
Using your Reason A Person Is Being Held table, add any code for a stay reason that should not be counted in the locations listed in the section above.

# map the requirements the report is being run against to state’s program type
# programType.TYPE/CODE=????
programType.PROG/MHCO=Juvenile Mental Health Court
Enter the requirement type or type/code for mental health court. After the equal sign, enter the actual words from the state’s program types, which are listed below:

Adult Drug Court
Adult Mental Health
Veteran’s Court
Family Recovery Court
Re-Entry Court
Domestic Violence Court
Juvenile Drug Court
Juvenile Problem Solving Court
Truancy Court
OVWI Court
Adult Problem Solving Court
Juvenile Mental Health Court

****For all of the mapping portions below, you are matching your Quest categories to the state categories that best fit yours. For example, in the next section below, you do not need to add “Involvement in a Civil Protection Proceeding” if that is completely irrelevant to your problem solving court cases. Just find how your Quest categories fit into the categories provided by the state. The only exception is if you have nothing already set up in Quest that matches any of the state categories, in which case you will need to add to your tables so that you have something to map.****

# map the requirement attributes to the state’s case type
# requireCaseType.CODE=????
requireCaseType.COPR=Condition of Probation
requireCaseType.JCWH=Judgment of Conviction Withheld Pending Successful Completion of the Problem Solving Court
Using your Requirement Attribute Type table, map the relevant requirement attribute types, which explain why/how a person was ordered to participate in mental health court, to the state’s case types. You will need to enter the code, then an equal sign, then include the actual words (verbatim) from the state’s case types, which are listed below:

Condition of Pretrial Diversion Program Authorized By Statute
Condition of Pretrial Diversion Program Authorized by the Problem-Solving Court Judge and Prosecutor
Judgment of Conviction Withheld Pending Successful Completion of the Problem Solving Court
Nonsuspendible Sentence Stayed Pending Successful Completion of the Problem Solving Court
Condition of Probation
Condition of Participation in a Community Corrections Program Under IC 11-12-1
Condition of a Forensic Diversion Program Under IC 11-12-3.7
Condition of Community Transition Program Under IC 11-10-11.5
Condition of Parole
Order in a Dispositional Decree to Participate in a Family Dependency Drug Court Under IC 31-34-20
Condition of a Delinquency Informal Adjustment Program Under IC 31-37-9
Involvement in a Child Support Proceeding
Involvement in Mental Health Commitment Proceeding
Involvement in a Civil Protection Proceeding
Condition of a CHINS Informal Adjustment Program Under IC 31-34-8

# map the requirement status to the state’s case status (we default to Active)
# requireStatus.CODE=????
requireStatus.COMP=Graduated
requireStatus.FAIL=Terminated
requireStatus.SUSP=Withdrawn
Using your Requirement Status table, map the relevant requirement statuses for mental health court to the state’s case statuses. You will need to enter the code, then an equal sign, then include the actual words from the state’s case statuses, which are listed below:

Active
Active PSC Case
Active PSC Case – Concurrent
Active – Concurrent
Graduated
Terminated
Withdrawn
Deceased

# map the employment status to the state’s status
# employmentStatus.CODE=????
employmentStatus.EMPF=Full Time
employmentStatus.EMPP=Part Time
employmentStatus.FTS=Student
employmentStatus.DIS=Disabled
employmentStatus.RETI=Retired
employmentStatus.UNEM=Unemployed
employmentStatus.FIRE=Unemployed
employmentStatus.QUIT=Unemployed
Using your Employment Status table, map the relevant employment statuses to the state’s employment statuses. You will need to enter the code, then an equal sign, then include the actual words from the state’s employment statuses, which are listed below:

Part Time
Full Time
Unemployed
Disabled
Student
Retired
Medical Restriction

# map the requirement status to the state’s treatment status
# treatmentStatus.CODE=????
treatmentStatus.COMP=Successfully Completed
treatmentStatus.FAIL=Terminated Unsuccessfully/Revoked
Using your Requirement Status table, map the relevant requirement statuses for mental health and substance abuse treatment to the state’s treatment statuses. You will need to enter the code, then an equal sign, then include the actual words from the state’s case statuses, which are listed below:

Absconded / FTA
Deceased
Successfully Completed
Successfully Completed Owing Program Fees
Terminated Unsuccessfully/Revoked
Transferred Out

# map the assessment types to the state’s assessment types
# assessmentType.CODE=????
assessmentType.02=Detention Tool
assessmentType.03=Disposition Screening Tool
assessmentType.04=Disposition Tool
assessmentType.01=Diversion Tool
assessmentType.IR2=Community Supervision Screening Tool (IRAS-CSST) – Version 2
assessmentType.IR3=Community Supervision Tool (IRAS-CST)
assessmentType.IR1=Pretrial Assessment Tool (IRAS-PAT)
assessmentType.06=Reentry Tool
assessmentType.05=Residential Tool
From your Assessment Type table, map the relevant assessment types to the state’s assessment types. You will need to enter the code, then an equal sign, then include the actual words from the state’s assessment types, which are listed below:

Diversion Tool
Detention Tool
Disposition Screening Tool
Disposition Tool
Residential Tool
Reentry Tool
Pretrial Assessment Tool (IRAS-PAT)
Community Supervision Screening Tool (IRAS-CSST) – Version 2
Community Supervision Tool (IRAS-CST)
Prison Intake Tool (IRAS-PIT)
Supplemental Reentry Tool (IRAS-SRT)
Static Tool (IRAS-ST)

# map the substance report types to the state’s types
# substanceReportType.CODE=????
substanceReportType.FF6P=Oral Swab
substanceReportType.FF9P=Oral Swab
From your Substance Report Type table, map the relevant substance report types to the state’s substance report types. You will need to enter the code, then an equal sign, then include the actual words from the state’s substance report types, which are listed below:

Blood
Breath
Hair
Oral Swab
Sweat
Urine

# map the substance codes to the state’s substances
# substanceType.CODE=????
substanceType.MDMA=Methylenedioxymethamphetamine/MDMA
substanceType.ALCO=Ethanol
substanceType.AMPH=Amphetamine
substanceType.BENZ=Benzodiazepine
substanceType.COCA=Cocaine
substanceType.HERO=Heroin
substanceType.INHA=Inhalants
substanceType.LSD=LSD
substanceType.MARI=Marijuana/THC
substanceType.MTD=Methadone
substanceType.MAMP=Methamphetamine
substanceType.OPIA=Opiates
substanceType.PCP=Phencyclidine
substanceType.PPX=Propoxyphene
substanceType.SYN=Synthetic Cannabinoids/K2/Spice
substanceType.SALT=Bath Salts
From your Substance Type table, map the relevant substance types to the state’s substance types. You will need to enter the code, then an equal sign, then include the actual words from the state’s substance types, which are listed below:

Ethanol
Ethyl Glucuronide (ETG)
Ethyl Sulfate (ETS)
Amphetamine
Benzodiazepine
Rohypnol
Cocaine
Heroin
LSD
Marijuana/THC
Delta-8
Methamphetamine
Phencyclidine
Buprenorphine
Fentanyl
Methadone
Opiates
Oxycodone
Propoxyphene
Suboxone
Tramadol
Codeine
Oxymorphone
Hydromorphone
Norbuprenorphine
Bath Salts
Designer Stimulant
Flakka
Synthetic Cannabinoids/K2/Spice
Methylenedioxymethamphetamine/MDMA
Inhalant, Inhalants

# map substance codes to substance codes that mean valid prescription for that substance
# script.CODE1=CODE2
From your Substance Type table, map the relevant substance type codes to the substance type codes that mean valid prescription for that substance. You will need to enter the substance type code, then an equal sign, then the substance type code that means valid prescription for that substance.
script.AMP=AMPP

# map the stay reasons to the state’s incarceration reasons (we default to Other)
# stayReason.CODE=????
stayReason.APLA=Awaiting Treatment Placement
stayReason.FTA=Failure to Appear
stayReason.CVPR=Program Violation
stayReason.NVPR=New Arrest
stayReason.CVPO=Probation Violation
From your Reason A Person Is Being Held table, map the relevant stay reasons to the state’s stay reasons. You will need to enter the code, then an equal sign, then include the actual words from the state’s stay reasons, which are listed below:

Awaiting Home Detention/Work Release
Awaiting Sentencing
Awaiting Termination from PSC
Awaiting Treatment Placement
Bond Revoked
Community Corrections Revoked
Community Corrections Violation
Failure to Appear
New Arrest
Original Sentence
Other
Probation Revoked
Probation Violation
Program Violation
Sanction
Sentence Modified

# map the requirements to the state’s out of home placements
# oohPlacementType.TYPE/CODE=????
oohPlacementType.COMM/DIA=Department of Correction
oohPlacementType.COMM/IBS=Department of Correction
oohPlacementType.COMM/IGS=Department of Correction
oohPlacementType.COMM/JDC=Detention
oohPlacementType.PLAC/ALT=Shelter Care
oohPlacementType.PLAC/BASH=Residential Facility
oohPlacementType.PLAC/CAM=Residential Facility
oohPlacementType.PLAC/CC=Residential Facility
oohPlacementType.PLAC/CR=Residential Facility
oohPlacementType.PLAC/DAMR=Residential Facility
oohPlacementType.PLAC/EVAN=Psychiatric Placement
oohPlacementType.PLAC/FAIR=Residential Facility
oohPlacementType.PLAC/FWLH=Group Home
oohPlacementType.PLAC/FOSC=Foster Home
oohPlacementType.PLAC/GSB=Residential Facility
oohPlacementType.PLAC/IUM=Group Home
oohPlacementType.PLAC/LHGH=Group Home
oohPlacementType.PLAC/LW=Residential Facility
oohPlacementType.PLAC/BHCA=Psychiatric Placement
oohPlacementType.PLAC/BHC=Psychiatric Placement
oohPlacementType.PLAC/NDI=Psychiatric Placement
oohPlacementType.PLAC/OAK=Residential Facility
oohPlacementType.PLAC/OPT=Residential Facility
oohPlacementType.PLAC/PAD=Residential Facility
oohPlacementType.PLAC/PCNH=Group Home
oohPlacementType.PLAC/PIE=Residential Facility
oohPlacementType.PLAC/POL=Group Home
oohPlacementType.PLAC/RELP=Family Placement
oohPlacementType.PLAC/RESO=Residential Facility
oohPlacementType.PLAC/RES=Residential Facility
oohPlacementType.PLAC/SAFP=Residential Facility
oohPlacementType.PLAC/SHLT=Residential Facility
oohPlacementType.PLAC/STEL=Group Home
oohPlacementType.PLAC/SF=Residential Facility
oohPlacementType.PLAC/SCS=Group Home
oohPlacementType.PLAC/TRAN=Residential Facility
oohPlacementType.PLAC/TRUH=Residential Facility
oohPlacementType.PLAC/UHGH=Group Home
oohPlacementType.PLAC/VV=Residential Facility
oohPlacementType.PLAC/WERN=Residential Facility
oohPlacementType.PLAC/WHIT=Residential Facility
oohPlacementType.PLAC/WOOD=Group Home
oohPlacementType.PLAC/YOC=Residential Facility
oohPlacementType.PLAC/YVIL=Residential Facility
Enter the requirement type/code for every out-of-home placement location in your tables, including DOC. After the equal sign, you will need to map each one to the state’s out-of-home placement types, which are listed below.

Department of Correction
Detention
Electronic Monitoring
Family Placement
Foster Home
Group Home
Psychiatric Placement
Residential Facility
Shelter Care

# map the requirement attributes to the state’s placement reasons
# oohPlacementReason.CODE=????
oohPlacementReason.DIAG=Diagnostic Evaluation
oohPlacementReason.DOCD=Diagnostic Evaluation
oohPlacementReason.DISP=Disposition
oohPlacementReason.MOD=Modification
oohPlacementReason.VLTR=Voluntary
From your Requirement Attribute table, map the relevant requirement attributes to the state’s placement reasons. You will need to enter the code, then an equal sign, then include the actual words from the state’s placement reasons, which are listed below:

Diagnostic Evaluation
Disposition
Modification
New Offense
Other Reason
Placed Under JC Case
Sanction
Step Down
Violation of Release
Voluntary

# map the stay locations to the state’s ooh placements (as detention)
# placementLocations.CODE=????
placementLocations.I=Detention
placementLocations.ISO=Detention
placementLocations.OBS=Detention
placementLocations.SDE=Detention
placementLocations.SDW=Detention
From your Location Code for Facilities table, map the secure detention location codes to Detention.

# map the stay locations to the state’s placement reasons
# stayPlacementReason.CODE=????
stayPlacementReason.APLA=Other Reason
stayPlacementReason.ADOC=Other Reason
stayPlacementReason.NVPO=Other Reason
stayPlacementReason.FTA=Other Reason
stayPlacementReason.CVPR=Violation of Release
stayPlacementReason.MAND=Other Reason
stayPlacementReason.NVPR=New Offense
stayPlacementReason.CVPO=Other Reason
stayPlacementReason.WDF=Other Reason
From your Reason a Person Is Being Held table, map the relevant stay reasons to the state’s placement reasons. You will need to enter the code, then an equal sign, then include the actual words from the state’s placement reasons, which are listed below:

• Diagnostic Evaluation
• Disposition
• Modification
• New Offense
• Other Reason
• Placed Under JC Case
• Sanction
• Step Down
• Violation of Release
• Voluntary

# map the sex to the state’s sex (we default to U)
# sex.CODE=????
sex.F=Female
sex.M=Male
sex.U=Unknown
From your Sex table, map the sex codes to the state’s sexes. You will need to enter the code, then an equal sign, then include the actual words from the state’s sexes, which are listed below:

Male
Female
Unknown

# map the gender to the state’s gender (we default to U)
# gender.CODE=????
gender.M=Male
gender.F=Female
gender.TRAN=Transgender
From your Gender table, map the gender codes to the state’s genders. You will need to enter the code, then an equal sign, then include the actual words from the state’s genders, which are listed below:

Male
Female
Transgender
Non-Binary
Unknown

# map the race to the state’s race (we default to U)
# race.CODE=????
race.A=Asian
race.B=Black or African American
race.MR=Mixed Race
race.I=American Indian or Alaska Native
race.P=Native Hawaiian or Other Pacific Islander
race.U=Unknown
race.C=White
From your Race table, map the race codes to the state’s races. You will need to enter the code, then an equal sign, then include the actual words from the state’s races, which are listed below:

American Indian or Alaska Native
Asian
Black or African American
Native Hawaiian or Other Pacific Islander
Other
Mixed Race
Unknown
White

# map the ethnicity to the state’s ethnicity (we default to U)
# ethnicity.CODE=????
ethnicity.HIS=Hispanic
ethnicity.NHIS=Non-Hispanic
From your Ethnicity table, map the ethnicity codes to the state’s ethnicities. You will need to enter the code, then an equal sign, then include the actual words from the state’s ethnicities, which are listed below:

Hispanic
Non-Hispanic
Unknown

## Prompt the user
prompt.parm.1=startDate
prompt.parm.1.type=date
prompt.parm.1.label=From date
prompt.parm.1.required=true
prompt.parm.1.default=begPrevYear
prompt.parm.2=endDate
prompt.parm.2.type=date
prompt.parm.2.label=To date
prompt.parm.2.required=true
prompt.parm.2.default=endPrevYear
prompt.parm.3=details
prompt.parm.3.type=boolean
prompt.parm.3.label=Include details
prompt.parm.3.required=true
prompt.parm.3.primaryValue=N