API tools faq
paste
Advertisement
doranchak

Untitled

doranchak
Nov 30th, 2017
113
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.14 KB | None | 0 0
raw download clone embed print report
  1. First file read. 2930 lines. Path: /Users/doranchak/projects/harmony_trunk_2/sql/sqlserver/navajo_picklist_value__from_test.txt
  2. Second file read. 2930 lines. Path: /Users/doranchak/projects/harmony_trunk_2/sql/sqlserver/navajo_picklist_value__from_prod.txt
  3.  
  4. ==================================================
  5. Picklist values that were removed from first file:
  6. ==================================================
  7.  
  8. -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
  9. -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
  10. -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
  11. -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
  12. -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
  13. -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
  14. -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
  15. -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
  16. -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
  17. -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
  18. -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
  19. -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
  20. -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
  21. -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
  22. -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
  23. -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
  24. -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
  25. -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
  26. -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
  27. -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
  28. -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
  29. -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
  30. -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
  31. -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
  32. -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
  33. -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
  34. -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
  35. -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
  36. -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
  37. -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
  38. -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
  39. -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
  40. -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
  41. -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
  42. -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
  43. -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
  44. -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
  45. -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
  46. -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
  47. -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
  48. -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
  49. -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
  50. -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
  51. -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
  52. -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
  53. -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
  54. -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
  55. -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
  56. -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
  57.  
  58. ==================================================
  59. Picklist values that were added to second file:
  60. ==================================================
  61.  
  62. -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
  63. -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
  64. -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
  65. -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
  66. -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
  67. -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
  68. -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
  69. -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
  70. -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
  71. -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
  72. -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
  73. -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
  74. -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
  75. -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
  76. -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
  77. -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
  78. -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
  79. -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
  80. -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
  81. -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
  82. -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
  83. -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
  84. -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
  85. -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
  86. -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
  87. -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
  88. -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
  89. -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
  90. -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
  91.  
  92. ==================================================
  93. Changes to individual picklist values:
  94. ==================================================
  95.  
  96. id: -924210
  97. active before: [true] after: [false]
  98. id: -924209
  99. active before: [true] after: [false]
  100. id: -924212
  101. active before: [true] after: [false]
  102. id: -924211
  103. active before: [true] after: [false]
  104. id: -924213
  105. active before: [true] after: [false]
  106. id: -924405
  107. sequence_number before: [13] after: [12]
  108. id: -924406
  109. sequence_number before: [14] after: [13]
  110. id: -924407
  111. sequence_number before: [15] after: [14]
  112. id: -924408
  113. sequence_number before: [16] after: [15]
  114. id: -924401
  115. sequence_number before: [9] after: [8]
  116. id: -924402
  117. sequence_number before: [10] after: [9]
  118. id: -924403
  119. sequence_number before: [11] after: [10]
  120. id: -924404
  121. sequence_number before: [12] after: [11]
  122. id: -924413
  123. sequence_number before: [21] after: [20]
  124. id: -924414
  125. sequence_number before: [22] after: [21]
  126. id: -924415
  127. sequence_number before: [23] after: [22]
  128. id: -924409
  129. sequence_number before: [17] after: [16]
  130. id: -924410
  131. sequence_number before: [18] after: [17]
  132. id: -924411
  133. sequence_number before: [19] after: [18]
  134. id: -924412
  135. sequence_number before: [20] after: [19]
  136. id: -924398
  137. sequence_number before: [6] after: [5]
  138. id: -924397
  139. sequence_number before: [5] after: [4]
  140. id: -924400
  141. sequence_number before: [8] after: [7]
  142. id: -924399
  143. sequence_number before: [7] after: [6]
  144. id: -924394
  145. sequence_number before: [2] after: [1]
  146. id: -924396
  147. sequence_number before: [4] after: [3]
  148. id: -924395
  149. sequence_number before: [3] after: [2]
  150. id: -910060
  151. sequence_number before: [1] after: [0]
  152. id: -910059
  153. sequence_number before: [0] after: [27]
  154. id: -10000634
  155. string_value before: [Restititon] after: [Restitution]
  156. id: -10000600
  157. string_value before: [Hasish] after: [Hashish]
  158. description before: [Hasish] after: [Hashish]
  159. id: -10000594
  160. string_value before: [Cocaine (powder)] after: [Cocaine]
  161. description before: [Cocaine (powder)] after: [Cocaine]
  162. id: -923613
  163. string_value before: [AQUITTED] after: [AQUIT]
  164. description before: [AQUITTED] after: [AQUIT]
  165. id: -10001136
  166. sequence_number before: [24] after: [23]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!