Total Jobs
33
all active records
Served
16
48% completion rate
Non-Serve
6
↑ needs escalation
Past Due
5
due date passed
Avg Days Open
15.3
days per job
Jobs by Client
Holcomb Law Group18
American Legal Solutions5
Greentree Legal2
Schwartz & Associates2
Heidelberg Patterson2
Other / misc.4
Job Aging — Days Since Created
8–14 days 5 jobsfollow up
Jobs / Week
⚠ Past Due — Action Required
●
NOBLE HALE — 15324957
Due Mar 20 · Non-Service · 3 attempts · 85 days open
●
Lashanda Fox — 15557672
Due Apr 10 · Attempted · 2 attempts · 56 days open
●
Optum Care, Inc. — 15732725
Due May 10 · Attempted · 3 attempts · 34 days open
●
Tirrell Wells — 15837679
Due May 25 · Non-Service · 4 attempts · 20 days open
●
Rachel Massey — 15646566
Due May 25 · Attempted · 1 attempt · 45 days open
Overall Data Quality Score
52%
FAILING
79 of 165 tracked fields are blank
Process Server Blank
31/33
94% of jobs unassigned
Job Status Blank
29/33
88% missing job_status
Due Date Missing
11/33
33% of jobs — no deadline
Recipient Desc. Blank
38/52
73% of attempts incomplete
Jobs Table — Field Completion
sm_job_number
33/33 complete
✓
client_company_name
33/33 complete
✓
recipient_name
33/33 complete
✓
service_status
6 missing
C
client_contact_name
2 missing
A
process_server_name
31 missing
F
Attempts Table — Field Completion
What Needs to Be Fixed
1
Process server must be assigned at intake
94% of jobs have no server name. This field must be set when job is accepted — not optional.
2
Due date required on every job at intake
11 jobs have no deadline. 3 jobs with no due date are already 29+ days open.
3
Recipient description required on every attempt
73% of attempts have no description. Who was served? Required for affidavit accuracy.
4
job_status field is nearly always blank
88% empty. Likely not mapped from the source feed. Verify the intake payload includes this field.
Jobs With No Process Server Assigned (31 of 33)
Attempts Missing Recipient Description (38 of 52)
73% of attempt records have no recipient description.
This means no record of who the papers were handed to — a legal liability on every affidavit.
Required fix at intake: Process servers must complete the "Description of Person Served" field on every attempt — successful or not. This is a mandatory field for affidavit of service accuracy.
Enforcement option: Flag attempts missing this field and block affidavit generation until it's filled in.
Complete attempts
14 / 52
Missing description
38 / 52