Badger TraCS Guides
Worksheet 3: Data Dictionary - Warrant Reporting
- Geraldine Polster
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 | 5 | 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 |
|
|
|
|
Related content
email badgertracs@dot.wi.gov or call 608-267-2096