D20 Traffic Records Systems Data Dictionary

Transcription

D20Traffic Records SystemsData Dictionary7.0 0System Release Document ReleaseAAMVA - Official Use OnlyD20 Data Dictionary 7.0The D20 Data Dictionary presents model data definitionsfor use by Motor Vehicle Agencies and their partners.AAMVA collects these data definitions and publishes thisinformation in this document.

The American Association of Motor Vehicle Administrators (AAMVA) is a non-profit organization, representing thestate, provincial, and territorial officials in the United States and Canada who administer andenforce motor vehicle laws.Address :AAMVA4401 Wilson BoulevardSuite 700Arlington, VA 22203Telephone :1-703-522-4200Fax :1-703-522-1553Email :AAMVA Help Desk helpdesk@aamva.orgWebsite :http://www.aamva.orgThis release of this document was prepared on Friday, November 20, 2020.The American Association of Motor Vehicle Administrators (AAMVA) produced this document. No part of thisdocument may be reproduced or transmitted in any form or by any means, electronic or mechanical, includingphotocopying, recording, or information storage or retrieval systems, for any purpose other than the intended use byAAMVA, without the express written permission of AAMVA. 2020 AAMVA. All rights reserved.

D20 Data Dictionary 7.0AAMVA - Official Use OnlyTable of Contents1Document Introduction. 11.12Document Purpose . 1D20 Standard . 22.1D20 Overview . 22.2D20 History . 22.3D20 References . 42.4References to D20 . 52.5D20 Maintenance Procedures . 52.6Personally identifiable information (PII). 5Appendix A:A.1Data Dictionary . 8Data Dictionary Introduction . 8A.1.1 Organization of D20 Data Elements . 9A.2Referenced Material . 10A.2.1 AAMVA Person Name Rule . 10A.2.2 AAMVA Person Name Rule 2008 . 13A.2.3 Address Format . 15A.2.4 ACD . 15A.2.5 Brand Code Values . 16A.2.6 Character Encoding . 20A.2.7 Date Format . 22A.2.8 Driver Addresses . 22A.2.9 Driver License Statuses. 23A.3A.2.10Commercial Motor Vehicle . 23A.2.11Commercial Class Definition . 25A.2.12Driver Control Record . 26A.2.13Hazardous Material Class . 27A.2.14Inspection Code . 29A.2.15Jurisdiction Code Values . 29A.2.16Jurisdiction Mail Abbreviation Values . 31A.2.17NCIC Vehicle Color Code Values . 32A.2.18Vehicle Weight . 33Automobile Dealer. 34A.3.1 Dealer Code. 34Table of Contentsiii

D20 Data Dictionary 7.0AAMVA - Official Use OnlyA.3.2 Dealer EIN / FID . 35A.3.3 Dealer Mailing Address . 35A.3.4 Dealer Name . 35A.3.5 Dealer Number. 35A.4Business . 35A.4.1 Employer Identification Number . 35A.4.2 Business Partner ID . 36A.5Citation. 36A.5.1 Citation CDL Holder Indicator. 36A.5.2 Citation Date . 37A.5.3 Citation Court Address State . 37A.5.4 Citation Number . 37A.5.5 Citation Trial Date . 37A.5.6 Parking Citation Bail Amount . 37A.5.7 Parking Citation Court Code . 38A.5.8 Parking Citation Number . 38A.5.9 Parking Citation Violation Date . 38A.6Conviction . 38A.6.1 Conviction Commercial Vehicle Indicator . 38A.6.2 Conviction Court City / Place. 39A.6.3 Conviction Court Type . 39A.6.4 Conviction Date . 40A.6.5 Conviction Fine. 40A.6.6 Conviction HAZMAT Indicator . 40A.6.7 Conviction Jail Sentence Length . 40A.6.8 Conviction Judge Identification Number . 41A.6.9 Conviction Jurisdiction Court Report ID . 41A.7A.6.10Conviction Jurisdiction Offense Code . 41A.6.11Conviction Offense ACD Code . 41A.6.12Conviction Points, Violation Demerit . 41A.6.13Conviction Suspended Sentence . 42A.6.14Court Suspension Termination Date . 42A.6.15Conviction Trial Date . 42A.6.16Jurisdiction Code - Convicting . 42Crash . 43Table of Contentsiv

D20 Data Dictionary 7.0AAMVA - Official Use OnlyA.7.1 Crash Involving Commercial Vehicle. 43A.7.2 Crash Citation. 44A.7.3 Crash County . 44A.7.4 Driver Crash Commercial Vehicle Indicator . 44A.7.5 Driver Crash HAZMAT Indicator. 44A.7.6 Crash Date . 45A.7.7 Crash Jurisdiction Code . 45A.7.8 Crash Locator Reference. 45A.7.9 Crash Severity Code. 46A.7.10A.8Crash Care By Non Response Unit . 46Credit Card . 46A.8.1 Credit Card Authorization Code. 46A.8.2 Credit Card Number And Expire Date . 47A.8.3 Credit Card Reference . 47A.8.4 Credit Card Type. 47A.9Driver. 47A.9.1 Driver Date Of Birth . 48A.9.2 Driver Eye Color. 48A.9.3 Driver Hair Color. 49A.9.4 Driver Height . 49A.9.5 Driver Mailing Address . 49A.9.6 Driver Medical History Indicator. 50A.9.7 Driver Name . 50A.9.8 Driver Race And Ethnicity . 50A.9.9 Driver Residence Address . 51A.9.10Driver Sex . 51A.9.11Driver Social Security Number . 52A.9.12Driver Weight. 52A.9.13Passport Number . 52A.9.14U.S. Passport Number Format . 53A.9.15Person Digital Image . 53A.9.16Person Last Complete Examination Date. 54A.9.17Person Military Indicator . 54A.9.18Person Nationality Code . 54A.9.19Person Name Group . 54Table of Contentsv

D20 Data Dictionary 7.0AAMVA - Official Use OnlyA.9.20Person Points, Active Demerit. 55A.9.21Person Organ Donor Indicator . 55A.9.22Person Veteran Indicator. 55A.9.23USCIS Alien Registration Number . 55A.10 Driver Education and Improvement . 55A.10.1Driver Education Completion Date . 56A.10.2Driver Education Curriculum Type . 56A.10.3Driver Education Facility City/Place. 56A.10.4Driver Education Facility Type . 56A.10.5Driver Improvement Analyst’s Recommendation . 57A.10.6Driver Improvement Clinic Assignment Date . 57A.10.7Driver Improvement Clinic City/Place. 57A.11 Driver License . 58A.11.1CDL Medical Self Certification Code . 58A.11.2Driver License Advisory Letter Date. 58A.11.3Driver License Advisory Letter Type Code . 58A.11.4Driver License Application Date . 59A.11.5Driver License Card ID . 59A.11.6Driver License Card Design Revision Date. 59A.11.7Driver License Commercial Class Code. 60A.11.8Driver License Endorsement Code . 60A.11.9Driver License Expiration Date. 61A.11.10Driver License Hazmat Endorsement Expiration Date . 61A.11.11Driver License Issuing Country Code . 61A.11.12Driver License Issuance Type Code . 62A.11.13Driver License Limited Term Indictor. 62A.11.14Driver License Number . 62A.11.15Driver License Original Issue Date. 63A.11.16Driver License Privilege Type W/D Action Pending . 63A.11.17State Document REAL-ID Conformant . 63A.11.18Driver License Commercial Status . 63A.11.19Driver License Non-Commercial Status. 65A.11.20Driver License Issue Date . 66A.11.21Driver License Privilege Type Status . 66A.11.22Driver License Probation Start Date . 68Table of Contentsvi

D20 Data Dictionary 7.0AAMVA - Official Use OnlyA.11.23Driver License Probation Termination Date . 68A.11.24Driver License REAL-ID Compliance Code. 68A.11.25Driver SPE Effective Date . 68A.11.26Driver SPE Expiration Date . 68A.11.27Driver License Suspension Termination Date. 69A.11.28Driver Waiver/Exempt Effective Date . 69A.11.29Driver Waiver/Exempt Expiration Date. 69A.11.30State Document Type . 69A.12 Driver License Review . 70A.12.1Departmental Hearing City/Place . 70A.12.2Departmental Hearing Date . 70A.12.3Departmental Hearing Status . 70A.12.4Group Interview City/Place. 70A.12.5Group Interview Date . 71A.12.6Group Interview Status . 71A.12.7Personal Interview City/Place . 71A.12.8Personal Interview Date . 71A.12.9Personal Interview Status . 71A.13 Driver Permit. 72A.13.1Driver License Permit Endorsement Code . 72A.13.2Driver License Permit Expiration Date. 72A.13.3Driver License Permit Issue Date . 73A.13.4Driver License Permit Restriction Code . 73A.13.5Driver License Permit Restriction End Date . 73A.13.6Driver Permit Commercial Class Code . 73A.13.7Driver License Permit Restriction Explanation. 74A.13.8Driver License Permit Status . 74A.14 Driver Restriction. 75A.14.1Driver License Restriction Code. 76A.14.2Driver License Restriction End Date . 76A.14.3Driver License Restriction Explanation. 76A.15 Driver License Withdrawal . 77A.15.1Driver License ACD Withdrawal Reason Code . 77A.15.2Driver License Withdrawal Basis . 77A.15.3Driver License Withdrawal Due Process Status. 78Table of Contentsvii

D20 Data Dictionary 7.0AAMVA - Official Use OnlyA.15.4Driver License Withdrawal Effective Date . 78A.15.5Driver License Withdrawal Eligibility Date . 78A.15.6Driver License Withdrawal Extent ID . 79A.15.7Driver License Withdrawal Jurisdiction Report ID . 79A.15.8Driver License Withdrawal Period . 79A.15.9Driver License Withdrawal Reason Reference. 80A.15.10Driver License Withdrawal Reinstatement Date . 80A.15.11Driver License Withdrawal Type . 80A.15.12Jurisdiction Code - Withdrawing . 81A.16 Driving Test . 82A.16.1Testing Jurisdiction Code . 82A.16.2Schedule ID . 82A.16.3Scheduled Test Site ID . 82A.16.4Scheduled Test Route Number . 82A.16.5Schedule CDL Class. 83A.16.6Schedule Trailer Length Code . 83A.16.7Schedule Brake Type Code . 83A.16.8Schedule Vehicle With Air Brakes . 84A.16.9Schedule Vehicle With Automatic Transmission. 84A.16.10Schedule Cancel Reason Code . 84A.16.11Test Date . 84A.16.12Test Start Time . 84A.16.13Test End Time . 85A.16.14Test Skills Segment Code. 85A.16.15Test CCD Number . 85A.16.16Test CCD Issue Date . 85A.16.17Test Vehicle Type . 85A.16.18Test Site ID . 86A.16.19Test Fail Reason Code . 86A.16.20Test Inspection Form Code . 86A.16.21Test Form Number . 87A.16.22Test Vehicle Provider . 87A.16.23Test Vehicle Plate Number . 87A.16.24Test Commercial Vehicle Make . 88

Data Dictionary 7.0 0 System Release Document Release AAMVA - Official Use Only D20 Data Dictionary 7.0 The D20 Data Dictionary presents model data definitions for use by Motor Vehicle Agencies and their partners. AAMVA collects these data definitions and publishes this information in this document.