-
Notifications
You must be signed in to change notification settings - Fork 1
/
Fill_Database0.sql
3342 lines (3342 loc) · 481 KB
/
Fill_Database0.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
/* Doctor Insertions */
INSERT INTO Doctor (d_id, d_first_name, d_last_name, d_employed_date) VALUES ('D789', 'Imani', 'Roberts', to_date('24/02/1990', 'dd/mm/yyyy'));
INSERT INTO Doctor (d_id, d_first_name, d_last_name, d_employed_date) VALUES ('D764', 'Walker', 'Stein', to_date('12/06/1996', 'dd/mm/yyyy'));
INSERT INTO Doctor (d_id, d_first_name, d_last_name, d_employed_date) VALUES ('D797', 'Melodie', 'Farrell', to_date('13/01/2000', 'dd/mm/yyyy'));
INSERT INTO Doctor (d_id, d_first_name, d_last_name, d_employed_date) VALUES ('D64', 'Brianna', 'Ware', to_date('1/11/1979', 'dd/mm/yyyy'));
/* Patient Insertions */
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (4994820407, 'Kibo', 'Roary', 'Delacruz', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (96528830, 'Rose', 'Adrienne', 'Love', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (4570532007, 'Kaye', 'Shea', 'Garner', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (2033245913, 'Devin', '', 'Skinner', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (7747495466, 'Jonas', 'Thaddeus', 'Stuart', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (8280039343, 'Linda', '', 'Byrd', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (5504924452, 'Herman', '', 'Wilkins', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (5589473607, 'Rae', 'Hayden', 'Huff', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (8655896257, 'Judith', 'Odette', 'Foley', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (969400694, 'Keith', 'Benjamin', 'Cleveland', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (3099747112, 'Lesley', 'Nigel', 'Morris', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (116787819, 'Olga', 'Callum', 'Hobbs', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (4458931944, 'Lesley', 'Connor', 'Stein', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (6059489737, 'Karen', 'Hyacinth', 'Wiggins', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (6061899931, 'Lars', 'Imelda', 'Parrish', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (3843947887, 'Catherine', '', 'Coleman', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (9514476656, 'Jesse', 'Ina', 'Moss', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (3228054205, 'Irene', 'Cassidy', 'Lyons', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (3162685496, 'Elijah', 'Carol', 'Aguirre', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (2812470316, 'Jenette', 'Jennifer', 'Bryant', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (3276780813, 'Athena', 'Olga', 'Griffin', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (5375525959, 'Macaulay', 'Haviva', 'Fulton', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (6298872745, 'Francesca', 'Hector', 'Soto', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (5996735857, 'Mia', 'Amena', 'Morse', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (7454769265, 'Cairo', '', 'Mack', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (8290339259, 'Adrienne', 'Athena', 'Sellers', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (8654655460, 'Herman', 'Georgia', 'Holt', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (2301327858, 'Ezra', '', 'Yang', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (4003803584, 'Cairo', 'Shelly', 'Bradford', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (3935071831, 'Kaye', 'Tanek', 'Cohen', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (7388459373, 'Justin', 'Sasha', 'Casey', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (3437088553, 'Marshall', 'Hashim', 'Love', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (3257815200, 'Hyacinth', 'Thaddeus', 'Dillard', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (5707720434, 'Jenette', '', 'Coleman', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (5933735095, 'Adrienne', 'Carol', 'Dalton', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (9268703157, 'Christian', 'Caldwell', 'Carter', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (1029060478, 'Ronan', 'Melodie', 'Ramirez', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (85785247, 'Shelly', '', 'Benjamin', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (3345000475, 'Christian', '', 'George', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (1507343410, 'Hyacinth', '', 'Goodwin', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (2815416000, 'Justine', '', 'Pennington', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (2921382094, 'Bell', 'Connor', 'Knox', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (2019897468, 'Mia', 'Charity', 'Barrera', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (4593052841, 'Tatum', 'Marshall', 'Maxwell', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (9038202661, 'Ina', 'Ruth', 'Coleman', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (1664364344, 'Libby', 'Lucy', 'Soto', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (9103206061, 'Burke', 'Brenna', 'Jarvis', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (5582498399, 'Ruth', 'Caldwell', 'Skinner', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (4994301602, 'Felicia', 'Jenette', 'Rios', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (8796828442, 'Roth', 'Shea', 'Holt', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (8757882066, 'Athena', 'Basia', 'Alvarado', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (5880592218, 'Walker', 'Kaye', 'Jacobson', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (6838628218, 'Marshall', 'Emily', 'Mcpherson', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (3254320120, 'Callum', 'Hashim', 'Mckay', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (6854282314, 'Christian', 'Catherine', 'Wiggins', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (7539455344, 'Lesley', 'Cassidy', 'Hobbs', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (1142001154, 'Alyssa', 'Oscar', 'Jarvis', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (9355460777, 'Kaye', 'Hyacinth', 'Buckner', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (413497885, 'Farrah', 'Jenette', 'Snyder', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (1988033962, 'Abraham', 'Lesley', 'Cleveland', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (2009021450, 'Neville', 'Naida', 'Harris', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (114298891, 'Jerry', 'Libby', 'Bryant', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (135615945, 'Sylvia', 'Declan', 'Schroeder', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (1081214761, 'Jonah', 'Jeremy', 'Andrews', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (1255627326, 'Cairo', 'Garrison', 'Acosta', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (2097890380, 'Basia', 'September', 'Irwin', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (2443410133, 'Jesse', 'Declan', 'Stephens', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (9216721734, 'Amery', 'Kaye', 'Petty', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (7381710081, 'Jenette', 'Ezra', 'Burton', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (4831732435, 'Jennifer', 'Madaline', 'Love', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (6898087904, 'Ezra', 'Amena', 'Cohen', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (7398395518, 'Athena', 'Linda', 'Jacobson', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (4063583583, 'Tana', 'Fiona', 'Patton', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (1554503464, 'Ezra', 'Lamar', 'Mckay', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (8251926379, 'Josiah', '', 'Kirby', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (4244260021, 'Nigel', 'Lunea', 'Byrd', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (3376989102, 'Felicia', 'Wendy', 'Simpson', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (4466389550, 'Lars', '', 'Hunt', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (6050425019, 'Ina', 'Ann', 'Hobbs', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (9762675580, 'Hashim', 'Burke', 'Adkins', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (6191327328, 'Kaye', 'Garrison', 'Barrera', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (5497721387, 'Oscar', '', 'Cash', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (6708613119, 'Libby', 'Melodie', 'Burton', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (8614061646, 'Lois', '', 'Love', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (3338775495, 'Connor', 'Lars', 'Knox', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (2706452745, 'Oscar', 'Lara', 'Schmidt', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (6151912513, 'Rose', 'Lara', 'Wilkins', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (5471254270, 'Elijah', '', 'Fitzgerald', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (2950766659, 'Wendy', 'Athena', 'Maxwell', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (2524560208, 'Suki', 'Wyoming', 'Pennington', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (7244371033, 'Adrienne', 'Shea', 'Key', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (5853699429, 'Adrienne', 'Burke', 'Chase', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (5268286837, 'Wynne', 'Fiona', 'Bentley', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (7008527922, 'Byron', 'Shana', 'Anthony', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (4878729303, 'Justin', '', 'Fitzpatrick', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (1609263795, 'Irene', 'Irene', 'Schroeder', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (4631427834, 'Farrah', 'Quinn', 'Griffin', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (9315737638, 'Justin', 'Miranda', 'Buckner', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (3676633181, 'Adrienne', 'Nash', 'Contreras', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (9445354979, 'Jenette', 'Lois', 'Mcmahon', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (6478944760, 'Melodie', 'Jennifer', 'Bowen', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (7107697087, 'Jennifer', 'Jeremy', 'Weber', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (180731918, 'Shea', 'Nash', 'Lewis', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (2246354779, 'Thaddeus', 'Byron', 'Koch', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (4389418021, 'Adrienne', 'Cairo', 'Shepherd', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (5002401781, 'Maya', '', 'Kirby', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (5624199477, 'Haviva', 'Kimberley', 'Holt', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (8316109098, 'Jillian', 'Kaye', 'Stuart', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (7821570407, 'Byron', 'Callum', 'Lyons', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (4428506844, 'Devin', 'Igor', 'Kirby', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (1809789810, 'Tiger', 'Upton', 'Maxwell', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (6676637134, 'Shoshana', 'Odette', 'Ramirez', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (1728326071, 'Roth', 'Maya', 'Rios', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (7803309740, 'Prescott', 'Neville', 'Massey', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (1482288657, 'Wyoming', 'Cairo', 'Hobbs', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (4958032873, 'Rae', 'Lesley', 'Stokes', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (784662371, 'Haviva', 'Abraham', 'Bradford', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (925371656, 'Imani', 'Dacey', 'Hampton', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (756997697, 'Abraham', 'Lara', 'Ray', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (3455405457, 'Ezra', 'Imani', 'Schroeder', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (3361368657, 'Amena', 'Oscar', 'Delacruz', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (4578596368, 'Wynne', '', 'Shepherd', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (2246850453, 'Thaddeus', 'Lois', 'Hartman', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (8144444643, 'Grace', 'Cassidy', 'Byrd', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (4336325597, 'Maya', '', 'Mcmahon', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (9631801555, 'Bell', 'Herman', 'Hanson', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (2742866589, 'Amery', 'Lunea', 'Shepherd', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (957119679, 'Lunea', 'Jerome', 'Fulton', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (5404193907, 'Grace', 'Ruth', 'Fulton', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (6875197606, 'Lara', 'Melodie', 'Page', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (7374886005, 'Jillian', 'Jesse', 'Skinner', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (5851014502, 'Wyoming', 'Ciara', 'Chase', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (4718730319, 'Shelly', 'Orson', 'Mendez', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (5738542567, 'Caldwell', 'Olga', 'Hahn', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (9825204485, 'Lunea', 'Thaddeus', 'Gaines', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (6633248855, 'Jack', 'Leo', 'Hahn', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (2711323181, 'Kimberley', '', 'Leonard', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (8829912480, 'Wyoming', 'Tatum', 'Collins', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (9304692914, 'Mari', 'Lunea', 'Whitehead', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (8699136049, 'Lars', '', 'Stein', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (2883799741, 'Nigel', 'Amena', 'Benjamin', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (1657380225, 'Callum', '', 'Rodriquez', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (9321524954, 'Justine', 'Mia', 'Byrd', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (3226157429, 'Ina', 'Upton', 'Gaines', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (6956279829, 'Judith', 'Jenette', 'Scott', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (2518100514, 'Ava', 'Catherine', 'Hanson', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (8956816291, 'Kibo', 'Oscar', 'Page', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (4496988029, 'Igor', 'Karen', 'Irwin', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (3297877356, 'Kimberley', 'Igor', 'Yang', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (3962974606, 'Shelly', 'Jack', 'Foley', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (1156583591, 'Igor', 'Odette', 'Irwin', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (1174443477, 'Lamar', 'Amena', 'Powers', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (6054624450, 'Connor', 'Brenna', 'Jarvis', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (1378725389, 'Shoshana', 'Callum', 'Adkins', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (4921755996, 'Orson', 'Lucy', 'Farrell', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (5691341161, 'Rae', 'Ina', 'Swanson', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (4260953902, 'Odysseus', 'Odette', 'Soto', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (7599411719, 'Leo', 'Macaulay', 'Knox', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (5719113393, 'Ava', 'Kaye', 'Massey', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (5328204923, 'Leo', 'Francis', 'Moss', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (6827034263, 'Madaline', 'Hector', 'Cash', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (7668988049, 'Fuller', '', 'Foley', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (1010729621, 'Kenneth', '', 'Ware', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (540461963, 'Ezra', 'Sylvia', 'Lyons', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (2031366091, 'Wyoming', 'Suki', 'Mcpherson', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (6793538797, 'Tatum', 'Justin', 'Conley', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (7447983706, 'Byron', 'Amena', 'Clayton', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (8851909068, 'Jennifer', 'Maya', 'Jacobson', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (7523429529, 'Lois', 'Jack', 'Byrd', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (3841718318, 'Yen', 'Kibo', 'Snyder', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (3744792535, 'Miranda', 'Odysseus', 'Maxwell', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (4480942721, 'Kirestin', '', 'Love', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (8856536939, 'Jillian', '', 'Chase', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (5534368020, 'Lamar', '', 'Irwin', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (1405543994, 'Ina', 'Lars', 'Foster', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (6858596231, 'Basia', 'Hyacinth', 'Blackburn', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (513336976, 'Mia', 'Suki', 'Garner', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (3812223946, 'Keith', 'Jonah', 'Cohen', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (135809156, 'Alyssa', '', 'Adkins', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (4732409566, 'Yen', 'Odysseus', 'Ware', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (6528169465, 'Melodie', 'Dacey', 'Skinner', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (7646518164, 'Kibo', 'India', 'Dodson', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (6525447369, 'Wynne', 'Ina', 'Fulton', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (6926567834, 'Basia', 'Tatum', 'Parrish', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (3046074601, 'Amery', 'Kimberley', 'Foster', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (474373179, 'Orla', 'Lara', 'Hewitt', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (8450725355, 'Melodie', 'Tatum', 'Gillespie', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (5889562026, 'Miranda', '', 'Casey', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (2648821530, 'Macaulay', 'Wyoming', 'Key', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (8840657126, 'Suki', 'Devin', 'Love', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (5930950926, 'Lunea', 'Aphrodite', 'Hewitt', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (9481888561, 'Ann', 'Miranda', 'Kaufman', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (359785647, 'Fiona', 'Jaden', 'Stout', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (6072641135, 'Kibo', 'Melodie', 'Soto', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (1079096678, 'Jenette', '', 'Lewis', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (5320461351, 'Kirestin', 'Ruth', 'Scott', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (8624145723, 'Shoshana', 'Garrison', 'Aguirre', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (8035654579, 'Brenna', 'Jenette', 'Ramirez', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (3525610050, 'Dacey', 'September', 'Langley', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (7674143462, 'Kenneth', '', 'Byrd', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (1806315395, 'Declan', 'Hyacinth', 'Huff', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (3792454321, 'Brianna', '', 'Koch', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (9976178427, 'Quinn', '', 'Ramirez', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (9089761481, 'Haviva', 'Hayden', 'Powers', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (2692449986, 'Ruth', '', 'Kaufman', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (9129897571, 'Walker', 'Macaulay', 'Skinner', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (3927728215, 'Catherine', 'Yen', 'Stein', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (2811776718, 'Kimberley', 'Kirestin', 'Cleveland', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (2859791480, 'Lars', '', 'Fitzgerald', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (3322784084, 'Tanek', '', 'Kaufman', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (8723747054, 'Dacey', 'Perry', 'Patton', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (6121410682, 'Ezra', 'Wyoming', 'Koch', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (139841035, 'Shea', 'Irene', 'Hobbs', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (4254790174, 'Suki', 'Catherine', 'Stuart', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (3589783620, 'Ann', 'Neville', 'Casey', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (1088106302, 'Alyssa', 'Jaden', 'Alvarado', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (6435503429, 'Fuller', 'Athena', 'Massey', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (8347625051, 'Mari', 'Shelly', 'Frank', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (5405481077, 'Imani', '', 'Pennington', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (4931675475, 'Madaline', 'Maya', 'Lyons', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (818257364, 'Neville', '', 'Garner', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (8931037303, 'Thaddeus', 'Declan', 'Roberts', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (1322076400, 'Igor', 'Karen', 'Mcpherson', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (4747656769, 'Jack', 'Nash', 'Goodwin', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (8005525087, 'Hector', 'Yen', 'Boone', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (854127693, 'Amena', '', 'Kaufman', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (3702721417, 'Nigel', 'Connor', 'Fulton', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (1418707255, 'Shoshana', 'Sylvia', 'Langley', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (9693739347, 'Marshall', 'Leo', 'Snyder', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (2949689059, 'Miranda', '', 'George', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (285210701, 'Garrison', 'Jeremy', 'Whitehead', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (27266088, 'Abraham', 'Tanek', 'Garner', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (2334728575, 'Charity', 'Callum', 'Roberts', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (3962589555, 'Jack', 'Georgia', 'Griffin', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (1066634100, 'Hyacinth', 'Quinn', 'Moss', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (798742738, 'Jeremy', '', 'Collins', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (7374429168, 'Naida', 'Naomi', 'Mcdonald', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (2479522268, 'Linda', 'Rose', 'Cohen', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (5684055069, 'Elijah', 'Sylvia', 'Stein', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (2982654385, 'Lamar', 'Caldwell', 'Weber', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (8718808927, 'Hayden', 'Ciara', 'Bowen', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (7120747532, 'India', 'Tana', 'Jarvis', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (6425514626, 'Jillian', 'Ina', 'Byrd', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (531097493, 'Francesca', '', 'Irwin', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (6092501903, 'Perry', 'Bell', 'Hess', 'D764');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (7311251071, 'Bell', 'Shoshana', 'Greene', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (5328714482, 'Georgia', 'Lamar', 'Thomas', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (3376902888, 'Igor', 'Ava', 'Knox', 'D789');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (1550429721, 'Jerry', 'Hyacinth', 'Cleveland', 'D797');
INSERT INTO Patient (p_id, p_first_name, p_middle_name, p_last_name, p_d_id) VALUES (4097735161, 'Libby', 'Dacey', 'Rich', 'D789');
/* Patient_Additional Insertions */
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (4994820407,to_date('20/2/1936','dd/mm/yyyy'),'','',287165394);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (96528830,to_date('16/3/1987','dd/mm/yyyy'),'','',746707478);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (4570532007,to_date('19/9/2005','dd/mm/yyyy'),'','',496420693);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (2033245913,to_date('13/9/1996','dd/mm/yyyy'),'','',846799922);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (7747495466,to_date('10/7/2011','dd/mm/yyyy'),'','',117986919);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (8280039343,to_date('20/2/1962','dd/mm/yyyy'),'','',917184553);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (5504924452,to_date('16/2/1978','dd/mm/yyyy'),'','',553928910);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (5589473607,to_date('27/7/1967','dd/mm/yyyy'),'','',267504450);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (8655896257,to_date('2/4/1926','dd/mm/yyyy'),'','',800864859);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (969400694,to_date('14/11/1946','dd/mm/yyyy'),'','',767189510);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (3099747112,to_date('13/8/1982','dd/mm/yyyy'),'','',500231194);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (116787819,to_date('21/10/1968','dd/mm/yyyy'),'','',311416738);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (4458931944,to_date('12/4/1963','dd/mm/yyyy'),'','',624303417);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (6059489737,to_date('16/3/1915','dd/mm/yyyy'),'','',813394333);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (6061899931,to_date('21/11/1955','dd/mm/yyyy'),'','',799340591);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (3843947887,to_date('2/2/1966','dd/mm/yyyy'),'','',234235242);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (9514476656,to_date('11/2/1918','dd/mm/yyyy'),'','',573876146);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (3228054205,to_date('8/3/1923','dd/mm/yyyy'),'','',241292459);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (3162685496,to_date('22/6/2009','dd/mm/yyyy'),'','',136982506);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (2812470316,to_date('1/5/1982','dd/mm/yyyy'),'','',273763338);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (3276780813,to_date('4/7/2004','dd/mm/yyyy'),'','',494723660);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (5375525959,to_date('24/4/2004','dd/mm/yyyy'),'','',250573892);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (6298872745,to_date('21/9/1993','dd/mm/yyyy'),'','',912849924);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (5996735857,to_date('1/3/2004','dd/mm/yyyy'),'','',280790221);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (7454769265,to_date('15/4/2009','dd/mm/yyyy'),'','',463364571);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (8290339259,to_date('21/9/1916','dd/mm/yyyy'),'','',720100321);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (8654655460,to_date('3/10/1915','dd/mm/yyyy'),'','',573958454);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (2301327858,to_date('4/8/1927','dd/mm/yyyy'),'','',186109365);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (4003803584,to_date('13/6/1940','dd/mm/yyyy'),'','',228610374);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (3935071831,to_date('24/9/1973','dd/mm/yyyy'),'','',208882469);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (7388459373,to_date('26/8/1917','dd/mm/yyyy'),'','',516854900);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (3437088553,to_date('13/3/1986','dd/mm/yyyy'),'','',903478249);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (3257815200,to_date('3/11/1945','dd/mm/yyyy'),'','',449808542);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (5707720434,to_date('7/3/1981','dd/mm/yyyy'),'','',975160128);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (5933735095,to_date('22/4/1968','dd/mm/yyyy'),'','',294448469);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (9268703157,to_date('23/3/1988','dd/mm/yyyy'),'','',305480502);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (1029060478,to_date('27/3/1929','dd/mm/yyyy'),'','',196990745);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (85785247,to_date('1/2/1937','dd/mm/yyyy'),'','',666406824);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (3345000475,to_date('1/1/1921','dd/mm/yyyy'),'','',571765660);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (1507343410,to_date('7/5/1952','dd/mm/yyyy'),'','',579642186);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (2815416000,to_date('9/7/1996','dd/mm/yyyy'),'','',937786989);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (2921382094,to_date('23/2/1950','dd/mm/yyyy'),'','',570729536);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (2019897468,to_date('24/3/1965','dd/mm/yyyy'),'','',698654967);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (4593052841,to_date('21/7/1940','dd/mm/yyyy'),'','',576807274);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (9038202661,to_date('9/2/2012','dd/mm/yyyy'),'','',390995773);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (1664364344,to_date('18/4/2008','dd/mm/yyyy'),'','',715344512);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (9103206061,to_date('13/6/1928','dd/mm/yyyy'),'','',541886821);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (5582498399,to_date('21/10/1982','dd/mm/yyyy'),'','',733442854);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (4994301602,to_date('11/5/1922','dd/mm/yyyy'),'','',934957525);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (8796828442,to_date('20/8/1997','dd/mm/yyyy'),'','',287991643);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (8757882066,to_date('22/7/1940','dd/mm/yyyy'),'','',605894549);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (5880592218,to_date('6/11/1980','dd/mm/yyyy'),'','',944841307);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (6838628218,to_date('20/10/1961','dd/mm/yyyy'),'','',276256346);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (3254320120,to_date('16/11/2011','dd/mm/yyyy'),'','',770483682);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (6854282314,to_date('16/1/1982','dd/mm/yyyy'),'','',639992536);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (7539455344,to_date('8/9/1915','dd/mm/yyyy'),'','',450146464);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (1142001154,to_date('2/2/1982','dd/mm/yyyy'),'','',725314988);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (9355460777,to_date('25/3/1963','dd/mm/yyyy'),'','',780574532);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (413497885,to_date('23/3/1931','dd/mm/yyyy'),'','',611944684);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (1988033962,to_date('10/11/2005','dd/mm/yyyy'),'','',238161611);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (2009021450,to_date('26/8/1943','dd/mm/yyyy'),'','',651325909);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (114298891,to_date('16/11/1960','dd/mm/yyyy'),'','',750296927);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (135615945,to_date('27/4/1934','dd/mm/yyyy'),'','',998477624);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (1081214761,to_date('9/1/1983','dd/mm/yyyy'),'','',224964694);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (1255627326,to_date('18/5/1924','dd/mm/yyyy'),'','',751187295);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (2097890380,to_date('24/6/1917','dd/mm/yyyy'),'','',145418136);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (2443410133,to_date('4/4/1977','dd/mm/yyyy'),'','',712350369);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (9216721734,to_date('26/2/1935','dd/mm/yyyy'),'','',900156765);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (7381710081,to_date('20/1/1920','dd/mm/yyyy'),'','',653152979);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (4831732435,to_date('25/3/1919','dd/mm/yyyy'),'','',870937677);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (6898087904,to_date('7/4/1999','dd/mm/yyyy'),'','',634892311);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (7398395518,to_date('7/11/1977','dd/mm/yyyy'),'','',103433909);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (4063583583,to_date('20/2/1990','dd/mm/yyyy'),'','',256326119);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (1554503464,to_date('24/1/2003','dd/mm/yyyy'),'','',328300587);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (8251926379,to_date('13/11/1940','dd/mm/yyyy'),'','',924199463);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (4244260021,to_date('7/8/2012','dd/mm/yyyy'),'','',983949828);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (3376989102,to_date('18/3/1945','dd/mm/yyyy'),'','',357608208);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (4466389550,to_date('1/5/1985','dd/mm/yyyy'),'','',245134303);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (6050425019,to_date('23/2/2003','dd/mm/yyyy'),'','',184309651);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (9762675580,to_date('8/5/2001','dd/mm/yyyy'),'','',289602581);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (6191327328,to_date('16/4/1992','dd/mm/yyyy'),'','',436403361);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (5497721387,to_date('22/1/2007','dd/mm/yyyy'),'','',144389964);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (6708613119,to_date('14/4/1981','dd/mm/yyyy'),'','',451530756);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (8614061646,to_date('23/2/1945','dd/mm/yyyy'),'','',930705214);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (3338775495,to_date('18/7/1916','dd/mm/yyyy'),'','',766945697);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (2706452745,to_date('18/2/1975','dd/mm/yyyy'),'','',400974791);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (6151912513,to_date('6/8/1934','dd/mm/yyyy'),'','',936657941);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (5471254270,to_date('9/2/1979','dd/mm/yyyy'),'','',789615506);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (2950766659,to_date('6/7/1955','dd/mm/yyyy'),'','',850687285);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (2524560208,to_date('8/10/1944','dd/mm/yyyy'),'','',553998674);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (7244371033,to_date('10/4/2014','dd/mm/yyyy'),'','',163237908);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (5853699429,to_date('6/10/1983','dd/mm/yyyy'),'','',705515100);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (5268286837,to_date('24/10/2011','dd/mm/yyyy'),'','',397851836);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (7008527922,to_date('13/11/1981','dd/mm/yyyy'),'','',343976201);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (4878729303,to_date('23/3/1983','dd/mm/yyyy'),'','',108837746);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (1609263795,to_date('12/11/1918','dd/mm/yyyy'),'','',542361872);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (4631427834,to_date('20/4/1935','dd/mm/yyyy'),'','',533402330);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (9315737638,to_date('21/9/1957','dd/mm/yyyy'),'','',411263822);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (3676633181,to_date('18/5/1931','dd/mm/yyyy'),'','',821261468);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (9445354979,to_date('15/5/1926','dd/mm/yyyy'),'','',841285746);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (6478944760,to_date('21/4/2004','dd/mm/yyyy'),'','',486408496);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (7107697087,to_date('21/9/1940','dd/mm/yyyy'),'','',650859597);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (180731918,to_date('16/3/1917','dd/mm/yyyy'),'','',501811584);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (2246354779,to_date('14/10/1953','dd/mm/yyyy'),'','',254745697);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (4389418021,to_date('2/8/1960','dd/mm/yyyy'),'','',239578628);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (5002401781,to_date('5/2/1955','dd/mm/yyyy'),'','',712545865);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (5624199477,to_date('26/11/1975','dd/mm/yyyy'),'','',445307568);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (8316109098,to_date('4/11/2009','dd/mm/yyyy'),'','',537946664);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (7821570407,to_date('5/8/1940','dd/mm/yyyy'),'','',491389707);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (4428506844,to_date('3/6/1941','dd/mm/yyyy'),'','',954745736);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (1809789810,to_date('24/4/1937','dd/mm/yyyy'),'','',772706841);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (6676637134,to_date('5/8/2010','dd/mm/yyyy'),'','',813719742);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (1728326071,to_date('18/11/1946','dd/mm/yyyy'),'','',620427581);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (7803309740,to_date('17/6/1955','dd/mm/yyyy'),'','',479365541);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (1482288657,to_date('20/11/1997','dd/mm/yyyy'),'','',783234246);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (4958032873,to_date('1/3/1920','dd/mm/yyyy'),'','',498673242);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (784662371,to_date('23/4/1918','dd/mm/yyyy'),'','',859143908);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (925371656,to_date('2/6/1938','dd/mm/yyyy'),'','',650312362);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (756997697,to_date('23/8/1916','dd/mm/yyyy'),'','',191792534);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (3455405457,to_date('24/9/1974','dd/mm/yyyy'),'','',194446487);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (3361368657,to_date('10/4/1984','dd/mm/yyyy'),'','',385829480);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (4578596368,to_date('19/5/2001','dd/mm/yyyy'),'','',965192219);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (2246850453,to_date('19/7/1923','dd/mm/yyyy'),'','',679365339);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (8144444643,to_date('25/9/1939','dd/mm/yyyy'),'','',507875126);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (4336325597,to_date('18/3/2013','dd/mm/yyyy'),'','',576444739);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (9631801555,to_date('3/2/1976','dd/mm/yyyy'),'','',251709800);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (2742866589,to_date('21/5/1992','dd/mm/yyyy'),'','',745327420);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (957119679,to_date('8/7/1956','dd/mm/yyyy'),'','',932406701);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (5404193907,to_date('24/1/2014','dd/mm/yyyy'),'','',523803974);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (6875197606,to_date('16/3/1958','dd/mm/yyyy'),'','',881254235);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (7374886005,to_date('14/10/1919','dd/mm/yyyy'),'','',220659255);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (5851014502,to_date('4/11/2010','dd/mm/yyyy'),'','',795196126);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (4718730319,to_date('17/11/1927','dd/mm/yyyy'),'','',624920914);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (5738542567,to_date('10/6/1920','dd/mm/yyyy'),'','',160957292);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (9825204485,to_date('2/3/2001','dd/mm/yyyy'),'','',470659820);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (6633248855,to_date('19/3/1972','dd/mm/yyyy'),'','',962865868);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (2711323181,to_date('6/11/2013','dd/mm/yyyy'),'','',171990917);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (8829912480,to_date('3/8/1928','dd/mm/yyyy'),'','',659249876);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (9304692914,to_date('5/11/1941','dd/mm/yyyy'),'','',198624120);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (8699136049,to_date('25/2/1971','dd/mm/yyyy'),'','',315838169);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (2883799741,to_date('21/4/1964','dd/mm/yyyy'),'','',427775706);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (1657380225,to_date('23/10/1955','dd/mm/yyyy'),'','',141572697);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (9321524954,to_date('26/10/1947','dd/mm/yyyy'),'','',860252934);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (3226157429,to_date('4/4/1995','dd/mm/yyyy'),'','',140964725);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (6956279829,to_date('11/3/1974','dd/mm/yyyy'),'','',559489648);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (2518100514,to_date('7/8/1921','dd/mm/yyyy'),'','',711261449);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (8956816291,to_date('17/2/1984','dd/mm/yyyy'),'','',543351346);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (4496988029,to_date('26/6/1919','dd/mm/yyyy'),'','',546510531);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (3297877356,to_date('1/8/1959','dd/mm/yyyy'),'','',634972522);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (3962974606,to_date('7/7/2014','dd/mm/yyyy'),'','',309678148);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (1156583591,to_date('24/6/1947','dd/mm/yyyy'),'','',215967323);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (1174443477,to_date('8/4/1952','dd/mm/yyyy'),'','',175497137);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (6054624450,to_date('22/4/1956','dd/mm/yyyy'),'','',384599886);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (1378725389,to_date('7/8/1979','dd/mm/yyyy'),'','',454616737);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (4921755996,to_date('17/11/1987','dd/mm/yyyy'),'','',703519777);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (5691341161,to_date('21/11/1985','dd/mm/yyyy'),'','',307138638);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (4260953902,to_date('14/3/2002','dd/mm/yyyy'),'','',686851345);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (7599411719,to_date('24/6/2012','dd/mm/yyyy'),'','',168529442);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (5719113393,to_date('13/9/2008','dd/mm/yyyy'),'','',722201812);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (5328204923,to_date('12/3/1954','dd/mm/yyyy'),'','',175477727);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (6827034263,to_date('12/4/1927','dd/mm/yyyy'),'','',362493252);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (7668988049,to_date('13/6/1940','dd/mm/yyyy'),'','',599441642);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (1010729621,to_date('24/10/1957','dd/mm/yyyy'),'','',665396905);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (540461963,to_date('3/6/1928','dd/mm/yyyy'),'','',523194388);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (2031366091,to_date('26/5/1952','dd/mm/yyyy'),'','',468387285);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (6793538797,to_date('16/11/1933','dd/mm/yyyy'),'','',554116604);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (7447983706,to_date('10/4/1922','dd/mm/yyyy'),'','',685384952);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (8851909068,to_date('1/6/1990','dd/mm/yyyy'),'','',157634315);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (7523429529,to_date('22/10/1925','dd/mm/yyyy'),'','',777590932);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (3841718318,to_date('9/11/1989','dd/mm/yyyy'),'','',637295351);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (3744792535,to_date('10/7/2004','dd/mm/yyyy'),'','',662225163);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (4480942721,to_date('9/3/1991','dd/mm/yyyy'),'','',384970140);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (8856536939,to_date('23/7/1922','dd/mm/yyyy'),'','',331611756);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (5534368020,to_date('19/3/1976','dd/mm/yyyy'),'','',997855458);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (1405543994,to_date('22/11/1979','dd/mm/yyyy'),'','',141984603);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (6858596231,to_date('12/4/1933','dd/mm/yyyy'),'','',778273238);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (513336976,to_date('6/6/1915','dd/mm/yyyy'),'','',345918764);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (3812223946,to_date('26/5/1938','dd/mm/yyyy'),'','',757994876);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (135809156,to_date('10/3/1918','dd/mm/yyyy'),'','',501272231);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (4732409566,to_date('26/9/1973','dd/mm/yyyy'),'','',713748206);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (6528169465,to_date('23/10/1975','dd/mm/yyyy'),'','',249365877);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (7646518164,to_date('9/8/1963','dd/mm/yyyy'),'','',476183483);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (6525447369,to_date('24/3/1931','dd/mm/yyyy'),'','',716463159);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (6926567834,to_date('10/1/1927','dd/mm/yyyy'),'','',400184868);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (3046074601,to_date('13/2/1923','dd/mm/yyyy'),'','',418801595);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (474373179,to_date('19/4/1916','dd/mm/yyyy'),'','',587852180);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (8450725355,to_date('24/6/1916','dd/mm/yyyy'),'','',602697733);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (5889562026,to_date('23/9/2011','dd/mm/yyyy'),'','',892467892);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (2648821530,to_date('21/10/1974','dd/mm/yyyy'),'','',936350254);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (8840657126,to_date('16/11/1968','dd/mm/yyyy'),'','',831378644);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (5930950926,to_date('3/1/1976','dd/mm/yyyy'),'','',555780722);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (9481888561,to_date('25/4/1961','dd/mm/yyyy'),'','',679796439);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (359785647,to_date('11/2/1961','dd/mm/yyyy'),'','',841169249);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (6072641135,to_date('19/3/1975','dd/mm/yyyy'),'','',843101845);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (1079096678,to_date('13/5/1950','dd/mm/yyyy'),'','',745342586);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (5320461351,to_date('23/2/1966','dd/mm/yyyy'),'','',243302804);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (8624145723,to_date('11/8/1972','dd/mm/yyyy'),'','',941484504);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (8035654579,to_date('3/7/2005','dd/mm/yyyy'),'','',592923232);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (3525610050,to_date('6/5/1932','dd/mm/yyyy'),'','',666954992);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (7674143462,to_date('15/1/1937','dd/mm/yyyy'),'','',660114845);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (1806315395,to_date('3/4/1988','dd/mm/yyyy'),'','',909322711);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (3792454321,to_date('6/8/1948','dd/mm/yyyy'),'','',725764387);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (9976178427,to_date('12/9/1948','dd/mm/yyyy'),'','',856871432);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (9089761481,to_date('1/4/1974','dd/mm/yyyy'),'','',554785309);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (2692449986,to_date('16/2/1923','dd/mm/yyyy'),'','',191196419);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (9129897571,to_date('2/5/1916','dd/mm/yyyy'),'','',496562939);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (3927728215,to_date('24/1/2006','dd/mm/yyyy'),'','',606612330);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (2811776718,to_date('10/5/2003','dd/mm/yyyy'),'','',899564891);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (2859791480,to_date('7/10/1958','dd/mm/yyyy'),'','',286372698);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (3322784084,to_date('25/6/1997','dd/mm/yyyy'),'','',294415300);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (8723747054,to_date('25/11/1931','dd/mm/yyyy'),'','',280396889);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (6121410682,to_date('25/10/1993','dd/mm/yyyy'),'','',398640216);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (139841035,to_date('16/9/1976','dd/mm/yyyy'),'','',864711482);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (4254790174,to_date('13/3/2005','dd/mm/yyyy'),'','',820383372);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (3589783620,to_date('7/11/2010','dd/mm/yyyy'),'','',289490596);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (1088106302,to_date('11/11/2001','dd/mm/yyyy'),'','',757862886);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (6435503429,to_date('1/2/1956','dd/mm/yyyy'),'','',311239287);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (8347625051,to_date('5/8/1948','dd/mm/yyyy'),'','',213909886);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (5405481077,to_date('16/11/1928','dd/mm/yyyy'),'','',321574571);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (4931675475,to_date('22/8/1957','dd/mm/yyyy'),'','',882813327);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (818257364,to_date('15/9/1954','dd/mm/yyyy'),'','',299506292);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (8931037303,to_date('9/2/1944','dd/mm/yyyy'),'','',568393254);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (1322076400,to_date('20/7/1957','dd/mm/yyyy'),'','',685574512);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (4747656769,to_date('1/2/1946','dd/mm/yyyy'),'','',933469420);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (8005525087,to_date('17/8/1934','dd/mm/yyyy'),'','',971584211);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (854127693,to_date('1/1/2005','dd/mm/yyyy'),'','',464395420);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (3702721417,to_date('22/5/1982','dd/mm/yyyy'),'','',657969779);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (1418707255,to_date('8/3/1935','dd/mm/yyyy'),'','',421122946);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (9693739347,to_date('22/9/1950','dd/mm/yyyy'),'','',576534543);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (2949689059,to_date('14/3/1932','dd/mm/yyyy'),'','',649222789);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (285210701,to_date('22/1/1933','dd/mm/yyyy'),'','',858386754);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (27266088,to_date('8/9/1948','dd/mm/yyyy'),'','',224378168);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (2334728575,to_date('7/2/1974','dd/mm/yyyy'),'','',729220964);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (3962589555,to_date('17/6/1978','dd/mm/yyyy'),'','',735949324);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (1066634100,to_date('10/5/1917','dd/mm/yyyy'),'','',251600565);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (798742738,to_date('17/3/1925','dd/mm/yyyy'),'','',436542772);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (7374429168,to_date('24/9/1982','dd/mm/yyyy'),'','',233957777);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (2479522268,to_date('15/10/1976','dd/mm/yyyy'),'','',878474499);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (5684055069,to_date('26/10/1957','dd/mm/yyyy'),'','',734756497);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (2982654385,to_date('4/6/1929','dd/mm/yyyy'),'','',849388803);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (8718808927,to_date('17/2/1960','dd/mm/yyyy'),'','',342700652);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (7120747532,to_date('23/6/1975','dd/mm/yyyy'),'','',953572284);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (6425514626,to_date('11/7/2014','dd/mm/yyyy'),'','',107716312);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (531097493,to_date('20/10/1965','dd/mm/yyyy'),'','',910831111);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (6092501903,to_date('22/6/1996','dd/mm/yyyy'),'','',385138512);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (7311251071,to_date('12/7/1948','dd/mm/yyyy'),'','',563540408);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (5328714482,to_date('20/9/1946','dd/mm/yyyy'),'','',323332469);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (3376902888,to_date('20/1/2007','dd/mm/yyyy'),'','',950427424);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (1550429721,to_date('7/8/1929','dd/mm/yyyy'),'','',301200673);
INSERT INTO Patient_Additional (pa_p_id, pa_bd, pa_add1, pa_add2, pa_ph) VALUES (4097735161,to_date('1/4/1948','dd/mm/yyyy'),'','',635549718);
/* Encounter Insertions */
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('12110','Consultation - in office: (age 0-1)',80.12);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00110','Consultation - in office: (age 2 - 49)',72.82);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('15310','Consultation in office (age 50 - 59)',80.12);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('16110','Consultation - in office: (age 60 - 69)',83.77);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('17110','Consultation - in office: (age 70 - 79)',94.67);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('18110','Consultation - in office: (age 80+)',109.23);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00116','Special in-hospital consultation',154.33);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('12210','Consultation out of office (age 0 1)',96.15);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('13210','Consultation out of office (age 2 - 49)',87.39);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('15210','Consultation out of office (age 50 - 59)',96.15);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('16210','Consultation out of office (age 60 - 69)',100.51);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('17210','Consultation out of office (age 70 - 79)',113.62);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('18210','Consultation out of office (age 80+)',131.09);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('12101','Complete examination - in office (age 0-1)',72.83);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00101','Complete examination - in office (age 2-49)',66.20);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('15301','Complete examination in office (age 50 59)',72.83);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('16101','Complete examination - in office (age 60-69)',76.15);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('17101','Complete examination - in office (age 70-79)',86.07);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('18101','Complete examination - in office (age 80+)',99.29);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('12201','Complete examination - out of office (age 0-1)',87.40);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('13201','Complete examination - out of office (age 2-49)',79.45);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('15201','Complete examination - out of office (age 50-59)',87.40);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('16201','Complete examination - out of office (age 60-69)',91.38);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('17201','Complete examination - out of office (age 70-79)',103.27);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('18201','Complete examination - out of office (age 80+)',119.16);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('12100','Visit - in office (age 0-1)',32.75);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00100','Visit - in office (age 2-49)',29.79);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('15300','Visit in office (age 50-59)',32.75);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('16100','Visit - in office (age 60-69)',34.23);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('17100','Visit - in office (age 70-79)',38.70);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('18100','Visit - in office (age 80+)',44.67);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P13070','In office assessment of an unrelated condition(s) in association with a WorkSafe BC service',15.75);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P13075','In office assessment of an unrelated condition(s) in association with an ICBC service',15.75);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('12200','Visit - out of office (age 0-1)',39.32);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('13200','Visit - out of office (age 2-49)',35.73);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('15200','Visit out of office (age 50-59)',39.32);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('16200','Visit - out of office (age 60-69)',41.08);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('17200','Visit - out of office (age 70-79)',46.45);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('18200','Visit - out of office (age 80+)',53.60);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P13763','Three patients',24.65);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P13764','Four patients',19.92);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P13765','Five patient',17.11);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P13766','Six patients',15.23);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P13767','Seven patients',13.89);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P13768','Eight patients',12.88);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P13769','Nine patients',12.09);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P13770','Ten patients',11.45);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P13771','Eleven patients',10.03);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P13772','Twelve patients',9.43);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P13773','Thirteen patients',8.74);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P13774','Fourteen patients',8.58);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P13775','Fifteen patients',8.23);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P13776','Sixteen patients',7.98);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P13777','Seventeen patients',7.65);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P13778','Eighteen patients',7.48);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P13779','Nineteen patients',7.22);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P13780','Twenty patients',7.05);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P13781','Greater than 20 patients (per patient)',6.79);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('12120','Individual counselling - in office (age 0-1)',57.03);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00120','Individual counselling - in office (age 2-49)',51.84);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('15320','Individual counselling in office (age 50-59)',57.03);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('16120','Individual counselling - in office (age 60-69)',59.62);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('17120','Individual counselling - in office (age 70-79)',67.40);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('18120','Individual counselling - in office (age 80+)',77.77);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('12220','Individual counselling - out of office (age 0-1)',68.43);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('13220','Individual counselling - out of office (age 2-49)',62.20);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('15220','Individual counselling out of office (age 50 59)',68.43);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('16220','Individual counselling - out of office (age 60-69)',71.55);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('17220','Individual counselling - out of office (age 70-79)',80.85);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('18220','Individual counselling - out of office (age 80+)',93.30);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00121','- first full hour',84.75);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00122','- second hour, per 1/2 hour or major portion thereof',42.41);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P13036','Telehealth GP in-office Consultation',80.37);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P13037','Telehealth GP in-office Visit',33.56);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P13041','- First full hour',84.75);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P13042','- Second hour, per ½ hour or major portion thereof',42.41);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P13016','Telehealth GP out-of-office Consultation',105.65);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P13017','Telehealth GP out-of-office Visit',40.31);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P13021','- First full hour',84.75);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P13022','- Second hour, per ½ hour or major portion thereof',42.41);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('13015','HIV/AIDS Primary Care Management in or out of office - per half hour or major portion thereof',82.30);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00109','Acute care hospital admission visit',79.10);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00108','Hospital visit',31.31);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00128','Supportive care hospital visit',26.51);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00127','Terminal care facility visit',40.27);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P13338','Community based GP, first facility visit of the day bonus, extra (active hospital privileges) (for routine, supportive or terminal care)',35.53);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('13008','Community based GP: hospital visit (active hospital privileges)',40.27);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('13028','Community based GP: supportive care hospital visit (active hospital privileges)',34.09);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P13339','Community based GP, first facility visit of the day bonus, extra, (courtesy/associate privileges)',28.25);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('13228','Community based GP: hospital visit (courtesy/associate privileges)',28.25);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00113','Evening (between 1800 hours and 2300 hours)',48.73);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00105','Night (between 2300 hours and 0800 hours)',68.55);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00123','Saturday, Sunday or Statutory Holiday',48.73);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00114','One or multiple patients, per patient',32.22);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P13334','Community based GP, long term care facility visit - first visit of the day bonus, extra',32.22);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00115','Nursing home visit one patient, when specially called and patient seen between hours of 0800 hrs and 2300 hrs any day',108.95);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00112','Emergency visit (call placed between hours of 0800 and 1800 hours) weekdays',108.95);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00111','An emergency home (or scene of accident) visit for an acutely ill or injured patient immediately followed by a trip to hospital to arrange for emergency admission and to include immediate associated hospital visit',110.92);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('13000','Telephone advice to a Community Health Representative in First Nations Communities',14.88);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('13005','Advice about a patient in Community Care',14.88);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('14090','Prenatal visit - complete examination',79.46);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('14091','- subsequent examination',29.79);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P14094','Post-natal office visit',29.79);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('14104','Delivery and post-natal care (1-14 days in-hospital)',550.55);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('14108','Post-natal care after elective caesarean section(1-14 days in-hospital)',113.26);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('14109','Primary management of labour and attendance at delivery and post-natal care associated with emergency caesarean section (1-14 days in-hospital)',458.58);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('T14545','Medical abortion',155.31);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('15120','Pregnancy test, immunologic - urine',10.94);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00118','Attendance at caesarian section (if specifically requested by surgeon for care of baby only)',85.50);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00119','Routine care of newborn in hospital',87.40);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('14540','Insertion of intrauterine contraceptive device (operation only) 40.61',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('Y13655','GP vasectomy bonus associated with bilateral vasectomy',20.20);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('13194','First Surgical Assist of the Day',75.76);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00195','- less than $317.00 inclusive',130.08);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00196','- $317.01 to 529.00 inclusive',183.39);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00197','- over $529.01',240.16);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00198','Time, after 3 hours of continuous surgical assistance for one patient, each 15 minutes or fraction thereof',27.47);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00193','Non-CVT-certified surgical assistance at open-heart surgery, per quarter hour or major portion thereof',27.78);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('13052','Anesthetic evaluation - non-certified anesthesiologist',38.71);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00190','Forms of treatment other than excision, X-ray, or Grenz ray; such as removal of haemangiomas and warts with electrosurgery, cryotherapy, etc.- per visit (operation only)',29.46);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('13660','Metatarsal bone - closed reduction (operation only) 49.69',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('13600','Biopsy of skin or mucosa (operation only) 48.88',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('13601','Biopsy of facial area (operation only) 48.88',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('13605','Opening superficial abscess, including furuncle - operation only 41.87',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('13611','Minor laceration or foreign body - requiring anesthesia - operation only 62.46',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('13612','Extensive laceration greater than 5 cm (maximum charge 35 cm) - operation only - per cm 12.52',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('13620','Excision of tumour of skin or subcutaneous tissue or small scar under local anesthetic - up to 5 cm (operation only) 62.46',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('13621','- additional lesions removed at the same sitting (maximum per sitting, five) each (operation only)',31.24);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('13622','Localized carcinoma of skin proven histopathologically (operation only) 69.00',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('13630','Paronychia - operation only (operation only) 33.46',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('13631','Removal of nail - simple operation only 33.46',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('13632','- with destruction of nail bed (operation only) 67.69',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('13633','Wedge excision of one nail (operation only) 59.72',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('Y10710','In office Anoscopy',7.45);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00012','Venepuncture and dispatch of specimen to laboratory, when no other blood work performed',5.62);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('15132','Candida Culture',6.50);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P15134','Examination for pinworm ova',5.76);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('15136','Fungus, direct examination, KOH preparation',8.23);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('15100','Glucose - semiquantitative (dipstick analysed visually or by reflectance meter)',3.53);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('15137','Hemoglobin cyanmethemoglobin method and/or haematocrit.',3.07);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('15000','Hemoglobin - other methods',1.55);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('15110','Occult blood feces',5.12);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('15120','Pregnancy test, immunologic - urine',10.94);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('30015','Secretion smear for eosinophils',7.15);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('15138','Sedimentation rate',2.46);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('15139','Sperm, Seminal examination for presence or absence',14.40);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P15140','Stained smear',7.25);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P15141','Trichomonas and/or Candida direct examination',5.49);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('15130','Urinalysis - Chemical or any part of (screening)',2.05);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('15131','Urinalysis - Microscopic examination of centrifuged deposit',4.00);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('15142','Urinalysis - Complete diagnostic, semi-quant and micro',5.37);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('15143','White cell count only (see hematology protocol)',6.31);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00117','Interpretation of electrocardiogram by non-internist',9.77);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('G14015','General Practice Facility Patient Conference: when requested by a facility to review ongoing management of the patient in that facility or to determine whether a patient in a facility with complex supportive care needs can safely return to the community or transition to a supportive care or long-term facility - per 15 minutes or greater portion thereof',40.00);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('G14018','General Practice Urgent Telephone Conference with a Specialist Fee: Conferencing on an urgent basis (within 2 hours of request for a telephone conference) with a specialist or GP with specialty training by telephone followed by the creation, documentation, and implementation of a clinical action plan for the care of patients with acute needs; i.e. requiring attention within the next 24 hours and communication of that plan to the patient or patient''s representative',40.00);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('G14079','GP Telephone/Email Management Fee',15.00);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('G14033','GP Annual Complex Care Management Fee',315.00);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('G14066','Personal Health Risk Assessment',50.00);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('G14010','Maternity Care Network Initiative Payment',2100.00);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('G14004','Incentive for Full Service General Practitioner - Obstetric Delivery bonus associated with vaginal delivery and postnatal care',275.28);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('G14005','Incentive for Full Service General Practitioner - Obstetric delivery bonus associated with management of labour and transfer to a higher level of care facility for delivery',114.64);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('G14009','Incentive for Full Service General Practitioner - Obstetric Delivery bonus related to attendance at delivery and postnatal care associated with emergency caesarean section',229.29);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('G14008','Incentive for Full Service General Practitioner Obstetric Delivery bonus associated with postnatal care after an elective C-section',56.63);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('G14043','GP Mental Health Planning Fee',100.00);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('G14044','GP Mental Health Management Fee age 2 49',51.84);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('G14045','GP Mental Health Management Fee age 50 - 59',57.03);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('G14046','GP Mental Health Management Fee age 60 - 69',59.62);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('G14047','GP Mental Health Management Fee age 70 - 79',67.40);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('G14048','GP Mental Health Management Fee age 80+',77.77);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('G14063','Palliative Care planning fee',100.00);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('G14021','GP with Specialty Training Telephone Advice - Initiated by a Specialist or General Practitioner, Response within 2 hours',60.00);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('G14022','GP with Specialty Training Telephone Patient Management - Initiated by a Specialist or General Practitioner, Response in One Week',40.00);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('G14023','GP with Specialty Training Telephone Patient Management / Follow-Up',20.00);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('B00010','Intramuscular medications',10.20);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('B00011','Intravenous medications',12.04);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('B00013','Intra-arterial medications',15.10);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('Y00014','Intra-articular medications by injection  hip (initial injection)',24.05);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('Y00015','- tendons, bursae, and all other joints (initial injection)',16.00);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00016','Intrathecal medications by injection',32.17);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00019','Venesection for polycythaemia or phlebotomy - procedural fee',29.71);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00018','Autologous ascitic infusion',46.93);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00017','Insertion of central venous pressure catheter',23.32);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00020','Administered outside hospital',58.57);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00021','Administered in hospital',36.38);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00022','Serum transfusion',23.31);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00023','With vein dissection - extra',50.19);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('33750','Blood dialysis - physician in charge',516.73);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('33751','Repeat blood dialysis - physician in charge',194.18);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('items','33750 or 33751',130.64);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('33708','Subsequent hospital visits (Preamble, Clause B.4.e.(ii) applies)',26.63);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('33756','Reinsertion of peritoneal catheter after 10 days from initial insertion',50.79);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('77380','Insertion of permanent catheter, procedural fee only 185.47',3);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('33761','Supervision of home dialysis - per week',61.40);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('B00030','Diagnostic skin tests (Schick, Dick, TB., and Frei.)',8.42);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('B00031','Vaccination against smallpox (with certificate)',8.10);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('10010','DTaP-P (Diphtheria, Tetanus, Pertussis, Polio)',5.12);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('10012','Td (Tetanus, Diphtheria)',5.12);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('10013','TdP (Tetanus, Diphtheria, Polio)',5.12);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('10014','TdaP (Tetanus, Diphtheria, Pertussis)',5.12);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('10015','Flu (Influenza)',5.12);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('10018','HiB (Haemophilus influenza type b)',5.12);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('10019','IPV (Polio Vaccine - Inactivated)',5.12);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('10020','MEN-C-C (Meningococcal-Conjugate-ACYW135)',5.12);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('10021','MEN-C-ACYW135 (Meningococcal-Conjugate-ACYW135)',5.12);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('10022','MMR (Measles, Mumps, Rubella)',5.12);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('10023','PNEU-C-13 (Pneumococcal 13-valent Conjugate)',5.12);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('10024','PNEU-P-23 (Pneumococcal-Polysaccharide-23)',5.12);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('10025','RAB (Rabies)',5.12);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('10026','VAR (Varicella)',5.12);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('10028','HPV vaccine (Human Papiloma Virus)',5.12);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('10029','Rotavirus vaccine, oral',5.12);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('T00039','Methadone or buprenorphine/naloxone treatment only',22.46);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00040','Stomach lavage and gavage',25.41);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00043','Anticoagulation therapy by telephone',6.58);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00025','Where no other fee is charged - physician in chamber - 1st ½ hour 77.43',7);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00026','- each additional 15 mins.',39.75);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00027','- physician outside chamber - 1st ½ hour 52.73',5);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00028','- each additional 15 mins.',28.00);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00046','Additional charge to pertinent medical, anesthetic or surgical fee, per hour',26.92);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00050','Enucleation of eye(s) for use in corneal transplant',136.00);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00051','Corneal tissue processing',368.41);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00065','Investigation (with certificate of mental ill health) (fee per doctor)',65.45);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00067','Voluntary committal',29.34);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00081','Emergency care, per ½ hour or major portion thereof',99.61);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P10089','Trauma Team Leader Subsequent Hospital Visit (Days 3 Â 15 inclusive)',77.20);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00044','Mini Tray Fee',4.94);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00700','Bronchoscopy or bronchofibroscopy - procedural fee 87.71',4);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00702','Bronchoscopy with biopsy - procedural fee 134.46',4);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P10700','Endobronchial cautery - extra 75.00',6);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P10702','Endobronchial cryotherapy - extra 75.00',6);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00719','Thoracoscopy 165.47',7);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00701','Direct laryngoscopy - procedural fee 36.97',5);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00717','Micro-laryngoscopy - procedural fee 73.94',5);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('SY00908','- procedure and biopsy 51.88',3);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('SY00909','Flexible fiberoptic nasopharyngolaryngoscopy 38.32',3);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00704','Cystoscopy to include dilation and panendoscopy - procedural fee 93.50',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00708','Gastroscopy - procedural fee 90.49',3);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00711','Gastric biopsy - procedural fee extra 26.58',3);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00709','Oesophagoscopy - procedural fee 73.29',3);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00706','Oesophagoscopy with biopsy 105.56',3);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00707','Oesophagogastroduodenoscopy - procedural fee 86.92',3);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('PSY10750','Transnasal esophagogastroduodenoscopy (TGD), procedural fee',88.00);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('10708','Video capsule endoscopy using M2A capsule - professional fee:',251.70);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('SY00715','Sigmoidoscopy (with biopsy) - procedural fee 35.56',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('SY10714','Proctosigmoidoscopy, rigid; diagnostic 33.57',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('SY00716','Sigmoidoscopy, flexible; diagnostic 62.65',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('SY00718','- with biopsy 75.84',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S10732','- with removal of foreign body 266.82',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00722','Operative arteriography - procedural fee',73.34);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00721','Myelogram - procedural fee 42.08',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00724','Presacral air insufflation - procedural fee 37.30',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00727','Salpingogram - procedural fee 71.57',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00728','Orthodiagram - procedural fee 11.43',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00731','Duodenal biopsy - procedural fee 75.84',3);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00732','Voiding cysto-urethrogram - procedural fee 18.77',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00733','Venogram, intraosseous, or intravenous - procedural fee 56.73',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('-','Surgical component (see Item 08614)',124.69);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('P10739','Endobronchial Ultrasound (EBUS) 250.00',6);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00743','Localizing of non-palpable breast lesion 98.23',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00811','Joint injection, aspiration or arthrogram, under radiological guidance 50.77',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00826','Biopsy of pancreas - percutaneous 80.17',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00857','Percutaneous trans-hepatic cholangiogram (included in S00980) 108.10',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00868','Percutaneous gastrostomy/gastrojejunostomy - procedural fee 263.46',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('10735','Rectal endoscopy utilizing ultrasound (radial/linear)',151.02);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('10740','Upper GI endoscopy utilizing radial ultrasound',251.70);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('10741','Upper GI endoscopy utilizing linear ultrasound',251.70);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00738','Removal of biliary calculi by Burhenne technique 196.17',4);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00746','Reduction of intussusception using hydrostatic pressure, procedural fee 92.83',4);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('ST00921','Varicocele and/or uterine artery embolization  unilateral 385.90',3);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('ST00925','Varicocele and/or uterine artery embolization - bilateral 536.57',3);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00976','Radiological oesophageal dilatation 105.00',3);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00977','Antegrade pyelogram (not billable in conjunction with 00978, 00979) 101.12',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00978','Percutaneous nephrostomy, procedural fee 286.71',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00980','Transhepatic biliary drainage procedure (includes 00857) 405.04',3);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00981','Therapeutic radiological embolization 405.04',3);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00982','Percutaneous transluminal angioplasty 386.09',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00983','Percutaneous abdominal abscess drainage by catheter insertion 263.70',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('ST00989','Extra-corporeal shock wave lithotripsy 130.09',4);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('ST00994','Extra-corporeal shock wave biliary lithotripsy - procedural only 159.10',4);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('10320','Insertion of permanent pleural drainage catheter 200.00',5);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('10321','Removal permanent pleural drainage catheter 67.39',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('10903','Percutaneous hemodialysis graft thrombolysis 558.87',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('10904','Percutaneous transcatheter arterial chemo-embolization (TACE) 561.39',3);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('10906','Image-guided percutaneous vertebroplasty - first level 347.52',4);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('10907','- each additional level (to a maximum of 3) 80.20',4);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('10908','Percutaneous image-guided tumour ablation  first lesion 504.77',3);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('10911','Selective salpingography/fallopian tube recanalization (FTR) 374.25',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('10912','Transjugular liver/renal biopsy 374.25',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('10913','Cerebral arterial balloon occlusion tolerance test 760.56',5);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('10914','Percutaneous balloon angioplasty for cerebral vasospasm 977.53',9);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('10917','Â after 4 hours (extra to 10916)',279.62);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('10919','Intravascular stent placement  extra',123.34);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('10920','Intracorporeal stent placement  extra',123.34);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00739','Percutaneous lung or mediastinal biopsy - procedure fee 88.93',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00740','Liver biopsy - procedural fee 87.75',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00741','Splenic biopsy - procedural fee 87.75',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00742','Renal biopsy - procedural fee 88.93',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00744','Thyroid biopsy - procedural fee 59.52',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00745','Peripheral or subcutaneous lymph node biopsy - procedural fee 12.19',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00747','Prostate biopsy - procedural fee 19.38',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('ST00748','Bone biopsy under local/regional anesthetic',59.75);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00749','Parietal pleural, including thoracentesis - procedural fee 46.02',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00844','Biopsy of salivary gland, fine needle or core needle 52.98',3);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('SY00750','Lumbar puncture - in a patient 13 years of age and over 52.51',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('SY00570','Lumbar puncture in a patient 12 years of age and younger 78.77',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00751','Pericardial puncture - procedural fee 132.00',3);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00752','Cisternal puncture - procedural fee 36.58',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00753','Marrow aspiration - procedural fee 42.50',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00759','Paracentesis - (thoracic) or transtracheal aspiration - procedural fee 21.67',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00760','- (abdominal) - procedural fee 24.64',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00761','Cyst or bursa - procedural fee 13.92',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00762','Scratch test, per antigen',1.05);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00763','- children under 5 years of age, per antigen',2.27);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00764','Intracutaneous test, per test',2.10);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00767','Patch testing (extra) (annual maximum, 70 tests), per test',1.28);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00768','Photopatch test - per test',4.93);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00769','- annual maximum',49.33);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00771','Retinal examination under anesthesia - procedural fee 19.69',3);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00775','Hydrotubation',37.96);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00776','Fetal scalp sampling',37.96);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00782','Needle aspiration of Pouch of Douglas - procedural fee 29.98',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00783','Huhner''s test - procedural fee',37.96);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00784','Cervix punch biopsy - procedural fee 16.10',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00785','Endometrial biopsy - procedural fee 37.96',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00787','Transabdominal amniocentesis 78.90',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00794','Chorionic villus sampling 108.69',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00807','Diagnostic hysteroscopy - not payable in addition to a D&C 105.90',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00808','Diagnostic hysteroscopy with biopsy(s), includes D&C 160.95',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00815','Laparoscopically directed biopsies and/or lysis of adhesions  extra 53.29',4);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('ST00819','Diagnostic vaginoscopy under GA 105.92',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00802','Urethrogram 38.77',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00792','- technical fee 11.94',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00793','- professional fee',5.97);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00799','Transurethral ureterorenoscopy to include C&P 155.07',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00800','Transurethral ureterorenoscopy with x-ray control - C & P included 340.00',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00803','Loopogram',52.07);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00866','Dynamic cavernosometry and cavernosography 77.53',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00878','Cystometry, to include pelvic floor EMG',55.16);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00874','Urethral profilometry (water or gas)',19.38);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00876','Video uro-dynamics (full study), includes S00874, S00875 and S00878',151.19);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00774','Secretion pancreazymin stimulation test',86.88);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00780','Schirmer''s Test (included in fee Item 02015)',12.89);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('SY00789','Peritoneal lavage 84.08',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00797','Oesophageal motility test',134.58);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00788','- technical fee',72.92);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00798','- professional fee',61.66);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00818','Oesophageal pH study for reflux, extra - professional fee',40.04);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00817','- technical fee',12.21);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00804','Bernstein acid perfusion tests',53.99);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00821','- technical fee',26.99);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00820','professional fee',26.99);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00809','Retrograde pancreatography 212.36',3);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00869','Manometry; anal - adult 61.66',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00801','Intra-arterial cannulation - with multiple aspirations - procedural fee',21.67);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00810','Right heart catheterization, by duly qualified specialist 162.26',4);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00812','Selective angiocardiogram, extra, by duly qualified specialist 54.45',4);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00813','Ergonovine provocative testing for coronary artery spasm 77.62',4);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00814','Dye dilution studies, extra, by duly qualified specialist 54.45',4);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00816','Hydrogen ion study 28.40',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00827','Retrograde left heart catheterization, extra, by duly qualified specialist 129.78',4);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00830','Trans-septal left heart catheterization, by duly qualified specialist 223.80',4);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00839','Direct intracoronary streptokinase thrombolysis 353.16',4);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00840','Percutaneous transluminal coronary angioplasty 369.39',4);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00842','- additional site or vessel',185.37);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00871','- intravascular, including both arterial and venous',54.45);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00880','- hepatic vein wedge pressure, by duly qualified specialist',62.71);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00881','- percutaneous splenic portal pressure 50.19',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00898','Balloon septostomy 321.71',7);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00890','- abdominal - procedural fee 110.71',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00892','- carotid percutaneous; unilateral 109.39',3);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00891','- carotid percutaneous; bilateral 164.49',3);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00893','- femoral or axillary 84.70',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00894','- cerebral, by dissection 184.42',3);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00853','Superior venacavogram, by indirect means 23.10',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00854','Inferior venacavogram 110.71',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00856','- others 57.17',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00859','Splenoportogram - by whatever means 98.48',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00896','Pulmonary arteriography 134.38',3);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00885','Digital angiography - peripheral injection 44.75',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('ST00919','Impedance plethysmography - professional component',6.70);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('ST00920','Impedance plethysmography - technical component',33.55);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00845','For first hour or fraction thereof',108.90);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('00846','After one hour, for each 15 minutes or fraction thereof',27.23);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00900','Schedule A - extensive examination (eight or more items)',118.36);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00901','Schedule B - limited examination (four to seven items)',79.16);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00902','Schedule C - short examination (one to three items)',39.45);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00923','Technical fee for electrodiagnostic testing',20.00);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00905','Daily measurements of nerve conduction thresholds in facial palsy',6.22);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00906','- maximum per course',43.31);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00915','Intra-carotid injection of sodium amytal, speech localization test 96.12',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('ST00947','- professional fee',175.12);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('ST00948','- technical fee',109.45);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00910','- professional fee',27.36);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00911','- technical fee',15.32);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('ST11915','Polysomnography, standard  professional fee',164.17);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('ST11916','Polysomnography, standard  technical fee',379.57);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('ST11917','Polysomnography, two-night  professional fee',246.26);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('ST11918','Polysomnography, two-night  technical fee',759.13);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('ST11919','Multiple Sleep Latency Test (MSLT) - professional fee',82.09);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('ST11920','Multiple Sleep Latency Test (MSLT) - technical fee',189.78);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('PS11925','Four channel home polysomnography  Professional fee',82.00);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('PS11926','Four channel home polysomnography  Technical fee',82.25);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00930','Peak expiratory flow rate',5.44);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00931','- professional fee',13.90);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00932','- technical fee',13.90);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00933','- without bronchodilators - professional fee',10.90);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00934','- without bronchodilators - technical fee',10.90);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00935','- before and after bronchodilators - professional fee',12.52);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00936','- before and after bronchodilators - technical fee',13.90);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00937','- without bronchodilators - professional fee',10.90);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00938','- without bronchodilators - technical fee',17.85);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00940','- before and after bronchodilators - professional fee',13.90);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00941','- before and after bronchodilators - technical fee',26.40);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00942','- at rest or exercise - professional fee',14.82);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00943','- technical fee',12.62);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00945','- professional fee (includes S00931, S00935 and S00942)',41.24);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00946','- technical fee (includes S00932, S00936 and S00943)',39.51);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00950','- professional fee',21.67);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00951','- technical fee',31.97);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00954','- professional fee',90.18);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00955','- technical fee',57.93);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00956','- professional fee',107.36);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00957','- technical fee',68.97);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00958','- professional fee',21.91);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00959','- technical fee',32.31);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00964','- professional fee',13.21);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00965','- technical fee',26.40);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00968','- professional fee',35.71);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00969','- technical fee',35.71);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('PSY11964','- professional fee',10.29);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('PSY11965','- technical fee',43.50);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00970','- professional fee',10.90);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00971','- technical fee',26.40);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00972','- professional fee',17.85);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00973','- technical fee',10.90);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00974','- professional fee',12.02);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00975','- technical fee',12.48);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S11961','- technical fee',5.00);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S11963','- technical fee',15.64);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00986','Somatosensory evoked response - upper extremity',36.36);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00987','- upper and lower extremity',62.87);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S00988','Visual evoked response',70.50);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S11200','Arthroscopy shoulder joint 293.02',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('11215','Arthrotomy shoulder joint or bursa 183.13',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S11230','Needle biopsy under GA 183.13',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S11232','Arthroscopy - biopsy, shoulder 238.06',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('11245','Biopsy, open 238.06',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S11300','Arthroscopy elbow joint 263.26',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S11302','Aspiration bursa, tendon sheath. 22.79',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('11315','Arthrotomy elbow joint 183.13',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S11330','Needle biopsy under GA 183.13',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S11332','Arthroscopy and biopsy 290.73',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('11345','Open - biopsy 238.06',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S11400','Arthroscopy wrist joint 282.08',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S11402','Aspiration bursa, synovial sheath, 22.79',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('11415','Arthrotomy wrist joint - isolated procedure 183.13',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S11430','Needle biopsy, under GA 183.13',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S11432','Arthroscopy and biopsy, wrist /hand joint(s) 183.13',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('11445','Open biopsy, hand or wrist 238.06',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S11500','Arthroscopy hip joint 508.19',3);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S11501','Aspiration hip joint 22.79',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S11502','Aspiration bursa, tendon sheath 11.40',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('11515','Arthrotomy hip joint 293.02',3);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S11530','Needle biopsy, under GA 183.13',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S11532','Arthroscopy and biopsy, hip 508.19',3);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('11545','Arthrotomy and biopsy, hip 238.06',3);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('11546','Biopsy open, soft tissue or bone 238.06',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S11600','Arthroscopy knee joint 210.59',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S11602','Aspiration bursa, tendon sheath or other peri-articular structures 22.79',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('11615','Arthrotomy knee joint 238.06',3);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S11630','Needle biopsy, under GA 183.13',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S11632','Arthroscopy - biopsy 210.59',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('11645','Biopsy, open 238.06',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S11700','Arthroscopy ankle joint / subtalar joint 183.13',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S11702','Aspiration bursa, tendon sheath. 22.79',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('11715','Ankle joint, 183.13',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('11716','Subtalar joint 183.13',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('11717','Midtarsal joint 183.13',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('11718','Tarsal-metatarsal, metatarsal-phalangeal, interphalangeal joint. 183.13',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S11730','Needle biopsy, under GA 183.13',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('11745','Open biopsy, under GA 238.06',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S11830','Needle biopsy - soft tissue/bone - thoracic spine, under GA 210.59',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('S11831','Needle biopsy - soft tissue/bone - lumbar spine, under GA 183.13',2);
INSERT INTO Encounter (e_id, e_type, e_price) VALUES ('11845','Biopsy, with GA 238.06',3);
INSERT INTO Patient_Visit (pv_id, pv_e_id, pv_p_id, pv_d_id, pv_t) VALUES(0,'S00764',6059489737,'D764',to_date('2011/04/26:17:19','yyyy/mm/dd:hh24:mi'));
INSERT INTO Patient_Visit (pv_id, pv_e_id, pv_p_id, pv_d_id, pv_t) VALUES(1,'10013',5471254270,'D789',to_date('1986/11/14:13:51','yyyy/mm/dd:hh24:mi'));
INSERT INTO Patient_Visit (pv_id, pv_e_id, pv_p_id, pv_d_id, pv_t) VALUES(2,'00100',1657380225,'D64',to_date('1992/09/26:13:48','yyyy/mm/dd:hh24:mi'));
INSERT INTO Patient_Visit (pv_id, pv_e_id, pv_p_id, pv_d_id, pv_t) VALUES(3,'S00943',1609263795,'D789',to_date('1987/06/07:15:01','yyyy/mm/dd:hh24:mi'));
INSERT INTO Patient_Visit (pv_id, pv_e_id, pv_p_id, pv_d_id, pv_t) VALUES(4,'ST11916',7747495466,'D797',to_date('1978/09/05:10:11','yyyy/mm/dd:hh24:mi'));
INSERT INTO Patient_Visit (pv_id, pv_e_id, pv_p_id, pv_d_id, pv_t) VALUES(5,'00019',5684055069,'D797',to_date('1982/07/19:15:09','yyyy/mm/dd:hh24:mi'));
INSERT INTO Patient_Visit (pv_id, pv_e_id, pv_p_id, pv_d_id, pv_t) VALUES(6,'P13041',3962974606,'D789',to_date('1978/10/04:17:03','yyyy/mm/dd:hh24:mi'));
INSERT INTO Patient_Visit (pv_id, pv_e_id, pv_p_id, pv_d_id, pv_t) VALUES(7,'10920',8614061646,'D64',to_date('1996/10/19:15:42','yyyy/mm/dd:hh24:mi'));