Badger TraCS Guides
Worksheet 7: Data Population - MCSAP
Worksheet 7: Data Population - MCSAP
Purpose: Gathers requirements for various automatic data populations of the form including instant search, violation search, replicate, and auto-populate.
Project Name: MCSAP
Form Name: MCSAP
Instant Search | |||
List fields that are triggers for instant search. Explain what the instant search does | |||
Trigger Field | Result | ||
Document.documentPoliceNumber | Populates police number from folder CFSNumber if available or from any existing form in the contact. | ||
Location.locationLiteralDescription | Populates location group from TLT. | ||
carrierUSDOTNumber | Looks up carrier information from Feds | ||
violationIssuedTo | Look up all people in form | ||
violationUnitNumber | Look up all units | ||
Violation Search | |||
List fields that use the violation search databar. Identify the violation search type as show in the Local Violation Manager and if more than one field is populated, explain what the violation search does. | |||
Trigger Field | Type | Result | |
violationFederalCode | Federal Safety Net |
| |
violationStatuteNumber | Traffic Violations |
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Replicate/Auto-populate | |||
List the forms that will receive data from this form. Explain the data that will be copied. | |||
To Form | Type | Result | |
ELCI | Replicate | Multiple forms | |
|
|
| |
|
|
| |
List the forms that will be the source of data to populate this form. Explain the data that will be copied. | |||
From Form | Type | Result | |
Warning | Auto-populate | Populates campaign and tag fields, date and time occurred, violation fields, location fields, and agency space. | |
ELCI | Auto-populate | Populates campaign and tag fields, date and time occurred, violation fields, location fields, and agency space. | |
NTC | Auto-populate | Populates campaign and tag fields, date and time occurred, violation fields, location fields, and agency space. | |
DNR | Auto-populate | Populates campaign and tag fields, date and time occurred, violation fields, location fields, and agency space. | |
Alcohol | Auto-populate | Populates campaign and tag fields, date and time occurred, violation fields, location fields, and agency space. | |
Incident | Auto-populate | Populates campaign and tag fields, date and time occurred, violation fields, location fields, and agency space. | |
UFAD | Auto-populate | Populates campaign and tag fields, date and time occurred, violation fields, location fields, and agency space. | |
Crash | Auto-populate | Populates campaign and tag fields, date and time occurred, violation fields, location fields, and agency space. | |
DNR Crash | Auto-populate | Populates campaign and tag fields, date and time occurred, violation fields, location fields, and agency space. | |
Citizen Contact | Auto-populate | Populates campaign and tag fields, date and time occurred, violation fields, location fields, and agency space. | |
Inspection | Auto-populate | Populates campaign and tag fields, date and time occurred, violation fields, location fields, and agency space. | |
Arrest | Auto-populate | Populates campaign and tag fields, date and time occurred, violation fields, location fields, and agency space. | |
Inspection | Replicate | Populates all common fields |
Related content
email badgertracs@dot.wi.gov or call 608-267-2096