access f

profilepd535402620
yourname_BH_Final_Practice_Version.accdb
Employee_No Ward_No Hours
123.0 100.0 10.0
123.0 200.0 10.0
123.0 300.0 5.0
123.0 600.0 10.0
124.0 100.0 20.0
124.0 300.0 10.0
124.0 600.0 10.0
125.0 100.0 20.0
125.0 400.0 10.0
125.0 600.0 10.0
126.0 100.0 10.0
126.0 500.0 10.0
126.0 600.0 20.0
127.0 100.0 20.0
127.0 600.0 20.0
128.0 100.0 20.0
128.0 600.0 20.0
129.0 100.0 20.0
129.0 600.0 20.0
130.0 100.0 20.0
130.0 600.0 20.0
131.0 100.0 15.0
131.0 600.0 25.0
132.0 200.0 15.0
132.0 600.0 25.0
133.0 200.0 15.0
133.0 500.0 25.0
134.0 200.0 10.0
134.0 500.0 30.0
135.0 200.0 10.0
135.0 500.0 30.0
136.0 200.0 20.0
136.0 500.0 20.0
137.0 200.0 20.0
137.0 500.0 20.0
138.0 200.0 20.0
138.0 500.0 20.0
139.0 200.0 20.0
139.0 500.0 20.0
140.0 200.0 20.0
140.0 500.0 20.0
141.0 200.0 20.0
141.0 500.0 20.0
142.0 200.0 20.0
142.0 400.0 20.0
143.0 300.0 10.0
143.0 400.0 30.0
144.0 300.0 10.0
144.0 400.0 30.0
145.0 300.0 15.0
145.0 400.0 25.0
146.0 300.0 20.0
146.0 400.0 20.0
147.0 300.0 20.0
147.0 400.0 20.0
148.0 300.0 20.0
148.0 400.0 20.0
149.0 300.0 20.0
149.0 400.0 20.0
150.0 300.0 20.0
150.0 400.0 20.0
151.0 300.0 20.0
151.0 400.0 20.0
152.0 300.0 20.0
152.0 400.0 20.0
153.0 300.0 20.0
153.0 400.0 20.0
154.0 300.0 20.0
154.0 400.0 20.0
155.0 300.0 20.0
155.0 400.0 20.0
156.0 300.0 20.0
156.0 400.0 20.0
157.0 300.0 20.0
157.0 400.0 20.0
158.0 300.0 10.0
158.0 400.0 30.0
159.0 300.0 10.0
159.0 400.0 30.0
160.0 300.0 20.0
160.0 400.0 20.0
161.0 300.0 30.0
161.0 400.0 10.0
162.0 300.0 20.0
162.0 400.0 20.0
163.0 300.0 25.0
163.0 500.0 15.0
164.0 300.0 20.0
164.0 500.0 20.0
165.0 300.0 20.0
165.0 500.0 20.0
166.0 200.0 20.0
166.0 500.0 20.0
167.0 200.0 20.0
167.0 500.0 20.0
168.0 200.0 20.0
168.0 500.0 20.0
169.0 200.0 10.0
169.0 500.0 10.0
169.0 600.0 20.0
170.0 200.0 10.0
170.0 500.0 10.0
170.0 600.0 20.0
171.0 200.0 20.0
171.0 500.0 20.0
172.0 200.0 20.0
172.0 500.0 20.0
173.0 100.0 20.0
173.0 600.0 20.0
174.0 100.0 20.0
174.0 600.0 20.0
175.0 100.0 20.0
175.0 600.0 20.0
176.0 100.0 20.0
176.0 600.0 20.0
177.0 100.0 20.0
177.0 600.0 20.0
178.0 100.0 20.0
178.0 600.0 20.0
179.0 100.0 20.0
179.0 600.0 20.0
180.0 100.0 20.0
180.0 600.0 20.0
181.0 100.0 20.0
181.0 600.0 20.0
182.0 100.0 20.0
182.0 600.0 20.0
183.0 100.0 20.0
183.0 600.0 20.0
184.0 100.0 20.0
184.0 600.0 20.0
185.0 100.0 20.0
185.0 600.0 20.0
186.0 100.0 20.0
186.0 600.0 20.0
187.0 100.0 20.0
187.0 600.0 20.0
188.0 200.0 20.0
188.0 600.0 20.0
189.0 200.0 20.0
189.0 600.0 20.0
190.0 200.0 20.0
190.0 600.0 20.0
191.0 200.0 20.0
191.0 500.0 20.0
192.0 200.0 20.0
192.0 500.0 20.0
193.0 300.0 20.0
193.0 500.0 20.0
194.0 300.0 20.0
194.0 500.0 20.0
195.0 300.0 20.0
195.0 500.0 20.0
196.0 300.0 20.0
196.0 400.0 20.0
197.0 300.0 20.0
197.0 400.0 20.0
198.0 300.0 20.0
198.0 400.0 20.0
199.0 300.0 20.0
199.0 400.0 20.0
200.0 300.0 20.0
200.0 400.0 20.0
201.0 300.0 20.0
201.0 400.0 20.0
202.0 200.0 20.0
202.0 400.0 20.0
203.0 200.0 20.0
203.0 500.0 20.0
204.0 200.0 5.0
204.0 500.0 35.0
205.0 200.0 20.0
205.0 500.0 20.0
206.0 200.0 10.0
206.0 500.0 30.0
207.0 200.0 20.0
207.0 600.0 20.0
208.0 100.0 11.0
208.0 600.0 29.0
209.0 100.0 20.0
209.0 600.0 20.0
210.0 100.0 10.0
210.0 600.0 30.0
211.0 100.0 20.0
211.0 600.0 20.0
212.0 100.0 20.0
212.0 600.0 20.0
213.0 200.0 10.0
213.0 400.0 10.0
213.0 600.0 15.0
Bed_No Ward_No Room_No Patient_ID
2.0 100.0 1.0 1016.0
3.0 100.0 2.0
4.0 100.0 2.0 1097.0
5.0 100.0 3.0 1052.0
6.0 100.0 3.0
7.0 100.0 4.0 1001.0
8.0 100.0 4.0 1092.0
9.0 100.0 5.0
10.0 100.0 5.0
11.0 100.0 6.0 1056.0
12.0 100.0 6.0 1067.0
13.0 100.0 7.0 1033.0
14.0 100.0 7.0 1031.0
15.0 100.0 8.0 1086.0
16.0 100.0 8.0 1083.0
17.0 100.0 9.0 1011.0
18.0 100.0 9.0
19.0 100.0 10.0
20.0 100.0 10.0 1089.0
21.0 200.0 1.0 1018.0
22.0 200.0 1.0
23.0 200.0 2.0 1015.0
24.0 200.0 2.0
25.0 200.0 3.0
26.0 200.0 3.0
27.0 200.0 4.0
28.0 200.0 4.0 1044.0
29.0 200.0 5.0 1071.0
30.0 200.0 5.0 1052.0
31.0 200.0 6.0
32.0 200.0 6.0 1081.0
33.0 200.0 7.0 1043.0
34.0 200.0 7.0 1073.0
35.0 200.0 8.0
36.0 200.0 8.0
37.0 200.0 9.0 1064.0
38.0 200.0 9.0 1025.0
39.0 200.0 10.0 1040.0
40.0 200.0 10.0
41.0 300.0 1.0 1007.0
42.0 300.0 1.0
43.0 300.0 2.0 1079.0
44.0 300.0 2.0
45.0 300.0 3.0 1046.0
46.0 300.0 3.0 1019.0
47.0 300.0 4.0 1047.0
48.0 300.0 4.0
49.0 300.0 5.0 1091.0
50.0 300.0 5.0 1096.0
51.0 300.0 6.0 1006.0
52.0 300.0 6.0 1036.0
53.0 300.0 7.0
54.0 300.0 7.0 1038.0
55.0 300.0 8.0
56.0 300.0 8.0
57.0 300.0 9.0
58.0 300.0 9.0 1022.0
59.0 300.0 10.0
60.0 300.0 10.0 1013.0
61.0 400.0 1.0 1029.0
62.0 400.0 1.0 1070.0
63.0 400.0 2.0
64.0 400.0 2.0
65.0 400.0 3.0 1088.0
66.0 400.0 3.0
67.0 400.0 4.0
68.0 400.0 4.0 1075.0
69.0 400.0 5.0
70.0 400.0 5.0
71.0 400.0 6.0 1004.0
72.0 400.0 6.0 1001.0
73.0 400.0 7.0 1028.0
74.0 400.0 7.0
75.0 400.0 8.0 1023.0
76.0 400.0 8.0 1045.0
77.0 400.0 9.0
78.0 400.0 9.0
79.0 400.0 10.0
80.0 400.0 10.0
81.0 500.0 1.0 1078.0
82.0 500.0 2.0 1020.0
83.0 500.0 3.0
84.0 500.0 4.0
85.0 500.0 5.0
86.0 500.0 6.0
87.0 500.0 7.0
88.0 500.0 8.0 1060.0
89.0 500.0 9.0
90.0 500.0 10.0
91.0 600.0 1.0
92.0 600.0 2.0 1094.0
93.0 600.0 3.0
94.0 600.0 4.0
95.0 600.0 5.0 1021.0
96.0 600.0 6.0
97.0 600.0 7.0 1084.0
98.0 600.0 8.0
99.0 600.0 9.0
100.0 600.0 10.0 1048.0
150.0 100.0 1.0 1050.0
182.0 200.0 5.0 1016.0
200.0 1015.0
Patient_ID Item_ID Date Quantity
1001.0 601.0 1/1/04 1.0
1001.0 601.0 2/2/22 2.0
1001.0 606.0 3/31/04 6.0
1001.0 804.0 2/27/04 2.0
1001.0 804.0 3/14/04 4.0
1001.0 905.0 3/13/04 4.0
1002.0 502.0 4/1/04 6.0
1003.0 613.0 5/1/04 3.0
1003.0 706.0 1/29/04 5.0
1003.0 921.0 4/30/04 3.0
1004.0 503.0 3/15/04 4.0
1004.0 613.0 2/28/04 2.0
1004.0 911.0 5/2/04 3.0
1004.0 913.0 5/3/04 3.0
1004.0 922.0 1/30/04 5.0
1005.0 509.0 1/1/04 3.0
1005.0 607.0 1/2/04 1.0
1005.0 614.0 1/31/04 5.0
1005.0 702.0 1/2/04 3.0
1005.0 905.0 1/3/04 1.0
1006.0 602.0 4/2/04 6.0
1006.0 615.0 1/4/04 1.0
1007.0 606.0 1/3/04 3.0
1007.0 612.0 2/29/04 2.0
1008.0 617.0 1/4/04 3.0
1008.0 901.0 1/5/04 1.0
1008.0 904.0 4/3/04 6.0
1009.0 502.0 4/4/04 6.0
1009.0 613.0 3/1/04 2.0
1009.0 806.0 3/16/04 4.0
1010.0 600.0 1/5/04 3.0
1010.0 601.0 3/4/04 2.0
1010.0 609.0 3/2/04 2.0
1010.0 614.0 4/5/04 6.0
1010.0 702.0 3/17/04 3.0
1010.0 908.0 3/3/04 2.0
1011.0 503.0 3/19/04 4.0
1011.0 505.0 1/6/04 1.0
1011.0 508.0 1/6/04 3.0
1011.0 617.0 4/6/04 6.0
1011.0 802.0 3/18/04 4.0
1012.0 610.0 2/1/04 5.0
1012.0 807.0 3/5/04 2.0
1012.0 912.0 3/20/04 4.0
1013.0 506.0 4/7/04 6.0
1013.0 605.0 1/8/04 3.0
1013.0 607.0 3/21/04 4.0
1013.0 805.0 1/7/04 3.0
1013.0 906.0 1/7/04 1.0
1014.0 503.0 1/9/04 3.0
1014.0 507.0 2/2/04 5.0
1014.0 509.0 3/23/04 4.0
1014.0 801.0 3/22/04 4.0
1015.0 504.0 3/6/04 2.0
1015.0 506.0 1/8/04 1.0
1015.0 804.0 3/24/04 4.0
1015.0 909.0 1/10/04 3.0
1015.0 910.0 3/25/04 4.0
1015.0 921.0 1/11/04 3.0
1015.0 922.0 3/26/04 4.0
1016.0 605.0 3/29/04 4.0
1016.0 612.0 1/9/04 1.0
1016.0 702.0 3/28/04 4.0
1016.0 705.0 3/7/04 2.0
1016.0 806.0 1/12/04 3.0
1016.0 907.0 3/27/04 4.0
1017.0 606.0 1/13/04 3.0
1017.0 906.0 3/8/04 2.0
1017.0 918.0 4/8/04 6.0
1018.0 608.0 2/3/04 5.0
1018.0 910.0 3/9/04 2.0
1018.0 912.0 4/9/04 6.0
1019.0 506.0 1/11/04 1.0
1019.0 602.0 2/4/04 5.0
1019.0 616.0 3/10/04 2.0
1019.0 616.0 3/30/04 4.0
1019.0 914.0 1/10/04 1.0
1020.0 608.0 3/31/04 4.0
1020.0 704.0 4/11/04 6.0
1020.0 905.0 4/10/04 6.0
1020.0 914.0 4/1/04 4.0
1021.0 502.0 3/11/04 2.0
1021.0 600.0 1/12/04 1.0
1021.0 703.0 2/5/04 5.0
1021.0 802.0 4/13/04 6.0
1021.0 908.0 4/12/04 6.0
1022.0 604.0 1/13/04 1.0
1022.0 701.0 3/12/04 2.0
1022.0 805.0 2/6/04 5.0
1022.0 915.0 4/2/04 4.0
1023.0 505.0 1/14/04 3.0
1023.0 507.0 4/3/04 4.0
1023.0 909.0 4/4/04 4.0
1023.0 917.0 1/14/04 1.0
1024.0 509.0 1/15/04 1.0
1024.0 602.0 4/5/04 4.0
1025.0 908.0 1/15/04 3.0
1025.0 916.0 2/7/04 5.0
1026.0 509.0 4/14/04 6.0
1026.0 612.0 2/8/04 5.0
1026.0 612.0 3/13/04 2.0
1027.0 602.0 4/16/04 6.0
1027.0 612.0 4/6/04 4.0
1027.0 614.0 4/15/04 6.0
1027.0 805.0 1/16/04 1.0
1028.0 507.0 4/18/04 6.0
1028.0 602.0 1/17/04 1.0
1028.0 701.0 1/18/04 1.0
1028.0 706.0 4/17/04 6.0
1028.0 805.0 1/16/04 3.0
1028.0 903.0 4/7/04 4.0
1028.0 908.0 2/9/04 5.0
1028.0 910.0 4/9/04 4.0
1028.0 913.0 3/14/04 2.0
1028.0 914.0 4/8/04 4.0
1029.0 502.0 2/10/04 5.0
1030.0 504.0 1/19/04 1.0
1030.0 601.0 4/19/04 6.0
1030.0 904.0 2/11/04 5.0
1030.0 904.0 4/10/04 4.0
1031.0 610.0 4/11/04 4.0
1031.0 705.0 2/12/04 5.0
1032.0 504.0 4/12/04 4.0
1032.0 507.0 4/13/04 4.0
1032.0 607.0 1/17/04 3.0
1032.0 913.0 4/20/04 6.0
1032.0 916.0 1/18/04 3.0
1033.0 501.0 4/17/04 4.0
1033.0 509.0 4/15/04 4.0
1033.0 609.0 1/20/04 1.0
1033.0 611.0 1/19/04 3.0
1033.0 614.0 3/15/04 2.0
1033.0 703.0 4/16/04 4.0
1033.0 901.0 4/14/04 4.0
1034.0 610.0 4/21/04 6.0
1034.0 611.0 4/18/04 4.0
1034.0 615.0 1/21/04 3.0
1034.0 702.0 2/13/04 5.0
1034.0 922.0 1/20/04 3.0
1035.0 610.0 1/22/04 3.0
1035.0 612.0 4/22/04 6.0
1035.0 613.0 4/23/04 6.0
1035.0 705.0 2/14/04 5.0
1035.0 902.0 4/20/04 4.0
1035.0 904.0 3/16/04 2.0
1035.0 920.0 4/19/04 4.0
1036.0 604.0 1/25/04 3.0
1036.0 912.0 1/23/04 3.0
1036.0 915.0 4/21/04 4.0
1036.0 919.0 1/24/04 3.0
1037.0 607.0 1/26/04 3.0
1037.0 901.0 1/21/04 1.0
1037.0 919.0 3/17/04 2.0
1037.0 920.0 4/24/04 6.0
1038.0 905.0 3/18/04 2.0
1039.0 902.0 1/27/04 3.0
1039.0 908.0 4/22/04 4.0
1040.0 501.0 1/23/04 1.0
1040.0 617.0 4/25/04 6.0
1040.0 801.0 1/22/04 1.0
1040.0 919.0 4/24/04 4.0
1040.0 921.0 4/23/04 4.0
1041.0 501.0 1/28/04 3.0
1041.0 607.0 1/29/04 3.0
1041.0 903.0 1/30/04 3.0
1041.0 905.0 4/25/04 4.0
1041.0 910.0 4/26/04 6.0
1041.0 918.0 1/31/04 3.0
1042.0 612.0 2/15/04 5.0
1042.0 917.0 4/26/04 4.0
1042.0 918.0 2/16/04 5.0
1042.0 920.0 1/24/04 1.0
1043.0 508.0 4/28/04 4.0
1043.0 600.0 2/17/04 5.0
1043.0 613.0 4/27/04 4.0
1043.0 902.0 1/25/04 1.0
1044.0 703.0 4/29/04 4.0
1044.0 907.0 2/18/04 5.0
1045.0 617.0 4/27/04 6.0
1046.0 506.0 2/1/04 3.0
1046.0 605.0 3/19/04 2.0
1046.0 915.0 2/2/04 3.0
1047.0 611.0 1/26/04 1.0
1047.0 704.0 2/3/04 3.0
1047.0 901.0 3/20/04 2.0
1047.0 910.0 4/28/04 6.0
1048.0 501.0 4/29/04 6.0
1048.0 503.0 3/21/04 2.0
1048.0 902.0 1/27/04 1.0
1049.0 609.0 5/1/04 6.0
1049.0 701.0 4/30/04 6.0
1050.0 611.0 1/28/04 1.0
1050.0 613.0 4/30/04 4.0
1050.0 807.0 3/22/04 2.0
1051.0 505.0 2/4/04 3.0
1051.0 611.0 5/1/04 4.0
1051.0 614.0 5/2/04 4.0
1051.0 616.0 2/5/04 3.0
1051.0 807.0 5/2/04 6.0
1051.0 901.0 1/30/04 1.0
1051.0 913.0 1/29/04 1.0
1052.0 604.0 2/6/04 3.0
1052.0 903.0 3/23/04 2.0
1052.0 919.0 1/31/04 1.0
1053.0 804.0 5/3/04 4.0
1053.0 916.0 2/7/04 3.0
1054.0 509.0 5/3/04 6.0
1054.0 608.0 2/8/04 3.0
1055.0 503.0 2/9/04 3.0
1055.0 606.0 3/24/04 2.0
1055.0 920.0 2/10/04 3.0
1056.0 606.0 2/1/04 1.0
1056.0 703.0 2/19/04 5.0
1056.0 916.0 2/2/04 1.0
1057.0 605.0 2/11/04 3.0
1057.0 806.0 2/3/04 1.0
1058.0 503.0 3/25/04 2.0
1058.0 505.0 1/2/04 4.0
1058.0 507.0 2/4/04 1.0
1058.0 609.0 3/26/04 2.0
1058.0 804.0 1/1/04 4.0
1058.0 903.0 2/5/04 1.0
1058.0 904.0 2/20/04 5.0
1059.0 610.0 1/3/04 4.0
1059.0 908.0 1/1/04 6.0
1059.0 921.0 2/21/04 5.0
1060.0 504.0 2/6/04 1.0
1060.0 504.0 2/22/04 5.0
1060.0 504.0 2/23/04 5.0
1060.0 508.0 3/27/04 2.0
1060.0 615.0 1/2/04 6.0
1060.0 615.0 1/3/04 6.0
1060.0 616.0 1/4/04 4.0
1060.0 702.0 3/28/04 2.0
1061.0 601.0 1/4/04 6.0
1061.0 604.0 2/12/04 3.0
1061.0 706.0 2/7/04 1.0
1061.0 706.0 3/29/04 2.0
1061.0 915.0 2/24/04 5.0
1062.0 611.0 3/30/04 2.0
1062.0 704.0 3/31/04 2.0
1062.0 904.0 2/25/04 5.0
1062.0 911.0 1/5/04 4.0
1062.0 914.0 2/13/04 3.0
1063.0 506.0 2/26/04 5.0
1063.0 601.0 4/1/04 2.0
1063.0 604.0 2/8/04 1.0
1063.0 615.0 2/14/04 3.0
1063.0 706.0 4/2/04 2.0
1063.0 902.0 2/16/04 3.0
1063.0 903.0 2/15/04 3.0
1064.0 506.0 2/18/04 3.0
1064.0 607.0 4/3/04 2.0
1064.0 701.0 2/17/04 3.0
1064.0 911.0 2/9/04 1.0
1064.0 916.0 1/6/04 4.0
1064.0 917.0 2/27/04 5.0
1065.0 601.0 2/10/04 1.0
1065.0 601.0 4/4/04 2.0
1065.0 801.0 1/5/04 6.0
1065.0 916.0 1/6/04 6.0
1066.0 509.0 2/29/04 5.0
1066.0 604.0 1/9/04 6.0
1066.0 614.0 1/7/04 6.0
1066.0 804.0 2/28/04 5.0
1066.0 907.0 1/8/04 6.0
1066.0 912.0 1/7/04 4.0
1067.0 501.0 1/10/04 6.0
1067.0 701.0 3/1/04 5.0
1067.0 909.0 2/19/04 3.0
1067.0 922.0 1/8/04 4.0
1068.0 507.0 2/21/04 3.0
1068.0 600.0 3/2/04 5.0
1068.0 608.0 4/5/04 2.0
1068.0 804.0 1/9/04 4.0
1068.0 806.0 2/20/04 3.0
1069.0 505.0 3/4/04 5.0
1069.0 608.0 3/3/04 5.0
1069.0 614.0 1/11/04 6.0
1069.0 704.0 4/6/04 2.0
1069.0 805.0 4/8/04 2.0
1069.0 907.0 4/7/04 2.0
1069.0 912.0 1/12/04 6.0
1070.0 609.0 2/11/04 1.0
1070.0 617.0 1/13/04 6.0
1070.0 913.0 3/5/04 5.0
1071.0 506.0 1/10/04 4.0
1071.0 610.0 1/14/04 6.0
1071.0 801.0 2/12/04 1.0
1071.0 914.0 3/6/04 5.0
1071.0 918.0 4/9/04 2.0
1072.0 606.0 2/22/04 3.0
1072.0 615.0 1/15/04 6.0
1072.0 912.0 3/7/04 5.0
1073.0 608.0 2/23/04 3.0
1073.0 617.0 4/10/04 2.0
1073.0 802.0 3/8/04 5.0
1075.0 704.0 2/24/04 3.0
1075.0 801.0 4/11/04 2.0
1075.0 802.0 2/13/04 1.0
1075.0 806.0 1/11/04 4.0
1075.0 917.0 3/9/04 5.0
1075.0 918.0 3/10/04 5.0
1076.0 701.0 4/12/04 2.0
1076.0 901.0 3/11/04 5.0
1076.0 909.0 4/13/04 2.0
1076.0 922.0 4/14/04 2.0
1077.0 801.0 1/16/04 6.0
1077.0 805.0 4/15/04 2.0
1077.0 905.0 1/12/04 4.0
1077.0 906.0 3/12/04 5.0
1078.0 502.0 3/15/04 5.0
1078.0 503.0 1/17/04 6.0
1078.0 706.0 2/15/04 1.0
1078.0 805.0 3/14/04 5.0
1078.0 906.0 1/13/04 4.0
1078.0 910.0 3/13/04 5.0
1078.0 911.0 2/14/04 1.0
1079.0 508.0 2/25/04 3.0
1079.0 508.0 4/16/04 2.0
1079.0 706.0 2/16/04 1.0
1080.0 501.0 3/18/04 5.0
1080.0 602.0 4/17/04 2.0
1080.0 604.0 4/18/04 2.0
1080.0 616.0 3/17/04 5.0
1080.0 701.0 2/17/04 1.0
1080.0 702.0 3/16/04 5.0
1080.0 807.0 2/26/04 3.0
1080.0 906.0 2/18/04 1.0
1081.0 806.0 1/14/04 4.0
1081.0 903.0 1/18/04 6.0
1081.0 907.0 1/15/04 4.0
1081.0 917.0 4/19/04 2.0
1081.0 919.0 3/19/04 5.0
1082.0 703.0 1/16/04 4.0
1082.0 913.0 1/19/04 6.0
1083.0 508.0 1/18/04 4.0
1083.0 613.0 2/19/04 1.0
1083.0 705.0 1/17/04 4.0
1083.0 919.0 2/27/04 3.0
1083.0 921.0 1/20/04 6.0
1084.0 504.0 2/28/04 3.0
1084.0 915.0 4/20/04 2.0
1085.0 600.0 3/20/04 5.0
1085.0 609.0 3/1/04 3.0
1085.0 702.0 2/29/04 3.0
1085.0 907.0 3/21/04 5.0
1085.0 911.0 3/2/04 3.0
1085.0 918.0 3/3/04 3.0
1086.0 505.0 2/20/04 1.0
1086.0 505.0 4/23/04 2.0
1086.0 611.0 4/21/04 2.0
1086.0 617.0 3/4/04 3.0
1086.0 703.0 4/22/04 2.0
1087.0 704.0 1/19/04 4.0
1088.0 605.0 4/24/04 2.0
1088.0 610.0 3/6/04 3.0
1088.0 616.0 1/20/04 4.0
1088.0 807.0 1/21/04 4.0
1088.0 911.0 3/5/04 3.0
1089.0 615.0 1/22/04 4.0
1089.0 921.0 3/22/04 5.0
1090.0 909.0 1/21/04 6.0
1090.0 920.0 3/7/04 3.0
1090.0 922.0 2/21/04 1.0
1091.0 501.0 3/24/04 5.0
1091.0 605.0 1/24/04 4.0
1091.0 703.0 2/22/04 1.0
1091.0 802.0 3/8/04 3.0
1091.0 902.0 3/23/04 5.0
1091.0 914.0 1/23/04 4.0
1091.0 915.0 1/25/04 4.0
1092.0 502.0 3/25/04 5.0
1092.0 606.0 3/9/04 3.0
1092.0 705.0 2/23/04 1.0
1092.0 906.0 3/26/04 5.0
1093.0 705.0 3/27/04 5.0
1093.0 802.0 2/24/04 1.0
1094.0 607.0 4/25/04 2.0
1094.0 705.0 2/25/04 1.0
1094.0 917.0 1/22/04 6.0
1094.0 920.0 3/10/04 3.0
1095.0 602.0 3/11/04 3.0
1095.0 609.0 4/26/04 2.0
1095.0 704.0 2/26/04 1.0
1095.0 802.0 1/27/04 4.0
1095.0 807.0 1/26/04 4.0
1096.0 909.0 1/23/04 6.0
1097.0 600.0 3/12/04 3.0
1097.0 605.0 1/24/04 6.0
1097.0 608.0 1/25/04 6.0
1097.0 616.0 1/28/04 4.0
1097.0 801.0 4/27/04 2.0
1097.0 807.0 1/26/04 6.0
1098.0 508.0 3/28/04 5.0
1098.0 806.0 4/29/04 2.0
1098.0 901.0 4/28/04 2.0
1099.0 502.0 1/27/04 6.0
1099.0 507.0 3/29/04 5.0
1099.0 600.0 3/30/04 5.0
1099.0 902.0 1/28/04 6.0
Employee_No Employee_Name
123.0 Maria Anders
124.0 Ana Trujillo
125.0 Antonio Moreno
126.0 Thomas Hardy
127.0 Christina Berglund
128.0 Hanna Moos
129.0 Frédérique Citeaux
130.0 Martín Sommer
131.0 Laurence Lebihan
132.0 Elizabeth Lincoln
133.0 Victoria Ashworth
134.0 Patricio Simpson
135.0 Francisco Chang
136.0 Yang Wang
137.0 Pedro Afonso
138.0 Elizabeth Brown
139.0 Sven Ottlieb
140.0 Janine Labrune
141.0 Ann Devon
142.0 Roland Mendel
143.0 Aria Cruz
144.0 Diego Roel
145.0 Martine Rancé
146.0 Maria Larsson
147.0 Peter Franken
148.0 Carine Schmitt
149.0 Paolo Accorti
150.0 Lino Rodriguez
151.0 Eduardo Saavedra
152.0 José Pedro Freyre
153.0 André Fonseca
154.0 Howard Snyder
155.0 Manuel Pereira
156.0 Mario Pontes
157.0 Carlos Hernández
158.0 Yoshi Latimer
159.0 Patricia McKenna
160.0 Helen Bennett
161.0 Philip Cramer
162.0 Daniel Tonini
163.0 Annette Roulet
164.0 Yoshi Tannamuri
165.0 John Steel
166.0 Renate Messner
167.0 Jaime Yorres
168.0 Carlos González
169.0 Felipe Izquierdo
170.0 Fran Wilson
171.0 Giovanni Rovelli
172.0 Catherine Dewey
173.0 Jean Fresnière
174.0 Alexander Feuer
175.0 Simon Crowther
176.0 Yvonne Moncada
177.0 Rene Phillips
178.0 Henriette Pfalzheim
179.0 Marie Bertrand
180.0 Guillermo Fernández
181.0 Georg Pipps
182.0 Isabel de Castro
183.0 Bernardo Batista
184.0 Lúcia Carvalho
185.0 Horst Kloss
186.0 Sergio Gutiérrez
187.0 Paula Wilson
188.0 Maurizio Moroni
189.0 Janete Limeira
190.0 Michael Holz
191.0 Alejandra Camino
192.0 Jonas Bergulfsen
193.0 Jose Pavarotti
194.0 Hari Kumar
195.0 Jytte Petersen
196.0 Dominique Perrier
197.0 Art Braunschweiger
198.0 Pascale Cartrain
199.0 Liz Nixon
200.0 Liu Wong
201.0 Karin Josephs
202.0 Miguel Angel Paolino
203.0 Anabela Domingues
204.0 Helvetius Nagy
205.0 Palle Ibsen
206.0 Mary Saveley
207.0 Paul Henriot
208.0 Rita Müller
209.0 Pirkko Koskitalo
210.0 Paula Parente
211.0 Karl Jablonski
212.0 Matti Karttunen
213.0 Zbyszek Piestrzeniewicz
Item_ID Description Unit_Cost
501.0 Inflatable Air Splint Leg 32" ¤ 12.00
502.0 Inflatable Air Splint Leg 25" ¤ 11.00
503.0 Inflatable Air Splint Arm 32" ¤ 9.00
504.0 Inflatable Air Splint Arm 25" ¤ 8.00
505.0 Inflatable Air Splint Hand and Wrist ¤ 9.00
506.0 Inflatable Air Splint Ankle and Foot ¤ 9.00
507.0 Cast Boot Large ¤ 19.00
508.0 Cast Boot Small ¤ 18.00
509.0 Stiffneck Collar ¤ 30.00
600.0 Ultrasound Lotion ¤ 1.25
601.0 UltraSound Gel ¤ 1.00
602.0 Ammonia Inhalant ¤ 3.00
604.0 Burn Relief Spray ¤ 12.00
605.0 Burn sheets 60"x96" ¤ 8.00
606.0 Oxygen face Mask w/valve ¤ 27.00
607.0 Micro face Mask ¤ 6.00
608.0 Eyewash Bottle ¤ 8.00
609.0 Soote-A-Sting swab ¤ 3.00
610.0 Insect Sting Wipe ¤ 2.50
611.0 Poison Antidote Kit ¤ 12.00
612.0 OB Kit ¤ 6.00
613.0 Resuscitator Bag Mask Adult ¤ 30.00
614.0 Resuscitator Bag Mask Child ¤ 29.00
615.0 Tracheotamy Kit ¤ 40.00
616.0 IV Sodium Clorine ¤ 3.00
617.0 IV Sterile Water ¤ 2.00
701.0 Chemical Strips #135 Luc.,Gluc.,Prot,Bld ¤ 1.00
702.0 Chemical Strips #145 Luc.,Gluc.,Prot,Bld.,N, Urin. ¤ 1.50
703.0 LabStix-urinary blood, ketones, glucose, protein and pH ¤ 1.25
704.0 Multi Stix-pH, protein, glucose, ketones, bilirubin, blood and urobilinogen in urine ¤ 2.00
705.0 Multi Stix glucose, bilirubin, ketones, specific gravity,glood, pH, protein, nitrate and leukocytes in urine ¤ 3.00
706.0 Uristix ¤ 1.50
801.0 Insta-Glucose tube 31 gram ¤ 6.00
802.0 Insulin Syrenge bx/100 monojet 27 gauge ¤ 17.00
804.0 Insulin Travel Kit ¤ 26.00
805.0 Lancets bx/100 ¤ 7.00
806.0 Diabetis Socks ¤ 5.00
807.0 Diabetic Gloves ¤ 7.00
901.0 Bed Pan diposable ¤ 7.00
902.0 Bed Tray ¤ 17.00
903.0 Emesis Basin Disposable ¤ 1.00
904.0 Hair Comb ¤ 3.00
905.0 Hair Brush ¤ 5.00
906.0 Toothbrush ¤ 3.00
907.0 Nail Clippers ¤ 5.00
908.0 Sitz Bath Disposable ¤ 7.00
909.0 Female Urinal Disposable ¤ 6.00
910.0 Male Urinal Disposable ¤ 2.00
911.0 Wash Basin Disposable ¤ 2.00
912.0 Hand bulb syringe ¤ 7.00
913.0 Wool Blanket ¤ 24.00
914.0 Emergency Foam Blanket ¤ 14.00
915.0 Bite Stick ¤ 4.00
916.0 Tournicate Velcro ¤ 8.00
917.0 Tournicate Latex Disposable ¤ 2.00
918.0 Male Briefs Disposable ¤ 1.00
919.0 Female Briefs Disposable ¤ 1.00
920.0 Telephone ¤ 20.00
921.0 Television ¤ 20.00
922.0 Computer ¤ 20.00
923.0 Sarah stuff ¤ 0.00
Patient_ID Patient_First_Name Patient_Last_Name Physician_ID Patient_Street_Address P_City P_State P_Zip_Code P_Insurance
1001.0 Patricia Agbetsiafa 1.0 224 North Sunnyside South Bend IN 46617.0 Blue Cross/Blue Sheid
1002.0 Adarsh Anderson 2.0 44 1st Street Bloomington IN 47403.0 Cigna
1003.0 Eric Anderson 3.0 23098 Dallas Bloomington IN 47403.0 Cigna
1004.0 Catherine Andrew 4.0 4289 Plymouth Ellettsville IN 47429.0 CNA HealthPro
1005.0 Larry Andrews 5.0 62014 Pine Bloomington IN 47403.0 Cigna
1006.0 Anna Beebe 6.0 24290 Gerencser Drive South Bend IN 46614.0 Blue Cross/Blue Sheid
1007.0 Marilynn Bishop 7.0 51711 Waterford Lane Granger IN 46530.0 Blue Cross/Blue Sheid
1008.0 Laura Bontrager 8.0 2640 Sylvan Lane Bloomington IN 47403.0 Aetna
1009.0 Stephanie Brooks 9.0 362 Oak Bloomington IN 47403.0 Cigna
1010.0 Steven Buchanan 10.0 14 Garrett Hill London OH 47402.0 Activa
1011.0 Thomas Byers 11.0 18312 Westover Drive South Bend IN 46637.0 Blue Cross/Blue Sheid
1012.0 Maren Caldwell 12.0 Street Bloomington IN 47403.0 Cigna
1013.0 Laura Callahan 13.0 4726 - 11th Ave. N.E. Seattle WA 98105.0 Activa
1014.0 Ellen Casper 14.0 412 Roosevelt Martinsville IN 46151.0 None
1015.0 Kyle Coulter 15.0 915 Meadow Lane Bloomington IN 48408.0 CNA HealthPro
1016.0 Belvia Cryer 16.0 P.O. Box 420 Bloomington IN 47403.0 Aetna
1017.0 Valerie Daniels 17.0 P.o. Box 442 Bloomington IN 47405.0 Cigna
1018.0 Sharmili Davis 18.0 4429 Fee Bloomington IN 47405.0 Cigna
1019.0 Nancy Davolio 19.0 507 - 20th Ave. E. Apt. 2A Seattle WA 98122.0 Activa
1020.0 Anne Dodsworth 20.0 7 Houndstooth Rd. London OH 47402.0 Activa
1021.0 Nichk Elliott 21.0 2008 Rogers Bloomington IN 47403.0 Cigna
1022.0 John Emmerson 1.0 894 Law Bloomington IN 47405.0 Cigna
1023.0 Patricia Evans 2.0 406 N Gernhart Mishawaka IN 46544.0 Activa
1024.0 Daniel Fenk 3.0 898 Lawson Bloomington IN 47405.0 Cigna
1025.0 Andrew Fuller 4.0 908 W. Capital Way Tacoma WA 98401.0 Activa
1026.0 Shirley Fulton 5.0 1628 South Carlisle South Bend IN 46613.0 Activa
1027.0 John Gibbs 6.0 6200 Pennsylvania Bloomington IN 48408.0 Cigna
1028.0 Matthew Gibson 7.0 812 8th Street Bloomington IN 48408.0 Cigna
1029.0 Sherry Graham 8.0 98032 Maple Bloomington IN 48408.0 CNA HealthPro
1030.0 Darrell Gunn 9.0 72983 State Road 23 Walkerton IN 46574.0 Activa
1031.0 Mark Halasz 10.0 20800 Kern Road South Bend IN 46614.0 Blue Cross/Blue Sheid
1032.0 Shirley Hamilton 11.0 1602 1st Street Bloomington IN 48408.0 CNA HealthPro
1033.0 Adam Hart 12.0 2601 Park Street Bloomington IN 48408.0 CNA HealthPro
1034.0 Joseph Helmuth 13.0 519 Clover Bloomington IN 47403.0 Cigna
1035.0 David Henley 14.0 410 Park Avenue Mishawaka IN 46545.0 Blue Cross/Blue Sheid
1036.0 Morgan Isban 15.0 1062 Walnut Bloomington IN 48408.0 CNA HealthPro
1037.0 Cheryl Isiah 16.0 6021 Main Street Bloomington IN 48408.0 CNA HealthPro
1038.0 andrew Jackson 17.0 2602 Cedar Bloomington IN 48408.0 CNA HealthPro
1039.0 Christopher Jackson 18.0 P.O. Box 4622 Ellettsville IN 47429.0 CNA HealthPro
1040.0 Kay Jacobs 19.0 420 Roosevelt Ellettsville IN 47429.0 Lincoln
1041.0 Daniel James 20.0 3512 Oaklawn Ellettsville IN 47429.0 Medicaid
1042.0 Sean James 21.0 114 Cedar Bloomington IN 47405.0 Cigna
1043.0 Nellie Jamison 1.0 1255 Fenbrook Ellettsville IN 47429.0 Medicaid
1044.0 Timothy Janowczyk 2.0 15358 Kerlin Drive Granger IN 46530.0 Blue Cross/Blue Sheid
1045.0 Jennifer Jones 3.0 1500 North Walnut Ellettsville IN 47429.0 Lincoln
1046.0 Kenneth Jones 4.0 871 Woodbridge Ellettsville IN 47429.0 Lincoln
1047.0 Mary Jones 5.0 3103 Arcadia Ellettsville IN 47429.0 Lincoln
1048.0 Karen Kellog 6.0 2308 Brendon Ellettsville IN 47429.0 Lincoln
1049.0 Joseph Kelter 7.0 910 Adams Ellettsville IN 47429.0 Lincoln
1050.0 Sean Kennons 8.0 8920 Jefferson Ellettsville IN 47429.0 Medicaid
1051.0 Robert King 9.0 Edgeham Hollow Winchester Way London OH 47402.0 Activa
1052.0 Matt Koorsen 10.0 2489 Sale Bloomington IN 47405.0 Cigna
1053.0 Phu Koorsen 11.0 984 Briar Bloomington IN 47405.0 Cigna
1054.0 Karl Kopec 12.0 50585 Dusty Trail Court Granger IN 46530.0 Blue Cross/Blue Sheid
1055.0 Janet Leverling 13.0 722 Moss Bay Blvd. Kirkland WA 98033.0 Activa
1056.0 Anatol Lucenko 14.0 919 Washington Avenue Mishawaka IN 46544.0 Activa
1057.0 Dustin Macy 15.0 4022 Gennessee Bloomington IN 47403.0 Activa
1058.0 Michael Marker 16.0 1846 Stone Maple Martinsville IN 46151.0 None
1059.0 Shannon Marks 17.0 55332 Liberty Drive Osceola IN 46561.0 Blue Cross/Blue Sheid
1060.0 Mark Martin 18.0 409 N. Park Martinsville IN 46151.0 None
1061.0 Stanley Martin 19.0 16852 Smith Martinsville IN 46151.0 None
1062.0 Bobby Mason 20.0 729 Warsaw Bloomington IN 47403.0 Activa
1063.0 Ken Mason 21.0 644 Sample Bloomington IN 47403.0 Cigna
1064.0 Samual Mason 1.0 3400 S. Sare Ellettsville IN 47429.0 Lincoln
1065.0 Evan Mathers 2.0 421 E. 3rd Street Martinsville IN 46151.0 None
1066.0 Jonathan Mayes 3.0 981 13th Street Ellettsville IN 47429.0 Medicaid
1067.0 Michael Mertuth 4.0 198 Walter Ellettsville IN 47429.0 Medicaid
1068.0 Katie Miller 5.0 318 Tillman Bloomington IN 47403.0 Activa
1069.0 Kristin Miller 6.0 8261 U.S. 20 Bloomington IN 47403.0 Activa
1070.0 Nicholas Molchan 7.0 4401 Irish Hills Drive #2-D South Bend IN 46614.0 Blue Cross/Blue Sheid
1071.0 Seth Morgan 8.0 RR #2 Bloomington IN 47403.0 Activa
1072.0 David Myers 9.0 9842 Lark Ellettsville IN 47429.0 CNA HealthPro
1073.0 Mark Myers 10.0 100 E. Miller Ellettsville IN 47429.0 Lincoln
1074.0 Shane Myers 11.0 261 Ester Ellettsville IN 47429.0 Medicaid
1075.0 Marcie Neff 12.0 2211 Churchill Ellettsville IN 47429.0 Medicaid
1076.0 Margaret Peacock 13.0 4110 Old Redmond Rd. Redmond WA 98052.0 Activa
1077.0 Patrick Pingel 14.0 54461 Old Bedford Trail Mishawaka IN 46545.0 Blue Cross/Blue Sheid
1078.0 Regina Plummer 15.0 1527 East Madison Street South Bend IN 46617.0 Blue Cross/Blue Sheid
1079.0 Grace Rodgers 16.0 14394 Shoreline Drive Granger IN 46530.0 Blue Cross/Blue Sheid
1080.0 Aaron Samms 17.0 168 Sharp Ellettsville IN 47429.0 Medicaid
1081.0 Casey Schenk 18.0 3489 S. Oaklawn Circle Ellettsville IN 47429.0 Lincoln
1082.0 Robin Schramm 19.0 4837 Selkirk Drive South Bend IN 46614.0 Blue Cross/Blue Sheid
1083.0 Elizabeth Shannon 20.0 16 West 1st Street Ellettsville IN 47429.0 CNA HealthPro
1084.0 Allen Smith 21.0 509 E. 1th Street Ellettsville IN 47429.0 Medicaid
1085.0 Dustin Smith 1.0 3520 E. Covenanter Ellettsville IN 47429.0 Lincoln
1086.0 Erin Smith 2.0 861 Long Lane Ellettsville IN 47429.0 CNA HealthPro
1087.0 Julie Smith 3.0 9984 Parkway Bloomington IN 47403.0 Aetna
1088.0 Lisa Smith 4.0 P.O. Box 984 Martinsville IN 46151.0 None
1089.0 Shawn Stidham 5.0 126 Rocke Ellettsville IN 47429.0 Medicaid
1090.0 Marta Stone 6.0 21 Grimes Ellettsville IN 47429.0 None
1091.0 Melanie Stone 7.0 8751 Oak Ridger Martinsville IN 46151.0 None
1092.0 Kevin Surine 8.0 P.O. Box 18 Ellettsville IN 47429.0 CNA HealthPro
1093.0 Michael Suyama 9.0 Coventry House Miner Rd. London OH 47402.0 Activa
1094.0 Laura Wagley 10.0 124 East Omer Avenue Mishawaka IN 46545.0 Blue Cross/Blue Sheid
1095.0 Gail Waltman 11.0 20818 Whispering Creek Court South Bend IN 46614.0 Blue Cross/Blue Sheid
1096.0 Margaret Yoder 12.0 2210 Nbent Tree Drive Ellettsville IN 47429.0 Lincoln
1097.0 Pil Yoder 13.0 20 W. Main Bloomington IN 47403.0 Aetna
1098.0 Lisa Young 14.0 4419 Meadow Lane Bloomington IN 47403.0 Aetna
1099.0 Richard Young 15.0 189 1st Street Ellettsville IN 47429.0 Medicaid
1100.0 David Young 16.0 1814 Cedar Bloomington IN 47403.0 Aetna
Physician_ID Physician_Name
1.0 Allen, Richard
2.0 Batty, Lisa
3.0 Crabbush, Ricardo
4.0 Daizon, Amelia
5.0 Egbert, Paul
6.0 Folikal, Jennifer
7.0 Gorky, Elton
8.0 Holestan, Melanie
9.0 Irwin, Fred
10.0 Junish, Alisa
11.0 Koldpepper, Allen
12.0 Lemon, Naomi
13.0 Moonsloth, Grady
14.0 Nokins, Neena
15.0 Optolector, George
16.0 Polp, Percy
17.0 Quarzain, Quint
18.0 Reef, Lindsay
19.0 Serlupty, Sam
20.0 Toother, Tina
21.0 Ulrich, Unser
Treatment_ID Treatment_Name
1.0 Antinuclear Antibody Test
2.0 Appendectomy
3.0 Arthroscopy
4.0 Bone Density Scan
5.0 Bone Marrow Aspiration and Biopsy
6.0 Cat Scan
7.0 Colonoscopy
8.0 Complete Blood Count
9.0 Coronary Angiogram
10.0 Coronary Artery Bypass Graft
11.0 Coronary Artery Diseas Screening Test
12.0 Coronary Balloon Angioplasty
13.0 Cortisone Injection
14.0 Liver Blood Tests
15.0 MRI Scan
16.0 Occult Fecal Blood Test
17.0 Oophorectomy
18.0 Thyroid Blood Tests
19.0 Ultrasound
20.0 Urinalysis
21.0 Vasectomy
Patient_ID Physician_ID Treatment_ID Results Date date_perf
1001.0 1.0 1.0 Neg 3/4/05
1001.0 1.0 8.0 Neg 3/2/05
1002.0 2.0 20.0 Pos 2/1/05
1003.0 3.0 4.0 Pos 10/18/04
1003.0 3.0 15.0 Neg 2/10/04
1003.0 4.0 6.0 Neg 2/12/04
1005.0 6.0 12.0 Neg 12/1/04
1005.0 7.0 11.0 Pos 12/1/04
1006.0 5.0 18.0 Pos 1/6/05
1006.0 6.0 16.0 Pos 1/5/05
1006.0 10.0 20.0 Neg 1/12/05
1008.0 9.0 19.0 Pos 11/10/03
1009.0 8.0 3.0 Neg 11/12/04
1009.0 8.0 4.0 Pos 11/14/04
1009.0 21.0 13.0 Pos 12/14/04
1009.0 21.0 14.0 Pos 12/15/04
1010.0 14.0 10.0 Neg 2/20/05
1010.0 15.0 21.0 Pos 3/9/05
1011.0 12.0 12.0 Neg 2/27/05
1013.0 11.0 17.0 Pos 2/1/05
1014.0 10.0 7.0 Pos 2/2/04
1015.0 18.0 10.0 Neg 7/15/03
1016.0 7.0 21.0 Neg 8/12/04
1016.0 18.0 1.0 Neg 9/15/03
1018.0 17.0 6.0 Pos 10/11/04
1018.0 17.0 20.0 Pos 10/10/04
1019.0 17.0 13.0 Pos 1/10/05
1020.0 16.0 8.0 Pos 3/12/04
1020.0 19.0 9.0 Neg 3/15/04
1020.0 19.0 14.0 Pos 3/16/04
1022.0 1.0 17.0 Neg 6/24/04
1022.0 3.0 15.0 Pos 6/26/04
1022.0 20.0 1.0 Pos 6/19/04
1022.0 21.0 20.0 Neg 6/21/04
1023.0 4.0 13.0 Neg 2/5/03
1024.0 4.0 5.0 Pos 5/10/04
1025.0 7.0 18.0 Pos 3/3/05
1026.0 19.0 20.0 Pos 11/20/04
1026.0 20.0 2.0 Neg 11/20/04
1028.0 13.0 16.0 Pos 12/21/04
1029.0 11.0 4.0 Neg 8/10/03
1029.0 12.0 3.0 Pos 8/9/03
1031.0 5.0 19.0 Pos 1/20/05
1031.0 6.0 21.0 Pos 9/1/04
1032.0 4.0 5.0 Neg 1/21/05
1033.0 21.0 4.0 Neg 10/31/04
1034.0 20.0 10.0 Pos 11/27/04
1035.0 19.0 11.0 Pos 2/12/04
1036.0 5.0 1.0 Pos 3/2/05
1036.0 5.0 17.0 Pos 3/7/05
1036.0 5.0 20.0 Pos 3/3/05
1039.0 6.0 15.0 Neg 12/1/04
1040.0 13.0 12.0 Neg 6/9/04
1040.0 17.0 10.0 Pos 3/3/05
1041.0 20.0 13.0 Pos 4/15/03
1042.0 12.0 1.0 Pos 4/21/04
1043.0 6.0 2.0 Pos 5/10/03
1043.0 11.0 3.0 Neg 1/6/04
1045.0 2.0 9.0 Neg 11/11/04
1047.0 3.0 10.0 Pos 10/12/03
1048.0 3.0 7.0 Pos 7/15/04
1048.0 3.0 11.0 Pos 7/9/04
1048.0 17.0 6.0 Pos 7/13/04
1048.0 19.0 16.0 Pos 7/12/04
1049.0 18.0 21.0 Neg 7/7/04
1050.0 4.0 1.0 Neg 2/20/05
1050.0 6.0 19.0 Pos 8/12/03
1051.0 1.0 2.0 Pos 11/1/04
1052.0 4.0 4.0 Pos 1/17/05
1055.0 3.0 5.0 Neg 1/3/05
1055.0 5.0 6.0 Pos 12/31/04
1056.0 6.0 21.0 Neg 9/2/03
1057.0 12.0 20.0 Pos 5/31/04
1059.0 11.0 17.0 Neg 3/15/05
1059.0 11.0 19.0 Pos 3/5/05
1059.0 13.0 7.0 Pos 10/17/04
1060.0 14.0 8.0 Neg 12/29/03
1062.0 15.0 16.0 Pos 2/20/04
1064.0 10.0 15.0 Pos 7/18/04
1065.0 8.0 9.0 Pos 1/30/05
1065.0 9.0 14.0 Neg 2/1/05
1066.0 16.0 12.0 Pos 10/31/04
1066.0 20.0 9.0 Pos 11/3/04
1067.0 1.0 7.0 Pos 3/1/05
1067.0 14.0 20.0 Pos 2/26/05
1067.0 15.0 1.0 Neg 3/2/05
1070.0 1.0 10.0 Pos 1/7/05
1071.0 7.0 11.0 Pos 10/3/03
1072.0 2.0 11.0 Neg 4/6/04
1073.0 3.0 12.0 Neg 3/4/05
1074.0 4.0 10.0 Pos 6/10/04
1075.0 12.0 7.0 Pos 2/13/05
1075.0 15.0 9.0 Pos 2/15/05
1076.0 9.0 15.0 Pos 1/17/05
1076.0 9.0 18.0 Neg 1/12/05
1077.0 18.0 4.0 Pos 1/21/05
1077.0 18.0 16.0 Pos 1/22/05
1079.0 9.0 3.0 Pos 2/2/05
1080.0 9.0 2.0 Neg 12/24/04
1082.0 12.0 21.0 Pos 8/16/04
1084.0 13.0 20.0 Neg 8/2/04
1085.0 5.0 19.0 Pos 9/19/03
1085.0 6.0 18.0 Neg 9/18/03
1085.0 15.0 3.0 Pos 9/12/03
1087.0 4.0 7.0 Pos 10/10/04
1088.0 11.0 10.0 Pos 10/7/03
1088.0 12.0 6.0 Pos 5/12/03
1089.0 10.0 12.0 Pos 10/31/04
1090.0 13.0 11.0 Neg 7/11/03
1091.0 12.0 9.0 Neg 3/12/04
1092.0 7.0 20.0 Pos 3/19/05
1092.0 15.0 12.0 Pos 3/18/05
1092.0 21.0 14.0 Neg 7/16/04
1092.0 21.0 15.0 Pos 7/12/03
1093.0 19.0 1.0 Pos 11/11/03
1095.0 21.0 4.0 Pos 10/10/04
1096.0 6.0 5.0 Neg 3/6/05
1096.0 10.0 6.0 Pos 3/3/05
1096.0 10.0 13.0 Pos 2/19/04
1097.0 1.0 12.0 Pos 2/20/05
1097.0 11.0 10.0 Neg 2/9/05
1098.0 3.0 9.0 Pos 2/10/05
1100.0 14.0 11.0 Pos 5/20/04
Ward_No Ward_Name Nurse_In_Charge
100.0 Maternity 123.0
200.0 Emergency 132.0
300.0 Burn Unit 124.0
400.0 ICU 125.0
500.0 Geriatric 126.0
600.0 Children 127.0
700.0 Cancer 131.0
SELECT ItemTbl.Item_ID, ItemTbl.Description, ItemTbl.Unit_Cost FROM ItemTbl;
PARAMETERS __Patient_ID Value; SELECT DISTINCTROW * FROM [SELECT [HW6a_qry].Patient_ID, [HW6a_qry].Item_ID, [HW6a_qry].Date, [HW6a_qry].Quantity FROM HW6a_qry; ]. AS hw6a_frm WHERE ([__Patient_ID] = Patient_ID);
PARAMETERS __Patient_ID IEEEDouble; SELECT DISTINCTROW * FROM ConsumesTbl AS Patient_Consumes_Frm_For_class WHERE ([__Patient_ID] = Patient_ID);
SELECT ItemTbl.Item_ID, ItemTbl.Description, ItemTbl.Unit_Cost FROM ItemTbl;
PARAMETERS __Patient_ID Value; SELECT DISTINCTROW * FROM [SELECT ConsumesTbl.Item_ID, ConsumesTbl.Quantity, ItemTbl.Description, ItemTbl.Unit_Cost, ConsumesTbl.Patient_ID FROM ItemTbl INNER JOIN ConsumesTbl ON ItemTbl.Item_ID=ConsumesTbl.Item_ID; ]. AS Patient_frm WHERE ([__Patient_ID] = Patient_ID);