Badger TraCS Guides

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 3 Current »

Worksheet 3: Data Dictionary - Warrant Reporting


Purpose: Create the data dictionary for a form

Form Name: Warrant Reporting

Name

Sort Order

Min Instances

Max Instances

Sub Group Of

Comment

Document

1

1

1

Summary

2

1

1

Details

3

0

99

Individual

4

0

99

Details

Involved Department

8

0

99

Details

Agency

6

1

1

Attachment

7

1

99

Field

Name

Group

Copy Existing Form

Data Type

Length

Data Bar

Subscriptions

Code Table Tab Link

Required

Additional Business Rules

Comment

Group #

agencyAddressMunicipality

Law Enforcement Agency City  

Agency  

Text

16

TEXT

agencyAddressState

Law Enforcement Agency State  

Agency  

Text

2

TEXT

V3State

agencyAddressStreet

Law Enforcement Agency Street Address  

Agency  

Text

30

TEXT

agencyAddressStreet2

Law Enforcement Agency Street Address 2  

Agency  

Text

30

TEXT

agencyAddressZipCode

Law Enforcement Agency Zip Code  

Agency  

Text

9

ZIP CODE

agencyAgencySpace

Agency Space  

Agency  

Text

200

TEXT

agencyBFUNCAgencyCode

BFUNC Agency  

Agency  

Text

4

TEXT

agencyDNROfficerIdentificationNumber

DNR Officer ID  

Agency  

Text

9

TEXT

agencyDOTOfficerIdentificationNumber

DOT Officer ID  

Agency  

Text

5

TEXT

agencyJurisdiction

Law Enforcement Agency Jurisdiction  

Agency  

Text

40

TEXT

agencyLawEnforcementType

Law Enforcement Agency Type  

Agency  

Text

3

SINGLE LIST

V3LawEnforcementAgencyType

agencyLocalAgencyNumber

Local Agency Number  

Agency  

Text

10

TEXT

agencyLocationID

TraCS Agency Number  

Agency  

Text

4

NUMBERS

agencyNameDepartment

Law Enforcement Agency Name  

Agency  

Text

30

TEXT

agencyOfficerBadgeNumber

Officer Badge Number  

Agency  

Text

20

TEXT

agencyOfficerEmail

Officer Email  

Agency  

Text

100

TEXT

agencyOfficerFaxNumber

Agency  

Text

20

PHONE

agencyOfficerNameFirst

Officer First Name  

Agency  

Text

15

TEXT

agencyOfficerNameLast

Officer Last Name  

Agency  

Text

30

TEXT

agencyOfficerNameMiddle

Officer Middle Name  

Agency  

Text

15

TEXT

agencyOfficerNameSuffix

Officer Suffix  

Agency  

Text

3

TEXT

agencyOfficerPhoneNumber

Agency  

Text

20

PHONE

agencyOfficerRank

Officer Rank  

Agency  

Text

8

TEXT

V2Rank

agencyOfficerRMSID

Officer RMS ID  

Agency  

Text

20

TEXT

agencyORINumber

ORI Number  

Agency  

Text

9

TEXT

agencyPhoneNumber

Law Enforcment Agency Phone Number  

Agency  

Text

20

PHONE

agencyTASAgencyName

TAS Agency Name  

Agency  

Text

30

TEXT

detailsAdditionalAgenciesFlag

Were Other Agency Present During Execution  

Details  

Text

1

SINGLE LIST

V2YesNo

detailsApprovedFlag

Was It Approved? 

Details  

Text

1

SINGLE LIST

V2YesNo

detailsBodilyHarmFlag

Execution Cause Great Bodily Harm? 

Details  

Text

1

SINGLE LIST

V2YesNo

detailsBodilyHarmKind

Kind of Bodily Harm  

Details  

Text

3

SINGLE LIST

V2DOJInjuriesOfficer

detailsDateApproved

Date Approved  

Details  

DateTime

10

DATE

detailsDateExecuted

Date Executed  

Details  

DateTime

10

DATE

detailsDateRequested

Date Requested  

Details  

DateTime

10

DATE

detailsDeathFlag

Did Execution Result in Death? 

Details  

Text

1

SINGLE LIST

V2YesNo

detailsEntryTypeApproved

Entry Type Approved 

Details  

Text

3

SINGLE LIST

V2DOJWarrantType

detailsEntryTypeExecuted

Entry Type Executed 

Details  

Text

3

SINGLE LIST

V2DOJWarrantType

detailsEntryTypeRequested

Entry Type Requested  

Details  

Text

3

SINGLE LIST

V2DOJWarrantType

detailsExecutedFlag

Was This Executed 

Details  

Text

1

SINGLE LIST

V2YesNo

detailsMultiAgencyTaskForceFlag

No Knock As Task Force  

Details  

Text

1

SINGLE LIST

V2YesNo

detailsOffenseCode

Suspected Crime Type 

Details  

Text

3

SINGLE LIST

V2WIBRSOffense

detailsSuspectsAtScene

Total Suspects Present At The Scene? 

Details  

Text

3

TEXT

detailsWhoseBodilyHarm

Who Sustained Bodily Harm 

Details  

Text

3

SINGLE LIST

V2DOJWhoAffected

detailsWhoseDeath

Whose Death 

Details  

Text

3

SINGLE LIST

V2DOJWhoAffected

detailsWrittenProperyInventoryFlag

Execution By Written Property inventory? 

Details  

Text

1

SINGLE LIST

V2YesNo

documentDateValidated

Initial Date Of Validation  

Document  

DateTime

10

DATE

documentDocumentNumber

Document Number  

Document  

Text

10

TEXT

documentFormRejectionReason

  

Document  

Memo

1000

NARRATIVE

documentMachineNumber

Machine Number  

Document  

Text

50

TEXT

documentPoliceNumber

Police Number  

Document  

Text

20

TEXT

documentReporting

Do you have anything to report this month?  

Document  

Text

1

SINGLE LIST

V2YesNo

documentReportingMonth

Reporting Month 

Document  

Text

2

SINGLE LIST

V2Month

documentReportingYear

Reporting Year

Document  

Text

4

YEAR

documentTags

Document Tags  

Document  

Memo

300

MULTI LIST

V2Tag

documentTracsMapNumber

Map 

Document  

Text

10

TEXT

documentTracsPackNumber

TraCS Baseline

  

Document  

Text

10

TEXT

documentTracsPatchNumber

TraCS Pack 

Document  

Text

10

TEXT

documentWisconsinFormRevisionDate

Version Date  

Document  

Text

4

TEXT

documentWisconsinFormVersion

WI Form Version Number  

Document  

Text

6

TEXT

individualAge

Age  

Individual  

Text

3

TEXT

individualDateOfBirth

Date of Birth 

Individual  

DateTime

10

BIRTH DATE

individualRace

Race  

Individual  

Text

1

SINGLE LIST

V2Race

individualSex

Sex  

Individual  

Text

1

GENDER

V2Sex

involveddepartmentsAgenciesNameDepartment

Involved Agency Name 

InvolvedDepartment  

Text

100

SINGLE LIST OTHER

V2ORIAgency

involveddepartmentsAgenciesPoliceNumber

Involved Agency Police/Case Number

InvolvedDepartment  

Text

20

TEXT

involveddepartmentsAgencyORI

ORI  

InvolvedDepartment  

Text

9

TEXT

summaryBodilyHarmFlag

Great Bodily Harm

Summary  

Text

1

SINGLE LIST

V2YesNo

summaryDateReported

Reported Date 

Summary  

DateTime

10

DATE

summaryDeathFlag

Deaths? 

Summary  

Text

1

SINGLE LIST

V2YesNo

summaryNoKnockExecutionFlag

No Knock Warrants Execution? 

Summary  

Text

1

SINGLE LIST

V2YesNo

summaryNoKnockRequestedFlag

No Knock Requested?  

Summary  

Text

1

SINGLE LIST

V2YesNo

summaryTimeReported

Reported Time  

Summary  

Text

5

MILITARY TIME UNKNOWN

summaryTotalApproved

Approved Warrants  

Summary  

Text

3

TEXT

summaryTotalBodilyHarm

Total Warrants Resulting in Bodily Injury 

Summary  

Text

3

TEXT

summaryTotalDeath

Total Warrants Resulting in Death 

Summary  

Text

3

TEXT

summaryTotalDenied

Denied Warrants  

Summary  

Text

3

TEXT

summaryTotalNoKnockExplicitAuthorization

Total No Knock Explicit Authorization  

Summary  

Text

3

TEXT

summaryTotalNoKnockNotRequested

Total Executed No Knock, Not Requested  

Summary  

Text

3

TEXT

summaryTotalRequested

Total Requested Warrants 

Summary  

Text

3

TEXT

summaryWhoseBodilyHarm

Whose Bodily Harm 

Summary  

Text

100

MULTI LIST

V2DOJWhoAffected

summaryWhoseDeath

Whose Death 

Summary  

Text

100

MULTI LIST

V2DOJWhoAffected

  • No labels