First file read. 2930 lines. Path: /Users/doranchak/projects/harmony_trunk_2/sql/sqlserver/navajo_picklist_value__from_test.txt Second file read. 2930 lines. Path: /Users/doranchak/projects/harmony_trunk_2/sql/sqlserver/navajo_picklist_value__from_prod.txt ================================================== Picklist values that were removed from first file: ================================================== -933030 Evidence Tech Evidence Tech 10 java.lang.String 1 0 1 -901605 0 -933030 1 1 2017-02-06 10:10:24.610 2017-02-06 10:10:24.610 2017-02-06 10:10:24.610 -931952 Transfer Transferred To Another Court 0 java.lang.String 1 0 1 -931951 0 -931952 1 1 2015-02-23 09:58:28.030 2015-02-23 09:58:28.030 2015-02-23 09:58:28.030 -931989 No Lab Analysis No Lab Analysis 0 java.lang.String 1 0 1 -931968 0 -931989 1 1 2015-02-23 09:58:28.030 2015-02-23 10:02:54.637 2015-02-23 10:02:54.637 -931990 Department Report Problems Department Report Problems 1 java.lang.String 1 0 1 -931968 0 -931990 1 1 2015-02-23 09:58:28.030 2015-02-23 10:02:54.670 2015-02-23 10:02:54.670 -931991 No Conviction Likely No Conviction Likely 2 java.lang.String 1 0 1 -931968 0 -931991 1 1 2015-02-23 09:58:28.030 2015-02-23 10:02:54.727 2015-02-23 10:02:54.727 -931992 Assisted in Another Prosecution Assisted in Another Prosecution 3 java.lang.String 1 0 1 -931968 0 -931992 1 1 2015-02-23 09:58:28.030 2015-02-23 10:02:54.737 2015-02-23 10:02:54.737 -931997 Split Sentence Split Sentence 3 java.lang.String 1 0 1 -931970 0 -931997 1 1 2015-02-23 09:58:28.030 2015-02-23 10:02:54.373 2015-02-23 10:02:54.373 -931998 Suspended Sentence Suspended Sentence 4 java.lang.String 1 0 1 -931970 0 -931998 1 1 2015-02-23 09:58:28.030 2015-02-23 10:02:54.403 2015-02-23 10:02:54.403 -931999 Community Service Community Service 5 java.lang.String 1 0 1 -931970 0 -931999 1 1 2015-02-23 09:58:28.030 2015-02-23 10:02:54.483 2015-02-23 10:02:54.483 -932000 Fines Fines 6 java.lang.String 1 0 1 -931970 0 -932000 1 1 2015-02-23 09:58:28.030 2015-02-23 10:02:54.517 2015-02-23 10:02:54.517 -931993 Other Other 4 java.lang.String 1 0 1 -931968 0 -931993 1 1 2015-02-23 09:58:28.030 2015-02-23 10:02:54.783 2015-02-23 10:02:54.783 -931994 Prison Prison 0 java.lang.String 1 0 1 -931970 0 -931994 1 1 2015-02-23 09:58:28.030 2015-02-23 10:02:53.457 2015-02-23 10:02:53.457 -931995 Jail Jail 1 java.lang.String 1 0 1 -931970 0 -931995 1 1 2015-02-23 09:58:28.030 2015-02-23 10:02:54.253 2015-02-23 10:02:54.253 -931996 Probation Probation 2 java.lang.String 1 0 1 -931970 0 -931996 1 1 2015-02-23 09:58:28.030 2015-02-23 10:02:54.330 2015-02-23 10:02:54.330 -932008 CU Consume/Use 4 java.lang.String 1 0 1 -931966 0 -932008 1 1 2015-02-23 09:58:28.030 2015-02-23 10:02:54.950 2015-02-23 10:02:54.950 -932007 TI Transport/Import 3 java.lang.String 1 0 1 -931966 0 -932007 1 1 2015-02-23 09:58:28.030 2015-02-23 10:02:54.893 2015-02-23 10:02:54.893 -932006 DS Dist./Selling 2 java.lang.String 1 0 1 -931966 0 -932006 1 1 2015-02-23 09:58:28.030 2015-02-23 10:02:54.857 2015-02-23 10:02:54.857 -932005 CM Cult./Manuf. 1 java.lang.String 1 0 1 -931966 0 -932005 1 1 2015-02-23 09:58:28.030 2015-02-23 10:02:54.820 2015-02-23 10:02:54.820 -932004 BR Buy/Receive 0 java.lang.String 1 0 1 -931966 0 -932004 1 1 2015-02-23 09:58:28.030 2015-02-23 10:02:54.810 2015-02-23 10:02:54.810 -932002 Unknown Unknown 8 java.lang.String 1 0 1 -931970 0 -932002 1 1 2015-02-23 09:58:28.030 2015-02-23 10:02:54.620 2015-02-23 10:02:54.620 -932001 Other Other 7 java.lang.String 1 0 1 -931970 0 -932001 1 1 2015-02-23 09:58:28.030 2015-02-23 10:02:54.577 2015-02-23 10:02:54.577 -932011 UN Unknown 7 java.lang.String 1 0 1 -931966 0 -932011 1 1 2015-02-23 09:58:28.030 2015-02-23 10:02:55.047 2015-02-23 10:02:55.047 -932010 OT Other 6 java.lang.String 1 0 1 -931966 0 -932010 1 1 2015-02-23 09:58:28.030 2015-02-23 10:02:55.030 2015-02-23 10:02:55.030 -932009 PC Possess/Conceal 5 java.lang.String 1 0 1 -931966 0 -932009 1 1 2015-02-23 09:58:28.030 2015-02-23 10:02:55.010 2015-02-23 10:02:55.010 -10001749 Other Hallucinogen Other Hallucinogen 20 java.lang.String 1 0 1 -921482 0 -10001749 22954398 22954398 2015-06-04 11:20:40.217 2015-06-04 11:20:40.217 2015-06-04 11:20:40.217 -10001750 Methamphetamine (Ice) Methamphetamine (Ice) 21 java.lang.String 1 0 1 -921482 0 -10001750 22954398 22954398 2015-06-04 11:20:58.387 2015-06-04 11:20:58.387 2015-06-04 11:20:58.387 -10001751 Perscription Perscription 22 java.lang.String 1 0 1 -921482 0 -10001751 22954398 22954398 2015-06-04 11:46:34.707 2015-06-04 11:46:34.707 2015-06-04 11:46:34.707 -10001752 Other Stimulant Other Stimulant 23 java.lang.String 1 0 1 -921482 0 -10001752 22954398 22954398 2015-06-04 11:46:58.917 2015-06-04 11:46:58.917 2015-06-04 11:46:58.917 -10001746 Marijuana Plants Marijuana Plants 17 java.lang.String 1 0 1 -921482 0 -10001746 22954398 22954398 2015-06-04 11:19:17.183 2015-06-04 11:19:17.183 2015-06-04 11:19:17.183 -10001747 Synthetic Cannabinoids Synthetic Cannabinoids 18 java.lang.String 1 0 1 -921482 0 -10001747 22954398 22954398 2015-06-04 11:19:41.350 2015-06-04 11:19:41.350 2015-06-04 11:19:41.350 -10001748 Other Narcotic Other Narcotic 19 java.lang.String 1 0 1 -921482 0 -10001748 22954398 22954398 2015-06-04 11:20:06.217 2015-06-04 11:20:06.217 2015-06-04 11:20:06.217 -10001757 DUI adfadf 2 java.lang.String 1 0 1 -10001754 0 -10001757 1 1 2016-05-05 09:18:32.843 2016-05-05 09:18:32.843 2016-05-05 09:18:32.843 -10001758 Investigation Supervisor Investigation Supervisor 9 java.lang.String 1 0 1 -901605 0 -10001758 1 1 2016-05-05 10:07:35.070 2016-05-05 10:07:35.070 2016-05-05 10:07:35.070 -10001753 CONCLUDED CONCLUDED 60 java.lang.String 1 0 1 -901745 1 -10001753 1 22954398 2015-06-09 15:54:19.100 2016-09-02 11:42:49.563 2016-09-02 11:42:49.563 -10001755 Assault adekfjdkf 0 java.lang.String 1 0 1 -10001754 0 -10001755 1 1 2016-05-05 09:18:09.643 2016-05-05 09:18:09.643 2016-05-05 09:18:09.643 -10001756 Homicide a;kldjf;dljf 1 java.lang.String 1 0 1 -10001754 0 -10001756 1 1 2016-05-05 09:18:23.613 2016-05-05 09:18:23.613 2016-05-05 09:18:23.613 -10002313 Subpoena Subpoena 52 java.lang.String 1 0 1 -4869 0 -10002313 1 1 2017-02-06 10:31:18.153 2017-02-06 10:31:18.153 2017-02-06 10:31:18.153 -10002311 Investigator Investigator 5 java.lang.String 1 0 1 -903291 0 -10002311 1 1 2017-02-06 10:25:03.367 2017-02-06 10:25:03.367 2017-02-06 10:25:03.367 -10002312 Investigator Investigator 4 java.lang.String 1 0 1 -889349 0 -10002312 1 1 2017-02-06 10:25:03.473 2017-02-06 10:25:03.473 2017-02-06 10:25:03.473 -10002322 Warrant Case still open for warrant status 1 java.lang.String 1 0 1 -933022 0 -10002322 36287437 36287437 2017-03-02 11:47:01.817 2017-03-02 11:47:01.817 2017-03-02 11:47:01.817 -10002321 Case Open Case still open 0 java.lang.String 1 0 1 -933022 0 -10002321 36287437 36287437 2017-03-02 11:46:42.747 2017-03-02 11:46:42.747 2017-03-02 11:46:42.747 -10002324 Homicide Case Homicide case evidence kept forever 3 java.lang.String 1 0 1 -933022 0 -10002324 36287437 36287437 2017-03-02 11:47:54.650 2017-03-02 11:47:54.650 2017-03-02 11:47:54.650 -10002323 Sex Case Sex case evidence kept forever 2 java.lang.String 1 0 1 -933022 0 -10002323 36287437 36287437 2017-03-02 11:47:41.590 2017-03-02 11:47:41.590 2017-03-02 11:47:41.590 -10002299 Assigned Attorney Assigned Attorney 4 java.lang.String 1 0 1 -902404 0 -10002299 1 1 2016-08-22 20:42:25.357 2016-08-22 20:42:25.357 2016-08-22 20:42:25.357 -10002300 Assigned Attorney Assigned Attorney 1 java.lang.String 1 0 1 -112322 0 -10002300 1 1 2016-08-22 20:42:25.463 2016-08-22 20:42:25.463 2016-08-22 20:42:25.463 -10002303 Suicide Suicide 5 java.lang.String 1 0 1 -889914 0 -10002303 1 1 2016-09-02 11:52:23.013 2016-09-02 11:52:23.013 2016-09-02 11:52:23.013 -10002304 Investigator Investigator 5 java.lang.String 1 0 1 -902404 0 -10002304 1 1 2017-02-06 10:25:03.440 2017-02-06 10:25:03.440 2017-02-06 10:25:03.440 -10002301 Parent/Guardian Parent/Guardian 73 java.lang.String 1 0 1 -906853 0 -10002301 1 1 2016-08-22 20:42:30.027 2016-08-22 20:42:30.027 2016-08-22 20:42:30.027 -10002302 CIRCUS Went to Circus 61 java.lang.String 1 0 1 -901745 0 -10002302 1 1 2016-09-02 11:42:47.900 2016-09-02 11:42:47.900 2016-09-02 11:42:47.900 ================================================== Picklist values that were added to second file: ================================================== -10001166 Pseudoephedrine Pseudoephedrine 27 java.lang.String 1 0 1 -921482 2 -10001166 22954398 22954398 2015-06-08 16:46:52.367 2015-06-08 16:47:33.443 2015-06-08 16:47:33.443 -10001165 Psilocybin (mushrooms) Psilocybin (mushrooms) 26 java.lang.String 1 0 1 -921482 4 -10001165 22954398 22954398 2015-06-08 16:44:23.530 2015-06-08 16:47:33.457 2015-06-08 16:47:33.457 -10001168 Salvia Salvia 29 java.lang.String 1 0 1 -921482 2 -10001168 22954398 22954398 2015-06-08 16:47:15.580 2015-06-08 16:47:33.473 2015-06-08 16:47:33.473 -10001167 Steroids Steroids 28 java.lang.String 1 0 1 -921482 2 -10001167 22954398 22954398 2015-06-08 16:47:03.907 2015-06-08 16:47:33.507 2015-06-08 16:47:33.507 -10001162 Other Stimulant Other Stimulant 23 java.lang.String 1 0 1 -921482 4 -10001162 22954398 22954398 2015-06-08 16:43:32.267 2015-06-08 16:47:33.380 2015-06-08 16:47:33.380 -10001161 Perscription Perscription 22 java.lang.String 1 0 1 -921482 4 -10001161 22954398 22954398 2015-06-08 16:43:17.003 2015-06-08 16:47:33.427 2015-06-08 16:47:33.427 -10001164 Unknown Drug Unknown Drug 25 java.lang.String 1 0 1 -921482 4 -10001164 22954398 22954398 2015-06-08 16:44:03.430 2015-06-08 16:47:33.537 2015-06-08 16:47:33.537 -10001163 Other Depressants Other Depressants 24 java.lang.String 1 0 1 -921482 4 -10001163 22954398 22954398 2015-06-08 16:43:46.240 2015-06-08 16:47:33.333 2015-06-08 16:47:33.333 -10001158 Other Narcotic Other Narcotic 19 java.lang.String 1 0 1 -921482 4 -10001158 22954398 22954398 2015-06-08 16:42:02.647 2015-06-08 16:47:33.363 2015-06-08 16:47:33.363 -10001157 Synthetic Cannabinoids Synthetic Cannabinoids 18 java.lang.String 1 0 1 -921482 4 -10001157 22954398 22954398 2015-06-08 16:41:45.360 2015-06-08 16:47:33.520 2015-06-08 16:47:33.520 -10001160 Methamphetamine (Ice) Methamphetamine (Ice) 21 java.lang.String 1 0 1 -921482 4 -10001160 22954398 22954398 2015-06-08 16:42:49.370 2015-06-08 16:47:33.257 2015-06-08 16:47:33.257 -10001159 Other Hallucinogen Other Hallucinogen 20 java.lang.String 1 0 1 -921482 4 -10001159 22954398 22954398 2015-06-08 16:42:28.303 2015-06-08 16:47:33.347 2015-06-08 16:47:33.347 -10001156 Marijuana Plants Marijuana Plants 17 java.lang.String 1 0 1 -921482 4 -10001156 22954398 22954398 2015-06-08 16:40:56.503 2015-06-08 16:47:33.240 2015-06-08 16:47:33.240 -10001155 Victim Rights Enforcement Assessment Victim Rights Enforcement Assessment 21 java.lang.String 1 0 1 -911154 13 -10001155 22954457 22954398 2015-05-27 16:41:51.693 2015-07-10 09:53:28.653 2015-07-10 09:53:28.653 -10001181 RESTITUTION Restitution Documents 26 java.lang.String 1 0 1 -910057 7 -10001181 1 22954457 2015-12-08 15:30:45.893 2016-05-04 14:26:12.340 2016-05-04 14:26:12.340 -10001182 Conviction fee Conviction Fee 26 java.lang.String 1 0 1 -911154 0 -10001182 22954457 22954457 2015-12-18 13:32:36.393 2015-12-18 13:32:36.393 2015-12-18 13:32:36.393 -10001183 Defendant defendant 0 java.lang.String 1 0 1 -918704 0 -10001183 22954457 22954457 2016-01-26 14:27:59.060 2016-01-26 14:27:59.060 2016-01-26 14:27:59.060 -10001177 CMC/COP Case Management Conference/Change of Plea 0 java.lang.String 1 1 1 -919065 0 -10001177 22954457 22954457 2015-12-07 14:48:58.840 2015-12-07 14:48:58.840 2015-12-07 14:48:58.840 -10001178 Case Management Conference & Change of Plea Case Management Conference & Change of Plea 96 java.lang.String 1 0 1 -889993 2 -10001178 22954457 22954457 2015-12-07 14:51:56.250 2015-12-07 14:52:09.187 2015-12-07 14:52:09.187 -10001179 SENTENCE Sentencing documents 24 java.lang.String 1 0 1 -910057 11 -10001179 1 22954457 2015-12-08 15:29:46.453 2016-05-04 14:26:12.360 2016-05-04 14:26:12.360 -10001180 LETTER letter 25 java.lang.String 1 0 1 -910057 9 -10001180 1 22954457 2015-12-08 15:30:06.987 2016-05-04 14:26:12.140 2016-05-04 14:26:12.140 -10001173 GPS Monitoring Fee GPS Monitoring Fee 24 java.lang.String 1 0 1 -911154 6 -10001173 22954457 22954457 2015-06-29 09:56:30.357 2015-07-10 09:53:28.697 2015-07-10 09:53:28.697 -10001174 Drug Fine Drug Fine 25 java.lang.String 1 0 1 -911154 4 -10001174 22954457 22954457 2015-07-10 09:51:45.187 2015-07-10 09:53:28.710 2015-07-10 09:53:28.710 -10001175 Daubert Hearing Daubert Hearing 95 java.lang.String 1 0 1 -889993 4 -10001175 22954457 22954457 2015-10-08 16:24:03.397 2015-12-07 14:52:09.210 2015-12-07 14:52:09.210 -10001176 Failure to Register Failure to Register as a Sex Offender 133 java.lang.String 1 0 1 -5916 0 -10001176 22954398 22954398 2015-10-26 15:18:20.627 2015-10-26 15:18:20.627 2015-10-26 15:18:20.627 -10001169 PPC Promoting Prison Contraband 132 java.lang.String 1 0 1 -5916 0 -10001169 22954398 22954398 2015-06-10 16:55:27.247 2015-06-10 16:55:27.247 2015-06-10 16:55:27.247 -10001170 Indigent Assessment Indigent Assessment 22 java.lang.String 1 0 1 -911154 12 -10001170 22954457 22954457 2015-06-29 09:45:31.810 2015-07-10 09:53:28.663 2015-07-10 09:53:28.663 -10001172 Investigative Assessment Investigative Assessment 23 java.lang.String 1 0 1 -911154 8 -10001172 22954457 22954457 2015-06-29 09:54:40.980 2015-07-10 09:53:28.683 2015-07-10 09:53:28.683 -10001201 Pinal County Court Pinal County Superior Court 47 java.lang.String 0 1 1 -889974 0 -10001201 38254536 38254536 2017-03-22 16:05:16.320 2017-03-22 16:05:16.320 2017-03-22 16:05:16.320 ================================================== Changes to individual picklist values: ================================================== id: -924210 active before: [true] after: [false] id: -924209 active before: [true] after: [false] id: -924212 active before: [true] after: [false] id: -924211 active before: [true] after: [false] id: -924213 active before: [true] after: [false] id: -924405 sequence_number before: [13] after: [12] id: -924406 sequence_number before: [14] after: [13] id: -924407 sequence_number before: [15] after: [14] id: -924408 sequence_number before: [16] after: [15] id: -924401 sequence_number before: [9] after: [8] id: -924402 sequence_number before: [10] after: [9] id: -924403 sequence_number before: [11] after: [10] id: -924404 sequence_number before: [12] after: [11] id: -924413 sequence_number before: [21] after: [20] id: -924414 sequence_number before: [22] after: [21] id: -924415 sequence_number before: [23] after: [22] id: -924409 sequence_number before: [17] after: [16] id: -924410 sequence_number before: [18] after: [17] id: -924411 sequence_number before: [19] after: [18] id: -924412 sequence_number before: [20] after: [19] id: -924398 sequence_number before: [6] after: [5] id: -924397 sequence_number before: [5] after: [4] id: -924400 sequence_number before: [8] after: [7] id: -924399 sequence_number before: [7] after: [6] id: -924394 sequence_number before: [2] after: [1] id: -924396 sequence_number before: [4] after: [3] id: -924395 sequence_number before: [3] after: [2] id: -910060 sequence_number before: [1] after: [0] id: -910059 sequence_number before: [0] after: [27] id: -10000634 string_value before: [Restititon] after: [Restitution] id: -10000600 string_value before: [Hasish] after: [Hashish] description before: [Hasish] after: [Hashish] id: -10000594 string_value before: [Cocaine (powder)] after: [Cocaine] description before: [Cocaine (powder)] after: [Cocaine] id: -923613 string_value before: [AQUITTED] after: [AQUIT] description before: [AQUITTED] after: [AQUIT] id: -10001136 sequence_number before: [24] after: [23]