/
Worksheet 7: Data Population - MCSAP

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