RO_Attachment_B_UD-8_Supplemental_field_information.doc

DOC document 124 KB Posted

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

About this file

The document RO_Attachment_B_UD-8_Supplemental_field_information.doc appears to be a supplemental field information attachment related to the City of Royal Oak's electronic procurement opportunity for Citation Issuance & Mobile LPR (License Plate Recognition) services. The procurement will be conducted through the city's online procurement portal, with electronic proposals being accepted until 1:00 pm on Wednesday, April 2, 2025. The City of Royal Oak reserves the right to reject any or all proposals and to select the most favorable proposal based on their assessment.

The procurement details indicate that mailed, faxed, and emailed proposals will not be considered, with all submissions required through the specified procurement portal at https://procurement.opengov.com/portal/romi. In the event of mathematical errors in proposal pricing, the unit prices will take precedence. The city maintains flexibility in the proposal evaluation process, allowing for partial proposal acceptance and the ability to waive informalities in submitted proposals. Award results will be made publicly available through the procurement portal once proposal evaluations are completed.

View the file

Other files

On GovTribe

Work with this file

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

Text version

Supplemental UD-8 Field Definitions for JIS

Field Name
Description & Comments
Format
TACTIONCD
Action Code – ‘ADD’ for new tickets
Left justified
TTICKETNO
Ticket number – courts prefer 7 characters in order to leave room for a prefix & suffix (or use maximum of 9 characters if 2 digit year prefix is already part of ticket#, which leaves room for 1 character suffix).
Left justified
TDEPTNO
Officer department number – needs to be a valid officer department number used by the court.

If the department number is greater than four digits or contains alpha characters, enter 0000 in positions 68 thru 71, then enter the department number in the first 7 characters of the Agency Name field from 1302 thru 1308. The Agency Name can then be entered in positions 1309 thru 1331.

Numeric

TOFCIDNO2
Badge number of second officer involved – (optional)
Alpha left justified
TOFFNMTH
Offense date month – 2 digits
Numeric
TOFFNDAY
Offense date day – 2 digits
Numeric
TOFFNYEAR
Offense date year – 4 digits ccyy
numeric
TOFFNTIME
Offense time – 4 digits military time as hhmm
Numeric
TBIRTHMTH
Defendant’s month of birth – 2 digits (optional)
Numeric
TBIRTHDAY
Defendant’s day of birth – 2 digits (optional)
Numeric
TBIRTHYEAR
Defendant’s year of birth – 4 digits ccyy (optional)
Numeric
TDRVLICST
Defendant’s Driver license state abbreviation (optional)
Alpha
TDRVLICNO
Defendant’s Driver license number (optional)
Alpha
TSSNO
Defendant’s Social Security Number (optional)
Numeric
TRACE
Defendant’s race – valid NCIC race codes (optional)
Alpha
TSEX
Defendant’s sex (M, F, or U optional)
Alpha
TNAMEF
Defendant’s first name (optional)
Alpha
TNAMEM
Defendant’s middle name (optional)
Alpha
TNAMEL
Defendant’s last name (optional)
Alpha
TNAMESUFX
Defendant’s name suffix – NCIC codes (optional)
Alpha
TADDRNO
Defendant’s address number (optional)
Alpha
TADDRDIR
Defendant’s address direction – N, S, E, W, etc (optional)
Alpha
TSTREET
Defendant’s address street (optional)
Alpha
TSTREETSFX
Defendant’s address street suffix (optional)
Alpha
TAPTNO
Defendant’s address apartment number (optional)
Alpha
TCITY
Defendant’s address city (optional)
Alpha
TSTATE
Defendant’s address state – NCIC state codes (optional)
Alpha
TZIP
Defendant’s address zip code (optional)
Alpha
TVEHREGNO
Vehicle plate number
Alpha
TVEHREGST
Vehicle plate state – NCIC state codes
Alpha
TVEHREGYR
Vehicle plate expiration year – ccyy
Numeric
TVEHYEAR
Vehicle year – ccyy
Numeric
TVEHMAKE
Vehicle make – NCIC make codes
Alpha
TVEHCOLOR1
Vehicle color – NCIC codes
Alpha
TVEHSTYLE
Vehicle style – NCIC codes
Alpha
TVEHTYPE
Vehicle type – NCIC codes
Alpha
TLOCALORD
Local vs. state offense – If the ticket is written as a local ordinance offense, this field should contain a value of “1”.

If the ticket is written as a state offense, then this field should contain a value of “0”.

Alpha

TUPNPREFX
Offense location street name prefix (optional)
Alpha
TUPSTREET
Offense location street name (optional)
Alpha
TUPNSUFIX
Offense location street suffix - N, S, E, W, etc (optional)
Alpha
TUPNDIR
Upon direction - additional location information (Optional)
Alpha
TUPNDIST
Upon distance - additional location information (Optional)
Alpha
TUPNFEETML
Upon feet/mile - additional location information (Optional)
Alpha
TATNRPREFX
Offense location at or near street prefix (optional)
Alpha
TATNRSTRET
Offense location at or near street (optional)
Alpha
TATNRSUFIX
Offense location at or near street suffix (optional)
Alpha

Note:

The UD-8 allows for up to three offenses written for the same defendant on a single ticket. The following field names containing a suffix of 1, 2, or 3 refer to the offense number. When only one offense is written, fields for suffixes 2 and 3 will be blank. When two offenses are written for the same defendant, fields with a suffix of 3 will be blank.

TCTCASTYP1
Court case type assigned to the first offense (optional as long as the field, TSOSCD1, TPACCODE1, or TMCLCODE1 is supplied
Alpha
TSOSCD1
Michigan Secretary of State offense code for conviction and suspension processing (this field is optional when either fields TPACCODE1 or TMCLCODE1 contain a value)
Alpha
TCTCASTYP2
Court case type assigned to the second offense (optional as long as the field, TSOSCD2 TPACCODE2 or TMCLCODE2is supplied
Alpha
TSOSCD2
Michigan Secretary of State offense code for conviction and suspension processing (this field is optional when either fields TPACCODE2 or TMCLCODE2 contain a value)
Alpha
TCTCASTYP3
Court case type assigned to the third offense (optional as long as the field, TSOSCD3, TPACCODE3, or TMCLCODE3 is supplied
Alpha
TSOSCD1
Michigan Secretary of State offense code for conviction and suspension processing (this field is optional when either fields TPACCODE3 or TMCLCODE3 contain a value)
Alpha
TCIVINFR1
Civil infraction flag – When the offense is a civil infraction, move “1” to this field
Alpha
TCIVINFR2
Civil infraction flag – When the offense is a civil infraction, move “1” to this field
Alpha
TCIVINFR3
Civil infraction flag – When the offense is a civil infraction, move “1” to this field
Alpha
TMISDEM1
Misdemeanor flag – When the offense is a misdemeanor, move “1” to this field
Alpha
TMISDEM2
Misdemeanor flag – When the offense is a misdemeanor, move “1” to this field
Alpha
TMISDEM3
Misdemeanor flag – When the offense is a misdemeanor, move “1” to this field
Alpha
TFELONY1
Felony flag – When the offense is a felony, move “1” to this field (not valid for parking tickets)
Alpha
TFELONY2
Felony flag – When the offense is a felony, move “1” to this field (not valid for parking tickets)
Alpha
TFELONY3
Felony flag – When the offense is a felony, move “1” to this field (not valid for parking tickets)
Alpha
TWARNING1
Optional, not used for parking tickets
Alpha
TWARNING2
Optional, not used for parking tickets
Alpha
TWARNING3
Optional, not used for parking tickets
Alpha
TFUGITIV1
Optional, not used for parking tickets
Alpha
TFUGITIV2
Optional, not used for parking tickets
Alpha
TFUGITIV3
Optional, not used for parking tickets
Alpha
TAUTHPND1
Optional, not used for parking tickets
Alpha
TAUTHPND2
Optional, not used for parking tickets
Alpha
TAUTHPND3
Optional, not used for parking tickets
Alpha
TMCLCODE1
Michigan Compiled Law Code (this should be the court’s offense code. If not supplied, fields TSOSCD1, TPACCODE1, or TDESC1 must contain a value)
Alpha
TMCLCODE2
Michigan Compiled Law Code (this should be the court’s offense code. If not supplied, fields TSOSCD2, TPACCODE2, or TDESC2 must contain a value)
Alpha
TMCLCODE3
Michigan Compiled Law Code (this should be the court’s offense code. If not supplied, fields TSOSCD3, TPACCODE3, or TDESC3 must contain a value)
Alpha
TPACCODE1
PACC Code for offense. Not used for parking tickets.
Alpha
TPACCODE2
PACC Code for offense. Not used for parking tickets.
Alpha
TPACCODE3
PACC Code for offense. Not used for parking tickets.
Alpha
TDESC1
Description of offense. Only necessary when there isn’t a TSOSCD1, TMCLCODE1 or TPACCCODE1 code supplied.
Alpha
TDESC2
Description of offense. Only necessary when there isn’t a TSOSCD2, TMCLCODE2 or TPACCCODE2 code supplied.
Alpha
TDESC3
Description of offense. Only necessary when there isn’t a TSOSCD3, TMCLCODE3 or TPACCCODE3 code supplied.
Alpha
TSPEED1
Speed charged (only required for speeding offenses)
Numeric
TSPEED2
Speed charged (only required for speeding offenses)
Numeric
TSPEED3
Speed charged (only required for speeding offenses)
Numeric
TSPEEDLMT1
Posted speed limit (only required for speeding offenses)
Numeric
TSPEEDLMT2
Posted speed limit (only required for speeding offenses)
Numeric
TSPEEDLMT3
Posted speed limit (only required for speeding offenses)
Numeric
TSPEEDFRM1
Former posted speed limit (only required for speeding offenses in a zone where a speed limit has changed)
Numeric
TSPEEDFRM2
Former posted speed limit (only required for speeding offenses in a zone where a speed limit has changed)
Numeric
TSPEEDFRM2
Former posted speed limit (only required for speeding offenses in a zone where a speed limit has changed)
Numeric
TREMARKS
Remarks: Any note or comment.

The current UD-8 record does not have fields for VIN, meter number, CDL, TCN, or Venue. This information can be captured anywhere in the 200 character remarks area using the following prefixes and format:

VIN= immediately followed by 17 characters of data.

MTR= immediately followed by 10 characters of data, which is placed in the “PIN” field on the Case Entry screen.

CDL= immediately followed by 1 character of data;

“Y” (driver has a CDL license)

“N” (driver does not have a CDL license)

“U” (it is unknown if driver has a CDL license)

TCN= immediately followed by an 11 digit number.

VNU= immediately followed by a 2 digit number, which is placed in the

“Venue” field on the Case Entry screen.

The UD-8 record does have make, color and location fields, but a way to capture all 3 in the TREMARKS field can be accomplished as follows:

MK= immediately followed by 27 characters of data, which is placed in the “Victim/Desc” field on the Case Entry screen.

“MK=FORD/CLR=RED/AT:WILLIAMS ST”

Alpha

TTRAFCRSH
Traffic crash – use a value of “1” if the offense involved a crash
Alpha
TDMGROUP
Property damage – use a value of “1” if the offense involved property damage
Alpha
TINJURY
Injury – use a value of “1” if the offense involved a personal injury
Alpha
TDEATH
Death – use a value of “1” if the offense involved a death.
Alpha
TAPPRMTH
Appearance month – 2 digits
Numeric
TAPPRDAY
Appearance day – 2 digits
Numeric
TAPPRYEAR
Appearance year – 4 digits ccyy
Numeric
TAPPRTIME
Appearance time - 4 digits military time as hhmm
Numeric
THEARMTH
Hearing month – 2 digits
Numeric
THEARDAY
Hearing day – 2 digits
Numeric
THEARYEAR
Hearing year – 4 digits ccyy
Numeric
THEARTIME
Hearing time - 4 digits military time as hhmm
Numeric
TCOURTORI
Court ORI number – required
Alpha
TOFCIDNO1
Badge number of primary officer involved – needs to be a valid officer badge number used by the court
Alpha
TAGNCYORI
Police agency or parking division ORI number
Alpha
TAGNCYNAM
Police agency or parking division name
Alpha
TVOIDED
Use a value of “1” if the ticket was voided
Alpha
TVOIDEDBY
Badge number of the person who voided the ticket
Alpha

Note: All Y/N flags are to be stored a Y=”1’ and N=”0”

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