Badger TraCS Guides
DAIT and DOJ Meeting Notes
DAIT and DOJ Meeting Notes
- 1 Meeting 3/5/2020
- 2 Meeting 4/2/2020
- 3 Spillman clearances
- 4 Meeting 4/30/2020
- 5 Meeting 5/14/2020 Agenda
- 6 Meeting May 14, 2020 with DA/DOJ Notes
- 7 Meeting 5/24/2020 Agenda
- 8 May 14, 2020 Incident Mtg with DA/DOJ
- 9 September 22, 2020
- 10 January 7th, 2021
- 11 January 7th, 2021 Notes
- 12 January 20th, 2021
- 13 February 4th 2021 agenda
- 14 February 5th 2021
- 15 April 15th, 2021
- 16 April 29th 2021
- 17 May 13th, 2021
- 18 June 10th 2021
- 19 June 24th 2021
- 20 July 8th 2021
- 21 July 22nd 2021
- 22 August 19th 2021
- 23 September 2nd 2021
- 24 September 9nd 2021
- 25 September 30 2021
- 26 October 14 2021
- 27 October 14 2021
- 28 November 11th, 2021
- 29 November 30 2021
- 30 Dec 9th 2021
- 31 January 6th, 2022
- 32 January 20th, 2022
- 33 February 3rd, 2022
- 34 February 17th, 2022
- 35 March 3rd, 2022
- 36 March 16th, 2022
- 37 March 31st 2022
- 38 April 14th 2022
- 39 April 28th 2022
- 40 June 9th 2022
Meeting 3/5/2020
Thursday, March 5, 2020
2:09 PM
Attendees: Brenda Ray, Alesha Brown, Mac Dempsey, Geri Polster, Derek Veitenheimer, Brian Neil
Discussion on developing the form to be easy for law enforcement to complete.
DOJ thinks that way we have now is close to completing all the information they need.
DAIT
Law Enforcement thinks on the criminal justice system front.
Can see most le officers being confused.
Officers collect the data but usually have another staff member do the NIBRS portion with the RMS
We would get better information if we just received the raw data and then we do the data manipulation.
DOJ agrees in principal, but worry about how the FBI will look at the data and reject it.
A few field have been added for DAIT needs
Count and Citation number.
The term incident means different things to DOJ and DAIT
How to handle split incidents
Offenses should be connected to participants.
For every offense there should be a link to a subject and victim
Hard to split Property offenses when it comes to the stolen property.
Derek thinks it would be alright to not split the incident
Would find a way to not double count property
Would find a way to clear one of the incidents without the other being cleared.
If there are misapplied offenses per individuals could result in creating unneeded splitting.
Offenses not being selected correctly for all individuals.
Alesha is cautious about not having anything mocked up to provide data.
When does DA split?
One case with two defendants, one victim, and charges. (Dane county)
Split this to 2 incidents, (brown county).
Definition of incident: single date, place, time (DAIT)
If jurisdiction changes, then it becomes another incident. (Derek smashing mailboxes across city lines)
Derek is worried about the FBI changing the definition of incident down the road.
Form simplification
Derek: Need to have this form as simple for law enforcement to use and complete correctly.
Agreed that they should be doing the backend processing.
This is the first step of creating a statewide incident report form that contains all the needed data.
Users of the data should be doing their backend processing.
Should not be concentrating solely on NIBRS data.
Brenda: Need to get user buy in for them to use the form
Don't want to throw out what we have already done.
Need to put out the "Chevy" version and go on to the "Caddy" version.
Analysis needs
Is there something that DAIT needs?
Referral come to DA a day after it happens. DOJ could be up to a year later.
Referrals come when there is enough data to present a case.
Persons booked/arrested the DA must act within 48 hours. Referral goes immediately.
Scenario on DA handling
2 defendants and 1 dies.
No Prosecute the one that dies.
Prosecute the survivor.
Submitted in error/unfounded
No Prosecute the case.
DAIT will get updates to eReferral, but are usually in form of attachments.
When a new defendant is found, defendant is added to existing referral and resubmitted.
DAIT does not receive referrals without a defendant being identified.
When Individual Type is "Unknown"
All fields will be enabled for entry of known data.
Will not be sent to DA without a name.
DOJ will accept the data as is.
If Society/Public is individual type, DAIT does not want it.
Subject Types needed:
DAIT: Individual, Non-Individual
DOJ: Individual, Non-Individual
Will ignore any Non-Individual, will be treated as Unknown.
Summary group with have Total Subject, Total Victims, etc.
**** Work group meeting agenda item
How does LE want to report the number of defendants/subject, i.e. unknown?
Arrests
Definition: Arrest and Fingerprinted (DA)
Once fingerprinted - must be sent to DA
Will take information without the arrest and fingerprinting.
Fingerprinting creates record in CIB
Referral sent
Should invite someone from CIB. (Katie?)
Need to discuss how NTC do not get counted/reported as incidents.
RMS
Agencies are putting their information into RMS to create eReferral, and other forms.
Need for further discussion
Citation forms
Discussion on how citation data will be imported into the incident form.
****Agenda item for next meeting.
Next meeting discussion
Review each field in the Arrested section for differences in what data is expected for DAIT and DOJ. - DAIT doesn't need any of the arrest fields.
Discussion on how citation data will be imported into the incident form.
Booking group
DA would need Booking Date, Booking Time, Booking agency. Do not need ATN , but could use it later.
Subject group.
Arrested (NIBRS) label changes.
Booked (eReferral) label changes.
Verify at the next Incident Group these changes
Next meeting:
Set up a meeting for about two weeks out.
Mac is not available 19th and 20th
Meeting 4/2/2020
Monday, March 30, 2020
2:12 PM
Skype Conference Attendees: Geri, Dar, Alesha, Brenda, and Mac (Derek joined later)
Geri walked through the Property and Incident forms and explained changes she made since the last meeting.
Property Form:
Ask at Incident Meeting: Do they want this form attached to the Incident Form:
Drug group:
Loss Type: DOJ will provide the list of loss types.
Vehicle Group:
Added Recovered Property Value
Need a list for Loss Type
**Vehicle stolen, put only parts recovered
DOJ only wants # of stolen cars or if it was chopped up they would want the dollar value of recovered parts
Loss Type: DOJ will provide the list of loss types
DOJ will come up with Wording for new field indicating vehicle recovered in parts.
Mac will talk to Alesha and Derek
Property Group
Loss Type: DOJ will provide the list of loss types
Fields added: Recovery Date, Quantity Recovered and Recovered Value
Incident Form
Summary:
Added eReferral Agency (not in Jurisdiction)
Got the Total Offenses, Total Subjects and Total Victims working
Offense group
Showed a draft of the Felony Table
Different categories to filter
Geri showed how an offense that is one to one relationship will fill in and then how an offense with a one to many relationship would fill in
Alesha had a concern with the Offense field and it being a violation search. Geri stated that she wouldn't be able to limit it so it would be better to just have a drop down list. Alesha agreed
Will turn the field into a single list.
VALIDATION RULE: if the Offense = Simple Assault then Attempted Completed is always Completed.
DOJ will give Geri a list of what offenses are always in a Completed status and not applicable (group B Offenses).
Adjusting the property field to a radio button with Society, Property and Person offenses.
Derek's statute list had a lot of statutes that did not have any offense code attached to them
Brenda believes that there are a lot of new statues ( a lot of them are from 2020)
DOJ needs to discuss how often the statutes should be updated in TraCS
TraCS could update the tables every time we send out a TraCS Pack
If a statute is listed that doesn't have an offense connected to them, then the whole list of offenses is shown
Something shows as NR - Means Not Reportable?
Yes, Derek said NR = Not Reported
Cleared by Exception
Mac - if there was a split incident and an assault occurred
Then if an officer showed up and he was assaulted. They would all have the same 13B, could they only clear one of them.
More discussion - ask the incident group how they would handle
Clearance means nothing to the DA
Subject Group
Individual
All the Y/N boxes are for the individual
If Arrested, then the arrest group opens up
Associated Offense - needs to change to multi select
Drop down list has the attributes showing the description up front and the statue number at the end
Fix Caps and Non-caps in the attributes (Make consistent)
Prescription
Prescription field opens up
Suspected Drugs and Narcan Administered fields to fill in
Non-Individual than all the Y/N boxes are grayed out
Victim Group
Still working on this
UCR Offense (Multiple)
Geri gave demo of Scenario #1
Mac wondered if LE would be expected to fill out the relationship between all the victims and the offenders?
We believe so - Need to check with the Incident group
If there isn't a victim - it's society
Need to check with the Incident Group how they complete it
How would DOJ handle that data?
If there is a situation where the second person was a lookout, then DOJ would want them to be added as an offender but Brenda stated that the police would not put them as an offence since they wouldn't be changed with anything
How people will fill things out in practice?
Brenda said police will fill this out and put the second person as a witness
Ask Group
Geri gave demo of Scenario #2
Subject 1 simple assault
Subject 2 simple assault
Victim 1 -
Police Officer was assaulted by one of the subjects
VALIDATION RULE: All subjects with an offense against a Victim then the Relationship section should be completed
Geri will rework the property field in the offense section to be a radio button with property, person and society offenses. This will direct what offenses can show up in the victim and property groups.
Group A and B crimes
Need to discuss more as group B crimes still get charged, just that DOJ only collects arrest group B charges. One of those charges looks like it would have a victim (bad checks I don't think we will have a N/A just most of those don't have victims as they the victim is still society)
Offense section
If DOJ needed to split an incident
Mac asked Derek and Alesha if they would have an issue with the offense group being duplicated
Alesha was concerned with the weapon
DOJ will meet to discuss these issues
Mac wondered if law enforcement would complete this as one incident or two?
We asked Mac to come up with situations that could be discussed/reviewed at the Incident Meeting in two weeks.
Geri could have them filled out and discuss if that is how law enforcement would normally fill it out
This will assist DOJ in figuring out how they will split their incidents
Next Week Wednesday - Geri can package and get a TraCS Pack with the Incident form in it to Mac
Geri is still working on the victim group
Spillman clearances
Monday, April 20, 2020
8:46 AM
Here are the clearances our department uses from Spillman.
CFA - Cleared by False Alarm
CM - Civil Matter
CTT - Clerk to Type
CTI - Citation Issued
CRO - Cleared by Responding Officer
These are the dispositions:
CIT - Citation
CON - Confidential
NRP - No Report
REP - Report
RFA - Referred to other Agency
WRN - Traffic Warning/ 10-Day/ Verbal
UNF - Unfounded
Shawn McGee
Chief of Police
Meeting 4/30/2020
Tuesday, April 28, 2020
11:36 AM
Agenda
Attachments – to the DA
Property Types – Question asked in the general meeting
Field Requirements (DOJ)– See picture,
F2 help
Thursday, April 30, 2020 from 2:30 - 4:00 PM
Remote Skype Meeting
Attendees: Derek V. (needs to leave early), Mac Dempsey, Alesha B, Geri P, Brenda R (arrived 15 min. late) and Dar
Derek discussed his concerns with 'rushing' this project and wants to make sure that DOJ has reviewed and addressed all their situations so they are able to receive the data that they need in a way that is usable for them to use.
He doesn’t want us to make short sighted decisions. He wants to make sure it works for now and for the future.
Two weeks from today, DOJ will be meeting to discuss more of their questions with the incident form and how they will handle all the different situations.
Sending Attachments to the DA
TraCS can't send any Attachments with the incident form.
Send the incident form to DA
Send the Attachments after the form has been sent
Ask the Incident Work Group if we can remove the 'Attachment' Group from the Incident form
Have LEA send Attachments via the Attachment form
Ask FAC if we could move the Form Type and Form Reference Number to the Summary Group.
Does this impact other forms? Need to see if any agency uses these fields.
Also add the eReferral Y/N field to the Summary Group
Property Types – Question asked in the general meeting
Drug Section
Need to add two new fields
Recovered value
Date Recovered
Loss type
What needs loss value vs measure
Should they report drugs in two places on the form
It's cleaner to only have the drug type and remove from the property form
We are also looking for a dual purpose
Drugs and used by someone or drugs that were stolen
Enter the value and measure??
Add more fields to the XX group so depending on what they type of situation, the enter certain fields and the others are grayed out
Mac will give TraCS what loss type needs what fields.
Aircrafts - Where do they go?
Hybrid - is a way to record property (stolen vs recovered)
Is it ambiguous on where they put something that is stolen vs recovered.
Go through a sample of this situation next meeting (stolen vs recovered)
Property type will be a sub group of the other property type
What's a motor vehicle is different for DOJ
Need to figure out what is a vehicle per LEA.
Clearances:
Geri shared Spillman's clearance information
DOJ wants an exceptional field and all clearances the way that DOJ wants it.
F2 help:
TraCS will create empty files of all the F2 Help Fields
TraCS will place DAIT fields on the SharePoint in the DAIT folder (if there isn't one - create one)
TraCS will place the DOJ fields on the SharePoint in the DOJ folder
This should be completed the week of May 4th
After the fields have been completed, put the completed files on the SharePoint site to be added to the next Pack release.
Don't wait to get the all done, complete some and put them on the SharePoint site.
After these have been updated, we'll ask LEA to review the fields and provide comments
Alesha still doesn't have access to the SharePoint site.
Field Requirements (DOJ)– See picture,
DOJ will look at the Criminal Activity and the others fields that need to be reviewed
DOJ thinks they would keep the fields at the offense level, but will discuss in the next two weeks.
If they can't decide, we may remove them and add them later.
Add this topic to the next agenda in two weeks
Meeting 5/14/2020 Agenda
Thursday, May 7, 2020
7:45 AM
AGENDA
Summary of work (Geri)
Violation(Offense) Fields (DOJ)
Loss type with Measure vs Value for Drugs (DOJ)
Property demo
DOJ to receive property data
with the incident form (a summary)
Linked to offenses
with the property form (raw data)
Not linked to offenses
DOJ receive raw xml in Fall idea
F2 Help
Meeting May 14, 2020 with DA/DOJ Notes
Thursday, May 14, 2020
2:15 PM
AGENDA - May 14 2020 from 2:30 - 4:00 PM - TEAMS Mtg
Attendees: Geri Polster, Mac Dempsey, Alesha Brown, Brenda Ray, Derek Veitenheimer, and Darlene Schwartz
Summary of work (Geri)
Can everyone get to the SharePoint site?
Yes - But Brenda doesn't know what she is supposed to do
Property form: (see change document)
Adjusted recovered fields and value fields gray and enable based on loss type.
Summary
Add Unknown Victim Type
Fixed the issue with the disappearing victim groups when violation changed.
Added programming to adjust Dynamic lists if main linking group deleted. The fields affected by dynamic lists are
Arrest Group -->Associated Offenses
Individual(Subject) Group--> Associated Offenses
Relationships -->Associated Offenses
Relationships -->Offender
Other Person -->Linked To
Other Person-->Parent OF
Property-->Associated Offenses
Victim-->Associated Offenses
Individual(subject) Group --> Relationship offender
Reports
Office
Attachment Form
Need to ask FAC
Generated all the F2 Helps
Violation (Offense) Fields (DOJ)
Remove the Cleared Exceptionally and Date Cleared Fields and put in Summary Group
Should they be one field?
Want to add Unfounded and Deleted Records
Should they be in one field?
Unfounded means something was reported, but through investigation it did not happen
Deleted means that there was a keying error or it was a duplicate
If LEA sent a couple of offenses sent to DOJ and then they want to delete those offenses
If LEA sent to DOJ (duplicate) they want it deleted.
If LEA sent it and now want it to be non-reportable, then send to DOJ
More discussion and decisions needed for the Unfounded/Deleted
Loss type with Measure vs Value for Drugs (DOJ)
Loss Type = Recovered, stolen/etc, Recovered
Recovery Date and Recovered Value
Mac will send Geri "something" tomorrow
Only Seized loss type does measure all others do value.
Property demo
Is there a risk from the user stand point, have a stolen and recovered item.
Training issue - Could you have LEA put it an item was stolen and it was recovered
We need validation rules to check to see if items have been duplicated on the form.
Some of what they talked about will be training cannot check for everything.
DOJ to receive property data only from the incident form. They do not want the property form.
DOJ receive raw xml in Fall idea
They do not want the xml.
F2 Help
Geri will set up a meeting with Brenda.
F2 Help Deadline by July 1st 2020
DOJDAIT files should first be completed by DOJ
Meeting 5/24/2020 Agenda
Thursday, May 7, 2020
7:45 AM
AGENDA
2:30-3:30 Go over scenarios with law enforcement personal
DOJ and/or DA will have the scenarios they want to ask law enforcement
Summary of work
Proposal for closing a case
Demo of Parking.
Not a full transmission process
May 14, 2020 Incident Mtg with DA/DOJ
Thursday, May 14, 2020
2:15 PM
AGENDA - May 14 2020 from 2:30 - 4:00 PM - TEAMS Mtg
Attendees: Geri Polster, Mac Dempsey, Alesha Brown, Brenda Ray, Derek Veitenheimer, and Darlene Schwartz
Summary of work (Geri)
Can everyone get to the SharePoint site?
Yes - But Brenda doesn't know how to update the F2 Helps
Geri will set up a separate meeting to discuss
Property form:
Adjusted recovered fields and value fields gray and enable based on loss type.
Summary
Add Unknown Victim Type
Fixed the issue with the disappearing victim groups when violation changed.
Added programming to adjust Dynamic lists if main linking group deleted. The fields affected by dynamic lists are
Arrest Group -->Associated Offenses
Individual(Subject) Group--> Associated Offenses
Relationships -->Associated Offenses
Relationships -->Offender
Other Person -->Linked To
Other Person-->Parent OF
Property-->Associated Offenses
Victim-->Associated Offenses
Individual(subject) Group --> Relationship offender
Reports
Office
Attachment Form
Need to ask FAC
Generated all the F2 Helps
Violation (Offense) Fields (DOJ)
DOJ would like the Cleared Exceptionally and Date Cleared Fields removed and put in the Summary Group
Should they be one field?
Want to add Unfounded and Deleted Records
Should they be in one field?
Unfounded means something was reported, but through investigation it did not happen
Deleted means that there was a keying error or it was a duplicate
If LEA sent a couple of offenses sent to DOJ and then they want to delete those offenses
If LEA sent to DOJ (duplicate) they want it deleted.
If LEA sent it and now want it to be non-reportable, then send to DOJ
More discussion and decisions needed for the Unfounded/Deleted fields
Mac will send Geri "something" tomorrow
Loss type with Measure vs Value for Drugs (DOJ)
(Geri please add your comments)
Property demo (Geri please add your comments)
Is there a risk from the user stand point, have a stolen and recovered item.
Training issue - Could you have LEA put it an item was stolen and it was recovered
DOJ to receive property data (Geri needs to explain what she did)
with the incident form (a summary)
Linked to offenses
with the property form (raw data)
Not linked to offenses
DOJ doesn't want the Property Form data sent to them
DOJ receive raw xml in Fall idea
Do they want to receive the XML data starting this fall?
No, they wouldn't be able to have a Web Service set up in time for this fall.
Maybe we could send a 'handful' of different zipfiles
F2 Help
Have DOJ start working on the DAIT/DOJ Help Files first
July 1, 2020 deadline
New TraCS Pack with current Incident Form
Geri will package a new release on Monday or Tuesday and get it to DOJ and some Incident Work Group agencies
Next Meeting
Invite LEA's to the next meeting to get their input on how they complete the form based on different scenarios
Start with the OWI scenario
September 22, 2020
Thursday, September 17, 2020
12:45 PM
Incident Form 2021 Release Plan
2020 Fall Package release
Questions?
Drop Down lists
Race
Pacific Islander
Federal government
Committee
FBI Certification
Multi choice?
eCitation rules and stricter than eReferral Good Brenda.
DOJ
Get a test server set up at DOJ by end of Jan 2021 or As soon as possible
May to June
Have database ready for testing
Field naming by January
Provide Xslt to TraCS by end of 2020
Interface to directly change a status without sending a form end of March 2021
NIBRS Edits/rules
How DOJ will process incidents (splitting) by end of 2020
DOJ/TraCS/Work Group
Work on any additional rules needed in TraCS to submit to DOJ
Additional functionality like auto-populate
Evidence form
Supplemental form
F2 Help
TraCS
Added NIBRS Rules as soon as possible end of March
Additional forms
Additional functionality
Phase 2 of property—Sum the property form into the incident form completed by end of march
Transmission to DOJ
Status Changes to DOJ
DOJ
Get a Production Server Set up by end of June 2021 UFAD until last 2 weeks.
TraCS for other partners - Only if we have time.
DSPS—Prescription Drug Monitory Program Department of Safety and Professional services
DOC—Probation and Parole
HIDTA—Overdose
Other things if time
Work on interfacing with other DOJ departments
Human trafficking
Suspicious Activity Repotting-- DCI 5 fields Division of criminal investigation in DOJ
Cleary -- Department of Education not a state entity. Play by ear.
See about interfacing with DAIT
January 7th, 2021
Wednesday, December 16, 2020
10:37 AM
Agenda
Timeline
XSD -XML
Validation Rules
Submission Dates for Agencies
Tables
Do I have enough in the documentation?
Do you need the TraCS field names added
Added Not Applicable in WIBRS Drug Table-Discussion
Scenarios
5 or 6 of the most common so we can test on our side.
January 7th, 2021 Notes
Thursday, January 7, 2021
1:53 PM
Agenda
Timeline
XSD -XML
Validation Rules
Submission Dates for Agencies
Tables
Do I have enough in the documentation?
Do you need the TraCS field names added
Added Not Applicable in WIBRS Drug Table-Discussion
Scenarios
5 or 6 of the most common so we can test on our side.
Attendees: Dar, Geri, Brian, Gowri Karri, Alesha Brown, Mac Dempsey
Review of the timeline
We would like to be able to test for 6 months at least.
We are moving into the DOJ phase of the Incident form
Items
Validation rules spreadsheet has been updated by DOJ.
Would like to have all the rules by the end of this month
DOJ will have the majority of the rules to us by the end of the month.
XSD \ File Layout
Gowri will be working on the bulk of files
Brian will be emailing Mac and Gowri on Friday to set up a meeting about the XML file
Will need to create xml files as we process
How to process Incidents (splitting)
DOJ will receive the data from TraCS without any splitting
DOJ will be doing the splitting.
We are willing to add any additional fields that could help to know an incident needs to be split.
DOJ has had some discussion on this, but doesn't have a clean way to do this automatically.
More discussion is needed on Justifiable Homicide
Also group wants to collect Run away data, but DOJ does not need this information.
Transmission to DOJ
Would like to have this ready by April 1st to start testing.
Form xml
Status change for exceptional clearance.
Database
Gowri has been working on the database since early December
Validation rules for TraCS developers
This has been started.
Summing of the Property
Need to scan the property and sum it to be able to send it to DOJ as a single number
Drugs can be handled in multiple ways
Seized
Stolen
Part of a crime (violator is using drugs)
Geri will be setting up individualized meetings to discuss how this works.
Menus / Ribbons
About 50% done
Working on the status transmission button
What will the xml contain?
Looking at sending to document number, and the clearance code value.
DOJ will want to see this file.
Can the XSLT be utilized for this?
DOJ is planning on using a web service to validate both the XML versions.
Production Environment
XSD/XML
We are wanting the get these files.
Validation rule
Submission dates for agencies
Warning if incidents have an old date
May give a date of 1950 or so just so nothing silly is used for this field.
DOJ will continue to look at this, but they most likely will not have this changed to an error.
Tables
Review of Box account and contents
Validation Requirement spreadsheet
Used to list the requested validation
F2 Help
This is for DOJ when they make changes to files
We should try to keep the structure of the box files the same as the sharepoint files
A file for DOJ, DAIT, and DOJ DAIT shared folders
Codes and Code Text should be consistent for DOJ
Table Documentation
Review of document.
It would be helpful if the TraCS field names are included
Discussion
There may be risk in changing code values for existing values that has been sent to DOJ.
Victim Type
Removed other and society values per workgroup
Disposition
May need to add a column for DOJ codes
Suspected Drugs
Using SLH DRE drug list
We will be adding a WIBRS code column for conversion to send to DOJ
DOJ will be able to add the values.
Email the drug list to DOJ – Alesha
Will need to contact DOJ when SLH adds drugs to the table
V2WIBRS drug
Added code Z for Not applicable
DOJ has other drugs category.
Codes are used when dealing illegal drugs.
These codes would not be used when someone is under the influence,
UserLocation
Agencies with a location ID above 5000 are not law enforcement agency
These are satellite agencies using the law enforcement TraCS license
Zero Reports
Has there been discussion if they had no crimes to report?
We have not discussed this.
DOJ would like to have a mechanizim to report when agencies do not have anything to report this month.
Would not be able to send until after the first of the following month, similar to UFAD
V2WibrsOffense
Owned by TraCS, DOJ should not be making changes.
WIBRSArmed
Combination table that uses two codes.
Transmitted XML should contain the two fields separately
WibrsAge
DOJ should review to see if all the values they need are included.
Some of the codes are only valid for types of individuals
Offenders
Victims
V2Wibrs
Not applicble added
WIBRSLoss
This file will be used extensively for validations.
DOJ has code value of 1 that codes to None, we have N/A
They need to have None as the value.
If we need to have N/A then we will have to figure something out.
V2Wibrsdrug
Need to add X when more than 3 drugs are being sent.
Mac will check with FED manual to see if this is still being used with XML
WIBRSOffense
This table drives how the form works depending upon which codes are selected.
Added:
Runaway – as requested by workgroup committee
Non Reportable – as requested by workgroup committee for when it is not reportable to DOJ. These will not be sent.
WibrsProperty
Type field for use to place property into the correct group
Vehicle,
Firearm
Drugs
Default Low
Used when no value is given
Code value VO text changed to SELF instead of Victim was Offender
VIRBSWeapon
Combined with ?, but needs to be split in the XML
Changes will be made in the tables, then item is added to the history spreadsheet.
Documentation seems complete, but can ask for anything additional as needed.
Gowri asked if the tables during the discussion are the ones for DOJ database.
These are the tables used in TraCS
There may be times that a code will have to be modified when sent to DOJ
Scenarios
We would like to have DOJ provide us with a few scenarios we can use for testing purposes.
Some of the most common types would be helpful.
Additional questions
Gowri: When using a form and closing it, I am not able to edit.
Just need to click on the Edit Form button
If the form is validated, it will put it back in Open status.
Gowri: Associated offenses fields in Subject and Victim groups.
What is the difference between the fields
Subject offenses populate the Victim dropdown list.
What did the subject do to the victim?
January 20th, 2021
Wednesday, January 20, 2021
2:02 PM
Agenda
Assignments
Geri/Mac set up property review meeting
1/28/2021
Brian/Gowri set up xml meeting
1/12/2021
Brian sent an XML sample and the xsd file.
Gowri is not able to create XML on his machine.
Will remote in and troubleshoot.
Scenarios for Testing
Due 2/28/2021
Would like about 5 or 6 of them.
We will need to have the codes included.
Milestones review
Incident Form DOJ - DOJ Side Style Sheet XSLT
Gowri is working on them, but needs to be able to generate XML files.
Incident Form DOJ - DOJ Side NIBRS Edits Rules
Mac is mostly done with victim rules.
Property rules will be worked on after the incidnet meeting discussion property.
DOJ should be able to have the non property rules by end of month.
Incident Form DOJ - TraCS Validation Rules NIBRS
Spreadsheet items reviewed and status updates made.
Box Directories
We will moving SharePoint content to Box
Creating standards
DOJ content from SharePoint moved to Box
Please test to be sure you are able to access
Mac was able to log in and it looks good
Full Workgroup Meeting
2/10/2021
Send me any agenda items
Zero Reports have a question at the top or how to do
Agency report type default values
Meeting 2/18/2021 needs to be canceled
National TraCS Meeting
Additional questions
F2 help
Let DOJ know when they are moved to Box
Will need to have a good structure so everyone knows which files they are responsible for.
DOJ wants to be sure that they do not overwrite someone elses changes.
Incident workgroup
Let us know if there are any issues/question/needs that should be discussed
Need to know what will be transmitted as the Exceptional Clearance
How to report Zero Report Months
Can we add questions similar to UFAD?
Is there a standardized incident number?
The Form number is considered the incident number
The Police number field is a free form field that there is no standard format.
Can two different agencies have the same form/document number?
No they cannot.
Agencies may have duplicated form numbers, but we try to fix that.
Machine number is duplicated between 2 or more machines
Machine may have been rolled back to a restore point.
What is the Agency Report Type field content?
This is an agency controlled field and will be blank when installed
Agency are responsible for populating this table.
Can we put a couple of Default choices in the table and agencies could add more?
It is possible, but we have only done this once before.
Caution needed to be sure we don't have the some codes with different text.
Assignments
Geri:
Set up Box structure
Brian:
Get DOJ able to create XML samples on their machines.
February 4th 2021 agenda
Wednesday, February 3, 2021
7:37 AM
Updates on Assignments
Xml -- Brian/Mac/Gowri
Property -- Geri/Mac
Drug Table -- Alesha
Every group except property rule list -- Mac
Rules to discuss
Single Offense Code on incident
Rules that cannot be tested
Property loss fields
See Offense Table
Show list
Updates to Form
No Report
Property on Incident
Cargo Loss
Property/Evidence form
Milestones
Questions for Next Week Full Workgroup meeting
Future assignments.
Exceptional clearance -- Mac/Geri/Brian/Gowri
See what we would send
Zero Report xml -- Mac/Brian/Gowri
February 5th 2021
Friday, February 5, 2021
10:18 AM
Assignments
Need Race and Ethnicity tables
Property rules
Drug Table -- Alesha
Exceptional clearance -- Mac/Geri/Brian/Gowri
See what we would send
Zero Report xml -- Mac/Brian/Gowri
Xml programming DOJ
80% complete
Property format
Road blocks
More recent
property
How do we handle subjects that are not individuals like companies
Do not have age, race, sex
Treat like unknowns?
Hold
Programming
Justified Homicide
New assignments
DOJ need to review my tables
Need V2WIBRSAggAssaultHomicideCircumstances updated missing items
Move the location Type field from location to offense
April 15th, 2021
Thursday, April 15, 2021
12:48 PM
Attendees: Sandeep, Mac, Alesha, Gowri, Geri, Dar, Brian
Assignments
Fix report type table
Move location type field
Moved to Offense field
Get WIBRS Race table installed
Received WIBRS Race table from Derrick
WIBRS Ethnicity field was set to uppercase
Xslt
Do you need example xml for special circumstances?
Unknown Number of Subjects?
Need to send xml of this to DOJ
Mac and Gowri is working on xslt
Have received a few xml files from DSP
Will email Brian with some example scenarios needed.
Test Environment
We will be able to get a new pack out in May after BTHE is released.
When will the URL be ready?
Working on developing web service code
Still a few months away from having a draft environment available
Will still be able to do some testing with xml supplied by DSP
Test Hosted environment could be available for testing
After release of the May pack, we will be working in the Fall pack release
Would DOJ like to have access to test?
Would need to have a separate machine for this connection.
Cannot have TraCS installed
We would install a client version of TraCS to connect to BTHE Test
DOJ will like to discuss this option within their group.
Production version
DOJ may do some transmission in the future.
Need to develop protocols
When can we get a xml example of
Delete report
Exceptional clearance report
Working on finalizing data architecture now.
May be able to get examples with a week or two
Questions with rules
Line 19 -- Property Descriptions cannot be repeated.
for a loss type or over all loss types?
For a particular loss type.
Should only show description and amounts once per loss type.
If questions are added to the spreadsheet, we should email Mac to let him know.
Test Version
Have any questions for next week's workgroup meeting?
Next week Wednesday
Nothing off hand.
Can send questions up to end of day Tuesday.
DOJ Questions
Property xml.
Would like to have a corresponding screen shot or some other image of the form.
No report xml
Seeing more groups than expected.
If you want more groups removed let DSP know.
Not able to open the PDF that was sent.
Brian is working on getting this available.
April 29th 2021
Thursday, April 29, 2021
1:35 PM
Attendees: Brenda Ray, Gowri, Alesha, Sandeep, Geri, Brian
Assignments
Property Rules
Geri has these done
Xslt
Mac is working on getting this done.
Any more examples
The xml with property was received and looked good.
Incorporated into the XSLT
Hope to have it next week.
When can we get a xml example of
Delete report
Exceptional clearance report
Should be getting this next week.
Alesha and Travis are working on the drug list to put in their codes.
There are a few statutes that look out of date or don't exist.
Looking to see if they can get this updated.
When this list is complete, then send to DSP
Any other questions?
When will we be doing some testing?
On hold for the moment, until BTHE package is out.
Test Environment/Database
Will be having another meeting with their IT
Should be meeting next week.
More information next meeting.
May 13th, 2021
Monday, May 10, 2021
3:00 PM
Assignments
Xslt
Mac is working on getting this done.
Hope to have it next week.
When can we get a xml example of
Delete report
Phone number of submitter is only the agency phone number
Exceptional clearance report
The button would add the distribution to the form
Would need to transmit the form
There is no guarentee that the agency would transmit
We would include a message that the form needs to be transmitted.
Disposition codes
DOJ will need to transform the codes we send to their format
Referred to DA
This is set when first transmitted to DA
Would there be a time or situation where this may get changed?
Geri will program that only another Exceptional Clearance code could change this.
Will need to be sure that agencies don't refer to DA after DOJ gets it.
Button that says DA Failed to Prosecute is the same as Declined.
Geri will check on how Citations uses the Decline
In V2IncidentDisposition table they need to convert our code.
TraCS dispositions require a 2 number code
Needs to be validation
Change the transmitted to button so the next time the form transmits.
Via a button
Programming of Transmission process flow.
Merging into the form.
Brian set up the transmission waiting on url.
Programming of Transmission process flow
DA does not want to have incidents resent will small changes, only the large changes
Ready to merge the rules in the form.
Brian will be working on the transmission
URL is needed, but backend system is not needed
DOJ: It will be months before a working URL is created.
Will need to discuss their naming conventions and try to get something set up
Alesha and Travis are working on the drug list to put in their codes.
Travis working with CCAP to get them up to date
Geri will get this when is it complete
On hold for the moment, until BTHE package is out.
Our test environment.
Test Environment/Database
Report on meeting week of May 3rd
When will we be doing some testing?
June 1st first package.
On hold for the moment, until BTHE package is out.
Will there be a test plan available?
Yes, a plan will be available.
DOJ: Should we be testing everything or concentrate on Incident?
Should be looking at Incident, but need to test all.
DOT should have tested all validation rules before packaging.
Some validations rules may change from DOJ testing.
DOJ would like to split up testing into chunks.
Focus testing on certain areas and get them working before moving on to the next section.
Should be fairly easy to test until the Property section is tested as it is a new section.
Has DOJ given any thought to become web clients in our BTHE test environment?
They have a system in place that takes a day or two to get the updates to everyone.
They will continue the discussion to see if they feel this may be an option in the future.
They will contact their tech staff on how this may work.
Updates take about an hour on Mac's machine to download and install.
The update push for BJIA takes another hour or so.
Time Line discussion
DOJ has lost some staffing.
They still hope to have the working system by end of the year.
Their system design is still a work in progress.
We want to start the testing in June
Would like to have Alesha and other testers be part of the BTHE test.
DOJ could continue to work on their systems and then test the pack.
Test plan
A plan will be created for general testing as well as specific items.
The goal is to release the Fall Pack by the end of October
We will discuss with DOJ as the time gets closer about how/when to implement.
The "turn on date" is something to think about, but want to be sure DOJ can meet the date.
A lot of work was done last year, so we are just building on that.
UWSP has successfully transmitted a few eReferrals to DAIT.
Other questions?
No other discussion needed.
V2IncidentDisposition
CodeValue | CodeText |
54 | Unfounded |
61 | Offender Death |
62 | Declined |
63 | Other Jurisdiction |
64 | Victim Refused |
65 | Juvenile |
66 | Referred to DA |
June 10th 2021
Thursday, June 10, 2021
9:19 AM
Process flow programming (Geri)
Complete
Transmission programing (Brian)
Started
XSLT(Mac)
Progress
Good draft end of next week
Test Environment
Progress
End of next week
Statutes (Travis)
Travis contacted Andrea Olson directly on 5-24 and she said she would work to get the statutes updated.
Questions
June 24th 2021
Thursday, June 10, 2021
9:19 AM
Test Environment
Package Create
Issue with Tables
Transmission programing (Brian)
Started
DOJ does not have servers set up.
Will send a fake URL so we can test the failed transmission.
XSLT(Mac)
Progress
Good draft end of next week
Working with a limited amount of samples.
After export is setup, they should be able to do additional testing.
Will send a draft version soon.
Demo Evidence form
Related to DOJ
To copy data from evidence form to incident.
Officers will bring in data via button
They are used to doing this with other forms.
If data is changed on either form, they should import again
Can also be changed manually.
Form that will receive the data must be in Edited status.
What status must a form be in that data is copied from?
This has not been coded yet so it can be whatever you want.
First thoughts
Geri will check if the field is filled in before importing.
DOJ may want to form to be Validated, but will do some additional checking and report back.
Validation rule discussion
Will leave DSP decide which form the validations should be done on.
Users
Need to add Evidence Reporter access levels to see evidence form.
Will need to log into Config Manager as 333 or 00001 in order to assign the access level.
Questions
No additional questions.
July 8th 2021
Thursday, July 8, 2021
12:53 PM
Test Environment
Transmission programing (Brian)
When will we get the url
XSLT(Mac)
When will we get the draft that was promised
Adding Property
Don't need evidence form
Questions
July 22nd 2021
Thursday, July 22, 2021
2:15 PM
Attendees: Geri, Mac, Gowri, Alisha, Brenda
Showed Gowri how to fix rules by looking up the rule in Mac’s spreadsheet.
DOJ has a timeline for getting the first round of bug fixes to me.
They will be complete by next Friday and Mac will get me the proofed list by Aug 3 or 4th.
Looks like minor miscommunications so far. Nothing big. (Mac)
I told them I would not make the next meeting and it would be up to Dar/Brian if they wanted to cancel.
August 19th 2021
Thursday, August 19, 2021
9:07 AM
Justifiable Homicides (09C)
We should have discussed this with you sooner, but Justifiable Homicides are unique as compared to other UCR offenses in that they are not a crime and cannot be linked to a statute. Let’s discuss the range of impacts that this might have, especially with regard to:
(1) allowing them to be reported without a linked statute and
I already does this there is a warning but it is a DA warning all DA and DOJ errors have warnings when that form type is not chosen to show that the form will have issues if they decide to change the form in some way.
(2) requiring Justifiable Homicide (09C) to be submitted separately and not in combination with crimes on the same incident form
This is not allowed not only is there a batch rule prevent it if they try and put any other offense into the form they get a rare popup message.
Notes:
Do you think that having the DA or WIBRS warnings on the form may cause confusion when completing a DA only or WIBRS only forms?
With training this should note be a problem.
What happens if another offense is added to a Justifiable Homicide incident?
There is a popup message that states this cannot be done.
The form will not validate if Justifiable Homicide and another offense is listed on the same form.
Having Multiple Statutes link to the Same UCR Code
We’ve brought this up previously, without ever coming up with a strategy. We cannot report the same UCR Offense Code multiple times with different linked fields. So, let’s discuss how we can best handle the situation where two statutes can link to the same UCR Offense Code. Currently the Incident Form allows you to select the same UCR Offense Code twice in that situation, which then allows you to fill out the corresponding fields in a contradictory way.
Notes:
Hard to combine if the same code contains contradictory information.
Can the UCR offense be grayed out if this is the case, and send only the first one?
Maybe have a batch rule to check for duplicate offense codes and be sure that the information is the same.
Can the same offense code be set so it cannot be selected a second time?
This is a possibility and would have an entry of "duplicate".
Should be able to gray out the NIBRS fields in this case.
Will need to have really good training on this situation.
Validation message to explain what needs to be done.
Offense type--To reduce user confusion, we would like to only associate the "Person," "Property," and "Society" offense categories for Group A Offenses (and not for 90A, 90B, etc. Group B Offenses).
We cannot do that as that field runs almost the entire form.
I had Brenda go through and mark those offenses so as to work with the DA requirements.
Notes:
Group B offenses will be ignored by DOJ as the feds don't need that.
Would like to have the mapping for group b removed.
DA will need a victim for Group B offense.
Person, property, Society is set with the offense code.
NR is mapped to Society.
Could Society be changed the "Society / NA"
Yes, we can do this.
Incident time--I have some concern that time of incident auto populates to time when filling out the report. May be best to leave it blank to prevent data quality issues?
This is actually how all forms work. Most of the time at least one form is filled out at the time of the incident and the other forms are replicated/auto populated and the date time caries over from the other form.
They are actually very good at modifying the date/time if they fill out the form at a later date.
Do you want it to be blank for a time range.
Geri - Leave it blank when opened and use the incident time from other forms when the form is replicated.
We can eliminate the upper time range.
If unknown time is selected, gray out the field.
Subject Type--What is a "non-individual" and "unknown" subject vs an "individual" offender?
This is an extremely rare occurrence but it does happen.
Most of these don't tend to happen with something you would get.
In the xslt have that individual skipped.
Have a rule that at least one subject needs to be an individual or unknown.
This is the best solution.
Notes:
Non individual could be Corporate Pollution
FBI guidelines indicate that the CEO or the person reported to is listed as the individual. Most of these will end up as just being reported as unknown.
Will there be times when the non-individual is listed and then require an individual be added, that the individual will pass validation rules for race, sex and or other fields.
You cannot prosecute a corporation, you must have a named individual. (Brenda)
Corporate type of offenses end up at DATCP not at the DA.
DA can accept a non-individual, but they cannot accept subject as Unknown.
Victim type--"Other" is not listed as an option for victim type
The workgroup wanted this removed and stated they would never enter this.
Notes:
This is rare, but it needs to be added back as it is a Fed option.
ORI's--Would it be better to only allow ORIs selected through the dropdown? The FBI would reject records with an invalid ORI.
We do not have a list of all ORIs we only have a list of agencies TraCS uses so we have them pick the agency and put it in. All other agencies -- out of state or the few non tracs agencies which are very unlikely as they are 1/2 to 1 person agencies.
Notes:
DOJ does have a listing of all agencies ORI numbers.
DOJ will send the list over to us to review.
May need to remove some of the entries as the DA's and other agencies are included.
Other Discussions:
The arrest code does not have to be linked to the offense code or statute.
Disorderly Conduct statute, the codes could be Aggregated Assault
Don't match, owi stop with heroin found. Group A drug offense, but arrest sent is owi.
If it is a one to one, you can override the Offense code. If it multi list, then you cannot override.
DOJ will discuss whether the offense code should be allowed to be overwritten at all times and report back.
September 2nd 2021
Thursday, September 2, 2021
1:52 PM
Transmission
Bugs
WI Pack
Friday packaging
Testing
Need to do as much as we can now.
Questions
September 9nd 2021
Thursday, September 2, 2021
1:52 PM
Transmission
Still Configuring Dev web environment
Testing after completed
Month away
Turn on Date
Mid Jan
Bugs Fixed
Incident time
eliminate the upper time range.
If unknown time is selected, gray out the field
Leave Blank-Friday
Offense type
Could Society be changed the "Society / NA"
Arrest code
Added field
Victim Type
Other - Friday
WI Pack
Friday packaging
Testing
Need to do as much as we can now.
Questions
September 30 2021
Thursday, September 23, 2021
2:20 PM
Database setup
Bugs Fixed
Gave a list to Mac
WI Pack
Most likely next Friday
Testing
Need to do as much as we can now.
Questions
statsanalysis@doj.state.wi.us
From <https://teams.microsoft.com/multi-window/?agent=electron&version=21071502213>
October 14 2021
Thursday, September 23, 2021
2:20 PM
Database setup
Fall Pack release date
Bugs Fixed
Working on 1/3 complete
Property
Drop down lists
Drug Type -V2WIBRSDrug
Property Loss - V2WIBRSLoss
Removed Total Property field in summary
Auto set property group to open
Currently works only on Edit form if you click edit off and on again the group adds itself
Fixed it to add/delete correctly
?? Able to validate a robbery
WI Pack
Friday @ 1pm
Questions
F2 help directory in Box
October 14 2021
Thursday, September 23, 2021
2:20 PM
Database setup
Fall Pack release date
Bugs Question
When a nonzero number of Stolen Motor Vehicles is supplied, a Vehicle Type must also be supplied for at least one Property Description.
Questions
F2 help directory in Box
November 11th, 2021
Monday, November 1, 2021
9:06 AM
Agenda
Data Base Update (DOJ)
Transmission
List of Bugs complete by Nov 15th
Questions
November 30 2021
Tuesday, November 30, 2021
12:56 PM
Here are the items
lines 92-- Validation #SP0560 works now (that if it’s a property offense that is attempted, the loss type has to be None or Unknown). But when you select none or unknown, I now get an error that says a stolen or recovered property record must be included for certain ucr property crimes.
I put in attempted burglary
Loss type = none
Clicked validate and all property errors were gone.
Can you tell me a scenario where this doesn’t work?
I might have fixed it as I did have to make changes.
lines 61, 64, 67, 69, 70, 72, 75—Property validations I keep getting failures because of attempted completed not being correct but these issues don’t have attempted completed as a attribute to look at. I am using table field to determine the loss type needed but I don’t think I have all the attempted completed items on one correct. I did modify it since last update as it was triggering on non property offenses. I have 2 rules one for attempted and one for all offense statuses but I keep getting conflicting comments but in the second rule none of your validations specified the offense status being attempted or completed.
line 11 --"Cargo Theft?" should be a required field for WIBRS Reports. UPDATE: Cargo Theft is a required field, but only for Cargo Theft applicable offenses listed in our WIBRS Spec.
Based on this should cargo theft be in the offense group?
I will also need a new column in the offense table to trigger a requirement
I put a field in the table up on Box
line 23 -- LEOKA Other Jurisdiction allows any input currently (even though it defaults to the selected ORI).
We cannot prevent all issues but that is where your Schema errors come in. I can put rules in and exclude characters.
We need to leave it open because we will never have all the ORI’s available.
9 digits exclude all characters
Line 48 - Victim Validation #SV3153 is not being thrown when it should be. I am only looking at the first age field I need some suggestions on how to compare an age range.
Line 99—“ The "Attempted/Completed" field should always be required for all offense codes, and currently isn't being required. àThere is an error for this, “Error: Offense Status Required" Triggers for every type of form except no report. If you don’t like the verbiage DOJ needs to give me the verbiage you want.
Offense attempted completed status required
Line 100—" if I enter more than one property description then clear the description the row won’t go away that gets cleared out. “this is how the form is supposed to work. if they don't want the property row they have to manually delete it. All forms work this way. This would be problematic if I delete the row with code.
Line 8 -- To reduce user confusion, we would like to only associate the "Person," "Property," and "Society" offense categories for Group A Offenses (and not for 90A, 90B, etc. Group B Offenses).
This is not a DOJ field it is a mechanical field and used more for the DA. I added my first rule for DOJ connected to this field last week.
I only use DOJ terminology because I thought I would be using it for both DA and DOJ
Transmission
Dec 9th 2021
Thursday, December 9, 2021
1:14 PM
Transmission (Brian/Mac)
How is it going
Bulk Transmission
My question is when you process our response, do you rely both on SuccessFlag & ReturnCode or only on SuccessFlag?
DOJ perform the following things once we receive the request from TraCS.
1. Schema validations through XSD
2. Insert your data from XML into our History tables
3. Business validations
4. Insert validated into Primary tables if no validation errors.
If step 1 or 3 fails for any validations, currently our process is sending the SuccessFlag as “true” with ReturnCode “200”. I will be changing to “false” with ReturnCode “101” similar to UOF.
Pack (Geri)
Error you received.
Need to drop a table before the next update
V2LocationAtStreet
Questions
January 6th, 2022
Thursday, January 6, 2022
12:47 PM
Transmission (Brian/Mac)
Pack(Geri)
Next Friday
Issues - screen shots?
Questions
January 20th, 2022
Thursday, January 6, 2022
12:47 PM
Issues
Transmission (Brian/Mac)
Pack(Geri)
Questions
February 3rd, 2022
Thursday, January 6, 2022
12:47 PM
Issues
Transmission (Brian/Mac)
Pack(Geri)
Questions
February 17th, 2022
Thursday, January 6, 2022
12:47 PM
Issues
17 new
Transmission (Brian/DOJ)
Questions
March 3rd, 2022
Thursday, January 6, 2022
12:47 PM
Issues
Did I get all of them added to the list?
Update the tables
F2 Help
Transmission (Brian/DOJ)
DOJ Update
Questions
March 16th, 2022
Thursday, January 6, 2022
12:47 PM
Agenda
Transmission
Issue List
WebServices Server-Side
Changes to your web service issues we need notice of. UFAD and when Incident is released.
badgertracs@dot.wi.gov
Questions
March 31st 2022
Thursday, March 31, 2022
1:00 PM
Transmission
Issue List
Arrest rules
All fields required except juvenile disposition
Geri will check on table changes in the WIPack
Questions
April 14th 2022
Thursday, March 31, 2022
1:00 PM
Transmission
DOJ Update time line
Issue List
Questions
April 28th 2022
Thursday, March 31, 2022
1:00 PM
Testing - DOJ
F2 Help - Brian
Questions
June 9th 2022
Thursday, March 31, 2022
1:00 PM
Package
Testing - DOJ
Questions
Related content
email badgertracs@dot.wi.gov or call 608-267-2096