The “Indigence Statistics Report” job creates a comma-separated values (CSV) report file you can use for auditing assessments
over a specific date range.
The file starts with a single header row followed by a row for each individual assessment with the following data:
| Value |
Description |
| AssessmentID |
The assessment identifier the row is associated with |
| Date Received |
The date the assessment was received |
| Date Reviewed |
The date the assessment was created |
| LE # |
A semi-colon separated list of booking numbers linked to the charges associated with the assessment |
| Case Number |
A semi-colon separated list of case numbers linked to the charges associated with the assessment |
| SSN |
The Social Security number of the defendant |
| First Name |
The first name of the defendant |
| Last Name |
The first name of the defendant |
| Public Programs |
(Y) if the assessment has any public programs. (N) if not. |
| MHMR |
(Y) if the assessment is selected for Continuity of Care. (N) if not.
|
| FPL |
The FPL attached to the assessment |
| Indigent |
(Y) if the defendant has an Approved decision on the assessment. (N) if not. |
| Source |
The code of the source attached to the assessment |
| CAA |
A semi-colon separated list of attorneys appointed to charges associated with the assessments (listed by last name first,
and then first name and middle initial)
|
| Misdemeanors |
The count of misdemeanor charges associated with the assessment |
| Felonies |
The count of felony charges associated with the assessment |
| User |
The name of the user who created the assessment |
The following is an example of the CSV generated by the job:
AssessmentID,Date Received,Date Reviewed,LE #,Case Number,SSN,First Name,LastName,Public Programs,MHMR,FPL,Indigent,Source,CAA,Misdemeanors,Felonies,User"16","05/10/2017","05/10/2017","","","","Betty","Smith","code2;SSI/SSDI","N","0.1000","Y","Jail","","0","0","Henderson,
Bart""17","05/10/2017","05/10/2017","","","","Betty","Smith","code2;SSI/SSDI","Y","0.3600","N","Out of County","","0","0","Henderson,
Bart""18","05/10/2017","05/10/2017","","","","Betty","Smith","code2;SSI/SSDI","Y","0.1800","Y","Jail","","0","0","Henderson,
Bart""23","05/10/2017","05/10/2017","01602017JM","15C-00026","989-88-8999","John","Smith","","N","","Y","Jail","Braun, Craig
Douglas","0","1","Henderson, Bart""24","05/10/2017","05/10/2017","","","989-88-8999","John","Smith","","N","","N","Jail","","0","0","Henderson,
Bart""25","05/10/2017","05/10/2017","","","989-88-8999","John","Smith","","N","","N","Jail","","0","0","Henderson, Bart"