JFwwG5g0

1IF EXISTS (SELECT NAME  FROM SYS.TABLES  WHERE NAME = 'CONNECT_EXTABLE_LIST')
2Drop table CONNECT_EXTABLE_LIST
3GO
4CREATE TABLE CONNECT_EXTABLE_LIST
5    (
6    CEL_TABLE_NAME VARCHAR(50),
7    CEL_EXCLUDED_BY VARCHAR(100),
8    CEL_EXCLUDED_REASON VARCHAR(2000),
9    CEL_EXCLUDED_DATE DATETIME DEFAULT(GETDATE()),
10    CEL_AUTO_ID INT IDENTITY(1,1),
11    TIMESTAMP TIMESTAMP
12    )
13GO
14
15
16IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'AccHoldChequeDetails') BEGIN
17
18     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
19     VALUES ('AccHoldChequeDetails', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
20
21END
22
23GO
24
25IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'AccHoldPending') BEGIN
26
27     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
28     VALUES ('AccHoldPending', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
29
30END
31
32GO
33
34IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'AccHoldVoucher') BEGIN
35
36     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
37     VALUES ('AccHoldVoucher', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
38
39END
40
41GO
42
43IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'AccHoldVoucherBeneficiaryDtl') BEGIN
44
45     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
46     VALUES ('AccHoldVoucherBeneficiaryDtl', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
47
48END
49
50GO
51
52IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'ajax_view_defn') BEGIN
53
54     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
55     VALUES ('ajax_view_defn', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
56
57END
58
59GO
60
61IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'appl_lang') BEGIN
62
63     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
64     VALUES ('appl_lang', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
65
66END
67
68GO
69
70IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'appl_resource_detail') BEGIN
71
72     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
73     VALUES ('appl_resource_detail', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
74
75END
76
77GO
78
79IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'appl_resource_master') BEGIN
80
81     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
82     VALUES ('appl_resource_master', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
83
84END
85
86GO
87
88IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'auto_trigger_config_dtl') BEGIN
89
90     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
91     VALUES ('auto_trigger_config_dtl', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
92
93END
94
95GO
96
97IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'auto_trigger_config_hdr') BEGIN
98
99     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
100     VALUES ('auto_trigger_config_hdr', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
101
102END
103
104GO
105
106IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'business_formula') BEGIN
107
108     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
109     VALUES ('business_formula', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
110
111END
112
113GO
114
115IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'catalog_item_mast') BEGIN
116
117     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
118     VALUES ('catalog_item_mast', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
119
120END
121
122GO
123
124IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'catalog_local_item_map') BEGIN
125
126     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
127     VALUES ('catalog_local_item_map', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
128
129END
130
131GO
132
133IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'catalog_mfr_mast') BEGIN
134
135     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
136     VALUES ('catalog_mfr_mast', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
137
138END
139
140GO
141
142IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'catalog_version_mast') BEGIN
143
144     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
145     VALUES ('catalog_version_mast', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
146
147END
148
149GO
150
151IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'CONNECT_EXTABLE_LIST') BEGIN
152
153     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
154     VALUES ('CONNECT_EXTABLE_LIST', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
155
156END
157
158GO
159
160IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'CONNECT_FSTABLE_LIST') BEGIN
161
162     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
163     VALUES ('CONNECT_FSTABLE_LIST', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
164
165END
166
167GO
168
169IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'CONNECT_PATCH_INSERT_TABLES') BEGIN
170
171     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
172     VALUES ('CONNECT_PATCH_INSERT_TABLES', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
173
174END
175
176GO
177
178IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'connect_patch_timestamp') BEGIN
179
180     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
181     VALUES ('connect_patch_timestamp', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
182
183END
184
185GO
186
187IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'connect_patch_update_tables') BEGIN
188
189     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
190     VALUES ('connect_patch_update_tables', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
191
192END
193
194GO
195
196IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'CONNECT_TABLE_LIST') BEGIN
197
198     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
199     VALUES ('CONNECT_TABLE_LIST', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
200
201END
202
203GO
204
205IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'connect_unsynced_records') BEGIN
206
207     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
208     VALUES ('connect_unsynced_records', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
209
210END
211
212GO
213
214IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'country_master') BEGIN
215
216     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
217     VALUES ('country_master', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
218
219END
220
221GO
222
223IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'db_patch_hdr') BEGIN
224
225     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
226     VALUES ('db_patch_hdr', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
227
228END
229
230GO
231
232IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'dbpatch_check_info') BEGIN
233
234     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
235     VALUES ('dbpatch_check_info', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
236
237END
238
239GO
240
241IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'dsname_info') BEGIN
242
243     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
244     VALUES ('dsname_info', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
245
246END
247
248GO
249
250IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'Dual') BEGIN
251
252     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
253     VALUES ('Dual', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
254
255END
256
257GO
258
259IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'gft_save_queries') BEGIN
260
261     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
262     VALUES ('gft_save_queries', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
263
264END
265
266GO
267
268IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'gst_2a_imports') BEGIN
269
270     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
271     VALUES ('gst_2a_imports', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
272
273END
274
275GO
276
277IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'gst_2a_inv_wise_pur_dtl') BEGIN
278
279     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
280     VALUES ('gst_2a_inv_wise_pur_dtl', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
281
282END
283
284GO
285
286IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'gst_tfa_version_audit') BEGIN
287
288     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
289     VALUES ('gst_tfa_version_audit', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
290
291END
292
293GO
294
295IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'GSTLedgerMappingDefaultData') BEGIN
296
297     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
298     VALUES ('GSTLedgerMappingDefaultData', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
299
300END
301
302GO
303
304IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'gstreasoncodemaster') BEGIN
305
306     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
307     VALUES ('gstreasoncodemaster', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
308
309END
310
311GO
312
313IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'hq_email_config') BEGIN
314
315     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
316     VALUES ('hq_email_config', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
317
318END
319
320GO
321
322IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'hq_email_out') BEGIN
323
324     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
325     VALUES ('hq_email_out', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
326
327END
328
329GO
330
331IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'hq_jasp_prop') BEGIN
332
333     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
334     VALUES ('hq_jasp_prop', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
335
336END
337
338GO
339
340IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'hq_process_pwd') BEGIN
341
342     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
343     VALUES ('hq_process_pwd', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
344
345END
346
347GO
348
349IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'hq_related_report') BEGIN
350
351     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
352     VALUES ('hq_related_report', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
353
354END
355
356GO
357
358IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'item_favorites') BEGIN
359
360     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
361     VALUES ('item_favorites', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
362
363END
364
365GO
366
367IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'jasper_config') BEGIN
368
369     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
370     VALUES ('jasper_config', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
371
372END
373
374GO
375
376IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'jasper_report') BEGIN
377
378     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
379     VALUES ('jasper_report', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
380
381END
382
383GO
384
385IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'kitchen_setup_dtl') BEGIN
386
387     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
388     VALUES ('kitchen_setup_dtl', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
389
390END
391
392GO
393
394IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'kitchen_setup_hdr') BEGIN
395
396     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
397     VALUES ('kitchen_setup_hdr', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
398
399END
400
401GO
402
403IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'kitchen_setup_locations') BEGIN
404
405     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
406     VALUES ('kitchen_setup_locations', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
407
408END
409
410GO
411
412IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'LAYOUT_FIELDS') BEGIN
413
414     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
415     VALUES ('LAYOUT_FIELDS', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
416
417END
418
419GO
420
421IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'map_terminal') BEGIN
422
423     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
424     VALUES ('map_terminal', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
425
426END
427
428GO
429
430IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'mauth_exempt') BEGIN
431
432     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
433     VALUES ('mauth_exempt', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
434
435END
436
437GO
438
439IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'med_backup_sequence') BEGIN
440
441     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
442     VALUES ('med_backup_sequence', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
443
444END
445
446GO
447
448IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'med_report_buttons') BEGIN
449
450     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
451     VALUES ('med_report_buttons', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
452
453END
454
455GO
456
457IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'med_report_column_group') BEGIN
458
459     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
460     VALUES ('med_report_column_group', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
461
462END
463
464GO
465
466IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'med_report_diagnosis') BEGIN
467
468     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
469     VALUES ('med_report_diagnosis', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
470
471END
472
473GO
474
475IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'med_report_header_dtl') BEGIN
476
477     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
478     VALUES ('med_report_header_dtl', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
479
480END
481
482GO
483
484IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'med_report_props') BEGIN
485
486     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
487     VALUES ('med_report_props', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
488
489END
490
491GO
492
493IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'med_report_unote_grade') BEGIN
494
495     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
496     VALUES ('med_report_unote_grade', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
497
498END
499
500GO
501
502IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'med_report_unote_impact') BEGIN
503
504     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
505     VALUES ('med_report_unote_impact', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
506
507END
508
509GO
510
511IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'med_report_unote_status') BEGIN
512
513     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
514     VALUES ('med_report_unote_status', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
515
516END
517
518GO
519
520IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'med_rpt_unote_acs_type') BEGIN
521
522     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
523     VALUES ('med_rpt_unote_acs_type', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
524
525END
526
527GO
528
529IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'med_schedule_param') BEGIN
530
531     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
532     VALUES ('med_schedule_param', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
533
534END
535
536GO
537
538IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'MED_SESSION_PAYMENT_SUMMARY') BEGIN
539
540     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
541     VALUES ('MED_SESSION_PAYMENT_SUMMARY', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
542
543END
544
545GO
546
547IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'med_unicode_numbers') BEGIN
548
549     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
550     VALUES ('med_unicode_numbers', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
551
552END
553
554GO
555
556IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'module_versions') BEGIN
557
558     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
559     VALUES ('module_versions', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
560
561END
562
563GO
564
565IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'nt_attempts') BEGIN
566
567     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
568     VALUES ('nt_attempts', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
569
570END
571
572GO
573
574IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'payment_processor') BEGIN
575
576     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
577     VALUES ('payment_processor', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
578
579END
580
581GO
582
583IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'ppt_fp_webrqst_api_url') BEGIN
584
585     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
586     VALUES ('ppt_fp_webrqst_api_url', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
587
588END
589
590GO
591
592IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'PPTDesign_TimeStamp') BEGIN
593
594     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
595     VALUES ('PPTDesign_TimeStamp', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
596
597END
598
599GO
600
601IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'project_properties') BEGIN
602
603     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
604     VALUES ('project_properties', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
605
606END
607
608GO
609
610IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'pt_processor_terminals') BEGIN
611
612     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
613     VALUES ('pt_processor_terminals', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
614
615END
616
617GO
618
619IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'register_map_terminal') BEGIN
620
621     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
622     VALUES ('register_map_terminal', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
623
624END
625
626GO
627
628IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'runsql_info') BEGIN
629
630     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
631     VALUES ('runsql_info', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
632
633END
634
635GO
636
637IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'saved_report_dtl') BEGIN
638
639     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
640     VALUES ('saved_report_dtl', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
641
642END
643
644GO
645
646IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'smart_api') BEGIN
647
648     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
649     VALUES ('smart_api', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
650
651END
652
653GO
654
655IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'smart_api_attributes') BEGIN
656
657     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
658     VALUES ('smart_api_attributes', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
659
660END
661
662GO
663
664IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'smart_api_audit_log') BEGIN
665
666     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
667     VALUES ('smart_api_audit_log', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
668
669END
670
671GO
672
673IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'smart_api_file_prop') BEGIN
674
675     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
676     VALUES ('smart_api_file_prop', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
677
678END
679
680GO
681
682IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'smart_api_permissions') BEGIN
683
684     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
685     VALUES ('smart_api_permissions', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
686
687END
688
689GO
690
691IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'smart_api_resources') BEGIN
692
693     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
694     VALUES ('smart_api_resources', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
695
696END
697
698GO
699
700IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'smart_api_save') BEGIN
701
702     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
703     VALUES ('smart_api_save', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
704
705END
706
707GO
708
709IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'smart_api_save_qry') BEGIN
710
711     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
712     VALUES ('smart_api_save_qry', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
713
714END
715
716GO
717
718IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'smart_api_segment') BEGIN
719
720     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
721     VALUES ('smart_api_segment', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
722
723END
724
725GO
726
727IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'smart_report_list') BEGIN
728
729     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
730     VALUES ('smart_report_list', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
731
732END
733
734GO
735
736IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'sr_advance_options_params_dtl') BEGIN
737
738     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
739     VALUES ('sr_advance_options_params_dtl', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
740
741END
742
743GO
744
745IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'sr_api_sync') BEGIN
746
747     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
748     VALUES ('sr_api_sync', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
749
750END
751
752GO
753
754IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'sr_audit_login') BEGIN
755
756     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
757     VALUES ('sr_audit_login', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
758
759END
760
761GO
762
763IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'sr_audit_service') BEGIN
764
765     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
766     VALUES ('sr_audit_service', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
767
768END
769
770GO
771
772IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'SR_CATEGORY_LINK') BEGIN
773
774     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
775     VALUES ('SR_CATEGORY_LINK', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
776
777END
778
779GO
780
781IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'sr_filter_list') BEGIN
782
783     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
784     VALUES ('sr_filter_list', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
785
786END
787
788GO
789
790IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'sr_properties') BEGIN
791
792     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
793     VALUES ('sr_properties', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
794
795END
796
797GO
798
799IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'sr_report_alias') BEGIN
800
801     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
802     VALUES ('sr_report_alias', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
803
804END
805
806GO
807
808IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'sr_report_base') BEGIN
809
810     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
811     VALUES ('sr_report_base', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
812
813END
814
815GO
816
817IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'sr_report_buttons') BEGIN
818
819     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
820     VALUES ('sr_report_buttons', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
821
822END
823
824GO
825
826IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'sr_report_field') BEGIN
827
828     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
829     VALUES ('sr_report_field', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
830
831END
832
833GO
834
835IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'sr_report_index') BEGIN
836
837     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
838     VALUES ('sr_report_index', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
839
840END
841
842GO
843
844IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'sr_report_props') BEGIN
845
846     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
847     VALUES ('sr_report_props', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
848
849END
850
851GO
852
853IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'sr_report_search') BEGIN
854
855     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
856     VALUES ('sr_report_search', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
857
858END
859
860GO
861
862IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'sr_report_settings') BEGIN
863
864     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
865     VALUES ('sr_report_settings', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
866
867END
868
869GO
870
871IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'sr_schedule_properties') BEGIN
872
873     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
874     VALUES ('sr_schedule_properties', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
875
876END
877
878GO
879
880IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'sr_schedule_templete') BEGIN
881
882     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
883     VALUES ('sr_schedule_templete', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
884
885END
886
887GO
888
889IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'sr_showhide_conf') BEGIN
890
891     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
892     VALUES ('sr_showhide_conf', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
893
894END
895
896GO
897
898IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'tax_formula') BEGIN
899
900     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
901     VALUES ('tax_formula', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
902
903END
904
905GO
906
907IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'TBL_PK_VALIDATION_RESULT') BEGIN
908
909     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
910     VALUES ('TBL_PK_VALIDATION_RESULT', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
911
912END
913
914GO
915
916IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'temp_catalog_item_master') BEGIN
917
918     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
919     VALUES ('temp_catalog_item_master', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
920
921END
922
923GO
924
925IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'temp_catalog_mfr_mast') BEGIN
926
927     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
928     VALUES ('temp_catalog_mfr_mast', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
929
930END
931
932GO
933
934IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'TEMP_PENDINGADJUST') BEGIN
935
936     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
937     VALUES ('TEMP_PENDINGADJUST', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
938
939END
940
941GO
942
943IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'test_table_for_cp') BEGIN
944
945     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
946     VALUES ('test_table_for_cp', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
947
948END
949
950GO
951
952IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'tfa_preferences') BEGIN
953
954     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
955     VALUES ('tfa_preferences', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
956
957END
958
959GO
960
961IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'timezone_master') BEGIN
962
963     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
964     VALUES ('timezone_master', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
965
966END
967
968GO
969
970IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'TRACDLLLog') BEGIN
971
972     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
973     VALUES ('TRACDLLLog', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
974
975END
976
977GO
978
979IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'tran_profile_hdr') BEGIN
980
981     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
982     VALUES ('tran_profile_hdr', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
983
984END
985
986GO
987
988IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'tran_profile_map') BEGIN
989
990     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
991     VALUES ('tran_profile_map', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
992
993END
994
995GO
996
997IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'tran_user_profile') BEGIN
998
999     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
1000     VALUES ('tran_user_profile', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
1001
1002END
1003
1004GO
1005
1006IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'truepos_smartmfw_config_map') BEGIN
1007
1008     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
1009     VALUES ('truepos_smartmfw_config_map', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
1010
1011END
1012
1013GO
1014
1015IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'UI_LAYOUTS') BEGIN
1016
1017     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
1018     VALUES ('UI_LAYOUTS', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
1019
1020END
1021
1022GO
1023
1024IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'Update_Column_Details') BEGIN
1025
1026     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
1027     VALUES ('Update_Column_Details', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
1028
1029END
1030
1031GO
1032
1033IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'weborder_file_import') BEGIN
1034
1035     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
1036     VALUES ('weborder_file_import', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
1037
1038END
1039
1040GO
1041
1042IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'weborder_file_types') BEGIN
1043
1044     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
1045     VALUES ('weborder_file_types', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
1046
1047END
1048
1049GO
1050
1051IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'webreporter_login_info') BEGIN
1052
1053     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
1054     VALUES ('webreporter_login_info', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
1055
1056END
1057
1058GO
1059
1060IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'wnow_context_index') BEGIN
1061
1062     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
1063     VALUES ('wnow_context_index', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
1064
1065END
1066
1067GO
1068
1069IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'wnow_query_dtl') BEGIN
1070
1071     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
1072     VALUES ('wnow_query_dtl', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
1073
1074END
1075
1076GO
1077
1078IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'wnow_query_hdr') BEGIN
1079
1080     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
1081     VALUES ('wnow_query_hdr', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
1082
1083END
1084
1085GO
1086
1087IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'wo_function_key') BEGIN
1088
1089     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
1090     VALUES ('wo_function_key', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
1091
1092END
1093
1094GO
1095
1096IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'wo_procedure_value') BEGIN
1097
1098     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
1099     VALUES ('wo_procedure_value', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
1100
1101END
1102
1103GO
1104
1105IF NOT EXISTS (SELECT [CEL_TABLE_NAME] FROM [dbo].[CONNECT_EXTABLE_LIST] WHERE [CEL_TABLE_NAME] = 'wr_menu_master') BEGIN
1106
1107     INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON], [CEL_EXCLUDED_DATE])
1108     VALUES ('wr_menu_master', 'PRAGALATHAN P', 'This is excluded for first time', '20180102')
1109
1110END
1111
1112GO
1113
1114
1115INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON]) VALUES ('sam_employee_sync','PRAGALATHAN P', 'This is excluded for first time')
1116GO
1117INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON]) VALUES ('sr_adv_opt_params_dtl','PRAGALATHAN P', 'This is excluded for first time')
1118GO
1119INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON]) VALUES ('sr_report_audit','PRAGALATHAN P', 'This is excluded for first time')
1120GO
1121INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON]) VALUES ('sr_user_favrpts','PRAGALATHAN P', 'This is excluded for first time')
1122GO
1123INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON]) VALUES ('med_report_usernote_dtl','PRAGALATHAN P', 'This is excluded for first time')
1124GO
1125INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON]) VALUES ('med_report_schedule','PRAGALATHAN P', 'This is excluded for first time')
1126GO
1127INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON]) VALUES ('med_rep_schedule_audit','PRAGALATHAN P', 'This is excluded for first time')
1128GO
1129INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON]) VALUES ('sr_report_schedule','PRAGALATHAN P', 'This is excluded for first time')
1130GO
1131INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON]) VALUES ('med_report_disp_config','PRAGALATHAN P', 'This is excluded for first time')
1132GO
1133INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON]) VALUES ('med_user_recentrpts','PRAGALATHAN P', 'This is excluded for first time')
1134GO
1135INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON]) VALUES ('sr_related_report','PRAGALATHAN P', 'This is excluded for first time')
1136GO
1137INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON]) VALUES ('med_pivot_reports','PRAGALATHAN P', 'This is excluded for first time')
1138GO
1139INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON]) VALUES ('sr_report_function_keys','PRAGALATHAN P', 'This is excluded for first time')
1140GO
1141INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON]) VALUES ('sr_report_filter','PRAGALATHAN P', 'This is excluded for first time')
1142GO
1143INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON]) VALUES ('sr_lov_config','PRAGALATHAN P', 'This is excluded for first time')
1144GO
1145INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON]) VALUES ('sr_user_search','PRAGALATHAN P', 'This is excluded for first time')
1146GO
1147INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON]) VALUES ('send_report_audit_dtl','PRAGALATHAN P', 'This is excluded for first time')
1148GO
1149INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON]) VALUES ('med_report_config','PRAGALATHAN P', 'This is excluded for first time')
1150GO
1151INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON]) VALUES ('rsm_employee_dtl','PRAGALATHAN P', 'This is excluded for first time')
1152GO
1153INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON]) VALUES ('custom_report_audit_dtl','PRAGALATHAN P', 'This is excluded for first time')
1154GO
1155INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON]) VALUES ('med_report_unote_type','PRAGALATHAN P', 'This is excluded for first time')
1156GO
1157INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON]) VALUES ('Tmp_ForignKey_Tbl_Cols','PRAGALATHAN P', 'This is excluded for first time')
1158GO
1159INSERT INTO [dbo].[CONNECT_EXTABLE_LIST] ([CEL_TABLE_NAME], [CEL_EXCLUDED_BY], [CEL_EXCLUDED_REASON]) VALUES ('sr_report_disp_config','PRAGALATHAN P', 'This is excluded for first time')
1160GO
1161
1162
1163
1164Update connect_table_list set CTL_IS_INDEX =1 where ctl_timestamp_col ='timestamp'
1165GO