/
7-update-1-insert-sd-person.sql
314 lines (312 loc) · 49.7 KB
/
7-update-1-insert-sd-person.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
/*
* Load customer records into the sd_person table with data detection
* to only load customer records with updated information.
* Run as the semarchy_customer_b2c_mdm user.
*/
INSERT INTO semarchy_customer_b2c_mdm.sd_person (
b_loadid,
b_classname,
b_pubid,
b_sourceid,
first_name,
last_name,
date_of_birth,
addstreet,
addcity,
addstate,
addpostal_code,
addcountry,
source_email,
source_phone,
person_type,
value_status
)
SELECT
semarchy_repository.get_continuous_loadid('CONTINUOUS_LOAD_INTEGRATE_ALL') AS b_loadid,
'Person' AS b_classname, /* Entity name. Found in MDM Workbench UI. */
stg.b_pubid,
stg.b_sourceid,
stg.first_name,
stg.last_name,
stg.date_of_birth,
stg.addstreet,
stg.addcity,
stg.addstate,
stg.addpostal_code,
stg.addcountry,
stg.source_email,
stg.source_phone,
stg.person_type,
stg.value_status
FROM (
VALUES
('CRM', '1123060', 'Mary-Ann', 'Markes', to_date('11/18/1993', 'MM-DD-YYYY'), '1200 Summer St #-103', 'Stamford', 'CT', '06905', 'US', 'maryann@markes.com', '203-967-5612', 'CUSTOMER', 'HIGH'),
('CRM', '1313060', 'Mary-ann', 'Markes', to_date('11/18/1993', 'MM-DD-YYYY'), '1200 Summer St #-103', 'Stamford', 'CT', '06905', 'US', 'maryann@markes.com', '203-967-5612', 'CUSTOMER', 'HIGH'),
('CRM', '1316294', 'Rey', 'Amason', to_date('12/16/1975', 'MM-DD-YYYY'), '3 Depot St', 'Wapakoneta', 'OH', '45665', 'US', 'rey@amason.com', '419 738 9241', 'CUSTOMER', 'HIGH'),
('CRM', '1320830', 'Jass', 'Ellerbusch', to_date('12/11/1991', 'MM-DD-YYYY'), '73 S Hamilton Ave', 'Doylestown', 'PA', '18901', 'US', 'jass@ellerbusch.com', '215-348-5078', 'PROSPECT', NULL),
('CRM', '1326294', 'Ray', 'Amason', to_date('12/16/1975', 'MM-DD-YYYY'), '3 Depot St', 'Wapakoneta', 'OH', '45665', 'US', 'rey@amason.com', '419-738-9241', 'CUSTOMER', 'HIGH'),
('CRM', '1333590', 'John', 'Edelman', to_date('09/03/1976', 'MM-DD-YYYY'), '591 Redwood Hwy #-1200', 'Mill Valley', 'CA', '94941', 'US', 'john@jedelman.com', '415.381.9176', 'CUSTOMER', 'NORMAL'),
('CRM', '1333591', 'John', 'Edelman', to_date('09/03/1976', 'MM-DD-YYYY'), '591 Redwood Hwy #-1200', 'Mill Valley', 'CA', '94941', 'US', 'john@jedelman.com', '415-381-9176', 'CUSTOMER', 'NORMAL'),
('CRM', '1334125', 'Jasmine', 'Ellerbusch', to_date('12/11/1991', 'MM-DD-YYYY'), '73 S Hamilton Ave', 'Doylestown', 'PA', '18901', 'US', 'jass@ellerbusch.com', '215-348-5078', 'PROSPECT', NULL),
('CRM', '1336294', 'Ray', 'Amason', to_date('12/16/1975', 'MM-DD-YYYY'), '3 Depot St', 'Wapakoneta', 'OH', '45665', 'US', 'ray@amason.com', '419.738.9241', 'CUSTOMER', 'HIGH'),
('CRM', '1350076', 'Federico', 'Popp', to_date('04/30/1983', 'MM-DD-YYYY'), '419 N Cascade Ave', 'Colorado Springs', 'CO', '60603', 'US', 'federico@popp.com', '719-635-5347', 'CUSTOMER', 'NORMAL'),
('CRM', '1350480', 'Quinn', 'Mitchen', to_date('01/12/1992', 'MM-DD-YYYY'), '67616 Desert View Ave', 'Desert Hot Springs', 'CA', '62240', 'US', 'quinn@mitchen.com', '760-329-3382', 'PROSPECT', NULL),
('CRM', '1351779', 'Lyman', 'Wengel', to_date('01/02/1986', 'MM-DD-YYYY'), '1225 17th St', 'Denver', 'CO', '60202', 'US', 'lyman@wengel.com', '303-292-4338', 'PROSPECT', NULL),
('CRM', '1352226', 'Lucinda', 'Clingingsmith', to_date('03/18/1993', 'MM-DD-YYYY'), '91195 Hanua St', 'Kapolei', 'HI', '68707', 'US', 'lucy@clingingsmith.com', '808-682-3122', 'PROSPECT', NULL),
('CRM', '1352415', 'Tuan', 'Corbett', to_date('11/09/1992', 'MM-DD-YYYY'), '16 Maple St', 'Mechanic Falls', 'ME', '04258', 'US', 'tuan@corbett.com', '207-345-7845', 'PROSPECT', NULL),
('CRM', '1352961', 'Harry', 'Elbers', to_date('11/17/1995', 'MM-DD-YYYY'), '106 T St', 'Eureka', 'CA', '65501', 'US', 'harold@elbers.com', '707-442-1642', 'PROSPECT', NULL),
('CRM', '1353445', 'Vernice', 'Southwood', to_date('10/22/1987', 'MM-DD-YYYY'), '8 Commercial Blvd', 'Medford', 'NY', '11783', 'US', 'vernice@southwood.com', '631-698-8293', 'CUSTOMER', 'NORMAL'),
('CRM', '1353638', 'Winnie', 'Gouker', to_date('08/17/1986', 'MM-DD-YYYY'), 'Glaize Shopping', 'Osage Beach', 'MO', '85085', 'US', NULL, '573-348-0827', 'CUSTOMER', 'NORMAL'),
('CRM', '1353672', 'Angelica', 'Aldaba', to_date('11/23/1986', 'MM-DD-YYYY'), '1427 Nw Davis St', 'Portland', 'OR', '67206', 'US', 'angelica@aldaba.com', '503-228-3027', 'CUSTOMER', 'NORMAL'),
('CRM', '1353814', 'Ross', 'Taulman', to_date('11/06/1978', 'MM-DD-YYYY'), '1201 3rd Ave #-3400', 'Seattle', 'WA', '66101', 'US', 'roscoe@taulman.com', '206-682-4857', 'CUSTOMER', 'NORMAL'),
('CRM', '1355424', 'Liza', 'Assante', to_date('12/03/1981', 'MM-DD-YYYY'), '8589 Darrow Rd', 'Twinsburg', 'OH', '44067', 'US', 'liza@assante.com', '330-425-7382', 'CUSTOMER', 'NORMAL'),
('CRM', '1355739', 'Weldon', 'Odegard', to_date('08/07/1985', 'MM-DD-YYYY'), '6822 Academy Parkway W', 'Albuquerque', 'NM', '67106', 'US', 'weldon@odegard.com', '505-345-1780', 'PROSPECT', NULL),
('CRM', '1356431', 'Dino', 'Mitchen', to_date('01/11/1983', 'MM-DD-YYYY'), '400 N Pennsylvania Ave #-500', 'Roswell', 'NM', '66201', 'US', 'dino@mitchen.com', '505-622-3923', 'CUSTOMER', 'NORMAL'),
('CRM', '1356506', 'Katharine', 'Sankar', to_date('02/09/1977', 'MM-DD-YYYY'), '5122 Lewis Ave', 'Toledo', 'OH', '43812', 'US', 'katharine@sankar.com', '419-476-7118', 'CUSTOMER', 'NORMAL'),
('CRM', '1356510', 'Faye', 'Mcgrue', to_date('06/13/1983', 'MM-DD-YYYY'), '1120 20th St Nw', 'Washington', 'DC', '20038', 'US', 'faye@mcgrue.com', '202-962-9236', 'CUSTOMER', 'NORMAL'),
('CRM', '1357165', 'Caroline', 'LaPalme', to_date('05/22/1990', 'MM-DD-YYYY'), '4910 Departure Drive', 'Raleigh', 'NC', '27804', 'US', 'carol.lapalme@yahoo.com', '919-876-7612', 'CUSTOMER', 'NORMAL'),
('CRM', '1358759', 'Colton', 'Rave', to_date('01/19/1973', 'MM-DD-YYYY'), '1644 N Honore St', 'Chicago', 'IL', '80822', 'US', 'colton@rave.com', '773-486-5500', 'CUSTOMER', NULL),
('CRM', '1359465', 'Leif', 'Defiguero', to_date('02/23/1992', 'MM-DD-YYYY'), '4097 W Ramsey St', 'Banning', 'CA', '62220', 'US', 'leif@defiguero.com', '951-849-6891', 'PROSPECT', NULL),
('CRM', '1361292', 'Virgie', 'Geuder', to_date('09/05/1980', 'MM-DD-YYYY'), '1922 S Laredo St', 'San Antonio', 'TX', '76207', 'US', 'virgie@geuder.com', '210-224-1698', 'CUSTOMER', 'NORMAL'),
('CRM', '1363457', 'Zay', 'Hendel', to_date('08/01/1979', 'MM-DD-YYYY'), '2332 E Division St', 'Springfield', 'MO', NULL, 'US', 'isaiah@hendel.com', '417-864-1286', 'CUSTOMER', 'NORMAL'),
('CRM', '1363595', 'Nola', 'Girvan', to_date('04/10/1980', 'MM-DD-YYYY'), '1620 Paonia St', 'Colorado Springs', 'CO', NULL, 'US', 'nola@girvan.com', '719-574-6245', 'PROSPECT', NULL),
('CRM', '1365204', 'Wesley', 'Sahagun', to_date('11/15/1978', 'MM-DD-YYYY'), '2404 W Mercury Blvd', 'Hampton', 'VA', NULL, 'US', 'wesley@sahagun.com', '757-827-1035', 'PROSPECT', NULL),
('CRM', '1366067', 'Hanna', 'Waetzig', to_date('01/16/1994', 'MM-DD-YYYY'), 'Hwy 80', 'Pooler', 'GA', NULL, 'US', NULL, '912-748-2988', 'PROSPECT', NULL),
('CRM', '1366369', 'Lisa', 'Hilgeman', to_date('08/11/1977', 'MM-DD-YYYY'), '600 Grant St #-42', 'Pittsburgh', 'PA', NULL, 'US', 'elisa@hilgeman.com', '412-566-1804', 'PROSPECT', NULL),
('CRM', '1366458', 'Earline', 'Hendel', to_date('09/21/1969', 'MM-DD-YYYY'), '4850 Rhawn Ave', 'Philadelphia', 'PA', '19136', 'US', 'earline@hendel.com', '215-338-6850', 'CUSTOMER', 'NORMAL'),
('CRM', '1366536', 'Nelda', 'Elbers', to_date('02/02/1997', 'MM-DD-YYYY'), '100 Federal Ave', 'Boston', 'MA', '02110', 'US', 'nelda@elbers.com', '617-330-5446', 'PROSPECT', NULL),
('CRM', '1368072', 'Sheena', 'Missel', to_date('09/20/1979', 'MM-DD-YYYY'), '789 Sherman Ave', 'Denver', 'CO', '80203', 'US', 'sheena@missel.com', '303-860-0262', 'PROSPECT', NULL),
('CRM', '1368095', 'Edmundo', 'Resides', to_date('10/23/1988', 'MM-DD-YYYY'), '222 W 6th Ave', 'Junction City', 'KS', '66441', 'US', 'edmundo@resides.com', '785-762-2986', 'CUSTOMER', 'NORMAL'),
('CRM', '1368164', 'Lu', 'Geuder', to_date('07/03/1984', 'MM-DD-YYYY'), '429 Themis Ave', 'Cape Girardeau', 'MO', '63701', 'US', 'luella@geuder.com', '573-334-9416', 'CUSTOMER', 'NORMAL'),
('CRM', '1369203', 'Lynn', 'Willer', to_date('06/16/1983', 'MM-DD-YYYY'), '343 Sansome Ave', 'San Francisco', 'CA', '94104', 'US', 'lynn@willer.com', '415-981-1865', 'PROSPECT', NULL),
('CRM', '1369708', 'Toni', 'Mattos', to_date('07/01/1973', 'MM-DD-YYYY'), '3109 Main Ave', 'Melbourne', 'FL', '32901', 'US', 'toni@mattos.com', '321-727-6512', 'CUSTOMER', 'HIGH'),
('CRM', '1370125', 'Jasmine', 'Ellerbusch', to_date('12/11/1991', 'MM-DD-YYYY'), '73 S Hamilton Ave', 'Doylestown', 'PA', '18901', 'US', 'jass@ellerbusch.com', '215-348-5078', 'PROSPECT', NULL),
('CRM', '1370624', 'Dan', 'Lamoureux', to_date('12/09/1978', 'MM-DD-YYYY'), '810 W Bridge Ave', 'Streator', 'IL', '61364', 'US', 'daniel@lamoureux.com', '815-672-0290', 'CUSTOMER', 'NORMAL'),
('CRM', '1370830', 'Jass', 'Ellerbusch', to_date('12/11/1991', 'MM-DD-YYYY'), '73 S Hamilton Ave', 'Doylestown', 'PA', '18901', 'US', 'jass@ellerbusch.com', '215-348-5078', 'PROSPECT', NULL),
('CRM', '1370933', 'Tina', 'Maschak', to_date('03/12/1988', 'MM-DD-YYYY'), '210 N Saint Clair Ave', 'Dayton', 'OH', '45402', 'US', 'christina@maschak.com', '937-222-7228', 'CUSTOMER', 'NORMAL'),
('CRM', '1371322', 'DeShawn', 'Peters', to_date('09/18/1982', 'MM-DD-YYYY'), '125 Ne 1st Ave', 'Ocala', 'FL', '34470', 'US', 'd@pedrogo.com', '217-243-7667', 'CUSTOMER', 'NORMAL'),
('CRM', '1372230', 'Jame', 'Okimoto', to_date('10/23/1983', 'MM-DD-YYYY'), '210 S Carancahua Ave', 'Corpus Christi', 'TX', '78401', 'US', 'jame@okimoto.com', '361-889-6534', 'PROSPECT', NULL),
('CRM', '1372234', 'Russ', 'Schettler', to_date('07/22/1981', 'MM-DD-YYYY'), '689 W Main Ave', 'Freehold', 'NJ', '07728', 'US', 'russell@schettler.com', '732-409-1741', 'CUSTOMER', 'NORMAL'),
('CRM', '1372351', 'Dan', 'Runions', to_date('12/28/1996', 'MM-DD-YYYY'), '44 School Ave', 'Boston', 'MA', '02108', 'US', 'daniel@runions.com', '617-367-6047', 'CUSTOMER', 'NORMAL'),
('CRM', '1373036', 'Eloisa', 'Resides', to_date('04/05/1974', 'MM-DD-YYYY'), '224 Saint Louis Ave', 'Edwardsville', 'IL', '62025', 'US', 'eloisa@resides.com', '618-656-9506', 'PROSPECT', NULL),
('CRM', '1373060', 'Hallie', 'Lolli', to_date('12/20/1976', 'MM-DD-YYYY'), '320 New Bridge Ave', 'Jacksonville', 'NC', '28540', 'US', 'hallie@lolli.com', '910-455-8087', 'PROSPECT', NULL),
('CRM', '1373064', 'Mary-Ann', 'Markes', to_date('11/18/1993', 'MM-DD-YYYY'), '1200 Summer St #-103', 'Stamford', 'CT', '06905', 'US', 'maryann@markes.com', '203-967-5612', 'CUSTOMER', 'HIGH'),
('CRM', '1374265', 'Dale', 'Balliew', to_date('10/14/1980', 'MM-DD-YYYY'), '216 Birch Ave', 'Kennett Square', 'PA', '19348', 'US', 'dale@balliew.com', '610-444-4527', 'CUSTOMER', 'NORMAL'),
('CRM', '1374473', 'Buster', 'Tukuafa', to_date('10/24/1972', 'MM-DD-YYYY'), '822 Baronne Ave', 'New Orleans', 'LA', '70113', 'US', 'buster@tukuafa.com', '504-522-0979', 'PROSPECT', NULL),
('CRM', '1375249', 'Marquis', 'Barayuga', to_date('01/30/1985', 'MM-DD-YYYY'), '2 Allée Florian', 'Tassin-la-Demi-Lune', 'Rhône', '69160', 'France', 'marquis@barayuga.com', '+33 4 78 79 83 84', 'CUSTOMER', 'NORMAL'),
('CRM', '1376294', 'Ray', 'Amason', to_date('12/16/1975', 'MM-DD-YYYY'), '3 Depot St', 'Wapakoneta', 'OH', '45665', 'US', 'rey@amason.com', NULL, 'CUSTOMER', 'HIGH'),
('CRM', '1376534', 'Cortez', 'Derer', to_date('12/21/1976', 'MM-DD-YYYY'), '1415 N 32nd Ave', 'Fort Smith', 'AR', '72904', 'US', 'cortez@derer.com', '479-785-7023', 'CUSTOMER', NULL),
('CRM', '1376827', 'Reginald', 'Kososky', to_date('01/11/1969', 'MM-DD-YYYY'), '600 S Indian Hill Ave', 'Claremont', 'CA', '91711', 'US', 'reggie@kososky.com', '909-625-9884', 'CUSTOMER', 'NORMAL'),
('CRM', '1376927', 'Lexi', 'Assante', to_date('03/02/1990', 'MM-DD-YYYY'), '484 Lincoln Ave', 'Middlesex', 'NJ', '08846', 'US', 'alexis@assante.com', '732-563-0191', 'PROSPECT', NULL),
('CRM', '1377537', 'Mason', 'Shabazz', to_date('04/19/1974', 'MM-DD-YYYY'), '89 E Nationwide Ave', 'Columbus', 'OH', '43215', 'US', 'mason@shabazz.com', '614-221-4018', 'CUSTOMER', 'HIGH'),
('CRM', '1378963', 'Jonah', 'Bamfield', to_date('08/14/1986', 'MM-DD-YYYY'), '180 N Stetson Ave', 'Chicago', 'IL', '60601', 'US', 'jonah@bamfield.com', '312-565-2859', 'CUSTOMER', 'NORMAL'),
('CRM', '1379472', 'Ted', 'Hilgeman', to_date('11/10/1984', 'MM-DD-YYYY'), '1 Whitney Ave', 'New Haven', 'CT', '06510', 'US', 'edmund@hilgeman.com', '203-865-1215', 'PROSPECT', NULL),
('CRM', '1380101', 'Sara', 'Johnson', to_date('10/17/1997', 'MM-DD-YYYY'), NULL, 'San Rafael', 'CA', NULL, 'US', 'saraj@yahoo.com', '415-472-3289', 'CUSTOMER', 'NORMAL'),
('CRM', '1380327', 'Emilie', 'Svec', to_date('09/04/1991', 'MM-DD-YYYY'), '2222 W Grandview Blvd', 'Erie', 'PA', '16506', 'US', 'emilie@svec.com', '814-833-6073', 'PROSPECT', NULL),
('CRM', '1380441', 'Barnabas', 'Summerset', to_date('05/24/1987', 'MM-DD-YYYY'), '4499 Ruffin Rd', 'San Diego', 'CA', '92123', 'US', 'barney@summerset.com', '714-897-5451', 'CUSTOMER', 'NORMAL'),
('CRM', '1381226', 'Mose', 'Pravata', to_date('02/15/1969', 'MM-DD-YYYY'), '1011 Edgewater Ave', 'Ridgefield', 'NJ', '07657', 'US', 'mose@pravata.com', '201-941-5345', 'PROSPECT', NULL),
('CRM', '1381797', 'Pearlie', 'Ellerbusch', to_date('05/15/1991', 'MM-DD-YYYY'), '2108 Menaul Blvd Ne', 'Albuquerque', 'NM', '87107', 'US', 'pearlie@ellerbusch.com', '505-889-8955', 'CUSTOMER', 'NORMAL'),
('CRM', '1381799', 'Julianna', 'Quimby', to_date('08/05/1989', 'MM-DD-YYYY'), '615 Franklin Tpke', 'Ridgewood', 'NJ', '07450', 'US', 'juliana@quimby.com', '201-444-6741', 'PROSPECT', NULL),
('CRM', '1381860', 'Roy', 'Semrad', to_date('07/16/1969', 'MM-DD-YYYY'), '6555 Carnegie Ave', 'Cleveland', 'OH', '44103', 'US', 'roy@semrad.com', '216-361-9627', 'CUSTOMER', 'NORMAL'),
('CRM', '1382839', 'Kelly', 'Graniela', to_date('12/31/1899', 'MM-DD-YYYY'), '925 L St', 'Sacramento', 'CA', '95814', 'US', 'kelly@graniela.com', '916-442-8885', 'CUSTOMER', 'NORMAL'),
('CRM', '1383060', 'Mary-ann', 'Markes', to_date('11/18/1993', 'MM-DD-YYYY'), '1200 Summer St #-103', 'Stamford', 'CT', '06905', 'US', 'maryann@markes.com', '203-967-5612', 'CUSTOMER', 'HIGH'),
('CRM', '1383590', 'John', 'Edelman', to_date('09/30/1986', 'MM-DD-YYYY'), '591 Redwood Hwy #-1200', 'Mill Valley', 'CA', '94941', 'US', 'john@jedelman.com', '415-381-9176', 'CUSTOMER', 'NORMAL'),
('CRM', '1384577', 'Roy', 'Averhart', to_date('02/17/1973', 'MM-DD-YYYY'), '101 S San Mateo Dr.', 'San Mateo', 'CA', '94401', 'US', 'roy@averhart.com', '650-342-2438', 'CUSTOMER', 'NORMAL'),
('CRM', '1384862', 'Eloisa', 'Schaedler', to_date('11/17/1977', 'MM-DD-YYYY'), '191 Peachtree St Ne', 'Atlanta', 'GA', '30303', 'US', 'eloisa@schaedler.com', '404-818-6870', 'CUSTOMER', 'NORMAL'),
('CRM', '1385517', 'Mike', 'Larue', to_date('09/04/1991', 'MM-DD-YYYY'), '109 N Mayo St', 'Americus', 'GA', '31709', 'US', 'mikelarue@amason.com', '229-924-2487', 'CUSTOMER', 'HIGH'),
('CRM', '1385755', 'Emilie', 'Svec', to_date('05/10/1984', 'MM-DD-YYYY'), '2222 W Grandview Blvd', 'Erie', 'PA', '16506', 'US', 'emilie@svec.com', '814-833-6073', 'PROSPECT', NULL),
('CRM', '1385955', 'Cal', 'Taulman', to_date('03/31/1984', 'MM-DD-YYYY'), 'Petroleum', 'Wichita', 'KS', '67202', 'US', 'caleb@taulman.com', '316-625-8492', 'CUSTOMER', 'NORMAL'),
('CRM', '1386206', 'Kelley', 'Taulman', to_date('09/06/1976', 'MM-DD-YYYY'), '1111 Superior Ave E', 'Cleveland', 'OH', '44114', 'US', 'kelley@taulman.com', '216-771-0715', 'CUSTOMER', 'NORMAL'),
('CRM', '1386237', 'Callie', 'Aldaba', to_date('04/03/1972', 'MM-DD-YYYY'), '2151 River Plaza Dr #-105', 'Sacramento', 'CA', '95833', 'US', 'callie@aldaba.com', '916-567-4449', 'CUSTOMER', 'NORMAL'),
('CRM', '1386547', 'Alyce', 'Mercury', to_date('08/29/1973', 'MM-DD-YYYY'), '108 N Columbus St', 'Alexandria', 'VA', '22314', 'US', 'alyce@mercury.com', '703-548-7115', 'CUSTOMER', 'NORMAL'),
('CRM', '1387232', 'Anthony', 'Robaina', to_date('08/14/1986', 'MM-DD-YYYY'), '1555 S Greenwood Ave', 'Montebello', 'CA', '90640', 'US', 'tony@robaina.com', '323-887-4889', 'PROSPECT', NULL),
('CRM', '1388087', 'Marquis', 'Barayuga', to_date('01/30/1985', 'MM-DD-YYYY'), '2 Allée Florian', 'Tassin-la-Demi-Lune', 'Rhône', '69160', 'France', 'marquis@barayuga.com', '+33 4 78 79 83 84', 'PROSPECT', NULL),
('CRM', '1388210', 'Abe', 'Corbett-Lopéz', to_date('10/06/1986', 'MM-DD-YYYY'), '12 S 12th St', 'Philadelphia', 'PA', '19107', 'US', 'abraham@corbett.com', '215-627-9067', 'PROSPECT', NULL),
('CRM', '1388630', 'Carmine', 'Anadio', to_date('02/28/1994', 'MM-DD-YYYY'), '93 Main St', 'Orono', 'ME', '04473', 'US', 'carmine@anadio.com', '207-866-5602', 'CUSTOMER', 'NORMAL'),
('CRM', '1388894', 'Mikel', 'Pete', to_date('09/05/1982', 'MM-DD-YYYY'), '2 E Mifflin St', 'Madison', 'WI', '53703', 'US', NULL, '608-257-6727', 'CUSTOMER', 'NORMAL'),
('CRM', '1388913', 'Marlon', 'Gouker', to_date('11/13/1979', 'MM-DD-YYYY'), '167 E Main St', 'Lexington', 'KY', '40507', 'US', NULL, '859-253-6671', 'PROSPECT', NULL),
('CRM', '1389553', 'Fran', 'Sahagun', to_date('07/22/1972', 'MM-DD-YYYY'), '220 S 6th St', 'Minneapolis', 'MN', '55402', 'US', 'francine@sahagun.com', '612-340-7052', 'CUSTOMER', 'NORMAL'),
('CRM', '1390591', 'Lyle', 'Hilgeman', to_date('03/26/1991', 'MM-DD-YYYY'), '115 N 20th St', 'Tampa', 'FL', '33605', 'US', 'lyle@hilgeman.com', '813-248-1861', 'CUSTOMER', 'NORMAL'),
('CRM', '1390832', 'Jake', 'Schettler', to_date('05/09/1983', 'MM-DD-YYYY'), '10400 Eaton Pl #-401', 'Fairfax', 'VA', '22030', 'US', 'jake@schettler.com', '703-591-4492', 'CUSTOMER', 'NORMAL'),
('CRM', '1391074', 'Claude', 'Averhart', to_date('02/15/1969', 'MM-DD-YYYY'), '49 S Carroll St', 'Frederick', 'MD', '21701', 'US', 'claude@averhart.com', '301-698-3706', 'PROSPECT', NULL),
('CRM', '1391721', 'Alex', 'Anadio', to_date('02/25/1992', 'MM-DD-YYYY'), '1651 W Baseline Rd', 'Tempe', 'AZ', '85283', 'US', 'alexander@anadio.com', '480-491-3109', 'PROSPECT', NULL),
('CRM', '1391755', 'Ken', 'Robaina', to_date('11/18/1993', 'MM-DD-YYYY'), '1455 91st Ave Ne', 'Minneapolis', 'MN', '55449', 'US', 'ken@robaina.com', '763.780.4712', 'PROSPECT', NULL),
('CRM', '1391914', 'Thanh', 'Spark', to_date('05/15/1991', 'MM-DD-YYYY'), '1800 Ids Ctr', 'Minneapolis', 'MN', '55402', 'US', 'thanh@spark.com', '612-339-5614', 'CUSTOMER', 'NORMAL'),
('CRM', '1392184', 'Clare', 'Poitier', to_date('07/16/1969', 'MM-DD-YYYY'), '28500 Green Oak Dr', 'Roseville', 'MI', '48066', 'US', 'clair@poitier.com', '586-296-0808', 'PROSPECT', NULL),
('CRM', '1392270', 'Adele', 'Richardson', to_date('01/09/1981', 'MM-DD-YYYY'), '15 Pleasant Ave E', 'Paramus', 'NJ', '07652', 'US', 'adelaide@mackson.com', '201-845-4885', 'CUSTOMER', 'NORMAL'),
('CRM', '1392285', 'Quinton', 'Svec', to_date('09/28/1987', 'MM-DD-YYYY'), '160 Belmont Ave', 'Garfield', 'NJ', '07026', 'US', 'quinton@svec.com', '973-772-6233', 'PROSPECT', NULL),
('CRM', '1392506', 'LaTonia', 'Williams', to_date('03/09/1991', 'MM-DD-YYYY'), '7600 Olde Eight Rd', 'Hudson', 'OH', '44236', 'US', 'latonia.williams@yahoo.com', '330-656-1030', 'CUSTOMER', 'HIGH'),
('CRM', '1392939', 'Stacy', 'Schettler', to_date('08/01/1979', 'MM-DD-YYYY'), '36 Exton St', 'South River', 'NJ', '08882', 'US', 'stacy@schettler.com', '732-254-0161', 'CUSTOMER', 'NORMAL'),
('CRM', '1393125', 'Jude', 'Warstler', to_date('09/30/1986', 'MM-DD-YYYY'), '205 Madison Ave', 'Scranton', 'PA', '18503', 'US', 'jude@warstler.com', '570-346-7206', 'PROSPECT', NULL),
('CRM', '1394755', 'Ken', 'Robaina', to_date('11/17/1977', 'MM-DD-YYYY'), '1455 91st Ave Ne', 'Minneapolis', 'MN', '55449', 'US', 'ken@robaina.com', '7637804712', 'PROSPECT', NULL),
('CRM', '1395755', 'Kenneth', 'Robaina', to_date('01/05/1986', 'MM-DD-YYYY'), '1455 91st Ave Ne', 'Minneapolis', 'MN', '55449', 'US', 'ken@robaina.com', '763-780-4712', 'PROSPECT', NULL),
('CRM', '1396755', 'Kenneth', 'Robaina', to_date('04/03/1972', 'MM-DD-YYYY'), '1455 91st Ave Ne', 'Minneapolis', 'MN', '55449', 'US', 'ken@robaina.com', '763-780-4712', 'PROSPECT', NULL),
('CRM', '1397271', 'Harlan', 'Semrad', to_date('08/29/1973', 'MM-DD-YYYY'), '459 River Rd', 'Bay City', 'MI', '48708', 'US', 'harlan@semrad.com', '989-893-3319', 'CUSTOMER', 'NORMAL'),
('CRM', '1398304', 'Curt', 'Cha', to_date('04/08/1986', 'MM-DD-YYYY'), '545 Chancellor Ave', 'Irvington', 'NJ', '07111', 'US', 'curtis@cha.com', '973-372-5969', 'CUSTOMER', NULL),
('CRM', '1398320', 'Jackson', 'Tea', to_date('05/09/1996', 'MM-DD-YYYY'), '50 Robbers Roost Ln', 'Cedar City', 'UT', '84720', 'US', 'jack@jtea.com', '435-865-5139', 'CUSTOMER', NULL),
('CRM', '1398375', 'Mark', 'Waters', to_date('06/15/1980', 'MM-DD-YYYY'), '2308 Bates Ave', 'Concord', 'CA', '94520', 'US', 'mark@markwaters.com', '925-682-6249', 'CUSTOMER', 'HIGH'),
('CRM', '1398396', 'Michelle', 'Garcia', to_date('03/18/1991', 'MM-DD-YYYY'), '4311 Puma Drive', 'Casper', 'WY', '82604', 'US', 'michelle@garcia.com', '307-577-9333', 'CUSTOMER', NULL),
('CRM', '1399446', 'Sara', 'Johnson', to_date('02/28/1994', 'MM-DD-YYYY'), '90 Mitchell Blvd #201', 'San Rafael', 'CA', '94903', 'US', 'saraj@yahoo.com', '415-472-3289', 'CUSTOMER', 'NORMAL'),
('CRM', '1399550', 'Dixie', 'Jackowiak', to_date('12/16/1983', 'MM-DD-YYYY'), '18017 Roseland Rd', 'Cleveland', 'OH', '44112', 'US', 'dixie@jackowiak.com', '216-531-6191', 'PROSPECT', NULL),
('CRM', '1399801', 'Jill', 'Guzzetta', to_date('11/13/1979', 'MM-DD-YYYY'), '44 Galloway Rd', 'Warwick', 'NY', '10990', 'US', 'jill@guzzetta.com', '986-1216', 'CUSTOMER', 'NORMAL'),
('CRM', '1400678', 'Frannie', 'Maggert', to_date('07/22/1972', 'MM-DD-YYYY'), '8000 Cooper Ave', 'Ridgewood', 'NY', '11385', 'US', 'fran@maggert.com', '718-894-8022', 'PROSPECT', NULL),
('CRM', '1402251', 'Araceli', 'Creecy', to_date('12/31/1899', 'MM-DD-YYYY'), '100 Federal Ave', 'Boston', 'MA', '02110', 'US', 'araceli@creecy.com', '527-4935', 'CUSTOMER', 'NORMAL'),
('CRM', '1402262', 'Louis', 'Kyle', to_date('05/23/1988', 'MM-DD-YYYY'), '9425 Stenton Ave', 'Philadelphia', 'PA', '19118', 'US', 'louis@kyle.com', '233-0367', 'CUSTOMER', 'HIGH'),
('CRM', '1403451', 'Chris', 'Ubaldo', to_date('01/26/1995', 'MM-DD-YYYY'), '6840 N Cutter Cir', 'Portland', 'OR', '97217', 'US', 'kris@ubaldo.com', '240-0223', 'PROSPECT', NULL),
('CRM', '1403605', 'Margarito', 'Winland', to_date('01/05/1982', 'MM-DD-YYYY'), '1856 Lombardy Dr', 'Rapid City', 'SD', '57701', 'US', 'margarito@winland.com', '348-4444', 'PROSPECT', NULL),
('CRM', '1404509', 'Alanna P.', 'Resides', to_date('05/25/1969', 'MM-DD-YYYY'), '4892 River St. #102', 'Detroit', 'MI', '48208', 'US', 'a@aresides.com', '898-2211', 'CUSTOMER', 'NORMAL'),
('CRM', '1405405', 'Linda', 'Bamfield', to_date('10/18/1981', 'MM-DD-YYYY'), '2094 White Plains Rd', 'Bronx', 'NY', '10462', 'US', 'lynda@bamfield.com', '347-430-2736', 'CUSTOMER', 'HIGH'),
('CRM', '1406729', 'angelica', 'aldaba', to_date('12/31/1899', 'MM-DD-YYYY'), '1427 Nw Davis St', 'Portland', 'OR', '67206', 'US', 'angelia@aldaba.com', '503.228.3027', 'CUSTOMER', 'NORMAL'),
('CRM', '1408146', 'Josef', 'Taulman', to_date('04/29/1989', 'MM-DD-YYYY'), '1620 Asheville Hwy', 'Hendersonville', 'NC', '28791', 'US', 'josef@taulman.com', '693-9775', 'PROSPECT', NULL),
('CRM', '1408293', 'J', 'Kososky', to_date('06/19/1989', 'MM-DD-YYYY'), '100 Wilshire Blvd #-500', 'Santa Monica', 'CA', '90401', 'US', 'j@kososky.com', '458-6371', 'CUSTOMER', 'NORMAL'),
('CRM', '1409489', 'Carroll', 'Spark', to_date('02/08/1992', 'MM-DD-YYYY'), '500 S Randall St', 'Rhome', 'TX', '76078', 'US', 'carroll@spark.com', '636-2216', 'CUSTOMER', NULL),
('CRM', '1410025', 'Dell', 'Tarka', to_date('02/24/1978', 'MM-DD-YYYY'), 'Kingsbury Squa', 'Zephyr Cove', 'NV', '89448', 'US', 'adele@tarka.com', '588-1343', 'PROSPECT', NULL),
('CRM', '1410141', 'Brett', 'Rave', to_date('02/05/1979', 'MM-DD-YYYY'), '2501 Wayzata Blvd', 'Minneapolis', 'MN', '55405', 'US', 'britt@rave.com', '377-6491', 'PROSPECT', NULL),
('CRM', '1412102', 'Robbin', 'Durham', to_date('12/27/1990', 'MM-DD-YYYY'), '105 W Superior St', 'Duluth', 'MN', '55802', 'US', 'robbin@durham.com', '720-7716', 'CUSTOMER', 'NORMAL'),
('CRM', '1412528', 'Migdalia', 'Tukuafa', to_date('07/19/1979', 'MM-DD-YYYY'), '215 E Hawaii Ave', 'Nampa', 'ID', '83686', 'US', 'migdalia@tukuafa.com', '465-9237', 'PROSPECT', NULL),
('CRM', '1418027', 'Gail', 'Taulman', to_date('12/10/1971', 'MM-DD-YYYY'), '5094 Westbrook Rd', 'Union City', 'GA', '30291', 'US', 'gail@taulman.com', '969-4377', 'PROSPECT', NULL),
('CRM', '1419718', 'Antonia', 'Mattos', to_date('07/01/1973', 'MM-DD-YYYY'), '3109 Main Ave', 'Melbourne', 'FL', '32901', 'US', 'toni@mattos.com', '727-6512', 'CUSTOMER', 'HIGH'),
('CRM', '1419728', 'Antonia', 'Mattos', to_date('07/01/1973', 'MM-DD-YYYY'), '3109 Main Ave', 'Melbourne', 'FL', '32901', 'US', 'toni@mattos.com', '(321)727-6512', 'CUSTOMER', 'HIGH'),
('CRM', '1419748', 'Toni', 'Mattos', to_date('07/01/1973', 'MM-DD-YYYY'), '3109 Main Ave', 'Melbourne', 'FL', '32901', 'US', 'toni@mattos.com', '321.727-.512', 'CUSTOMER', 'NORMAL'),
('CRM', '1421940', 'Prince', 'Schettler', to_date('03/28/1981', 'MM-DD-YYYY'), '412 Front St', 'Beaufort', 'NC', '28516', 'US', 'prince@schettler.com', '728-0135', 'CUSTOMER', 'NORMAL'),
('CRM', '1422294', 'Buford', 'Cacace', to_date('04/27/1973', 'MM-DD-YYYY'), '1030 Us Highway 46', 'Clifton', 'NJ', '07013', 'US', 'buford@cacace.com', '773-8628', 'PROSPECT', NULL),
('CRM', '1422971', 'Mark', 'Waters', to_date('06/15/1980', 'MM-DD-YYYY'), '2308 Bates Ave', 'Concord', 'CA', '94520', 'US', 'markwaters@gmail.com', '682-6249', 'CUSTOMER', 'HIGH'),
('CRM', '1423914', 'Clo', 'Anadio', to_date('10/08/1985', 'MM-DD-YYYY'), '114 N Main St', 'Mullica Hill', 'NJ', '08062', 'US', 'chloe@anadio.com', '478-4036', 'CUSTOMER', NULL),
('CRM', '1426631', 'Liza', 'Assante', to_date('12/03/1981', 'MM-DD-YYYY'), '8589 Darrow Rd', 'Twinsburg', 'OH', '44087', 'US', 'liza@assante.com', '425-7382', 'CUSTOMER', 'NORMAL'),
('CRM', '1428529', 'Chang', 'Svec', to_date('12/14/1989', 'MM-DD-YYYY'), '3416 S 48th St #-6', 'Phoenix', 'AZ', '85040', 'US', 'chang@svec.com', '968-2792', 'CUSTOMER', 'NORMAL'),
('CRM', '1429646', 'Huey', 'Gouker', to_date('10/27/1990', 'MM-DD-YYYY'), '100 Habersham Dr', 'Fayetteville', 'GA', '30214', 'US', 'huey@gouker.com', '461-4303', 'CUSTOMER', 'NORMAL'),
('CRM', '1433728', 'Saul', 'Rave', to_date('04/09/1986', 'MM-DD-YYYY'), '1500 N 13th St', 'Reading', 'PA', '19604', 'US', 'saul@rave.com', '484-375-7261', 'CUSTOMER', 'NORMAL'),
('CRM', '1434531', 'Lee', 'Coday', to_date('04/10/1982', 'MM-DD-YYYY'), '27324 Camino Capistrano #-153', 'Laguna Niguel', 'CA', '92677', 'US', 'levi@coday.com', '348-4985', 'CUSTOMER', 'NORMAL'),
('CRM', '1435348', 'Gail', 'Taulman', to_date('12/10/1971', 'MM-DD-YYYY'), '5094 Westbrook Rd', 'Union City', 'GA', '30291', 'US', 'gail@taulman.com', '969-4377', 'CUSTOMER', 'NORMAL'),
('CRM', '1436978', 'Deshawn', 'peters', to_date('12/31/1899', 'MM-DD-YYYY'), '125 Ne 1st Ave', 'Ocala', 'FL', '34470', 'US', 'd@pedrogo.com', '217.243.7667', 'CUSTOMER', 'NORMAL'),
('CRM', '1438474', 'Dianne', 'Kytle', to_date('09/07/1981', 'MM-DD-YYYY'), '3501 W Lake Rd', 'Abilene', 'TX', '79601', 'US', 'dianne@kytle.com', '325-672-6016', 'CUSTOMER', 'NORMAL'),
('CRM', '1438610', 'Nettie', 'Winland', to_date('10/14/1977', 'MM-DD-YYYY'), '222 N 3rd St', 'Yakima', 'WA', '98901', 'US', 'natalie@winland.com', '509-575-7812', 'CUSTOMER', 'NORMAL'),
('CRM', '1439057', 'Zack', 'Lessin', to_date('07/15/1990', 'MM-DD-YYYY'), '44800 Industrial Dr', 'Fremont', 'CA', '94538', 'US', 'zack@lessin.com', '510-657-4870', 'CUSTOMER', 'NORMAL'),
('CRM', '1439566', 'Reginald', 'Temores', to_date('12/12/1976', 'MM-DD-YYYY'), '402 Bna Dr', 'Nashville', 'TN', '37217', 'US', 'reggie@temores.com', '615-360-5493', 'CUSTOMER', 'NORMAL'),
('CRM', '1439594', 'Kathie', 'Kum', to_date('11/05/1980', 'MM-DD-YYYY'), '220 S Broadway', 'Rochester', 'MN', '55904', 'US', 'kathie@kum.com', '507-288-4102', 'PROSPECT', NULL),
('CRM', '1469708', 'Antonia', 'Mattos', to_date('07/01/1973', 'MM-DD-YYYY'), '3109 Main Ave', 'Melbourne', 'FL', '32901', 'US', 'toni@mattos.com', '321-727-6512', 'CUSTOMER', 'HIGH'),
('CRM', '1483060', 'Mary-ann', 'Markes', to_date('11/18/1993', 'MM-DD-YYYY'), '1200 Summer St #-103', 'Stamford', 'CT', '06905', 'US', 'maryann@markes.com', '203-967-5612', 'CUSTOMER', 'HIGH'),
('MKT', '1321830', 'Jass', 'Ellerbusch', to_date('12/11/1991', 'MM-DD-YYYY'), '73 S Hamilton Ave', 'Doylestown', 'PA', '18901', 'US', 'jass@ellerbusch.com', '215-348-5078', 'PROSPECT', NULL),
('MKT', '1351755', 'Billie', 'Pedro', to_date('01/31/1973', 'MM-DD-YYYY'), '419 N Cascade Ave', 'Colorado Springs', 'CO', '80903', 'US', 'billie@pedro.com', '303-288-4159', 'PROSPECT', NULL),
('MKT', '1352605', 'Cassie', 'Sandrowicz', to_date('01/19/1984', 'MM-DD-YYYY'), 'Howells Rd', 'Middletown', 'NY', '10640', 'US', 'carrie@sandrowicz.com', '845-344-5941', 'CUSTOMER', 'NORMAL'),
('MKT', '1353360', 'Linda', 'Pelham', to_date('08/21/1990', 'MM-DD-YYYY'), 'Old Hwy #-72', 'Cherokee', 'AL', '35818', 'US', 'melinda@pelham.com', '256-360-5870', 'PROSPECT', NULL),
('MKT', '1353826', 'Teri', 'Neundorfer', to_date('11/09/1983', 'MM-DD-YYYY'), '601 W Main #-815', 'Spokane', 'WA', '66201', 'US', 'teri@neundorfer.com', '509-838-6142', 'CUSTOMER', 'NORMAL'),
('MKT', '1354026', 'Willy', 'Okimoto', to_date('05/18/1990', 'MM-DD-YYYY'), '17 Hanover Rd', 'Florham Park', 'NJ', '07632', 'US', 'willy@okimoto.com', '973-822-8978', 'CUSTOMER', 'NORMAL'),
('MKT', '1355044', 'Lexi', 'Derer', to_date('07/20/1986', 'MM-DD-YYYY'), 'Rt 111', 'Hollis', 'NH', '03046', 'US', 'alexis@derer.com', '603-883-6221', 'CUSTOMER', 'NORMAL'),
('MKT', '1356294', 'Rey', 'Amason', to_date('12/16/1975', 'MM-DD-YYYY'), '3 Depot St', 'Wapakoneta', 'OH', '45665', 'US', 'rey@amason.com', '419-738-9241', 'CUSTOMER', 'HIGH'),
('MKT', '1356989', 'Lino', 'Sultaire', to_date('07/20/1986', 'MM-DD-YYYY'), '1400 N Woodward Ave #-200', 'Bloomfield Hills', 'MI', '46304', 'US', 'lino@sultaire.com', '248-647-7623', 'PROSPECT', NULL),
('MKT', '1357114', 'Latonia', 'Williams', to_date('07/18/1986', 'MM-DD-YYYY'), '7600 Olde Eight Rd', 'Hudson', 'OH', '44236', 'US', 'latonia.williams@yahoo.com', '330-656-1030', 'CUSTOMER', 'NORMAL'),
('MKT', '1358864', 'Evan', 'Cacace', to_date('12/12/1971', 'MM-DD-YYYY'), '1400 Old Country Rd', 'Westbury', 'NY', '11560', 'US', 'evan@cacace.com', '516-997-9354', 'CUSTOMER', 'NORMAL'),
('MKT', '1362223', 'Opal', 'Roecker', to_date('11/14/1975', 'MM-DD-YYYY'), '27 Washington', 'Westborough', 'MA', '01561', 'US', 'opal@roecker.com', '508-870-0435', 'PROSPECT', NULL),
('MKT', '1363038', 'Lois', 'Kyle', to_date('03/13/1972', 'MM-DD-YYYY'), '9425 Stenton Ave', 'Philadelphia', 'PA', NULL, 'US', 'lois@kyle.com', '215-233-0367', 'CUSTOMER', 'NORMAL'),
('MKT', '1363200', 'Karin', 'Camell', to_date('06/15/1975', 'MM-DD-YYYY'), 'Cedar', 'Mountain Grove', 'MO', NULL, 'US', 'karin@camell.com', '417-962-5985', 'PROSPECT', NULL),
('MKT', '1363548', 'Kenneth', 'Robaina', to_date('10/24/1996', 'MM-DD-YYYY'), '1455 91st Ave Ne', 'Minneapolis', 'MN', NULL, 'US', 'ken@robaina.com', '763-780-4712', 'PROSPECT', NULL),
('MKT', '1363938', 'Jake', 'Schettler', to_date('08/26/1979', 'MM-DD-YYYY'), '10400 Eaton Pl #-401', 'Fairfax', 'VA', NULL, 'US', 'jake@schettler.com', '703-591-4492', 'CUSTOMER', 'NORMAL'),
('MKT', '1364608', 'Rey', 'Amason', to_date('12/16/1975', 'MM-DD-YYYY'), '3 Depot St', 'Wapakoneta', 'OH', NULL, 'US', 'rey@amason.com', '419-738-9241', 'CUSTOMER', 'HIGH'),
('MKT', '1364655', 'Jeri', 'Willer', to_date('07/19/1985', 'MM-DD-YYYY'), '1660 S Albion St', 'Denver', 'CO', NULL, 'US', 'jeri@willer.com', '303-753-2153', 'PROSPECT', NULL),
('MKT', '1364815', 'Chuck', 'Mattos', to_date('09/11/1985', 'MM-DD-YYYY'), '137 Farnsworth Ave', 'Bordentown', 'NJ', NULL, 'US', 'charlie@mattos.com', '609-298-3130', 'CUSTOMER', 'NORMAL'),
('MKT', '1366323', 'Ed', 'Markes', to_date('06/11/1970', 'MM-DD-YYYY'), '2444 Madison Rd', 'Cincinnati', 'OH', NULL, 'US', 'elisa@markes.com', '513-871-6770', 'CUSTOMER', 'NORMAL'),
('MKT', '1367021', 'Nelly', 'Graniela', to_date('03/09/1991', 'MM-DD-YYYY'), '925 L Ave', 'Sacramento', 'CA', '95814', 'US', 'e@graniela.com', '916-442-88', 'PROSPECT', NULL),
('MKT', '1367261', 'Fran', 'Sahagun', to_date('11/17/1981', 'MM-DD-YYYY'), '220 S 6th Ave', 'Minneapolis', 'MN', '55402', 'US', 'francine@sahagun.com', '612-340-7052', 'CUSTOMER', 'NORMAL'),
('MKT', '1367501', 'Shanna', 'Seyfarth', to_date('08/01/1970', 'MM-DD-YYYY'), '631 Grove Ave', 'Jersey City', 'NJ', '07310', 'US', 'shanna@seyfarth.com', '201-659-6516', 'PROSPECT', NULL),
('MKT', '1368178', 'Nola', 'Girvan', to_date('04/10/1980', 'MM-DD-YYYY'), '1620 Paonia Ave', 'Colorado Springs', 'CO', '80915', 'US', 'nola@girvan.com', '719-574-6245', 'CUSTOMER', 'NORMAL'),
('MKT', '1370265', 'Betsy', 'Pravata', to_date('12/12/1987', 'MM-DD-YYYY'), '7230 Woodland Dr', 'Indianapolis', 'IN', '46278', 'US', 'betsy@pravata.com', '630-801-2462', 'PROSPECT', NULL),
('MKT', '1372469', 'Billie', 'Balliew', to_date('12/09/1975', 'MM-DD-YYYY'), '166 Boulder Dr', 'Fitchburg', 'MA', '01420', 'US', 'billie@balliew.com', '508-548-4717', 'PROSPECT', NULL),
('MKT', '1372958', 'Leann', 'Creecy', to_date('03/17/1974', 'MM-DD-YYYY'), '3850 W 20th Ave', 'Cleveland', 'OH', '44109', 'US', 'leann@creecy.com', '216-749-0767', 'CUSTOMER', 'NORMAL'),
('MKT', '1373514', 'Aida', 'James', to_date('05/01/1994', 'MM-DD-YYYY'), '1200 Main Ave', 'Kansas City', 'MO', '64105', 'US', 'aida@neundorfer.com', '374-9387', 'PROSPECT', NULL),
('MKT', '1373598', 'Bryon', 'Ubaldo', to_date('08/09/1994', 'MM-DD-YYYY'), '1922 S Laredo St', 'San Antonio', 'TX', '78207', 'US', 'bryon@ubaldo.com', '210-436-9996', 'CUSTOMER', 'NORMAL'),
('MKT', '1374096', 'Claudine', 'Hudy', to_date('08/03/1988', 'MM-DD-YYYY'), '1540 S 21st Ave', 'Colorado Springs', 'CO', '80904', 'US', 'claudine@hudy.com', '719-633-3092', 'CUSTOMER', 'NORMAL'),
('MKT', '1374707', 'Alanna', 'Glasser', to_date('12/31/1899', 'MM-DD-YYYY'), '4892 River', 'DETROIT', 'Michigan', ' ', NULL, 'a@aresides.com', '618-594-3207', 'CUSTOMER', 'NORMAL'),
('MKT', '1374829', 'Prince', 'Anadio', to_date('07/18/1988', 'MM-DD-YYYY'), '100 Boxart Ave', 'Rochester', 'NY', '14612', 'US', 'prince@anadio.com', '585-663-6442', 'PROSPECT', NULL),
('MKT', '1375542', 'Cheri', 'Defiguero', to_date('02/16/1973', 'MM-DD-YYYY'), '2844 Fresno Ave', 'Fresno', 'CA', '93721', 'US', 'cheri@defiguero.com', '559-486-5603', 'CUSTOMER', 'NORMAL'),
('MKT', '1375653', 'Lino', 'Maggert', to_date('11/30/1978', 'MM-DD-YYYY'), '6 Beacon Ave', 'Boston', 'MA', '02108', 'US', 'lino@maggert.com', '617-227-6545', 'PROSPECT', NULL),
('MKT', '1375815', 'Florencio', 'Michna', to_date('05/17/1990', 'MM-DD-YYYY'), '201 S Main Ave', 'Salt Lake City', 'UT', '84111', 'US', 'florencio@michna.com', '801-536-1091', 'CUSTOMER', 'NORMAL'),
('MKT', '1376216', 'Ashleigh', 'Schiveley', to_date('01/29/1997', 'MM-DD-YYYY'), '8 Commercial Ave', 'Medford', 'NY', '11763', 'US', 'ashleigh@missel.com', '716-372-9571', 'PROSPECT', NULL),
('MKT', '1376987', 'Vernice', 'Southwood', to_date('10/22/1987', 'MM-DD-YYYY'), '8 Commercial Ave', 'Medford', 'NY', '11763', 'US', 'vernice@southwood.com', '631-698-8293', 'PROSPECT', NULL),
('MKT', '1377623', 'Edward', 'Michaels', to_date('06/09/1979', 'MM-DD-YYYY'), '3601 N Lincoln Ave', 'Oklahoma City', 'OK', '73105', 'US', 'emily@gouker.com', '405-524-6481', 'CUSTOMER', 'NORMAL'),
('MKT', '1378547', 'Tonya', 'Joehnck', to_date('01/21/1993', 'MM-DD-YYYY'), '30 7th St E #-510', 'Saint Paul', 'MN', '55101', 'US', 'tonya@joehnck.com', '651-298-9175', 'CUSTOMER', 'NORMAL'),
('MKT', '1378817', 'Patty', 'Mitchen', to_date('04/19/1980', 'MM-DD-YYYY'), '220 Park Ave S', 'Saint Cloud', 'MN', '56301', 'US', 'martha@mitchen.com', '320-251-3787', 'CUSTOMER', 'NORMAL'),
('MKT', '1379005', 'Mark', 'Waters', to_date('06/15/1980', 'MM-DD-YYYY'), '2308 Bates Ave', 'Concord', 'CA', '94520', 'US', 'mark@markwaters.com', '925-682-6249', 'CUSTOMER', 'NORMAL'),
('MKT', '1379404', 'Emily', 'Michaels', to_date('05/09/1983', 'MM-DD-YYYY'), '108 W Randolph Ave', 'Enid', 'OK', '73701', 'US', 'emily@gouker.com', '580-233-9834', 'CUSTOMER', 'NORMAL'),
('MKT', '1379537', 'David', 'Camell', to_date('07/01/1989', 'MM-DD-YYYY'), '4 E 8th St #-200', 'Wilmington', 'DE', '19801', 'US', 'dave@camell.com', '302-655-4884', 'PROSPECT', NULL),
('MKT', '1379608', 'Harry', 'Masters', to_date('04/13/1971', 'MM-DD-YYYY'), '7220 Woodland Drive', 'Indianapolis', 'IN', '46278', 'US', 'harry@icloudnet.com', '317-290-2614', 'PROSPECT', NULL),
('MKT', '1380531', 'Carol', 'Lapalme', to_date('03/26/1991', 'MM-DD-YYYY'), '4910 Departure Dr', 'Raleigh', 'NC', '27605', 'US', 'carol.lapalme@yahoo.com', '919-876-7612', 'CUSTOMER', 'NORMAL'),
('MKT', '1380884', 'R', 'Mares', to_date('05/09/1983', 'MM-DD-YYYY'), '220090 S 7th St', 'Minneapolis', 'MN', '55402', 'US', 'reinaldo@mares.com', '612-336-4873', 'PROSPECT', NULL),
('MKT', '1381567', 'Earnestine', 'Waetzig', to_date('02/25/1992', 'MM-DD-YYYY'), '16161 Brookpark Rd', 'Brook Park', 'OH', '44142', 'US', 'earnestine@waetzig.com', '216-267-1844', 'CUSTOMER', 'NORMAL'),
('MKT', '1381582', 'Mary-Ann', 'Markes', to_date('12/31/1899', 'MM-DD-YYYY'), '1200 Summer St #-103', 'Stamford', 'CT', '06905', 'US', 'maryann@markes.com', '203-967-5612', 'CUSTOMER', 'NORMAL'),
('MKT', '1381873', 'Omer', 'Averhart', to_date('01/09/1981', 'MM-DD-YYYY'), '400 Capitol Mall', 'Sacramento', 'CA', '95814', 'US', 'omer@averhart.com', '916-927-6221', 'CUSTOMER', 'NORMAL'),
('MKT', '1382583', 'Aimee', 'Singh', to_date('09/28/1987', 'MM-DD-YYYY'), '2211 Parsons Ave', 'Columbus', 'OH', '43207', 'US', 'aimee@pulkrabek.com', '614-445-5812', 'PROSPECT', NULL),
('MKT', '1382655', 'Latonya', 'Odegard', to_date('03/09/1991', 'MM-DD-YYYY'), '4499 Ruffin Rd', 'San Diego', 'CA', '92123', 'US', 'latonya@odegard.com', '858-277-6570', 'CUSTOMER', 'HIGH'),
('MKT', '1383342', 'Zay', 'Hendel', to_date('09/03/1976', 'MM-DD-YYYY'), '2332 E Division St', 'Springfield', 'MO', '65803', 'US', 'isaiah@hendel.com', '417-864-1286', 'CUSTOMER', 'NORMAL'),
('MKT', '1385863', 'Mario', 'Averhart', to_date('01/05/1986', 'MM-DD-YYYY'), '111 Lyon St Nw', 'Grand Rapids', 'MI', '49503', 'US', 'mario@averhart.com', '752-3959', 'CUSTOMER', 'NORMAL'),
('MKT', '1386889', 'Porfirio', 'Creecy', to_date('05/24/1976', 'MM-DD-YYYY'), '1440 Poplar Ave', 'Memphis', 'TN', '38104', 'US', 'porfirio@creecy.com', '901-272-9572', 'PROSPECT', NULL),
('MKT', '1386998', 'Jack', 'Guzzetta', to_date('08/05/1985', 'MM-DD-YYYY'), 'Rr 1', 'Lawsonville', 'NC', '27022', 'US', NULL, '336-871-7622', 'PROSPECT', NULL),
('MKT', '1387000', 'Franklin', 'Pappan', to_date('04/08/1986', 'MM-DD-YYYY'), '5 Post Oak Park', 'Houston', 'TX', '77027', 'US', 'frank@pappan.com', '713-961-3153', 'PROSPECT', NULL),
('MKT', '1387710', 'Sandra', 'Lessin', to_date('01/30/1985', 'MM-DD-YYYY'), '401 B St', 'San Diego', 'CA', '92101', 'US', 'alexandria@lessin.com', '619-687-1471', 'PROSPECT', NULL),
('MKT', '1388393', 'Jose', 'Gumm', to_date('12/04/1978', 'MM-DD-YYYY'), '198 S 2nd Ave', 'Piggott', 'AR', '72454', 'US', 'jose@gumm.com', '870-598-1132', 'PROSPECT', NULL),
('MKT', '1388559', 'Lana', 'Ramming', to_date('02/17/1986', 'MM-DD-YYYY'), '2930 Carol Rd', 'York', 'PA', '17402', 'US', 'lana@ramming.com', '717-840-9610', 'PROSPECT', NULL),
('MKT', '1388757', 'Moises', 'Lessin', to_date('12/16/1983', 'MM-DD-YYYY'), '3703 W Highway 14', 'Owatonna', 'MN', '55060', 'US', 'moises@lessin.com', '507-451-6685', 'PROSPECT', NULL),
('MKT', '1389085', 'Bennie', 'Lessin', to_date('11/17/1981', 'MM-DD-YYYY'), '200 A St', 'Crescent City', 'CA', '95531', 'US', 'bennie@lessin.com', '661-324-1207', 'CUSTOMER', 'NORMAL'),
('MKT', '1389913', 'Claudine', 'Coday', to_date('06/17/1977', 'MM-DD-YYYY'), 'Exit #-21', 'Stevens', 'PA', '17578', 'US', 'claudine@coday.com', '717-336-5449', 'CUSTOMER', 'NORMAL'),
('MKT', '1392031', 'T', 'Polacek', to_date('08/05/1989', 'MM-DD-YYYY'), '1100 Alakea St #-12', 'Honolulu', 'HI', '96813', 'US', 'terri@polacek.com', '808-237-6644', 'CUSTOMER', 'NORMAL'),
('MKT', '1392625', 'Viv', 'Jackowiak', to_date('12/31/1899', 'MM-DD-YYYY'), '1320 Hodges St', 'Raleigh', 'NC', '27604', 'US', 'vivian@jackowiak.com', '919-832-9928', 'PROSPECT', NULL),
('MKT', '1393026', 'Cari', 'Isaacson', to_date('09/03/1976', 'MM-DD-YYYY'), '820 Lester Ave', 'Saint Joseph', 'MI', '49085', 'US', 'cari@isaacson.com', '269-983-2318', 'CUSTOMER', 'NORMAL'),
('MKT', '1393927', 'Fred', 'Tarka', to_date('02/17/1973', 'MM-DD-YYYY'), 'Box #-34506', 'Houston', 'TX', '77234', 'US', 'willie@tarka.com', '713-731-5570', 'PROSPECT', NULL),
('MKT', '1394793', 'Isiah', 'Durham', to_date('09/04/1991', 'MM-DD-YYYY'), '7427 Arlington Rd', 'Bethesda', 'MD', '20814', 'US', 'isiah@durham.com', '301-986-1395', 'CUSTOMER', 'NORMAL'),
('MKT', '1395419', 'Federico', 'Popp', to_date('05/10/1984', 'MM-DD-YYYY'), '419 N Cascade Ave', 'Colorado Springs', 'CO', '80903', 'US', 'federico@popp.com', '719-635-5347', 'CUSTOMER', 'NORMAL'),
('MKT', '1396700', 'Ross', 'Glueckert', to_date('03/31/1984', 'MM-DD-YYYY'), '1106 E 3rd St', 'Dayton', 'OH', '45402', 'US', 'ross@glueckert.com', '937-228-3007', 'CUSTOMER', 'NORMAL'),
('MKT', '1396727', 'Dustin', 'Hysmith', to_date('09/06/1976', 'MM-DD-YYYY'), '6371 Burnt Poplar Rd', 'Greensboro', 'NC', '27409', 'US', 'dustin@hysmith.com', '336-852-6077', 'CUSTOMER', 'NORMAL'),
('MKT', '1397394', 'O', 'Tukuafa', to_date('05/24/1976', 'MM-DD-YYYY'), '6805 Capitol Hwy #-32', 'Austin', 'TX', '78731', 'US', 'octavio@tukuafa.com', '512-327-8399', 'CUSTOMER', 'NORMAL'),
('MKT', '1398218', 'Mohammed', 'Mikell', to_date('08/05/1985', 'MM-DD-YYYY'), 'Box #-1092', 'Crescent City', 'CA', '95531', 'US', 'mohammed@mikell.com', '707-464-9425', 'CUSTOMER', 'NORMAL'),
('MKT', '1398717', 'Justina', 'Ubaldo', to_date('01/30/1985', 'MM-DD-YYYY'), '320 W Front St', 'Media', 'PA', '19063', 'US', 'justina@ubaldo.com', '610-565-9373', 'CUSTOMER', 'NORMAL'),
('MKT', '1398731', 'Marlene', 'Hilgeman', to_date('09/20/1982', 'MM-DD-YYYY'), '300 S 4th St #-1700', 'Las Vegas', 'NV', '89101', 'US', 'marlene@hilgeman.com', '383-2994', 'PROSPECT', NULL),
('MKT', '1398789', 'Leopoldo', 'Michna', to_date('10/06/1986', 'MM-DD-YYYY'), '166 Boulder Dr', 'Fitchburg', 'MA', '01420', 'US', 'leopoldo@michna.com', '978-343-6343', 'CUSTOMER', 'NORMAL'),
('MKT', '1398995', 'Henry', 'Masters', to_date('12/04/1978', 'MM-DD-YYYY'), '7220 Woodland Dr', 'Indianapolis', 'IN', '46278', 'US', 'harry@icloudnet.com', '317-290-2614', 'PROSPECT', NULL),
('MKT', '1399171', 'Francesco', 'Roecker', to_date('02/17/1986', 'MM-DD-YYYY'), '334 Us Highway 46', 'Wayne', 'NJ', '07470', 'US', 'francesco@roecker.com', '973-890-9344', 'CUSTOMER', 'NORMAL'),
('MKT', '1399642', 'Emilie', 'Svec', to_date('09/05/1982', 'MM-DD-YYYY'), '2222 W Grandview Blvd', 'Erie', 'PA', '16506', 'US', 'emilie@svec.com', '814-833-6073', 'PROSPECT', NULL),
('MKT', '1399854', 'Tammi', 'Eilert', to_date('11/17/1981', 'MM-DD-YYYY'), '425 Maluniu Ave #-b', 'Kailua', 'HI', '96734', 'US', 'tammi@eilert.com', '808-263-1923', 'PROSPECT', NULL),
('MKT', '1401213', 'Juliana', 'Quimby', to_date('06/17/1977', 'MM-DD-YYYY'), '615 Franklin Tpke', 'Ridgewood', 'NJ', '07450', 'US', 'juliana@quimby.com', '201.444.6741', 'PROSPECT', NULL),
('MKT', '1404880', 'John', 'Edelman', to_date('09/03/1976', 'MM-DD-YYYY'), '591 Redwood Hwy #-1200', 'Mill Valley', 'CA', '94941', 'US', 'john@jedelman.com', '415.381.9176', 'CUSTOMER', 'NORMAL'),
('MKT', '1405814', 'Tina', 'Poitier', to_date('04/01/1980', 'MM-DD-YYYY'), '2571 Timber Ln', 'Dayton', 'OH', '45414', 'US', 'christine@poitier.com', '277-1814', 'PROSPECT', NULL),
('MKT', '1406654', 'Dana', 'Missel', to_date('02/10/1987', 'MM-DD-YYYY'), '2445 M St Nw', 'Washington', 'DC', '20037', 'US', 'dana@missel.com', '663-4512', 'PROSPECT', NULL),
('MKT', '1408222', 'Eldon', 'Lolli', to_date('09/27/1997', 'MM-DD-YYYY'), '8350 E Mcdonald Dr', 'Scottsdale', 'AZ', '85250', 'US', 'eldon@lolli.com', '443-6788', 'CUSTOMER', 'NORMAL'),
('MKT', '1409121', 'Nonie', 'Pete', to_date('04/01/1979', 'MM-DD-YYYY'), '313 Price Pl', 'Madison', 'WI', '53705', 'US', 'nora@pete.com', '231-6751', 'CUSTOMER', 'NORMAL'),
('MKT', '1409934', 'Sara', 'Johnson', to_date('10/17/1997', 'MM-DD-YYYY'), '90 Mitchell Boulevard', 'San Rafael', 'CA', '94903', 'US', 'saraj@yahoo.com', '472-3289', 'CUSTOMER', 'NORMAL'),
('MKT', '1410024', 'Homer', 'Southwood', to_date('06/01/1995', 'MM-DD-YYYY'), '1430 N Meacham Rd', 'Schaumburg', 'IL', '60173', 'US', 'homer@southwood.com', '884-7511', 'CUSTOMER', 'NORMAL'),
('MKT', '1412252', 'Alice', 'Shabazz', to_date('09/12/1985', 'MM-DD-YYYY'), '16 S Ketcham Ave', 'Amityville', 'NY', '11701', 'US', 'alyce@shabazz.com', '691-6477', 'PROSPECT', NULL),
('MKT', '1413179', 'Jude', 'Warstler', to_date('10/24/1975', 'MM-DD-YYYY'), '205 Madison Ave', 'Scranton', 'PA', '18503', 'US', 'jude@warstler.com', '346-7206', 'PROSPECT', NULL),
('MKT', '1413527', 'Daron', 'Seyfarth', to_date('09/25/1991', 'MM-DD-YYYY'), '1211 Sw 5th Ave', 'Portland', 'OR', '97204', 'US', 'daron@seyfarth.com', '796-4738', 'CUSTOMER', 'NORMAL'),
('MKT', '1414505', 'Jarod', 'Mercury', to_date('10/21/1995', 'MM-DD-YYYY'), '5901 N Western Ave', 'Oklahoma City', 'OK', '73118', 'US', 'jarod@mercury.com', '2907', 'CUSTOMER', 'NORMAL'),
('MKT', '1416366', 'Saul', 'Rave', to_date('04/19/1986', 'MM-DD-YYYY'), '1500 N 13th St', 'Reading', 'PA', '19604', 'US', 'saul@rave.com', '(484) 375-7261', 'CUSTOMER', 'NORMAL'),
('MKT', '1420684', 'Delmar', 'Quimby', to_date('08/03/1981', 'MM-DD-YYYY'), '212 W Gibson Dr', 'Greenville', 'MI', '48838', 'US', 'delmar@quimby.com', '754-6715', 'CUSTOMER', 'NORMAL'),
('MKT', '1422861', 'Lynda', 'Bamfield', to_date('10/18/1981', 'MM-DD-YYYY'), '2094 White Plains Rd', 'Bronx', 'NY', '10462', 'US', 'lynda@bamfield.com', '3474302736', 'CUSTOMER', 'HIGH'),
('MKT', '1424076', 'Burl', 'Maggert', to_date('02/09/1993', 'MM-DD-YYYY'), '129 Lockwood St', 'Newark', 'NJ', '07105', 'US', 'burl@maggert.com', '589-0421', 'PROSPECT', NULL),
('MKT', '1425005', 'Toni', 'Mattos', to_date('07/01/1973', 'MM-DD-YYYY'), '3109 Main St', 'Melborne', 'FL', '32901', 'US', 'toni@mattos.com', '727-6512', 'CUSTOMER', 'NORMAL'),
('MKT', '1425478', 'Josef', 'Taulman', to_date('04/29/1989', 'MM-DD-YYYY'), '1620 Asheville Hwy', 'Hendersonville', 'NC', '28791', 'US', 'josef@taulman.com', '693-9775', 'CUSTOMER', 'NORMAL'),
('MKT', '1427534', 'mike', 'larue', to_date('11/17/1977', 'MM-DD-YYYY'), '109 N Mayo St', 'Americus', 'GA', '31709', 'US', 'mikelarue@amason.com', '229 924-2487', 'CUSTOMER', 'HIGH'),
('MKT', '1428866', 'Shauna', 'Ellerbusch', to_date('03/18/1985', 'MM-DD-YYYY'), '1042 Ih 35 E', 'New Braunfels', 'TX', '78130', 'US', 'shauna@ellerbusch.com', '2591', 'CUSTOMER', 'NORMAL'),
('MKT', '1429319', 'Oscar', 'Graniela', to_date('03/22/1990', 'MM-DD-YYYY'), '6905 E Us Highway 87', 'San Antonio', 'TX', '78263', 'US', 'oscar@graniela.com', '648-7659', 'CUSTOMER', 'NORMAL'),
('MKT', '1429729', 'Cissy', 'Hysmith', to_date('09/26/1983', 'MM-DD-YYYY'), '3200 W Market St #-108', 'Akron', 'OH', '44333', 'US', 'cecilia@hysmith.com', '864-0619', 'PROSPECT', NULL),
('MKT', '1432608', 'Merle', 'Cha', to_date('11/26/1986', 'MM-DD-YYYY'), '450 S Australian Ave', 'West Palm Beach', 'FL', '33401', 'US', 'merle@cha.com', '832-1820', 'PROSPECT', NULL),
('MKT', '1433965', 'Ronnie', 'Ellerbusch', to_date('06/02/1995', 'MM-DD-YYYY'), '1126 17th Ave', 'Monroe', 'WI', '53566', 'US', 'ron@ellerbusch.com', '325-2068', 'CUSTOMER', 'NORMAL'),
('MKT', '1438732', 'Callie', 'Aldaba', to_date('09/06/1976', 'MM-DD-YYYY'), '2151 River Plaza Dr #-105', 'Sacramento', 'CA', '95833', 'US', 'callie@aldaba.com', '916-567-4449', 'CUSTOMER', 'NORMAL')
) AS stg(b_pubid, b_sourceid, first_name, last_name, date_of_birth, addstreet, addcity, addstate, addpostal_code, addcountry, source_email, source_phone, person_type, value_status)
WHERE NOT EXISTS (
SELECT 1
FROM semarchy_customer_b2c_mdm.sd_person dest
WHERE dest.b_sourceid = stg.b_sourceid
and dest.b_pubid = stg.b_pubid
/* duplicate data detection */
AND COALESCE(dest.first_name, '') = COALESCE(stg.first_name, '')
AND COALESCE(dest.last_name, '') = COALESCE(stg.last_name, '')
AND dest.date_of_birth = stg.date_of_birth
AND COALESCE(dest.addstreet, '') = COALESCE(stg.addstreet, '')
AND COALESCE(dest.addcity, '') = COALESCE(stg.addcity, '')
AND COALESCE(dest.addstate, '') = COALESCE(stg.addstate, '')
AND COALESCE(dest.addcountry, '') = COALESCE(stg.addcountry, '')
AND COALESCE(dest.source_email, '') = COALESCE(stg.source_email, '')
AND COALESCE(dest.source_phone, '') = COALESCE(stg.source_phone, '')
AND COALESCE(dest.person_type, '') = COALESCE(stg.person_type, '')
AND COALESCE(dest.value_status, '') = COALESCE(stg.value_status, '')
);
COMMIT;