RO_Attachment_A_TKTDATAP-UD8_field_layout_positions.doc

112 KB Posted

Attached to
Citation Issuance & Mobile LPR
Solicitation number
RFP-RO-2025-021
Issued by
Oakland County, Michigan

About this file

Written by GovTribe AI ·

The document is a technical specification file (RO_Attachment_A_TKTDATAP-UD8_field_layout_positions.doc) detailing a comprehensive data structure for ticket/citation recording, primarily for law enforcement and judicial processing in Michigan. The file appears to be associated with a City of Royal Oak procurement opportunity for Citation Issuance & Mobile LPR (License Plate Recognition) systems, with electronic proposals due on Wednesday, April 2, 2025, at 1:00 pm through the city's procurement portal. The technical specification provides an extensive field layout for capturing detailed information about citations, including personal identifiers, vehicle details, offense information, court proceedings, and administrative metadata.

The data structure supports comprehensive citation tracking across multiple dimensions, including personal information (name, address, driver's license), vehicle details (registration, make, color), offense specifics (type, codes, location), and procedural elements like court appearances, bond amounts, and case dispositions. The system appears designed to standardize citation data collection across jurisdictions, with specific fields for tracking civil infractions, misdemeanors, felonies, and associated administrative processes. The procurement opportunity suggests the city is seeking a modern, integrated electronic citation and mobile data collection system that can efficiently capture, process, and manage law enforcement citation information with high levels of detail and standardization.

View the file

Other files

File Type Posted
Citation_Issuance_&_Mobile_LPR_(Addendum_#1_Revision).pdf PDF
20250224_RO_Citation_Issuance_&_Mobile_LPR_RFP_Items_FINAL.docx DOCX document
20250224_RO_Citation_Issuance_&_Mobile_LPR_TCM.xlsx XLSX spreadsheet
20250224_RO_Citation_Issuance_&_Mobile_LPR_Pricing_Workbook.xlsx XLSX spreadsheet
20250224_RO_Citation_Issuance_&_Mobile_LPR_SOW_FINAL.docx DOCX document
RO_Attachment_B_UD-8_Supplemental_field_information.doc DOC document

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

5769PW1 V4R4M0 990521 SEU SOURCE LISTING 04/24/03 09:05:05 PAGE 1

SOURCE FILE . . . . . . . OSMDCST/DISTRICT

MEMBER . . . . . . . . . TKTRECWS

SEQNBR*...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6 ...+... 7 ...+... 8 ...+... 9 ...+... 0

100 *****************************************************************

200 * TKTDETLP DATA ELEMENTS FROM UD-8 FORM *

300 * FOR COPYING INTO WORKING STORAGE - TKTRECWS COBOL COPY MBR *

400 * Fields in Red used by JIS *

500 * NOTES: ALL DATES ARE MMDDCCYY *

600 * ALL NUMERIC FIELDS ARE RIGHT JUSTIFIED *

700 * ALL Y/N FLAGS ARE STORED IN THE D.B. AS 1/0; (1=Y,0=N)*

800 *****************************************************************

900 01 TKT-DATA.

1000 03 TKT-RECORD. Position Length Type

1100 05 TACTIONCD PIC X(3).

alphanumeric 1200 * Action Code - Used Internally = “ADD”

1300 05 TTICKETNO PIC X(20).

alphanumeric

1400 * Left just/blank filled. DC Case = X(10)

1500 05 TCURRMTH PIC 99.

1600 * Current Month

1700 05 TCURRDAY PIC 99.

1800 * Current Day

1900 05 TCURRYEAR PIC 9(4).

2000 * Current Year - CCYY

2100 05 TCURRTIME PIC 9(4).

2200 * Current Time - Military

2300 05 TVICTIM PIC X.

2400 * Check Box - Y/N

2500 05 TDOTNO PIC X(15).

2600 05 TINCJURIS PIC X(3).

2700 * Incident Juris Number

2800 05 TINCSEQNO PIC 9(7).

2900 * Incident Sequence Number

3000 05 TINCYEAR PIC 9(4).

3100 * Incident Year - CCYY

3200 05 TINCJURSUB PIC XX.

3300 * Incident Juris Subunit Number A-Z,0-9,space

3400 05 TDEPTNO PIC 9(4).

numeric 3500 * Dept for both Officers 1 & 2

3600 05 TARRESTNO PIC X(15).

3700 05 TNOTESFLAG PIC X.

3800 * Flag for internal use by CJDC - Y/N

3900 05 TOFCRANK2 PIC X(8).

4000 * Officer Rank 2

4100 05 TOFCFNAME2 PIC X(18).

4200 * Officer First Name 2

4300 05 TOFCMNAME2 PIC X(18).

4400 * Officer Middle Name 2

4500 05 TOFCLNAME2 PIC X(18).

4600 * Officer Last Name 2

4700 05 TOFCIDNO2 PIC X(5).

alphanumeric 4800 * Officer ID Number 2

4900 05 TCOURTOFC2 PIC X(5).

5000 * Court/Officer Assigned Number 2

5100 05 TBAC PIC X(10).

5200 05 TDEVICE PIC X(10).

5300 05 TPEOPLECD PIC 9.

5769PW1 V4R4M0 990521 SEU SOURCE LISTING 04/24/03 09:05:05 PAGE 2

SOURCE FILE . . . . . . . OSMDCST/DISTRICT

MEMBER . . . . . . . . . TKTRECWS

SEQNBR*...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6 ...+... 7 ...+... 8 ...+... 9 ...+... 0

5400 * People CD (1=City;2=Village;3=Twnshp;4=Cnty;5=State)

5500 05 TPEOPLELC PIC X(20).

5600 * People Location

5700 05 TPAGE1 PIC 9.

5800 05 TPAGE2 PIC 9.

5900 05 TOFFNMTH PIC 99.

6000 * Offense Month

6100 05 TOFFNDAY PIC 99.

6200 * Offense Day

6300 05 TOFFNYEAR PIC 9(4).

6400 * Offense Year - CCYY

6500 05 TOFFNTIME PIC 9(4).

6600 * Offense Time - Military Time

6700 05 TBIRTHMTH PIC 99.

6800 05 TBIRTHDAY PIC 99.

6900 05 TBIRTHYEAR PIC 9(4).

7000 05 TDRVLICST PIC XX.

7100 * Drivers License State - LEIN/NCIC

7200 05 TDRVLICNO PIC X(20).

7300 * Drivers License - LEIN Standard

7400 05 TSSNO PIC 9(9).

7500 05 TRACE PIC X.

7600 * W,B,I,A,U - LEIN/NCIC Codes

7700 05 TSEX PIC X.

7800 * M,F,U

7900 05 THEIGHT PIC 9(3).

8000 05 TWEIGHT PIC 9(3).

8100 05 THAIR PIC X(3).

8200 * LEIN/NCIC Codes

8300 05 TEYE PIC X(3).

8400 * LEIN/NCIC Codes

8500 05 TOCCUPATN PIC X(25).

8600 05 TNAMEF PIC X(18).

8700 05 TNAMEM PIC X(18).

8800 05 TNAMEL PIC X(18).

8900 05 TNAMESUFX PIC X(3).

9000 * Name/Suffix - LEIN/NCIC Codes

9100 05 TADDRNO PIC X(10).

9200 05 TADDRDIR PIC XX.

9300 * Address Direction - N,E,W,S,NE,SE,SW,NW

9400 05 TSTREET PIC X(24).

9500 * LEIN/NCIC

9600 05 TSTREETSFX PIC X(4).

9700 05 TAPTNO PIC X(5).

9800 05 TCITY PIC X(19).

9900 05 TSTATE PIC XX.

10000 * LEIN/NCIC Codes

10100 05 TZIP PIC X(9).

10200 05 TVEHREGNO PIC X(8).

10300 * Vehicle Registration No (Plate) - LEIN/NCIC

10400 05 TVEHREGST PIC XX.

10500 * Vehicle Registration State - LEIN/NCIC Codes

10600 05 TVEHREGYR PIC 9(4).

5769PW1 V4R4M0 990521 SEU SOURCE LISTING 04/24/03 09:05:05 PAGE 3

SOURCE FILE . . . . . . . OSMDCST/DISTRICT

MEMBER . . . . . . . . . TKTRECWS

SEQNBR*...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6 ...+... 7 ...+... 8 ...+... 9 ...+... 0

10700 05 TVEHYEAR PIC 9(4).

10800 05 TVEHMAKE PIC X(4).

10900 * Vehicle Make - LEIN/NCIC Codes

11000 05 TVEHCOLOR1 PIC X(3).

11100 * Vehicle Color1 - LEIN/NCIC Codes

11200 05 TVEHCOLOR2 PIC X(3).

11300 * Vehicle Color2 - LEIN/NCIC Codes

11400 05 TVEHSTYLE PIC XX.

11500 * Vehicle Style - LEIN/NCIC Codes

11600 05 TVEHTYPE PIC XX.

11700 * Vehicle Type - LEIN/NCIC Codes

11800 05 TLOCALORD PIC X.

11900 * Local Ordinance - Y/N

12000 05 TSTATELAW PIC X.

12100 * State Law - Y/N

12200 05 TADMINRULE PIC X.

12300 * Administrative Rule - Y/N

12400 05 TCONSRVORD PIC X.

12500 * Conservation Order - Y/N

12600 05 TDIRORD PIC X.

12700 * Director's Order - Y/N

12800 05 TUPNPREFX PIC XX.

12900 * Upon Prefix - Future Expansion to Match UD-10

13000 05 TUPNSTREET PIC X(24).

13100 05 TUPNSUFIX PIC X(4).

13200 * Upon Suffix - Future Expansion to Match UD-10

13300 05 TUPNDIR PIC XX.

13400 * Upon Direction - Future Expansion to Match UD-10

13500 05 TUPNDIST PIC X(4).

13600 * Upon Distance - Future Expansion to Match UD-10

13700 05 TUPNFEETML PIC XX.

13800 * Upon Feet/Mile - Future Expansion to Match UD-10

13900 05 TATNRPREFX PIC XX.

14000 * At or Near Prefix - Future Expansion to Match UD-10

14100 05 TATNRSTRET PIC X(60).

14200 * At or Near Street

14300 05 TATNRSUFIX PIC X(4).

14400 * At or Near Suffix - Future Expansion to Match UD-10

14500 05 TCTCASTYP1 PIC X(2).

14600 * Criminal/Traffic Case Type 1 - (EX,FY,OM,SM,FD,FT,OD,OI,OT,SD,SI,ST,OK,ON,SK,SN)

14700 05 TSOSCD1 PIC X(4).

14800 * SOS Offense Codes for Conviction and FAC/FCJ Reporting

14900 05 TCTCASTYP2 PIC X(2).

15000 * Criminal/Traffic Case Type 2 - (EX,FY,OM,SM,FD,FT,OD,OI,OT,SD,SI,ST,OK,ON,SK,SN)

15100 05 TSOSCD2 PIC X(4).

15200 * SOS Offense Codes for Conviction and FAC/FCJ Reporting

15300 05 TCTCASTYP3 PIC X(2).

15400 * Criminal/Traffic Case Type 3 -(EX,FY,OM,SM,FD,FT,OD,OI,OT,SD,SI,ST,OK,ON,SK,SN)

15500 05 TSOSCD3 PIC X(4).

15600 * SOS Offense Codes for Conviction and FAC/FCJ Reporting

15700 05 TWITHIN PIC 9.

15800 * (1=City;2=Village;3=Township)

15900 05 TWITHINCD PIC 99.

5769PW1 V4R4M0 990521 SEU SOURCE LISTING 04/24/03 09:05:05 PAGE 4

SOURCE FILE . . . . . . . OSMDCST/DISTRICT

MEMBER . . . . . . . . . TKTRECWS

SEQNBR*...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6 ...+... 7 ...+... 8 ...+... 9 ...+... 0

16000 * Within Name Code - LEIN/MICR City/Township Codes

16100 05 TCOUNTY PIC 99.

16200 * County Number

16300 05 TCIVINFR1 PIC X.

16400 * Civil Infraction 1 - Y/N

16500 05 TCIVINFR2 PIC X.

16600 * Civil Infraction 2 - Y/N

16700 05 TCIVINFR3 PIC X.

16800 * Civil Infraction 3 - Y/N

16900 05 TMISDEM1 PIC X.

17100 05 TMISDEM2 PIC X.

17200 * Misdemeanor 2 - Y/N

17300 05 TMISDEM3 PIC X.

17400 * Misdemeanor 3 - Y/N

17500 05 TFELONY1 PIC X.

17600 * - Y/N

17700 05 TFELONY2 PIC X.

17800 * - Y/N

17900 05 TFELONY3 PIC X.

18000 * - Y/N

18100 05 TWARNING1 PIC X.

18200 * - Y/N

18300 05 TWARNING2 PIC X.

18400 * - Y/N

18500 05 TWARNING3 PIC X.

18600 * - Y/N

18700 05 TFUGITIV1 PIC X.

18800 * - Y/N

18900 05 TFUGITIV2 PIC X.

19000 * - Y/N

19100 05 TFUGITIV3 PIC X.

19200 * - Y/N

19300 05 TWAIVE1 PIC X.

19400 * - Y/N

19500 05 TWAIVE2 PIC X.

19600 * - Y/N

19700 05 TWAIVE3 PIC X.

19800 * - Y/N

19900 05 TAUTHPND1 PIC X.

20000 * Authorization Pending 1 - Y/N

20100 05 TAUTHPND2 PIC X.

20200 * Authorization Pending 2 - Y/N

20300 05 TAUTHPND3 PIC X.

20400 * Authorization Pending 3 - Y/N

20500 05 TMCLCODE1 PIC X(15).

20600 05 TMCLCODE2 PIC X(15).

20700 05 TMCLCODE3 PIC X(15).

20800 05 TPACCODE1 PIC X(21).

20900 05 TPACCODE2 PIC X(21).

21000 05 TPACCODE3 PIC X(21).

21100 05 TDESC1 PIC X(60).

21200 05 TDESC2 PIC X(60).

5769PW1 V4R4M0 990521 SEU SOURCE LISTING 04/24/03 09:05:05 PAGE 5

SOURCE FILE . . . . . . . OSMDCST/DISTRICT

MEMBER . . . . . . . . . TKTRECWS

SEQNBR*...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6 ...+... 7 ...+... 8 ...+... 9 ...+... 0

21300 05 TDESC3 PIC X(60).

21400 05 TOFNOTICE1 PIC X.

21500 * Offense Notice1 for Enhanced Penalties Applies for 21600 * the Violation - Y/N

21700 05 TOFNOTICE2 PIC X.

21800 * Offense Notice2 for Enhanced Penalties Applies for 21900 * the Violation - Y/N

22000 05 TOFNOTICE3 PIC X.

22100 * Offense Notice3 for Enhanced Penalties Applies for 22200 * the Violation - Y/N

22300 05 TBONDAMT1 PIC 9(4)V9(2).

22400 * Bond Amount 1

22500 05 TBONDAMT2 PIC 9(4)V9(2).

22600 * Bond Amount 2

22700 05 TBONDAMT3 PIC 9(4)V9(2).

22800 * Bond Amount 3

22900 05 TCURRTYP1 PIC XX.

23000 * Currency Type 1 - US,OT(Other)

23100 05 TCURRTYP2 PIC XX.

23200 * Currency Type 2 - US,OT(Other)

23300 05 TCURRTYP3 PIC XX.

23400 * Currency Type 3 - US,OT(Other)

23500 05 TOFNCD1 PIC 9(4).

23600 * Offense Code 1 - MICR/UD-8 Codes

23700 05 TOFNCD2 PIC 9(4).

23800 * Offense Code 2 - MICR/UD-8 Codes

23900 05 TOFNCD3 PIC 9(4).

24000 * Offense Code 3 - MICR/UD-8 Codes

24100 05 TCNSRVFEE1 PIC X.

24200 * Conservation Fee 1 - Y/N

24300 05 TCNSRVFEE2 PIC X.

24400 * Conservation Fee 2 - Y/N

24500 05 TCNSRVFEE3 PIC X.

24600 * Conservation Fee 3 - Y/N

24700 05 TSPEED1 PIC 9(3).

24800 05 TSPEED2 PIC 9(3).

24900 05 TSPEED3 PIC 9(3).

25000 05 TSPEEDLMT1 PIC 99.

25100 05 TSPEEDLMT2 PIC 99.

25200 05 TSPEEDLMT3 PIC 99.

25300 05 TSPEEDFRM1 PIC 99.

25400 * Speed Formerly 1

25500 05 TSPEEDFRM2 PIC 99.

25600 * Speed Formerly 2

25700 05 TSPEEDFRM3 PIC 99.

25800 * Speed Formerly 3

25900 05 TCHARGENO PIC 9.

26000 * Number of Original Charges on this Ticket

26100 05 TREMARKS PIC X(200).

26200 05 TVEHIMPND PIC X.

26300 * Vehicle Impound - Y/N

26400 05 TTRAFCRSH PIC X.

26500 * Traffic Crash - Y/N

5769PW1 V4R4M0 990521 SEU SOURCE LISTING 04/24/03 09:05:05 PAGE 6

SOURCE FILE . . . . . . . OSMDCST/DISTRICT

MEMBER . . . . . . . . . TKTRECWS

SEQNBR*...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6 ...+... 7 ...+... 8 ...+... 9 ...+... 0

26600 05 TDMGPROP PIC X.

26700 * Damage to Property - Y/N

26800 05 TINJURY PIC X.

26900 * - Y/N

27000 05 TDEATH PIC X.

27100 * - Y/N

27200 05 TACTMILSRV PIC X.

27300 * Active Military Service - Y/N

27400 05 TBNDTOTAMT PIC 9(4)V9(2).

27500 * Local Court Bond Total

27600 05 TLICPOSTED PIC X.

27700 * License Posted in Lieu of Bond - Y/N

27800 05 TAPPRNCERT PIC X.

27900 * Appearance Certificate - Y/N

28000 05 TNONE PIC X.

28100 * - Y/N

28200 05 TAPPRDATE PIC X.

28300 * Appearance Date - Y/N

28400 05 TAPPRDTWI PIC 99.

28500 * Appearance Date Within

28600 05 TAPPRMTH PIC 99.

28700 * Appearance Date Month

28800 05 TAPPRDAY PIC 99.

28900 * Appearance Date Day

29000 05 TAPPRYEAR PIC 9(4).

29100 * Appearance Date Year - CCYY

29200 05 TAPPRTIME PIC 9(4).

29300 * Appearance Date Time - Military Time

29400 05 TLODGED PIC X.

29500 * - Y/N

29600 05 THEARDATE PIC X.

29700 * Hearing Date - Y/N

29800 05 THEARDTWI PIC 99.

29900 * Hearing Date Within

30000 05 THEARMTH PIC 99.

30100 * Hearing Date Month

30200 05 THEARDAY PIC 99.

30300 * Hearing Date Day

30400 05 THEARYEAR PIC 9(4).

30500 * Hearing Date Year - CCYY

30600 05 THEARTIME PIC 9(4).

30700 * Hearing Date Time - Military Time

30800 05 TCONTACTCT PIC X.

30900 * Contact Court - Y/N

31000 05 TJUVTRFMIS PIC X.

31100 * Juvenile Traffic Misdemeanor - Y/N

31200 05 TFORMLHEAR PIC X.

31300 * Formal Hearing Required Court will Notify - Y/N

31400 05 TCOURTORI PIC X(9).

31500 * Court ORI

31600 05 TSERVED PIC X.

31700 * - Y/N

31800 05 TOFCRANK1 PIC X(8).

5769PW1 V4R4M0 990521 SEU SOURCE LISTING 04/24/03 09:05:05 PAGE 7

SOURCE FILE . . . . . . . OSMDCST/DISTRICT

MEMBER . . . . . . . . . TKTRECWS

SEQNBR*...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6 ...+... 7 ...+... 8 ...+... 9 ...+... 0

31900 * Officer Rank 1

32000 05 TOFCFNAME1 PIC X(18).

32100 * Officer First Name 1

32200 05 TOFCMNAME1 PIC X(18).

32300 * Officer Middle Name 1

32400 05 TOFCLNAME1 PIC X(18).

32500 * Officer Last Name 1

32600 05 TOFCIDNO1 PIC X(5).

alphanumeric 32700 * Officer ID Number 1

32800 05 TCOURTOFC1 PIC X(5).

32900 * Court/Officer Assigned Number 1

33000 05 TAGNCYORI PIC X(9).

33100 * Agency ORI

33200 05 TAGNCYNAM PIC X(30).

33300 * Agency Name

33400 05 TNBRPRINTD PIC 99.

33500 * Number Printed

33600 05 TRSNPRINTD PIC X(30).

33700 * Reason Printed if ticket was printed more than once

33800 05 TVOIDED PIC X.

33900 * Voided - Y/N

34000 05 TVOIDEDBY PIC X(5).

34100 * Voided by Badge Number

34200 05 TRSNVOIDED PIC X(30).

34300 * Reason Voided

34400 05 TONLINE PIC X.

34500 * Online Indicator

* * * * E N D O F S O U R C E * * * *

Q:\DCS\Criteria\TKTDATAP-UD8 field layout positions.doc

File details come from the government source that posted it. Updated .