Example_CRIMS20Extract_DHS20File_Layout2020Glossaries.pdf

01 DSH FILE LAYOUT DSH-RECORD O3 DSH-KEY 05 DSH-CTY 05 05 DSH-REC-TYP O5 KOKOQKO 2) 9) 2) Values: 00 through 12 3) Remainder of Case History record depends on record type to follow. County code of origin CRIMS Internal ID 2 Record Type Identifier: Type Header record Type 1 Case/Defendant data record containing case-related data (1 record per case) Type 2 Arresting officer data (1 record per case) Type 3 Defense attorney/ADA data (Multiple records per case) Type 4 Docket data (Multiple records per case) Type 5 Appearance/Disposition-related information, using docket?specific data (Multiple records per docket) Type 6 Charges associated with a specific case (Multiple records per docket) Type 7 Charge disposition data (Multiple records per docket) Type 8 Charge sentence,data (Multiple records per docket) Type 9 Charge resentence data (Multiple records per docket) Type 10 Motion?related data (Multiple records per docket) Type 11 Family relationship data (Data not currently being captured) Type 12 Vehicle data Docket/Case number sequence identifier Record Types 1, 2 and 3 will have 00, while types 4 through 10 will have a corresponding value to link together data elements associated with the same docket or case number HEADER RECORD HEADER INDICATOR x(1) 9(2) 9(2) Value 00 9(8) HEADER Blank County Blank Record Type Blank Data entry date for which file was generated -3- RECORD TYPE 1 9(2) County 9(9) Internal ID 9(2) Value 01 Record Type DSH-DSEQ 9(3) Value 000 Docket sequence Field Name Attributes Statewide Description Data Dictionary Reference Number N1 Defendant last name N1 Defendant first name N1 Defendant middle initial DSH-DEF-DOB 9(8) Dl Defendant date Of birth 88 Defendant sex R1 Defendant race E17 Defendant ethnicity E27 Defendant color H1 Defendant hair color 9(3) W7 Defendant weight 9(3) H2 Defendant height A23 Alias #1 last name A23 Alias #1 first name A23 Alias #1 middle initial A23 Alias #2 last name A23 Alias #2 first name A23 Alias #2 middle initial A2 Defendant address? In care of A8 Street A1 Apartment A3 City A7 State 9(5) Zip code (lst 5 digits) 9(4) A10 Zip code (last 4 digits) N12 Defendant NYSID O1 Defendant Court Control A36 Defendant Arrest 9(8) A35 Arrest date 9(4) A38 Arrest time DSH-CAS-CRIME-DT 9(8) Crime date 120 Interpreter Language -4- RECORD TYPE 1 (cont'd) Field Name Attributes Statewide Description Data Dictionarv Reference Number X(l) Defendant Name Type 9(5) Blood Alcohol Level -5- RECORD TYPE 2 DSH-RECORD DSH-KEY 9(2) County 9(9) Internal ID 9(2) Value 02 Record Type 9(3) Value 000 Docket sequence Field Name Attributes Statewide Description Data Dictionary Reference Number DSH-ARRESTING OFFICER A44 Arresting officer last name X(ll) A44 Arresting officer first name X(l) A44 Arresting officer middle initial 9(5) APO shield number A43 Arresting agency DSH-APO-CMD C14 APO command DSH-RECORD DSH-CTY DSH-DSEQ Field Name RECORD TYPE 3 KOKOKOKO WNKON Attributes DSH-ATY-CRT-TYP DSH-ATTORNEY-NAME DSH-ATTORNEY-ADDRESS DSH-ATN-CITY DSH-ATN-ZIPX DSH-ATN-PHN-AC DSH-ATN-PHN-XCH DSH-ATN-PHN-NUM Value 03 Value 000 County Internal ID Record Type Docket sequence Description Data Dictionarv Reference Number C30 C31 D11 A50 A50 A50 A49 C31 A46 A46 A46 Date attorney assigned/ retained Court part attorney assigned/retained Court type attorney assigned/retained Attorney type Attorney last name Attorney first name Attorney middle initial Attorney firm name Street City State Zip code (lst 5 digits) Zip code (last 4 digits) Area code Exchange Number Legal Aid Complex Date ADA assigned Court type ADA assigned ADA last name ADA first name ADA middle initial RECORD TYPE 4 9(2) DSH-ID 9(9) 9(2) 9(3) Field Name Attributes 9(3) 9(8) X(l) x(2) X(ll) x(1) Value 04 Etatewide County Internal ID Record type Docket sequence Description Data Dictionary Reference Number C31 P24 S3 S4 N1 N1 N1 Court type of case Docket/superior court Top charge sequence Date ordered sealed Sealed status of case Type of sealing Docket/superior court of codefendant Codefendant last name Codefendant first name Codefendant middle init Summons Number (for NYC Universal Summons Cases) or Ticket Number (for non~NYC Cases) RECORD TYPE 5 9(2) County 9(9) Internal ID 9(2) Value 05 Record type 9(3) Docket sequence Field Name Attributes Statewide Description Data Dictionary Reference Number 9(8) P24 Court appearance date C30 Court appearance part J1 Last name of judge J1 First name of judge J1 Middle initial of judge Name of court reporter Name of court reporter 2 Calendar section of this appearance D9 Release status 9(9) A26 Bond bail amount set 9(9) A27 Cash bail amount set F21 Bail made indicator Plea vacated/plea withdrawn indicator 9(2) Arraignment type C34 Hearing type 9(3) R3 Reason for adjournment 9(2) 85 Reason for delay in sentencing Court to which case was transferred 9(1) Restored to calendar - after ACD 9(2) Jurisdiction from which case was returned 9(8) N5 Next scheduled court date C30 Next scheduled court part Calendar section of next scheduled appearance W3 Type of warrant issued -9- RECORD TYPE 5 (Cont'd) Field Name Attributes Statewide Description Data Dictionary Reference Number 9(4) D18 Outcome of court appearance Bail exonerated indicator Temporary order of protection indicator A47 Consolidated/superseding case number Do not seal order issued by court S7 Sentence type(s) imposed 13 Length of imprisonment time 9(9) R8 Restitution amount L9 License suspension time P22 Probation time 9(9) F15 Fine amount F16 Fine payment status 9(5) C15 Community service hours Order of protection time C16 Concurrent/consecutive sentence indicator C19 Concurrent/consecutive docket or case C23 Conditions related to severity of sentence 9(4) 827 Amount of surcharge 829 Surcharge imprisonment time alternative 828 Surcharge payment status 9(8) P24 Advanced From Date B1 Surety last name X(1l) B1 Surety first name B1 Surety middle initial C30 Court part to which case is returnable after warrant is executed -lO- RECORD TYPE 6 9(2) County 9(9) Internal ID 9(2) Value 06 Record type 9(3) Docket sequence Field Name Attributes Statewide Description Data Dictionary Reference Number DSH-CHARGE-INFO 9(3) C11 Charge sequence DSH-CHG-LAW A28 Law code A28 Article and section A28 Sub?section A28 Class A28 Category 9(1) A28 Degree A28 Attempt Indicator 9(3) Charge count 9(1) Arrest charge indicator 9(1) Lower court arraignment indicator 9(1) Superior court arraignment indicator 9(8) . P24 Court date on which charge was added Charge description 9(4) N3 NCIC Code Weapon/drug type DSH-CTY Field Name -11- RECORD TYPE 7 KOKDKOKO WNKON Attributes DSH-CHG-CNT Value 07 Statewide County Internal ID Record type Docket sequence DescriQtion Data Dictionary Reference Number C11 C10 C17 C18 T8 Charge sequence Charge count Charge disposition code Concurrent/consecutive indicator Concurrent/consecutive charge sequence Jurisdiction to which charge was transferred DSH-RECORD DSH-KEY DSH-REC-TYP Field Name DSH-CHS-PROB-TM DSH-CHS-CS-TM DSH-CHS-STY _12_ RECORD TYPE 8 Attributes Value 08 Statewide County Internal ID Record type Docket sequence Description Data Dictionary Reference Number C11 Charge sequence Charge count Sentence type(s) imposed Length of imprisonment time License suspension time Probation time Fine amount Community service hours Order of protection time Sentence stayed indicator DSH-RECORD DSH-CTY DSH-REC-TYP _l3_ RECORD TYPE 9 Field Name Attributes DSH-CHG-SEQ DSH-CHG-CNT DSH-CRS-CS-TM DSH-CRS-STY Value 09 Statewide County Internal ID Record type Docket sequence Description Data Dictionary Reference Number C11 Charge sequence Charge count Sentence type(s) imposed Length of imprisonment time License suspension time Probation time Fine amount Community service hours Order of protection time Sentence stayed indicator DSH-CTY DSH-DSEQ Field Name DSH-MOT-APP-DT DSH-MOT-SEQ DSH-MOT-HABEAS-CORPUS DSH-MOT-ACTIVITY WNKON -14- RECORD TYPE 10 Attributes Value 10 Statewide County Internal ID Record Docket type sequence Description Data Dictionary Reference Number P24 C30 M14 M16 M10 M11 M15 M13 Motion Motion Motion Motion Motion appearance date appearance part sequence type filed date Party who filed motion Habeas Motion Motion Corpus indicator activity disposition DSH-ID DSH-REC-TYP Field Name DSH-FAM DSH-FAM-COM-DEF RECORD TYPE 11 Attributes County Internal ID Value 11 Record Type Value 0 Docket sequence Statewide Description Data Dictionary Reference Number V8 Victim to defendant relationship Complainant to defendant relationship V8 Defendant to victim relationship -l6- RECORD TYPE 12 9(2) County 9(9) Internal ID 9(2) Value 12 Record Type DSH-DSEQ 9(3) Value 0 Docket sequence Field Name Attributes Statewide Description Data Dictionary Reference Number Type of vehicle L8 Year of registration expiration Vehicle owner name Motorist ID Vehicle ID V2 Make of vehicle 9(4) Year of vehicle L5 Vehicle plate L6 License plate state 9(1) Operator is owner of vehicle 9(8) Date license issued License status Registration status Registration suspension time AGENCY NAME Amherst Town Police Amtrak Railroad Police Amityville Village Police Ardsley Village Police Asharoken Village Police Beacon Police Bedford Town Police Belmont Village Police Blasdell Village Police Blooming Grove Town Police Boston Town Police Briarcliff Manor Police Bronx District Attorney Bronxville Village Police Brownville Village Police Buchanan Village Police Buffalo Police Buffalo State University Police Carmel Town Police Centre Island Village Police Cheektowaga Town Police Chester Town Police Chester Village Police Clarkstown Town Police Cold Spring Village Police Conrail Police Cornwall Town Police Cornwall Village Police Cortlandt Town Police Cove Neck Village Police Crawford Town Police Croton-on-Hudson Police Deerpark Town Police Dobbs Ferry Village Police Dutchess County Sheriff Eastchester Town Police East Fishkill Town Police East Hampton Town Police Elmsford Village Police Erie County Sheriff Fishkill Town Police NY0145100 NYAMXO 1 SO NY0512000 NY0592400 NYOS 14400 NY0130100 NY0595000 NY0022100 NY0142900 NY0357300 NYO 145300 NY0593100 NY062013A NY0592200 NY0222300 NY0594100 NY0140100 NY0146800 NY0395000 NY0294700 NY0145500 NY0357700 NY0352100 NY0435000 NYO3 92000 NY001679E NY0355200 NY0352200 NY0597400 NY0296200 NY0357600 NY0592100 NY0357100 NY0592500 NY0130000 NY0595200 NY0136600 NY0515200 NYOS 93900 NY0140000 AGENCY NAME Fishkill Village Police Floral Park Village Police Florida Village Police Freeport Village Police Garden City Village Police Glen Cove Police Goshen Town Police Goshen Village Police Great Neck Estates Village Police Greenburgh Town Police Greenport Village Police Greenwood Lake Village Police Harriman Village Police Harrison Town Police Hastings-on-Hudson Police Haverstraw Town Police Haverstraw Village Police Head of Harbor Police Hempstead Village Police Highland Falls Village Police Highlands Town Police Hyde Park Town Police Irvington Village Police Islip Town Attorney Kensington Village Police Kent Town Police Kings District Attorney Kings Point Village Police Lake Success Village Police Larchmont Village Police Laurel Hollow Village Police Lewisboro Town Police Lloyd Harbor Village Police Long Beach Police Long Island Railroad Police Village Police Malverne Village Police Mamaroneck Town Police Mamaroneck Village Police Maybrook Village Police Metro North Police NY0132000 NY0290300 NY0353400 NY0290400 NY0290500 NY0290100 NY0358100 NY0352300 NY0293300 NY0595300 NY0512700 NY0353300 NY0353700 NY0595400 NY0592600 NY0435100 NY0432100 NY0514600 NY0290600 NY0352400 NY0355800 NY0136500 NY0592700 NY05101 1A NY0294100 NY0395100 NY023013A NY0294400 NY0296300 NY0592900 NY0294900 NY0595500 NY0513700 NY0290200 NY0400100 NY0290700 NY0293900 NY0595600 NY0590900 NY0353200 NY03 08300 AGENCY NAME Middletown Police Mill Neck Village Police Millbrook Village Police Millerton Village Police Monroe Village Police Montgomery Town Police Montgomery Village Police Mount HOpe Town Police Mount Kisco Village Police Mount Pleasant Town Police Mount Vernon Police Nassau County Highway Patrol Bureau Nassau County Police Nassau County Probation Department Nassau County Sheriff Newburgh Police Newburgh Town Police New Castle Town Police New Rochelle Police New Windsor Town Police NYC Housing Authority NYC Police NYC Sheriff NYC Transit Police NYC Water Supply Police New York District Attorney New York Harbor Waterfront Commission NYS Attorney General NYS Park Police - Long Island NYS Park Police - Bear Mountain NYS Police - Albany NYS Police - Batavia NYS Police Bethpage NYS Police - Brewster NYS Police - Dover Plains NYS Police - Fishkill NYS Police - Hawthorne NYS Police - Lake Success NYS Police - Lewisboro NYS Police - Liberty NYS Police Middletown NY0350100 NY0293100 NY0132800 NY0132100 NY03 52600 NY0357400 NY0352700 NY0355000 NY0592000 NY0595 700 NY05 90300 NY0290008 NY0290000 NY029013G NY0299000 NY03 50200 NYO356300 NY0595800 NY0590400 NY03 56700 NY03 07200 NY0303000 NY0300000 NY0232300 NY0591200 NY03 0013A NY0303200 NY030035A NY0519000 NY0439000 NY10100L1 NY1180100 NY1290200 NY1390200 NY1130300 NY1130100 NY1590100 NY1290100 NY1590800 NY1520100 NY1350100 AGENCY NAME CODE NYS Police Monroe NY1350200 NYS Police - Montrose NY1590900 NYS Police - Newburgh NY1350300 NYS Police - Palisades NY1430100 NYS Police - Peekskill NY1590200 NYS Police - Pound Ridge NY1590700 NYS Police - Rhinebeck NY1130200 NYS Police - Somers NY1590300 NYS Police - Storrnville NY1130500 NYS Police through Buffalo NY1140400 NYS Police through East Fishkill NY1130800 NYS Police through New Rochelle NY 1 590500 NYS Police through Tarrytown NY1590400 NYS Police Troop Headquarters (Poughkeepsie) NY1130400 NYS Police Troop Headquarters (East armingdale) NY1510300 NYS Police - Valley Stream NY1290300 NYS Police - VFW Squad (Pleasantville) NY1590600 NYS Police Wurtsboro NY1520200 Niagara Frontier Transit Authority NYO 143700 North Castle Town Police NY0595900 North Salem Town Police NY0597100 Northport Village Police NYOS 12500 Ocean Beach Village Police NY0513300 Old Brookville Police NY0297200 Old Westbury Village Police NY0294300 Orange County Sheriff NY0350000 Orangetown Town Police NY0435200 Ossining ToWn Police 7 NY0597300 Ossining Village Police NY0590500 Oyster Bay Cove Police NY0298800 Pawling Village Police NY0132200 Peekskill Police NY0590100 Pelham Manor Village Police NY0593700 Pelham Village Police NY0593500 Piermont Village Police NY0432500 Pine Plains Town Police NY0135000 Pleasant Valley Police NY0135100 Pleasantville Village Police NY0593300 Port Authority Police NY0307000 Port Chester Village Police NY0590600 Port Jervis Police NY0353 500 AGENCY NAME Port Washington Police Poughkeepsie Police Poughkeepsie Town Police Pound Ridge Town Police Putnam County Sheriff Putnam Valley Town Police Queens District Attorney Ramapo Town Police Red Hook Village Police Rhinebeck Village Police Richmond District Attorney Riverhead Police Rockland County Sheriff Rockville Centre Village Police Rye Brook Village Police Rye Police Sands Point Village Police Scarsdale Village Police Shelter Island Town Police Somers Town Police Southampton Town Police Southampton Village Police Southold Town Police South Nyack/Grandview Village Police Spring Valley Village Police Stony Point Town Police Suffern Village Police Suffolk County Police Suffolk County Probation Department Suffolk County Sheriff Suffolk District Attorney SUNY Buffalo SUNY Farmingdale SUNY Stony Brook Tarrytown Village Police Triborough Bridge and Tunnel Authority Tuckahoe Village Police Tuxedo Park Village Police Tuxedo Town Police US Park Police Walden Village Police NY0295 500 NY013 0200 NY013 6300 NY05 96300 NYO3 90000 NYO3 95400 NY040013A NY043 5300 NY0132500 NY0132700 NY042013A NY05 15 500 NY043 0000 NY0290900 NY05 97200 NY05 90800 NY0293 500 NY0591000 NY05 15 600 NY0594200 NY05 15 800 NY05 12600 NY05 15900 NY043 2600 NY0432800 NYO43 5400 NY0432900 NY0510100 NY051013G NY0510000 NY051013A NY0146900 NY0296800 NY0512100 NY0592800 NY0307100 NY0592300 NY0353600 NY0356500 NY0352800 AGENCY NAME Walkill Town Police Wappingers Falls Police Warwick Town Police Warwick Village Police Washingtonville Village Police Westchester County Police Westchester District Attorney Westhampton Beach Village Police White Plains Police Woodbury Town Police Yonkers Police Yorktown Town Police NY0357800 NY0132400 NY0357000 NY0352900 NY0352000 NY0590000 NY059013A NYOS 14000 NY0590200 NYO356900 NY0590700 NY0596800 Code Meaning 01 Cash 02 Secured Bond 03 Unsecured Bond 04 Partial Security 0Values Meaning Not Arraigned at this Appearance Desk Appearance Ticket Concurrent Jurisdiction for Criminal and Family Courts Felony Hearing Hospital Arraignment Defendant is a 13 year old Juvenile Violent Felony Offender (JVFO) Defendant is a 14 year old JVFO Defendant is a 15 year old IVFO Misdemeanor Hearing Not Arraigned, although Arraignment was Scheduled (usually used in conjunction with a bench warrant) Pre?Arraignment Deposition Provided Regular Arraignment Transferred from Summons Part Superior Court Information Criminal Summons Field Appearance Ticket Civilian Complaint Case Assigned Violation of Probation Transfer from another County Domestic Violence Case Domestic Violence Case - Not Arraigned, although Arraignment was Scheduled (usually used in conjunction with a bench warrant) Domestic Violence Indictment ?Demest'i'c Violence superior coumnfomation' Defendant is a 13 year old JVFO - Domestic Violence Case Defendant is a 14 year old JVFO Domestic Violence Case Defendant is a 15 year old JV FO Domestic Violence Case Hospital Arraignment Domestic Violence Case Uniform Traffic Ticket CL a: Attorney Type Codes Meaning Legal Aid Private Court-Appointed Self Representation Public Defender Neighborhood Defender Service Other