SSN First Name Last Name Phone Extension Date Hired Address Salary Date of Birth Supervisor SSN Department Name
123 Steward Noble 2000 100 Jan. 1, 2018 Matn 100000 Jan. 1, 1990 None Corporate
1243 Melissa Black 3010 315 March 28, 2012 Matn 61000 June 23, 1984 None Customer Service
1234 John Smith 3001 111 May 15, 2018 Matn 60000 March 27, 1987 None Marketing
1235 Sarah Johnson 3002 112 Feb. 20, 2019 Beirut 55000 Jan. 23, 1993 1234 Marketing
1236 Michael Davis 3003 113 Aug. 10, 2020 Beirut 59000 Nov. 17, 1989 1234 Marketing
1237 Emily White 3004 211 Nov. 3, 2017 Hamra 57000 Sept. 13, 1991 1238 Sales
1238 David Anderson 3005 212 April 25, 2021 Beirut 61000 Aug. 26, 1987 None Sales
1239 Lisa Miller 3006 311 Sept. 12, 2016 Hamra 56000 April 23, 1992 1243 Customer Service
1240 Andrew Martinez 3007 312 Jan. 30, 2015 Hamra 60000 May 9, 1988 1243 Customer Service
1241 Jessica Johnson 3008 313 July 19, 2014 Dekwaneh 54000 Feb. 21, 1994 1243 Customer Service
1242 William Brown 3009 314 Dec. 1, 2013 Dekwaneh 53000 July 8, 1995 1243 Customer Service
1244 Daniel Wilson 3011 316 Aug. 5, 2011 Matn 60000 April 30, 1988 1243 Customer Service
1245 Karen Lee 3012 411 May 20, 2010 Sayda 55000 July 13, 1990 1248 Human Resources
1246 Richard Baker 3013 512 Feb. 15, 2009 Sayda 70000 Sept. 21, 1989 None Human Resources
1247 Elise Turner 3014 413 June 10, 2008 Jbeil 57000 Aug. 6, 1988 1246 Administration
1248 James Rodriguez 3015 414 April 5, 2007 Jbeil 61000 April 8, 1987 None Human Resources
Name Extension Floor Number Manager SSN
Finance 600 6 1246
Training 600 6 1246
Customer Service 300 3 1243
Marketing 100 1 1234
Legal 600 6 1246
Administration 500 5 1246
Sales 200 2 1238
IT 600 6 1246
Corporate 101 1 123
Human Resources 400 4 1248
Claims 600 6 1246
Phone Start Date End Date Address Commission Name
4001 March 15, 2022 None Jbeil 5 Alice Reynolds
4002 April 23, 2020 None Matn 6 Samuel Mitchell
4003 Dec. 19, 2021 None Hamra 5 Olivia Anderson
4004 Jan. 26, 2023 None Hamra 4 Ethan Walker
4005 Feb. 3, 2023 None Jbeil 4 Sophia Baker
4006 Sept. 12, 2021 None Mansourieh 5 Liam Turner
4007 Nov. 30, 2020 None Beirut 5 Ava Harris
4008 Jan. 23, 2023 March 15, 2023 Ashrafieh 3 Mason Jenkins
4009 March 14, 2021 May 6, 2023 Jbeil 4 Isabella Martin
4010 May 17, 2021 None Jbeil 4 Noah Foster
SSN First Name Last Name Phone Date of Birth Address Broker Phone Employee SSN Date of Assignment
1 Mike Madison 4123 April 22, 1980 Ashrafieh 4001 1239 April 5, 2023
2 William Johnson 4132 Nov. 25, 1983 Saida 4001 1239 March 3, 2023
3 Sarah Brown 4152 March 23, 1991 Hamra 4003 1239 Jan. 2, 2023
4 Ashley Taylor 4133 Oct. 17, 1999 Jounie 4004 1239 June 7, 2023
5 Thomas Wilson 4555 Sept. 8, 1999 Jbeil None 1239 April 20, 2023
6 Anthony Anderson 4765 July 7, 2006 Faraya None 1240 Feb. 14, 2023
7 Lucas Martinez 4122 March 25, 1957 Zahle 4002 1240 Oct. 10, 2023
8 Susan Wilson 4999 July 21, 1985 Mansourieh 4002 1242 Sept. 1, 2023
9 Lea Marris 4545 Nov. 7, 1999 Matn 4002 1243 Aug. 1, 2023
10 Laura Jackson 4677 Aug. 5, 1963 Sawfar 4002 1243 July 1, 2023
Customer SSN First Name Last Name Date of Birth Relation
1 Sophia Madison Aug. 30, 1981 Wife
1 Jack Madison Aug. 29, 2008 Son
1 Ethan Madison Nov. 8, 2010 Son
1 Olivia Madison July 25, 2013 Daughter
10 Grace Jackson March 30, 1965 Sister
10 Eva Jackson Aug. 27, 1940 Mother
10 Linda Jackson Oct. 20, 1973 Sister
10 Liam Jackson April 19, 1991 Son
8 Oliver Wilson June 21, 1986 Husband
8 Emma Wilson July 22, 2006 Daughter
8 James Wilson Oct. 4, 2010 Son
ID Name Representative Phone
101 ABC Ziad Shami 4111
102 Biotech Ali Rizk 4212
103 Precision Karim Chahine 4333
104 PHD Anthony Karam 4799
105 NovaBio Jad Chehab 4999
106 VitalScan Issa Yasser 4919
107 Quantum Hasan Moukallid 4500
108 GeneSys Ahmad Hajj 4002
109 ALC Sara Yaser 4888
110 MIC Mohamad Ahmad 4900
ID Phone Name Representative Location
201 4541 CMC Sami Ahmad Hamra
202 4000 AUBMC Hussein Madi Hamra
203 4002 BAUHC Joe Noura Beirut
204 4909 RIZK Karam Saaed Ashrafieh
205 4155 BELLVUE Jad Chahine Beirut
206 4330 EVERGREEN Omar Khalil Beirut
207 4444 LIBERTY Celena Younes Saida
208 4997 ANC Ahmad Hashem Mansourie
209 4998 HUH Karim Abi Karam Hazmieh
210 4344 MUH Ahmad Agha Matn
Phone Specialization First Name Last Name Work Start Number of Malpractices
5112 Radiology Emily Tuner Jan. 1, 2018 1
5661 Dermatology Laura Mitchell July 9, 2013 4
5221 Oncologist Victoria White Jan. 5, 2003 2
5665 Cardiologist Gabriel Garcia Aug. 1, 2010 1
5881 Neurologist Alexander Johnson June 1, 2021 2
5990 Pediatrician Christopher William Sept. 1, 2022 0
5771 Gastroenterologist Isabelle Charter Jan. 1, 2018 2
5889 Pulmonologist Willian Lee May 1, 2021 0
5991 Urologist Lucas Rodriguez July 1, 2019 0
5118 Nephrologist Susan Foster Aug. 1, 2015 1
ID Type Name Description Price Start Age End Age Percentage Paid Time Limit Financial Limit
1 in+out Everything covered Will cover all medical bills, hospital and labs 500 5 20 100 365 1000000
2 in+out Everything covered Will cover all medical bills, hospital and labs 550 21 40 100 365 1000000
3 in+out Everything covered Will cover all medical bills, hospital and labs 600 41 60 100 365 1000000
4 in+out Everything covered Will cover all medical bills, hospital and labs 700 61 70 100 365 1000000
5 in+out Everything covered Will cover all medical bills, hospital and labs 800 71 80 100 365 1000000
6 in+out Everything covered Will cover all medical bills, hospital and labs 900 81 90 100 365 1000000
7 in Hospital only Will only cover hospital bills related to operations 200 5 30 100 365 750000
8 in Hospital only Will only cover hospital bills related to operations 250 31 60 100 365 750000
9 in Hospital only Will only cover hospital bills related to operations 300 61 70 100 365 750000
10 in Hospital only Will only cover hospital bills related to operations 350 71 80 100 365 750000
11 in Hospital only Will only cover hospital bills related to operations 450 81 90 100 365 750000
ID Total Amount Date Days to Pay
1 550 Jan. 15, 2020 30
2 550 Jan. 15, 2021 30
3 550 Jan. 15, 2022 30
4 550 Jan. 15, 2023 30
5 200 May 23, 2023 30
6 1100 March 4, 2022 30
7 1100 March 4, 2023 30
8 200 July 30, 2023 30
9 2100 June 25, 2022 30
10 2100 Oct. 10, 2023 30
Customer SSN Bill ID Date Amount Paid
2 1 Jan. 15, 2020 550
2 2 Jan. 15, 2021 550
2 3 Jan. 15, 2022 550
2 4 Jan. 15, 2023 550
6 5 May 23, 2023 100
6 5 June 4, 2023 100
1 6 March 4, 2022 700
1 6 March 24, 2022 400
1 7 March 4, 2023 700
1 7 March 21, 2023 400
5 8 July 30, 2023 200
8 9 June 25, 2022 2100
8 10 Oct. 10, 2023 1100
Plan Identifier Customer SSN Number of Plans Date Activated Billed
2 2 1 Jan. 15, 2020 True
7 6 1 May 23, 2023 True
2 2 1 Jan. 15, 2021 True
2 2 1 Jan. 15, 2022 True
2 2 1 Jan. 15, 2023 True
8 1 5 March 4, 2022 True
8 1 5 March 4, 2023 True
7 5 1 July 30, 2023 True
2 8 4 June 25, 2022 True
2 8 4 Oct. 10, 2023 True
Plan Identifier Hospital ID
1 201
1 202
1 203
1 204
1 205
1 206
1 207
1 208
1 209
1 210
2 201
2 202
2 203
2 204
2 205
2 206
2 207
2 208
2 209
2 210
3 201
3 202
3 203
3 204
3 205
3 206
3 207
3 208
3 209
3 210
4 201
4 202
4 203
4 204
4 205
4 206
4 207
4 208
4 209
4 210
5 201
5 202
5 203
5 204
5 205
5 206
5 207
5 208
5 209
5 210
6 201
6 202
6 203
6 204
6 205
6 206
6 207
6 208
6 209
6 210
7 203
7 204
7 205
7 206
7 207
7 208
7 209
7 210
8 203
8 204
8 205
8 206
8 207
8 208
8 209
8 210
9 203
9 204
9 205
9 206
9 207
9 208
9 209
9 210
10 203
10 204
10 205
10 206
10 207
10 208
10 209
10 210
11 203
11 204
11 205
11 206
11 207
11 208
11 209
11 210
Doctor Phone Hospital ID
5112 201
5661 202
5221 203
5665 204
5881 205
5990 206
5771 207
5889 208
5991 209
5118 210
Plan Identifier Lab ID
1 101
1 102
1 103
1 104
1 105
1 106
1 107
1 108
1 109
1 110
2 101
2 102
2 103
2 104
2 105
2 106
2 107
2 108
2 109
2 110
3 101
3 102
3 103
3 104
3 105
3 106
3 107
3 108
3 109
3 110
4 101
4 102
4 103
4 104
4 105
4 106
4 107
4 108
4 109
4 110
5 101
5 102
5 103
5 104
5 105
5 106
5 107
5 108
5 109
5 110
6 101
6 102
6 103
6 104
6 105
6 106
6 107
6 108
6 109
6 110
Customer SSN Lab ID Description Price Date
1 101 Blood Test 10 Sept. 4, 2023
2 102 Urine Analysis 15 Sept. 6, 2023
3 103 X-Ray 30 Sept. 16, 2023
4 104 MRI Scan 65 Sept. 23, 2023
5 105 Blood Test 10 Sept. 29, 2023
6 106 Ultrasound 45 Oct. 3, 2023
7 107 Urine Analysis 15 Oct. 5, 2023
8 108 X-Ray 30 Oct. 9, 2023
9 109 Blood Test 10 Oct. 13, 2023
10 110 MRI Scan 65 Oct. 17, 2023
1 101 X-Ray 30 Oct. 18, 2023
1 102 Urine Analysis 15 Oct. 24, 2023
3 103 Blood Test 10 Oct. 30, 2023
4 104 MRI Scan 65 Jan. 5, 2023
5 105 Ultrasound 45 Jan. 11, 2023
6 106 X-Ray 30 Jan. 17, 2023
2 107 Urine Analysis 15 Jan. 23, 2023
8 108 Blood Test 10 Jan. 29, 2023
9 109 MRI Scan 65 Feb. 4, 2023
4 110 Ultrasound 45 Feb. 10, 2023
Lab ID Location
101 Hamra
101 Jbeil
102 Hamra
103 Beirut
104 Ashrafieh
105 Ashrafieh
105 Saida
106 Saida
107 Hamra
108 Dekwaneh
108 Mansourieh
109 Dekwaneh
110 Hamra
Customer SSN Chronic Disease
7 Diabetes
9 Diabetes
4 Diabetes
7 Hypertension
7 Asthma
7 Arthritis
2 Asthma
4 Asthma
5 Epilepsy
5 Cancer
7 Alzheimers
10 Alzheimers
Customer SSN Exclusion
1 Dental care
2 Dental care
3 Dental care
5 Dental care
8 Dental care
1 Cosmetic surgery
2 Cosmetic surgery
3 Cosmetic surgery
5 Cosmetic surgery
8 Cosmetic surgery
10 Cosmetic surgery
Customer SSN First Name Last Name Chronic Disease
10 Grace Jackson Diabetes
10 Grace Jackson Alzheimers
10 Grace Jackson Hypertension
1 Jack Madison Asthma
8 Oliver Wilson Asthma
8 Oliver Wilson Alzheimers
8 Oliver Wilson Hypertension
8 Oliver Wilson Diabetes
10 Liam Jackson Asthma
1 Ethan Madison Asthma
Doctor Phone Hospital ID Customer SSN Date Description Price
5881 205 1 March 12, 2022 Brain Surgery 40000
5881 205 1 May 23, 2022 Brain Surgery 32000
5221 203 4 Dec. 21, 2022 Appendectomy 10000
5991 209 4 June 30, 2022 Endoscopy 3000
5881 208 5 April 21, 2021 Brain Surgery 35000
5991 209 7 March 24, 2022 Endoscopy 3000
5991 210 3 Feb. 18, 2023 General Surgery 8000
5221 203 3 June 4, 2023 Appendectomy 10000
5771 207 10 Jan. 31, 2023 General Surgery 8000
5881 201 6 Sept. 24, 2023 Brain Surgery 30000
5112 201 1 May 15, 2023 General Surgery 8000