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 2 Current »

Worksheet 3: Data Dictionary - POLD


Purpose: Create the data dictionary for a form

Form Name: POLD

Name

Sort Order

Min Instances

Max Instances

Sub Group Of

Comment

Document

1

1

1

Location

2

1

1

Summary

3

1

1

Description

4

0

1

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 #

documentDateValidated

 

Document

Yes

Date

10

DATE

Yes

1

documentDocumentNumber

 

Document

Yes

Text

10

Text

Yes

1

documentFormRejectionReason

 

Document

Yes

Text

255

Text

1

documentMachineNumber

 

Document

Yes

Text

50

Text

Yes

1

documentPoliceNumber

 

Document

Yes

Text

20

Text

1

documentTags

 

Document

Yes

Text

200

Single List

V2Tag

1

documentTracsPackNumber

 

Document

Yes

Text

10

Text

Yes

1

documentTracsPatchNumber

 

Document

Yes

Text

10

Text

Yes

1

locationCountyDMV

 

Location

Yes

Text

2

Single List

V2CountyDMV

2

locationDirectionFromIntersection

 

Location

Yes

Text

1

Single List

V2LocationDirection

2

locationEstimatedDistance

 

Location

Yes

Text

10

Distance

2

locationFromAtHighwayDirection

 

Location

Yes

Text

2

Single List

V2LocationDirection

2

locationFromAtHighwayName

 

Location

Yes

Text

3

Text

2

locationFromAtHighwayType

 

Location

Yes

Text

3

Single List

V2LocationHighwayType

2

locationFromAtRoadwayType

 

Location

Yes

Text

50

Single List

V2LocationRoadwayType

2

locationFromAtStreetName

 

Location

Yes

Text

50

Single List Other

V2LocationStreet

2

locationLatitude

 

Location

Yes

Text

15

Latitude Longitude

2

locationLiteralDescription

 

Location

Yes

Text

50

Text

2

locationLongitude

 

Location

Yes

Text

15

Latitude Longitude

2

locationMunicipalityDMV

 

Location

Yes

Text

4

Single List

V2MunicipalityDMV

2

locationMunicipalityType

 

Location

Yes

Text

50

Single List

V2LocationMunicipalityType

2

locationOnHighwayDirection

 

Location

Yes

Text

2

Single List

V2LocationDirection

2

locationOnHighwayName

 

Location

Yes

Text

3

Single List

V2LocationHighway

2

locationOnHighwayType

 

Location

Yes

Text

3

Single List

V2LocationHighwayType

2

locationOnRoadwayLinkID

 

Location

Yes

Text

50

Text

2

locationOnRoadwayLinkOffset

 

Location

Yes

Text

50

Text

2

locationOnRoadwayType

 

Location

Yes

Text

50

Single List

V2LocationRoadwayType

2

locationOnStreetName

 

Location

Yes

Text

50

Single List

V2LocationStreet

2

locationOverrideFlag

 

Location

Yes

Text

1

Single List

V2YesNo

2

locationStructureNumber

 

Location

Yes

Text

10

Text

2

locationStructureType

 

Location

Yes

Text

3

Single List

V2LocationStructureType

2

locationXCoordinate

 

Location

Yes

Text

50

Text

2

locationYCoordinate

 

Location

Yes

Text

50

Text

2

agencyAddressMunicipality

 

Agency

Yes

Text

16

Text

6

agencyAddressState

 

Agency

Yes

Text

2

Text

V2State

6

agencyAddressStreet

 

Agency

Yes

Text

30

Text

6

agencyAddressStreet2

 

Agency

Yes

Text

30

Text

6

agencyAddressZipCode

 

Agency

Yes

Text

9

Zip Code

6

agencyAgencySpace

 

Agency

Yes

Text

200

Text

6

agencyBFUNCAgencyCode

 

Agency

Yes

Text

4

Text

6

agencyDNROfficerIdentificationNumber

 

Agency

Yes

Text

9

Text

6

agencyJurisdiction

 

Agency

Yes

Text

40

Text

6

agencyLawEnforcementType

 

Agency

Yes

Text

3

Single List

V2LawEnforcementAgencyType

6

agencyLocalAgencyNumber

 

Agency

Yes

Text

10

Text

6

agencyLocationID

 

Agency

Yes

Text

50

Numbers

6

agencyNameDepartment

 

Agency

Yes

Text

30

Text

6

agencyOfficerBadgeNumber

 

Agency

Yes

Text

20

Text

6

agencyOfficerEmail

 

Agency

Yes

Text

100

Text

6

agencyOfficerNameFirst

Agency

Yes

Text

15

Text

6

agencyOfficerNameLast

Agency

Yes

Text

30

Text

6

agencyOfficerNameMiddle

Agency

Yes

Text

15

Text

6

agencyOfficerNameSuffix

Agency

Yes

Text

3

Single List

V2Suffix

6

agencyOfficerRank

Agency

Yes

Text

8

Text

V2Rank

6

agencyORINumber

Agency

Yes

Text

9

Text

6

agencyPhoneNumber

Agency

Yes

Text

20

Phone

6

agencyTASAgencyName

Agency

Yes

Text

30

Text

6

attachmentAgencySpace

Attachment

Yes

Text

100

Text

7

attachmentConfidentialFlag

Attachment

Yes

Text

1

Single List

V2YesNoBlank

7

attachmentFile

Attachment

Yes

Attachment

7

attachmentFilename

Attachment

Yes

Text

100

Text

7

  • No labels